#! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! GUI IGNORE SourceDataset_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_SERVER_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_USER_NAME_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_PASSWORD_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_USE_SSPI_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_WHERE_CLAUSE_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_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1,DestDataset_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_SERVER_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_USER_NAME_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_PASSWORD_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_USE_SSPI_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_SPATIAL_TYPE_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_SPATIAL_COLUMN_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_WRITER_MODE_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_START_TRANSACTION_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_TRANSACTION_INTERVAL_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_BEGIN_SQL_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_END_SQL_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_INIT_TABLES_MSSQL_SPATIAL_2,MSSQL_SPATIAL_OUT_ORIENT_POLYGONS_MSSQL_SPATIAL_2 DEFAULT_MACRO WHERE GUI OPTIONAL TEXT WHERE WHERE Clause: #! START_HEADER #! START_WB_HEADER READER_TYPE MSSQL_SPATIAL READER_KEYWORD MSSQL_SPATIAL_1 READER_GEN_DIRECTIVES USE_SSPI,YES,WHERE_CLAUSE,,USER_NAME,Unused,PASSWORD,Unused,USE_SEARCH_ENVELOPE,NO,SEARCH_ENVELOPE_MINX,0,_MERGE_SCHEMAS,YES,SEARCH_ENVELOPE_MAXY,0,TABLELIST,dbo.General,SEARCH_ENVELOPE_MAXX,0,CLIP_TO_ENVELOPE,No,SERVER,MAY,SEARCH_ENVELOPE_MINY,0 WRITER_TYPE MULTI_WRITER MULTI_WRITER_DATASET_ORDER BY_ID MULTI_WRITER_FIRST_WRITER_ID 0 MULTI_WRITER_TYPE{0} MSSQL_SPATIAL MULTI_WRITER_KEYWORD{0} MSSQL_SPATIAL_2 #! END_WB_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "MSSQL_SPATIAL_1" #! END_WB_HEADER #! START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_1 # ============================================================================ # First get the dataset for the database. For SQL, it's the database name. # For now we'll use whatever they had when they generated this mapping file, # and not reprompt # 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_1 $(SourceDataset)} \ } ] #! END_WB_HEADER #! START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_1 DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_1 KenyaFME GUI Text SourceDataset_MSSQL_SPATIAL_1 Source Microsoft SQL Server Spatial Name: # ============================================================================ # The ADO provider in use. For SQL Server, this is always MSSQL_ADO DEFAULT_MACRO MSSQL_SPATIAL_IN_PROVIDER_TYPE_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_PROVIDER_TYPE "$(MSSQL_SPATIAL_IN_PROVIDER_TYPE_MSSQL_SPATIAL_1)" # ============================================================================ # The location of the server (e.g.SERVERNAME,SERVERNAME\INSTANCE) DEFAULT_MACRO MSSQL_SPATIAL_IN_SERVER_MSSQL_SPATIAL_1 MAY MSSQL_SPATIAL_1_SERVER "$(MSSQL_SPATIAL_IN_SERVER_MSSQL_SPATIAL_1)" GUI TEXT MSSQL_SPATIAL_IN_SERVER_MSSQL_SPATIAL_1 Server: # ============================================================================ # Username required if USE_SSPI is NO DEFAULT_MACRO MSSQL_SPATIAL_IN_USER_NAME_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_USER_NAME "$(MSSQL_SPATIAL_IN_USER_NAME_MSSQL_SPATIAL_1)" GUI TEXT MSSQL_SPATIAL_IN_USER_NAME_MSSQL_SPATIAL_1 Username: # ============================================================================ # Password, required if USE_SSPI is NO DEFAULT_MACRO MSSQL_SPATIAL_IN_PASSWORD_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_PASSWORD "$(MSSQL_SPATIAL_IN_PASSWORD_MSSQL_SPATIAL_1)" GUI PASSWORD MSSQL_SPATIAL_IN_PASSWORD_MSSQL_SPATIAL_1 Password: # ============================================================================ # Use Windows Authentication? DEFAULT_MACRO MSSQL_SPATIAL_IN_USE_SSPI_MSSQL_SPATIAL_1 YES MSSQL_SPATIAL_1_USE_SSPI "$(MSSQL_SPATIAL_IN_USE_SSPI_MSSQL_SPATIAL_1)" GUI ACTIVECHECK MSSQL_SPATIAL_IN_USE_SSPI_MSSQL_SPATIAL_1 YES,MSSQL_SPATIAL_IN_USER_NAME,MSSQL_SPATIAL_IN_PASSWORD%NO Use Windows Authentication # ============================================================================ # And an optional global WHERE clause DEFAULT_MACRO MSSQL_SPATIAL_IN_WHERE_CLAUSE_MSSQL_SPATIAL_1 $(WHERE) MSSQL_SPATIAL_1_WHERE_CLAUSE "$(MSSQL_SPATIAL_IN_WHERE_CLAUSE_MSSQL_SPATIAL_1)" GUI OPTIONAL TEXT MSSQL_SPATIAL_IN_WHERE_CLAUSE_MSSQL_SPATIAL_1 WHERE Clause: # ============================================================================ # bounding box with optional clipping # Zero as a default means we don't do any search -- this makes workbench happier # =========================================================================== DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1 0 MSSQL_SPATIAL_1_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1)" GUI FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1 Minimum X: # =========================================================================== 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 FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1 Minimum Y: # =========================================================================== 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 FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1 Maximum X: # =========================================================================== 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 FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1 Maximum Y: # =========================================================================== DEFAULT_MACRO MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1 No MSSQL_SPATIAL_1_CLIP_TO_ENVELOPE "$(MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1)" GUI CHECKBOX MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1 YES%NO Clip to Search Envelope # ============================================================================ # Search Envelope Coordinate System DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1 GUI OPTIONAL COORDSYS MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1 Search Envelope Coordinate System: MSSQL_SPATIAL_1_SEARCH_ENVELOPE_COORDINATE_SYSTEM "$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1)" # ============================================================================ # This keyword controls how many records to retrieve at one time into local # memory from the provider DEFAULT_MACRO MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1 10 GUI OPTIONAL TEXT MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1 Number Of Records To Fetch At A Time: MSSQL_SPATIAL_1_READ_CACHE_SIZE $(MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1) # ============================================================================ # Command time out. Indicates in seconds, how long to wait for a command # (sqlquery) to execute before terminating the attempt and generating an error. DEFAULT_MACRO MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 GUI OPTIONAL TEXT MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 Command Timeout (Seconds): MSSQL_SPATIAL_1_COMMAND_TIMEOUT "$(MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1)" # ============================================================================ # Assume that geometry columns have exactly one SRID? DEFAULT_MACRO MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1 GUI OPTIONAL CHOICE MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1 YES%NO Geometry Columns Have Exactly One SRID: MSSQL_SPATIAL_1_ASSUME_ONE_SRID_PER_COL "$(MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1)" # ============================================================================ # 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_1 NO GUI CHOICE MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1 YES%NO Make Connection Persistent: MSSQL_SPATIAL_1_PERSISTENT_CONNECTION $(MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1) MSSQL_SPATIAL_1_DATASET "$(SourceDataset_MSSQL_SPATIAL_1)" #! END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "MSSQL_SPATIAL_2" #! END_WB_HEADER #! START_DEST_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_2 # ============================================================================ # First get the dataset for the database. For SQL, it's the database name. # For now we'll use whatever they had when they generated this mapping file, # and not reprompt #! END_DEST_HEADER #! START_WB_HEADER DEFAULT_MACRO DestDataset INCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_MSSQL_SPATIAL_2 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_2 DEFAULT_MACRO DestDataset_MSSQL_SPATIAL_2 TileCache GUI Text DestDataset_MSSQL_SPATIAL_2 Destination Microsoft SQL Server Spatial Name: # ============================================================================ # The ADO provider in use. For SQL Server, this is always MSSQL_ADO DEFAULT_MACRO MSSQL_SPATIAL_OUT_PROVIDER_TYPE_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_PROVIDER_TYPE "$(MSSQL_SPATIAL_OUT_PROVIDER_TYPE_MSSQL_SPATIAL_2)" # ============================================================================ # The location of the server (e.g.SERVERNAME,SERVERNAME\INSTANCE) DEFAULT_MACRO MSSQL_SPATIAL_OUT_SERVER_MSSQL_SPATIAL_2 MAY MSSQL_SPATIAL_2_SERVER "$(MSSQL_SPATIAL_OUT_SERVER_MSSQL_SPATIAL_2)" GUI TEXT MSSQL_SPATIAL_OUT_SERVER_MSSQL_SPATIAL_2 Server: # ============================================================================ # Username required if USE_SSPI is NO DEFAULT_MACRO MSSQL_SPATIAL_OUT_USER_NAME_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_USER_NAME "$(MSSQL_SPATIAL_OUT_USER_NAME_MSSQL_SPATIAL_2)" GUI TEXT MSSQL_SPATIAL_OUT_USER_NAME_MSSQL_SPATIAL_2 Username: # ============================================================================ # Password required if SSPI is NO DEFAULT_MACRO MSSQL_SPATIAL_OUT_PASSWORD_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2_PASSWORD "$(MSSQL_SPATIAL_OUT_PASSWORD_MSSQL_SPATIAL_2)" GUI PASSWORD MSSQL_SPATIAL_OUT_PASSWORD_MSSQL_SPATIAL_2 Password: # ============================================================================ # Use Windows Authentication? DEFAULT_MACRO MSSQL_SPATIAL_OUT_USE_SSPI_MSSQL_SPATIAL_2 YES MSSQL_SPATIAL_2_USE_SSPI "$(MSSQL_SPATIAL_OUT_USE_SSPI_MSSQL_SPATIAL_2)" GUI ACTIVECHECK MSSQL_SPATIAL_OUT_USE_SSPI_MSSQL_SPATIAL_2 YES,MSSQL_SPATIAL_OUT_USER_NAME,MSSQL_SPATIAL_OUT_PASSWORD%NO Use Windows Authentication # ============================================================================ # Write geometry (planar) or geography (geodetic) by default? DEFAULT_MACRO MSSQL_SPATIAL_OUT_SPATIAL_TYPE_MSSQL_SPATIAL_2 geometry MSSQL_SPATIAL_2_SPATIAL_TYPE "$(MSSQL_SPATIAL_OUT_SPATIAL_TYPE_MSSQL_SPATIAL_2)" GUI LOOKUP_CHOICE MSSQL_SPATIAL_OUT_SPATIAL_TYPE_MSSQL_SPATIAL_2 Geometry,geometry%Geography,geography Spatial Type: # ============================================================================ # Default spatial column name DEFAULT_MACRO MSSQL_SPATIAL_OUT_SPATIAL_COLUMN_MSSQL_SPATIAL_2 Geometry MSSQL_SPATIAL_2_SPATIAL_COLUMN "$(MSSQL_SPATIAL_OUT_SPATIAL_COLUMN_MSSQL_SPATIAL_2)" GUI OPTIONAL TEXT MSSQL_SPATIAL_OUT_SPATIAL_COLUMN_MSSQL_SPATIAL_2 Spatial Column: # ============================================================================ # This keyword sets the mode of the writer DEFAULT_MACRO MSSQL_SPATIAL_OUT_WRITER_MODE_MSSQL_SPATIAL_2 UPDATE GUI CHOICE MSSQL_SPATIAL_OUT_WRITER_MODE_MSSQL_SPATIAL_2 INSERT%UPDATE%DELETE Writer Mode: MSSQL_SPATIAL_2_WRITER_MODE $(MSSQL_SPATIAL_OUT_WRITER_MODE_MSSQL_SPATIAL_2) # ============================================================================ # This keyword sets the starting transaction DEFAULT_MACRO MSSQL_SPATIAL_OUT_START_TRANSACTION_MSSQL_SPATIAL_2 0 GUI OPTIONAL TEXT MSSQL_SPATIAL_OUT_START_TRANSACTION_MSSQL_SPATIAL_2 Start transaction at: MSSQL_SPATIAL_2_START_TRANSACTION $(MSSQL_SPATIAL_OUT_START_TRANSACTION_MSSQL_SPATIAL_2) # ============================================================================ # This keyword sets the number of features between transaction commits DEFAULT_MACRO MSSQL_SPATIAL_OUT_TRANSACTION_INTERVAL_MSSQL_SPATIAL_2 500 GUI OPTIONAL TEXT MSSQL_SPATIAL_OUT_TRANSACTION_INTERVAL_MSSQL_SPATIAL_2 Transaction interval: MSSQL_SPATIAL_2_TRANSACTION_INTERVAL $(MSSQL_SPATIAL_OUT_TRANSACTION_INTERVAL_MSSQL_SPATIAL_2) # ============================================================================ # The following specifies an SQL command to execute before opening the first # table. DEFAULT_MACRO MSSQL_SPATIAL_OUT_BEGIN_SQL_MSSQL_SPATIAL_2 GUI OPTIONAL TEXT_EDIT_SQL MSSQL_SPATIAL_OUT_BEGIN_SQL_MSSQL_SPATIAL_2 SQL Statement to Execute Before Translation: MSSQL_SPATIAL_2_BEGIN_SQL{0} "$(MSSQL_SPATIAL_OUT_BEGIN_SQL_MSSQL_SPATIAL_2)" # ============================================================================ # The following specifies an SQL command to execute after closing all the # tables. DEFAULT_MACRO MSSQL_SPATIAL_OUT_END_SQL_MSSQL_SPATIAL_2 GUI OPTIONAL TEXT_EDIT_SQL MSSQL_SPATIAL_OUT_END_SQL_MSSQL_SPATIAL_2 SQL Statement to Execute After Translation: MSSQL_SPATIAL_2_END_SQL{0} "$(MSSQL_SPATIAL_OUT_END_SQL_MSSQL_SPATIAL_2)" # ============================================================================ # The following specifies when we should perform table initialization. # Table initialization is when we DROP, TRUNCATE, and CREATE TABLE. DEFAULT_MACRO MSSQL_SPATIAL_OUT_INIT_TABLES_MSSQL_SPATIAL_2 FIRSTFEATURE GUI OPTIONAL CHOICE MSSQL_SPATIAL_OUT_INIT_TABLES_MSSQL_SPATIAL_2 FIRSTFEATURE%IMMEDIATELY Initialize Tables: MSSQL_SPATIAL_2_INIT_TABLES "$(MSSQL_SPATIAL_OUT_INIT_TABLES_MSSQL_SPATIAL_2)" # ============================================================================ # Fix polygon orientations when writing geodetic (geography) data? DEFAULT_MACRO MSSQL_SPATIAL_OUT_ORIENT_POLYGONS_MSSQL_SPATIAL_2 YES GUI CHOICE MSSQL_SPATIAL_OUT_ORIENT_POLYGONS_MSSQL_SPATIAL_2 YES%NO Orient Polygons: MSSQL_SPATIAL_2_ORIENT_POLYGONS "$(MSSQL_SPATIAL_OUT_ORIENT_POLYGONS_MSSQL_SPATIAL_2)" MSSQL_SPATIAL_2_DATASET "$(DestDataset_MSSQL_SPATIAL_2)" #! END_DEST_HEADER #! END_HEADER LOG_FILENAME "$(FME_MF_DIR)MosaicDuplicatesWithDelete.log" LOG_APPEND NO LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 LOG_FILTER_MASK -1 DEFAULT_MACRO DATASET_KEYWORD_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1 DEFAULT_MACRO DATASET_KEYWORD_MSSQL_SPATIAL_2 MSSQL_SPATIAL_2 # ------------------------------------------------------------------------- MSSQL_SPATIAL_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME MosaicDuplicatesWithDelete MACRO FME_VIEWER_APP fmeview # ------------------------------------------------------------------------- MSSQL_SPATIAL_1_DEF TileCache mssql_sql_statement "" mssql_where_clause "" Quadkey bigint Raster image # ------------------------------------------------------------------------- Lookup ___KnownFeatureTypes___ TileCache yes "" no # ------------------------------------------------------------------------- FACTORY_DEF * TestFactory FACTORY_NAME "Unexpected Input Remover" INPUT FEATURE_TYPE * TEST @Lookup(___KnownFeatureTypes___,@FeatureType()) == yes OUTPUT PASSED FEATURE_TYPE * # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Source -> Generic" INPUT FEATURE_TYPE * OUTPUT FEATURE_TYPE * @Transform(MSSQL_SPATIAL,FME_GENERIC,ALIAS_GEOMETRY) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "TileCache (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE TileCache OUTPUT FEATURE_TYPE TileCache_0 OUTPUT FEATURE_TYPE TileCache_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- FACTORY_DEF * RasterMosaicFactory FACTORY_NAME RasterMosaicker INPUT FEATURE_TYPE TileCache_0 GROUP_BY Quadkey ACCUMULATE_ATTRIBUTES yes NODATA_OVERWRITE No INTERPOLATION_TYPE_NAME Bicubic COMPOSITE_USING_ALPHA_BAND yes SNAPPING_TYPE RESAMPLE MERGE_PALETTES Yes OUTPUT MOSAICKED FEATURE_TYPE RasterMosaicker_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME AttributeCreator_2 INPUT FEATURE_TYPE RasterMosaicker_OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_2_OUTPUT @SupplyAttributes(ENCODED,fme_db_operation,INSERT) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME AttributeCreator INPUT FEATURE_TYPE TileCache_1 OUTPUT FEATURE_TYPE AttributeCreator_OUTPUT @SupplyAttributes(ENCODED,fme_db_operation,DELETE) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeCreator_OUTPUT -> NewFeatureType Correlator" INPUT FEATURE_TYPE AttributeCreator_OUTPUT OUTPUT FEATURE_TYPE __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id 0 @Transform(FME_GENERIC,MSSQL_SPATIAL) @SupplyAttributes(fme_template_feature_type,NewFeatureType) @CopyAttributes(__wb_out_feat_type__,fme_feature_type) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeCreator_2_OUTPUT -> NewFeatureType Correlator" INPUT FEATURE_TYPE AttributeCreator_2_OUTPUT OUTPUT FEATURE_TYPE __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id 0 @Transform(FME_GENERIC,MSSQL_SPATIAL) @SupplyAttributes(fme_template_feature_type,NewFeatureType) @CopyAttributes(__wb_out_feat_type__,fme_feature_type) # ------------------------------------------------------------------------- FACTORY_DEF * TestFactory FACTORY_NAME "Final Output Feature Type Router" INPUT FEATURE_TYPE * TEST @Value(__wb_out_feat_type__) != "" OUTPUT PASSED FEATURE_TYPE * @FeatureType(@Value(__wb_out_feat_type__)) # ------------------------------------------------------------------------- MSSQL_SPATIAL_2_DEF_TEMPLATE NewFeatureType mssql_update_key_columns Quadkey,Raster mssql_drop_table NO mssql_truncate_table NO mssql_table_writer_mode UPDATE mssql_geom_column Geography fme_schema_readers MSSQL_SPATIAL_1 Quadkey bigint Raster image