Icon for Socrata external plugin
Open repository in Console
Updated almost 3 years ago
Indexed 2 hours ago


This spatial data represents the drainage infrastructure that exists at a depth less than 1.5 m below ground. The colour assigned to this is data is Red.

This spatial data was created as a result of a 2016 study, using 2014 data, done for the Edmonton area to determine the vulnerable drainage and sewage areas of Edmonton in regards to a 1 in 100 year rainfall event.

Due to the constant changing of subsurface infrastructure (adding, upgrading, etc.) combined with the constant changing definition of a 1 in 100 year rainfall event (based on historic rainfall amounts), this raster file reflects the results of a study done in 2016 and should neither suggest previous year’s vulnerabilities nor future year’s vulnerabilities.

For a more regional Edmonton area breakdown of the Study’s results:


There are three different colour to the vulnerability of the roadways and the corresponding ponding depth that would occur for that area during a large rainstorm.

Those colours are:

Green (representing the depth from surface that sanitary flows can surcharge from less than 2.5 m)

Yellow (representing the depth from surface that sanitary flows can surcharge from 1.5 to 2.5 m)

Red (representing the depth from surface that sanitary flows can surcharge from greater than 1.5 m)

This Raster file is best viewed overlaid with the 2016 Flood Mitigation Study - Drainage and Sanitation Surcharge Map; as the various coloured areas follow the subsurface infrastructure (and the corresponding roadways if you are also viewing the street map as a layer).

Disclaimer: No Warranty with Flood Risk Maps.

Your use of the flood risk maps is solely at your own risk, and you are fully responsible for any consequences arising from your use of the flood risk maps. The flood risk maps are provided on an “as is” and “as available” basis, and you agree to use them solely at your own risk. There are no warranties, expressed or implied in respect to the flood risk maps or your use of them, including without limitation, implied warranties and conditions of merchantability and fitness for any particular purpose.

Please note that the flood risk maps have been modified from their original source, and that all data visualization on maps are approximate and include only records that can be mapped.

This dataset is based on 2014 information and will not be updated further. The model is based on a theoretical, worst-case scenario storm that has never occurred in the Edmonton area.

Model Accuracy:

The LiDar used was a 5 meter grid system. LiDar has an accuracy of ? cm horizontally/vertically. Bare Earth LiDar was used in for this model surface.

This is a spline fit interpolations model. This is a 1D-1D model with 2D interpolations.The accuracy of the information provided in these data sets is plus or minus 10 cm vertically, and 10 cm horizontally.

The 100 year flood was based on the 2015 Edmonton 4 year Chicago storm event over 20 plus neighbourhoods. The data is a collection of the worst case scenario of model runs.

This is a common practice for Edmonton drainage models. These models are high level concept and projects determined from this data set will undergo finer, more detailed modeling.

These maps are a visual representation and intended to be used when prioritization of the best engineering solutions that are scheduled to be brought forward to Utility Council to mitigate future flooding in the City. The best engineering solutions are high level concept designs and require further modeling and design. At the time of the PDF release, November 9, 2016 there was no funding for any projects to be completed or for further design. Strategy will be brought forward to Utility Committee on June 7, 2017. Council will be determining funding and rate of project completion.

The Storm size used in these models are larger than

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/red-v9r8-s4bi\".\"red\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • red
Upstream Metadata