extract data Overture buildings theme

buildings_query_duckdb.sql

COPY (
    SELECT
           id,
           theme,
           type,
           version,
           level,
           updateTime,
           height,
           numFloors,
           class,
           JSON(names) AS names,
           JSON(sources) AS sources,
           ST_GeomFromWkb(geometry) AS geometry
      FROM read_parquet('s3://overturemaps-us-west-2/release/2024-01-17-alpha.0/theme=buildings/type=*/*', filename=true, hive_partitioning=1)
     WHERE 
        bbox.minx > -79.938171
        AND bbox.maxx < -79.922957
        AND bbox.miny > 32.782061
        AND bbox.maxy < 32.794544
        LIMIT 10
        )
     TO 'buildings_charleston.geojson'
     WITH (FORMAT GDAL, DRIVER 'GeoJSON', SRS 'EPSG:4326');