#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
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