RCMP Detachment

Owned by Diego Cesa de Meira (Unlicensed)
Last updated: Dec 12, 2019 by Lawrence Chong (Unlicensed)
2 min read

Description

Royal Canadian Mounted Police (RCMP) is the federal and national police force of Canada. The RCMP provides law enforcement at the federal level. It also provides provincial policing in eight of Canada's provinces (Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Prince Edward Island, and Saskatchewan) and local policing on contract basis in the three territories (Northwest Territories, Nunavut, and Yukon) and more than 150 municipalities, 600 aboriginal communities, and three international airports.

Originator

  1. RCMP Web Portal

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

RCMP Detachment

RCMP Web Portal

CSV

2018

As needed

N/A

Free

EGIS Data Folder: RCMPDetachment_pt.gdb.zip
RCMP Listing by Province

Use preprocessed GDB file as provided.

Remarks

  1. The FME workflow automatically scans through RCMP Detachment urls for every provinces/territories and extract the table content and detachment link.

  2. Geocoding of the address uses Bing/AGOL. Unfortunately not all addresses were geocoded correctly.A workaround was to output the initial result into an MS Access database.

  3. Gecoding incorrect Lat/Long using Google Earth.

  4. Export the database to GDB.

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

Process for EGIS integration

CSV File Transformation:

  1. In FME, use the Google Geocoder transformer to geocode by Location.

  2. Expose the returned Lat/Long value.

  3. Transform the Lat/Long to point.

  4. Output to KML, SHP or GDB as required

  5. 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\SafetyAndSecurity\RCMPDetachment\RCMP_Detachment.kmz

Customization:

  1. Schema transformation: As required

  2. Denormalization: No Required

  3. Value coding: Not required

  4. Attribute renaming: As required to improve readability

  5. Attribute removal: Not required.

  6. Geoenrichment: Not required.

  7. Format translation: As required.

  8. Language translation: French version not available.