Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Info

In Createlayer\EGIS-RailSafety-NationalRailwayNetwork-Eng-Creating.fmw, it need customize setting the reproject for 'NAD83_to_CSRS'

Solution

In FMW

  1. click Tools->FME options

  2. click the Coordinate Systems

  3. select Canada Only from the Implicit Transformations

  4. select NaD83_to_CSRS, click the Edit

  5. add "C:\Program Files\FME\Reproject\GridData\Canada\CSRS\ntv2_0.gsb", delete the others by the - button;

  6. click the OK, OK.

View file
nameCanada.zip

Info

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@20714c
showSpacefalse
sortmodified
typepage
reversetrue
labelsreproject CSRS NAD83
cqllabel in ( "csrs" , "nad83" , "reproject" ) and type = "page" and space = "EGIS"
Page Properties
hiddentrue

Related issues

 

 

From: Xu, Bill
Sent: Thursday, January 23, 2020 10:54 AM
To: Chong, Lawrence <lawrence.chong@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

I deleted the rs_nrwn_eng layer in pilot, when I run the FMW, I got these errors:

 

Feature Caching is ON

The workspace may run slower because features are being recorded on all output ports.

Command-line to run this workspace:

"C:\Program Files\FME\fme.exe" "G:\EGIS\FME Workbench\Working FMW list\Createlayer\EGIS-RailSafety-NationalRailwayNetwork-Eng-Creating.fmw"

  • -SourceDataset_ESRISHAPE_17 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/ab/nrwn_rfn_ab_shp_en.zip"

  • -SourceDataset_ESRISHAPE_25 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/bc/nrwn_rfn_bc_shp_en.zip"

  • -SourceDataset_ESRISHAPE_21 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/mb/nrwn_rfn_mb_shp_en.zip"

  • -SourceDataset_ESRISHAPE_29 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/nb/nrwn_rfn_nb_shp_en.zip"

  • -SourceDataset_ESRISHAPE_19 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/nl/nrwn_rfn_nl_shp_en.zip"

  • -SourceDataset_ESRISHAPE_23 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/ns/nrwn_rfn_ns_shp_en.zip"

  • -SourceDataset_ESRISHAPE_27 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/nt/nrwn_rfn_nt_shp_en.zip"

  • -SourceDataset_ESRISHAPE_31 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/on/nrwn_rfn_on_shp_en.zip"

  • -SourceDataset_ESRISHAPE_18 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/qc/nrwn_rfn_qc_shp_en.zip"

  • -SourceDataset_ESRISHAPE_20 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/sk/nrwn_rfn_sk_shp_en.zip"

  • -SourceDataset_ESRISHAPE_22 "

http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/yt/nrwn_rfn_yt_shp_en.zip"

  • -SourceDataset_XLSXR_4 "\\tc4s0e\groups\AFCC\EGIS\Smart maps GDB files\Copy of RDIMS-#12486229-v99-CROSSINGS_AND_SIGNALS_LOCATION_INVENTORY_EXPORT.XLSX"

  • -myPortalLink "

https://egis-sige.tcgis.ca/portal"

  • -SourceDataset_FILEGDB_4 "\\tc4s0e\groups\AFCC\EGIS\Smart maps GDB files\RailwayUpdate-BC-BdyExtent.gdb"

  • -SourceDataset_FILEGDB_3 "\\tc4s0e\groups\AFCC\EGIS\Smart maps GDB files\RailwayUpdate-BC-BdyExtent.gdb"

Starting translation...

FME 2019.2.1.0 (20191202 - Build 19813 - WIN64)

FME_HOME is 'C:\Program Files\FME\'

FME Professional Edition (node locked-crc)

Serial Number: TXUW-F8U8-192F

Permanent License.

Machine host name is: NCRTBH799741

START - ProcessID: 11132, peak process memory usage: 32248 kB, current process memory usage: 32172 kB

FME Configuration: Command line arguments are `C:\Program Files\FME\fme.exe' `G:/EGIS/FME Workbench/Working FMW list/Createlayer\wb-xlate-1579794651448_16552' `LOG_STANDARDOUT' `YES' `LogCountServerName' `{21a171d8-efec-4a6c-b565-407d92a7cf63}'

FME Configuration: Connection Storage: 'C:\Users\xubi\AppData\Roaming\Safe Software\FME\'

Shared folders for formats are : C:\Program Files\FME\datasources;C:\Users\xubi\Documents\FME\Formats

Shared folders for transformers are : C:\Users\xubi\AppData\Roaming\Safe Software\FME\Packages\19813-win64\transformers;C:\Program Files\FME\transformers;C:\Users\xubi\AppData\Roaming\Safe Software\FME\FME Store\Transformers

Shared folders for coordinate systems are : C:\Users\xubi\Documents\FME\CoordinateSystems

Shared folders for coordinate system exceptions are : C:\Users\xubi\Documents\FME\CoordinateSystemExceptions

Shared folders for coordinate system grid overrides are : C:\Users\xubi\Documents\FME\CoordinateSystemGridOverrides

Shared folders for CS-MAP transformation exceptions are : C:\Users\xubi\Documents\FME\CsmapTransformationExceptions

Shared folders for transformer categories are : C:\Users\xubi\Documents\FME\TransformerCategories

FME Configuration: Reader Keyword is `MULTI_READER'

FME Configuration: Writer Keyword is `MULTI_WRITER'

FME Configuration: Writer Group Definition Keyword is `MULTI_WRITER_DEF'

FME Configuration: Reader type is `MULTI_READER'

FME Configuration: Writer type is `MULTI_WRITER'

FME Configuration: No destination coordinate system set

FME Configuration: Geometry Handling Mode is `Classic'

FME Configuration: Current working folder is `G:\EGIS\FME Workbench\Working FMW list\Createlayer'

FME Configuration: Temporary folder is `C:\Users\xubi\AppData\Local\Temp', set from environment variable `TEMP'

FME Configuration: FME_HOME is `C:\Program Files\FME\'

FME Configuration: FME_BASE is 'no'

FME Configuration: FME_MF_DIR is 'G:\EGIS\FME Workbench\Working FMW list\Createlayer/'

FME Configuration: FME_MF_NAME is 'EGIS-RailSafety-NationalRailwayNetwork-Eng-Creating.fmw'

FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2019.2.1.0'

System Status: 81.93 GB of disk space available in the FME temporary folder (C:\Users\xubi\AppData\Local\Temp)

System Status: 128.00 TB of virtual memory available

Operating System: Microsoft Windows 10 64-bit (Build 16299)

FME Platform: WIN64

Locale: en_US

Code Page: 1252 (ANSI - Latin I)

FME Configuration: Process limit is 15.88 GB of physical memory

FME Configuration: Start freeing memory when process usage exceeds 47.65 GB of virtual memory

FME Configuration: Stop freeing memory when process usage is below 35.74 GB of virtual memory

Creating writer for format:

Creating reader for format:

MULTI_READER(MULTI_READER): Will fail with first member reader failure

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_1

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_2

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_3

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_4

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_5

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_6

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_7

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_8

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_9

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_10

MULTI_READER(MULTI_READER): Adding ESRISHAPE Reader with keyword ESRISHAPE_11

MULTI_READER(MULTI_READER): Adding XLSXR Reader with keyword XLSXR_1

MULTI_READER(MULTI_READER): Adding FILEGDB Reader with keyword FILEGDB_1

MULTI_READER(MULTI_READER): Adding FILEGDB Reader with keyword FILEGDB_2

Using Multi Reader with keyword `MULTI_READER' to read multiple datasets

Python version 3.7 loaded successfully

Potentially retrieving dataset 'http://ftp.maps.canada.ca/pub/nrcan_rncan/vector/geobase_nrwn_rfn/ab/nrwn_rfn_ab_shp_en.zip' for reader ESRISHAPE_1

Retrieved file C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\nrwn_rfn_ab_shp_en.zip for reader ESRISHAPE_1

FME Configuration: Reading 7 dataset(s) with ESRISHAPE reader identified by ESRISHAPE_1

Creating reader for format: Esri Shapefile (Replaced by SHAPEFILE)

FME Configuration: Source coordinate system for reader ESRISHAPE_1[MULTI_READER] set to `LL-CSRS'

Coordinate System `LL-CSRS' parameters: CS_NAME=`LL-CSRS' DESC_NM=`Canadian Spatial Reference System, Latitude-Longitude; Degs' DT_NAME=`CSRS' GROUP=`LL' MAP_SCL=`1' MAX_LAT=`80' MAX_LNG=`-55' MIN_LAT=`-35' MIN_LNG=`-130' PROJ=`LL' QUAD=`1' SCL_RED=`1' SOURCE=`Service New Brunswick' UNIT=`DEGREE' ZERO_X=`1.0000000000000003e-9' ZERO_Y=`1.0000000000000003e-9'

MULTI_READER(ESRISHAPE_1): Will continue past member reader failures

MULTI_READER(ESRISHAPE_1): Adding ESRISHAPE Reader with keyword ESRISHAPE_1

Using Multi Reader with keyword `ESRISHAPE_1' to read multiple datasets

Creating reader for format: Esri Shapefile (Replaced by SHAPEFILE)

FME Configuration: Source coordinate system for reader ESRISHAPE_1[ESRISHAPE] set to `LL-CSRS'

Coordinate System `LL-CSRS' parameters: CS_NAME=`LL-CSRS' DESC_NM=`Canadian Spatial Reference System, Latitude-Longitude; Degs' DT_NAME=`CSRS' GROUP=`LL' MAP_SCL=`1' MAX_LAT=`80' MAX_LNG=`-55' MIN_LAT=`-35' MIN_LNG=`-130' PROJ=`LL' QUAD=`1' SCL_RED=`1' SOURCE=`Service New Brunswick' UNIT=`DEGREE' ZERO_X=`1.0000000000000003e-9' ZERO_Y=`1.0000000000000003e-9'

Using Shape Reader to read shape files from folder `C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132/'

ESRISHAPE_1 Reader: Using classic geometry

Shape Reader: Using simple donut geometry detection

Shape Reader: Handling numeric types with standard integer and floating point types

Shape Reader: Allowing attribute names with mixed case

Opened Shape File 'C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132\NRWN_AB_2_0_CROSSING.shp' for input

Opened DBF File 'C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132\NRWN_AB_2_0_CROSSING.dbf' for input

DBF Reader: Detected character encoding `windows-1252'

DBF File 'C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132\NRWN_AB_2_0_CROSSING.dbf' has fields: NID char(32), CROSSINGID char(32), LEVELCROSS char(20), LEVELCROSC short, CROSSINTYP char(25), CROSSINTYC short, WARNINGSYS char(20), WARNINGSYC short, ROADCLASS char(40), ROADCLASSC short, CROSSTYPNM char(250), ROUTENUMBE char(10), CROSACCES char(10), CROSACCESC short, TCID long, TRACKNID char(32), TRACKNAME char(100), TRACKCLASS char(20), TRACKCLASC short, SUBDI1NID char(32), SUBDI1NAME char(100), SUBD1DIST float, SUB1UNITDI char(20), SUB1UNITDC short, SUB1DISTY char(15), SUB1DISTYC short, SUBDI2NID char(32), SUBDI2NAME char(100), SUBD2DIST float, SUB2UNITDI char(20), SUB2UNITDC short, SUB2DISTY char(15), SUB2DISTYC short, ADMINAREA char(50), ADMINAREAC char(2), SPECVERS char(10), SECURCLASS char(15), SECURCLASC short, GEOCREDATE char(8), GEOREVDATE char(8), GEOACQTECH char(30), GEOACQTECC short, GEOACCURA short, GEOPROVIDE char(25), GEOPROVIDC short, ATTCREDATE char(8), ATTREVDATE char(8), ATTACQTECH char(30), ATTACQTECC short, ATTPROVIDE char(30), ATTPROVIDC short

The OGC definition of the FME coordinate system 'LL-CSRS' is 'GEOGCS["GCS_North_American_1983_CSRS98",DATUM["D_North_American_1983_CSRS98",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199432955]]'

Shape Reader: Bounding box of shapefile `C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132\NRWN_AB_2_0_CROSSING' is: (-119.970515,48.9994885),(-110.0062328,59.9131508)

Shape Reader: Bounding box of shapefile(s) selected from folder `C:\Users\xubi\AppData\Local\Temp\FME_TempFileStore_1579794684328_11132\dsESRISHAPE_1_1579794688437_11132\nrwn_rfn_ab_shp_en.zip_1579794688438_11132/' is: (-119.970515,48.9994885),(-110.0062328,59.9131508)

Using MultiWriter with keyword `MULTI_WRITER' to output data (ID_ATTRIBUTE is `multi_writer_id')

Writer output will be ordered by value of multi_writer_id

Loaded module 'LogCount_func' from file 'C:\Program Files\FME\plugins/LogCount_func.dll'

FME API version of module 'LogCount_func' matches current internal version (3.8 20190820)

Loaded module 'AttributeFilterFactory' from file 'C:\Program Files\FME\plugins/AttributeFilterFactory.dll'

FME API version of module 'AttributeFilterFactory' matches current internal version (3.8 20190820)

FME API version of module 'AttributeFilterFactory' matches current internal version (3.8 20190820)

Loaded module 'StringReplacerFactory' from file 'C:\Program Files\FME\plugins/StringReplacerFactory.dll'

FME API version of module 'StringReplacerFactory' matches current internal version (3.8 20190820)

... Last line repeated 2 times ...

FME Configuration: Using FME Reprojection Engine

Loaded module 'RasterClippingFactory' from file 'C:\Program Files\FME\plugins/RasterClippingFactory.dll'

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

Loaded module 'SolidIntersectionFactory' from file 'C:\Program Files\FME\plugins/SolidIntersectionFactory.dll'

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

Loaded module 'GeometryValidationFactory' from file 'C:\Program Files\FME\plugins/GeometryValidationFactory.dll'

FME API version of module 'GeometryValidationFactory' matches current internal version (3.8 20190820)

Loaded module 'CRC_func' from file 'C:\Program Files\FME\plugins/CRC_func.dll'

FME API version of module 'CRC_func' matches current internal version (3.8 20190820)

Loaded module 'VertexCreatorFactory' from file 'C:\Program Files\FME\plugins/VertexCreatorFactory.dll'

FME API version of module 'VertexCreatorFactory' matches current internal version (3.8 20190820)

FME API version of module 'StringReplacerFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

FME API version of module 'RasterClippingFactory' matches current internal version (3.8 20190820)

FME API version of module 'SolidIntersectionFactory' matches current internal version (3.8 20190820)

Storing feature(s) to FME feature store file `C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_NRWN_AB_2_0_CROSSING -1 4 -1 0 df8cd31e563117b403c118a3da1b3e023d8c71a3.ffsupdating'

Storing feature(s) to FME feature store file `C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_AttributeManager -1 180 fo 0 OUTPUT 0 0e418b2a54af87c7a294423c19910a8e3b43a6a8.ffsupdating'

CS-MAP Reprojector: Transformation will be created from datum parameters for 'LL-CSRS' -> 'LL-WGS84'

CSRS :: Referenced grid file does not exist or cannot be opened for reading.

CS-Map Reprojector: Unable to load grid file for 'NAD83_to_CSRS'

CS-Map Reprojector: This grid may either be available at the government agency applicable to the geographical area or in the FME Reprojection Grid Add-on at:

http://www.safe.com/support/support-resources/fme-downloads/ or http://www.safe.com/support/support-resources/fme-downloads/beta/

CS-MAP Reprojector: Please visit following link for more information on obtaining Canadian grid files: https://knowledge.safe.com/articles/789/where-to-source-canadian-grid-shift-files-not-incl.html

CS-MAP Reprojector: No transformation found to get from 'LL-CSRS (CSRS)' to 'LL-WGS84 (WGS84)'. Add CsmapReprojector tranformers with explicitly chosen transformations

Reprojector: Could not create reprojection engine

Storing feature(s) to FME feature store file `G:\EGIS\FME Workbench\Working FMW list\Createlayer\EGIS-RailSafety-NationalRailwayNetwork-Eng-Creating_log.ffs'

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Feature Type: `Reprojector_REPROJECTED'

Attribute(encoded: fme-system): `Access' has value `Public'

Attribute(string) : `Crossing_Id' has value `-1'

Attribute(encoded: fme-system): `Crossing_Type' has value `Road'

Attribute(encoded: fme-system): `Highway_No' has value `None'

Attribute(encoded: fme-system): `Level_Crossing' has value `Under'

Attribute(string) : `Mile' has value `-1'

Attribute(encoded: fme-system): `NID' has value `4485c41501184a5ba004f06c5be0b7a7'

Attribute(encoded: fme-system): `Protection' has value `None'

Attribute(encoded: fme-system): `Province' has value `AB'

Attribute(encoded: fme-system): `Road_Name' has value `156 Street North-west'

Attribute(string) : `SHAPE_GEOMETRY' has value `shape_point'

Attribute(encoded: fme-system): `Subdivision' has value `Edson'

Attribute(encoded: fme-system): `Track_Class' has value `Main'

Attribute(encoded: fme-system): `Track_Name' has value `None'

Attribute(string) : `fme_feature_type' has value `NRWN_AB_2_0_CROSSING'

Attribute(string) : `fme_geometry' has value `fme_point'

Attribute(entangled: string) : `fme_type' has value `fme_point'

entangled to [SHAPE_GEOMETRY]

Attribute(string) : `multi_reader_full_id' has value `0.0'

Attribute(32 bit integer) : `multi_reader_id' has value `0'

Attribute(string) : `multi_reader_keyword' has value `ESRISHAPE_1'

Attribute(string) : `multi_reader_type' has value `ESRISHAPE'

Geometry Type: Point (1)

Number of Coordinates: 1 -- Coordinate Dimension: 2 -- Coordinate System: `LL-CSRS'

(-113.5910518,53.5809083)

===========================================================================

Reprojector (TeeFactory): Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not create reprojection engine

Stored 1 feature(s) to FME feature store file `C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_NRWN_AB_2_0_CROSSING -1 4 -1 0 df8cd31e563117b403c118a3da1b3e023d8c71a3.ffsupdating'

Saving spatial index into file 'C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_NRWN_AB_2_0_CROSSING -1 4 -1 0 df8cd31e563117b403c118a3da1b3e023d8c71a3.fsi'

Finished saving spatial index into file 'C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_NRWN_AB_2_0_CROSSING -1 4 -1 0 df8cd31e563117b403c118a3da1b3e023d8c71a3.fsi'

Stored 1 feature(s) to FME feature store file `C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_AttributeManager -1 180 fo 0 OUTPUT 0 0e418b2a54af87c7a294423c19910a8e3b43a6a8.ffsupdating'

Saving spatial index into file 'C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_AttributeManager -1 180 fo 0 OUTPUT 0 0e418b2a54af87c7a294423c19910a8e3b43a6a8.fsi'

Finished saving spatial index into file 'C:\Users\xubi\AppData\Local\Temp\wb-cache-EGIS-RailSafety-NationalRailwayN-TnxbxS\Main_AttributeManager -1 180 fo 0 OUTPUT 0 0e418b2a54af87c7a294423c19910a8e3b43a6a8.fsi'

Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not create reprojection engine

Translation FAILED with 34 error(s) and 3 warning(s) (0 feature(s) output)

Stored 1 feature(s) to FME feature store file `G:\EGIS\FME Workbench\Working FMW list\Createlayer\EGIS-RailSafety-NationalRailwayNetwork-Eng-Creating_log.ffs'

FME Session Duration: 11.3 seconds. (CPU: 1.1s user, 2.5s system)

END - ProcessID: 11132, peak process memory usage: 118228 kB, current process memory usage: 103400 kB

Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not create reprojection engine

Program Terminating

Translation FAILED.

 

From: Chong, Lawrence
Sent: Wednesday, January 22, 2020 6:31 PM
To: Xu, Bill <Bill.Xu@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

See comments below in RED.

 

Base Map 2M:

City, Poly changed to City_poly (LegendConfig typo)

 

NRWN_Eng:

[MS_NRWN_Eng] should be [RS_NRWN_Eng] (LegendConfig typo)

Bidge_Tunnel changed to Bridge_Tunnel (requires republishing feature service using current FMW)

 

NAVWARN_Eng:

Navigational_Warning_poly  changed to  NavigationalWarning_poly (LegendConfig typo)

 

Regards,

Lawrence Chong

Programmer Analyst, Application Development | Analyste programmeur, Développent d’applications

Digital Services Directorate | Direction générale des services numériques

 

1100 9700 Jasper Ave. Edmonton, AB T5J 4E6

Lawrence.chong@tc.gc.ca

Tél Cel: 780-920-2269

Government of Canada | Gouvernement du Canada

 

From: Xu, Bill
Sent: Wednesday, January 22, 2020 2:11 PM
To: Chong, Lawrence <lawrence.chong@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

Hi Lawrence,

 

After run the latest updateFMEProperty.py, 3 sections have error in the pilot: ( I highlight with yellow)

"BM_BaseMap_2M" "MS_NRWN_Eng"  "MS_NAVWARN_Eng"

 

Maybe some sub-layer has not published or have error.

 

Thanks,

Bill

 

The error like the following:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 

Begin the section:  BM_BaseMap_2M

in Title:  Base_Map_2M File Geodatabase

  • -Find item.title:  Base_Map_2M

GroupID gdb:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:02:03,948 - INFO - Update GDB like: Base_Map_2M id: f17bd07adc0d4cbe8b3569c5f1749594

in Title:  Base_Map_2M Feature Service

  • -Find item.title:  Base_Map_2M

2020-01-22 16:02:05,258 - INFO - Found feature layer: Base_Map_2M, I will update properties for this feature layer.

GroupID fs:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:02:41,485 - INFO - >>>Update the properties for layers: Base_Map_2M

title  Base_Map_2M

Finish the update properties:  BM_BaseMap_2M

['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -In Sub-LayerName:  Town In Sub-LayerID:  0

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid1 --> 0

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/0/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 0 result:  {"success":true}

  • -In Sub-LayerName:  City In Sub-LayerID:  1

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid0 --> 1

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/1/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 1 result:  {"success":true}

  • -In Sub-LayerName:  Road In Sub-LayerID:  2

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid7 --> 2

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/2/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 2 result:  {"success":true}

  • -In Sub-LayerName:  Province_line In Sub-LayerID:  3

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid5 --> 3

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/3/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 3 result:  {"success":true}

  • -In Sub-LayerName:  Railway In Sub-LayerID:  4

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid6 --> 4

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/4/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 4 result:  {"success":true}

  • -In Sub-LayerName:  Dam_line In Sub-LayerID:  5

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid3 --> 5

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/5/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 5 result:  {"success":true}

  • -In Sub-LayerName:  Drainage_line In Sub-LayerID:  6

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid4 --> 6

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/6/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 6 result:  {"success":true}

  • -In Sub-LayerName:  Boundary In Sub-LayerID:  7

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid2 --> 7

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/7/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 7 result:  {"success":true}

  • -In Sub-LayerName:  National_Park In Sub-LayerID:  8

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid13 --> 8

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/8/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 8 result:  {"success":true}

  • -In Sub-LayerName:  Provincial_Park In Sub-LayerID:  9

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid15 --> 9

  • -In Sub-LayerName:  Indian_Reserve In Sub-LayerID:  10

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road', 'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

  • -new popup text order:  sublayerid12 --> 10

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Base_Map_2M/FeatureServer/10/updateDefinition

 

BM_BaseMap_2M response updateDefinition sub-layer: 10 result:  {"success":true}

  • -In Sub-LayerName:  City_poly In Sub-LayerID:  11

  • -inLayerList:  ['City', 'Town', 'Boundary', 'Dam_line', 'Drainage_line', 'Province_line', 'Railway', 'Road',

'City', 'Poly', 'Dam_poly', 'Drainage_poly', 'Indian_Reserve', 'National_Park', 'Province_poly', 'Provincial_Park']

Finish the update service def:  BM_BaseMap_2M

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 

Begin the section:  MS_NRWN_Eng

in Title:  National_Railway_Network_NRWN File Geodatabase

  • -Find item.title:  National_Railway_Network_NRWN

GroupID gdb:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:03:39,586 - INFO - Update GDB like: National_Railway_Network_NRWN id: 119c42b2f4454756820e16a95531bcee

in Title:  National_Railway_Network_NRWN Feature Service

  • -Find item.title:  National_Railway_Network_NRWN

2020-01-22 16:03:40,975 - INFO - Found feature layer: National_Railway_Network_NRWN, I will update properties for this feature layer.

GroupID fs:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:04:01,966 - INFO - >>>Update the properties for layers: National_Railway_Network_NRWN

title  National_Railway_Network_NRWN

Finish the update properties:  MS_NRWN_Eng

['Culvert', 'Grade_Crossing', 'Station', 'Bridge_Tunnel', 'Track']

  • -In Sub-LayerName:  Grade_Crossing In Sub-LayerID:  0

  • -inLayerList:  ['Culvert', 'Grade_Crossing', 'Station', 'Bridge_Tunnel', 'Track']

  • -new popup text order:  sublayerid1 --> 0

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/National_Railway_Network_NRWN/FeatureServer/0/updateDefinition

 

MS_NRWN_Eng response updateDefinition sub-layer: 0 result:  {"success":true}

  • -In Sub-LayerName:  Culvert In Sub-LayerID:  1

  • -inLayerList:  ['Culvert', 'Grade_Crossing', 'Station', 'Bridge_Tunnel', 'Track']

  • -new popup text order:  sublayerid0 --> 1

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/National_Railway_Network_NRWN/FeatureServer/1/updateDefinition

 

MS_NRWN_Eng response updateDefinition sub-layer: 1 result:  {"success":true}

  • -In Sub-LayerName:  Station In Sub-LayerID:  2

  • -inLayerList:  ['Culvert', 'Grade_Crossing', 'Station', 'Bridge_Tunnel', 'Track']

  • -new popup text order:  sublayerid2 --> 2

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/National_Railway_Network_NRWN/FeatureServer/2/updateDefinition

 

MS_NRWN_Eng response updateDefinition sub-layer: 2 result:  {"success":true}

  • -In Sub-LayerName: 

Bidge_Tunnel In Sub-LayerID:  3

  • -inLayerList:  ['Culvert', 'Grade_Crossing', 'Station', 'Bridge_Tunnel', 'Track']

Finish the update service def:  MS_NRWN_Eng

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 

Begin the section:  MS_NAVWARN_Eng

in Title:  Navigational_Warnings_NAVWARN File Geodatabase

  • -Find item.title:  Navigational_Warnings_NAVWARN

GroupID gdb:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:04:22,838 - INFO - Update GDB like: Navigational_Warnings_NAVWARN id: 899b09186d6141cf8d2f39b56cb8b61f

in Title:  Navigational_Warnings_NAVWARN Feature Service

  • -Find item.title:  Navigational_Warnings_NAVWARN

2020-01-22 16:04:24,162 - INFO - Found feature layer: Navigational_Warnings_NAVWARN, I will update properties for this feature layer.

GroupID fs:  f7e0071abd144750b9acef75099b096b

2020-01-22 16:04:43,083 - INFO - >>>Update the properties for layers: Navigational_Warnings_NAVWARN

title  Navigational_Warnings_NAVWARN

Finish the update properties:  MS_NAVWARN_Eng

['Navigational_Warning_pt', 'Navigational_Warning_line', 'Navigational_Warning_poly']

  • -In Sub-LayerName:  Navigational_Warning_pt In Sub-LayerID:  0

  • -inLayerList:  ['Navigational_Warning_pt', 'Navigational_Warning_line', 'Navigational_Warning_poly']

  • -new popup text order:  sublayerid0 --> 0

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Navigational_Warnings_NAVWARN/FeatureServer/0/updateDefinition

 

MS_NAVWARN_Eng response updateDefinition sub-layer: 0 result:  {"success":true}

  • -In Sub-LayerName:  Navigational_Warning_line In Sub-LayerID:  1

  • -inLayerList:  ['Navigational_Warning_pt', 'Navigational_Warning_line', 'Navigational_Warning_poly']

  • -new popup text order:  sublayerid1 --> 1

response url:  https://egis-sige.tcgis.ca/server/rest/admin/services/Hosted/Navigational_Warnings_NAVWARN/FeatureServer/1/updateDefinition

 

MS_NAVWARN_Eng response updateDefinition sub-layer: 1 result:  {"success":true}

  • -In Sub-LayerName:  NavigationalWarning_poly In Sub-LayerID:  2

  • -inLayerList:  ['Navigational_Warning_pt', 'Navigational_Warning_line', 'Navigational_Warning_poly']

Finish the update service def:  MS_NAVWARN_Eng

 

From: Chong, Lawrence
Sent: Monday, January 20, 2020 2:25 PM
To: Xu, Bill <Bill.Xu@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

Hi Bill,

I just published several layers as indicated in the list in PLT. Please LegendConfig as required.

 

                Line 94: ****Alert: didn't find the feature layer: Drone_Free_Zone_-_All. (Published: Drone_Free_Zone, To be deleted/replaced: Drone_Free_Zone)

                Line 188: ****Alert: didn't find the feature layer: Canada_Base_Map. (This is WMS. We published Base Map 30M, 7M and 2M)

                Line 202: ****Alert: didn't find the feature layer: Base_Map_2M. (Published: Base_Map_2M)

                Line 242: ****Alert: didn't find the feature layer: Réseau_ferroviaire_national_RFN. (Published: Réseau_ferroviaire_national_RFN)

                Line 343: ****Alert: didn't find the feature layer: Northern_Project_Management_Office_(NPMO)_-_Pipeline_and_Transmission_Line. (Replaced with Major_Mining_Projects)

                Line 347: ****Alert: didn't find the feature layer: Northern_Project_Management_Office_(NPMO)_-_Point.

                Line 366: ****Alert: didn't find the feature layer: NPA_Opt_out_Structures. (Published: NPA_Opt_out_Structures)

                Line 370: ****Alert: didn't find the feature layer: NPA_Opt_out_Bridges. (Published: NPA_Opt_out_Bridges)

                Line 470: ****Alert: didn't find the feature layer: TC_Regions. (Published: TC_Regions)

                Line 519: ****Alert: didn't find the feature layer: GRDC_Emplacement. (Published: GRDC_Emplacement, NOTE: Existing RCMP_Detachment to be deleted and republished)

                Line 523: ****Alert: didn't find the feature layer: Community_and_Municipal_Police. (Published: Community_and_Municipal_Police)

                Line 301: ****Alert: didn't find the feature layer: TC_Federal_Real_Property. (Published: TC_Federal_Real_Property)

                Line 305: ****Alert: didn't find the feature layer: TC_Federal_Real_Property. (NOTE: This is a duplicate of Line 301)

                Line 309: ****Alert: didn't find the feature layer: TC_Répertoire_des_biens_immobiliers_fédéraux. (Published: TC_Répertoire_des_biens_immobiliers_fédéraux)

 

Regards,

Lawrence Chong

Programmer Analyst, Application Development | Analyste programmeur, Développent d’applications

Digital Services Directorate | Direction générale des services numériques

 

1100 9700 Jasper Ave. Edmonton, AB T5J 4E6

Lawrence.chong@tc.gc.ca

Tél Cel: 780-920-2269

Government of Canada | Gouvernement du Canada

 

From: Xu, Bill
Sent: Monday, January 20, 2020 9:56 AM
To: Chong, Lawrence <lawrence.chong@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

Remember last Friday, some layers didn’t show correctly. (e.g. TC_regions) in new dev, now it is OK, please check it.

 

Cheers,

Bill

 

From: Chong, Lawrence
Sent: Monday, January 20, 2020 11:53 AM
To: Xu, Bill <Bill.Xu@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

Hi Bill,

There are layers that we need to delete before we can republish them with new data structure. How can we determine if there is a reference to the service published? This is to avoid another complain from user who published web app using those layers.

 

I am going through each theme to determine layers that have to be republished starting with Programs Group.

 

I will update the RDIMS to reflect the current status.

 

Regards,

Lawrence Chong

Programmer Analyst, Application Development | Analyste programmeur, Développent d’applications

Digital Services Directorate | Direction générale des services numériques

 

1100 9700 Jasper Ave. Edmonton, AB T5J 4E6

Lawrence.chong@tc.gc.ca

Tél Cel: 780-920-2269

Government of Canada | Gouvernement du Canada

 

From: Xu, Bill
Sent: Monday, January 20, 2020 9:45 AM
To: Chong, Lawrence <lawrence.chong@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

These are cleaning work for us. When you have time.

And please also update the excel file(rdims#14988431) and the (rdims# 14991016) EGIS RETROSPECTIVE percentage portion when you add a new layer in pilot/dev

 

Thanks,

Bill

 

From: Chong, Lawrence
Sent: Friday, January 17, 2020 12:11 PM
To: Xu, Bill <Bill.Xu@tc.gc.ca>
Subject: RE: These layers missing/wrong title base on the configFME.ini in Pilot

 

I haven’t done anything to the layers listed on PLT yet. Do you want me to publish them?

 

Regards,

Lawrence Chong

Programmer Analyst, Application Development | Analyste programmeur, Développent d’applications

Digital Services Directorate | Direction générale des services numériques

 

1100 9700 Jasper Ave. Edmonton, AB T5J 4E6

Lawrence.chong@tc.gc.ca

Tél Cel: 780-920-2269

Government of Canada | Gouvernement du Canada

 

From: Xu, Bill
Sent: Friday, January 17, 2020 9:36 AM
To: Chong, Lawrence <lawrence.chong@tc.gc.ca>
Subject: These layers missing/wrong title base on the configFME.ini in Pilot

 

                Line 94: ****Alert: didn't find the feature layer: Drone_Free_Zone_-_All.

                Line 188: ****Alert: didn't find the feature layer: Canada_Base_Map.

                Line 202: ****Alert: didn't find the feature layer: Base_Map_2M.

                Line 242: ****Alert: didn't find the feature layer: Réseau_ferroviaire_national_RFN.

                Line 343: ****Alert: didn't find the feature layer: Northern_Project_Management_Office_(NPMO)_-_Pipeline_and_Transmission_Line.

                Line 347: ****Alert: didn't find the feature layer: Northern_Project_Management_Office_(NPMO)_-_Point.

                Line 366: ****Alert: didn't find the feature layer: NPA_Opt_out_Structures.

                Line 370: ****Alert: didn't find the feature layer: NPA_Opt_out_Bridges.

                Line 470: ****Alert: didn't find the feature layer: TC_Regions.

                Line 519: ****Alert: didn't find the feature layer: GRDC_Emplacement.

                Line 523: ****Alert: didn't find the feature layer: Community_and_Municipal_Police., "

               

               

                Line 301: ****Alert: didn't find the feature layer: TC_Federal_Real_Property.

                Line 305: ****Alert: didn't find the feature layer: TC_Federal_Real_Property.

                Line 309: ****Alert: didn't find the feature layer: TC_Répertoire_des_biens_immobiliers_fédéraux.

section:  PG_TCRealProperty

in Title:  TC_Federal_Real_Property Feature Service

  • ***Alert: didn't find the feature layer: TC_Federal_Real_Property.

>>>Update the properties for layers: TC_Federal_Real_Property

section:  PG_TC_DFRP_Eng

in Title:  TC_Federal_Real_Property Feature Service

  • ***Alert: didn't find the feature layer: TC_Federal_Real_Property.

>>>Update the properties for layers: TC_Federal_Real_Property

section:  PG_TC_DFRP_Fre

in Title:  TC_Répertoire_des_biens_immobiliers_fédéraux Feature Service

  • ***Alert: didn't find the feature layer: TC_Répertoire_des_biens_immobiliers_fédéraux.

 

 

Best Regards,

Bill Xu

 

C51, 21st floor, 330 Sparks Street,Ottawa

613-949-7120

Bill.xu@tc.gc.ca