Canada Port

Owned by Diego Cesa de Meira (Unlicensed)
Last updated: Sept 30, 2019 by Lawrence Chong (Unlicensed)
2 min read

Description

Canada Ports
A port is a maritime commercial facility which may comprise one or more wharves where ships may dock to load and discharge passengers and cargo. Although usually situated on a sea coast or estuary, some ports are many miles inland, with access from the sea via river or canal.
Port Divestiture Programs (PDP) Database is a collection of all ports in Canada with current "Transfer Status" such as Deproclaimed, Transferred, Not Transferred etc and is maintained by the NCR Programs Group, Air and Marine Programs.

Originator

  1. Transport 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

Canada Ports

Programs Group-PDP Database

MS Access MDB

N/A

N/A

N/A

Free

EGIS Data Folder: CanadaPort_pt.gdb.zip
Contact Daniel Coldrey, Programs Group, NCR

-Use preprocessed GDB file as provided.
-Geocoded by name

Remarks

  1. Contact: Daniel Coldrey, Manager, Stretegic Program Policy, Air & Marine Programs, Programs Group, NCR.

  2. EGIS Data Folder: \\ncras382\Application Source Files\EGIS\Smartmap Files\

Process for EGIS integration

MDB File Transformation:

  1. As harbour/wharf facility locations are different from locality centroid, the following 3 methods were performed to pin point the nearest facility location.

  2. Join using DFRP#: In FME, use Feature Merger transformer to join Canada Port database with TC Port using DFRP # as primary key.

  3. Join using Site name: Join the remaining unmerged records with TBS DFRP dataset (xml format) by filtering Primary Use=Transportation Marine using Site name as primary key to extract DFRP # and Lat/Long values.

  4. Join using Neighbour Finder: Use the Neighbour Finder to locate nearest marine facility for the remaining records.

  5. Transform the Lat/Long to point.

  6. Output to KML, SHP or GDB as required

  7. Import into EGIS

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\Port\CanadaPort.kmz

Customization:

  1. Schema transformation: As 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 using Status theme is recommended to improve visualization

  7. Format translation: Not required

  8. Language translation: French version not available

  9. Update frequency: As identified