#!#!
#!
#!
#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!
#!#!#!#!
#!#!#!#!#!
#!#!
#!#!
#!#!
#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!OutputDimension,ESRISHAPE_STRICT_COMPATIBILITY,"OPTIONAL CHECKBOX Yes%No",ESRISHAPEStrictCompatibility,ESRISHAPE_ADVANCED,"OPTIONAL DISCLOSUREGROUP STRICT_COMPATIBILITY%GEOMETRY",ESRISHAPEAdvanced,ESRISHAPE_GEOMETRY,"OPTIONAL DISCLOSUREGROUP PRESERVE_RING_VERTEX_ORDER%SURFACE_AND_SOLID_STORAGE%MEASURES_AS_Z",ESRISHAPEGeometry,ESRISHAPE_SURFACE_AND_SOLID_STORAGE,"OPTIONAL LOOKUP_CHOICE Multipatch,shape_multipatch%Polygon,shape_polygon",ESRISHAPESurfaceandSolidStorage,ESRISHAPE_WRITE_SPATIAL_INDEX,"OPTIONAL CHECKBOX Yes%No",ESRISHAPEWriteSpatialIndex,ESRISHAPE_ENCODING,"OPTIONAL ENCODING ANSI%SYSTEM%BIG5%EUC%HKBIG5%ISO%OEM%SJIS%UTF-8%CP437%CP708%CP720%CP737%CP775%CP850%CP852%CP855%CP857%CP860%CP861%CP862%CP863%CP864%CP865%CP866%CP869%CP874%CP932%CP936%CP950%CP1250%CP1251%CP1252%CP1253%CP1254%CP1255%CP1256%CP1257%CP1258%ISO8859-1%ISO8859-2%ISO8859-3%ISO8859-4%ISO8859-5%ISO8859-6%ISO8859-7%ISO8859-8%ISO8859-9%ISO-8859-11%ISO8859-13%ISO8859-15%WINDOWS-874",ESRISHAPECharacterEncoding,ESRISHAPE_MEASURES_AS_Z,"OPTIONAL CHOICE yes%no",ESRISHAPETreatMeasuresasElevation,ESRISHAPE_UPPER_CASE_ATTR_NAMES,"OPTIONAL CHECKBOX Yes%No",ESRISHAPEUseUpperCase,ESRISHAPE_COMPRESSED_SHAPE_FILE,"OPTIONAL CHECKBOX Yes%No",ESRISHAPECreateCompressedShapefile.shz,ESRISHAPE_PRESERVE_RING_VERTEX_ORDER,"OPTIONAL CHECKBOX Yes%No",ESRISHAPEPreserveRingVertexOrder,ESRISHAPE_DESTINATION_DATASETTYPE_VALIDATION,"OPTIONAL NO_EDIT TEXT",ESRISHAPE">#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!#!
#!#!
#!#!
#!#!
#!#!Fme_python_version 27 GUI忽略SourceDataset_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1、MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_BEGIN_SQL {0} _MSSQL_SPATIAL_1, MSSQL_SPATIAL_IN_END_SQL {0} _MSSQL_SPATIAL_1, SourceDataset_MSSQL_SPATIAL_2、MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_2、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_2、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2、MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_2、MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_BEGIN_SQL {0} _MSSQL_SPATIAL_2, MSSQL_SPATIAL_IN_END_SQL {0} _MSSQL_SPATIAL_2、SourceDataset_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_3,该软件_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_3、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_3、MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_3、MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_3、MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_3, MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_BEGIN_SQL{0}_MSSQL_SPATIAL_3,MSSQL_SPATIAL_IN_END_SQL{0}_MSSQL_SPATIAL_3 DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL cc-gis1 GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL FMT:MSSQL_SPATIAL%FAMILY:微软
SQL
Server Connection: DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_5 cc-gis1 GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL_5 FMT:MSSQL_SPATIAL%FAMILY:微软
SQL
Server Connection: DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_4 cc-gis1 GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL_4 FMT:MSSQL_SPATIAL%FAMILY:微软
SQL
服务器连接:包含[if{$(SourceDataset_MSSQL_SPATIAL)}=={}{puts_real{Parameter'SourceDataset_MSSQL_SPATIAL'必须给定一个值。};退出1;};]包含[if{$(SourceDataset_MSSQL_SPATIAL_5)}={}{puts_real Parameter'SourceDataset_MSSQL_SPATIAL 5'必须给定一个值。};退出1;};]包含[if{{$(SourceDataset_MSSQL_SPATIAL_4)}={}{puts_real{Parameter'SourceDataset_MSSQL_SPATIAL_4'必须给定一个值。};退出1;]#!开始_HEADER#!开始_WB_HEADER READER_TYPE MULTI_READER_TYPE{0}MSSQL_SPATIAL MULTI_READER_关键字{0}MSSQL_SPATIAL 1 MULTI u READER_GEN 0}命令\u超时,30,搜索\u信封\u最大值,0,MSSQL\u空间\u公开\u格式\u属性,开始\u SQL
0
SEARCH_ENVELOPE_COORDINATE_SYSTEM, READ_CACHE_SIZE 10, END_SQL
0
ASSUME_ONE_SRID_PER_COL, APPLICATION_INTENT,读写,QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS,是的,NAMED_CONNECTION, cc-gis1, HANDLE_MULTIPLE_SPATIAL_COLUMNS,不,USE_SEARCH_ENVELOPE,不,WHERE_CLAUSE_WWJD, SEARCH_ENVELOPE_MINY, 0, PERSISTENT_CONNECTION,不,TABLELIST dbo。Cad_Parcels
dbo。Dev_Adds
dbo。Pub_Downloads
dbo.Trn\U高速公路,高级,搜索信封,最大,0,剪辑到信封,否,合并模式,是,公开属性组,使用使有效,否,搜索信封,0多阅读器类型{1}空多阅读器格式{1}MSSQL空间多阅读器关键字{1}MSSQL空间多阅读器{2多阅读器生成指令{1}命令超时,30,搜索信封,最大,MSSQL\u SPATIAL\u EXPOSE\u FORMAT\u ATTRS,,BEGIN\u SQL
0
SEARCH_ENVELOPE_COORDINATE_SYSTEM, READ_CACHE_SIZE 10, END_SQL
0
ASSUME_ONE_SRID_PER_COL, APPLICATION_INTENT,读写,QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS,是的,NAMED_CONNECTION, cc-gis1, HANDLE_MULTIPLE_SPATIAL_COLUMNS,不,USE_SEARCH_ENVELOPE,不,WHERE_CLAUSE_WWJD, SEARCH_ENVELOPE_MINY, 0, PERSISTENT_CONNECTION,不,TABLELIST, dbo.Com_Towers、先进、SEARCH_ENVELOPE_MAXY, 0, CLIP_TO_ENVELOPE,不,_MERGE_SCHEMAS,是的,世博会E_attrs_group,, use_make_valid, no, search_envele_minx,0 multi_reader_type {2} mssql_spatial multi_reader_keyword {2} mssql_spatial_3 multi_reader_gen_directives {2} search_envele_miny,0, end_sql
0
,d,search_envelope_minx,0,application_indent,readwlite,due_make_valid,no,command_timout_types_for_merge_filters
0
,,高级,, CLIP_TO_ENVELOPE,NO,PERSISTENT_CONNECTION,NO,SEARCH_ENVELOPE_MAXY,0,WHERE_CLAUSE_WWJD ,, _ MERGE_SCHEMAS,YES,MSSQL_SPATIAL_EXPOSE_FORMAT_ATTRS ,, SEARCH_ENVELOPE_MAXX,0,EXPOSE_ATTRS_GROUP ,, HANDLE_MULTIPLE_SPATIAL_COLUMNS,NO,READ_CACHE_SIZE,10 WRITER_TYPE NULL WRITER_KEYWORD NULL_DEST NULL_DEST_DATASET空#!END_WB_HEADER#!start_wb_header宏wb_keyword“mssql_spatial_1”#!END_WB_HEADER#!start_source_header mssql_spatial mssql_spatial_1 ##数据集此映射文件是:#!END_SOURCE_HEADER#!start_wb_header default_macro sourceatataSet包括[if {{$(sourceatataSet)}!=“”} {\ puts {default_macro sourceDataSet_mssql_spatial_1 $(sourceatataset)} \}]#!END_WB_HEADER#!START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_1 DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_1 $(SourceDataset_MSSQL_SPATIAL)GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL_1 FMT:MSSQL_SPATIAL连接:DEFAULT_MACRO MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_1是MSSQL_SPATIAL_1_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS “$(MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_1)” DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_1 GUI可选DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_NAMED_CONNECTION%MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1数据库连接#============================================================================#以下指定是否要创建一个持久连接。 If set # to YES, the connection will remain open until FME is shut down. DEFAULT_MACRO MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1 NO MSSQL_SPATIAL_1_PERSISTENT_CONNECTION "$(MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1)" GUI OPTIONAL CHECKBOX MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1 YES%NO Persistent Connection # Timeout DEFAULT_MACRO MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 30 MSSQL_SPATIAL_1_COMMAND_TIMEOUT "$(MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1)" GUI OPTIONAL INTEGER MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 Command Timeout (Seconds): DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_1 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_TABLELIST%MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_1 Constraints # ============================================================================ # And an optional global WHERE clause DEFAULT_MACRO MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_WHERE_CLAUSE_WWJD "$(MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_1)" GUI OPTIONAL TEXT_EDIT_SQL_CFG MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_1 MODE,WHERE WHERE Clause: # ============================================================================ # bounding box with optional clipping DEFAULT_MACRO MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_EXPOSE_ATTRS_GROUP "$(MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_1)" # 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 MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_1 NO MSSQL_SPATIAL_1_USE_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_1)" GUI ACTIVEDISCLOSUREGROUP MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1%MSSQL_SPATIAL_IN_SEARCH_METHOD%MSSQL_SPATIAL_IN_SEARCH_METHOD_FILTER%MSSQL_SPATIAL_IN_SEARCH_ORDER%MSSQL_SPATIAL_IN_SEARCH_FEATURE%MSSQL_SPATIAL_IN_DUMMY_SEARCH_ENVELOPE_PARAMETER Use Search Envelope # =========================================================================== GUI LOOKUP MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1
,0默认宏MSSQL\U SPATIAL\U IN_SEARCH\u信封\u MINX\u MSSQL\u SPATIAL\u 1 0 MSSQL\u SPATIAL\u SEARCH\u信封“$(MSSQL\u SPATIAL\u IN_SEARCH\u信封\u MINX\u MSSQL\u SPATIAL\u 1)”GUI可选浮动MSSQL\U SPATIAL\U在搜索信封中最小X:\35;==========================================================================================================================================================================================GUI查找MSSQL\U在搜索信封中最小MSSQL\U空间
,0 default_macro mssql_spatial_in_search_envelope miny_mssql_spatial_1 0 mssql_spatial_1_search_envelope "$(mssql_spatial_in_search_envelope miny_mssql_spatial_1)"GUI可选浮MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1最低Y : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1
,0 DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1 0 MSSQL_SPATIAL_1_SEARCH_ENVELOPE “$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1)” GUI OPTIONAL FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1最大X:#=========================================================================== GUI LOOKUP MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1
,0 DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1 0 MSSQL_SPATIAL_1_SEARCH_ENVELOPE “$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1)” GUI应用浮动MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1最大Y:#=========================================================================== gui查找mssql_spatial_in_search_envelope_coords_system_mssql_spatial_1
mssql_spatial_in_search_envele_coordinate_system_mssql_spatial_1 mssql_spatial_1_search_envelope "$(mssql_spatial_in_search_envelope _system_mssql_spatial_1)"GUI可选COORDSYS MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1搜索信封坐标系统 : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1
,没有默认的宏MSSQL\U SPATIAL\U IN\U CLIP\U TO\U信封MSSQL\U SPATIAL\U 1没有MSSQL\U SPATIAL\U CLIP\U TO\U信封“$(MSSQL\U SPATIAL\U IN\U CLIP\U TO\U信封MSSQL\U SPATIAL\U 1)”GUI可选复选框MSSQL\ U SPATIAL\ U IN\ U CLIP\ U TO\ U信封\U MSSQL\ U SPATIAL\ U 1是%NO CLIP搜索信封默认\U宏MSSQL\ U SPATIAL\ U IN\ U高级\U MSSQL\ U SPATIAL\ 1 GUI可选披露组MSSQL\ U SPATIAL\ U IN\ U高级\U MSSQL\ U SPATIAL\ 1空间,空间,空间,词汇,空间,空间,词汇,空间,空间,词汇,空间,空间,词汇,空间,空间,词汇,词汇,词汇,空间,词汇,空间,空间,词汇,空间,空间,词汇,空间,空间,空间,空间,词汇,空间,空间,空间,空间,空间,空间,空间,空间,词汇,空间,空间,空间,空间,空间,空间,空间,读读读读读,读,读,缓存,空间,单词,空间,空间,单词,空间,空间,空间,空间,空间,单词,空间,空间,空间,空间,空间,空间,单词,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,大小,大小,大小,大小,大小,大小,大小,空间,空间,空间,大小,空间,空间,空间,空间,大小,大小,空间,空间,大小,空间,大小,大小,空间,空间,大小,大小,空间,大小,大小,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间_SQL{0}_MSSQL\u SPATIAL\u 1高级默认\u宏MSSQL\u SPATIAL\u应用程序中\u意图\u MSSQL\u SPATIAL\u 1读写MSSQL\u SPATIAL\u应用程序中\u意图“$(MSSQL\u SPATIAL\u应用程序中\u意图\u MSSQL\u SPATIAL\u 1)”GUI选项MSSQL\U SPATIAL\U应用程序中的MSSQL\U意向图MSSQL\U SPATIAL\U 1读写%只读应用程序意向图MSSQL=======================================================================================================================================================================================此关键字控制一次从默认的MSSQL空间提供程序中检索到本地内存中的记录数MSSQL\u SPATIAL\u 1\u READ\u CACHE\u SIZE“$(MSSQL\u SPATIAL\u IN\u READ\u CACHE\u SIZE\u MSSQL\u SPATIAL\u 1)”GUI可选文本MSSQL\u SPATIAL\u IN\u READ\u CACHE\u SIZE\u 1一次要获取的记录数假定正好有一列SRID?默认宏MSSQL\U SPATIAL\U IN\U假设每个列一个SRID\U MSSQL\U SPATIAL\U 1 MSSQL\U SPATIAL\U 1假设每个列一个SRID“$(MSSQL\U SPATIAL\U IN\U假设每个列一个SRID\U MSSQL\U SPATIAL\U 1)”GUI可选选项MSSQL\u SPATIAL\u IN\u假设每个列有一个SRID\u MSSQL\u SPATIAL\u 1是%NO几何体列正好有一个SRID====================================================================================================================================================================================================================================================================================================================================================================================================================================================================================如果设置为“是”,则多个几何图形将被读取到一个集合中#如果设置为“否”,则选择一个几何图形的默认行为将发生默认的(宏MSSQL)空间(多个空间)列(多个空间)列(MSSQL(空间)多个空间)列(MSSQL)空间)列(1)GUI选项MSSQL\u SPATIAL\u IN\u HANDLE\u MULTIPLE\u SPATIAL\u COLUMNS\u MSSQL\u SPATIAL\u 1 YES%NO HANDLE MULTIPLE SPATIAL COLUMNS\n=====================================================================================================================================================================================================================================================================以下指定在使用搜索源读取无效数据时是否使用MakeValid()命令,如果是,可以修改信封,无效数据将变为有效数据;如果有效,将正常读取如果否,无效数据将导致转换失败。默认宏MSSQL\U SPATIAL\U IN\U USE\U MAKE\U SPATIAL\U 1无MSSQL\U SPATIAL\U 1\U USE\U MAKE\U VALID“$(MSSQL\U SPATIAL\U IN\U USE\U MAKE\U VALID\U MSSQL\U SPATIAL\U 1)”GUI选项MSSQL\u SPATIAL\u IN_USE\u MAKE\u VALID\u MSSQL\u SPATIAL\u 1 YES%NO USE MakeValid with Search Envelope\n=============================================================================================================================================================================================================================================================================================================================================================================================================================================。默认的宏MSSQL\u spatical\u IN_BEGIN\u SQL{0}中的MSSQL\u SPATIAL\u 1 MSSQL\u SPATIAL\u BEGIN\u SQL{0}中的MSSQL\u SPATIAL\u IN_BEGIN\u SQL{0}中的MSSQL\u空间\u 1)“GUI可选文本\u BEGIN\u SQL\u MSSQL\u spatical\u IN_BEGIN\u SQL{0}中的编辑\u SQL\u MSSQL\u空间\u,SQL;FORMAT,MSSQL\u读取前要运行的空间SQL============================================================================================================================================================================================================以下指定关闭所有表后要执行的SQL命令。默认的宏MSSQL\u spatical\u IN_END_SQL{0}中的MSSQL\u spatical\u 1 MSSQL\u spatical\u 1_END_SQL{0}中的MSSQL\u spatical\u IN_END_SQL{0}中的MSSQL\u spatical\u中的GUI可选文本\u CFG编辑\u SQL\u MSSQL\u spatical\u IN_END_SQL{0}模式,SQL;格式,MSSQL#u空间SQL在读取后运行#=================================================================================================================================================================================默认宏MSSQL_空间U在(U属性)读取(MSSQL)MSSQL(空间1)属性)====================================================================================================================================================MSSQL\u SPATIAL\u 1\u生成\u FME\u构建数量18567 MSSQL\u SPATIAL\u数据集“$(SourceDataset\u MSSQL\u SPATIAL\u 1)”!结束源头!START_WB_头宏WB_关键字“MSSQL_SPATIAL_2”#!结束(WB)(u头#)!!START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_2#生成此映射文件的数据集是:#!结束源头!START_WB_HEADER DEFAULT_MACRO SourceDataset INCLUDE[if{{{$(SourceDataset)}!=“”}{\put{DEFAULT_MACRO SourceDataset_MSSQL_spatical_2$(SourceDataset)}\}]#!结束(WB)(u头#)!!启动\u源\u头MSSQL\u空间MSSQL\u空间\u 2默认\u宏源数据集\u MSSQL\u空间\u 2$(源数据集\u MSSQL\u空间\u 5)名为\u DB\u连接\u编码源数据集\u MSSQL\u空间\u 2 FMT的GUI:MSSQL\u空间AL Connection: DEFAULT_MACRO MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_2 Yes MSSQL_SPATIAL_2_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS "$(MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_2)" DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_2 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_NAMED_CONNECTION%MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_2 Database Connection # ============================================================================ # The following specifies whether to create a persistent connection. If set # to YES, the connection will remain open until FME is shut down. DEFAULT_MACRO MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_2 NO MSSQL_SPATIAL_2_PERSISTENT_CONNECTION "$(MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_2)" GUI OPTIONAL CHECKBOX MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_2 YES%NO Persistent Connection # Timeout DEFAULT_MACRO MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_2 30 MSSQL_SPATIAL_2_COMMAND_TIMEOUT "$(MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_2)" GUI OPTIONAL INTEGER MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_2 Command Timeout (Seconds): DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_2 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_TABLELIST%MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_2 Constraints # ============================================================================ # And an optional global WHERE clause DEFAULT_MACRO MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_WHERE_CLAUSE_WWJD "$(MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_2)" GUI OPTIONAL TEXT_EDIT_SQL_CFG MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_2 MODE,WHERE WHERE Clause: # ============================================================================ # bounding box with optional clipping DEFAULT_MACRO MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_EXPOSE_ATTRS_GROUP "$(MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_2)" # 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 MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_2 NO MSSQL_SPATIAL_2_USE_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_2)" GUI ACTIVEDISCLOSUREGROUP MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_SEARCH_METHOD%MSSQL_SPATIAL_IN_SEARCH_METHOD_FILTER%MSSQL_SPATIAL_IN_SEARCH_ORDER%MSSQL_SPATIAL_IN_SEARCH_FEATURE%MSSQL_SPATIAL_IN_DUMMY_SEARCH_ENVELOPE_PARAMETER Use Search Envelope # =========================================================================== GUI LOOKUP MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_2
,0默认宏MSSQL\U SPATIAL\U IN_SEARCH\U ENVEL\U MINX\U MSSQL\U SPATIAL\U 2 0 MSSQL\U SPATIAL\U SEARCH\U ENVEL“$(MSSQL\U SPATIAL\U IN_SEARCH\U ENVEL\U MINX\U MSSQL\U SPATIAL\U 2)”GUI可选浮动MSSQL\U SPATIAL\U在搜索信封中最小X:\35;=============================================================================================================================================================================================GUI查找MSSQL\U在搜索信封中最小MSSQL\U空间
,0 default_macro mssql_spatial_in_search_envelope miny_mssql_spatial_2 0 mssql_spatial_2_search_envelope "$(mssql_spatial_in_search_envelope miny_mssql_spatial_2)"GUI可选浮MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_2最低Y : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_2
,0 default_macro mssql_spatial_in_search_envelope maxx_mssql_spatial_2 0 mssql_spatial_2_search_envelope "$(mssql_spatial_in_search_envelope maxx_mssql_spatial_2)"GUI可选浮MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_2最大X : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_2
,0默认\u宏MSSQL\u空间\u在搜索\u信封中\u最大\u MSSQL\u空间\u 2 0 MSSQL\u空间\u 2搜索\u信封“$(MSSQL\u空间\u在搜索\u信封中\u最大\u MSSQL\u空间\u 2)”GUI可选浮动MSSQL(空间)在搜索信封中最大Y:#======================================================================================================================================================================================================GUI查找MSQL(空间)在搜索信封坐标系中MSSQL(空间)
, default_macro mssql_spatial_in_search_envele_coordinate_system_mssql_spatial_2 mssql_spatial_2_search_envelope "GUI可选COORDSYS MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_2搜索信封坐标系统 : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2
,NO DEFAULT_MACRO MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2 NO MSSQL_SPATIAL_2_CLIP_TO_ENVELOPE “$(MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2)” GUI OPTIONAL CHECKBOX MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_2 YES%没有剪辑到搜索包络DEFAULT_MACRO MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_2 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_2 MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_BEGIN_SQL {0} _MSSQL_SPATIAL_2%MSSQL_SPATIAL_IN_END_SQL {0} _MSSQL_SPATIAL_2高级DEFAULT_MACRO MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_2读写MSSQL_SPATIAL_2_APPLICATION_INTENT “$(MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_2)” GUI CHOICE MSSQL_SPATIAL_IN_APPLICATION_INTENT_MSSQL_SPATIAL_2读写%只读应用程序意向#============================================================================#此关键字控制多少条记录检索一次到从提供者本地#内存DEFAULT_MACROMSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_2 10 MSSQL_SPATIAL_2_READ_CACHE_SIZE “$(MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_2)” GUI可选TEXT MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_2号码记录,以获取在时间#============================================================================#假设该几何列有一个确切的SRID?DEFAULT_MACRO MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_ASSUME_ONE_SRID_PER_COL “$(MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_2)” GUI可选CHOICE MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_2 YES NO%几何列有一个确切的SRID#============================================================================#以下指定是否维护多个几何形状或没有。#如果设置为YES,则多个几何将被读入一个聚合#如果否,选择一个几何形状将发生DEFAULT_MACRO MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_2 NO MSSQL_SPATIAL_2_HANDLE_MULTIPLE_SPATIAL_COLUMNS“$(MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_2)” GUI CHOICE MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_2 YES%NO处理多个空间列的默认行为#============================================================================#下面指定是否与搜索包络读取#当使用MakeValid()命令,可以修改无效源数据#如果是,无效数据进行有效; if valid will be read normally. # If NO, invalid data will cause the translation to fail. DEFAULT_MACRO MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_2 NO MSSQL_SPATIAL_2_USE_MAKE_VALID "$(MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_2)" GUI CHOICE MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_2 YES%NO Use MakeValid with Search Envelope # ============================================================================ # The following specifies an SQL command to execute before opening the first # table. DEFAULT_MACRO MSSQL_SPATIAL_IN_BEGIN_SQL{0}_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_BEGIN_SQL{0} "$(MSSQL_SPATIAL_IN_BEGIN_SQL{0}_MSSQL_SPATIAL_2)" GUI OPTIONAL TEXT_EDIT_SQL_CFG MSSQL_SPATIAL_IN_BEGIN_SQL{0}_MSSQL_SPATIAL_2 MODE,SQL;FORMAT,MSSQL_SPATIAL SQL To Run Before Read # ============================================================================ # The following specifies an SQL command to execute after closing all the # tables. DEFAULT_MACRO MSSQL_SPATIAL_IN_END_SQL{0}_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_END_SQL{0} "$(MSSQL_SPATIAL_IN_END_SQL{0}_MSSQL_SPATIAL_2)" GUI OPTIONAL TEXT_EDIT_SQL_CFG MSSQL_SPATIAL_IN_END_SQL{0}_MSSQL_SPATIAL_2 MODE,SQL;FORMAT,MSSQL_SPATIAL SQL To Run After Read # ============================================================================ DEFAULT_MACRO MSSQL_SPATIAL_IN_ATTRIBUTE_READING_MSSQL_SPATIAL_2 DEFLINE_ATTRS MSSQL_SPATIAL_2_ATTRIBUTE_READING "$(MSSQL_SPATIAL_IN_ATTRIBUTE_READING_MSSQL_SPATIAL_2)" # ============================================================================ MSSQL_SPATIAL_2_GENERATE_FME_BUILD_NUM 18567 MSSQL_SPATIAL_2_DATASET "$(SourceDataset_MSSQL_SPATIAL_2)" #! END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "MSSQL_SPATIAL_3" #! END_WB_HEADER #! START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_3 # 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_MSSQL_SPATIAL_3 $(SourceDataset)} \ } ] #! END_WB_HEADER #! START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_3 DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_3 $(SourceDataset_MSSQL_SPATIAL_4) GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL_3 FMT:MSSQL_SPATIAL Connection: DEFAULT_MACRO MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_3 Yes MSSQL_SPATIAL_3_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS "$(MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_3)" DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_3 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_CONNECTION_GROUP_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_NAMED_CONNECTION%MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_3 Database Connection # ============================================================================ # The following specifies whether to create a persistent connection. If set # to YES, the connection will remain open until FME is shut down. DEFAULT_MACRO MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_3 NO MSSQL_SPATIAL_3_PERSISTENT_CONNECTION "$(MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_3)" GUI OPTIONAL CHECKBOX MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_3 YES%NO Persistent Connection # Timeout DEFAULT_MACRO MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_3 30 MSSQL_SPATIAL_3_COMMAND_TIMEOUT "$(MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_3)" GUI OPTIONAL INTEGER MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_3 Command Timeout (Seconds): DEFAULT_MACRO MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_3 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_FME_GROUP_NAMED1_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_TABLELIST%MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_3 Constraints # ============================================================================ # And an optional global WHERE clause DEFAULT_MACRO MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_3 MSSQL_SPATIAL_3_WHERE_CLAUSE_WWJD "$(MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_3)" GUI OPTIONAL TEXT_EDIT_SQL_CFG MSSQL_SPATIAL_IN_WHERE_CLAUSE_WWJD_MSSQL_SPATIAL_3 MODE,WHERE WHERE Clause: # ============================================================================ # bounding box with optional clipping DEFAULT_MACRO MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_3 MSSQL_SPATIAL_3_EXPOSE_ATTRS_GROUP "$(MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_3)" # 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 MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_3 NO MSSQL_SPATIAL_3_USE_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_3)" GUI ACTIVEDISCLOSUREGROUP MSSQL_SPATIAL_IN_USE_SEARCH_ENVELOPE_MSSQL_SPATIAL_3 MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_3%MSSQL_SPATIAL_IN_SEARCH_METHOD%MSSQL_SPATIAL_IN_SEARCH_METHOD_FILTER%MSSQL_SPATIAL_IN_SEARCH_ORDER%MSSQL_SPATIAL_IN_SEARCH_FEATURE%MSSQL_SPATIAL_IN_DUMMY_SEARCH_ENVELOPE_PARAMETER Use Search Envelope # =========================================================================== GUI LOOKUP MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_3
,0 default_macro mssql_spatial_in_search_envele_minx_mssql_spatial_3 0 mssql_spatial_3_search_envelope "$(mssql_spatial_in_search_envele_minx_mssql_spatial)"GUI可选浮MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_3最小X : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_3
,0默认值\u宏MSSQL\u空间\u搜索中的信封\u最小\u MSSQL\u空间\u 3 0 MSSQL\u空间\u 3搜索中的信封“$(MSSQL\u空间\u搜索中的信封\u最小\u MSSQL\u空间\u 3)”GUI可选浮动MSSQL\U SPATICAL\U在搜索信封中最小Y:#=======================================================================================================================================================================================GUI查找MSSQL\U在搜索信封中最大X MSSQL\U空间3
,0 default_macro mssql_spatial_in_search_envelope maxx_mssql_spatial_3 0 mssql_spatial_3_search_envelope "$(mssql_spatial_in_search_envelope maxx_mssql_spatial_3)"GUI可选浮MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_3最大X : # =========================================================================== GUI查找MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_3
,0默认宏MSSQL\U SPATIAL\U IN_SEARCH\u ENVELOPE\u MAXY\u MSSQL\u SPATIAL\u 3 0 MSSQL\u SPATIAL\u SEARCH\u ENVELOPE“$(MSSQL\u SPATIAL\u IN_SEARCH\u ENVELOPE\u MAXY\u MSSQL\u SPATIAL\u 3)“GUI可选浮动MSSQL\u空间\u在搜索信封中\u最大Y:#==============================================================================================================================================================================================================================GUI查找MSSQL\u空间\u在搜索信封中\u坐标系U MSSQL\u空间\u 3
,默认的宏MSSQL\u空间\u在搜索\u包络线\u坐标系\u MSSQL\u空间\u 3 MSSQL\u空间\u搜索\u包络线“$(MSSQL\u空间\u在搜索\u包络线\u坐标系\u MSSQL\u空间\u 3)”GUI可选COORDSYS MSSQL_SPATIAL_IN_SEARCH_信封_坐标系_MSSQL_SPATIAL_3 SEARCH信封坐标系:#
,没有默认的宏MSSQL\U SPATIAL\U IN\U CLIP\U TO\U信封MSSQL\U SPATIAL\U 3没有MSSQL\U SPATIAL\U CLIP\U TO\U信封“$(MSSQL\U SPATIAL\U IN\U CLIP\U TO\U信封MSSQL\U SPATIAL\U 3)”GUI可选复选框MSSQL\u SPATIAL\u IN_CLIP\u TO_ENVELOPE\u MSSQL\u SPATIAL\u 3 YES%NO CLIP TO Search ENVELOPE默认值\u宏MSSQL\u SPATIAL\u IN_ADVANCED\u MSSQL\u SPATIAL\u 3 GUI可选披露组MSSQL\u SPATIAL\u IN_ADVANCED\u MSSQL\u SPATIAL\u 3空间,空间,空间,词汇,空间,空间,词汇,空间,空间,空间,词汇,空间,空间,空间,空间,在读,缓存,缓存,缓存,大小大小大小,词汇,空间,空间,空间,空间,空间,空间,空间,词汇,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,内存,空间,图片,空间,空间,空间,空间,空间,大小,空间,空间,大小,空间,空间,空间,空间,空间,空间,空间,大小,空间,空间,空间,空间,空间,空间,空间,空间,空间,空间,大小,空间,空间,空间,大小,空间,空间,空间,空间,空间,空间,大小,空间,空间,空间,大小,空间,大小,空间,空间,空间,大小,大小,大小,大小,空间,大小,空间,空间,空间,空间,大小,空间,空间,空间,空间,空间,空间,空间,空间,空间,_SQL{0}_MSSQL\u SPATIAL\u 3高级默认值\u宏MSSQL\u SPATIAL\u应用程序中的\u意图\u MSSQL\u SPATIAL\u 3读写MSSQL\u SPATIAL\u应用程序中的\u意图“$(MSSQL\u SPATIAL\u应用程序中的\u意图\u MSSQL\u SPATIAL\u 3)”GUI选项MSSQL\U SPATIAL\U应用程序中的MSSQL\U意向图MSSQL\U SPATIAL\U 3读写%只读应用程序意向图此关键字控制一次从默认提供程序中检索到本地内存的记录数MSSQL\U SPATIAL\U大小缓存中的MSSQL\U宏MSSQL\u SPATIAL\u 3\u READ\u CACHE\u SIZE“$(MSSQL\u SPATIAL\u IN\u READ\u CACHE\u SIZE\u MSSQL\u SPATIAL\u 3)”GUI可选文本MSSQL\u SPATIAL\u IN\u READ\u CACHE\u SIZE\u 3一次要获取的记录数假定正好有一列SRID?默认宏MSSQL\U SPATIAL\U IN\U ASSUE\U一个SRID\U每个列MSSQL\U SPATIAL\U 3 MSSQL\U SPATIAL\U 3\U ASSUE\U一个SRID\U每个列“$(MSSQL\U SPATIAL\U IN\U ASSUE\U一个SRID\U每个列MSSQL\U SPATIAL\U 3)”GUI可选选项MSSQL\u SPATIAL\u IN\u假设每个列有一个SRID\u MSSQL\u SPATIAL\u 3是%NO几何体列正好有一个SRID====================================================================================================================================================================================================================================================================================================================================================================================================================================================================================如果设置为“是”,则多个几何图形将被读取到一个集合中#如果设置为“否”,则选择一个几何图形的默认行为将出现默认的(宏MSSQL)空间(多个空间)列(MSSQL)空间(3)处理(多个空间)列(MSSQL)3)GUI选项MSSQL\u SPATIAL\u IN\u HANDLE\u MULTIPLE\u SPATIAL\u COLUMNS\u MSSQL\u SPATIAL\u 3 YES%NO HANDLE MULTIPLE SPATIAL COLUMNS\n==========================================================================================================================================================================================================================================以下指定在读取带有搜索源的数据时是否使用MakeValid()命令,如果是,可以修改信封,无效数据将变为有效数据;如果有效,将正常读取如果否,无效数据将导致转换失败。默认宏MSSQL\U SPATIAL\U IN\U USE\U MAKE\U SPATIAL\U 3无MSSQL\U SPATIAL\U 3\U USE\U MAKE\U VALID“$(MSSQL\U SPATIAL\U IN\U USE\U MAKE\U VALID\U MSSQL\U SPATIAL\U 3)”GUI选项MSSQL\u SPATIAL\u IN_USE\u MAKE\u VALID\u MSSQL\u SPATIAL\u 3 YES%NO USE MakeValid with Search Envelope======================================================================================================================================================================================================================================================================================================================================================================================================以下指定在打开第一个表之前要执行的SQL命令。默认的宏MSSQL\u spatical\u IN_BEGIN\u SQL{0}_MSSQL\u SPATIAL\u 3 MSSQL\u BEGIN\u SQL{0}(MSSQL\u SPATIAL\u IN_BEGIN\u SQL{0}_MSSQL\u SPATIAL\u 3)GUI可选文本\u编辑\u SQL\u MSSQL\u spatical\u IN_BEGIN\u SQL{0}模式,SQL;FORMAT,MSSQL\u读取前要运行的空间SQL============================================================================================================================================================================================================以下指定关闭所有表后要执行的SQL命令。默认宏MSSQL\u spatical\u IN_END_SQL{0}中的MSSQL\u SPATIAL\u 3 MSSQL\u SPATIAL\u 3_END_SQL{0}中的MSSQL\u SPATIAL\u IN_END_SQL{0}中的MSSQL\u SPATIAL\u 3)“GUI可选文本编辑_SQL\u MSSQL\u spatical\u IN_END_SQL{0}模式,SQL;格式,MSSQL#u空间SQL在读取后运行#====================================================================================================================================================================================默认宏MSSQL_空间_属性中的MSSQL_读取===MSSQL(空间=========3定义属性中的MSSU=======================================================================================================================================================MSSQL\u SPATIAL\u 3\u生成\u FME\u构建数量18567 MSSQL\u SPATIAL\u 3\u数据集“$(SourceDataset\u MSSQL\u SPATIAL\u 3)”!结束源头!开始_WB_头#!!结束(WB)(u头#)!!结束\u头日志\u文件名“$(FME\u MF\u目录)数据\u下载\u创建者\u 2.LOG”日志附加无日志过滤器掩码-1日志最大值功能200日志最大值记录功能200 FME重投影引擎FME FME隐式CSMAP重投影模式自动FME几何处理增强FME笔划最大偏差0默认宏数据集关键字MSSQL空间MSSQL空间MSSQL空间MSSQL 1默认宏数据集关键字MSSQL空间MSSQL 2默认的宏数据集关键字MSSQL空间MSSQL空间MSSQL空间MSSQLIAL_1_READER_META_ATTRIBUTES fme_feature_type fme_basename # ------------------------------------------------------------------------- MSSQL_SPATIAL_2_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MSSQL_SPATIAL_3_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME Data_Download_Creator_2 MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.Pub_Downloads multi_reader_keyword,$(DATASET_KEYWORD_MSSQL_SPATIAL_1) TO FME_GENERIC ::dbo.Pub_Downloads ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_3::dbo.Ele_Precincts2011 multi_reader_keyword,$(DATASET_KEYWORD_MSSQL_SPATIAL_3) TO FME_GENERIC ::dbo.Ele_Precincts2011 ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.Trn_Highways EXACT dbo.Trn_Highways MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.Cad_Parcels EXACT dbo.Cad_Parcels MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.Dev_Adds EXACT dbo.Dev_Adds MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.Pub_Downloads EXACT dbo.Pub_Downloads DEFLINE mssql_where_clause_wwjd,,Pub_DownloadID,identity,TableName,nvarchar
50
,描述,nvarchar
One hundred.
,Enabled,bit MSSQL_SPATIAL_2_MERGE_DEF MSSQL_SPATIAL_2::dbo.Com_Towers EXACT dbo.Com_Towers MSSQL_SPATIAL_3_MERGE_DEF MSSQL_SPATIAL_3::dbo。Ele_Precincts2011确切dbo。Ele_Precincts2011 DEFLINE mssql_where_clause_wwjd, GID,整数,PRCT_NUM,整数,PRCT_NAME varchar
50
BOS,整数,大学,整数,摩根大通,整数,USER_MOD varchar
24
TS, varchar
24
YMAX XMIN,整数,整数,XMAX,整数,YMIN,整数,ENC_GEOMETRY,形象 # ------------------------------------------------------------------------- dbo FACTORY_DEF * TeeFactory FACTORY_NAME”。cad_parcel (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo. txt "。cad_包裹输出FEATURE_TYPE dbo。Cad_Parcels_MSSQL_SPATIAL_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.Dev_Adds (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.Dev_Adds OUTPUT FEATURE_TYPE dbo.Dev_Adds_MSSQL_SPATIAL_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.Trn_Highways (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.Trn_Highways OUTPUT FEATURE_TYPE dbo.Trn_Highways_MSSQL_SPATIAL_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.Pub_Downloads (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.Pub_Downloads OUTPUT FEATURE_TYPE dbo.Pub_Downloads_MSSQL_SPATIAL_1 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.Com_Towers (MSSQL_SPATIAL_2) Splitter" INPUT FEATURE_TYPE dbo.Com_Towers OUTPUT FEATURE_TYPE dbo.Com_Towers_MSSQL_SPATIAL_2 # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.Ele_Precincts2011 (MSSQL_SPATIAL_3) Splitter" INPUT FEATURE_TYPE dbo.Ele_Precincts2011 OUTPUT FEATURE_TYPE dbo.Ele_Precincts2011_MSSQL_SPATIAL_3 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- MACRO OUTPUT_AREA_FTYPE not_selected MACRO OUTPUT_AREA_FTYPE GeometryFilter_AREA MACRO OUTPUT_INSTANCE_FTYPE not_selected Lookup GeometryFilter_RouterTable "" "not_selected" fme_area $(OUTPUT_AREA_FTYPE) MACRO COLLECTION_HANDLING NOT_THIS_TIME MACRO INSTANCE_FILTERING * INCLUDE [ if 0 { puts "MACRO COLLECTION_HANDLING *"; if
{MACRO INSTANCE_FILTERING NOT_THIS_TIME;};};if {{$(OUTPUT_INSTANCE_FTYPE)} == "not_selected"} {puts "MACRO INSTANCE_FILTERING NOT_THIS_TIME";};[FACTORY_DEF * tefactory FACTORY_NAME GeometryFilter_InputPassThrough INPUT FEATURE_TYPE dbo.]Ele_Precincts2011_MSSQL_SPATIAL_3输出FEATURE_TYPE GeometryFilter___Input___ @Geometry (FIX_FMETYPE_FMEGEOMETRY) FACTORY_DEF美元(INSTANCE_FILTERING) TestFactory FACTORY_NAME GeometryFilter_InstanceTest输入FEATURE_TYPE GeometryFilter___Input___测试@Geometry (IS_GEOMETRY_INSTANCE) = = 1的输出通过FEATURE_TYPE美元(OUTPUT_INSTANCE_FTYPE)输出FAILED FEATURE_TYPE GeometryFilter___Input___ FACTORY_DEF $(COLLECTION_HANDLING) TestFactory FACTORY_NAME GeometryFilter_CollectionTest INPUT FEATURE_TYPE GeometryFilter___Input___ TEST &fme_type == "fme_collection" OUTPUT FAILED FEATURE_TYPE GeometryFilter___Not_Collection___ OUTPUT PASSED FEATURE_TYPE GeometryFilter___Collection___ FACTORY_DEF$(COLLECTION_HANDLING) DeaggregateFactory FACTORY_NAME GeometryFilter_Deagg INPUT FEATURE_TYPE geometryfilter__collection___ HOMOGENIZE_COLLECTIONS YES RECURSIVE YES SET_FME_TYPE YES INSTANTIATE_GEOMETRY_INSTANCES_NEW
输出点FEATURE_TYPE GeometryFilter___HomogeneousAggregate___ OUTPUT LINE FEATURE_TYPE GeometryFilter___HomogeneousAggregate___ OUTPUT POLYGON FEATURE_TYPE GeometryFilter___HomogeneousAggregate___ OUTPUT DONUT FEATURE_TYPE GeometryFilter___HomogeneousAggregate___ OUTPUT AGGREGATE FEATURE_TYPE GeometryFilter___HomogeneousAggregate___FACTORY_DEF * TeeFactory FACTORY_NAME GeometryFilter_RouterPrepper输入FEATURE_TYPE GeometryFilter___HomogeneousAggregate___输入FEATURE_TYPE GeometryFilter___Not_Collection___输入FEATURE_TYPE GeometryFilter___Input___输出FEATURE_TYPE GeometryFilter___Prepped___ GeometryFilter_4e0fadb5_bc68_4df1_a786_8a22c4f2f9584_targetFeatureType@Lookup(GeometryFilter_RouterTable,&fme_type) FACTORY_DEF * TestFactory FACTORY_NAME GeometryFilter_Router INPUT FEATURE_TYPE geometryfilter__prepped___ TEST @Value(GeometryFilter_4e0fadb5_bc68_4df1_a786_8a22c4f2f9584_targetFeatureType) != "not_selected" OUTPUT PASSED FEATURE_TYPE * . *@FeatureType(@Value(@Value(GeometryFilter_4e0fadb5_bc68_4df1_a786_8a22c4f2f9584_targetFeatureType)
@RemoveAttributes(GeometryFilter_4e0fadb5_bc68_4df1_a786_8a22c4f2f9584_targetFeatureType) FACTORY_DEF * tefactory FACTORY_NAME "几何形过滤器
变压器输出Nuker“输入Feature_type GeometryFilter_
#---------------------------------------------------------------FACTORY\u DEF{*}AttrSetFactory\u NAME AttributeCreator\u 5命令\u PARM\u求值单通输入功能\u TYPE GeometryFilter\u区域多功能\u模式无空\u ATTR\u模式无\u OP ATTRSET\u创建\u指令\u传播\u FDIV ATTR\u操作{“fme\u basename”设置为“Ele_Discincts2011”}输出输出特征_类型属性创建器_5_输出35;----------------------------------------------------------------工厂_定义{*}AttrSetFactory命令\u PARM\u求值单次\u PASS FACTORY\u NAME attributeNamer\u 5输入功能\u TYPE AttributeCreator\u 5\u输出ATTRSET\u创建\u指令\u传播\u缺少\u FDIV ATTR\u操作{“fme\u basename”Tbl\u NAME“RENAME\u SET\u DEFAULT”}输出输出功能\类型属性名称\类型5 \输出\类型-------------------------------------------------------------------工厂\定义*测试工厂\名称已启用\是\否输入功能\类型dbo.Pub \下载\ MSSQL \空间\ 1测试@EvaluateExpression(FDIV,字符串\编码,
价值
启用
,Enabled_Yes_No) = Yes ENCODED boolean operator OR OUTPUT PASSED FEATURE_TYPE Enabled_Yes_No_PASSED FACTORY_DEF * TeeFactory FACTORY_NAME "Enabled_Yes_No PASSED Splitter" INPUT FEATURE_TYPE enabled_yes_no_passsed_0_vi0zod9sulw = OUTPUT FEATURE_TYPE enabled_yes_no_passsed_1_3pjfrhiqwu8 = OUTPUT FEATURE_TYPEEnabled_Yes_No_PASSED_2_FCnsvBx1Pcc =输出FEATURE_TYPE Enabled_Yes_No_PASSED_3_5lTyzqVuVt0 =输出FEATURE_TYPE Enabled_Yes_No_PASSED_4_WaIP + co /德吴 = # ------------------------------------------------------------------------- 包括(如果{{GEOM_AND_ATTRS} = ={属性}}{所说的“宏观FeatureMerger_3_REFERENCE_INFO属性”;} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD} && {
}={POLYGONS}{puts“宏特征合并”{3\u参考”{INFO GEOM\u BUILD\u POLYS”}elseif{{GEOM\u和{U ATTRS}=={GEOM\u BUILD}&{
} == {aggregate}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO geom_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD} && {
}={LINESFROMPOINTS}{puts“宏功能合并\u 3\u引用\u INFO GEOM\u从\u点构建\u线”}elseif{GEOM\u和\u ATTRS}={GEOM\u和\u ATTRS}&&{
} == {polygon}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO geom_and_attr_build_polyys ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS} && {
} == {aggregate}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO geom_and_attr_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS} && {
} == {LINESFROMPOINTS}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO GEOM_AND_ATTR_BUILD_LINES_FROM_POINTS";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO geom_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS}} {puts "MACRO FeatureMerger_3_REFERENCE_INFO geom_and_attr_build_aggregate ";其他}{};{*} ReferenceFactory FACTORY_NAME FeatureMerger_3 INPUT REFERENCER FEATURE_TYPE AttributeRenamer_5_OUTPUT INPUT referenceee FEATURE_TYPE Enabled_Yes_No_PASSED_4_WaIP+co/DEU= REFERENCE_INFO $(FeatureMerger_3_REFERENCE_INFO) REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED,
价值
tbl_name.
FeatureMerger_3) @EvaluateExpression (FDIV STRING_ENCODED,
价值
的表
,功能合并\u 3)自动属性累积模式“处理冲突”属性冲突\u RES“请求者如果冲突”忽略\u NULLS“否”处理\u NULL \u缺少\u键\u如\u FME2013没有要包含的属性列表{
} LIST_ATTRS_TO_INCLUDE_MODE
MERGE_ATTRIBUTES Yes MANAGE_FME_TYPE Yes MODE COMPLETE PROCESS_DUPLICATE_REFERENCEES NO REFERENCEES_FIRST NO REJECT_INVALID_GEOM Yes CLEANING_TOLERANCE
输出完整FEATURE_TYPE FeatureMerger_3_MERGED # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator_4 COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE dbo.Com_Towers_MSSQL_SPATIAL_2 MULTI_FEATURE_MODE没有NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES_PROPAGATE_MISSING_FDIV ATTR_ACTION{”““fme_basename”“SET_TO”“Com_Towers”}输出输出FEATURE_TYPE AttributeCreator_4_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory COMMAND_PARM_EVALUATION SINGLE_PASS FACTORY_NAME AttributeRenamer输入FEATURE_TYPE AttributeCreator_4_OUTPUTATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION { "fme_basename" "Tbl_Name" "RENAME_SET_DEFAULT" "" } OUTPUT OUTPUT FEATURE_TYPE AttributeRenamer_OUTPUT # ------------------------------------------------------------------------- INCLUDE [if { {GEOM_AND_ATTRS} == {ATTRIBUTES} } { puts "MACRO FeatureMerger_2_REFERENCE_INFO ATTRIBUTES"; } elseif { {GEOM_AND_ATTRS} == {GEOM_BUILD} && {
} == {polygon}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_build_polyys ";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD} && {
} == {aggregate}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD} && {
} == {LINESFROMPOINTS}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO GEOM_BUILD_LINES_FROM_POINTS";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS} && {
} == {polygon}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_and_attr_build_polyys ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS} && {
} == {aggregate}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_and_attr_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS} && {
} == {LINESFROMPOINTS}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO GEOM_AND_ATTR_BUILD_LINES_FROM_POINTS";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_AND_ATTRS}} {puts "MACRO FeatureMerger_2_REFERENCE_INFO geom_and_attr_build_aggregate ";其他}{};{*} ReferenceFactory FACTORY_NAME FeatureMerger_2 INPUT REFERENCER FEATURE_TYPE AttributeRenamer_OUTPUT INPUT REFERENCEE FEATURE_TYPE Enabled_Yes_No_PASSED_0_vI0zOd9SUlw= REFERENCE_INFO $(FeatureMerger_2_REFERENCE_INFO) REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED,
价值
tbl_name.
,FeatureMerge_2)@EvaluateExpression(FDIV,字符串编码,
价值
的表
,FeatureMerger_2) 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 Yes MANAGE_FME_TYPE Yes MODE COMPLETE PROCESS_DUPLICATE_REFERENCEES NO REFERENCEES_FIRST NO REJECT_INVALID_GEOM Yes CLEANING_TOLERANCE
输出完整FEATURE_TYPE FeatureMerger_2_MERGED # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE dbo。Trn_Highways_MSSQL_SPATIAL_1 MULTI_FEATURE_MODE没有NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION{”““fme_basename”“SET_TO”“Trn_Highways”}输出输出FEATURE_TYPE AttributeCreator_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactoryCOMMAND_PARM_EVALUATION SINGLE_PASS FACTORY_NAME AttributeRenamer_4 INPUT FEATURE_TYPE AttributeCreator_OUTPUT ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION {"fme_basename" "Tbl_Name" "RENAME_SET_DEFAULT" ""} OUTPUT OUTPUT FEATURE_TYPE AttributeRenamer_4_OUTPUT # .------------------------------------------------------------------------- FACTORY_DEF {*} FeatureJoinerFactory FACTORY_NAME Trn_Highways INPUT LEFT FEATURE_TYPE Enabled_Yes_No_PASSED_3_5lTyzqVuVt0= INPUT RIGHT FEATURE_TYPE AttributeRenamer_4_OUTPUT JOIN_MODE Inner JOIN_KEYS TableName Tbl_Name AUTO ATTR_CONFLICT_RES USE_LEFT GEOMETRY_HANDLINGUSE_LEFT输出加入FEATURE_TYPE Trn_Highways_JOINED # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeCreator_2 COMMAND_PARM_EVALUATION SINGLE_PASS输入FEATURE_TYPE dbo。Dev_Adds_MSSQL_SPATIAL_1 MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION { "" "fme_basename" "SET_TO" "Dev_Adds" } OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_2_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF {*} AttrSetFactory COMMAND_PARM_EVALUATION SINGLE_PASS FACTORY_NAME AttributeRenamer_2 INPUT FEATURE_TYPE AttributeCreator_2_OUTPUT ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ATTR_ACTION { "fme_basename" "Tbl_Name" "RENAME_SET_DEFAULT" "" } OUTPUT OUTPUT FEATURE_TYPE AttributeRenamer_2_OUTPUT # ------------------------------------------------------------------------- INCLUDE [if { {GEOM_AND_ATTRS} == {ATTRIBUTES} } { puts "MACRO FeatureMerger_REFERENCE_INFO ATTRIBUTES"; } elseif { {GEOM_AND_ATTRS} == {GEOM_BUILD} && {
}={POLYGONS}}{puts“宏特征合并参考信息几何构建”}elseif{{GEOM}和{ATTRS}={GEOM\u构建}&&{
} == {aggregate}} {puts "MACRO FeatureMerger_REFERENCE_INFO geom_build_aggregate ";} elseif {{GEOM_AND_ATTRS} == {GEOM_BUILD} && {
}={LINESFROMPOINTS}{puts“宏功能合并\u参考\u信息几何\u从点构建线”}elseif{GEOM\u和\u属性}={GEOM\u和\u属性}&{
}={POLYGONS}}{put“宏特性合并”{GEOM}和{ATTR}构建{u poly}{GEOM}和{ATTRS}={GEOM}和{ATTRS}&{
}={AGGREGATES}{puts“宏特性合并”{GEOM\U参考信息GEOM\U和ATTR\U构建集合”}elseif{GEOM\U和ATTR}={GEOM\U和ATTR}&{
} == {lineSfromopoints}} {puts“宏efturemerger_reference_info geom_and_attr_build_lines_from_points”;} elsef {{geom_and_attrs} == {geom_build}} {puts“macro featuremerger_reference_info geom_build_aggregates”;} elsef {{geom_and_attrs} == {geom_and_attrs}} {puts“macro featuremerger_reference_info geom_and_attr_build_aggregates”;其他}{};] Factory_Def {*} CapicentFactory Factory_name FeatureMerger输入引用程序Feature_Type Attributerenamer_2_Output输入Refeucte_type Enabled_yes_no_passed_1_3pjfrhiqwu8 = Reference_info $(featuremerger_reference_info)Reference_table @EvaluateExpression(FDIV,String_Encoded,
价值
tbl_name.
,FeatureMerge)@EvaluateExpression(FDIV,字符串编码,
价值
的表
,FeatureMerger)AUTO ATTR_ACCUM_MODE “HANDLE_CONFLICT” ATTR_CONFLICT_RES “REQUESTOR_IF_CONFLICT” IGNORE_NULLS “否” HANDLE_NULL_MISSING_KEYS_LIKE_FME2013没有LIST_ATTRS_TO_INCLUDE {
} LIST_ATTRS_TO_INCLUDE_MODE
MERGE_ATTRIBUTES Yes MANAGE_FME_TYPE Yes MODE COMPLETE PROCESS_DUPLICATE_REFERENCEES NO REFERENCEES_FIRST NO REJECT_INVALID_GEOM Yes CLEANING_TOLERANCE
输出完整特征U类型特征合并U合并35;----------------------------------------------------------------工厂定义{*}属性工厂名称属性创建器3命令参数评估单次输入特征类型dbo.Cad\u地块类型MSSQL\u空间特征1多个特征模式无空属性模式无属性集创建指令传播缺少FDIV属性操作{“fme\u basename”设置为“Cad\u地块”}输出输出功能\u类型属性创建器\u 3\u输出属性集\u创建\u指令\u传播\u缺失\u FDIV属性操作{“fme_basename”“Tbl_Name”“RENAME_SET_DEFAULT”“}输出特性_TYPE attributeNamer_3_OUTPUT#------------------------------------------工厂定义{*}FeatureJoinerFactory\u NAME Cad\u Parcels INPUT LEFT FEATURE\u TYPE Enabled\u Yes\u No\u PASSED\u 2\u FCnsvBx1Pcc=INPUT RIGHT FEATURE\u TYPE AttributeNamer\u 3\u OUTPUT JOIN\u MODE内部JOIN\u KEYS TableName Tbl\u NAME AUTO ATTR\u CONFLICT\u使用左几何图形\u处理使用左输出连接特征\u TYPE Cad\u Parcels\u JOINED\u-------------------------------------------------------------------------包括[puts{DEFAULT_宏特性编写器数据集_特性编写器@EvaluateExpression(FDIV,字符串编码,
cc-gis1
ITGIS
Data_Download
下载
价值
tbl_name.
. zip, FeatureWriter)};] FACTORY_DEF * WriterFactory FACTORY_NAME FeatureWriter WRITER_TYPE ESRISHAPE WRITER_DATASET "$(FeatureWriterDataset_FeatureWriter)"WRITER_SETTINGS RUNTIME_MACROS, UPPER_CASE_ATTR_NAMES
没有
编码
系统
WRITE_SPATIAL_INDEX
没有
压缩的形状文件
没有
维
二维
先进的
FME_公开
STRICT_COMPATIBILITY
是的
几何
FME_公开
PRESERVE_RING_VERTEX_ORDER
没有
DESTINATION_DATASETTYPE_VALIDATION
是的
SURFACE_AND_SOLID_STORAGE
shape_multipatch
测量值
否,图元文件,ESRISHAPE编写器图元文件属性大小写,任意,属性无效字符,。
-%
!?*
ATTRIBUTE_LENGTH 10 ATTR_TYPE_MAP, char
宽度
弗梅·瓦查尔
宽度
字符
宽度
fme_varbinary
宽度
字符
宽度
fme_char
宽度
字符
宽度
fme_二进制
宽度
字符
254
fme_缓冲器
字符
254
fme_二进制缓冲区
字符
254
fme_xml
字符
254
fme_json
字符
20
fme_datetime
字符
12
fme_时间
日期
fme_date
双
fme_real64
数字
31
15
fme_real64
双
fme_uint32
数字
11
0
fme_uint32
浮动
fme_real32
数字
15
7.
fme_real32
数字
20
0
fme_int64.
数字
20
0
fme_uint64
必然的
fme_布尔
短的
fme_int16
数字
6.
0
fme_int16
短的
fme_int8
数字
4.
0
fme_int8
短的