TC Real Property

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

Description

The TC Directory of Federal Real Property (DFRP) is the central record of real property holdings of Transport Canada which is a subset of the Government of Canada DFRP. It is administered by the Programs Group Real Property Branch.

The purpose of the Directory is to maintain a contemporary record of basic information concerning the real property holdings of the Government of Canada. Information held in the Directory is used to keep the Government of Canada informed about the scale and major components of its real property inventory. It is also used to provide information to ministers, members of Parliament and the general public concerning a specific property or group of properties within a particular geographic area.

Originator

  1. Transport Canada, Programs Group, Airport and Port Programs, Real Property

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

TC DFRP Polygon

EIS

TAB

2018

Frequent

N/A

Free

EGIS Data Folder: DFRPTC_poly.gdb.zip
Contact Chris Auger, Real Property

-Use preprocessed GDB file as provided.
-Property boundary

TC DFRP Database

EIS

Oracle Non-spatial Database

CSV

2018

Frequent

N/A

Free

Contact Chris Auger, Real Property

CSV

Polygon centroid

Remarks

  1. EIS is an Oracle Non-spatial database.

  2. Permission required to access the EIS Database for direct EGIS integration. Contact Programs Group, Real Property Manager for more information.

  3. To extract the property listing, perform Property Search on the EIS Real Property Portal. Click the Search button. From the result page, click the document icon on the top right of the page to save the CSV file.

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

Process for EGIS integration

TAB (Polygon):

  1. Property polygon dataset can be integrated into EGIS directly if granted permission, OR it can be provided upon request. Please contact Chris Auger (christopher.auger@tc.gc.ca), Senior Real Property Project Officer, Real Property Management, Programs Group for more information.

CSV File Transformation (Centroid):

  1. In FME, transform the Lat/Long to point.

  2. Output to KML, SHP or GDB as required

  3. 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\Property\DFRP_TC\DFRP_TC.kmz

Customization:

  • Schema transformation: Not required.

  • Denormalization: Not required

  • Value coding: Not required

  • Attribute renaming: As required to improve readability

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

  • Geoenrichment: Feature symbolization is recommended to improve visualization

  • Format translation: Not required

  • Language translation: French version available

  • Update frequency: As identified