Navigation Protection Program (NPP) - Projects

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

Description

All Canadians enjoy the right to navigate their boats (whether they are motorized, canoes or kayaks) through the vast network of oceans, rivers, lakes and canals across the country.

The navigation protection legislation, also known as Navigation Protection Act (NPA) was put in place to oversee projects such as bridges and dams that could affect navigation.

Protecting the public right of navigation is an important element of the new environmental and regulatory system in which important projects are allowed to proceed in a sustainable manner, with a framework that provides for predictable and timely decisions.

The Navigation Protection Program (NPP) Projects is a collection of past approved NPP projects, enabling Officers to assess the accumulative effects on the environment and make smart business decisions.

Originator

  1. Transport Canada, Programs Group, Navigation Protection Program.

Use Cases

  1. As an NPP Officer I want to be able to visualize past projects in the vicinity of project being reviewed so that I can assess cumulative effects on environment.

Source(s)

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

Description

Source

Format

Date

Update Frequency

Metadata

Cost

Link

Remarks

NPP Projects

NWDS Database

Oracle Non-spatial

N/A

Daily

N/A

Free

EGIS Data Folder: NPPProjects_pt.gdb.zip
Contact Stéphanie Talbot

-Use preprocessed GDB file as provided.
-Permission required to access database

Remarks

  1. NWDS is an Oracle Non-spatial database.

  2. Permission required to access the NWDS Database for direct EGIS integration. Contact Stéphanie Talbot (stephanie.talbot@tc.gc.ca), Project Coordinator, Navigation Protection Programs, Programs Group for more information.

  3. Cloud storage for NPP Projects may be restricted.

  4. Preprocessing is recommended as Lat/Long values are not consistent and not verified.

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

Process for EGIS integration

Oracle Direct Integration:

  1. Oracle Database can be directly connected to EGIS if the portal is hosted on TC Enterprise Network.

Oracle Non-spatial Database:

  1. In FME, connect to the database using Oracle Non-spatial Reader with the connection parameters provided by NWDS DBA.

  2. Transform the Lat/Long to point.

  3. Output to KML, SHP or GDB as required.

  4. Import into EGIS

Display Optimization:

  1. Sampled/thinned data (generated using data sampling technique) are displayed at small and medium scale. With scale transition, original data are displayed at large scale thus improve display performance.

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\Marine-NWP\NWP_Projects\NWP_Projects.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: Not required.

  • Format translation: Geocoding using the Lat/Long location

  • Language translation: French version not available.

  • Update frequency: As identified