Create points from long, lat values
Set CRS and buffer points to make visible over background map.
Could also output to KML
" last_save_build="FME(R) 2016.1.1.0 (20160707 - Build 16604 - WIN64)" destination="NONE" requirements="FME 2016.1
" title="Traffix XML to Points" warn_invalid_xform_param="Yes" doc_extents="2262.65 1545.38" fme_implicit_csmap_reprojection_mode="Auto" source_routing_file="" show_info_nodes="true" zoom_scale="100" redirect_terminators="NONE" ignore_reader_failure="No" max_log_features="200" fme_geometry_handling="Enhanced" password="" fme_document_priorguid="dc9e4faf-634c-47d7-a8bb-dee380eaec1a,79389451-1b62-4e3b-8ec1-4152c043f6f8,1dba2040-94dc-474c-9b3d-3fe128653b2c,1eb67427-85b9-4130-88aa-53ee4a9f94c7,53a46e7f-0748-4459-8240-0cd0064abe52" end_tcl="" category="XML" doc_top_left="-106.377 -1541.88" log_file="" fme_reprojection_engine="FME" begin_tcl="" python_compatibility="27" show_annotations="true" attr_type_encoding="SDF" begin_python="" view_position="-56.2506 18.7502" source="NONE" history="3
Read traffic web service and
extract features from rss/channel/item
" POSITION="-106.377 -268.376" TOP_LEFT="-106.377 -268.376" BOTTOM_RIGHT="-107.377 -267.376" BOUNDING_RECT="-106.377 -268.376 -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="1">Traffix XML to Excel
" POSITION="1145.01 3.50155" TOP_LEFT="1145.01 3.50155" BOTTOM_RIGHT="1895.01 -46.4984" BOUNDING_RECT="1145.01 3.50155 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">Source data from DriveBC: http://www.drivebc.com/
RRS Feed:
http://www.drivebc.ca/api/events/district/mainland?format=rss
" POSITION="368.753 -1268.13" TOP_LEFT="368.753 -1268.13" BOTTOM_RIGHT="1612.52 -1541.88" BOUNDING_RECT="368.753 -1268.13 1243.76 273.752" ORDER="5e+14" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.784314,0.196078" SIZE_POLICY="10" COMMENT_TYPE="REGULAR" ANCHORED_NODE="0">rename attributes and remove redundant attributes
" POSITION="699.875 -276.875" TOP_LEFT="699.875 -276.875" BOTTOM_RIGHT="1309.39 -419.377" BOUNDING_RECT="699.875 -276.875 609.513 142.501" ORDER="5e+14" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.784314,0.196078" SIZE_POLICY="10" COMMENT_TYPE="REGULAR" ANCHORED_NODE="5">DriveBCRoadevents [XLSXW]
Create a new worksheet for each category of event using feature type fanout
" POSITION="1464.97 -180.875" TOP_LEFT="1464.97 -180.875" BOTTOM_RIGHT="2156.27 -367.127" BOUNDING_RECT="1464.97 -180.875 691.303 186.252" ORDER="5e+14" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.784314,0.196078" SIZE_POLICY="10" COMMENT_TYPE="REGULAR" ANCHORED_NODE="10">Create an Excel hyperlink:
Map 'link' attribute to Description.hyperlink creates the link
This creates the link on the Description attribute
" POSITION="699.875 -704.38" TOP_LEFT="699.875 -704.38" BOTTOM_RIGHT="1434.39 -934.382" BOUNDING_RECT="699.875 -704.38 734.514 230.002" ORDER="5e+14" FOLLOW_ANCHOR="true" INFO_NODE="false" COLOUR="1,1,0.784314,0.196078" SIZE_POLICY="10" COMMENT_TYPE="REGULAR" ANCHORED_NODE="5">。映射空元素= 是的匹配前缀= 属性匹配的属性= 是的基数= +？ except-expression = structure-prefix = 孩子位置属性= 属性标识符= ui模式= 基本XML_1_XFMAP_FEATURE_PATHS_STRUCTURE “$（XML_IN_XFMAP_FEATURE_PATHS_STRUCTURE_XML_1）” GUI可选XML_FLATTEN_OPTIONS XML_IN_XFMAP_FEATURE_PATHS_STRUCTURE_XML_1拼合选项：＃=================================================================＃注：所做的任何更改应XMLFlattener，XMLFragmenter和XML阅读器的图元文件DEFAULT_MACRO XML_IN_XFMAP_FEATURE_PATHS_SUB_FRAGMENTS_XML_1 XML_1_XFMAP_FEATURE_PATHS_SUB_FRAGMENTS进行“$（XML_IN_XFMAP_FEATURE_PATHS_SUB_FRAGMENTS_XML_1）” ＃================================================================= DEFAULT_MACRO XML_IN_XFMAP_XML_1 XML_1_XFMAP “$（XML_IN_XFMAP_XML_1）” GUI可选的多文件XML_IN_XFMAP_XML_1 XML_Map_File（* XMP; *。XML）| * .XMP;* .XML | All_Files（*）| * xfMap文件：＃================================================================= DEFAULT_MACRO XML_IN_XRS_XML_1 XML_1_XRS “$（XML_IN_XRS_XML_1）” GUI可选FILENAME_MUSTEXIST XML_IN_XRS_XML_1 XRS_File（* XML; *。XRS）| * .XML; * XRS | All_Files（*）| * XRS文件：＃================================================================= DEFAULT_MACRO XML_IN_CONTINUE_ON_GEOM_ERROR_XML_1没有XML_1_CONTINUE_ON_GEOM_ERROR“$（XML_IN_CONTINUE_ON_GEOM_ERROR_XML_1)" GUI CHOICE XML_IN_CONTINUE_ON_GEOM_ERROR_XML_1 yes%no Continue on Geometry Error: DEFAULT_MACRO XML_IN_EXPOSE_ATTRS_GROUP_XML_1 XML_1_EXPOSE_ATTRS_GROUP "$(XML_IN_EXPOSE_ATTRS_GROUP_XML_1)" GUI DISCLOSUREGROUP XML_IN_EXPOSE_ATTRS_GROUP_XML_1 XML_EXPOSE_FORMAT_ATTRS Schema Attributes # Include this file in source setting section to add external search envelope processing # Zero as a default means we don't do any search -- this makes workbench happier # =========================================================================== DEFAULT_MACRO XML_IN_SEARCH_ENVELOPE_MINX_XML_1 0 XML_1_SEARCH_ENVELOPE "$(XML_IN_SEARCH_ENVELOPE_MINX_XML_1)" GUI OPTIONAL FLOAT XML_IN_SEARCH_ENVELOPE_MINX_XML_1 Minimum X: # =========================================================================== DEFAULT_MACRO XML_IN_SEARCH_ENVELOPE_MINY_XML_1 0 XML_1_SEARCH_ENVELOPE "$(XML_IN_SEARCH_ENVELOPE_MINY_XML_1)" GUI OPTIONAL FLOAT XML_IN_SEARCH_ENVELOPE_MINY_XML_1 Minimum Y: # =========================================================================== DEFAULT_MACRO XML_IN_SEARCH_ENVELOPE_MAXX_XML_1 0 XML_1_SEARCH_ENVELOPE "$(XML_IN_SEARCH_ENVELOPE_MAXX_XML_1)" GUI OPTIONAL FLOAT XML_IN_SEARCH_ENVELOPE_MAXX_XML_1 Maximum X: # =========================================================================== DEFAULT_MACRO XML_IN_SEARCH_ENVELOPE_MAXY_XML_1 0 XML_1_SEARCH_ENVELOPE "$(XML_IN_SEARCH_ENVELOPE_MAXY_XML_1)" GUI OPTIONAL FLOAT XML_IN_SEARCH_ENVELOPE_MAXY_XML_1 Maximum Y: # =========================================================================== # BUG18999: We now have a soft clip to fall back on like native spatial index # thus we are reintroducing the clip to envelop as an option for users. # Defualt to soft clip as per the existing database readers we are emulating DEFAULT_MACRO XML_IN_CLIP_TO_ENVELOPE_XML_1 NO XML_1_CLIP_TO_ENVELOPE "$(XML_IN_CLIP_TO_ENVELOPE_XML_1)" GUI OPTIONAL CHECKBOX XML_IN_CLIP_TO_ENVELOPE_XML_1 YES%NO Clip to Search Envelope # =========================================================================== DEFAULT_MACRO XML_IN_NETWORK_AUTHENTICATION_XML_1 AUTH_INFO_GROUP,NO,AUTH_METHOD, 没用过 ，NAMED_CONNECTION， 没用过 ，AUTH_USERNAME， 没用过 ，AUTH_PASSWORD， XML_1_NETWORK_AUTHENTICATION “$（XML_IN_NETWORK_AUTHENTICATION_XML_1）” GUI可选AUTHENTICATOR XML_IN_NETWORK_AUTHENTICATION_XML_1 CONTAINER％GROUP％CONTAINER_TITLE％ “网络身份验证” ％PROMPT_TYPE％NETWORK网络验证＃=========================================================================== DEFAULT_MACRO XML_IN_ATTRIBUTE_READING_XML_1 ALL XML_1_ATTRIBUTE_READING“$（XML_IN_ATTRIBUTE_READING_XML_1）”＃PR：31021＃包含在工作台源序言部分文件能够启用＃指定搜索包膜处理＃坐标系=========================================================================== DEFAULT_MACRO SEARCH_ENVELOPE_COORDINATE_SYSTEM_XML_1 GUI可选COORDSYS SEARCH_ENVELOPE_COORDINATE_SYSTEM_XML_1搜索信封坐标系：XML_1_SEARCH_ENVELOPE_COORDINATE_SYSTEM “$（SEARCH_ENVELOPE_COORDINATE_SYSTEM_XML_1）” ＃=========================================================================== DEFAULT_MACRO XFMAP_FEATURE_PATHS_XML_1 RSS 渠道 项目GUI可选STRING_ENCODED XFMAP_FEATURE_PATHS_XML_1元素相匹配：XML_1_XFMAP_FEATURE_PATHS $（XFMAP_FEATURE_PATHS_XML_1）＃============================================================================＃这指定是否xfMap文件应验证针对其＃DTD文件。如果设置为“自动”，则xfMap文件将仅＃验证其DTD文件可用。DEFAULT_MACRO _VALIDATE_XFMAP_XML_1没有GUI CHOICE _VALIDATE_XFMAP_XML_1是没有％％自动验证XML映射文件：XML_1_VALIDATE_XFMAP $（_ VALIDATE_XFMAP_XML_1）＃============================================================================＃这指定是否将XML数据集应针对其＃DTD文件进行验证。如果设置为“自动”，XML文档将仅＃验证其DTD文件可用。DEFAULT_MACRO _VALIDATE_DATASET_XML_1没有GUI CHOICE _VALIDATE_DATASET_XML_1是没有％％自动验证XML数据集文件：XML_1_VALIDATE_DATASET $（_ VALIDATE_DATASET_XML_1）＃============================================================================＃这可选参数指定的系统编码。如果没有指定值＃则使用系统的编码。DEFAULT_MACRO _SYSTEM_ENCODING_XML_1 GUI可选TEXT _SYSTEM_ENCODING_XML_1系统编码：XML_1_SYSTEM_ENCODING $（_ SYSTEM_ENCODING_XML_1）XML_1_DATASET “$（SourceDataset_XML_1）” ＃！ END_SOURCE_HEADER #! START_WB_HEADER MACRO WB_KEYWORD "XLSXW_1" #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_1 # ============================================================================ # First get the dataset for the database. For Excel, it's the file name. # For now we'll use whatever they had when they generated this mapping file, # and not reprompt #! END_DEST_HEADER #! START_WB_HEADER DEFAULT_MACRO DestDataset INCLUDE [ if {"$(DestDataset)" != ""} { \ puts {DEFAULT_MACRO DestDataset_XLSXW_1 $(DestDataset)} \ } ] #! END_WB_HEADER #! START_DEST_HEADER XLSXW XLSXW_1 DEFAULT_MACRO DestDataset_XLSXW_1 $(DestDataset_XLSXW) GUI FILENAME DestDataset_XLSXW_1 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|All_files(*)|* Destination Microsoft Excel File: # ============================================================================ # Whether or not to overwrite the file DEFAULT_MACRO XLSXW_OUT_OVERWRITE_FILE_XLSXW_1 Yes XLSXW_1_OVERWRITE_FILE "$(XLSXW_OUT_OVERWRITE_FILE_XLSXW_1)" GUI ACTIVECHOICE XLSXW_OUT_OVERWRITE_FILE_XLSXW_1 Yes%No,XLSXW_OUT_TEMPLATEFILE,XLSXW_OUT_TEMPLATE_SHEET,XLSXW_OUT_+TEMPLATEFILE+ 覆盖现有文件:# Template File option DEFAULT_MACRO XLSXW_OUT_TEMPLATEFILE_XLSXW_1 XLSXW_1_TEMPLATEFILEGUI OPTIONAL FILENAME_MUSTEXIST XLSXW_OUT_TEMPLATEFILE_XLSXW_1 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|Excel_Workbook_2007(*.xlsx)|*.xlsx|Excel_Macro_Workbook(*.xlsm)|*.xlsm|Excel_Workbook_Pre_2007(*.xls)|*.xls|All_files(*)|* Template File: # ============================================================================ # Parameters whose values will be percolated to the feature types, but will not # remain as writer level settings # Default to not drop feature type first DEFAULT_MACRO XLSXW_OUT_DROP_TABLE_XLSXW_1 No XLSXW_1_DROP_TABLE "$(XLSXW_OUT_DROP_TABLE_XLSXW_1)" # Default to not truncate feature type first (removeallcelldata,retainformatting/headers,etc.) DEFAULT_MACRO XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1 No XLSXW_1_TRUNCATE_TABLE "$(XLSXW_OUT_TRUNCATE_TABLE_XLSXW_1)" # Default to write out the field names DEFAULT_MACRO XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1 Yes XLSXW_1_FIELD_NAMES_OUT "$(XLSXW_OUT_FIELD_NAMES_OUT_XLSXW_1)" # Default writer mode DEFAULT_MACRO XLSXW_OUT_WRITER_MODE_XLSXW_1 Insert XLSXW_1_WRITER_MODE "$(XLSXW_OUT_WRITER_MODE_XLSXW_1)" # Default raster writing type DEFAULT_MACRO XLSXW_OUT_RASTER_FORMAT_XLSXW_1 PNG XLSXW_1_RASTER_FORMAT "$(XLSXW_OUT_RASTER_FORMAT_XLSXW_1)" # ============================================================================ # Opt in for destination dataset type vs format type validation DEFAULT_MACRO XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_1 Yes XLSXW_1_DESTINATION_DATASETTYPE_VALIDATION "$(XLSXW_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW_1)" # Add a new text field for the navigation tree in WB. More detail in BUG51426. DEFAULT_MACRO TEMPLATE_SHEET_XLSXW_1 GUI OPTIONAL TEXT TEMPLATE_SHEET_XLSXW_1 Template Sheet: XLSXW_1_TEMPLATE_SHEET "$(TEMPLATE_SHEET_XLSXW_1)" XLSXW_1_DATASET "$(DestDataset_XLSXW_1)" #! END_DEST_HEADER #! START_WB_HEADER #! END_WB_HEADER #! END_HEADER LOG_FILENAME "$(FME_MF_DIR)TrafficEvents XML to Excel.log" LOG_APPEND NO LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 MAPPING_FILE_ID Traffix XML 至 点LOG_TIMINGS YES LOG_FILTER_MASK -1 DEFAULT_MACRO DATASET_KEYWORD_XML_1 XML_1 DEFAULT_MACRO DATASET_KEYWORD_XLSXW_1 XLSXW_1＃------------------------------------------------------------------------- XML_1_READER_META_ATTRIBUTES fme_feature_type＃------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE无＃------------------------------------------------------------------------- MACRO WORKSPACE_NAME TrafficEvents XML到Excel宏FME_VIEWER_APP fmedatainspector＃ ------------------------------------------------------------------------ XML_1_DEF项目类别xml_char（20）描述xml_char（292）区xml_char（24）GUID xml_char（33）LAT xml_decimal（9,6）链路xml_char（33）长xml_decimal（11,6）pubdate的xml_char（32）路线xml_char（32）严重性xml_char（7）标题xml_char（52）类型xml_char（16）xml_fragment xml_xml xml_id xml_char（15）xml_matched_element xml_char（5）xml_parent_child_posxml_char（1）xml_parent_id xml_char（1）＃------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME “路由器和意外的输入卸妆” COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD XML_1输入FEATURE_TYPE * ROUTE XML XML_1 ::项目FME_GENERIC ::项目ALIAS_GEOMETRY MERGE_INPUT是输出连FEATURE_TYPE * XML_1_MERGE_DEF XML_1 ::项目确切项目＃------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME“项目（XML_1）分离器” INPUT FEATURE_TYPE项目输出FEATURE_TYPE item_XML_1 DEFAULT_MACRO WB_CURRENT_CONTEXT＃------------------------------------------------------------------------- FACTORY_DEF * AttrSetFactory FACTORY_NAME AttributeManager INPUT FEATURE_TYPE item_XML_1 MULTI_FEATURE_MODE NO NULL_ATTR_MODE NO_OP ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV ACTION_COLUMN 3 DEF_VAL_COLUMN 2 ATTR_ACTION "category" "EventCategory" "" "RENAME_SET_VALUE" ATTR_ACTION "description" "Description" "" "RENAME_SET_VALUE" ATTR_ACTION "district" "District" "" "RENAME_SET_VALUE" ATTR_ACTION "guid" "guid" "" "REMOVE" ATTR_ACTION "link" "Description.hyperlink" "" "RENAME_SET_VALUE" ATTR_ACTION "pubDate" "PublicationDate" "" "RENAME_SET_VALUE" ATTR_ACTION "route" "Route" "" "RENAME_SET_VALUE" ATTR_ACTION "severity" "Severity" "" "RENAME_SET_VALUE" ATTR_ACTION "title" "title" "" "REMOVE" ATTR_ACTION "type" "Type" "" "RENAME_SET_VALUE" ATTR_ACTION "lat" "Latitude" "" "RENAME_SET_VALUE" ATTR_ACTION "long" "Longitude" "" "RENAME_SET_VALUE" ATTR_ACTION "xml_fragment" "xml_fragment" "" "REMOVE" ATTR_ACTION "xml_id" "xml_id" "" "REMOVE" ATTR_ACTION "xml_matched_element" "xml_matched_element" "" "REMOVE" ATTR_ACTION "xml_parent_child_pos" "xml_parent_child_pos" "" "REMOVE" ATTR_ACTION "xml_parent_id" "xml_parent_id" "" "REMOVE" OUTPUT OUTPUT FEATURE_TYPE AttributeManager_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC AttributeManager_OUTPUT TO XLSXW __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0, SupplyAttributes ENCODED fme_template_feature_type RoadEvents ， EvaluateExpression ATTR_CREATE_EXPR __wb_out_feat_type__ 在 价值 openparen EventCategory closeparen RoadEvents 几何FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__输出路由FEATURE_TYPE *输出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“最终输出核武器”输入FEATURE_TYPE __nuke_me__ # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - XLSXW_1_DEF RoadEventsxlsx_drop_sheet没有xlsx_trunc_sheet xlsx_sheet_order”“xlsx_freeze_end_row”“xlsx_names_are_positions不xlsx_field_names_out是的xlsx_start_col”“xlsx_start_row”“xlsx_offset_col”“xlsx_offset_row”“xlsx_protect_sheet没有xlsx_raster_type PNG xlsx_table_writer_mode插入xlsx_row_id_column”“EventCategory汽车(20日版 1 number_format_string 字形 font_color 背景颜色 pattern_color pattern_style text_alignment 没有 水平对齐 vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells ）说明汽车（20版 1 number_format_string 字形 font_color 背景颜色 pattern_color pattern_style text_alignment 没有 水平对齐 vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells ）区汽车（20版 1 number_format_string 字形 font_color 背景颜色 pattern_color