Orthophoto Repository 2023

Spectral resolution: Colour (3-band)

Spatial resolution: 7.5 cm

Image acquisition date: May–July 2023

Individual GeoTIFF files (~286MB each) may be downloaded via the Google Drive links provided in the dataset.

Folder with all TIF files: https://drive.google.com/drive/folders/1e_OAoNwjIN57x7EUwO4YpzCezzf8qqtr.

The city-wide ECW file (~32GB) may be downloaded from https://drive.google.com/drive/folders/18I3ZjVIdXTUCGZl_0p0Aa8XMSEYvQM8m.

The spatial details for this ECW file are as follows:

CoordSys: Canadian Coordinate Systems

CoordZone: 3TM-114W Central Meridian

CoordDatum: NAD83

CoordUnits: Meters

ESRI WKID: 3776

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 \"edmonton-ca/orthophoto-repository-2023-n2wu-yipf\".\"orthophoto_repository_2023\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.