--- theme: seriph layout: cover title: Data for Canada - Orthoimagery author: Diego Ripley class: text-center drawings: persist: false transition: slide-left comark: true hideInToc: true favicon: 'https://www.dataforcanada.org/favicon.svg' routerMode: hash --- --- layout: full transition: slide-up --- # Data Portals --- layout: full transition: slide-up --- # Datasets --- layout: full transition: slide-up --- # Servers WMS, WMTS, ESRI. --- layout: center --- | Province | Data sources | Datasets | Storage | |------------------|--------------|----------|----------| | Quebec | 1 | 1 | 117.0 TB | | New Brunswick | 1 | 12 | 13.1 TB | | Ontario | 8 | 63 | 6.0 TB | | Alberta | 7 | 75 | 3.9 TB | | British Columbia | 10 | 58 | 3.6 TB | | Manitoba | 1 | 9 | 891.2 GB | | Yukon | 1 | 1 | 703.5 GB | | Total | 29 | 219 | 145.4 TB | --- layout: center --- # Processing Pipeline ```mermaid {scale: 0.5} flowchart TD Source["Source Imagery"] COG["Cloud Optimized GeoTIFF"] Tiles["PMTiles"] STAC["STAC Metadata"] STACGeoparquet["STAC GeoParquet"] Mirrors Source --> COG COG --> Tiles COG --> STAC Tiles --> STAC STAC --> STACGeoparquet STACGeoparquet --> Mirrors click COG "https://cogeo.org/" _blank click Tiles "https://github.com/protomaps/PMTiles/blob/main/spec/v3/spec.md" _blank click STAC "https://stacspec.org/" _blank click STACGeoparquet "https://radiantearth.github.io/stac-geoparquet-spec/latest/" _blank ``` --- layout: center --- # PMTiles [Demo](https://source.coop/dataforcanada/d4c-datapkg-orthoimagery/processed/ca-on_province_of_ontario-2024A000235_drape_eastern_ontario_orthoimagery_d4c-datapkg-orthoimagery_2024_16cm_v0.1.0-beta.2.pmtiles) --- layout: center transition: slide-up --- # COG [Demo](https://data.source.coop/dataforcanada/d4c-community/presentations/presentation-02/cog_example/index.html) --- layout: full transition: slide-up --- # 3 Band RGB ```bash gdal_translate vancouver_2022.sid vancouver_2022.tif \ -of COG \ -co COMPRESS=WEBP \ -co QUALITY=100 \ -co BLOCKSIZE=512 \ -co OVERVIEW_RESAMPLING=CUBIC \ -co NUM_THREADS=ALL_CPUS \ -co STATISTICS=YES \ -co BIGTIFF=IF_SAFER ``` --- layout: full --- # 4 Bands or More ```bash gdal_translate kitchener_2021.sid kitchener_2021.tif \ -of COG \ -co COMPRESS=ZSTD -co LEVEL=22 -co PREDICTOR=YES \ -co BLOCKSIZE=512 \ -co OVERVIEW_RESAMPLING=CUBIC \ -co NUM_THREADS=ALL_CPUS \ -co STATISTICS=YES \ -co BIGTIFF=IF_SAFER ``` --- layout: full transition: slide-up --- # STAC Metadata --- layout: full transition: slide-up --- # DuckDB Query Records that intersect Montreal, QC ```sql COPY ( SELECT * FROM read_parquet('https://data.source.coop/dataforcanada/d4c-datapkg-orthoimagery/archive/ca-qc_government_and_municipalities_of_quebec-2026A000224_d4c-datapkg-orthoimagery_orthorectified_imagery_from_quebec/items.parquet') WHERE bbox.xmin <= -73.4766 AND bbox.xmax >= -73.9742 AND bbox.ymin <= 45.7048 AND bbox.ymax >= 45.4100 ) TO 'montreal_items.parquet' (FORMAT parquet); ``` --- layout: center transition: slide-up --- --- layout: center --- --- layout: center class: text-center --- # Get Involved - [d4c-datapkg-orthoimagery on GitHub](https://github.com/dataforcanada/d4c-datapkg-orthoimagery) - Download from [Source Cooperative](https://source.coop/dataforcanada/d4c-datapkg-orthoimagery) - diegoripley@dataforcanada.org