calgary-ca/flood-extents-from-june-22-2013-sqfh-d2dp
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 1 month ago

Flood extents from June 22, 2013

The flood extents line was manually delineated from an aerial photo taken on June 22, 2013, and does not represent the peak or maximum flood extents during the June 2013 flood event. This aerial photo was taken somewhat after the flood peak had passed. Actual peak flood extents may have been greater than shown. There may be some error in the extents shown due to the method used for creating the line from the aerial photo (interference of trees, shadows, etc. when interpreting the location of flood water in the photo).

Export as <a href="https://data.calgary.ca/api/geospatial/sqfh-d2dp?method=export&format=Shapefile">Shapefile</a> or <a href="https://data.calgary.ca/api/geospatial/sqfh-d2dp?method=export&format=GeoJSON">GeoJSON</a>.

The approximate flows at the time the aerial photo was taken:

-Bow River upstream of where the Elbow River joins it: 1575 m3/s at time of aerial photo (1840 m3/s at 2013 flood peak flow)

-Elbow River downstream of Glenmore Dam: 550m3/s at time of aerial photo (700 m3/s at 2013 flood peak flow)

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" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"calgary-ca/flood-extents-from-june-22-2013-sqfh-d2dp\".\"flood_extents_from_june_22_2013\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • flood_extents_from_june_22_2013
     
     
     
     
     
Upstream Metadata