...
Process for EGIS integration
MDB File Transformation:
As harbour/wharf facility locations are different from locality centroid, the following 3 methods were performed to pin point the nearest facility location.
Join using DFRP#: In FME, use Feature 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
...