#! #! #! #! #! #! #! #! #! #! #! #! #! #! Writing First Row,firstrow%Yes,yes%No,no Write Field Names Row" firstrow "#!ATTR_INDEX_TYPES=""#!ATTR_NAME_INVALID_CHARS = " " * {} $ " # !SUPPORTS_FEATURE_TYPE_FANOUT="true"#!ENABLED="true"#!DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE="true"#!DATASET_TYPE="FILEDIR"#!GENERATE_FME_BUILD_NUM = " 17539 " # !NAME="CSV"#!FANOUT_EXPRESSION=""#!COORDSYS=""#!FANOUT_GROUP="NO"#!>#! #! #! #! #! #! #! #! #! #! Value fme_db_operation ,MULTIPLE,++fme_table_handling+USE_EXISTING,++fme_selection_group+FME_DISCLOSURE_OPEN Feature Operation" INSERT "GUI ACTIVECHOICE_LOOKUP fme_table_handling Use Existing,USE_EXISTING,fme_table_creation_group%Create If Needed,CREATE_IF_MISSING%Drop and Create,DROP_CREATE%Truncate Existing,TRUNCATE_EXISTING,fme_table_creation_group Table Handling" CREATE_IF_MISSING "GUI OPTIONAL DISCLOSUREGROUP fme_selection_group fme_selection_method Row Selection" "" "GUI OPTIONAL WHOLE_LINE RADIOPARAMETERGROUP fme_selection_method fme_match_columns,MATCH_COLUMNS%fme_where_builder_clause,BUILDER Row Selection Method" MATCH_COLUMNS "GUI WHOLE_LINE ATTRLIST_COMMAS fme_match_columns \" \" Match Columns" "" "GUI WHOLE_LINE TEXT_EDIT_SQL_CFG_OR_ATTR fme_where_builder_clause MODE,WHERE WHERE Clause" "" "GUI OPTIONAL DISCLOSUREGROUP fme_table_creation_group postgres_create_with_oids Table Creation Parameters" "" "GUI CHOICE postgres_create_with_oids YES%NO Create With OIDs" NO "GUI OPTIONAL DISCLOSUREGROUP fme_advanced_group postgres_vacuum_analyze%postgres_allow_serial_writing Advanced" "" "GUI CHOICE postgres_vacuum_analyze YES%NO Vacuum Analyze Table" NO "GUI CHOICE postgres_allow_serial_writing YES%NO Allow Serial Column Writing" NO "#!ATTR_INDEX_TYPES="BTree RTree Hash PrimaryKey"#!ATTR_NAME_INVALID_CHARS=".%-#[]"()!?*'&+\/"#!SUPPORTS_FEATURE_TYPE_FANOUT="true"#!ENABLED="true"#!DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE="true"#!DATASET_TYPE="DATABASE"#!GENERATE_FME_BUILD_NUM = " 17539 " # !FANOUT_EXPRESSION=""#!COORDSYS=""#!FANOUT_GROUP="NO"#!>#! #! #! #! #! #! #! #! #! #! #! #! Value fme_db_operation ,MULTIPLE,++fme_table_handling+USE_EXISTING,++fme_selection_group+FME_DISCLOSURE_OPEN Feature Operation" INSERT "GUI ACTIVECHOICE_LOOKUP fme_table_handling Use Existing,USE_EXISTING,fme_table_creation_group%Create If Needed,CREATE_IF_MISSING%Drop and Create,DROP_CREATE%Truncate Existing,TRUNCATE_EXISTING,fme_table_creation_group Table Handling" CREATE_IF_MISSING "GUI WHOLE_LINE LOOKUP_CHOICE fme_update_geometry Yes,YES%No,NO Update Spatial Column(s)" YES "GUI OPTIONAL DISCLOSUREGROUP fme_selection_group fme_selection_method Row Selection" "" "GUI OPTIONAL WHOLE_LINE RADIOPARAMETERGROUP fme_selection_method fme_match_columns,MATCH_COLUMNS%fme_where_builder_clause,BUILDER Row Selection Method" MATCH_COLUMNS "GUI WHOLE_LINE ATTRLIST_COMMAS fme_match_columns \" \" Match Columns" "" "GUI WHOLE_LINE TEXT_EDIT_SQL_CFG_OR_ATTR fme_where_builder_clause MODE,WHERE WHERE Clause" "" "GUI OPTIONAL DISCLOSUREGROUP fme_table_creation_group postgis_create_with_oids%postgis_create_gist_index Table Creation Parameters" "" "GUI CHOICE postgis_create_with_oids YES%NO Create With OIDs" NO "GUI CHOICE postgis_create_gist_index YES%NO Create GiST Index" YES "GUI OPTIONAL NAMEDGROUP fme_spatial_group postgis_spatial_column_type%postgis_spatial_column%postgis_srid Spatial" "" "GUI LOOKUP_CHOICE postgis_spatial_column_type Geometry,geometry%Geography,geography Spatial Type" geometry "GUI OPTIONAL WHOLE_LINE TEXT postgis_spatial_column Spatial Column" geom "GUI OPTIONAL FLOAT postgis_srid Spatial Column SRID" "" "GUI OPTIONAL DISCLOSUREGROUP fme_advanced_group postgis_vacuum_analyze%postgis_allow_serial_writing Advanced" "" "GUI CHOICE postgis_vacuum_analyze YES%NO Vacuum Analyze Table" NO "GUI CHOICE postgis_allow_serial_writing YES%NO Allow Serial Column Writing" NO "#!ATTR_INDEX_TYPES="BTree RTree Hash PrimaryKey"#!ATTR_NAME_INVALID_CHARS=".%-#[]"()!?*'&+\/"#!SUPPORTS_FEATURE_TYPE_FANOUT="true"#!ENABLED="true"#!DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE="true"#!DATASET_TYPE="DATABASE"#!GENERATE_FME_BUILD_NUM = " 17539 " # !FANOUT_EXPRESSION=""#!COORDSYS=""#!FANOUT_GROUP="NO"#!>#! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #!

02_ProcessPassengerCountData_2012_v003

03-07-2018


Workbench to process passenger count data - P4/P5/P6/PC/OC/TC/QL.


These all have had their survey reference added through a SQL query,as well as combining all tables into a single table per type of survey.


The workbench tests these survey references against the YearIndex table to confirm that they all match a survey in that table.The survey reference from the original table headings is first stored in the TableName field,and is renamed to survey_ref.


In the Yearindex outputs,the field MAPINFO_ID is removed as it no longer serves any need.

"#!POSITION="-316.844 536.54"#!TOP_LEFT="-316.844 536.54"#!BOTTOM_RIGHT="464.414 -371.594"#!BOUNDING_RECT="-316.844 536.54 781.258 908.134"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="10"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="0"#!/>#!

Expose fme_feature_type (table name)

TableName field renamed to Survey_Ref and all

changed to uppercase for merge with

YearIndex Survey field

"#!POSITION="1136.51 22.8808"#!TOP_LEFT="1136.51 22.8808"#!BOTTOM_RIGHT="1135.51 23.8808"#!BOUNDING_RECT="1136.51 22.8808 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="16"#!/>#!

TCN/TCR tables are passed through a

StringReplacer to take off the _1 off the

Survey_Ref.These tables did not have

an equivalent table without the _1 at

the end in the data and are

therefore included.

"#!POSITION="1016.76 -941.751"#!TOP_LEFT="1016.76 -941.751"#!BOTTOM_RIGHT="1015.76 -940.751"#!BOUNDING_RECT="1016.76 -941.751 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="34"#!/>#!

Merge traffic counts with YearIndex table

使用Survey_Ref和调查

"#!POSITION="1925.02 -1140.75"#!TOP_LEFT="1925.02 -1140.75"#!BOTTOM_RIGHT="1924.02 -1139.75"#!BOUNDING_RECT="1925.02 -1140.75 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="26"#!/>#!

Remove geometry merged from

YearIndex as no longer needed

"#!POSITION="2421.9 -1343.76"#!TOP_LEFT="2421.9 -1343.76"#!BOTTOM_RIGHT="2420.9 -1342.76"#!BOUNDING_RECT="2421.9 -1343.76 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="0"#!/>#!

Filter based on original table name

"#!POSITION="2996.91 -1428.14"#!TOP_LEFT="2996.91 -1428.14"#!BOTTOM_RIGHT="2995.91 -1427.14"#!BOUNDING_RECT="2996.91 -1428.14 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="0"#!/>#!

Some additional Yearindex features are rejected -

these are copies apart from the General1 through

4 columns which are not needed for identification

of the Site.

"#!POSITION="1970.64 -2178.26"#!TOP_LEFT="1970.64 -2178.26"#!BOTTOM_RIGHT="1969.64 -2177.26"#!BOUNDING_RECT="1970.64 -2178.26 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="80"#!/>#!

Remove MAPINFO_ID field

"#!POSITION="1136.51 -1535.25"#!TOP_LEFT="1136.51 -1535.25"#!BOTTOM_RIGHT="1135.51 -1534.25"#!BOUNDING_RECT="1136.51 -1535.25 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="86"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="2483.15 -2012.64"#!TOP_LEFT="2483.15 -2012.64"#!BOTTOM_RIGHT="2482.15 -2011.64"#!BOUNDING_RECT="2483.15 -2012.64 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="49"#!/>#!

To PostGIS writer

"#!POSITION="1459.26 -1913.77"#!TOP_LEFT="1459.26 -1913.77"#!BOTTOM_RIGHT="1458.26 -1912.77"#!BOUNDING_RECT="1459.26 -1913.77 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="95"#!/>#!

YearIndex

"#!POSITION="4112.62 1109.55"#!TOP_LEFT="4112.62 1109.55"#!BOTTOM_RIGHT="4111.62 1110.55"#!BOUNDING_RECT="4112.62 1109.55 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="97"#!/>#!

To CSV writer

"#!POSITION="1504.26 -2160.13"#!TOP_LEFT="1504.26 -2160.13"#!BOTTOM_RIGHT="1503.26 -2159.13"#!BOUNDING_RECT="1504.26 -2160.13 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="103"#!/>#!

Yearindex

"#!POSITION="4151.53 -3348.54"#!TOP_LEFT="4151.53 -3348.54"#!BOTTOM_RIGHT="4150.53 -3347.54"#!BOUNDING_RECT="4151.53 -3348.54 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="105"#!/>#!

Remove MAPINFO_ID field

"#!POSITION="931.259 -2342.38"#!TOP_LEFT="931.259 -2342.38"#!BOTTOM_RIGHT="930.259 -2341.38"#!BOUNDING_RECT="931.259 -2342.38 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="111"#!/>#!

TCIndex

"#!POSITION="2006.32 -2602.87"#!TOP_LEFT="2006.32 -2602.87"#!BOTTOM_RIGHT="2005.32 -2601.87"#!BOUNDING_RECT="2006.32 -2602.87 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="117"#!/>#!

TCIndex

"#!POSITION="4140.75 720.672"#!TOP_LEFT="4140.75 720.672"#!BOTTOM_RIGHT="4139.75 721.672"#!BOUNDING_RECT="4140.75 720.672 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="119"#!/>#!

OCHeader

"#!POSITION="1604.01 -3325.21"#!TOP_LEFT="1604.01 -3325.21"#!BOTTOM_RIGHT="1603.01 -3324.21"#!BOUNDING_RECT="1604.01 -3325.21 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="133"#!/>#!

OCHeader

"#!POSITION="4150.12 280.776"#!TOP_LEFT="4150.12 280.776"#!BOTTOM_RIGHT="4149.12 281.776"#!BOUNDING_RECT="4150.12 280.776 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="141"#!/>#!

Create geometry from attributes

"#!POSITION="902.263 -2131.02"#!TOP_LEFT="902.263 -2131.02"#!BOTTOM_RIGHT="901.263 -2130.02"#!BOUNDING_RECT="902.263 -2131.02 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="146"#!/>#!

Writer: PostGIS

"#!POSITION="4513.13 1162.41"#!TOP_LEFT="4513.13 1162.41"#!BOTTOM_RIGHT="4512.13 1163.41"#!BOUNDING_RECT="4513.13 1162.41 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="0.666667,1,0.494118,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="150"#!/>#!

QLHeader

"#!POSITION="1638.31 -2964.14"#!TOP_LEFT = " 1638.31 - -2964.14 " # !BOTTOM_RIGHT="1637.31 -2963.14"#!BOUNDING_RECT="1638.31 -2964.14 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="134"#!/>#!

QLHeader

"#!POSITION="4165.75 478.33"#!TOP_LEFT="4165.75 478.33"#!BOTTOM_RIGHT="4164.75 479.33"#!BOUNDING_RECT="4165.75 478.33 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="136"#!/>#!

QTHeader

"#!POSITION="1597.26 -3701.8"#!TOP_LEFT="1597.26 -3701.8"#!BOTTOM_RIGHT="1596.26 -3700.8"#!BOUNDING_RECT="1597.26 -3701.8 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="191"#!/>#!

QTHeader

"#!POSITION="4140.4 74.6805"#!TOP_LEFT="4140.4 74.6805"#!BOTTOM_RIGHT="4139.4 75.6805"#!BOUNDING_RECT="4140.4 74.6805 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="193"#!/>#!

JQHeader

"#!POSITION="1600.39 -4110.43"#!TOP_LEFT="1600.39 -4110.43"#!BOTTOM_RIGHT="1599.39 -4109.43"#!BOUNDING_RECT="1600.39 -4110.43 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="203"#!/>#!

JQHeader

"#!POSITION="4150.12 -111.953"#!TOP_LEFT="4150.12 -111.953"#!BOTTOM_RIGHT="4149.12 -110.953"#!BOUNDING_RECT="4150.12 -111.953 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,0.666667,1,1"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="205"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="962.509 -4317.8"#!TOP_LEFT="962.509 -4317.8"#!BOTTOM_RIGHT="961.509 -4316.8"#!BOUNDING_RECT="962.509 -4317.8 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="218"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="893.266 -3879.93"#!TOP_LEFT="893.266 -3879.93"#!BOTTOM_RIGHT="892.266 -3878.93"#!BOUNDING_RECT="893.266 -3879.93 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="204"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="917.505 -3468.72"#!TOP_LEFT="917.505 -3468.72"#!BOTTOM_RIGHT="916.505 -3467.72"#!BOUNDING_RECT="917.505 -3468.72 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="192"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="948.755 -3107.65"#!TOP_LEFT="948.755 -3107.65"#!BOTTOM_RIGHT="947.755 -3106.65"#!BOUNDING_RECT="948.755 -3107.65 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="228"#!/>#!

Rename all attributes to

use lowercase only

"#!POSITION="1479.33 -2764.37"#!TOP_LEFT="1479.33 -2764.37"#!BOTTOM_RIGHT="1478.33 -2763.37"#!BOUNDING_RECT="1479.33 -2764.37 -1 -1"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="8"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="232"#!/>#!

v003: changed PostGres writer feature types to work around a bug where copied feature types are considered duplicates.Added additional BulkAttributeRenamers for the _Header outputs for ease of use

"#!POSITION="-316.844 883.003"#!TOP_LEFT="-316.844 883.003"#!BOTTOM_RIGHT = " 433.156 - 833.003 " # !BOUNDING_RECT="-316.844 883.003 750 50"#!ORDER="5e+14"#!FOLLOW_ANCHOR="true"#!INFO_NODE="false"#!COLOUR="1,1,0.784314,0.192157"#!SIZE_POLICY="10"#!COMMENT_TYPE="REGULAR"#!ANCHORED_NODE="0"#!/>#! #! #! #! #!


"#!TOP_LEFT="-378.09 -470.319"#!BOTTOM_RIGHT="871.83 -4491.32"#!BOUNDING_RECT="-378.09 -470.319 1249.92 4021"#!STICKY="true"#!COLOUR="0.34902,0.0431373,0.27451"#!CONTENTS="160 158 125 176 156 161 174 154 159 177 126 157 124 175 155 "#!/>#!

Drops existing tables before writing

"#!TOP_LEFT="4100.04 876.745"#!BOTTOM_RIGHT="5068.8 -1722.41"#!BOUNDING_RECT="4100.04 876.745 968.76 2599.15"#!STICKY="true"#!COLOUR="0.729412,0.54902,0.482353"#!CONTENTS="120 243 202 114 119 62 141 239 206 238 145 43 197 193 241 58 217 205 60 237 140 240 212 136 123 190 209 56 216 "#!/>#!

Overwrites existing files

"#!TOP_LEFT="4096.41 -1733.3"#!BOTTOM_RIGHT="5087.05 -4539.26"#!BOUNDING_RECT="4096.41 -1733.3 990.635 2805.96"#!STICKY="true"#!COLOUR="0.737255,0.564706,0.486275"#!CONTENTS="68 129 178 70 214 109 105 115 199 72 106 162 69 42 102 198 71 127 "#!/>#! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! #! FME_PYTHON_VERSION 27GUI IGNORE SourceDataset_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_PERSISTENT_CONNECTION_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_WHERE_CLAUSE_MSSQL_SPATIAL_1,MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_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_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,DestDataset_CSV2_1,CSV2_OUT_DATASET_GROUP_CSV2_1,CSV2_OUT_EXTENSION_CSV2_1,CSV2_OUT_FIELDS_GROUP_CSV2_1,CSV2_OUT_DELIMITER_CSV2_1,CSV2_OUT_ENCODING_GROUP_CSV2_1,CSV2_OUT_ENCODING_CSV2_1,CSV2_OUT_WRITE_BOM_FOR_UNICODE_CSV2_1,CSV2_OUT_ADVANCED_GROUP_CSV2_1,CSV2_OUT_QUALIFY_FIELD_NAMES_CSV2_1,CSV2_OUT_QUALIFY_FIELD_VALUES_CSV2_1,CSV2_OUT_FIELD_QUALIFIER_CHARACTER_CSV2_1,CSV2_OUT_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1,CSV2_OUT_ROW_TERMINATION_CSV2_1,CSV2_OUT_WRITE_SCHEMA_FILE_CSV2_1,CSV2_OUT_EXISTING_SCHEMA_FILE_HANDLING_CSV2_1,DestDataset_POSTGRES_1,POSTGRES_OUT_ADVANCED_POSTGRES_1,POSTGRES_OUT_BULK_COPY_POSTGRES_1,POSTGRES_OUT_START_TRANSACTION_POSTGRES_1,POSTGRES_OUT_TRANSACTION_INTERVAL_POSTGRES_1,POSTGRES_OUT_BEGIN_SQL_POSTGRES_1,POSTGRES_OUT_END_SQL_POSTGRES_1,DestDataset_POSTGIS_1,POSTGIS_OUT_ADVANCED_POSTGIS_1,POSTGIS_OUT_BULK_COPY_POSTGIS_1,POSTGIS_OUT_START_TRANSACTION_POSTGIS_1,POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1,POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1,POSTGIS_OUT_BEGIN_SQL_POSTGIS_1,POSTGIS_OUT_END_SQL_POSTGIS_1DEFAULT_MACRO OutputFolder C:\Projects\40120 Traffic counts\Output\20180703_2012GUI OPTIONAL DIRNAME OutputFolder Please specify an output location:DEFAULT_MACRO OutputDatabase Att5GIS1_TfWM_2012_WriterGUI NAMED_DB_CONNECTION_ENCODED OutputDatabase FMT:POSTGRES%FAMILY:PostgreSQL OutputDatabase:DEFAULT_MACRO InputDatabase ATT5-GIS1_2012_ReaderGUI NAMED_DB_CONNECTION_ENCODED InputDatabase FMT:MSSQL_SPATIAL%FAMILY:Microsoft SQL Server InputDatabase:DEFAULT_MACRO Year 2012GUI OPTIONAL CHOICE Year 2012%2013%2014%2015%2016%2017 Choose year:INCLUDE [ if {{$(OutputDatabase)} == {}} { puts_real {Parameter 'OutputDatabase' must be given a value.};exit 1;};]INCLUDE [ if {{$(InputDatabase)} == {}} { puts_real {Parameter 'InputDatabase' must be given a value.};exit 1;};]#!START_HEADER#!START_WB_HEADERREADER_TYPE MSSQL_SPATIALREADER_KEYWORD MSSQL_SPATIAL_1READER_GEN_DIRECTIVES QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS,Yes,READ_CACHE_SIZE,10,SEARCH_ENVELOPE_MINX,0,ASSUME_ONE_SRID_PER_COL,,PERSISTENT_CONNECTION,NO,EXPOSE_ATTRS_GROUP,,COMMAND_TIMEOUT,30,SEARCH_ENVELOPE_MINY,0,SEARCH_ENVELOPE_COORDINATE_SYSTEM,,NAMED_CONNECTION,ATT5GIS1_2016,MSSQL_SPATIAL_EXPOSE_FORMAT_ATTRS,,FME_CONNECTION_GROUP,,USE_SEARCH_ENVELOPE,NO,ADVANCED,,HANDLE_MULTIPLE_SPATIAL_COLUMNS,NO,SEARCH_ENVELOPE_MAXX,0,TABLELIST,dbo.EXPORT_OC_Header_all dbo.EXPORT_OC_all dbo.EXPORT_P4_all dbo.EXPORT_P5_all dbo.EXPORT_P6_all dbo.EXPORT_PC_all dbo.EXPORT_TC_all dbo.TCIndex dbo.Yearindex,SEARCH_ENVELOPE_MAXY,0,USE_MAKE_VALID,NO,_MERGE_SCHEMAS,YES,WHERE_CLAUSE,,CLIP_TO_ENVELOPE,NOWRITER_TYPE MULTI_WRITERMULTI_WRITER_DATASET_ORDER BY_IDMULTI_WRITER_FIRST_WRITER_ID 0MULTI_WRITER_TYPE{0} CSV2MULTI_WRITER_KEYWORD{0} CSV2_1MULTI_WRITER_TYPE{1} POSTGRESMULTI_WRITER_KEYWORD{1} POSTGRES_1MULTI_WRITER_TYPE{2} POSTGISMULTI_WRITER_KEYWORD{2} POSTGIS_1#!END_WB_HEADER # !START_WB_HEADERMACRO WB_KEYWORD "MSSQL_SPATIAL_1"#!END_WB_HEADER # !START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_1# The dataset this mapping file was generated from was:#!END_SOURCE_HEADER#!START_WB_HEADERDEFAULT_MACRO SourceDatasetINCLUDE [ if {{$(SourceDataset)} != ""} { \ puts {DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_1 $(SourceDataset)} \ } ]#!END_WB_HEADER # !START_SOURCE_HEADER MSSQL_SPATIAL MSSQL_SPATIAL_1DEFAULT_MACRO SourceDataset_MSSQL_SPATIAL_1 $(InputDatabase)GUI NAMED_DB_CONNECTION_ENCODED SourceDataset_MSSQL_SPATIAL_1 FMT:MSSQL_SPATIAL Connection:DEFAULT_MACRO MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_MSSQL_SPATIAL_1 YesMSSQL_SPATIAL_1_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS "$(MSSQL_SPATIAL_IN_QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS_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 NOMSSQL_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# TimeoutDEFAULT_MACRO MSSQL_SPATIAL_IN_COMMAND_TIMEOUT_MSSQL_SPATIAL_1 30MSSQL_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):# ============================================================================# And an optional global WHERE clauseDEFAULT_MACRO MSSQL_SPATIAL_IN_WHERE_CLAUSE_MSSQL_SPATIAL_1 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 clippingDEFAULT_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)"GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_EXPOSE_ATTRS_GROUP_MSSQL_SPATIAL_1 MSSQL_SPATIAL_IN_MSSQL_SPATIAL_EXPOSE_FORMAT_ATTRS Schema Attributes# Include this file in source setting section to add native search envelope processing# Zero as a default means we don't do any search -- this makes workbench happier# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1 0MSSQL_SPATIAL_1_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1)"GUI OPTIONAL FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINX_MSSQL_SPATIAL_1 Minimum X:# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1 0MSSQL_SPATIAL_1_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1)"GUI OPTIONAL FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MINY_MSSQL_SPATIAL_1 Minimum Y:# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXX_MSSQL_SPATIAL_1 0MSSQL_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 Maximum X:# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1 0MSSQL_SPATIAL_1_SEARCH_ENVELOPE "$(MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1)"GUI OPTIONAL FLOAT MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_MAXY_MSSQL_SPATIAL_1 Maximum Y:# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_SEARCH_ENVELOPE "$(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:# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1 NOMSSQL_SPATIAL_1_CLIP_TO_ENVELOPE "$(MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1)"GUI OPTIONAL CHECKBOX MSSQL_SPATIAL_IN_CLIP_TO_ENVELOPE_MSSQL_SPATIAL_1 YES%NO Clip to Search EnvelopeDEFAULT_MACRO MSSQL_SPATIAL_IN_ADVANCED_MSSQL_SPATIAL_1 GUI OPTIONAL DISCLOSUREGROUP MSSQL_SPATIAL_IN_ADVANCED_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 Advanced# ============================================================================# This keyword controls how many records to retrieve at one time into local# memory from the providerDEFAULT_MACRO MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1 10MSSQL_SPATIAL_1_READ_CACHE_SIZE "$(MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1)"GUI OPTIONAL TEXT MSSQL_SPATIAL_IN_READ_CACHE_SIZE_MSSQL_SPATIAL_1 Number Of Records To Fetch At A Time# ============================================================================# Assume that geometry columns have exactly one SRID?DEFAULT_MACRO MSSQL_SPATIAL_IN_ASSUME_ONE_SRID_PER_COL_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1_ASSUME_ONE_SRID_PER_COL "$(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# ============================================================================# 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 occurDEFAULT_MACRO MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_1 NOMSSQL_SPATIAL_1_HANDLE_MULTIPLE_SPATIAL_COLUMNS "$(MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_1)"GUI CHOICE MSSQL_SPATIAL_IN_HANDLE_MULTIPLE_SPATIAL_COLUMNS_MSSQL_SPATIAL_1 YES%NO Handle Multiple Spatial Columns# ============================================================================# The following specifies whether to use the MakeValid() command when reading# with a search envelope,may modify invalid source data# If YES,invalid data will be made valid;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_1 NOMSSQL_SPATIAL_1_USE_MAKE_VALID "$(MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_1)"GUI CHOICE MSSQL_SPATIAL_IN_USE_MAKE_VALID_MSSQL_SPATIAL_1 YES%NO Use MakeValid with Search Envelope# ===========================================================================DEFAULT_MACRO MSSQL_SPATIAL_IN_ATTRIBUTE_READING_MSSQL_SPATIAL_1 DEFLINE_ATTRSMSSQL_SPATIAL_1_ATTRIBUTE_READING "$(MSSQL_SPATIAL_IN_ATTRIBUTE_READING_MSSQL_SPATIAL_1)"MSSQL_SPATIAL_1_DATASET "$(SourceDataset_MSSQL_SPATIAL_1)"#!END_SOURCE_HEADER#!START_WB_HEADERMACRO WB_KEYWORD "CSV2_1"#!END_WB_HEADER # !START_DEST_HEADER CSV2 CSV2_1# =====================================================================# The following GUI line prompts for a folder where the# CSV files will be stored#!END_DEST_HEADER#!START_WB_HEADERDEFAULT_MACRO DestDatasetINCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_CSV2_1 $(DestDataset)} \ } ]#!END_WB_HEADER # !START_DEST_HEADER CSV2 CSV2_1DEFAULT_MACRO DestDataset_CSV2_1 $(OutputFolder)GUI DIRNAME DestDataset_CSV2_1 Destination CSV (Comma Separated Value) Folder:DEFAULT_MACRO CSV2_OUT_DATASET_GROUP_CSV2_1 GUI OPTIONAL DISCLOSUREGROUP CSV2_OUT_DATASET_GROUP_CSV2_1 FME_DISCLOSURE_OPEN%CSV2_OUT_EXTENSION_CSV2_1%CSV2_OUT_EXISTING_FILE_HANDLING DatasetDEFAULT_MACRO CSV2_OUT_EXTENSION_CSV2_1 csvCSV2_1_EXTENSION "$(CSV2_OUT_EXTENSION_CSV2_1)"GUI OPTIONAL TEXT CSV2_OUT_EXTENSION_CSV2_1 Extension:DEFAULT_MACRO CSV2_OUT_EXISTING_FILE_HANDLING_CSV2_1 YesCSV2_1_EXISTING_FILE_HANDLING "$(CSV2_OUT_EXISTING_FILE_HANDLING_CSV2_1)"DEFAULT_MACRO CSV2_OUT_FIELDS_GROUP_CSV2_1 GUI OPTIONAL DISCLOSUREGROUP CSV2_OUT_FIELDS_GROUP_CSV2_1 FME_DISCLOSURE_OPEN%CSV2_OUT_DELIMITER_CSV2_1%CSV2_OUT_WRITE_FIELD_NAMES FieldsDEFAULT_MACRO CSV2_OUT_DELIMITER_CSV2_1 CSV2_1_DELIMITER "$(CSV2_OUT_DELIMITER_CSV2_1)"GUI STRING_OR_CHOICE_ENCODED CSV2_OUT_DELIMITER_CSV2_1 ,%;%|%space%tab Delimiter Character:DEFAULT_MACRO CSV2_OUT_WRITE_FIELD_NAMES_CSV2_1 firstrowCSV2_1_WRITE_FIELD_NAMES "$(CSV2_OUT_WRITE_FIELD_NAMES_CSV2_1)"DEFAULT_MACRO CSV2_OUT_ENCODING_GROUP_CSV2_1 GUI OPTIONAL DISCLOSUREGROUP CSV2_OUT_ENCODING_GROUP_CSV2_1 FME_DISCLOSURE_OPEN%CSV2_OUT_ENCODING_CSV2_1%CSV2_OUT_WRITE_BOM_FOR_UNICODE_CSV2_1 EncodingDEFAULT_MACRO CSV2_OUT_ENCODING_CSV2_1 CSV2_1_ENCODING "$(CSV2_OUT_ENCODING_CSV2_1)"GUI OPTIONAL STRING_OR_ENCODING CSV2_OUT_ENCODING_CSV2_1 SYSTEM%* Character Encoding:DEFAULT_MACRO CSV2_OUT_WRITE_BOM_FOR_UNICODE_CSV2_1 YesCSV2_1_WRITE_BOM_FOR_UNICODE "$(CSV2_OUT_WRITE_BOM_FOR_UNICODE_CSV2_1)"GUI CHOICE CSV2_OUT_WRITE_BOM_FOR_UNICODE_CSV2_1 Yes%No Write Byte Order Mark for Unicode:DEFAULT_MACRO CSV2_OUT_ADVANCED_GROUP_CSV2_1 GUI OPTIONAL DISCLOSUREGROUP CSV2_OUT_ADVANCED_GROUP_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_OUT_QUALIFY_FIELD_NAMES_CSV2_1%CSV2_OUT_QUALIFY_FIELD_VALUES_CSV2_1%CSV2_OUT_FIELD_QUALIFIER_CHARACTER_CSV2_1%CSV2_OUT_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1%CSV2_OUT_ROW_TERMINATION_CSV2_1%CSV2_OUT_WRITE_SCHEMA_FILE_CSV2_1 AdvancedDEFAULT_MACRO CSV2_OUT_QUALIFY_FIELD_NAMES_CSV2_1 if_neededCSV2_1_QUALIFY_FIELD_NAMES "$(CSV2_OUT_QUALIFY_FIELD_NAMES_CSV2_1)"GUI LOOKUP_CHOICE CSV2_OUT_QUALIFY_FIELD_NAMES_CSV2_1 Yes,yes%No,no%If Needed,if_needed Qualify Field Names:DEFAULT_MACRO CSV2_OUT_QUALIFY_FIELD_VALUES_CSV2_1 if_neededCSV2_1_QUALIFY_FIELD_VALUES "$(CSV2_OUT_QUALIFY_FIELD_VALUES_CSV2_1)"GUI LOOKUP_CHOICE CSV2_OUT_QUALIFY_FIELD_VALUES_CSV2_1 Yes,yes%No,no%If Needed,if_needed Qualify Field Values:DEFAULT_MACRO CSV2_OUT_FIELD_QUALIFIER_CHARACTER_CSV2_1 CSV2_1_FIELD_QUALIFIER_CHARACTER "$(CSV2_OUT_FIELD_QUALIFIER_CHARACTER_CSV2_1)"GUI STRING_ENCODED CSV2_OUT_FIELD_QUALIFIER_CHARACTER_CSV2_1 Field Qualifier Character:DEFAULT_MACRO CSV2_OUT_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1 CSV2_1_FIELD_QUALIFIER_ESCAPE_CHARACTER "$(CSV2_OUT_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1)"GUI STRING_ENCODED CSV2_OUT_FIELD_QUALIFIER_ESCAPE_CHARACTER_CSV2_1 Field Qualifier Escape Character:DEFAULT_MACRO CSV2_OUT_ROW_TERMINATION_CSV2_1 SystemCSV2_1_ROW_TERMINATION "$(CSV2_OUT_ROW_TERMINATION_CSV2_1)"GUI CHOICE CSV2_OUT_ROW_TERMINATION_CSV2_1 System%Windows%Unix%Macintosh Row Termination:DEFAULT_MACRO CSV2_OUT_WRITE_SCHEMA_FILE_CSV2_1 NOCSV2_1_WRITE_SCHEMA_FILE "$(CSV2_OUT_WRITE_SCHEMA_FILE_CSV2_1)"GUI ACTIVEDISCLOSUREGROUP CSV2_OUT_WRITE_SCHEMA_FILE_CSV2_1 FME_DISCLOSURE_CLOSED%CSV2_OUT_EXISTING_SCHEMA_FILE_HANDLING_CSV2_1 Write Schema Configuration FileDEFAULT_MACRO CSV2_OUT_EXISTING_SCHEMA_FILE_HANDLING_CSV2_1 CSV2_1_EXISTING_SCHEMA_FILE_HANDLING "$(CSV2_OUT_EXISTING_SCHEMA_FILE_HANDLING_CSV2_1)"GUI CHOICE CSV2_OUT_EXISTING_SCHEMA_FILE_HANDLING_CSV2_1 Overwrite%Prepend Existing Schema File Handling:DEFAULT_MACRO CSV2_OUT_COORDINATE_SYSTEM_GRANULARITY_CSV2_1 FEATURE_TYPECSV2_1_COORDINATE_SYSTEM_GRANULARITY "$(CSV2_OUT_COORDINATE_SYSTEM_GRANULARITY_CSV2_1)"CSV2_1_DATASET "$(DestDataset_CSV2_1)"#!END_DEST_HEADER#!START_WB_HEADERMACRO WB_KEYWORD "POSTGRES_1"#!END_WB_HEADER # !START_DEST_HEADER POSTGRES POSTGRES_1#!END_DEST_HEADER#!START_WB_HEADERDEFAULT_MACRO DestDatasetINCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_POSTGRES_1 $(DestDataset)} \ } ]#!END_WB_HEADER # !START_DEST_HEADER POSTGRES POSTGRES_1DEFAULT_MACRO DestDataset_POSTGRES_1 $(OutputDatabase)GUI NAMED_DB_CONNECTION_ENCODED DestDataset_POSTGRES_1 FMT:POSTGRES Connection:DEFAULT_MACRO POSTGRES_OUT_ADVANCED_POSTGRES_1 GUI OPTIONAL DISCLOSUREGROUP POSTGRES_OUT_ADVANCED_POSTGRES_1 POSTGRES_OUT_BULK_COPY_POSTGRES_1%POSTGRES_OUT_START_TRANSACTION_POSTGRES_1%POSTGRES_OUT_TRANSACTION_INTERVAL_POSTGRES_1%POSTGRES_OUT_BEGIN_SQL_POSTGRES_1%POSTGRES_OUT_END_SQL_POSTGRES_1 AdvancedDEFAULT_MACRO POSTGRES_OUT_BULK_COPY_POSTGRES_1 YESPOSTGRES_1_BULK_COPY "$(POSTGRES_OUT_BULK_COPY_POSTGRES_1)"GUI CHOICE POSTGRES_OUT_BULK_COPY_POSTGRES_1 YES%NO Bulk InsertDEFAULT_MACRO POSTGRES_OUT_START_TRANSACTION_POSTGRES_1 0POSTGRES_1_START_TRANSACTION "$(POSTGRES_OUT_START_TRANSACTION_POSTGRES_1)"GUI TEXT POSTGRES_OUT_START_TRANSACTION_POSTGRES_1 Starting Feature:DEFAULT_MACRO POSTGRES_OUT_TRANSACTION_INTERVAL_POSTGRES_1 1000POSTGRES_1_TRANSACTION_INTERVAL "$(POSTGRES_OUT_TRANSACTION_INTERVAL_POSTGRES_1)"GUI TEXT POSTGRES_OUT_TRANSACTION_INTERVAL_POSTGRES_1 Features Per TransactionDEFAULT_MACRO POSTGRES_OUT_BEGIN_SQL_POSTGRES_1 POSTGRES_1_BEGIN_SQL "$(POSTGRES_OUT_BEGIN_SQL_POSTGRES_1)"GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGRES_OUT_BEGIN_SQL_POSTGRES_1 MODE,SQL;FORMAT,POSTGRES SQL To Run Before WriteDEFAULT_MACRO POSTGRES_OUT_END_SQL_POSTGRES_1 POSTGRES_1_END_SQL "$(POSTGRES_OUT_END_SQL_POSTGRES_1)"GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGRES_OUT_END_SQL_POSTGRES_1 MODE,SQL;FORMAT,POSTGRES SQL To Run After WritePOSTGRES_1_DATASET "$(DestDataset_POSTGRES_1)"#!END_DEST_HEADER#!START_WB_HEADERMACRO WB_KEYWORD "POSTGIS_1"#!END_WB_HEADER # !START_DEST_HEADER POSTGIS POSTGIS_1#!END_DEST_HEADER#!START_WB_HEADERDEFAULT_MACRO DestDatasetINCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_POSTGIS_1 $(DestDataset)} \ } ]#!END_WB_HEADER # !START_DEST_HEADER POSTGIS POSTGIS_1DEFAULT_MACRO DestDataset_POSTGIS_1 $(OutputDatabase)GUI NAMED_DB_CONNECTION_ENCODED DestDataset_POSTGIS_1 FMT:POSTGIS Connection:# ============================================================================# Write geometry (planar) or geography (geodetic) columnDEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1 geometryPOSTGIS_1_SPATIAL_COLUMN_TYPE "$(POSTGIS_OUT_SPATIAL_COLUMN_TYPE_POSTGIS_1)"# ============================================================================# Default spatial column nameDEFAULT_MACRO POSTGIS_OUT_SPATIAL_COLUMN_NAME_POSTGIS_1 geomPOSTGIS_1_SPATIAL_COLUMN_NAME "$(POSTGIS_OUT_SPATIAL_COLUMN_NAME_POSTGIS_1)"DEFAULT_MACRO POSTGIS_OUT_GENERIC_GEOMETRY_POSTGIS_1 yesPOSTGIS_1_GENERIC_GEOMETRY "$(POSTGIS_OUT_GENERIC_GEOMETRY_POSTGIS_1)"DEFAULT_MACRO POSTGIS_OUT_COORDINATE_SYSTEM_GRANULARITY_POSTGIS_1 FEATURE_TYPEPOSTGIS_1_COORDINATE_SYSTEM_GRANULARITY "$(POSTGIS_OUT_COORDINATE_SYSTEM_GRANULARITY_POSTGIS_1)"DEFAULT_MACRO POSTGIS_OUT_ADVANCED_POSTGIS_1 GUI OPTIONAL DISCLOSUREGROUP POSTGIS_OUT_ADVANCED_POSTGIS_1 POSTGIS_OUT_BULK_COPY_POSTGIS_1%POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1%POSTGIS_OUT_START_TRANSACTION_POSTGIS_1%POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1%POSTGIS_OUT_BEGIN_SQL_POSTGIS_1%POSTGIS_OUT_END_SQL_POSTGIS_1 AdvancedDEFAULT_MACRO POSTGIS_OUT_BULK_COPY_POSTGIS_1 YESPOSTGIS_1_BULK_COPY "$(POSTGIS_OUT_BULK_COPY_POSTGIS_1)"GUI CHOICE POSTGIS_OUT_BULK_COPY_POSTGIS_1 YES%NO Bulk InsertDEFAULT_MACRO POSTGIS_OUT_START_TRANSACTION_POSTGIS_1 0POSTGIS_1_START_TRANSACTION "$(POSTGIS_OUT_START_TRANSACTION_POSTGIS_1)"GUI TEXT POSTGIS_OUT_START_TRANSACTION_POSTGIS_1 Starting Feature:DEFAULT_MACRO POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1 1000POSTGIS_1_TRANSACTION_INTERVAL "$(POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1)"GUI TEXT POSTGIS_OUT_TRANSACTION_INTERVAL_POSTGIS_1 Features Per TransactionDEFAULT_MACRO POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1 NOPOSTGIS_1_INSERT_TEXT_GEOMETRY "$(POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1)"GUI CHOICE POSTGIS_OUT_INSERT_TEXT_GEOMETRY_POSTGIS_1 YES%NO Insert WKTDEFAULT_MACRO POSTGIS_OUT_BEGIN_SQL_POSTGIS_1 POSTGIS_1_BEGIN_SQL "$(POSTGIS_OUT_BEGIN_SQL_POSTGIS_1)"GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_OUT_BEGIN_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run Before WriteDEFAULT_MACRO POSTGIS_OUT_END_SQL_POSTGIS_1 POSTGIS_1_END_SQL "$(POSTGIS_OUT_END_SQL_POSTGIS_1)"GUI OPTIONAL TEXT_EDIT_SQL_CFG POSTGIS_OUT_END_SQL_POSTGIS_1 MODE,SQL;FORMAT,POSTGIS SQL To Run After WritePOSTGIS_1_DATASET "$(DestDataset_POSTGIS_1)"#!END_DEST_HEADER#!START_WB_HEADER#!END_WB_HEADER # !END_HEADERWRITER_TYPE NULLWRITER_KEYWORD WBROUTER_OUTWBROUTER_OUT_DATASET nullLOG_END_BANNER LOG_END_BANNER *** All writer output has been redirected to the Data Inspector ***LOG_END_BANNER LOG_FILENAME "$(FME_MF_DIR)02_ProcessPassengerCountData_2012_v003.log"LOG_APPEND NOLOG_MAX_FEATURES 200LOG_MAX_RECORDED_FEATURES 200FME_REPROJECTION_ENGINE FMEFME_IMPLICIT_CSMAP_REPROJECTION_MODE AutoFME_GEOMETRY_HANDLING EnhancedFME_STROKE_MAX_DEVIATION 0LOG_TIMINGS YESLOG_FILTER_MASK -1DEFAULT_MACRO DATASET_KEYWORD_MSSQL_SPATIAL_1 MSSQL_SPATIAL_1DEFAULT_MACRO DATASET_KEYWORD_CSV2_1 CSV2_1DEFAULT_MACRO DATASET_KEYWORD_POSTGRES_1 POSTGRES_1DEFAULT_MACRO DATASET_KEYWORD_POSTGIS_1 POSTGIS_1# -------------------------------------------------------------------------MSSQL_SPATIAL_1_READER_META_ATTRIBUTES fme_feature_type# -------------------------------------------------------------------------MULTI_READER_CONTINUE_ON_READER_FAILURE No# -------------------------------------------------------------------------MACRO WORKSPACE_NAME 02_ProcessPassengerCountData_2012_v003MACRO FME_VIEWER_APP fmedatainspector# -------------------------------------------------------------------------INCLUDE [ if {[info exists env(FME_TEMP)] && [file isdirectory $env(FME_TEMP)]} {set gVisualizerTemp $env(FME_TEMP)} elseif {[info exists env(TEMP)] && [file isdirectory $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.ffsMACRO VISUALIZER_SCHEMA_FILE $(WORKSPACE_TEMP_DIR)/inspector.fscMACRO VISUALIZER_CREATE_SPATIAL_INDEX YES# -------------------------------------------------------------------------FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD MSSQL_SPATIAL_1 INPUT FEATURE_TYPE * ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_QT_Header_all TO FME_GENERIC ::dbo.EXPORT_QT_Header_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.YearIndex TO FME_GENERIC ::dbo.YearIndex ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_QL_all TO FME_GENERIC ::dbo.EXPORT_QL_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_QT_all TO FME_GENERIC ::dbo.EXPORT_QT_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_TC_all TO FME_GENERIC ::dbo.EXPORT_TC_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_OC_Header_all TO FME_GENERIC ::dbo.EXPORT_OC_Header_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_JQ_all TO FME_GENERIC ::dbo.EXPORT_JQ_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_JQ_Header_all TO FME_GENERIC ::dbo.EXPORT_JQ_Header_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_QL_all_Header TO FME_GENERIC ::dbo.EXPORT_QL_all_Header ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_PC_all TO FME_GENERIC ::dbo.EXPORT_PC_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.EXPORT_OC_all TO FME_GENERIC ::dbo.EXPORT_OC_all ALIAS_GEOMETRY ROUTE MSSQL_SPATIAL MSSQL_SPATIAL_1::dbo.TCIndex TO FME_GENERIC ::dbo.TCIndex ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE *MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_P6_all EXACT dbo.EXPORT_P6_allMSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_QT_Header_all EXACT dbo.EXPORT_QT_Header_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Ref,nvarchar 6 ,Loc,nvarchar 200 ,Arm,integer,ArmName,nvarchar 30 ,Day,nvarchar 3 ,Dat,nvarchar 8 ,GridE,nvarchar 6 ,GridN,nvarchar 6 ,District,nvarchar 2 ,JuncCntrl,nvarchar 1 ,CmpassPos,nvarchar 8 ,TableName,varchar 14 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_P5_all EXACT dbo.EXPORT_P5_allMSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.YearIndex EXACT dbo.YearIndex DEFLINE mssql_sql_statement,,mssql_where_clause,,Site,nvarchar 15 ,Survey,nvarchar 15 ,Description,nvarchar 200 ,District,nvarchar 3 ,Date,smalldatetime,General1,nvarchar 10 ,General2,nvarchar 10 ,General3,nvarchar 10 ,General4,smallint,GridX,float,GridY,float,Confidential,bit,MAPINFO_ID,integerMSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_QL_all EXACT dbo.EXPORT_QL_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Arm,integer,Tim,real,Lane1,integer,Lane2,integer,Lane3,integer,Lane4,integer,TableName,varchar 8 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_QT_all EXACT dbo.EXPORT_QT_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Arm,integer,Secs,nvarchar 1 ,Tim,real,QTime,real,Dir,nvarchar 1 ,TableName,varchar 7 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_TC_all EXACT dbo.EXPORT_TC_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Time,real,ArmEntry,integer,ArmExit,integer,Category1,integer,Category2,integer,Category3,integer,Category4,integer,Category5,integer,Category6,integer,TableName,varchar 11 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_OC_Header_all EXACT dbo.EXPORT_OC_Header_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Ref,nvarchar 6 ,Svno,integer,Loc,nvarchar 200 ,GridE,nvarchar 6 ,GridN,nvarchar 6 ,Day,nvarchar 3 ,Dat,nvarchar 8 ,District,nvarchar 2 ,NumCat,nvarchar 35 ,TableName,varchar 15 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_JQ_all EXACT dbo.EXPORT_JQ_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Survey,integer,RunNo,integer,RunTime,real,Day,nvarchar 3 ,Date,nvarchar 8 ,Weather,nvarchar 8 ,Node,nvarchar 4 ,QTime,real,JTime,real,Parked,nvarchar 3 ,TableName,varchar 7 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_JQ_Header_all EXACT dbo.EXPORT_JQ_Header_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Survey,integer,Ref,nvarchar 5 ,Loc,nvarchar 200 ,Dat,nvarchar 5 ,Dis,nvarchar 2 ,Dir,nvarchar 5 ,StartTime,real,FinishTime,real,Node,nvarchar 4 ,NodeLoc,nvarchar 20 ,Length,real,GridE,float,GridN,float,TableName,varchar 14 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_QL_all_Header EXACT dbo.EXPORT_QL_all_Header DEFLINE mssql_sql_statement,,mssql_where_clause,,Ref,nvarchar 6 ,Arm,integer,ArmName,nvarchar 44 ,Loc,nvarchar 200 ,GridE,nvarchar 6 ,GridN,nvarchar 6 ,Direc,nvarchar 10 ,Day,nvarchar 3 ,Dat,nvarchar 8 ,District,nvarchar 2 ,TimInt,integer,Lanes,integer,NumRecs,integer,TableName,varchar 15 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_PC_all EXACT dbo.EXPORT_PC_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Survey,integer,Direction,integer,Time,datetime,Category1,integer,Category2,integer,Category3,integer,Category4,integer,Category5,integer,Category6,integer,Category7,integer,Category8,integer,Category9,integer,Category10,integer,Category11,integer,Category12,integer,Comment,nvarchar 5 ,TableName,varchar 9 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_OC_all EXACT dbo.EXPORT_OC_all DEFLINE mssql_sql_statement,,mssql_where_clause,,Svno,integer,Direc,nvarchar 1 ,Tim,nvarchar 5 ,Occ1,integer,Occ2,integer,Occ3,integer,Occ4,integer,Occ5,integer,TableName,varchar 8 MSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.TCIndex EXACT dbo.TCIndex DEFLINE mssql_sql_statement,,mssql_where_clause,,Survey,nvarchar 10 ,Number,integer,Arm,smallint,Node,smallint,Name,nvarchar 30 ,Date,smalldatetime,MAPINFO_ID,integerMSSQL_SPATIAL_1_MERGE_DEF MSSQL_SPATIAL_1::dbo.EXPORT_P4_all EXACT dbo.EXPORT_P4_all# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_P6_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_P6_all OUTPUT FEATURE_TYPE dbo.EXPORT_P6_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_QT_Header_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_QT_Header_all OUTPUT FEATURE_TYPE dbo.EXPORT_QT_Header_all_MSSQL_SPATIAL_1_0_ZNCa1Ci/bbg= OUTPUT FEATURE_TYPE dbo.EXPORT_QT_Header_all_MSSQL_SPATIAL_1_1_Cd1lQW9rA1E=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_P5_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_P5_all OUTPUT FEATURE_TYPE dbo.EXPORT_P5_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.YearIndex (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.YearIndex OUTPUT FEATURE_TYPE dbo.YearIndex_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_QL_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_QL_all OUTPUT FEATURE_TYPE dbo.EXPORT_QL_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_QT_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_QT_all OUTPUT FEATURE_TYPE dbo.EXPORT_QT_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_TC_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_TC_all OUTPUT FEATURE_TYPE dbo.EXPORT_TC_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_OC_Header_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_OC_Header_all OUTPUT FEATURE_TYPE dbo.EXPORT_OC_Header_all_MSSQL_SPATIAL_1_0_I+SNiecys9Q= OUTPUT FEATURE_TYPE dbo.EXPORT_OC_Header_all_MSSQL_SPATIAL_1_1_JAg4NzroQsU=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_JQ_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_JQ_all OUTPUT FEATURE_TYPE dbo.EXPORT_JQ_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_JQ_Header_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_JQ_Header_all OUTPUT FEATURE_TYPE dbo.EXPORT_JQ_Header_all_MSSQL_SPATIAL_1_0_gg+FJ6x65Gw= OUTPUT FEATURE_TYPE dbo.EXPORT_JQ_Header_all_MSSQL_SPATIAL_1_1_mhjlqWnkNgI=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_QL_all_Header (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_QL_all_Header OUTPUT FEATURE_TYPE dbo.EXPORT_QL_all_Header_MSSQL_SPATIAL_1_0_njIm2pr9KE4= OUTPUT FEATURE_TYPE dbo.EXPORT_QL_all_Header_MSSQL_SPATIAL_1_1_CElGAuf0JRU=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_PC_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_PC_all OUTPUT FEATURE_TYPE dbo.EXPORT_PC_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_OC_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_OC_all OUTPUT FEATURE_TYPE dbo.EXPORT_OC_all_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.TCIndex (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.TCIndex OUTPUT FEATURE_TYPE dbo.TCIndex_MSSQL_SPATIAL_1# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "dbo.EXPORT_P4_all (MSSQL_SPATIAL_1) Splitter" INPUT FEATURE_TYPE dbo.EXPORT_P4_all OUTPUT FEATURE_TYPE dbo.EXPORT_P4_all_MSSQL_SPATIAL_1DEFAULT_MACRO WB_CURRENT_CONTEXT# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer_2 INPUT FEATURE_TYPE dbo.EXPORT_JQ_Header_all_MSSQL_SPATIAL_1_1_mhjlqWnkNgI= OUTPUT FEATURE_TYPE BulkAttributeRenamer_2_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_13 INPUT FEATURE_TYPE BulkAttributeRenamer_2_OUTPUT OUTPUT FEATURE_TYPE Junction_13_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_14 INPUT FEATURE_TYPE Junction_13_Output OUTPUT FEATURE_TYPE Junction_14_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer_3 INPUT FEATURE_TYPE dbo.EXPORT_QT_Header_all_MSSQL_SPATIAL_1_0_ZNCa1Ci/bbg= OUTPUT FEATURE_TYPE BulkAttributeRenamer_3_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_11 INPUT FEATURE_TYPE BulkAttributeRenamer_3_OUTPUT OUTPUT FEATURE_TYPE Junction_11_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_12 INPUT FEATURE_TYPE Junction_11_Output OUTPUT FEATURE_TYPE Junction_12_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer_5 INPUT FEATURE_TYPE dbo.EXPORT_QL_all_Header_MSSQL_SPATIAL_1_1_CElGAuf0JRU= OUTPUT FEATURE_TYPE BulkAttributeRenamer_5_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_7 INPUT FEATURE_TYPE BulkAttributeRenamer_5_OUTPUT OUTPUT FEATURE_TYPE Junction_7_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_8 INPUT FEATURE_TYPE Junction_7_Output OUTPUT FEATURE_TYPE Junction_8_Output# -------------------------------------------------------------------------FACTORY_DEF * VertexCreatorFactory FACTORY_NAME VertexCreator INPUT FEATURE_TYPE dbo.YearIndex_MSSQL_SPATIAL_1 MODE REPLACE INDEX " " CONTINUE_ON_ERROR YES XVAL "@EvaluateExpression(FDIV,FLOAT, Value GridX ,VertexCreator)" YVAL "@EvaluateExpression(FDIV,FLOAT, Value GridY ,VertexCreator)" OUTPUT OUTPUT FEATURE_TYPE VertexCreator_OUTPUT# -------------------------------------------------------------------------INCLUDE [ set macroLine "MACRO AttributeRemover_LIST_EXP ";foreach attr [split ""] { set attr [FME_DecodeText $attr];set attr [regsub "{}$" $attr "{}.*"];set attr [regsub -all "{}" $attr "\\{\[0-9\]+\\}"];append macroLine ",^$attr$";};puts $macroLine;]FACTORY_DEF * TeeFactory FACTORY_NAME AttributeRemover INPUT FEATURE_TYPE VertexCreator_OUTPUT OUTPUT FEATURE_TYPE AttributeRemover_OUTPUT @RemoveAttributes(fme_encoded,MAPINFO_ID) @RemoveAttributes(fme_pcre_match"$(AttributeRemover_LIST_EXP)")FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeRemover OUTPUT Splitter" INPUT FEATURE_TYPE AttributeRemover_OUTPUT OUTPUT FEATURE_TYPE AttributeRemover_OUTPUT_0_KgEqTnnsDj0= OUTPUT FEATURE_TYPE AttributeRemover_OUTPUT_1_Uawi2isjKi0= OUTPUT FEATURE_TYPE AttributeRemover_OUTPUT_2_8L+wjEf33Ks=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_3 INPUT FEATURE_TYPE AttributeRemover_OUTPUT_2_8L+wjEf33Ks= OUTPUT FEATURE_TYPE Junction_3_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "Junction_4 (Disabled) Nuker" INPUT FEATURE_TYPE Junction_3_OutputFACTORY_DEF * TeeFactory FACTORY_NAME "Junction_4_Output Disabled Nuker -1 106" INPUT FEATURE_TYPE Junction_4_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction INPUT FEATURE_TYPE AttributeRemover_OUTPUT_1_Uawi2isjKi0= OUTPUT FEATURE_TYPE Junction_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_2 INPUT FEATURE_TYPE Junction_Output OUTPUT FEATURE_TYPE Junction_2_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer_4 INPUT FEATURE_TYPE dbo.EXPORT_OC_Header_all_MSSQL_SPATIAL_1_0_I+SNiecys9Q= OUTPUT FEATURE_TYPE BulkAttributeRenamer_4_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_9 INPUT FEATURE_TYPE BulkAttributeRenamer_4_OUTPUT OUTPUT FEATURE_TYPE Junction_9_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_10 INPUT FEATURE_TYPE Junction_9_Output OUTPUT FEATURE_TYPE Junction_10_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME AttributeExposer INPUT FEATURE_TYPE dbo.EXPORT_QL_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_TC_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_PC_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_P6_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_P5_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_P4_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_OC_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_QT_all_MSSQL_SPATIAL_1 INPUT FEATURE_TYPE dbo.EXPORT_JQ_all_MSSQL_SPATIAL_1 OUTPUT FEATURE_TYPE AttributeExposer_OUTPUT# -------------------------------------------------------------------------FACTORY_DEF {*} AttrSetFactory FACTORY_NAME AttributeManager INPUT FEATURE_TYPE AttributeExposer_OUTPUT MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ACTION_COLUMN 3 DEF_VAL_COLUMN 2 ATTR_ACTION { "TableName" "Survey_Ref" " UpperCase Value TableName " "SET_TO" } OUTPUT OUTPUT FEATURE_TYPE AttributeManager_OUTPUT# -------------------------------------------------------------------------FACTORY_DEF * TestFactory FACTORY_NAME Tester INPUT FEATURE_TYPE AttributeManager_OUTPUT TEST @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey_Ref ,Tester) BEGINS_WITH tcn ENCODED TEST @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey_Ref ,Tester) BEGINS_WITH tcr ENCODED TEST @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey_Ref ,Tester) BEGINS_WITH TCN ENCODED TEST @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey_Ref ,Tester) BEGINS_WITH TCR ENCODED BOOLEAN_OPERATOR OR OUTPUT PASSED FEATURE_TYPE Tester_PASSED OUTPUT FAILED FEATURE_TYPE Tester_FAILED# -------------------------------------------------------------------------MACRO casemacINCLUDE [ if { {NO} == {NO} } { puts {MACRO casemac -nocase}} ]Tcl2 proc StringReplacer_53007733_a8df_41e4_9bbb_34c9dc29d1150_replacer { findText replaceText invalidValue} { set attrs [split \"Survey_Ref\" {,}];set findValue [FME_DecodeText $findText];设置replaceValue (FME_DecodeText replaceText美元);foreach attr $attrs { set attrVal [FME_GetAttribute $attr];设置noMatch真;if {{NO} == {YES}} { set newAttrVal [FME_ReplaceRegex $(casemac) $findValue $attrVal $replaceValue];} else { set newAttrVal [string map $(casemac) [list $findValue $replaceValue] $attrVal];};if { $newAttrVal ne $attrVal } { set noMatch false;FME_SetAttribute $attr $newAttrVal;};if {$noMatch} { if { $invalidValue == {FME_NULL_VALUE} } { FME_SetAttributeNull $attr;} elseif { $invalidValue != {_FME_NO_OP_} } { FME_SetAttribute $attr [FME_DecodeText $invalidValue];};};};}FACTORY_DEF * TeeFactory FACTORY_NAME StringReplacer INPUT FEATURE_TYPE Tester_PASSED OUTPUT FEATURE_TYPE StringReplacer_OUTPUT @Tcl2("StringReplacer_53007733_a8df_41e4_9bbb_34c9dc29d1150_replacer {_1} {} {_FME_NO_OP_}")# -------------------------------------------------------------------------INCLUDE [if { {GEOM_BUILD} == {ATTRIBUTES} } { puts "MACRO FeatureMerger_REFERENCE_INFO ATTRIBUTES";} elseif { {GEOM_BUILD} == {GEOM_BUILD} && { } == {POLYGONS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_POLYS";} elseif { {GEOM_BUILD} == {GEOM_BUILD} && { } == {AGGREGATES}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_AGGREGATES";} elseif { {GEOM_BUILD} == {GEOM_BUILD} && { } == {LINESFROMPOINTS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_LINES_FROM_POINTS";} elseif { {GEOM_BUILD} == {GEOM_AND_ATTRS} && { } == {POLYGONS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_POLYS";} elseif { {GEOM_BUILD} == {GEOM_AND_ATTRS} && { } == {AGGREGATES}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES";} elseif { {GEOM_BUILD} == {GEOM_AND_ATTRS} && { } == {LINESFROMPOINTS}} { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_LINES_FROM_POINTS";} elseif { {GEOM_BUILD} == {GEOM_BUILD} } { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_BUILD_AGGREGATES";} elseif { {GEOM_BUILD} == {GEOM_AND_ATTRS} } { puts "MACRO FeatureMerger_REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES";} else {};]FACTORY_DEF {*} ReferenceFactory FACTORY_NAME FeatureMerger INPUT REFERENCER FEATURE_TYPE StringReplacer_OUTPUT INPUT REFERENCER FEATURE_TYPE Tester_FAILED INPUT REFERENCEE FEATURE_TYPE AttributeRemover_OUTPUT_0_KgEqTnnsDj0= REFERENCE_INFO $(FeatureMerger_REFERENCE_INFO) REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey_Ref ,FeatureMerger) @EvaluateExpression(FDIV,STRING_ENCODED, Value Survey ,FeatureMerger) STRING ATTR_ACCUM_MODE " " 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 OUTPUT COMPLETE FEATURE_TYPE FeatureMerger_MERGED OUTPUT REJECTED FEATURE_TYPE FeatureMerger_ # -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "FeatureMerger__Rejected_ (Disabled) Nuker" INPUT FEATURE_TYPE FeatureMerger_ # -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME GeometryRemover INPUT FEATURE_TYPE FeatureMerger_MERGED OUTPUT FEATURE_TYPE GeometryRemover_OUTPUT @RemoveGeometry()# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer INPUT FEATURE_TYPE GeometryRemover_OUTPUT OUTPUT FEATURE_TYPE BulkAttributeRenamer_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME AttributeFilter INPUT FEATURE_TYPE BulkAttributeRenamer_OUTPUT OUTPUT FEATURE_TYPE AttributeFilter_FILTERFACTORY_DEF * AttributeFilterFactory FACTORY_NAME AttributeFilter_Filter COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE AttributeFilter_FILTER FILTER_ATTRIBUTE fme_feature_type FILTER_VALUES EMPTY MISSING NULL UNFILTERED dbo.EXPORT_P4_all dbo.EXPORT_P5_all dbo.EXPORT_P6_all dbo.EXPORT_PC_all dbo.EXPORT_OC_all dbo.EXPORT_TC_all dbo.EXPORT_QT_all dbo.EXPORT_JQ_all dbo.EXPORT_QL_all OUTPUT EMPTY FEATURE_TYPE AttributeFilter_ EMPTY OUTPUT MISSING FEATURE_TYPE AttributeFilter_ MISSING OUTPUT NULL FEATURE_TYPE AttributeFilter_ NULL OUTPUT UNFILTERED FEATURE_TYPE AttributeFilter_ UNFILTERED OUTPUT dbo.EXPORT_P4_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_P4_all OUTPUT dbo.EXPORT_P5_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_P5_all OUTPUT dbo.EXPORT_P6_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_P6_all OUTPUT dbo.EXPORT_PC_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_PC_all OUTPUT dbo.EXPORT_OC_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_OC_all OUTPUT dbo.EXPORT_TC_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_TC_all OUTPUT dbo.EXPORT_QT_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_QT_all OUTPUT dbo.EXPORT_JQ_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_JQ_all OUTPUT dbo.EXPORT_QL_all FEATURE_TYPE AttributeFilter_dbo.EXPORT_QL_allFACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter EMPTY Output Nuker" INPUT FEATURE_TYPE AttributeFilter_ EMPTY FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter MISSING Output Nuker" INPUT FEATURE_TYPE AttributeFilter_ MISSING FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter NULL Output Nuker" INPUT FEATURE_TYPE AttributeFilter_ NULL FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter UNFILTERED Output Nuker" INPUT FEATURE_TYPE AttributeFilter_ UNFILTERED FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_P4_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P4_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P4_all_0_wWyX0ef0F0g= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P4_all_1_EbsrBJp6MkQ=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_P5_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P5_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P5_all_0_KJZJskPzF8s= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P5_all_1_gpL0+lVGwv8=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_P6_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P6_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P6_all_0_1gIMZXeXiAw= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_P6_all_1_3RrIqm7+R7s=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_PC_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_PC_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_PC_all_0_HTN0QceaS2c= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_PC_all_1_7ELthB1weWE=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_OC_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_OC_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_OC_all_0_9+88wPGKvWs= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_OC_all_1_CEzhb0jba3g=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_TC_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_TC_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_TC_all_0_KZxdG4DbRCE= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_TC_all_1_m8gq56SY8js=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_QT_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QT_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QT_all_0_WKOzjw25Fr4= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QT_all_1_fcq4Ryhtngw=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_JQ_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_JQ_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_JQ_all_0_VtdCs4awv30= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_JQ_all_1_ESdC4aoGcec=FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeFilter dbo.EXPORT_QL_all Splitter" INPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QL_all OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QL_all_0_xRcffDpRj9I= OUTPUT FEATURE_TYPE AttributeFilter_dbo.EXPORT_QL_all_1_T+BaTePnpTY=# -------------------------------------------------------------------------INCLUDE [ set macroLine "MACRO AttributeRemover_2_LIST_EXP ";foreach attr [split ""] { set attr [FME_DecodeText $attr];set attr [regsub "{}$" $attr "{}.*"];set attr [regsub -all "{}" $attr "\\{\[0-9\]+\\}"];append macroLine ",^$attr$";};puts $macroLine;]FACTORY_DEF * TeeFactory FACTORY_NAME AttributeRemover_2 INPUT FEATURE_TYPE dbo.TCIndex_MSSQL_SPATIAL_1 OUTPUT FEATURE_TYPE AttributeRemover_2_OUTPUT @RemoveAttributes(fme_encoded,MAPINFO_ID) @RemoveAttributes(fme_pcre_match"$(AttributeRemover_2_LIST_EXP)")FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeRemover_2 OUTPUT Splitter" INPUT FEATURE_TYPE AttributeRemover_2_OUTPUT OUTPUT FEATURE_TYPE AttributeRemover_2_OUTPUT_0_iNGlrgK260E= OUTPUT FEATURE_TYPE AttributeRemover_2_OUTPUT_1_fKCmDr4zCWY=# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME BulkAttributeRenamer_6 INPUT FEATURE_TYPE AttributeRemover_2_OUTPUT_1_fKCmDr4zCWY= OUTPUT FEATURE_TYPE BulkAttributeRenamer_6_OUTPUT @RenameAttributes(PATTERN_REPLACE,CASECHANGE, ," "," ","lower"," ","-_","RENAME","NONFME")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_5 INPUT FEATURE_TYPE BulkAttributeRenamer_6_OUTPUT OUTPUT FEATURE_TYPE Junction_5_Output# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME Junction_6 INPUT FEATURE_TYPE Junction_5_Output OUTPUT FEATURE_TYPE Junction_6_Output# -------------------------------------------------------------------------FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P5_all_1_gpL0+lVGwv8= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC dbo.EXPORT_QL_all_Header_MSSQL_SPATIAL_1_0_njIm2pr9KE4= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P6_all_1_3RrIqm7+R7s= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_OC_all_1_CEzhb0jba3g= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC Junction_4_Output TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC dbo.EXPORT_JQ_Header_all_MSSQL_SPATIAL_1_0_gg+FJ6x65Gw= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_TC_all_0_KZxdG4DbRCE= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeRemover_2_OUTPUT_0_iNGlrgK260E= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_JQ_all_0_VtdCs4awv30= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC dbo.EXPORT_OC_Header_all_MSSQL_SPATIAL_1_1_JAg4NzroQsU= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC dbo.EXPORT_QT_Header_all_MSSQL_SPATIAL_1_1_Cd1lQW9rA1E= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_QL_all_1_T+BaTePnpTY= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P4_all_1_EbsrBJp6MkQ= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_PC_all_1_7ELthB1weWE= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_QT_all_0_WKOzjw25Fr4= TO CSV2 __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_QL_all_0_xRcffDpRj9I= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P6_all_0_1gIMZXeXiAw= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_PC_all_0_HTN0QceaS2c= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_JQ_all_1_ESdC4aoGcec= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1, SupplyAttributes ENCODED __wb_out_feat_type__ y$(Year$encode$encode)_Export.Table1 GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P4_all_0_wWyX0ef0F0g= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC Junction_14_Output TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC Junction_6_Output TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_OC_all_0_9+88wPGKvWs= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC AttributeFilter_dbo.EXPORT_P5_all_0_KJZJskPzF8s= TO POSTGRES __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,1,__wb_out_feat_type__,__nuke_me__ GEOMETRY ROUTE FME_GENERIC Junction_2_Output TO POSTGIS __GO_TO_FINAL_OUTPUT_ROUTER__ CopyAttributes ENCODED site Site survey Survey description Description district District date Date general1 General1 general2 General2 general3 General3 general4 General4 gridx GridX gridy GridY confidential Confidential ,multi_writer_id,2,__wb_out_feat_type__,__nuke_me__ GEOMETRY FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__ OUTPUT ROUTED FEATURE_TYPE * OUTPUT NOT_ROUTED FEATURE_TYPE __nuke_me__ @Tcl2("FME_StatMessage 818059 [FME_GetAttribute fme_template_feature_type] 818060 818061 fme_warn")# -------------------------------------------------------------------------FACTORY_DEF * TeeFactory FACTORY_NAME "Final Output Nuker" INPUT FEATURE_TYPE __nuke_me__# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME P5data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE P5data_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P5data$(Year$encode),P5data_2017) GROUP_ATTRIBUTE_PREFIX P5data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME P5data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,comment,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "P5data_2017 Output Nuker" INPUT FEATURE_TYPE P5data_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME OCHeader_201700_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE OCHeader_201700 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,QLHeader$(Year$encode),OCHeader_201700) GROUP_ATTRIBUTE_PREFIX OCHeader_201700 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME OCHeader_201700_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Ref,varchar 255 ,Arm,varchar 255 ,ArmName,varchar 255 ,Loc,varchar 255 ,GridE,varchar 255 ,GridN,varchar 255 ,Direc,varchar 255 ,Day,varchar 255 ,Dat,varchar 255 ,District,varchar 255 ,TimInt,varchar 255 车道,varchar 255 ,NumRecs,varchar 255 ,TableName,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "OCHeader_201700 Output Nuker" INPUT FEATURE_TYPE OCHeader_201700# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME P6data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE P6data_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P6data$(Year$encode),P6data_2017) GROUP_ATTRIBUTE_PREFIX P6data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME P6data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,category6,varchar 255 ,comment,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "P6data_2017 Output Nuker" INPUT FEATURE_TYPE P6data_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME OCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE OCdata_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,OCdata$(Year$encode),OCdata_2017) GROUP_ATTRIBUTE_PREFIX OCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME OCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,svno,varchar 255 ,direc,varchar 255 ,tim,varchar 255 ,occ1,varchar 255 ,occ2,varchar 255 ,occ3,varchar 255 ,occ4,varchar 255 ,occ5,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "OCdata_2017 Output Nuker" INPUT FEATURE_TYPE OCdata_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME Yearindex_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE Yearindex_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,YearIndex$(Year$encode),Yearindex_2017) GROUP_ATTRIBUTE_PREFIX Yearindex_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME Yearindex_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Site,varchar 255 ,Survey,varchar 255 ,Description,varchar 255 ,District,varchar 255 ,Date,varchar 255 ,General1,varchar 255 ,General2,varchar 255 ,General3,varchar 255 ,General4,varchar 255 ,GridX,varchar 255 格子,varchar 255 ,Confidential,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "Yearindex_2017 Output Nuker" INPUT FEATURE_TYPE Yearindex_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME OCHeader_201702_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE OCHeader_201702 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,JQHeader$(Year$encode),OCHeader_201702) GROUP_ATTRIBUTE_PREFIX OCHeader_201702 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME OCHeader_201702_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Survey,varchar 255 ,Ref,varchar 255 ,Loc,varchar 255 ,Dat,varchar 255 ,Dis,varchar 255 ,Dir,varchar 255 ,StartTime,varchar 255 ,FinishTime,varchar 255 ,Node,varchar 255 、NodeLoc varchar 255 ,Length,varchar 255 ,GridE,varchar 255 ,GridN,varchar 255 ,TableName,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "OCHeader_201702 Output Nuker" INPUT FEATURE_TYPE OCHeader_201702# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME TCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE TCdata_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,TCdata$(Year$encode),TCdata_2017) GROUP_ATTRIBUTE_PREFIX TCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME TCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,time,varchar 255 ,armentry,varchar 255 ,armexit,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,category6,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "TCdata_2017 Output Nuker" INPUT FEATURE_TYPE TCdata_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME TCIndex_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE TCIndex_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,TCIndex$(Year$encode),TCIndex_2017) GROUP_ATTRIBUTE_PREFIX TCIndex_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME TCIndex_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Survey,varchar 255 ,Number,varchar 255 ,Arm,varchar 255 ,Node,varchar 255 ,Name,varchar 255 ,Date,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "TCIndex_2017 Output Nuker" INPUT FEATURE_TYPE TCIndex_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME TCdata_20170000_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE TCdata_20170000 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,JQdata$(Year$encode),TCdata_20170000) GROUP_ATTRIBUTE_PREFIX TCdata_20170000 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME TCdata_20170000_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey,varchar 255 ,runno,varchar 255 ,runtime,varchar 255 ,day,varchar 255 ,date,varchar 255 ,weather,varchar 255 ,node,varchar 255 ,qtime,varchar 255 ,jtime,varchar 255 ,parked,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "TCdata_20170000 Output Nuker" INPUT FEATURE_TYPE TCdata_20170000# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME OCHeader_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE OCHeader_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,OCHeader$(Year$encode),OCHeader_2017) GROUP_ATTRIBUTE_PREFIX OCHeader_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME OCHeader_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Ref,varchar 255 ,Svno,varchar 255 ,Loc,varchar 255 ,GridE,varchar 255 ,GridN,varchar 255 ,Day,varchar 255 ,Dat,varchar 255 ,District,varchar 255 ,NumCat,varchar 255 ,TableName,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "OCHeader_2017 Output Nuker" INPUT FEATURE_TYPE OCHeader_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME OCHeader_201701_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE OCHeader_201701 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,QTHeader$(Year$encode),OCHeader_201701) GROUP_ATTRIBUTE_PREFIX OCHeader_201701 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME OCHeader_201701_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA Ref,varchar 255 ,Loc,varchar 255 ,Arm,varchar 255 ,ArmName,varchar 255 ,Day,varchar 255 ,Dat,varchar 255 ,GridE,varchar 255 ,GridN,varchar 255 ,District,varchar 255 ,JuncCntrl,varchar 255 ,CmpassPos,varchar 255 ,TableName,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "OCHeader_201701 Output Nuker" INPUT FEATURE_TYPE OCHeader_201701# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME TCdata_2017000000_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE TCdata_2017000000 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,QLdata$(Year$encode),TCdata_2017000000) GROUP_ATTRIBUTE_PREFIX TCdata_2017000000 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME TCdata_2017000000_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA arm,varchar 255 ,tim,varchar 255 ,lane1,varchar 255 ,lane2,varchar 255 ,lane3,varchar 255 ,lane4,varchar 255 ,tablename,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "TCdata_2017000000 Output Nuker" INPUT FEATURE_TYPE TCdata_2017000000# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME P4data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE P4data_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P4data$(Year$encode),P4data_2017) GROUP_ATTRIBUTE_PREFIX P4data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME P4data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,comment,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "P4data_2017 Output Nuker" INPUT FEATURE_TYPE P4data_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME PCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE PCdata_2017 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,PCdata$(Year$encode),PCdata_2017) GROUP_ATTRIBUTE_PREFIX PCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME PCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,category6,varchar 255 ,category7,varchar 255 ,category8,varchar 255 ,category9,varchar 255 ,category10,varchar 255 ,category11,varchar 255 ,category12,varchar 255 ,comment,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "PCdata_2017 Output Nuker" INPUT FEATURE_TYPE PCdata_2017# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME TCdata_201700_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE TCdata_201700 GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,QTdata$(Year$encode),TCdata_201700) GROUP_ATTRIBUTE_PREFIX TCdata_201700 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME TCdata_201700_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA arm,varchar 255 ,secs,varchar 255 ,tim,varchar 255 ,qtime,varchar 255 ,dir,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "TCdata_201700 Output Nuker" INPUT FEATURE_TYPE TCdata_201700# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.TCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.TCdata_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,QLdata$(Year$encode),y$(Year)_Export.TCdata_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.TCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.TCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA arm,varchar 255 ,tim,varchar 255 ,lane1,varchar 255 ,lane2,varchar 255 ,lane3,varchar 255 ,lane4,varchar 255 ,tablename,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.TCdata_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.TCdata_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.P6data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.P6data_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P6data$(Year$encode),y$(Year)_Export.P6data_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.P6data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.P6data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,category6,varchar 255 ,comment,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.P6data_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.P6data_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.PCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.PCdata_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,PCdata$(Year$encode),y$(Year)_Export.PCdata_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.PCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.PCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,category6,varchar 255 ,category7,varchar 255 ,category8,varchar 255 ,category9,varchar 255 ,category10,varchar 255 ,category11,varchar 255 ,category12,varchar 255 ,comment,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.PCdata_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.PCdata_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.Table1_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.Table1" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,JQdata$(Year$encode),y$(Year)_Export.Table1) GROUP_ATTRIBUTE_PREFIX y__Year__Export.Table1 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.Table1_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey,varchar 255 ,runno,varchar 255 ,runtime,varchar 255 ,day,varchar 255 ,date,varchar 255 ,weather,varchar 255 ,node,varchar 255 ,qtime,varchar 255 ,jtime,varchar 255 ,parked,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.Table1 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.Table1"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.P4data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.P4data_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P4data$(Year$encode),y$(Year)_Export.P4data_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.P4data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.P4data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,comment,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.P4data_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.P4data_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.OCHeader_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.OCHeader_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,JQHeader$(Year$encode),y$(Year)_Export.OCHeader_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.OCHeader_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.OCHeader_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey,varchar 255 ,ref,varchar 255 ,loc,varchar 255 ,dat,varchar 255 ,dis,varchar 255 ,dir,varchar 255 ,starttime,varchar 255 ,finishtime,varchar 255 ,node,varchar 255 ,nodeloc,varchar 255 ,length,varchar 255 ,gride,varchar 255 ,gridn,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.OCHeader_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.OCHeader_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.TCIndex_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.TCIndex" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,TCIndex$(Year$encode),y$(Year)_Export.TCIndex) GROUP_ATTRIBUTE_PREFIX y__Year__Export.TCIndex RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.TCIndex_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey,varchar 255 ,number,varchar 255 ,arm,varchar 255 ,node,varchar 255 ,name,varchar 255 ,date,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.TCIndex Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.TCIndex"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.OCdata_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.OCdata_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,OCdata$(Year$encode),y$(Year)_Export.OCdata_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.OCdata_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.OCdata_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,svno,varchar 255 ,direc,varchar 255 ,tim,varchar 255 ,occ1,varchar 255 ,occ2,varchar 255 ,occ3,varchar 255 ,occ4,varchar 255 ,occ5,varchar 255 ,tablename,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.OCdata_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.OCdata_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.P5data_2017_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.P5data_2017" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,P5data$(Year$encode),y$(Year)_Export.P5data_2017) GROUP_ATTRIBUTE_PREFIX y__Year__Export.P5data_2017 RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.P5data_2017_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA survey_ref,varchar 255 ,survey,varchar 255 ,direction,varchar 255 ,time,varchar 255 ,category1,varchar 255 ,category2,varchar 255 ,category3,varchar 255 ,category4,varchar 255 ,category5,varchar 255 ,comment,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.P5data_2017 Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.P5data_2017"# Assumption is that the workspace temp dir has been already set and created.See controldefs.cpp - ControlDefs::writeVisualizerTempDirDEFAULT_MACRO WORKSPACE_TEMP_DIRFACTORY_DEF * InspectorFactory FACTORY_NAME y__Year__Export.YearIndex_Prepper COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE "y$(Year)_Export.YearIndex" GROUP_ATTRIBUTE __inspector_feature_type_attr__ GROUP_BY @EvaluateExpression(FDIV,STRING,YearIndex$(Year$encode),y$(Year)_Export.YearIndex) GROUP_ATTRIBUTE_PREFIX y__Year__Export.YearIndex RASTER_REDUCTION NoReduction POINT_CLOUD_REDUCTION NO_THINNING OUTPUT RESULT FEATURE_TYPE __viewme__# Now route all the features into the recorder,changing their# feature type to the transformer name so that they view nicelyDEFAULT_MACRO VISUALIZER_FEATURE_FILE $(WORKSPACE_TEMP_DIR)/$(亚搏在线SAFE_FFS_NAME).ffsDEFAULT_MACRO VISUALIZER_CREATE_SPATIAL_INDEX NO# [PR#45549] The Data Inspector will limit the maximum number of features# it reads on WIN32,so we will correspondingly limit the number of# features we record here using the MAX_FEATURES_TO_RECORD directive.FACTORY_DEF * RecorderFactory FACTORY_NAME y__Year__Export.YearIndex_Recorder COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE __viewme__ _wb_termination_feature Yes @FeatureType(TERMINATOR_@Value(_wb_termination_xformer)) INPUT FEATURE_TYPE __viewme__ @FeatureType(@Value(__inspector_feature_type_attr__)) @RemoveAttributes(__inspector_feature_type_attr__) FEATURE_FILE "$(VISUALIZER_FEATURE_FILE)" STORE_SCANNED_SCHEMA YES CREATE_SPATIAL_INDEX "$(VISUALIZER_CREATE_SPATIAL_INDEX)" INSPECTOR "$(VISUALIZER_CREATE_SPATIAL_INDEX)" FSC_SCHEMA site,varchar 255 ,survey,varchar 255 ,description,varchar 255 ,district,varchar 255 ,date,varchar 255 ,general1,varchar 255 ,general2,varchar 255 ,general3,varchar 255 ,general4,varchar 255 ,gridx,varchar 255 ,gridy,varchar 255 ,confidential,varchar 255 ,fme_feature_type,varchar 255 MODE RECORD STORE_SCANNED_METADATA RECORD_DIRECTLY_TO_DISK YES MAX_FEATURES_TO_RECORD WIN32 2000000FACTORY_DEF * TeeFactory FACTORY_NAME "y$(Year)_Export.YearIndex Output Nuker" INPUT FEATURE_TYPE "y$(Year)_Export.YearIndex"# -------------------------------------------------------------------------FACTORY_DEF * CreationFactory CREATE_AT_END OUTPUT FEATURE_TYPE __NUKEME__ @TCL("if [file exists {$(WORKSPACE_TEMP_DIR)}] {set files [glob -nocomplain -directory {$(WORKSPACE_TEMP_DIR)} -tails *.ffs];if {[llength $files] == 1} { set theFile {$(WORKSPACE_TEMP_DIR)/};append theFile [lindex $files 0];eval FME_Execute System \173\042$(FME_HOME_UNIX)/fmedatainspector\042 --visualizer --single-application --delete-on-close --no-source-prompt -f FFS $theFile & \175;} elseif { [llength $files] == 0 } { catch { file delete -force {$(WORKSPACE_TEMP_DIR)} };} else { set filesNoExt {};set lastfile {};foreach {fileName} [lsort $files] { set fileNoExt [string trimright $fileName {.ffs}];if [regexp {(.*)_[0-9]*$} $fileNoExt wholething fileNoExtBase] { if { $fileNoExtBase == $lastfile } { continue } };set lastfile $fileNoExt;lappend filesNoExt $fileNoExt };eval FME_Execute System \173\042$(FME_HOME_UNIX)/fmedatainspector\042 --visualizer --single-application --delete-on-close --no-source-prompt -d {$(WORKSPACE_TEMP_DIR)} -a ffs -f FFS $filesNoExt & \175;};};")FACTORY_DEF * TeeFactory INPUT FEATURE_TYPE __NUKEME__# -------------------------------------------------------------------------POSTGRES_1_DEF "y$(Year)_Export.Table1" postgres_type All postgres_sql_key_columns "" postgres_drop_table "" postgres_truncate_table "" postgres_mode "" fme_feature_operation INSERT fme_table_handling DROP_CREATE postgres_create_with_oids NO postgres_vacuum_analyze NO postgres_allow_serial_writing NO survey int4 runno int4 runtime float4 day varchar(3) date varchar(8) weather varchar(8) node varchar(4) qtime float4 jtime float4 parked varchar(3) tablename varchar(7)WBROUTER_OUT_DEF P5data_2017WBROUTER_OUT_DEF OCHeader_201700WBROUTER_OUT_DEF P6data_2017WBROUTER_OUT_DEF OCdata_2017WBROUTER_OUT_DEF Yearindex_2017WBROUTER_OUT_DEF OCHeader_201702WBROUTER_OUT_DEF TCdata_2017WBROUTER_OUT_DEF TCIndex_2017WBROUTER_OUT_DEF TCdata_20170000WBROUTER_OUT_DEF OCHeader_2017WBROUTER_OUT_DEF OCHeader_201701WBROUTER_OUT_DEF TCdata_2017000000WBROUTER_OUT_DEF P4data_2017WBROUTER_OUT_DEF PCdata_2017WBROUTER_OUT_DEF TCdata_201700WBROUTER_OUT_DEF "y$(Year)_Export.TCdata_2017"WBROUTER_OUT_DEF "y$(Year)_Export.P6data_2017"WBROUTER_OUT_DEF "y$(Year)_Export.PCdata_2017"WBROUTER_OUT_DEF "y$(Year)_Export.Table1"WBROUTER_OUT_DEF "y$(Year)_Export.P4data_2017"WBROUTER_OUT_DEF "y$(Year)_Export.OCHeader_2017"WBROUTER_OUT_DEF "y$(Year)_Export.TCIndex"WBROUTER_OUT_DEF "y$(Year)_Export.OCdata_2017"WBROUTER_OUT_DEF "y$(Year)_Export.P5data_2017"WBROUTER_OUT_DEF "y$(Year)_Export.YearIndex"