/
Transportation Infrastructure Program

Transportation Infrastructure Program

Owned by Diego Cesa de Meira (Unlicensed)
Jul 31, 2019
2 min read

Description

Canada’s economy and way of life are directly tied to its national transportation infrastructure system. The Transportation Infrastructure Programs Directorate integrates the project management of the various facets of infrastructure, by managing federal funding for:

  • Highways

  • Borders

  • Railways

  • Transit

  • Federal bridges.

Originator

  1. Canada Open Data

  2. Infrastructure Canada

Use Cases

  1.  

Source(s)

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Transportation Infrastructure Programs

Canada Open Data
Infrastructure Canada

CSV

2018

On-going

XML

Free

Canada Open Data
Infrastructure Canada

Canada Open Data has no Lat/Long

Remarks

  1. CSV file from Canada Open Data does not have Lat/Long but contains more project details.

  2. Join two datasets to create a super set using Province and Project Name as primary key.

???For the table project list, it has 13848 records, and for the mapdata table, it has 14797 lines. there are 900 records different.

[10:47 AM] Lawrence Chong Ok. Skip the join as the two dataset are not structured the same.

[10:49 AM] Lawrence Chong As you can see in my latest workflow, I have dropped the join because it is not yielding the expected result.

Process for EGIS integration

CSV File Transformation:

  1. CSV can be integrated directly into ArcMap and ArcGIS.

TC Smart Maps:

  1. Not all GIS applications can consume KML file directly due to its unique data structures such as networklinks, folders, models etc.

  2. Please contact Lawrence Chong, Digital Services Directorate for TC Smart Maps KML dataset and format translation.

  3. TC Smart Maps KML link: \\tc.gc.ca\tcgis\GISData\Google Mashup\TransportationInfrastructurePrograms\APGCTIF Projects.kmz

Customization

  1. Schema transformation: Not required

  2. Denormalization: Not required

  3. Value coding: Not required

  4. Attribute renaming: As required to improve readability

  5. Attribute removal: It is highly recommended as some fields are unnecessary, this will also reduce file size and improve performance

  6. Geoenrichment: Feature symbolization by theme is recommended

  7. Format translation: Geocoding using Lat/Long values

  8. Language translation: French version available

  9. Update frequency: Frequent