# ! # ! 培训 PostGIS”# # #!VIEW_POSITION="-850.009 453.13" #! MARKDOWN_DESCRIPTION="" #! MAX_LOG_FEATURES="200" #! END_TCL="" #! EXPLICIT_BOOKMARK_ORDER="false" #! DOC_TOP_LEFT="-675.008 -1318.5" #! TERMINATE_REJECTED="YES" #! IGNORE_READER_FAILURE="No" #! DESCRIPTION="" #! LAST_SAVE_BUILD="FME(R) 2017.1.1.0 (20170929 - Build 17650 - WIN32)" #! LOG_FILE="" #! MULTI_WRITER_DATASET_ORDER="BY_ID" #! WARN_INVALID_XFORM_PARAM="Yes" #! MARKDOWN_USAGE="" #! DESTINATION_ROUTING_FILE="" #! HISTORY="" #! FME_STROKE_MAX_DEVIATION="0" #! SOURCE_ROUTING_FILE="" #! ATTR_TYPE_ENCODING="SDF" #! DOC_EXTENTS="3130.91 1088.5" #! USE_MARKDOWN="" #! FME_GEOMETRY_HANDLING="Enhanced" #! SHOW_ANNOTATIONS="true" #! REDIRECT_TERMINATORS="NONE" #! FME_DOCUMENT_PRIORGUID="0e4708a0-3348-4800-8248-effec09db047,f808434a-ea9a-471e-8027-20488f6da3d3,cb75f28e-9f21-4715-aa82-e0c78a94f365" #! FME_IMPLICIT_CSMAP_REPROJECTION_MODE="Auto" #! TITLE="" #! FME_REPROJECTION_ENGINE="FME" #! LOG_MAX_RECORDED_FEATURES="200" #! BEGIN_TCL="" #! SHOW_INFO_NODES="true" #! DESTINATION="NONE" #! FME_DOCUMENT_GUID="afd2756c-f8f6-4aeb-bbb5-e774cca2753d" #! LAST_SAVE_DATE="2017-11-02T13:37:53" #! ZOOM_SCALE="100" #! WORKSPACE_VERSION="1" #! BEGIN_PYTHON="" #! PYTHON_COMPATIBILITY="27" #! PASSWORD="" #! END_PYTHON="" #! FME_SERVER_SERVICES="" #! USAGE="" #! SOURCE="NONE" #! CATEGORY="" #! FME_BUILD_NUM="17650" #! > #! # ! # ! 价值 fme_db_operation ,多个,+fme_table_handling+USE_EXISTING,+fme_selection_group+fme_DISCLOSURE_OPEN Feature Operation“INSERT”GUI ACTIVECHOICE_LOOKUP fme_table_handling USE 现有的、有用的、存在的、FMEX表的创建组%创建 如果 需要,如果缺少%Drop,则创建 创建,删除创建%Truncate 现有的,TunCeTeBe存在,FMEA Table SeCudioType表处理“CuraTyIfFixEngess”GUI全线查找表FMEXUPDATEY几何,是的,是%%.无更新空间列(S)“是”GUI可选的公开组FMEA选择组FMEA选择方法行选择“”“GUI可选的整行放射参数组FMEX选择方法FMEX MatCHYH列,MatCHLH列%FMEIN Bug生成器行选择方法“match_columns”gui whole_line attrlist_commas fme_match_columns“\”match columns“”gui whole_line text_edit_sql_cfg_or_attr fme_where_builder_子句模式,where子句“”gui optional disclosuregroup fme_table_creation_group postgis_create_with_oids%postgis_create_gist_index table creation parameters“”“”“gui choice postgis_create_with_oid yes%no create with oid”no“gui choice postgis_create_gist_index yes%no create gist index”yes“gui可选名称组fme_space_group postgis_space_column_type%postgis_space_column%postgis_srid space”“gui lookup_choice postgis_space_column_type geometry,geometry%geography,”地理空间类型“geometry”图形用户界面可选整行文本postgis空间列“geom”图形用户界面可选浮动postgis空间列srid“”图形用户界面可选公开组fme高级组postgis真空分析%postgis允许串行写高级“”图形用户界面选择postgis真空分析是%NO真空分析表“否”图形用户界面选择postgis_allow_serial_writing yes%no allow serial column writing“no”!attr_index_types=“btree rtree hash primarykey”!属性名称无效。%-#[……”)!?*'&+\/" #! 支持_FEATURE_TYPE_FANOUT=“true”#ENABLED=“true”#动态_feature_types_list_on_merge=“true”!dataset_type=“database”!生成_fme_build_num=“17650”!COORDSYS=“#”fanout_group=“否”!FANOUT_表达式=“#”> #! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # !

去聚合器:分割多个空间

" # !POSITION="-79.127 -653.249" #! TOP_LEFT="-79.127 -653.249" #! BOTTOM_RIGHT="-80.127 -652.249" #! BOUNDING_RECT="-79.127 -653.249 -1 -1" #! ORDER="5e+14" #! FOLLOW_ANCHOR="true" #! INFO_NODE="false" #! COLOUR="1,1,0.784314,0.192157" #! SIZE_POLICY="8" #! COMMENT_TYPE="REGULAR" #! ANCHORED_NODE="30" #! /> #!
# ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # ! # !
FME_PYTHON_VERSION 27 GUI忽略SWORLDSWAF_IN_SERVER_SWORLDSWAF_1,SWORLDSWAF_IN_PORT_SWORLDSWAF_1,SWORLDSWAF_IN_SERVICE_SWORLDSWAF_1,SWORLDSWAF_IN_USER_NAME_SWORLDSWAF_1,SWORLDSWAF_IN_PASSWORD_SWORLDSWAF_1,SWORLDSWAF_IN_EXPOSE_INTERNAL_TABLES_SWORLDSWAF_1,SWORLDSWAF_IN_ALTERNATIVE_SWORLDSWAF_1,SWORLDSWAF_IN_CHECKPOINT_SWORLDSWAF_1,SWORLDSWAF_IN_QUERY_SWORLDSWAF_1,SWORLDSWAF_IN_EXPORT_CHANGES_SWORLDSWAF_1,SWORLDSWAF_IN_BASELINE_ALTERNATIVE_SWORLDSWAF_1,SWORLDSWAF_IN_BASELINE_CHECKPOINT_SWORLDSWAF_1,SWORLDSWAF_IN_USE_SEARCH_ENVELOPE_SWORLDSWAF_1,SWORLDSWAF_IN_SEARCH_ENVELOPE_MINX_SWORLDSWAF_1,SWORLDSWAF_IN_SEARCH_ENVELOPE_MINY_SWORLDSWAF_1,SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXX_SWORLDSWAF_1,SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXY_SWORLDSWAF_1,SWORLDSWAF_IN_NETWORK_AUTHENTICATION_SWORLDSWAF_1,DestDataset_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 FME 培训 如果{{$(DestDataset_POSTGIS)} == {}} {puts_real{参数'DestDataset_POSTGIS'必须被赋予一个值};退出1;};)# !START_HEADER # !START_WB_HEADER READER_TYPE SWORLDSWAF READER_KEYWORD SWORLDSWAF_1 reader_gen_use_search_envelope,NO,USER_NAME,,SERVICE,FMENOFACTORY,TABLELIST,electric .cable electricity.substation electricity.supply_point 电力。客户,搜索信封最大值,0,基线检查点,可选,导出更改,否,查询,搜索信封最小值,0,搜索信封最大值,0,合并模式,是,服务器,本地主机,基线检查点,端口,30000,公开内部表,否,搜索信封最小值,0 writer_type multi_writer multi_writer_dataset_order by_id multi_writer_first_id 0 multi_writer_type{0}postgis multi_writer_keyword{0}postgis_1!结束_WB_HEADER#!启动wb_header宏wb_关键字“sworldswaf_1”!结束_WB_HEADER#!开始_source_header sworldswaf sworldswaf_1目前,数据集似乎未被使用,因此我们不会要求它此映射文件生成的数据集是:!结束源头!启动WB_HEADER DEFAULT_宏SourceDataset INCLUDE[如果{{$(SourceDataset)}!=“”}{\puts{default_macro sourcedataset_sworldswaf_1$(sourcedataset)}}]!结束_WB_HEADER#!START_SOURCE_HEADER SWORLDSWAF SWORLDSWAF_1 DEFAULT_MACRO SourceDataset_SWORLDSWAF_1本地主机:30000#GUI可选TEXT SourceDataset来源的Smallworld 4数据集:DEFAULT_MACRO SWORLDSWAF_IN_DATASET_SWORLDSWAF_1本地主机:30000 SWORLDSWAF_1_DATASET “$(SWORLDSWAF_IN_DATASET_SWORLDSWAF_1)” #=========================================================================== DEFAULT_MACRO SWORLDSWAF_IN_SERVER_SWORLDSWAF_1 localhost SWORLDSWAF_1_SERVER "$(SWORLDSWAF_IN_SERVER_SWORLDSWAF_1)" GUI TEXT SWORLDSWAF_IN_SERVER_SWORLDSWAF_1 Server Host: # =========================================================================== DEFAULT_MACRO SWORLDSWAF_IN_PORT_SWORLDSWAF_1 30000 SWORLDSWAF_1_PORT "$(SWORLDSWAF_IN_PORT_SWORLDSWAF_1)" GUI TEXT SWORLDSWAF_IN_PORT_SWORLDSWAF_1 Server Port: # =========================================================================== DEFAULT_MACRO SWORLDSWAF_IN_SERVICE_SWORLDSWAF_1 FMENOFACTORY SWORLDSWAF_1_SERVICE "$(SWORLDSWAF_IN_SERVICE_SWORLDSWAF_1)" GUI TEXT SWORLDSWAF_IN_SERVICE_SWORLDSWAF_1 Service: DEFAULT_MACRO SWORLDSWAF_IN_USER_NAME_SWORLDSWAF_1 SWORLDSWAF_1_USER_NAME "$(SWORLDSWAF_IN_USER_NAME_SWORLDSWAF_1)" GUI OPTIONAL TEXT SWORLDSWAF_IN_USER_NAME_SWORLDSWAF_1 Username: DEFAULT_MACRO SWORLDSWAF_IN_PASSWORD_SWORLDSWAF_1 SWORLDSWAF_1_PASSWORD "$(SWORLDSWAF_IN_PASSWORD_SWORLDSWAF_1)" GUI OPTIONAL PASSWORD SWORLDSWAF_IN_PASSWORD_SWORLDSWAF_1 Password: DEFAULT_MACRO SWORLDSWAF_IN_EXPOSE_INTERNAL_TABLES_SWORLDSWAF_1 no SWORLDSWAF_1_EXPOSE_INTERNAL_TABLES "$(SWORLDSWAF_IN_EXPOSE_INTERNAL_TABLES_SWORLDSWAF_1)" GUI OPTIONAL CHECKBOX SWORLDSWAF_IN_EXPOSE_INTERNAL_TABLES_SWORLDSWAF_1 yes%no Expose Internal Tables DEFAULT_MACRO SWORLDSWAF_IN_ALTERNATIVE_SWORLDSWAF_1 SWORLDSWAF_1_ALTERNATIVE "$(SWORLDSWAF_IN_ALTERNATIVE_SWORLDSWAF_1)" GUI OPTIONAL TEXT SWORLDSWAF_IN_ALTERNATIVE_SWORLDSWAF_1 Alternative: DEFAULT_MACRO SWORLDSWAF_IN_CHECKPOINT_SWORLDSWAF_1 SWORLDSWAF_1_CHECKPOINT "$(SWORLDSWAF_IN_CHECKPOINT_SWORLDSWAF_1)" GUI OPTIONAL TEXT SWORLDSWAF_IN_CHECKPOINT_SWORLDSWAF_1 Checkpoint: DEFAULT_MACRO SWORLDSWAF_IN_QUERY_SWORLDSWAF_1 SWORLDSWAF_1_QUERY "$(SWORLDSWAF_IN_QUERY_SWORLDSWAF_1)" GUI OPTIONAL TEXT_EDIT_ SWORLDSWAF_IN_QUERY_SWORLDSWAF_1 WHERE Clause: DEFAULT_MACRO SWORLDSWAF_IN_EXPORT_CHANGES_SWORLDSWAF_1 NO SWORLDSWAF_1_EXPORT_CHANGES "$(SWORLDSWAF_IN_EXPORT_CHANGES_SWORLDSWAF_1)" GUI OPTIONAL ACTIVECHECK SWORLDSWAF_IN_EXPORT_CHANGES_SWORLDSWAF_1 YES,SWORLDSWAF_IN_QUERY_SWORLDSWAF_1%NO,SWORLDSWAF_IN_BASELINE_ALTERNATIVE_SWORLDSWAF_1,SWORLDSWAF_IN_BASELINE_CHECKPOINT_SWORLDSWAF_1 Export Changes from Baseline DEFAULT_MACRO SWORLDSWAF_IN_BASELINE_ALTERNATIVE_SWORLDSWAF_1 SWORLDSWAF_1_BASELINE_ALTERNATIVE "$(SWORLDSWAF_IN_BASELINE_ALTERNATIVE_SWORLDSWAF_1)" GUI OPTIONAL TEXT SWORLDSWAF_IN_BASELINE_ALTERNATIVE_SWORLDSWAF_1 Baseline Alternative: DEFAULT_MACRO SWORLDSWAF_IN_BASELINE_CHECKPOINT_SWORLDSWAF_1 SWORLDSWAF_1_BASELINE_CHECKPOINT "$(SWORLDSWAF_IN_BASELINE_CHECKPOINT_SWORLDSWAF_1)" GUI OPTIONAL TEXT SWORLDSWAF_IN_BASELINE_CHECKPOINT_SWORLDSWAF_1 Baseline Checkpoint: DEFAULT_MACRO SWORLDSWAF_IN_USE_SEARCH_ENVELOPE_SWORLDSWAF_1 NO SWORLDSWAF_1_USE_SEARCH_ENVELOPE "$(SWORLDSWAF_IN_USE_SEARCH_ENVELOPE_SWORLDSWAF_1)" GUI ACTIVEGROUP SWORLDSWAF_IN_USE_SEARCH_ENVELOPE_SWORLDSWAF_1 SWORLDSWAF_IN_SEARCH_ENVELOPE_MINX_SWORLDSWAF_1%SWORLDSWAF_IN_SEARCH_ENVELOPE_MINY_SWORLDSWAF_1%SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXX_SWORLDSWAF_1%SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXY_SWORLDSWAF_1 Use Search Envelope DEFAULT_MACRO SWORLDSWAF_IN_SEARCH_ENVELOPE_MINX_SWORLDSWAF_1 0 SWORLDSWAF_1_SEARCH_ENVELOPE "$(SWORLDSWAF_IN_SEARCH_ENVELOPE_MINX_SWORLDSWAF_1)" GUI FLOAT SWORLDSWAF_IN_SEARCH_ENVELOPE_MINX_SWORLDSWAF_1 Minimum X: DEFAULT_MACRO SWORLDSWAF_IN_SEARCH_ENVELOPE_MINY_SWORLDSWAF_1 0 SWORLDSWAF_1_SEARCH_ENVELOPE "$(SWORLDSWAF_IN_SEARCH_ENVELOPE_MINY_SWORLDSWAF_1)" GUI FLOAT SWORLDSWAF_IN_SEARCH_ENVELOPE_MINY_SWORLDSWAF_1 Minimum Y: DEFAULT_MACRO SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXX_SWORLDSWAF_1 0 SWORLDSWAF_1_SEARCH_ENVELOPE "$(SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXX_SWORLDSWAF_1)" GUI FLOAT SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXX_SWORLDSWAF_1 Maximum X: DEFAULT_MACRO SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXY_SWORLDSWAF_1 0 SWORLDSWAF_1_SEARCH_ENVELOPE "$(SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXY_SWORLDSWAF_1)" GUI FLOAT SWORLDSWAF_IN_SEARCH_ENVELOPE_MAXY_SWORLDSWAF_1 Maximum Y: # =========================================================================== DEFAULT_MACRO SWORLDSWAF_IN_NETWORK_AUTHENTICATION_SWORLDSWAF_1 SWORLDSWAF_1_NETWORK_AUTHENTICATION "$(SWORLDSWAF_IN_NETWORK_AUTHENTICATION_SWORLDSWAF_1)" GUI OPTIONAL AUTHENTICATOR SWORLDSWAF_IN_NETWORK_AUTHENTICATION_SWORLDSWAF_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication # =========================================================================== DEFAULT_MACRO SWORLDSWAF_IN_ATTRIBUTE_READING_SWORLDSWAF_1 ALL SWORLDSWAF_1_ATTRIBUTE_READING "$(SWORLDSWAF_IN_ATTRIBUTE_READING_SWORLDSWAF_1)" SWORLDSWAF_1_DATASET "localhost:30000" #!结束源头!宏WB_KEYWORD“POSTGIS_1”#!结束_WB_HEADER#!@ START_DEST_HEADER POSTGIS POSTGIS_1 #!END_DEST_HEADER # !START_WB_HEADER DEFAULT_MACRO DestDataset包含[if {"$(DestDataset)"] != ""} { \ puts {DEFAULT_MACRO DestDataset_POSTGIS_1 $(DestDataset)} \ } ] #!结束_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连接:# = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = #写几何(平面)或地理(大地)列DEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1几何POSTGIS_1_SPATIAL_COLUMN_TYPE " $ (POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1) "# = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = #默认名称空间列DEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_NAME_POSTGIS_1几何学POSTGIS_1_SPATIAL_COLUMN_NAME " $ (POSTGIS_OUT_SPATIAL_COLUMN_NAME_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_DATASET "$(DestDataset_POSTGIS_1)" #!END_DEST_HEADER # !START_WB_HEADER # !结束_WB_HEADER#!结束_HEADER LOG_FILENAME“$(FME_MF_DIR)1.LoadPostGIS.LOG”LOG_APPEND NO LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto FME_GEOMETRY_HANDLING增强FME_STROKE_MAX_DEVIATION 0 LOG_FILTER_MASK-1个默认_宏数据集关键字_1 SWORLDSWAF_1个默认_宏dataset_keyword_postgis_1 postgis_1——#------------------------------------------------------宏工作区名称1.loadpostgis宏fme_viewer_app fmedatainspector----------swoldswaf_1_def electronic.cable id char(255)已知字符(33)电压字符(6)状态字符(15)长度双倍fme_db_operation char(10)詿詿——sworldswaf_1_def electronic.customer_id char(255)name char(33)address1 char(33)address2 char(33)usage int sales double supply_point char(255)fme_db_operation char(10)#-----------------------------------SWORDSWAF_1_def electronic.supply_point id char(33)customer_class char(17)customer char(255)fme_db_operation char(10)----------SWORDSWAF_1_def electronic.substation id char(255)称为char(33)FMEYBDB操作字符(10),---------------------------------FaseYy-DEF*TraceFungFielyyNo.No.Routhand PosithEnter DeaveRever SCORDEPY PARMY评估单程多读关键字SWorkSWAF1输入特征SouthSavaSWorkSavaF1:::electric.cable ALIAS_GEOMETRY ROUTE SWORLDSWAF SWORLDSWAF_1::electric.customer TO FME_GENERIC::electric.customer ALIAS_GEOMETRY ROUTE SWORLDSWAF SWORLDSWAF_1::electric.supply_point TO FME_GENERIC::electric.supply_point ALIAS_GEOMETRY ROUTE SWORLDSWAF SWORLDSWAF_1::electric.substation TO FME_GENERICALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE*SWORLDSWAF_1_MERGE_DEF SWORLDSWAF_1::electric.cable EXACT electric.cable SWORLDSWAF_1_MERGE_DEF SWORLDSWAF_1::electric.supply_point EXACT electric.supply_point SWORLDSWAF_1_MERGEswoldswaf_1::electric.substation exact electric.substation 35;——#)-----------工厂定义*T工厂名称“电力.客户(SWORDSWAF_1)分配器”输入功能_类型电力.客户输出功能_类型电力.客户_SWORDSWAF_1----------工厂定义*TeeFactory FACTORY_NAME“electric.supply_point(SWORLDSWAF_1)Splitter”输入功能_TYPE electric.supply_point_1SWORLDSWAF_1——FEATURE_TYPE electricity.substation OUTPUT FEATURE_TYPE electricity.substation_SWORLDSWAF_1 DEFAULT_MACRO WB_CURRENT_CONTEXT%——无实例化的几何级数,是一个新的,没有St1,F1类型的字段。输出多边形特征U型去聚集器U 2 U型去聚集输出圆环特征U型去聚集器U 2 U型去聚集输出聚合特征U型去聚集器U 2 U型去聚集输入特征U型去聚集输出feature_type testfilter_2_testfilterinputline_0 factory_def*testfactory_name testfilter_2_testfactory_0 input feature_type testfilter_2_testfilterinputline_0 test@evaluateexpression(fdiv,string_encoded,字符串编码, 价值 _几何名称 ,TestFilter_2)=位置编码布尔运算符或复合运算表达式 输出通过的功能_TYPE TestFilter_2_location输出失败的功能_TYPE TestFilter_2_TestFilter inputline_1 FACTORY_DEF*TestFactory_NAME TestFilter_2_TestFactory_1输入功能_TYPE TestFilter_2_TestFilter inputline_1 TEST@evaluatexpression(FDIV,STRING_ENCODED, 价值 _几何名称 ,TestFilter_2)=标签编码的布尔运算器或复合运算器 输出通过功能_type testfilter_2_label输出失败功能_type testfilter_2_testfilterinputline_2 factory_def*teefactory factory_name testfilter_2_ 未过滤 输入功能_TYPE TestFilter_2_TESTFILTERINPUTLINE_2输出功能_TYPE TestFilter_2_ 未过滤 factory_def*teefactory_name“testfilter_2 label output nuker”输入功能_type testfilter_2_label factory_def*teefactory factory_name“testfilter_2 未过滤 输出Nuker“输入特性”类型TestFilter_ 未过滤 这是一个递归函数,它是一个递归函数。IdAdTraceID.AddioTythIdApple,SturyyIdPalthIdIdAddiaIdAtLo.ActhyLyHythoIdAdLoad CopythAutoTo.EnguloDouthOutoDoad PosioType,DeGeulyType DeGeigalAdgDeGeulyType,DeGeulyType DeGeultAggDeExcel,DeGeulyType DePosigAtgRead DyPosigAtter;特征_-TYPE Deaggregator_-DEAGGREGATED#-----------------------------FACTORY_-DEF*TeeFactory FACTORY_-NAME TestFilter INPUT FEATURE_-TYPE Deaggregator_-TYPE TestFilter_-TestFilter inputline_-0 FACTORY_-DEF*TestFactory_-NAME TestFilter_-TestFactory_-0 INPUT FEATURE_-TYPEtestfilter_testfilterinputline_0 test@evaluateexpression(fdiv,字符串编码, 价值 _几何名称 ,TestFilter)=位置编码的布尔运算器或复合运算器 输出通过功能_TYPE TestFilter_location输出失败功能_TYPE TestFilter_TESTFILTERINPUTLINE_1 FACTORY_DEF*TestFactory_NAME TestFilter_1输入功能_TYPE TestFilter_TESTFILTERINPUTLINE_1 TEST@evaluatexpression(FDIV,STRING_ENCODED, 价值 _几何名称 ,TestFilter)=注释编码BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR 的Passed FEATURE_TYPE TestFilter_annotation OUTPUT失败FEATURE_TYPE TestFilter_TESTFILTERINPUTLINE_2 FACTORY_DEF * TeeFactory FACTORY_NAME TestFilter_ 未过滤 INPUT FEATURE_TYPE TestFilter_TESTFILTERINPUTLINE_2输出FEATURE_TYPE TestFilter_ 未过滤 FACTORY_DEF * TeeFactory FACTORY_NAME “TestFilter注释输出Nuker” INPUT FEATURE_TYPE TestFilter_annotation FACTORY_DEF * TeeFactory FACTORY_NAME“TestFilter 未过滤 输出Nuker” INPUT FEATURE_TYPE TestFilter_ 未过滤 #------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC TestFilter_location TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED __wb_out_feat_type__ electricity_substation 几何ROUTE FME_GENERIC electricity.customer_SWORLDSWAF_1 TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED __wb_out_feat_type__ electricity_customer 几何ROUTE FME_GENERIC TestFilter_2_location TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED __wb_out_feat_type__ electricity_supply_point 几何ROUTE FME_GENERIC electricity.cable_SWORLDSWAF_1 TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED __wb_out_feat_type__ electricity_cable 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 electricity_substation 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 "" postgis_vacuum_analyze NO postgis_allow_serial_writing NO id varchar(255) known_as varchar(33) # ------------------------------------------------------------------------- POSTGIS_1_DEF electricity_customer 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 "" postgis_vacuum_analyze NO postgis_allow_serial_writing NO customer_id varchar(255) name varchar(33) address1 varchar(33) address2 varchar(33) usage int4 sales float8 # ------------------------------------------------------------------------- POSTGIS_1_DEF electricity_supply_point 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 "" postgis_vacuum_analyze NO postgis_allow_serial_writing NO id varchar(33) customer_class varchar(17) customer varchar(255) # ------------------------------------------------------------------------- POSTGIS_1_DEF electricity_cable 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 "" postgis_vacuum_analyze NO postgis_allow_serial_writing NO id varchar(255) known_as varchar(33) voltage varchar(6) status varchar(15) length float8