Skip to content

Instantly share code, notes, and snippets.

@aborruso
aborruso / roads.md
Created October 7, 2024 10:36 — forked from marklit/roads.md
MS Roads Detection in Parquet
$ wget https://usaminedroads.blob.core.windows.net/road-detections/MiddleEast-Full.zip
$ unzip MiddleEast-Full.zip
$ ~/duckdb roads.duckdb
CREATE OR REPLACE TABLE roads AS
    SELECT column0 as iso2,
 ST_GEOMFROMGeoJSON(column1::JSON->'$.geometry') geom