...
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 "Transfer Status" such as Deproclaimed, Transferred, Not Transferred etc and is maintained by the NCR Programs Group, Air and Marine Programs.
...
Process for EGIS integration
MDB File Transformation:
Join using DFRP#: In FME, use the Google Geocoder transformer to geocode by port name.Expose the returned Lat/Long valueFeature Merger transformer to join Canada Port database with TC Port using DFRP # as primary key.
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.
Join using Neighbour Finder: Use the Neighbour Finder to locate nearest marine facility for the remaining records.
Transform the Lat/Long to point.
Output to KML, SHP or GDB as required
Import into EGIS
...