#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
#!
GUI IGNORE SourceDataset_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1,IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1,IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1,SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1,DestDataset_ORACLE8I_1,ORACLE8I_OUT_USER_NAME_ORACLE8I_1,ORACLE8I_OUT_PASSWORD_ORACLE8I_1,_START_TRANSACTION_ORACLE8I_1,_CHUNK_SIZE_ORACLE8I_1,_TRANSACTION_INTERVAL_ORACLE8I_1,_BEGIN_SQL_ORACLE8I_1,_END_SQL_ORACLE8I_1,_STRICT_ATTR_CONVERSION_ORACLE8I_1,_WRITER_MODE_ORACLE8I_1,_ORACLE8I_Workspace_ORACLE8I_1,_ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1
DEFAULT_MACRO SourceDataset_IDRISI C:\FMEData\Data\Emergency\e911_facilities.vct
GUI MULTIFILE SourceDataset_IDRISI IDRISI_Vector_Files(*.vct)|*.vct|IDRISI_Link_Files(*.vlx)|*.vlx|All_Files|*.* Source IDRISI Vector Format File(s):
DEFAULT_MACRO DestDataset_ORACLE8I bpmal
GUI TEXT DestDataset_ORACLE8I Destination Oracle Spatial Object Service:
INCLUDE TCL
proc __FME_ExpandMacros {text {maxlevels 100}} {
if { $maxlevels <= 0 } { return $text; }
set pattern [join {{\$} {\([^()$]*\)}} {}]
set indices [regexp -inline -all -indices $pattern $text]
if [llength $indices] {
foreach pair [lreverse $indices] {
lassign $pair start end
set replacement {}
set replacement $::FME_MacroValues([string range $text [expr $start + 2] [expr $end - 1]])
set text [string replace $text $start $end $replacement]
}
return [__FME_ExpandMacros $text [expr $maxlevels - 1]]
}
return $text
}
proc __FME_ExpandEnvVars {text {maxlevels 100}} {
if { $maxlevels <= 0 } { return $text; }
set pattern [join {{\$} {\{[^\{\}$]*\}}} {}]
set indices [regexp -inline -all -indices $pattern $text]
if [llength $indices] {
foreach pair [lreverse $indices] {
lassign $pair start end
set replacement {}
set replacement $::env([string range $text [expr $start + 2] [expr $end - 1]])
set text [string replace $text $start $end $replacement]
}
return [__FME_ExpandEnvVars $text [expr $maxlevels - 1]]
}
return $text
}
proc __FME_EvalAndEncodeMacro {macroName} {
set macroVal {}
catch { set macroVal [__FME_ExpandMacros $::FME_MacroValues($macroName)] }
catch { set macroVal [__FME_ExpandEnvVars $macroVal] }
return [FME_EncodeText $macroVal]
}
END_INCLUDE
INCLUDE [ puts "MACRO SourceDataset_IDRISI__FMEENCODED__ [__FME_EvalAndEncodeMacro SourceDataset_IDRISI]" ; ]
INCLUDE [ puts "MACRO DestDataset_ORACLE8I__FMEENCODED__ [__FME_EvalAndEncodeMacro DestDataset_ORACLE8I]" ; ]
INCLUDE [ if {{$(SourceDataset_IDRISI)} == {}} { puts_real {Parameter 'SourceDataset_IDRISI' must be given a value.}; exit 1; }; ]
INCLUDE [ if {{$(DestDataset_ORACLE8I)} == {}} { puts_real {Parameter 'DestDataset_ORACLE8I' must be given a value.}; exit 1; }; ]
#! START_HEADER
#! START_WB_HEADER
READER_TYPE IDRISI
READER_KEYWORD IDRISI_1
READER_GEN_DIRECTIVES IDRISI_EXPOSE_FORMAT_ATTRS,,SEARCH_ENVELOPE_MAXX,0,CLIP_TO_ENVELOPE,NO,USE_SEARCH_ENVELOPE,NO,SEARCH_ENVELOPE_MINX,0,SEARCH_ENVELOPE_MINY,0,_MERGE_SCHEMAS,YES,SEARCH_ENVELOPE_MAXY,0
WRITER_TYPE ORACLE8I
WRITER_KEYWORD ORACLE8I_1
#! END_WB_HEADER
#! START_WB_HEADER
MACRO WB_KEYWORD "IDRISI_1"
#! END_WB_HEADER
#! START_SOURCE_HEADER IDRISI IDRISI_1
# ============================================================================
# The following GUI line prompts for a directory to be used as the
# source of the IDRISI files.
# The user input is stored in a macro, which is then used to define
# the dataset to be read.
# 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_IDRISI_1 $(SourceDataset)} \
} ]
#! END_WB_HEADER
#! START_SOURCE_HEADER IDRISI IDRISI_1
DEFAULT_MACRO SourceDataset_IDRISI_1 $(SourceDataset_IDRISI)
GUI MULTIFILE SourceDataset_IDRISI_1 IDRISI_Vector_Files(*.vct)|*.vct|IDRISI_Link_Files(*.vlx)|*.vlx|All_Files|*.* Source IDRISI Vector Format File(s):
# Include this file in source setting section to add external search envelope processing
# Zero as a default means we don't do any search -- this makes workbench happier
# ===========================================================================
DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1 0
IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1)"
GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MINX_IDRISI_1 Minimum X:
# ===========================================================================
DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1 0
IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1)"
GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MINY_IDRISI_1 Minimum Y:
# ===========================================================================
DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1 0
IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1)"
GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MAXX_IDRISI_1 Maximum X:
# ===========================================================================
DEFAULT_MACRO IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1 0
IDRISI_1_SEARCH_ENVELOPE "$(IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1)"
GUI OPTIONAL FLOAT IDRISI_IN_SEARCH_ENVELOPE_MAXY_IDRISI_1 Maximum Y:
# ===========================================================================
# BUG18999: We now have a soft clip to fall back on like native spatial index
# thus we are reintroducing the clip to envelop as an option for users.
# Defualt to soft clip as per the existing database readers we are emulating
DEFAULT_MACRO IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1 NO
IDRISI_1_CLIP_TO_ENVELOPE "$(IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1)"
GUI OPTIONAL CHECKBOX IDRISI_IN_CLIP_TO_ENVELOPE_IDRISI_1 YES%NO Clip to Search Envelope
# PR:31021
# Include this file in workbench source preamble section to enable the ability
# to specify a coordinate system for search envelope processing
# ===========================================================================
DEFAULT_MACRO SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1
GUI OPTIONAL COORDSYS SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1 Search Envelope Coordinate System:
IDRISI_1_SEARCH_ENVELOPE_COORDINATE_SYSTEM "$(SEARCH_ENVELOPE_COORDINATE_SYSTEM_IDRISI_1)"
# ===========================================================================
IDRISI_1_DATASET "$(SourceDataset_IDRISI_1)"
#! END_SOURCE_HEADER
#! START_WB_HEADER
MACRO WB_KEYWORD "ORACLE8I_1"
#! END_WB_HEADER
#! START_DEST_HEADER ORACLE8I ORACLE8I_1
# ============================================================================
# The following GUI line prompts for the name of the Oracle Service
# to which data will be written.
#! END_DEST_HEADER
#! START_WB_HEADER
DEFAULT_MACRO DestDataset
INCLUDE [ if {"$(DestDataset)" != ""} { \
puts {DEFAULT_MACRO DestDataset_ORACLE8I_1 $(DestDataset)} \
} ]
#! END_WB_HEADER
#! START_DEST_HEADER ORACLE8I ORACLE8I_1
DEFAULT_MACRO DestDataset_ORACLE8I_1 $(DestDataset_ORACLE8I)
GUI TEXT DestDataset_ORACLE8I_1 Destination Oracle Spatial Object Service:
DEFAULT_MACRO _ORACLE8I_Tolx_ORACLE8I_1 0.05
DEFAULT_MACRO _ORACLE8I_Toly_ORACLE8I_1 0.05
DEFAULT_MACRO _ORACLE8I_Tolz_ORACLE8I_1 0.05
DEFAULT_MACRO _ORACLE8I_Tolm_ORACLE8I_1 0.05
DEFAULT_MACRO _ORACLE8I_CreationParams_ORACLE8I_1
DEFAULT_MACRO _ORACLE8I_SRID_ORACLE8I_1
DEFAULT_MACRO _ORACLE8I_SpatialIndexName_ORACLE8I_1
DEFAULT_MACRO _ORACLE8I_ForceIndexCreation_ORACLE8I_1 No
DEFAULT_MACRO _ORACLE8I_TargetGeometryColumn_ORACLE8I_1
DEFAULT_MACRO _ORACLE8I_UpdateGeometry_ORACLE8I_1 Yes
DEFAULT_MACRO _ORACLE8I_DropTable_ORACLE8I_1 No
DEFAULT_MACRO _ORACLE8I_TruncateTable_ORACLE8I_1 No
DEFAULT_MACRO _ORACLE8I_Measures_ORACLE8I_1 No
DEFAULT_MACRO _ORACLE8I_CustomSQL_ORACLE8I_1
DEFAULT_MACRO _ORACLE8I_SequencedColumns_ORACLE8I_1
ORACLE8I_1_SERVER_TYPE ORACLE8i
# ============================================================================
# ============================================================================
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_USER_NAME_ORACLE8I_1 robyn
ORACLE8I_1_USER_NAME "$(ORACLE8I_OUT_USER_NAME_ORACLE8I_1)"
GUI OPTIONAL TEXT ORACLE8I_OUT_USER_NAME_ORACLE8I_1 Username:
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_PASSWORD_ORACLE8I_1 robyn
ORACLE8I_1_PASSWORD "$(ORACLE8I_OUT_PASSWORD_ORACLE8I_1)"
GUI OPTIONAL PASSWORD ORACLE8I_OUT_PASSWORD_ORACLE8I_1 Password:
# ============================================================================
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_DIMENSION_ORACLE8I_1 2
ORACLE8I_1_DIMENSION "$(ORACLE8I_OUT_DIMENSION_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_CONTAINS_MEASURES_ORACLE8I_1 NO
ORACLE8I_1_CONTAINS_MEASURES "$(ORACLE8I_OUT_CONTAINS_MEASURES_ORACLE8I_1)"
# cannot use LOOKUP_GLOBAL here because it assumes any parameter set to 0 in the destination
# parameters are parameters that was not set and prevent user from performing translations
# in UT
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINX_ORACLE8I_1 -180
ORACLE8I_1_SPATIAL_INDEX_MINX "$(ORACLE8I_OUT_SPATIAL_INDEX_MINX_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINY_ORACLE8I_1 -90
ORACLE8I_1_SPATIAL_INDEX_MINY "$(ORACLE8I_OUT_SPATIAL_INDEX_MINY_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINZ_ORACLE8I_1 0
ORACLE8I_1_SPATIAL_INDEX_MINZ "$(ORACLE8I_OUT_SPATIAL_INDEX_MINZ_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MINM_ORACLE8I_1 0
ORACLE8I_1_SPATIAL_INDEX_MINM "$(ORACLE8I_OUT_SPATIAL_INDEX_MINM_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXX_ORACLE8I_1 180
ORACLE8I_1_SPATIAL_INDEX_MAXX "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXX_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXY_ORACLE8I_1 90
ORACLE8I_1_SPATIAL_INDEX_MAXY "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXY_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXZ_ORACLE8I_1 0
ORACLE8I_1_SPATIAL_INDEX_MAXZ "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXZ_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_SPATIAL_INDEX_MAXM_ORACLE8I_1 0
ORACLE8I_1_SPATIAL_INDEX_MAXM "$(ORACLE8I_OUT_SPATIAL_INDEX_MAXM_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_GEOMETRY_COLUMN_ORACLE8I_1 GEOM
ORACLE8I_1_GEOMETRY_COLUMN "$(ORACLE8I_OUT_GEOMETRY_COLUMN_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_CREATE_SPATIAL_INDEX_ORACLE8I_1 no
ORACLE8I_1_CREATE_SPATIAL_INDEX "$(ORACLE8I_OUT_CREATE_SPATIAL_INDEX_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_INDEX_LEVELS_ORACLE8I_1 0
ORACLE8I_1_INDEX_LEVELS "$(ORACLE8I_OUT_INDEX_LEVELS_ORACLE8I_1)"
# ============================================================================
DEFAULT_MACRO ORACLE8I_OUT_NUMBER_OF_TILES_ORACLE8I_1 8
ORACLE8I_1_NUMBER_OF_TILES "$(ORACLE8I_OUT_NUMBER_OF_TILES_ORACLE8I_1)"
# ============================================================================
# The following option specifies which feature number the writer should actually
# start writing features to the database on. This should normally be zero, but
# can be changed if a previous translation is interrupted.
DEFAULT_MACRO _START_TRANSACTION_ORACLE8I_1 0
GUI INTEGER _START_TRANSACTION_ORACLE8I_1 Transaction To Start Writing At:
ORACLE8I_1_START_TRANSACTION $(_START_TRANSACTION_ORACLE8I_1)
# ============================================================================
# The following specifies how many features will be written to the database in
# on each bulk write.
DEFAULT_MACRO _CHUNK_SIZE_ORACLE8I_1 200
GUI INTEGER _CHUNK_SIZE_ORACLE8I_1 Features Per Bulk Write:
ORACLE8I_1_CHUNK_SIZE $(_CHUNK_SIZE_ORACLE8I_1)
# ============================================================================
# The following specifies how many features will be written to the database in
# each transaction.
DEFAULT_MACRO _TRANSACTION_INTERVAL_ORACLE8I_1 1000
GUI INTEGER _TRANSACTION_INTERVAL_ORACLE8I_1 Features To Write Per Transaction:
ORACLE8I_1_TRANSACTION_INTERVAL $(_TRANSACTION_INTERVAL_ORACLE8I_1)
# ============================================================================
# The following specifies an SQL command to execute before opening the first
# ORACLE table.
DEFAULT_MACRO _BEGIN_SQL_ORACLE8I_1
GUI OPTIONAL TEXT_EDIT_SQL _BEGIN_SQL_ORACLE8I_1 SQL Statement To Execute Before Translation:
ORACLE8I_1_BEGIN_SQL{0} "$(_BEGIN_SQL_ORACLE8I_1)"
# ============================================================================
# The following specifies an SQL command to execute after closing all the
# ORACLE tables.
DEFAULT_MACRO _END_SQL_ORACLE8I_1
GUI OPTIONAL TEXT_EDIT_SQL _END_SQL_ORACLE8I_1 SQL Statement To Execute After Translation:
ORACLE8I_1_END_SQL{0} "$(_END_SQL_ORACLE8I_1)"
# ==============================================================================
# The following specifies whether rows written to the writer's tables have
# to adhere strictly to the destination feature type. When 'No' or 'Warn',
# character columns are truncated to fit and other conversion problems end up
# inserting NULL values; if STRICT_ATTR_CONVERSION is 'Yes', rows containing
# such problems will be logged and not written to the tables.
DEFAULT_MACRO _STRICT_ATTR_CONVERSION_ORACLE8I_1 No
GUI OPTIONAL CHOICE _STRICT_ATTR_CONVERSION_ORACLE8I_1 Yes%No%Warn Enforce strict attribute conversion:
ORACLE8I_1_STRICT_ATTR_CONVERSION "$(_STRICT_ATTR_CONVERSION_ORACLE8I_1)"
# ============================================================================
# The following specifies the mode of the writer
DEFAULT_MACRO _WRITER_MODE_ORACLE8I_1 INSERT
GUI OPTIONAL CHOICE _WRITER_MODE_ORACLE8I_1 INSERT%UPDATE%DELETE Writer Mode:
ORACLE8I_1_WRITER_MODE "$(_WRITER_MODE_ORACLE8I_1)"
# ============================================================================
# The following specifies the name of the Oracle Workspace that we should go
# to when writing tables.
DEFAULT_MACRO _ORACLE8I_Workspace_ORACLE8I_1
GUI OPTIONAL TEXT _ORACLE8I_Workspace_ORACLE8I_1 Oracle Workspace:
ORACLE8I_1_WORKSPACE "$(_ORACLE8I_Workspace_ORACLE8I_1)"
# ============================================================================
# The following specifies whether to maintain multiple geometries or not.
# If set to YES, the Multiple Geometries will be read into an aggregate
# If NO, the default behavior of selecting one geometry will occur
DEFAULT_MACRO _ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1 NO
GUI CHOICE _ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1 YES%NO Handle Multiple Spatial Columns:
ORACLE8I_1_HANDLE_MULTIPLE_SPATIAL_COLUMNS $(_ORACLE8I_OUT_HANDLE_MULTIPLE_SPATIAL_COLUMNS_ORACLE8I_1)
ORACLE8I_1_DATASET "$(DestDataset_ORACLE8I_1)"
#! END_DEST_HEADER
#! END_HEADER
LOG_FILENAME "$(FME_MF_DIR)AttributeFileReader.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_IDRISI_1 IDRISI_1
DEFAULT_MACRO DATASET_KEYWORD_ORACLE8I_1 ORACLE8I_1
# -------------------------------------------------------------------------
IDRISI_1_READER_META_ATTRIBUTES fme_feature_type
# -------------------------------------------------------------------------
MULTI_READER_CONTINUE_ON_READER_FAILURE No
# -------------------------------------------------------------------------
MACRO WORKSPACE_NAME AttributeFileReader
MACRO FME_VIEWER_APP fmeview
# -------------------------------------------------------------------------
INCLUDE [ if {[info exists env(TEMP)]} {set gVisualizerTemp $env(TEMP)} elseif { $tcl_platform(platform) == "unix" } {set gVisualizerTemp "/tmp"} else {set gVisualizerTemp c:}; regsub -all {[ ,&]} {$(WORKSPACE_NAME)} {_} wsname; set gVisualizerTemp $gVisualizerTemp/${wsname}_[clock format [clock seconds] -format %H%M%S]; puts "MACRO WORKSPACE_TEMP_DIR $gVisualizerTemp";
MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/inspector.ffs
MACRO VISUALIZER_CREATE_SPATIAL_INDEX YES
# -------------------------------------------------------------------------
IDRISI_1_DEF e911_facilities IDRISI_TYPE idrisi_point IDR_ID0 integer IDR_ID integer ADDRESS char(40) NAME char(40) FACILITY char(50) TYPE_ double STATUS char(16) STA_NUM char(3) COMMAND char(16) ENTITY char(26) PROP_DATE char(8) FACILITY2 char(16) COLOCATE char(5) NAME2 char(25) UNIT char(35) GAATN char(16) LADDER char(16) X_COORD double Y_COORD double SECTORS_ char(16) JURIS_ char(16) NAME_FULL char(30)
# -------------------------------------------------------------------------
Lookup ___KnownFeatureTypes___ e911_facilities 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(IDRISI,FME_GENERIC,PRESERVE_GEOMETRY)
DEFAULT_MACRO WB_CURRENT_CONTEXT
# -------------------------------------------------------------------------
Tcl2 proc a56a978a_c11c_4d8e_aeef_116c706214254_doSetAttr {attrText} { FME_SetAttribute [FME_DecodeText {PHOTO_FILE_NAME}] [FME_DecodeText $attrText] }
FACTORY_DEF * TeeFactory FACTORY_NAME StringConcatenator INPUT FEATURE_TYPE e911_facilities OUTPUT FEATURE_TYPE StringConcatenator_OUTPUT @Tcl2("a56a978a_c11c_4d8e_aeef_116c706214254_doSetAttr {@EvaluateExpression(STRING_ENCODED,c:FMEDataDataEmergencyPDFValueNAME_FULL.pdf,StringConcatenator)} ")
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory FACTORY_NAME AttributeFileReader INPUT FEATURE_TYPE StringConcatenator_OUTPUT OUTPUT FEATURE_TYPE AttributeFileReader_OUTPUT @File(DestReadSrcWrite,PHOTO,"@Value(PHOTO_FILE_NAME)",fme-binary)
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFileReader_OUTPUT -> E911_FACILITIES Correlator" INPUT FEATURE_TYPE AttributeFileReader_OUTPUT OUTPUT FEATURE_TYPE __GO_TO_FINAL_OUTPUT_ROUTER__ @Transform(FME_GENERIC,ORACLE8I) @SupplyAttributes(__wb_out_feat_type__,E911_FACILITIES)
# -------------------------------------------------------------------------
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__)) OUTPUT FAILED FEATURE_TYPE __nuke_me__ @Tcl2("FME_StatMessage 818059 {@Value(fme_template_feature_type)} 818060 818061 fme_warn")
# -------------------------------------------------------------------------
FACTORY_DEF * TeeFactory FACTORY_NAME "Final Output Nuker" INPUT FEATURE_TYPE __nuke_me__
# -------------------------------------------------------------------------
ORACLE8I_1_DEF E911_FACILITIES oracle_model object oracle_create_indices No oracle_levels 0 oracle_numtiles 8 oracle_min_x -180 oracle_min_y -90 oracle_min_z 0 oracle_min_m 0 oracle_max_x 180 oracle_max_y 90 oracle_max_z 0 oracle_max_m 0 oracle_x_tol 0.05 oracle_y_tol 0.05 oracle_z_tol 0.05 oracle_m_tol 0.05 oracle_dim 2 oracle_default_contains_measures No oracle_default_geom_column GEOM oracle_drop_table Yes IDR_ID integer ADDRESS char(40) NAME char(40) FACILITY char(50) TYPE_ float STATUS char(16) STA_NUM char(3) COMMAND char(16) ENTITY char(26) PROP_DATE char(8) FACILITY2 char(16) COLOCATE char(5) NAME2 char(25) UNIT char(35) GAATN char(16) LADDER char(16) X_COORD float Y_COORD float SECTORS_ char(16) JURIS_ char(16) NAME_FULL char(30) PHOTO blob PHOTO_FILE_NAME char(75)