The Open Database of Infrastructure

Skip to text

Text begins

The Open Database of Infrastructure (ODI) is a collection of open data containing the types and locations of a selection of infrastructure across Canada, and is made available under the Open Government Licence - Canada.

The categories covered in the ODI are bridges, tunnels, solid waste, pedestrian and cycling paths, public transit stops, potable water, storm water, and wastewater.

The ODI brings together data primarily originating from municipal, provincial, and federal open data portals. This database aims to enhance access to a harmonized collection of business data across Canada and is a component of the Linkable Open Data Environment (LODE).

Data sources and methodology

The inputs for the ODI are primarily datasets provided by municipal, regional, or provincial sources available to the public under an open data licence.

The current version of the database (version 1.0) contains approximately 2 million records. Datasets were collected between November 2022 and March 2023 from their respective sources and processed and harmonized into the ODI. Within the original datasets, each data provider attached a different set of variables. To see the full list of variables and more information on licencing provided by a given data provider, please visit the original sources which are linked in the metadata document that accompanies the ODI.

The ODI does not assert having exhaustive coverage and may not contain all facilities in scope due to licencing conflicts or lack of open data in certain regions.

For each infrastructure category, there is some variation in the variables that are available. Excluding public transit, the variables shared across infrastructure categories are listed below:

• Infrastructure Type
• Infrastructure Subtype
• Status
• Provider
• Municipality Name
• Province
• Province Unique Identifier
• Census Subdivision Name
• Census Subdivision Unique Identifier
• Longitude
• Latitude
• Unique ID

For more information on how the database was compiled, and for a full list of variables by infrastructure type see the metadata document that accompanies the ODI.

Downloading the ODI

For ease of download, the ODI and accompanying metadata document is provided in a compressed format.

• ODI-BDOIn-En

Visualizing the ODI

The ODI content is available for visualization on a map using the Linkable Open Data Environment Viewer.