...
Copy/paste Port listing from TC website then save as an Excel spreadsheet.
Add 3 attributes to signify Public Port, Public Port Facility and Remote Port Facility.
In FME, use the Google Geocoder Feature Merger transformer to geocode join TC DFRP polygons (MapInfo format) with the Excel listing by port name .
Expose the returned Lat/Long value.
Transform the Lat/Long to point.
to extract DFRP #, manually insert the DFRP # for any records not processed.
Output to KML, SHP or GDB as required.
Three datasets are generated: TC Port, Public Port and Public Port Facility.
Import into EGIS
TC Smart Maps:
...