#! #! 训练 数据库 “###记录=! ”“ #LOG_FILE = ”“ #BEGIN_TCL =! ”“ #SOURCE_ROUTING_FILE = ”!“ #VIEW_POSITION =! ” - 1381.26 1046.89“!#FME_BUILD_NUM = ”17647“!#FME_REPROJECTION_ENGINE =” FME“#!DOC_EXTENTS =” 1375.29 71" #!FME_GEOMETRY_HANDLING = “增强型” #!DESCRIPTION =”


“#MULTI_WRITER_DATASET_ORDER =!” BY_ID”#DOC_TOP_LEFT =! “ - !556.531 264.631”!#END_PYTHON = “” #MARKDOWN_USAGE = “”!#MARKDOWN_DESCRIPTION = “” #FME_DOCUMENT_GUID = “bbe60e57-a65b-4377-94ac-b57e4c376c4a” #! ATTR_TYPE_ENCODING="SDF" #! LAST_SAVE_BUILD="FME(R) 2017.1.1.0 (20170926 - Build 17647 - WIN64)" #! FME_IMPLICIT_CSMAP_REPROJECTION_MODE="Auto" #! USE_MARKDOWN="" #! EXPLICIT_BOOKMARK_ORDER="false" #! FME_SERVER_SERVICES="" #! FME_DOCUMENT_PRIORGUID="e01a5332-11af-41f8-adc5-c53b4526090e,7cabae3a-3d2d-4907-8caf-9864a8e62214,7262f5fc-68c7-43a1-8f20-b72fb9243f97,368b646f-c253-43e8-95ca-756c146da961,92c337b1-6fd3-44b2-87ee-2f1c7cb5b9ce,2e4d75a1-1e20-4514-a91a-b14d62b9bfbf" #! END_TCL="" #! FME_STROKE_MAX_DEVIATION="0" #! TERMINATE_REJECTED="NO" #! LAST_SAVE_DATE="2017-09-29T12:03:03" #! BEGIN_PYTHON="" #! CATEGORY="" #! DESTINATION="NONE" #! PYTHON_COMPATIBILITY="27" #! WORKSPACE_VERSION="1" #! ZOOM_SCALE="100" #! MAX_LOG_FEATURES="200" #! SOURCE="NONE" #! WARN_INVALID_XFORM_PARAM="Yes" #! USAGE="


“#!REDIRECT_TERMINATORS =” NONE”#!LOG_MAX_RECORDED_FEATURES = “200” #!SHOW_INFO_NODES = “真” #!TITLE = “Example1_StartingWorkspace” #!IGNORE_READER_FAILURE = “否” #!DESTINATION_ROUTING_FILE = “” #!SHOW_ANNOTATIONS = “真” #!PASSWORD = “” #!>#! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! 连接方式:,POSTGRES_SCHEMAS_FOR_TABLE_LISTING, “忽略TEXT”,POSTGRES 架构 POSTGRES_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS,清单:“可选NO_EDIT文本”、POSTGRES " / > # ! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #!
FME_PYTHON_VERSION 27 GUI IGNORE SourceDataset_POSTGIS_1,POSTGIS_IN_EXPOSE_ATTRS_GROUP_POSTGIS_1,POSTGIS_IN_SEARCH_ENVELOPE_MINX_POSTGIS_1,POSTGIS_IN_SEARCH_ENVELOPE_MINY_POSTGIS_1,POSTGIS_IN_SEARCH_ENVELOPE_MAXX_POSTGIS_1,POSTGIS_IN_SEARCH_ENVELOPE_MAXY_POSTGIS_1,POSTGIS_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_POSTGIS_1,POSTGIS_IN_CLIP_TO_ENVELOPE_POSTGIS_1,POSTGIS_IN_SEARCH_METHOD_POSTGIS_1,POSTGIS_IN_ADVANCED_POSTGIS_1,POSTGIS_IN_FEATURES_PER_FETCH_POSTGIS_1,POSTGIS_IN_BEGIN_SQL_POSTGIS_1,POSTGIS_IN_END_SQL_POSTGIS_1,POSTGIS_IN_SCHEMAS_FOR_TABLE_LISTING_POSTGIS_1 DEFAULT_MACRO SourceDataset_POSTGIS PostGIS的 训练 数据库GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_POSTGIS FMT:POSTGIS%FAMILY:PostgreSQL的连接:INCLUDE [如果{{$(SourceDataset_POSTGIS)} {==}} {puts_real {参数 'SourceDataset_POSTGIS' 必须被给出的值};。出口1;};]#!START_HEADER#!START_WB_HEADER READER_TYPE POSTGIS READER_KEYWORD POSTGIS_1 READER_GEN_DIRECTIVES DISABLE_COLLECTION_SPLITTING,是的,高级,, FME_CONNECTION_GROUP ,, EXPOSE_ATTRS_GROUP ,, SEARCH_METHOD,MBR_OVERLAPS,USE_SEARCH_ENVELOPE,NO,POSTGIS_EXPOSE_FORMAT_ATTRS ,, SCHEMAS_FOR_TABLE_LISTING ,, END_SQL ,, CLIP_TO_ENVELOPE,NO,_MERGE_SCHEMAS,YES,USE_TRUE_POSTGIS_TYPES,是的,SEARCH_ENVELOPE_MAXY,0,SEARCH_ENVELOPE_COORDINATE_SYSTEM ,, FEATURES_PER_FETCH,10000,NAMED_CONNECTION,PostGIS的 空间 训练 空间 数据库,BEGIN_SQL ,, SEARCH_ENVELOPE_MAXX,0,SEARCH_ENVELOPE_MINY,0,TABLELIST,public.AddressPoints,SEARCH_ENVELOPE_MINX,0,QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS,是WRITER_TYPE NULL WRITER_KEYWORD NULL_DEST NULL_DEST_DATASET空#!END_WB_HEADER#!START_WB_HEADER MACRO WB_KEYWORD “POSTGIS_1” #!END_WB_HEADER#!START_SOURCE_HEADER POSTGIS POSTGIS_1#从生成此映射文件的数据集:#!END_SOURCE_HEADER#!START_WB_HEADER DEFAULT_MACRO SourceDataset有[如果{{$(SourceDataset)}!= “”} {\ {放DEFAULT_MACRO SourceDataset_POSTGIS_1 $(SourceDataset)} \}]#!END_WB_HEADER#!START_SOURCE_HEADER POSTGIS POSTGIS_1 DEFAULT_MACRO SourceDataset_POSTGIS_1 $(SourceDataset_POSTGIS)GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_POSTGIS_1 FMT:POSTGIS连接:DEFAULT_MACRO POSTGIS_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_POSTGIS_1是POSTGIS_1_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS “$(POSTGIS_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_POSTGIS_1)” DEFAULT_MACRO POSTGIS_IN_DISABLE_COLLECTION_SPLITTING_POSTGIS_1是POSTGIS_1_DISABLE_COLLECTION_SPLITTING “$(POSTGIS_IN_DISABLE_COLLECTION_SPLITTING_POSTGIS_1)” DEFAULT_MACRO POSTGIS_IN_USE_TRUE_POSTGIS_TYPES_POSTGIS_1是POSTGIS_1_USE_TRUE_POSTGIS_TYPES “$(POSTGIS_IN_USE_TRUE_POSTGIS_TYPES_POSTGIS_1)” DEFAULT_MACRO POSTGIS_IN_EXPOSE_ATTRS_GROUP_POSTGIS_1 POSTGIS_1_EXPOSE_ATTRS_GROUP "$(POSTGIS_IN_EXPOSE_ATTRS_GROUP_POSTGIS_1)" GUI OPTIONAL DISCLOSUREGROUP POSTGIS_IN_EXPOSE_ATTRS_GROUP_POSTGIS_1 POSTGIS_IN_POSTGIS_EXPOSE_FORMAT_ATTRS Schema Attributes # Include this file in source setting section to add native search envelope processing # Zero as a default means we don't do any search -- this makes workbench happier # =========================================================================== DEFAULT_MACRO POSTGIS_IN_SEARCH_ENVELOPE_MINX_POSTGIS_1 0 POSTGIS_1_SEARCH_ENVELOPE "$(POSTGIS_IN_SEARCH_ENVELOPE_MINX_POSTGIS_1)" GUI OPTIONAL FLOAT POSTGIS_IN_SEARCH_ENVELOPE_MINX_POSTGIS_1 Minimum X: # =========================================================================== DEFAULT_MACRO POSTGIS_IN_SEARCH_ENVELOPE_MINY_POSTGIS_1 0 POSTGIS_1_SEARCH_ENVELOPE "$(POSTGIS_IN_SEARCH_ENVELOPE_MINY_POSTGIS_1)" GUI OPTIONAL FLOAT POSTGIS_IN_SEARCH_ENVELOPE_MINY_POSTGIS_1 Minimum Y: # =========================================================================== DEFAULT_MACRO POSTGIS_IN_SEARCH_ENVELOPE_MAXX_POSTGIS_1 0 POSTGIS_1_SEARCH_ENVELOPE "$(POSTGIS_IN_SEARCH_ENVELOPE_MAXX_POSTGIS_1)" GUI OPTIONAL FLOAT POSTGIS_IN_SEARCH_ENVELOPE_MAXX_POSTGIS_1 Maximum X: # =========================================================================== DEFAULT_MACRO POSTGIS_IN_SEARCH_ENVELOPE_MAXY_POSTGIS_1 0 POSTGIS_1_SEARCH_ENVELOPE "$(POSTGIS_IN_SEARCH_ENVELOPE_MAXY_POSTGIS_1)" GUI OPTIONAL FLOAT POSTGIS_IN_SEARCH_ENVELOPE_MAXY_POSTGIS_1 Maximum Y: # =========================================================================== DEFAULT_MACRO POSTGIS_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_POSTGIS_1 POSTGIS_1_SEARCH_ENVELOPE "$(POSTGIS_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_POSTGIS_1)" GUI OPTIONAL COORDSYS POSTGIS_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_POSTGIS_1 Search Envelope Coordinate System: # =========================================================================== DEFAULT_MACRO POSTGIS_IN_CLIP_TO_ENVELOPE_POSTGIS_1 NO POSTGIS_1_CLIP_TO_ENVELOPE "$(POSTGIS_IN_CLIP_TO_ENVELOPE_POSTGIS_1)" GUI OPTIONAL CHECKBOX POSTGIS_IN_CLIP_TO_ENVELOPE_POSTGIS_1 YES%NO Clip to Search Envelope DEFAULT_MACRO POSTGIS_IN_SEARCH_METHOD_POSTGIS_1 MBR_OVERLAPS POSTGIS_1_SEARCH_METHOD "$(POSTGIS_IN_SEARCH_METHOD_POSTGIS_1)" GUI CHOICE POSTGIS_IN_SEARCH_METHOD_POSTGIS_1 MBR_OVERLAPS%CONTAINS%DISJOINT%EQUALS%INTERSECTS%OVERLAPS%TOUCHES%WITHIN Search Method: DEFAULT_MACRO POSTGIS_IN_ADVANCED_POSTGIS_1 GUI OPTIONAL DISCLOSUREGROUP POSTGIS_IN_ADVANCED_POSTGIS_1 POSTGIS_IN_FEATURES_PER_FETCH_POSTGIS_1%POSTGIS_IN_BEGIN_SQL_POSTGIS_1%POSTGIS_IN_END_SQL_POSTGIS_1 Advanced DEFAULT_MACRO POSTGIS_IN_FEATURES_PER_FETCH_POSTGIS_1 10000 POSTGIS_1_FEATURES_PER_FETCH "$(POSTGIS_IN_FEATURES_PER_FETCH_POSTGIS_1)" GUI FLOAT POSTGIS_IN_FEATURES_PER_FETCH_POSTGIS_1 Number Of Records To Fetch At A Time DEFAULT_MACRO POSTGIS_IN_BEGIN_SQL_POSTGIS_1 POSTGIS_1_BEGIN_SQL "$(POSTGIS_IN_BEGIN_SQL_POSTGIS_1)" GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_IN_BEGIN_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run Before Read DEFAULT_MACRO POSTGIS_IN_END_SQL_POSTGIS_1 POSTGIS_1_END_SQL "$(POSTGIS_IN_END_SQL_POSTGIS_1)" GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_IN_END_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run After Read # =========================================================================== DEFAULT_MACRO POSTGIS_IN_ATTRIBUTE_READING_POSTGIS_1 DEFLINE_ATTRS POSTGIS_1_ATTRIBUTE_READING "$(POSTGIS_IN_ATTRIBUTE_READING_POSTGIS_1)" DEFAULT_MACRO POSTGIS_IN_SCHEMAS_FOR_TABLE_LISTING_POSTGIS_1 GUI OPTIONAL TEXT POSTGIS_IN_SCHEMAS_FOR_TABLE_LISTING_POSTGIS_1 Schemas for Table Listing: POSTGIS_1_SCHEMAS_FOR_TABLE_LISTING $(POSTGIS_IN_SCHEMAS_FOR_TABLE_LISTING_POSTGIS_1) POSTGIS_1_DATASET "$(SourceDataset_POSTGIS_1)" #!END_SOURCE_HEADER#!START_WB_HEADER#!END_WB_HEADER#!END_HEADER LOG_FILENAME”(FME_MF_DIR) DatabaseJoiner美元。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 Enhanced FME_STROKE_MAX_DEVIATION 0 MAPPING_FILE_ID Example1_StartingWorkspace LOG_TIMINGS YES LOG_FILTER_MASK -1 DEFAULT_MACRO DATASET_KEYWORD_POSTGIS_1 POSTGIS_1 # ------------------------------------------------------------------------- POSTGIS_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME DatabaseJoiner MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD POSTGIS_1 INPUT FEATURE_TYPE * ROUTE POSTGIS POSTGIS_1::AddressPoints TO FME_GENERIC ::AddressPoints ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * POSTGIS_1_MERGE_DEF POSTGIS_1::AddressPoints EXACT AddressPoints DEFLINE postgis_sql_where_clause,,postgis_sql_statement,,AddressId,int4,CivicNo,varchar 16 、StreetName varchar 80 、TaxCoord varchar 8 、SiteId varchar 9 # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FACTORY_DEF * TeeFactory FACTORY_NAME”AddressPoints (POSTGIS_1)分流”输入FEATURE_TYPE AddressPoints输出FEATURE_TYPE AddressPoints_POSTGIS_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -宏DatabaseJoiner_DIRECTIVES NAMED_CONNECTION PostGIS 训练 如果{{MATCH_ALL} == {MATCH_ALL}} {put {MACRO DatabaseJoiner_ONE_FEATURE_PER_JOIN NO};} else {put {MACRO DatabaseJoiner_ONE_FEATURE_PER_JOIN YES};[/ replyview] [/ replyview] [/ replyview] [/ replyview] [/ replyview 训练 数据库“TABLE_ID”公开。PostalAddress" READER_PARAMS $(DatabaseJoiner_DIRECTIVES) JOIN_KEYS AddressId AddressId ADDED_FIELDS国家 LastUpdate OwnerName1 OwnerName2 PostalAddress PostalCity PostalCode PostalProvince SiteAddressKey结合属性PREFER_ORIGINAL MATCH_RULE MATCH_ALL CACHE_SIZE 20000 PREFETCH_QUERY SELECT * 公共 PostalAddress 在哪里 状态 = 当前的 PREFETCH_EXHAUSTIVE是的ONE_FEATURE_PER_JOIN $ (DatabaseJoiner_ONE_FEATURE_PER_JOIN) JOIN_ID“DatabaseJoiner REJECTION_ENABLED是的UNJOINED_ENABLED # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FACTORY_DEF * RoutingFactory FACTORY_NAME“目的地功能类型路由相关器”COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE * 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“最终输出核武器”输入FEATURE_TYPE __nuke_me__