# ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! 值 fme_db_operation ，多，++ fme_table_handling + USE_EXISTING，++ fme_selection_group + FME_DISCLOSURE_OPEN功能操作 “插入” GUI ACTIVECHOICE_LOOKUP fme_table_handling使用 现有的，USE_EXISTING，fme_table_creation_group％创建 如果 需要时，CREATE_IF_MISSING％的降幅 和 创建，DROP_CREATE％截断 现有的，TRUNCATE_EXISTING，fme_table_creation_group表处理 “CREATE_IF_MISSING ”GUI WHOLE_LINE LOOKUP_CHOICE fme_update_geometry是，YES％不，不更新空间列（S）“ 是 ”GUI可选DISCLOSUREGROUP fme_selection_group fme_selection_method行选择“ ”“” GUI可选WHOLE_LINE RADIOPARAMETERGROUP fme_selection_method fme_match_columns，MATCH_COLUMNS％fme_where_builder_clause,BUILDER Row Selection Method" MATCH_COLUMNS "GUI WHOLE_LINE ATTRLIST_COMMAS fme_match_columns \" \" Match Columns" "" "GUI WHOLE_LINE TEXT_EDIT_SQL_CFG_OR_ATTR fme_where_builder_clause MODE,WHERE WHERE Clause" "" "GUI OPTIONAL DISCLOSUREGROUP fme_table_creation_group postgis_create_with_oids%postgis_create_gist_index Table Creation Parameters" "" "GUI CHOICE postgis_create_with_oids YES%NO Create With OIDs" NO "GUI CHOICE postgis_create_gist_index YES%NO Create GiST Index" YES "GUI OPTIONAL NAMEDGROUP fme_spatial_group postgis_spatial_column_type%postgis_spatial_column%postgis_srid Spatial" "" "GUI LOOKUP_CHOICE postgis_spatial_column_type Geometry,geometry%Geography,geography Spatial Type" geometry "GUI OPTIONAL WHOLE_LINE TEXT postgis_spatial_column Spatial Column" geom "GUI OPTIONAL FLOAT postgis_srid Spatial Column SRID" "" "GUI OPTIONAL DISCLOSUREGROUP fme_advanced_group postgis_vacuum_analyze%postgis_allow_serial_writing Advanced" "" "GUI CHOICE postgis_vacuum_analyze YES%NO Vacuum Analyze Table" NO "GUI CHOICE postgis_allow_serial_writing YES%NO Allow Serial Column Writing" NO " #!ATTR_INDEX_TYPES = “B树RTREE散列的PrimaryKey” ＃！ATTR_NAME_INVALID_CHARS =”％ - ＃[] “！？（）*'＆+ \ /”！＃SUPPORTS_FEATURE_TYPE_FANOUT = “真”！＃启用= “真”！＃DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE = “真”！＃DATASET_TYPE = “数据库” ＃！GENERATE_FME_BUILD_NUM = “18295” ＃！COORDSYS = “” ＃！>＃！ # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # !

CSV：geoportal_user_docker [POSTGIS]

“＃！位置=” 2932.2920103473039 -1143.9517849829658" ＃！TOP_LEFT = “2932.2920103473039 -1143.9517849829658” ＃！BOTTOM_RIGHT = “3404.2920103473039 -1142.9517849829658” ＃！BOUNDING_RECT = “2932.2920103473039 -1143.9517849829658 472 -1” ＃！ORDER = “500000000000028” ＃！FOLLOW_ANCHOR= “真” ＃！INFO_NODE = “假” ＃！COLOR = “1,1,0.78431372549019607,0.19607843137254902” ＃！SIZE_POLICY = “10” ＃！ANCHORED_NODE = “8” ＃！/>＃！ # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! FME_PYTHON_VERSION 27 GUI忽略SourceDataset_SCHEMA_1,SCHEMA_IN_FME_GROUP_NAMED1_SCHEMA_1,SCHEMA_IN_REAL_FORMAT_SCHEMA_1,SCHEMA_IN_NETWORK_AUTHENTICATION_SCHEMA_1,SourceDataset_TEXTLINE_1,TEXTLINE_IN_FME_GROUP_NAMED1_TEXTLINE_1,TEXTLINE_IN_READ_WHOLE_FILE_AT_ONCE_TEXTLINE_1,TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1,TEXTLINE_IN_SKIP_LINES_TEXTLINE_1,TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1,TEXTLINE_IN_FME_GROUP_NAMED2_TEXTLINE_1,TEXTLINE_IN_ENCODING_TEXTLINE_1,TEXTLINE_IN_NETWORK_AUTHENTICATION_TEXTLINE_1,DestDataset_POSTGIS_1,POSTGIS_OUT_FME_CONNECTION_GROUP_POSTGIS_1,POSTGIS_OUT_ADVANCED_POSTGIS_1,POSTGIS_OUT_BULK_COPY_POSTGIS_1,POSTGIS_OUT_START_TRANSACTION_POSTGIS_1,POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1,POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1,POSTGIS_OUT_BEGIN_SQL_POSTGIS_1,POSTGIS_OUT_END_SQL_POSTGIS_1 DEFAULT_MACRO DestDataset_POSTGIS geoportal_user_docker GUI NAMED_DB_CONNECTION_ENCODED DestDataset_POSTGIS FMT:POSTGIS%FAMILY:PostgreSQL Connection: DEFAULT_MACRO _data_types GUI OPTIONAL STRING _data_types " " List of Field Types: DEFAULT_MACRO SourceDataset_SCHEMA $(FME_MF_DIR)wkt/i2_line1.csv GUI FILE_OR_URL SourceDataset_SCHEMA All_files|* Source Dataset: DEFAULT_MACRO REAL_FORMAT_SCHEMA GUESS_FROM_EXTENSION GUI READERPICK REAL_FORMAT_SCHEMA Input Format: DEFAULT_MACRO SourceDataset_TEXTLINE $(FME_MF_DIR)wkt/i2_line1.csvt GUI MULTIFILE SourceDataset_TEXTLINE Text/Compressed_Text_Files(*.txt;*.txt.gz)|*.txt;*.txt.gz|Text_Files(*.txt)|*.txt|Compressed_Text_Files(*.txt.gz)|*.txt.gz|All_files(*)|* Source Text File(s): INCLUDE [ if {{$(DestDataset_POSTGIS)} == {}} { puts_real {Parameter 'DestDataset_POSTGIS' must be given a value.};exit 1;};] INCLUDE [ if {{$(SourceDataset_SCHEMA)} == {}} { puts_real {Parameter 'SourceDataset_SCHEMA' must be given a value.};exit 1;};] INCLUDE [ if {{$(REAL_FORMAT_SCHEMA)} == {}} { puts_real {Parameter 'REAL_FORMAT_SCHEMA' must be given a value.};exit 1;};] INCLUDE [ if {{$(SourceDataset_TEXTLINE)} == {}} { puts_real {Parameter 'SourceDataset_TEXTLINE' must be given a value.};exit 1;};] #!START_HEADER #!START_WB_HEADER READER_TYPE MULTI_READER MULTI_READER_TYPE{0} SCHEMA MULTI_READER_KEYWORD{0} SCHEMA_1 MULTI_READER_GEN_DIRECTIVES{0} SCHEMA_READER,yes,SCHEMA_EXPOSE_FORMAT_ATTRS,,REAL_FORMAT,GUESS_FROM_EXTENSION,EXPOSE_ATTRS_GROUP,,_MERGE_SCHEMAS,YES MULTI_READER_TYPE{1} TEXTLINE MULTI_READER_KEYWORD{1} TEXTLINE_1 MULTI_READER_GEN_DIRECTIVES{1} READ_BOTTOM_UP,No,SKIP_FOOTER,0,SKIP_LINES,0,EXPOSE_ATTRS_GROUP,,TEXTLINE_EXPOSE_FORMAT_ATTRS,,READ_WHOLE_FILE_AT_ONCE,NO,_MERGE_SCHEMAS,YES,ENCODING, WRITER_TYPE MULTI_WRITER MULTI_WRITER_DATASET_ORDER BY_ID MULTI_WRITER_FIRST_WRITER_ID 0 MULTI_WRITER_TYPE{0} POSTGIS MULTI_WRITER_KEYWORD{0} POSTGIS_1 #!END_WB_HEADER＃！START_WB_HEADER MACRO WB_KEYWORD "SCHEMA_1" #!END_WB_HEADER＃！START_SOURCE_HEADER SCHEMA SCHEMA_1 # The dataset this mapping file was generated from was: #!END_SOURCE_HEADER＃！START_WB_HEADER DEFAULT_MACRO SourceDataset INCLUDE [ if {{$(SourceDataset)} != ""} { \ puts {DEFAULT_MACRO SourceDataset_SCHEMA_1 $(SourceDataset)} \ } ] #!END_WB_HEADER＃！START_SOURCE_HEADER SCHEMA SCHEMA_1 DEFAULT_MACRO SourceDataset_SCHEMA_1 $(SourceDataset_SCHEMA) GUI FILE_OR_URL SourceDataset_SCHEMA_1 All_files|* Source Dataset: SCHEMA_1_EXTENSION DEFAULT_MACRO SCHEMA_IN_FME_GROUP_NAMED1_SCHEMA_1 GUI OPTIONAL DISCLOSUREGROUP SCHEMA_IN_FME_GROUP_NAMED1_SCHEMA_1 SCHEMA_IN_REAL_FORMAT_SCHEMA_1 Input DEFAULT_MACRO SCHEMA_IN_REAL_FORMAT_SCHEMA_1 $(REAL_FORMAT_SCHEMA) SCHEMA_1_REAL_FORMAT "$(SCHEMA_IN_REAL_FORMAT_SCHEMA_1)" GUI READERPICK SCHEMA_IN_REAL_FORMAT_SCHEMA_1 Input Format: DEFAULT_MACRO SCHEMA_IN_SCHEMA_READER_SCHEMA_1 yes SCHEMA_1_SCHEMA_READER "$(SCHEMA_IN_SCHEMA_READER_SCHEMA_1)" DEFAULT_MACRO SCHEMA_IN_EXPOSE_ATTRS_GROUP_SCHEMA_1 SCHEMA_1_EXPOSE_ATTRS_GROUP "$(SCHEMA_IN_EXPOSE_ATTRS_GROUP_SCHEMA_1)" # =========================================================================== DEFAULT_MACRO SCHEMA_IN_NETWORK_AUTHENTICATION_SCHEMA_1 SCHEMA_1_NETWORK_AUTHENTICATION "$(SCHEMA_IN_NETWORK_AUTHENTICATION_SCHEMA_1)" GUI OPTIONAL AUTHENTICATOR SCHEMA_IN_NETWORK_AUTHENTICATION_SCHEMA_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # ============================================================================ DEFAULT_MACRO SCHEMA_IN_ATTRIBUTE_READING_SCHEMA_1 ALL SCHEMA_1_ATTRIBUTE_READING "$(SCHEMA_IN_ATTRIBUTE_READING_SCHEMA_1)" # ============================================================================ SCHEMA_1_GENERATE_FME_BUILD_NUM 18295 SCHEMA_1_DATASET "$(SourceDataset_SCHEMA_1)" #!END_SOURCE_HEADER＃！START_WB_HEADER MACRO WB_KEYWORD "TEXTLINE_1" #!END_WB_HEADER＃！START_SOURCE_HEADER TEXTLINE TEXTLINE_1＃===================================================================== # The following GUI line prompts for a file to be used as the source # TextLine file.用户输入被存储在宏，然后将其用于定义数据集＃被读取。＃从生成此映射文件的数据集：＃！END_SOURCE_HEADER＃！START_WB_HEADER DEFAULT_MACRO SourceDataset有[如果{{$（SourceDataset）}！= “”} {\ {放DEFAULT_MACRO SourceDataset_TEXTLINE_1 $（SourceDataset）} \}]＃！END_WB_HEADER＃！START_SOURCE_HEADER TEXTLINE TEXTLINE_1 DEFAULT_MACRO SourceDataset_TEXTLINE_1 $（SourceDataset_TEXTLINE）GUI的多文件SourceDataset_TEXTLINE_1文/ Compressed_Text_Files; | * .TXT（* TXT * txt.gz。）; * txt.gz | TEXT_FILES（* TXT）| * .TXT | Compressed_Text_Files（*.txt.gz)|*.txt.gz|All_files(*)|* Source Text File(s): DEFAULT_MACRO TEXTLINE_IN_FME_GROUP_NAMED1_TEXTLINE_1 GUI OPTIONAL DISCLOSUREGROUP TEXTLINE_IN_FME_GROUP_NAMED1_TEXTLINE_1 TEXTLINE_IN_READ_WHOLE_FILE_AT_ONCE_TEXTLINE_1%TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1%TEXTLINE_IN_SKIP_LINES_TEXTLINE_1%TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1 Reader Parameters DEFAULT_MACRO TEXTLINE_IN_READ_WHOLE_FILE_AT_ONCE_TEXTLINE_1 NO TEXTLINE_1_READ_WHOLE_FILE_AT_ONCE "$(TEXTLINE_IN_READ_WHOLE_FILE_AT_ONCE_TEXTLINE_1)" GUI ACTIVECHOICE TEXTLINE_IN_READ_WHOLE_FILE_AT_ONCE_TEXTLINE_1 YES,TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1,TEXTLINE_IN_SKIP_LINES_TEXTLINE_1,TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1%NO Read Whole File at Once: GUI LOOKUP TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1 ，NO GUI LOOKUP TEXTLINE_IN_SKIP_LINES_TEXTLINE_1 ，0 GUI LOOKUP TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1 ，0 DEFAULT_MACRO TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1无TEXTLINE_1_READ_BOTTOM_UP “$（TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1）” GUI CHOICE TEXTLINE_IN_READ_BOTTOM_UP_TEXTLINE_1是％否读取自下而上：DEFAULT_MACRO TEXTLINE_IN_SKIP_LINES_TEXTLINE_1 0 TEXTLINE_1_SKIP_LINES “$（TEXTLINE_IN_SKIP_LINES_TEXTLINE_1）” 线路的GUI可选的整数TEXTLINE_IN_SKIP_LINES_TEXTLINE_1数量跳过：DEFAULT_MACRO TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1 0 TEXTLINE_1_SKIP_FOOTER“$（TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1）”页脚行的GUI可选的整数TEXTLINE_IN_SKIP_FOOTER_TEXTLINE_1数量跳过：DEFAULT_MACRO TEXTLINE_IN_FME_GROUP_NAMED2_TEXTLINE_1 GUI可选DISCLOSUREGROUP TEXTLINE_IN_FME_GROUP_NAMED2_TEXTLINE_1 TEXTLINE_IN_ENCODING_TEXTLINE_1文件内容＃=====================================================================＃允许强制源的编码 text file DEFAULT_MACRO TEXTLINE_IN_ENCODING_TEXTLINE_1 TEXTLINE_1_ENCODING "$(TEXTLINE_IN_ENCODING_TEXTLINE_1)" GUI OPTIONAL STRING_OR_ENCODING TEXTLINE_IN_ENCODING_TEXTLINE_1 SYSTEM%* Character Encoding: # ===================================================================== # Allow dynamic exposing of FORMAT ATTRIBUTES on the schema DEFAULT_MACRO TEXTLINE_IN_EXPOSE_ATTRS_GROUP_TEXTLINE_1 TEXTLINE_1_EXPOSE_ATTRS_GROUP "$(TEXTLINE_IN_EXPOSE_ATTRS_GROUP_TEXTLINE_1)" # =========================================================================== DEFAULT_MACRO TEXTLINE_IN_NETWORK_AUTHENTICATION_TEXTLINE_1 TEXTLINE_1_NETWORK_AUTHENTICATION "$(TEXTLINE_IN_NETWORK_AUTHENTICATION_TEXTLINE_1)" GUI OPTIONAL AUTHENTICATOR TEXTLINE_IN_NETWORK_AUTHENTICATION_TEXTLINE_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # ============================================================================ DEFAULT_MACRO TEXTLINE_IN_ATTRIBUTE_READING_TEXTLINE_1 ALL TEXTLINE_1_ATTRIBUTE_READING "$(TEXTLINE_IN_ATTRIBUTE_READING_TEXTLINE_1)" # ============================================================================ TEXTLINE_1_GENERATE_FME_BUILD_NUM 18295 TEXTLINE_1_DATASET "$(SourceDataset_TEXTLINE_1)" #!END_SOURCE_HEADER＃！START_WB_HEADER MACRO WB_KEYWORD “POSTGIS_1” ＃！END_WB_HEADER＃！START_DEST_HEADER POSTGIS POSTGIS_1＃！END_DEST_HEADER＃！START_WB_HEADER DEFAULT_MACRO DestDataset有[{IF “$（DestDataset）”！= “”} {\ {放DEFAULT_MACRO DestDataset_POSTGIS_1 $（DestDataset）} \}]＃！END_WB_HEADER＃！START_DEST_HEADER POSTGIS POSTGIS_1 DEFAULT_MACRO DestDataset_POSTGIS_1 $（DestDataset_POSTGIS）GUI NAMED_DB_CONNECTION_ENCODED DestDataset_POSTGIS_1 FMT：POSTGIS连接：POSTGIS_1_PLUGIN_MAX_CHANNELS 1 DEFAULT_MACRO POSTGIS_OUT_STRICT_TEMPORAL_TYPE_HANDLING_POSTGIS_1是POSTGIS_1_STRICT_TEMPORAL_TYPE_HANDLING “$（POSTGIS_OUT_STRICT_TEMPORAL_TYPE_HANDLING_POSTGIS_1）” DEFAULT_MACRO POSTGIS_OUT_FME_CONNECTION_GROUP_POSTGIS_1 GUI可选DISCLOSUREGROUP POSTGIS_OUT_FME_CONNECTION_GROUP_POSTGIS_1 POSTGIS_OUT_NAMED_CONNECTION数据库连接＃============================================================================ # Write geometry (planar) or geography (geodetic) column DEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1 geometry POSTGIS_1_SPATIAL_COLUMN_TYPE "$(POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1)" # ============================================================================ # Default spatial column name DEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_NAME_POSTGIS_1 geom POSTGIS_1_SPATIAL_COLUMN_NAME "$(POSTGIS_OUT_SPATIAL_COLUMN_NAME_POSTGIS_1)" DEFAULT_MACRO POSTGIS_OUT_GENERIC_GEOMETRY_POSTGIS_1 yes POSTGIS_1_GENERIC_GEOMETRY "$(POSTGIS_OUT_GENERIC_GEOMETRY_POSTGIS_1)" DEFAULT_MACRO POSTGIS_OUT_COORDINATE_SYSTEM_GRANULARITY_POSTGIS_1 FEATURE_TYPE POSTGIS_1_COORDINATE_SYSTEM_GRANULARITY "$(POSTGIS_OUT_COORDINATE_SYSTEM_GRANULARITY_POSTGIS_1)" DEFAULT_MACRO POSTGIS_OUT_ADVANCED_POSTGIS_1 GUI OPTIONAL DISCLOSUREGROUP POSTGIS_OUT_ADVANCED_POSTGIS_1 POSTGIS_OUT_BULK_COPY_POSTGIS_1%POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1%POSTGIS_OUT_START_TRANSACTION_POSTGIS_1%POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1%POSTGIS_OUT_BEGIN_SQL_POSTGIS_1%POSTGIS_OUT_END_SQL_POSTGIS_1 Advanced DEFAULT_MACRO POSTGIS_OUT_BULK_COPY_POSTGIS_1 YES POSTGIS_1_BULK_COPY "$(POSTGIS_OUT_BULK_COPY_POSTGIS_1)" GUI CHOICE POSTGIS_OUT_BULK_COPY_POSTGIS_1 YES%NO Bulk Insert DEFAULT_MACRO POSTGIS_OUT_START_TRANSACTION_POSTGIS_1 0 POSTGIS_1_START_TRANSACTION "$(POSTGIS_OUT_START_TRANSACTION_POSTGIS_1)" GUI TEXT POSTGIS_OUT_START_TRANSACTION_POSTGIS_1 Starting Feature: DEFAULT_MACRO POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1 1000 POSTGIS_1_TRANSACTION_INTERVAL "$(POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1)" GUI TEXT POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1 Features Per Transaction DEFAULT_MACRO POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1 NO POSTGIS_1_INSERT_TEXT_GEOMETRY "$(POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1)" GUI CHOICE POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1 YES%NO Insert WKT DEFAULT_MACRO POSTGIS_OUT_BEGIN_SQL_POSTGIS_1 POSTGIS_1_BEGIN_SQL "$(POSTGIS_OUT_BEGIN_SQL_POSTGIS_1)" GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_OUT_BEGIN_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run Before Write DEFAULT_MACRO POSTGIS_OUT_END_SQL_POSTGIS_1 POSTGIS_1_END_SQL "$(POSTGIS_OUT_END_SQL_POSTGIS_1)" GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_OUT_END_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run After Write # ============================================================================ POSTGIS_1_GENERATE_FME_BUILD_NUM 18295 POSTGIS_1_DATASET "$(DestDataset_POSTGIS_1)" #!END_DEST_HEADER＃！START_WB_HEADER＃！END_WB_HEADER＃！END_HEADER LOG_FILENAME “$（FME_MF_DIR）wkt_import2k_worker.log” LOG_APPEND NO LOG_MAX_FEATURES 200个LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE自动FME_GEOMETRY_HANDLING增强FME_STROKE_MAX_DEVIATION 0 LOG_FILTER_MASK -17 DEFAULT_MACRO DATASET_KEYWORD_SCHEMA_1 SCHEMA_1 DEFAULT_MACRO DATASET_KEYWORD_TEXTLINE_1 TEXTLINE_1 DEFAULT_MACRO DATASET_KEYWORD_POSTGIS_1 POSTGIS_1＃------------------------------------------------------------------------- SCHEMA_1_READER_META_ATTRIBUTES fme_basename fme_feature_type # ------------------------------------------------------------------------- TEXTLINE_1_READER_META_ATTRIBUTES fme_basename fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME wkt_import2k_worker MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE SCHEMA SCHEMA_1::schema multi_reader_keyword,$(DATASET_KEYWORD_SCHEMA_1) TO FME_GENERIC ::schema ALIAS_GEOMETRY ROUTE TEXTLINE TEXTLINE_1::text_line multi_reader_keyword,$(DATASET_KEYWORD_TEXTLINE_1) TO FME_GENERIC ::text_line ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * SCHEMA_1_MERGE_DEF SCHEMA_1::schema EXACT schema TEXTLINE_1_MERGE_DEF TEXTLINE_1::text_line EXACT text_line # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "text_line (TEXTLINE_1) Splitter" INPUT FEATURE_TYPE text_line OUTPUT FEATURE_TYPE text_line_TEXTLINE_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "schema (SCHEMA_1) Splitter" INPUT FEATURE_TYPE schema OUTPUT FEATURE_TYPE schema_SCHEMA_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- Tcl2 set AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitDelim [FME_DecodeText { }];如果{[正则表达式{^（[1-9] [0-9] * S）+ $} [组AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitDelim]]} {集AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitWidths [分裂[regsub -all {S $} { } {}] S];PROC AttributeSplitter_doSplit {} {全球AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitWidths;组源[FME_GetAttribute [FME_DecodeText {text_line_data}]];集attrNum 0;集LISTNAME [FME_DecodeText {_list}];集attrPos 0;集keepEmptyParts [字符串等于{否} {否}];的foreach宽度[组AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitWidths] {集endPos [EXPR $ attrPos + $宽度 - 1];组位[串范围$ $源$ attrPos endPos];设置部位[串装饰$位]。如果{$ keepEmptyParts || $part != \"\" } { FME_SetAttribute "$listName{$attrNum}" $part;增量attrNum;};INCR attrPos $宽度;};};}其他{PROC AttributeSplitter_doSplit {} {全球AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitDelim;集DELIM [组AttributeSplitter_bcd73fe7_1980_4002_8a14_b7e99fab19e888_splitDelim];集delimLength [字符串长度$ DELIM];组源[FME_GetAttribute [FME_DecodeText {text_line_data}]];集keepEmptyParts [字符串等于{否} {否}];比特集合{};集的startIndex 0;集nextIndex [字符串第一$ $ DELIM源$的startIndex];而{$ nextIndex> = 0} {lappend位[串范围$ $源的startIndex [EXPR $ nextIndex-1]];组的startIndex [EXPR $ nextIndex + $ delimLength];集nextIndex [字符串第一$ $ DELIM源$的startIndex];};lappend位[串范围$ $源端的startIndex]。集LISTNAME [FME_DecodeText {_list}];集attrNum 0;的foreach位$位{设定trimmedPart [字符串装饰$比特];如果{$ keepEmptyParts || $trimmedPart != \"\" } { FME_SetAttribute "$listName{$attrNum}" $trimmedPart;增量attrNum;};}}} FACTORY_DEF * TeeFactory FACTORY_NAME AttributeSplitter INPUT FEATURE_TYPE text_line_TEXTLINE_1输出FEATURE_TYPE AttributeSplitter_OUTPUT @ TCL2（AttributeSplitter_doSplit）＃------------------------------------------------------------------------- FACTORY_DEF * ElementFactory FACTORY_NAME ListExploder_2 INPUT FEATURE_TYPE AttributeSplitter_OUTPUT LIST_NAME "_list{}" ELEMENT_NUMBER_FIELD "_element_index" CLONE_GEOMETRY ATTR_ACCUM_MODE "HANDLE_CONFLICT" ATTR_CONFLICT_RES "INCOMING_IF_CONFLICT" INCOMING_PREFIX " “输出元件FEATURE_TYPE ListExploder_2_ELEMENTS @RemoveAttributes（ElementFactory.baseCloned）＃------------------------------------------------------------------------- MACRO casemac INCLUDE [如果{{NO} == {} NO } { puts {MACRO casemac -nocase}} ] Tcl2 proc StringReplacer_4cb35b4d_08ec_41b2_947a_96d8cbb1e24987_replacer { findText replaceText invalidValue} { set attrs [split \"_list\" {,}]; set findValue [FME_DecodeText $findText]; set replaceValue [FME_DecodeText $replaceText]; foreach attr $attrs { set attrVal [FME_GetAttribute $attr]; set noMatch true; if {{NO} == {YES}} { set newAttrVal [FME_ReplaceRegex $(casemac) $findValue $attrVal $replaceValue]; } else { set newAttrVal [string map $(casemac) [list $findValue $replaceValue] $attrVal]; }; if { $newAttrVal ne $attrVal } { set noMatch false; FME_SetAttribute $attr $newAttrVal; }; if {$noMatch} { if { $invalidValue == {FME_NULL_VALUE} } { FME_SetAttributeNull $attr; } elseif { $invalidValue != {_FME_NO_OP_} } { FME_SetAttribute $attr [FME_DecodeText $invalidValue]; }; }; }; } FACTORY_DEF * TeeFactory FACTORY_NAME StringReplacer INPUT FEATURE_TYPE ListExploder_2_ELEMENTS OUTPUT FEATURE_TYPE StringReplacer_OUTPUT @Tcl2("StringReplacer_4cb35b4d_08ec_41b2_947a_96d8cbb1e24987_replacer { } {} {_FME_NO_OP_}“）＃------------------------------------------------------------------------- INCLUDE [ if { ({Selected Attributes} == {All Attributes}) } { puts {MACRO StringCaseChanger_func @RenameAttributes(PERFORM_OPERATION,value,.*,lower,"-_")}; } else { puts {MACRO StringCaseChanger_func @RenameAttributes(LIST_ATTR, "value", "_list",lower,"-_")}; } ] FACTORY_DEF * TeeFactory FACTORY_NAME StringCaseChanger INPUT FEATURE_TYPE StringReplacer_OUTPUT OUTPUT FEATURE_TYPE StringCaseChanger_OUTPUT $(StringCaseChanger_func) # ------------------------------------------------------------------------- Lookup AttributeValueMapper_LOOKUP_TABLE integer fme_int32 real fme_real32 string fme_varchar date fme_date time fme_time datetime fme_datetime wkt wkt "" fme_buffer ENCODED_SUPPORTUNICODE FACTORY_DEF * TeeFactory FACTORY_NAME AttributeValueMapper INPUT FEATURE_TYPE StringCaseChanger_OUTPUT OUTPUT FEATURE_TYPE AttributeValueMapper_OUTPUT @Lookup(AttributeValueMapper_LOOKUP_TABLE,"_list",FORWARD|ENCODED_ATTR|REAL_NULL_SUPPORT, fme_data_type) # ------------------------------------------------------------------------- INCLUDE [ set macroLine "MACRO AttributeRemover_2_LIST_EXP "; foreach attr [split ""] { set attr [FME_DecodeText $attr]; set attr [regsub "{}$" $attr "{}.*"]; set attr [regsub -all "{}" $attr "\\{\[0-9\]+\\}"]; append macroLine ",^$attr$"; }; puts $macroLine; ] FACTORY_DEF {*} TeeFactory FACTORY_NAME AttributeRemover_2 INPUT FEATURE_TYPE schema_SCHEMA_1 OUTPUT { FEATURE_TYPE AttributeRemover_2_OUTPUT @RemoveAttributes(fme_encoded,attribute 0 .native_data_type，属性 0 .fme_data_type) @RemoveAttributes(fme_pcre_match"$(AttributeRemover_2_LIST_EXP)") } # ------------------------------------------------------------------------- Tcl2 set AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitDelim [FME_DecodeText { }];if { [regexp {^([1-9][0-9]*s)+$} [set AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitDelim]] } { set AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitWidths [split [regsub -all {s$} { } {}] S];proc AttributeSplitter_2_doSplit {} { global AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitWidths;set source [FME_GetAttribute [FME_DecodeText {attribute 0 。名称}]];集attrNum 0;set listName [FME_DecodeText {attribute}];集attrPos 0;集keepEmptyParts [字符串等于{否} {否}];foreach width [set AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitWidths] { set endPos [expr $attrPos + $width - 1];组位[串范围$ $源$ attrPos endPos];设置部位[串装饰$位]。如果{$ keepEmptyParts || $part != \"\" } { FME_SetAttribute "$listName{$attrNum}" $part;增量attrNum;};INCR attrPos $宽度;};};} else { proc AttributeSplitter_2_doSplit {} { global AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitDelim;set delim [set AttributeSplitter_2_2945d15b_12e8_4546_9a29_5a6c8a0491c434_splitDelim];集delimLength [字符串长度$ DELIM];set source [FME_GetAttribute [FME_DecodeText {attribute 0 。名称}]];集keepEmptyParts [字符串等于{否} {否}];比特集合{};集的startIndex 0;集nextIndex [字符串第一$ $ DELIM源$的startIndex];而{$ nextIndex> = 0} {lappend位[串范围$ $源的startIndex [EXPR $ nextIndex-1]];组的startIndex [EXPR $ nextIndex + $ delimLength];集nextIndex [字符串第一$ $ DELIM源$的startIndex];};lappend位[串范围$ $源端的startIndex]。set listName [FME_DecodeText {attribute}];集attrNum 0;的foreach位$位{设定trimmedPart [字符串装饰$比特];如果{$ keepEmptyParts || $trimmedPart != \"\" } { FME_SetAttribute "$listName{$attrNum}" $trimmedPart;增量attrNum;};} } } FACTORY_DEF * TeeFactory FACTORY_NAME AttributeSplitter_2 INPUT FEATURE_TYPE AttributeRemover_2_OUTPUT OUTPUT FEATURE_TYPE AttributeSplitter_2_OUTPUT @Tcl2(AttributeSplitter_2_doSplit) # ------------------------------------------------------------------------- FACTORY_DEF * ElementFactory FACTORY_NAME ListExploder INPUT FEATURE_TYPE AttributeSplitter_2_OUTPUT LIST_NAME "attribute{}" ELEMENT_NUMBER_FIELD "_element_index" CLONE_GEOMETRY ATTR_ACCUM_MODE "HANDLE_CONFLICT" ATTR_CONFLICT_RES "INCOMING_IF_CONFLICT" INCOMING_PREFIX " " OUTPUT ELEMENT FEATURE_TYPE ListExploder_ELEMENTS @RemoveAttributes(ElementFactory.baseCloned) # ------------------------------------------------------------------------- INCLUDE [if { {ATTRIBUTES} == {ATTRIBUTES} } { puts "MACRO FeatureMerger_REFERENCE_INFO ATTRIBUTES"; } elseif { {ATTRIBUTES} == {GEOM_BUILD} && { } == {POLYGONS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_POLYS";} elseif { {ATTRIBUTES} == {GEOM_BUILD} && { } == {AGGREGATES}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_AGGREGATES";} elseif { {ATTRIBUTES} == {GEOM_BUILD} && { } == {LINESFROMPOINTS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_LINES_FROM_POINTS";} elseif { {ATTRIBUTES} == {GEOM_AND_ATTRS} && { } == {POLYGONS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_POLYS";} elseif { {ATTRIBUTES} == {GEOM_AND_ATTRS} && { } == {AGGREGATES}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES";} elseif { {ATTRIBUTES} == {GEOM_AND_ATTRS} && { } == {LINESFROMPOINTS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_LINES_FROM_POINTS";} elseif { {ATTRIBUTES} == {GEOM_BUILD} } { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_AGGREGATES";} elseif { {ATTRIBUTES} == {GEOM_AND_ATTRS} } { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES";} else {};] FACTORY_DEF {*} ReferenceFactory FACTORY_NAME FeatureMerger GROUP_BY { fme_basename } INPUT REFERENCER FEATURE_TYPE ListExploder_ELEMENTS INPUT REFERENCEE FEATURE_TYPE AttributeValueMapper_OUTPUT REFERENCE_INFO $(FeatureMerger_REFERENCE_INFO) REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED, 值 属性 ,FeatureMerger) @EvaluateExpression(FDIV,STRING_ENCODED, 值 fme_data_type ,FeatureMerger) AUTO ATTR_ACCUM_MODE "HANDLE_CONFLICT" ATTR_CONFLICT_RES "REQUESTOR_IF_CONFLICT" IGNORE_NULLS "No" HANDLE_NULL_MISSING_KEYS_LIKE_FME2013 No LIST_ATTRS_TO_INCLUDE { } LIST_ATTRS_TO_INCLUDE_MODE MERGE_ATTRIBUTES是MANAGE_FME_TYPE是模式完成PROCESS_DUPLICATE_REFERENCEES NO REFERENCEES_FIRST没有REJECT_INVALID_GEOM YES CLEANING_TOLERANCE 输出完成FEATURE_TYPE FeatureMerger_MERGED OUTPUT拒绝的FEATURE_TYPE FeatureMerger_ ＃------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME Logger_Logger INPUT FEATURE_TYPE FeatureMerger_ 输出FEATURE_TYPE Logger_LOGGED @Log（编码“记录器： --------------------------------------------------------------------------------------------------------------------------------------------- 拒绝： ---------------------------------------------------------------------------------------------------------------------------------------------","20","20","",INFO,LOG_ONLY,Logger_5aaad2b7_d5d2_49dc_a43d_0426a46a903366) FACTORY_DEF * TeeFactory FACTORY_NAME "Logger LOGGED Transformer Output Nuker" INPUT FEATURE_TYPE Logger_LOGGED # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME ListBuilder_fme_type_remover INPUT FEATURE_TYPE FeatureMerger_MERGED OUTPUT FEATURE_TYPE ListBuilder_no_fme_type @RemoveAttributes(fme_type,fme_geometry) FACTORY_DEF {*} ListFactory FACTORY_NAME ListBuilder INPUT FEATURE_TYPE ListBuilder_no_fme_type LIST_NAME "attribute{}" LIST_ATTRS_TO_INCLUDE { fme_data_type name } LIST_ATTRS_TO_INCLUDE_MODE SELECTED GROUP_BY { fme_basename } ORDERED_BY_GROUP Yes OUTPUT LIST FEATURE_TYPE ListBuilder_OUTPUT FACTORY_DEF * TeeFactory FACTORY_NAME "ListBuilder OUTPUT Splitter" INPUT FEATURE_TYPE ListBuilder_OUTPUT OUTPUT FEATURE_TYPE ListBuilder_OUTPUT_0_JDZQCVAu4hQ= OUTPUT FEATURE_TYPE ListBuilder_OUTPUT_1_3ZjSSa3+ink= # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME Logger_4_Logger INPUT FEATURE_TYPE ListBuilder_OUTPUT_1_3ZjSSa3+ink= OUTPUT FEATURE_TYPE Logger_4_LOGGED @Log(ENCODED, "Logger_4: @EvaluateExpression（FDIV，STRING_ENCODED，--------------------------------------------------------------------------------------------------------------------------------------------- 值 属性 0 .fme_data_type 值 属性 0 。名称 ---------------------------------------------------------------------------------------------------------------------------------------------,Logger_4)","20","20","",INFO,LOG_ONLY,Logger_4_777d5536_2cc8_43db_900d_f7996a09599928) FACTORY_DEF * TeeFactory FACTORY_NAME "Logger_4 LOGGED Transformer Output Nuker" INPUT FEATURE_TYPE Logger_4_LOGGED # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC ListBuilder_OUTPUT_0_JDZQCVAu4hQ= TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED __wb_out_feat_type__ from_wkt GEOMETRY FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__输出连FEATURE_TYPE * OUTPUT 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 "Final Output Nuker" INPUT FEATURE_TYPE __nuke_me__ # ------------------------------------------------------------------------- POSTGIS_1_DEF from_wkt postgis_type postgis_geometry postgis_mode "" postgis_sql_key_columns "" postgis_drop_table "" postgis_truncate_table "" fme_feature_operation INSERT fme_table_handling DROP_CREATE postgis_create_with_oids NO postgis_create_gist_index YES postgis_spatial_column_type geometry postgis_spatial_column geom postgis_srid 31468 postgis_vacuum_analyze NO postgis_allow_serial_writing NO real text wkt text real00 text string text