/
Alberta Major Oil and Gas Projects

Alberta Major Oil and Gas Projects

Description

Alberta Major Oil and Gas Projects is a subset of Alberta Major Projects. It is an inventory of private and public sector projects in Alberta valued at $5 million or greater. Projects are grouped into the following categories:

  • Oil and Gas

  • Pipeline

  • Infrastructure

  • Industrial

  • Commercial

  • etc.

Originator

  1. Government of Alberta

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

Major Oil and Gas Projects

Alberta Government

Excel XLSX

Current

N/A

N/A

Free

https://majorprojects.alberta.ca/#/

Click XLSX Full Dataset Download

Remarks

  1. Uses FME httpcaller to download spreadsheet.

Process for EGIS integration

  1. FME workflow automation uses httpcaller to download Excel spreadsheet direct from source and geocode using Lat/Long for output to EGIS portal.

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\EnvironmentalAffairs\ALbertaOilSands\AlbertaOilSands.kmz

Customization:

  1. Schema transformation: As required

  2. Denormalization: Not required

  3. Value coding: Not required

  4. Attribute renaming: As required to improve readability

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

  6. Geoenrichment: Feature symbolization is recommended to improve visualization

  7. Format translation: Not required

  8. Language translation: French version available for some dataset