#!#! #! #!#! #!#! #!#! #!#! #!#! #!#! #!#! #!#! #!#! #! #!#!#!#!#!#!#!#!#!#!#!#!#!#! #!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!FeatureTypes:,WFS_HTTP_USER_AGENT,"OPTIONAL TEXT",WFSHTTPUser-Agent:,WFS_MAX_RESULT_FEATURES,"OPTIONAL INTEGER",WFSMaxFeatures:,WFS_ADD_NAMESPACE_PREFIX_TO_NAMES,"OPTIONAL LOOKUP_CHOICE ""Feature Types"",FEATURE_TYPES%""Feature Types and Attributes"",FEATURE_TYPES_AND_ATTRIBUTES",WFSAddXMLNamespacePrefixto:,WFS_MAP_GEOMETRY_COLUMNS,"OPTIONAL CHECKBOX YES%NO",WFSMapGeometryColumns,WFS_MAX_MULTI_LIST_LEVEL,"OPTIONAL CHOICE 0%1%2%3%4%5%6%7%8%9%10%11%12%13%14%15%16%17%18%19%20",WFSLimitNumberofListsinNestedAttributes:,WFS_ENFORCE_PATH_CONTINUITY_BY,"OPTIONAL LOOKUP_CHOICE ""Snapping End Points"",SNAPPING_END_POINTS%""Inserting New Segment"",INSERTING_NEW_SEGMENT",WFSEnforcePathContinuityBy:,WFS_DISABLE_AUTOMATIC_READER_TYPE_SELECTION,"OPTIONAL CHECKBOX YES%NO",WFSDisableAutomaticReaderTypeSelection,WFS_EXPOSE_ATTRS_GROUP,"OPTIONAL DISCLOSUREGROUP WFS_EXPOSE_FORMAT_ATTRS",WFSSchemaAttributes,WFS_PREFER_DATASET_URL,"OPTIONAL CHECKBOX Yes%No",WFSPreferDatasetURL:,WFS_MAP_PREDEFINED_GML_PROPERTIES,"OPTIONAL CHECKBOX YES%NO",WFSMapPredefinedProperties,WFS_USE_OLD_READER,"OPTIONAL CHECKBOX YES%NO",WFSUseOldReaderforGMLv3.1.1andv2.1.2Documents,WFS_GML_FEATURE_PROPERTIES_ATTRIBUTE_HANDLING_GROUP,"OPTIONAL DISCLOSUREGROUP MAP_COMPLEX_PROPERTIES_AS%MAX_MULTI_LIST_LEVEL%XML_FRAGMENTS_AS_DOCUMENTS%FLATTEN_XML_FRAGMENTS",WFSGMLFeatureProperties-AttributeHandling,WFS_XML_FRAGMENTS_AS_DOCUMENTS,"OPTIONAL CHECKBOX YES%NO",WFSIncludeXMLDeclarationinXMLFragments,WFS_MAP_COMPLEX_PROPERTIES_AS,"OPTIONAL ACTIVECHOICE ""Nested Attributes""%""XML Fragments"",MAX_MULTI_LIST_LEVEL",WFSMapComplexPropertiesas:,WFS_QNAMES_FOR_PROPERTIES_TO_IGNORE,"OPTIONAL TEXT_EDIT_XML_ENCODED",WFSPropertiestoIgnore:,WFS_LOCAL_CACHE_EXPIRY,"OPTIONAL INTEGER",WFSLocalCacheExpiryminutes:,WFS_FLATTEN_XML_FRAGMENTS,"OPTIONAL ACTIVEDISCLOSUREGROUP FLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE%FLATTEN_XML_FRAGMENTS_CLOSE_LIST_BRACE%FLATTEN_XML_FRAGMENTS_SEPARATOR",WFSFlattenXMLFragments,WFS_CONNECTION_PROPERTIES_GROUP,"OPTIONAL DISCLOSUREGROUP PREFER_POST%HTTP_USER_AGENT%CONNECTION_TIMEOUT%TRANSFER_TIMEOUT",WFSConnectionProperties,WFS_PREFERRED_VERSION,"OPTIONAL ACTIVECHOICE 1.0.0,START_INDEX,COUNT%1.1.0,START_INDEX,COUNT%2.0.0",WFSWFSVersion:,WFS_TRANSFER_TIMEOUT,"OPTIONAL RANGE_SLIDER 1%MAX%0",WFSTransferTimeoutLengthseconds:,WFS_PREFER_POST,"OPTIONAL CHECKBOX Yes%No",WFSPreferHTTPPostifAvailable:,WFS_WFS_EXPOSE_FORMAT_ATTRS,"OPTIONAL LITERAL EXPOSED_ATTRS WFS%Source",WFSAdditionalAttributestoExpose:,WFS_DISABLE_XML_NAMESPACE_PROCESSING,"OPTIONAL CHECKBOX YES%NO",WFSDisableXMLNamespaceProcessing,WFS_MAP_EMBEDDED_OBJECTS_AS,"OPTIONAL LOOKUP_CHOICE ""Attributes"",ATTRIBUTES%""Geometries"",GEOMETRIES%""Feature Types"",FEATURE_TYPES",WFSMapEmbeddedObjectsas:,WFS_CONNECTION_TIMEOUT,"OPTIONAL RANGE_SLIDER 1%MAX%0",WFSConnectionTimeoutLengthseconds:,WFS_FILTER_EXPRESSION,"OPTIONAL TEXT_EDIT__ENCODED",WFSXMLFilterExpression:,WFS_GML_READER_GROUP,"OPTIONAL DISCLOSUREGROUP USE_OLD_READER%DISABLE_AUTOMATIC_READER_TYPE_SELECTION%DISABLE_XML_NAMESPACE_PROCESSING",WFSGMLVersionandNamespace,WFS_USE_SEARCH_ENVELOPE,"OPTIONAL ACTIVEDISCLOSUREGROUP SEARCH_ENVELOPE_MINX%SEARCH_ENVELOPE_MINY%SEARCH_ENVELOPE_MAXX%SEARCH_ENVELOPE_MAXY%CLIP_TO_ENVELOPE%BBOX_COORDINATE_SYSTEM",WFSUseSearchEnvelope,WFS_NETWORK_AUTHENTICATION,"OPTIONAL AUTHENTICATOR CONTAINER%ACTIVEDISCLOSUREGROUP%CONTAINER_TITLE%Use Network Authentication%PROMPT_TYPE%NETWORK",WFSUseNetworkAuthentication,WFS_XSD_DOC,"OPTIONAL FILE_OR_URL GML_Schema_File(*.xsd)|*.xsd|All_Files(*)|*",WFSApplicationSchema:,WFS_SRS_AXIS_ORDER,"OPTIONAL CHOICE 1,2%2,1%1,2,3%2,1,3",WFSGMLSRSAxisOrder:,WFS_MAP_FEATURE_COLLECTION,"OPTIONAL LOOKUP_LISTBOX gml:FeatureCollection,gml%wfs:FeatureCollection,wfs",WFSMapFeatureCollection:,WFS_FME_FEATURE_IDENTIFIER,"OPTIONAL WFS_NUMERIC_IDENTIFIER $[DATASET],LAYER_LIST_ONLY,YES,LAYER_LIST_ONLY_INCLUDE_ATTRIBUTES,YES,HTTP_AUTH_USER,$[HTTP_AUTH_USER],HTTP_AUTH_PASSWORD,$[HTTP_AUTH_PASSWORD],HTTP_AUTH_METHOD,$[HTTP_AUTH_METHOD],HTTP_PROXY,$[HTTP_PROXY],HTTP_PROXY_PORT,$[HTTP_PROXY_PORT],HTTP_PROXY_USER,$[HTTP_PROXY_USER],HTTP_PROXY_PASSWORD,$[HTTP_PROXY_PASSWORD],HTTP_PROXY_AUTH_METHOD,$[HTTP_PROXY_AUTH_METHOD]",WFSNumericIdentifierAttribute:,WFS_ARCGIS_CACHE_GROUP,"OPTIONAL DISCLOSUREGROUP LOCAL_CACHE_EXPIRY",WFSArcGISCacheExpiry,WFS_OUTPUT_FORMAT,"OPTIONAL STRING_OR_CHOICE",WFSWFSOutputFormat:,WFS_GMLSRS_GEOMETRY_PARAMETERS,"OPTIONAL DISCLOSUREGROUP SRS_AXIS_ORDER%SRS_ANGLE_DIRECTION%ENFORCE_PATH_CONTINUITY_BY",WFSGMLSRSGeometryParameters,WFS_SRS_ANGLE_DIRECTION,"OPTIONAL LOOKUP_CHOICE Counterclockwise,CCW%Clockwise,CW",WFSGMLSRSAngleDirection:,WFS_IGNORE_APPLICATON_SCHEMA,"OPTIONAL ACTIVECHOICE no,GML_FEATURE_ELEMENTS%yes,XSD_DOC,FME_FEATURE_IDENTIFIER,MAP_FEATURE_COLLECTION,GML_FEATURE_PROPERTIES,GML_FEATURE_PROPERTIES_ATTRIBUTE_HANDLING_GROUP,GML_READER_GROUP",WFSIgnoreApplicationSchema:,WFS_GML_FEATURE_PROPERTIES,"OPTIONAL DISCLOSUREGROUP MAP_EMBEDDED_OBJECTS_AS%MAP_PREDEFINED_GML_PROPERTIES%MAP_GEOMETRY_COLUMNS%ADD_NAMESPACE_PREFIX_TO_NAMES%QNAMES_FOR_PROPERTIES_TO_IGNORE",WFSGMLFeatureProperties">#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#! #!#!#!#!#!#!#!#!#!#!#!#!#!#!#!LowerCaseAttributeNames:,POSTGIS_START_TRANSACTION,"OPTIONAL TEXT",POSTGISStartingFeature:,POSTGIS_NAMED_CONNECTION,"IGNORE TEXT",POSTGISConnection:,POSTGIS_SPATIAL_COLUMN_NAME,"OPTIONAL TEXT",POSTGISSpatialColumn:,POSTGIS_BULK_COPY,"OPTIONAL CHOICE YES%NO",POSTGISBulkInsert,POSTGIS_BEGIN_SQL,"OPTIONAL TEXT_EDIT_SQL_CFG_ENCODED MODE,SQL;FORMAT,POSTGIS",POSTGISSQLToRunBeforeWrite,POSTGIS_TRANSACTION_INTERVAL,"OPTIONAL TEXT",POSTGISFeaturesPerTransaction,POSTGIS_SPATIAL_COLUMN_TYPE,"OPTIONAL LOOKUP_CHOICE geometry%geography",POSTGISSpatialColumnType:,POSTGIS_ADVANCED,"OPTIONAL DISCLOSUREGROUP BULK_COPY%INSERT_TEXT_GEOMETRY%START_TRANSACTION%TRANSACTION_INTERVAL%BEGIN_SQL%END_SQL",POSTGISAdvanced,POSTGIS_COORDINATE_SYSTEM_GRANULARITY,"OPTIONAL NO_EDIT TEXT",POSTGIS,POSTGIS_END_SQL,"OPTIONAL TEXT_EDIT_SQL_CFG_ENCODED MODE,SQL;FORMAT,POSTGIS",POSTGISSQLToRunAfterWrite,POSTGIS_INSERT_TEXT_GEOMETRY,"OPTIONAL CHOICE YES%NO",POSTGISInsertWKT,POSTGIS_STRICT_TEMPORAL_TYPE_HANDLING,"OPTIONAL NO_EDIT TEXT",POSTGIS,POSTGIS_GENERIC_GEOMETRY,"OPTIONAL CHECKBOX yes%no",POSTGISCreateGenericSpatialColumns:">#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#! #!#!#!#!#! #!#! #!#! #!#! #!#!FME_PYTHON_VERSION 27 #! START_HEADER #! START_WB_HEADER READER_TYPE MULTI_READER WRITER_TYPE NULL WRITER_KEYWORD NULL_DEST NULL_DEST_DATASET null #! END_WB_HEADER #! START_WB_HEADER #! END_WB_HEADER #! END_HEADER LOG_FILENAME "$(FME_MF_DIR)Wfs2PostGis(2018.1).log" LOG_APPEND NO LOG_TIMINGS YES LOG_FILTER_MASK -1 LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME Wfs2PostGis(2018.1) MACRO FME_VIEWER_APP fmedatainspector DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- Tcl2 proc Creator_CoordSysRemover {} { global FME_CoordSys; set FME_CoordSys {}; } MACRO Creator_XML NOT_ACTIVATED MACRO Creator_CLASSIC NOT_ACTIVATED MACRO Creator_2D3D 2D_GEOMETRY MACRO Creator_COORDS 包括(如果{{几何对象}= ={几何Object} } { puts {MACRO Creator_XML *} } ] INCLUDE [ if { {Geometry Object} == {2D Coordinate List} } { puts {MACRO Creator_2D3D 2D_GEOMETRY}; puts {MACRO Creator_CLASSIC *} } ] INCLUDE [ if { {Geometry Object} == {3D Coordinate List} } { puts {MACRO Creator_2D3D 3D_GEOMETRY}; puts {MACRO Creator_CLASSIC *} } ] INCLUDE [ if { {Geometry Object} == {2D Min/Max Box} } { set comment { We need to turn the COORDS which are minX minY maxX maxY into a full polygon list of coordinates }; set splitCoords [split [string trim { }]];if {[llength $ splitcoords]> 4} {set trimmedcoords {};foreach项目$ splastcoords {如果{$项目!= {}} {lappend trimmedcoords $ Item}};设置splitcoords $ trimmedcoords;};if {[llength $ splitcoords]!= 4} {错误{creator:坐标列表预计将是四个数字的空间分隔列表,为“minx miny maxx maxy” - ` ' is invalid}; }; set minX [lindex $splitCoords 0]; set minY [lindex $splitCoords 1]; set maxX [lindex $splitCoords 2]; set maxY [lindex $splitCoords 3]; puts "MACRO Creator_COORDS $minX $minY $minX $maxY $maxX $maxY $maxX $minY $minX $minY"; puts {MACRO Creator_2D3D 2D_GEOMETRY}; puts {MACRO Creator_CLASSIC *} } ] FACTORY_DEF $(Creator_XML) CreationFactory FACTORY_NAME Creator_XML_Creator CREATE_AT_END no OUTPUT FEATURE_TYPE _____CREATED______ @Geometry(FROM_ENCODED_STRING, ?xml version= 1.0 编码= US_ASCII 独立= no ? 地质etry 尺寸= 2 null 地质etry )FACTORY_DEF $(Creator_CLASSIC)CreationFactory FACTORY_NAME Creator_CLASSIC_Creator $(Creator_2D3D)$(Creator_COORDS)CREATE_AT_END无输出FEATURE_TYPE _____CREATED______ FACTORY_DEF * TeeFactory FACTORY_NAME Creator_Cloner INPUT FEATURE_TYPE _____CREATED______ @ TCL2(Creator_CoordSysRemover)@CoordSys()NUMBER_OF_COPIES 1 OUTPUT FEATURE_TYPE Creator_CREATED fme_feature_type造物主FACTORY_DEF * BranchingFactory FACTORY_NAME“creator_created brancher -1 4”输入feature_type creator_created target_factory“$(wb_current_context)_creator_branch_target”maximum_count none输出传递Feature_type *#------------------------------------------------------------------------------------------------------------------------teefactory factory_name“$(wb_current_context)_creator_branch_target”输入feature_type *输出功能_type *#----------------------------------------------------------------------------------------------------------------------宏观团,但是map_geometry_columns的map_geometry_polumns,yes,enforce_path_continity_by,snaping_end_points,disable_automatic_reader_type_selection,no,preplet_dataset_url,no,map_predefined_gml_properties,no,dudd_ord_reader,no,xml_fragments_as_documents,yes,map_complex_properties_as,嵌套 Attributes,LOCAL_CACHE_EXPIRY,60,FLATTEN_XML_FRAGMENTS,NO,CONNECTION_PROPERTIES_GROUP,NO,PREFERRED_VERSION,1.1.0,TRANSFER_TIMEOUT,90,PREFER_POST,No,DISABLE_XML_NAMESPACE_PROCESSING,NO,MAP_EMBEDDED_OBJECTS_AS,ATTRIBUTES,CONNECTION_TIMEOUT,90,USE_SEARCH_ENVELOPE,NO,IGNORE_APPLICATON_SCHEMA,no # Always provide an INTERACTION, otherwise the factory defaults to ENVELOPE_INTERSECTS INCLUDE [if { ( {NONE} == { } ) || ( {($INTERACT_OPTIONS)} == {} ) } { puts {MACRO FCTQUERY_INTERACTION_LINE FCTQUERY_INTERACTION NONE}; } else { puts {MACRO FCTQUERY_INTERACTION_LINE FCTQUERY_INTERACTION "NONE"}; } ] # Consolidate the attribute merge options to what the factory expects DEFAULT_MACRO FeatureReader_COMBINE_ATTRS INCLUDE [ if { {RESULT_ONLY} == {MERGE} } { puts "MACRO FeatureReader_COMBINE_ATTRS "; } else { puts "MACRO FeatureReader_COMBINE_ATTRS RESULT_ONLY"; }; ] INCLUDE [ puts {DEFAULT_MACRO FeatureReaderDataset_FeatureReader http: api.vicroads.vic.gov.au. vicroads. wfs?SERVICE=WFS VERSION=1.1.0 请求= getCapability. AUTH=eyJraWQiOiJRRFFQWDZVSDlQRExOOU9GQVowMlNFRFVYIiwic3R0IjoiYWNjZXNzIiwiYWxnIjoiSFMyNTYifQ.eyJqdGkiOiJuUzRMM0MzSURvdzRsakNNc3R2Y0IiLCJpYXQiOjE0OTE1Mzg2NDQsImlzcyI6Imh0dHBzOi8vYXBpLnN0b3JtcGF0aC5jb20vdjEvYXBwbGljYXRpb25zLzRBeTd5RjJtUUNpQlpxUHo5Q3lRVTgiLCJzdWIiOiJodHRwczovL2FwaS5zdG9ybXBhdGguY29tL3YxL2FjY291bnRzL20xckJyQ1BGMXJCREdVUG9oN2gxZiIsImV4cCI6MTU1NDYxMDY0NH0.9NmwBbkw_5pe_0LRaPENBCBo3j6KsPY-V2OR7Qq1rOw}; ] FACTORY_DEF * QueryFactory FACTORY_NAME FeatureReader INPUT FEATURE_TYPE Creator_CREATED $(FCTQUERY_INTERACTION_LINE) COMBINE_ATTRIBUTES $(FeatureReader_COMBINE_ATTRS) QUERYFCT_ATTRIBUTE_PREFIX COMBINE_GEOMETRY RESULT_ONLY ENABLE_CACHE NO QUERYFCT_TABLE_SEPARATOR SPACE READER_TYPE WFS READER_DATASET "$(FeatureReaderDataset_FeatureReader)" QUERYFCT_IDS "rwe_line rwe_point“reader_directives meta_macros,sourceprefer_dataset_url No sourcepreferred_version. 1.1.0 SourceCONNECTION_PROPERTIES_GROUP NO sourceprefer_post. No SourceHTTP_USER_AGENT SourceCONNECTION_TIMEOUT 90. SourceTRANSFER_TIMEOUT 90. SourceMAX_RESULT_FEATURES SourceSTART_INDEX 没用过 SourceCOUNT 没用过 SourceOUTPUT_FORMAT SourceFILTER_EXPRESSION SourceIGNORE_APPLICATON_SCHEMA no SourceXSD_DOC sourcefme_feature_identifier SourceMAP_FEATURE_COLLECTION SourceGML_FEATURE_ELEMENTS 没用过 sourcegmlsrs_geometry_parameters. SourceSRS_AXIS_ORDER sourcesrs_angle_direction. SourceENFORCE_PATH_CONTINUITY_BY snaping_end_points. SourceGML_READER_GROUP SourceUSE_OLD_READER NO SourceDISABLE_AUTOMATIC_READER_TYPE_SELECTION NO SourceDISABLE_XML_NAMESPACE_PROCESSING NO SourceGML_FEATURE_PROPERTIES SourceMAP_EMBEDDED_OBJECTS_AS ATTRIBUTES sourcemap_predefined_gml_properties. NO sourcemap_geometry_columns. 是的 SourceADD_NAMESPACE_PREFIX_TO_NAMES sourceqnames_for_properties_to_ignore. sourcegml_feature_properties_attribute_handling_group. sourcemap_complex_properties_as. Nested Attributes SourceMAX_MULTI_LIST_LEVEL sourcexml_fragments_as_documents. 是的 SourceFLATTEN_XML_FRAGMENTS NO SourceFLATTEN_XML_FRAGMENTS_OPEN_LIST_BRACE sourceflatten_xml_fragments_close_list_brace. SourceFLATTEN_XML_FRAGMENTS_SEPARATOR SourceARCGIS_CACHE_GROUP SourceLOCAL_CACHE_EXPIRY 60. SourceEXPOSE_ATTRS_GROUP SourceWFS_EXPOSE_FORMAT_ATTRS SourceUSE_SEARCH_ENVELOPE NO sourcearch_envelope_minx. 0 sourcearch_envelope_mine. 0 SourceSEARCH_ENVELOPE_MAXX 0 SourceSEARCH_ENVELOPE_MAXY 0 sourceclip_to_envelope. NO sourcebbox_coording_system. SourceNETWORK_AUTHENTICATION ,metafile,wfs queryfct_output _on_reader_error yes queryfct_result_tags $(featurerereader_output_ports_encoded)queryfct_set_fme_feature_type yes reader_params_wwjd $(featurerereder_directives)treat_reader_param_ampersands_as_literals是输出结果feature_type featurereader_ OUTPUT SCHEMA FEATURE_TYPE FeatureReader_ # ------------------------------------------------------------------------- INCLUDE [ puts {DEFAULT_MACRO FeatureWriterDataset_FeatureWriter localhost.test}; ] FACTORY_DEF * WriterFactory FACTORY_NAME FeatureWriter WRITER_TYPE POSTGIS WRITER_DATASET "$(FeatureWriterDataset_FeatureWriter)" WRITER_SETTINGS RUNTIME_MACROS,STRICT_TEMPORAL_TYPE_HANDLING 是的 named_connection. localhost.test SPATIAL_COLUMN_TYPE 地质etry spatial_column_name. the_geom. GENERIC_GEOMETRY no LOWERCASE_ATTRIBUTE_NAMES 是的 conorde_system_granularity. feature_type. ADVANCED FME_DISCLOSURE_OPEN BULK_COPY 是的 start_transaction. 0 transaction_interval. 1000 插入_text_geometry. NO begin_sql. end_sql. ,METAFILE,POSTGIS WRITER_METAFILE ATTRIBUTE_CASE,LOWER,ATTRIBUTE_INVALID_CHARS,. %-# !?* + ,ATTRIBUTE_LENGTH,63,ATTR_TYPE_MAP,bool fme_boolean. char width fme_char width varchar. width fme_varchar width 文本 FME_BUFFER. xml fme_xml 杰森 fme_json 杰森b fme_json bytea fme_binarybuffer bytea fme_varbinary width bytea fme_binary width int2 fme_int16 int2 fme_int8. int2 FME_UINT8. int4 fme_int32 int4 FME_UINT16 int8 fme_int64. int8 fme_uint32 numeric width 十进制 fme_decimal width 十进制 numeric 20 0 fme_uint64. oid fme_uint32 serial fme_int32 float4 fme_real32. fme_real32. float8 fme_real64 date fme_date. 时间 fme_time 时间tz fme_time 时间stamp fme_date.时间 时间stamptz fme_date.时间 uuid FME_BUFFER. 少量 width fme_char width varbit FME_BUFFER. varbit width fme_varchar width ,DEST_ILLEGAL_ATTR_LIST,FME_DB_OPERATION fme_db_transaction. FME_FEATURE_OPERATION postgis_truncate_table. fme_table_handling. fme_selection_method. fme_match_columns. FME_WHERE_BUILDER_CLAUSE FME_MATCH_ID_ATTRIBUTE fme_match_revision_attribute. fme_update_geometry. POSTGIS_TYPE POSTGIS_MODE POSTGIS_SQL_KEY_COLUMNS postgis_geometry_column. POSTGIS_SPATIAL_COLUMN POSTGIS_DROP_TABLE POSTGIS_SPATIAL_COLUMN_TYPE POSTGIS_SRID POSTGIS_CREATE_WITH_OIDS postgis_create_gist_index. POSTGIS_VACUUM_ANALYZE postgis_allow_serial_writing. postgis_multi_geometry,feature_type_case,任何feature_type_invalid_chars, :?* | %# + ,FEATURE_TYPE_LENGTH,63,FEATURE_TYPE_LENGTH_INCLUDES_PREFIX,false,FEATURE_TYPE_RESERVED_WORDS,,FORMAT_METAFILE,$(FME_HOME_ENCODED)metafile POSTGIS.fmf,FORMAT_NAME,POSTGIS,GEOM_MAP,postgis_multipoint fme_point postgis_point. fme_point postgis_multilinestring fme_line postgis_multicurve. fme_line postgis_linestring fme_line postgis_multilinestring fme_line postgis_circularstring. fme_line postgis_compoundcurve fme_line postgis_multipolygon. fme_polygon postgis_multisurface fme_polygon postgis_polygon fme_polygon postgis_multipolygon. fme_polygon postgis_curvepolygon. fme_polygon postgis_multipolygon. fme_rectangle postgis_multipolygon. fme_rounded_rectangle postgis_multipoint fme_text postgis_multipolygon. fme_ellipse postgis_multilinestring fme_arc postgis_triangle. fme_polygon postgis_polyhedralsurface fme_surface postgis_polyhedralsurface fme_solid postgis_tin fme_surface postgis_none. fme_no_geom postgis_geometry fme_no_geom postgis_geometrycollection. fme_collection. postgis_multipolygon. fme_raster postgis_multipolygon. fme_point_cloud. postgis_none. fme_feature_table,READER_ATTR_INDEX_TYPES,BTree RTree 哈希 PrimaryKey,SOURCE,no,SUPPORTS_FEAT_TYPE_FANOUT,yes,SUPPORTS_MULTI_GEOM,no,WORKBENCH_CANNED_SCHEMA,,WRITER,POSTGIS,WRITER_ATTR_INDEX_TYPES,BTree RTree 哈希 PrimaryKey,WRITER_DEFLINE_PARMS, 吉伊 NAMEDGROUP fme_configuration_group fme_configuration_common_group.%fme_spatial_group%fme_advanced_group%oracle_advanced_group Table 吉伊 NAMEDGROUP fme_configuration_common_group. fme_feature_operation%fme_table_handling%oracle_model%fme_update_geometry%fme_selection_group%fme_table_creation_group 一般的 吉伊 ActiveChoice_lookup. fme_feature_operation Insert INSERT fme_update_geometry fme_selection_group%Update UPDATE ++fme_table_handling+USE_EXISTING ++ fme_selection_group + fme_disclosure_open%删除 DELETE ++fme_table_handling+USE_EXISTING fme_update_geometry ++fme_selection_group+FME_DISCLOSURE_OPEN fme_spatial_group fme_advanced_group Oracle_Sequences_cols% at Value openparen fme_db_operation closeparen MULTIPLE ++fme_table_handling+USE_EXISTING ++fme_selection_group+FME_DISCLOSURE_OPEN Feature Operation INSERT 吉伊 ActiveChoice_lookup. fme_table_handling Use space 现存的 USE_EXISTING fme_table_creation_group%create. space 如果 space 需要 create_if_missing%drop. space and space Create DROP_CREATE%Truncate space 现存的 truncate_existing. fme_table_creation_group. Table 处理 CREATE_IF_MISSING 吉伊 WHOLE_LINE LOOKUP_CHOICE fme_update_geometry 是的 是百分之不是 NO Update Spatial Column s 是的 吉伊 DISCLOSUREGROUP fme_selection_group fme_selection_method Row Selection 吉伊 WHOLE_LINE radioparametergroup. fme_selection_method fme_match_columns MATCH_COLUMNS%fme_where_builder_clause BUILDER Row Selection Method MATCH_COLUMNS 吉伊 WHOLE_LINE attrlist_commas. fme_match_columns Match Columns 吉伊 WHOLE_LINE 文本_EDIT_SQL_CFG_OR_ATTR fme_where_builder_clause MODE WHERE WHERE Clause 吉伊 DISCLOSUREGROUP fme_table_creation_group. postgis_create_with_oids.%postgis_create_gist_index Table 创建 Parameters 吉伊 CHOICE postgis_create_with_oids. 是的%NO Create OIDs NO 吉伊 CHOICE postgis_create_gist_index 是的%NO Create 要旨 Index 是的 吉伊 NAMEDGROUP fme_spatial_group postgis_spatial_column._type%postgis_spatial_column%postgis_srid Spatial 吉伊 LOOKUP_CHOICE postgis_spatial_column._type Geometry 地质etry%Geography geography Spatial Type 地质etry 吉伊 OPTIONAL WHOLE_LINE 文本 postgis_spatial_column. Spatial Column the_geom. 吉伊 OPTIONAL FLOAT postgis_srid Spatial Column SRID 吉伊 DISCLOSUREGROUP fme_advanced_group postgis_vacuum_analyze%postgis_allow_serial_writing 先进的 吉伊 CHOICE postgis_vacuum_analyze 是的%NO Vacuum Analyze Table NO 吉伊 CHOICE postgis_allow_serial_writing. 是的%NO 允许 Serial Column Writing NO,WRITER_DEF_LINE_TEMPLATE, FME_GEN_GROUP_NAME postgis_type. FME_GEN_GEOMETRY postgis_mode postgis_sql_key_columns. postgis_drop_table postgis_truncate_table. fme_feature_operation INSERT fme_table_handling CREATE_IF_MISSING fme_selection_method MATCH_COLUMNS fme_match_columns fme_where_builder_clause fme_update_geometry 是的 postgis_create_with_oids. NO postgis_create_gist_index 是的 postgis_spatial_column._type 地质etry postgis_spatial_column. 地质 postgis_srid postgis_vacuum_analyze no postgis_allow_serial_writing. NO,WRITER_FORMAT_PARAMETER,NETWORK_AUTHENTICATION NO network_proxy. NO ADVANCED_PARMS POSTGIS_IN_SCHEMAS_FOR_TABLE_LISTING DATASET_NAME 数据库 feature_type._NAME Table feature_type._DEFAULT_NAME Table1 supports_schema_in_feature_type_name. 是的 attribute_reading. DEFLINE_ATTRS attribute_reading._HISTORIC ALL ADVANCED_PARMS POSTGIS_IN_FEATURES_PER_FETCH POSTGIS_IN_BEGIN_SQL POSTGIS_IN_END_SQL POSTGIS_IN_SEARCH_METHOD POSTGIS_OUT_BULK_COPY postgis_out_insert_text_geometry. POSTGIS_OUT_TRANSACTION_INTERVAL POSTGIS_OUT_BEGIN_SQL POSTGIS_OUT_END_SQL ,WRITER_HAS_DEFLINE_ATTRS,yes WRITER_FEATURE_TYPES Value fme_feature_type. : Generic ,ftp_feature_type_name_exp, Value fme_feature_type. ,ftp_writer,POSTGIS,ftp_dynamic_schema,是的,ftp_dynamic_feature_type_name_type,DYN_SCHEMA_PROP_AUTO,ftp_dynamic_geometry_type,DYN_SCHEMA_PROP_AUTO,ftp_dynamic_schema_def_name_type,DYN_SCHEMA_PROP_AUTO,ftp_dynamic_schema_sources,SCHEMA_FROM_FIRST_FEATURE,ftp_attribute_source,2,ftp_format_parameters,fme_configuration_group fme_configuration_common_group. fme_feature_operation INSERT fme_table_handling DROP_CREATE fme_update_geometry lt 没用过 GT. fme_selection_group fme_selection_method lt 没用过 GT. fme_match_columns lt 没用过 GT. fme_where_builder_clause lt 没用过 GT. fme_table_creation_group. postgis_create_with_oids. NO postgis_create_gist_index 是的 fme_spatial_group postgis_spatial_column._type 地质etry postgis_spatial_column. the_geom. postgis_srid fme_advanced_group postgis_vacuum_analyze NO postgis_allow_serial_writing. NO WRITER_PARAMS LOWERCASE_ATTRIBUTE_NAMES,Yes,START_TRANSACTION,0,NAMED_CONNECTION,localhost.test,SPATIAL_COLUMN_NAME,the_geom,BULK_COPY,YES,TRANSACTION_INTERVAL,1000,SPATIAL_COLUMN_TYPE,geometry,ADVANCED,FME_DISCLOSURE_OPEN,COORDINATE_SYSTEM_GRANULARITY,FEATURE_TYPE,INSERT_TEXT_GEOMETRY,NO,STRICT_TEMPORAL_TYPE_HANDLING,Yes,GENERIC_GEOMETRY,no DATASET_ATTR _dataset FEATURE_TYPE_LIST_ATTR _feature_type TOTAL_FEATURES_WRITTEN_ATTR _total_features_written OUTPUT_PORTS "" INPUT Generic feature_type.FeatureReader_ @FeatureType(ENCODED,@EvaluateExpression(FDIV,STRING_ENCODED, Value fme_feature_type. ,FeatureWriter)) @SupplyAttributes(ENCODED,fme_template_feature_type, Generic ) INPUT Generic feature_type.FeatureReader_ @FeatureType(ENCODED,@EvaluateExpression(FDIV,STRING_ENCODED, Value fme_feature_type. ,FeatureWriter)) @SupplyAttributes(ENCODED,fme_template_feature_type, Generic )#---------------------------------------------------------------------- Factory_def * routingFactory factory_name“目标特征类型路由相关器”command_parm_evalization single_past __tnepe * feature_type_attribute __wb_out_feat_type___输出路由feature_type *输出not_routed feature_type__nuke_me__ @ tcl2(“fme_statmessage 818059 [fme_getattribute fme_template_feature_type] 818060 818061 fme_warn”)#-------------------------------------------------------------------- Factory_def * teefactory factory_name“最终输出nuker”输入feature_type __nuke_me__