Matt Travis

@felix-schott I've just had a go at this and can't reproduce the error. Environment Information - open_buildings version: 0.10.0 - Python version: 3.10 - Operating System: Pop!_OS 22.04 Is it...

@felix-schott great, looks like it's not specific to just shapefile but other formats that use .db https://github.com/duckdblabs/duckdb_spatial/issues/141#issuecomment-1763219632

@felix-schott also, I haven't upgraded to DuckDB 0.9.1 as of yet.

I think having the ability to directly pass the WKT is a great idea.

@cholmes i think we could use the OSMnx python library for this.https://osmnx.readthedocs.io/en/stable/getting-started.html#geocoding-and-querying I've got scripts that use it that I can adapt so I'd love to work in this one.

@cholmes I've got experience of creating a QGIS plugin and know others who could help so happy to work on this one with you.

@cholmes happy to take this one on.

@cholmes is it worth thinking about using the dataset-links.csv here https://github.com/microsoft/GlobalMLBuildingFootprints#what-does-the-data-include We could cross ref that with another list that has the iso-2 codes perhaps?

@Maxxen I'm also seeing the error above. `overturemaps download -f geoparquet --bbox -71.063432,42.301047,-71.009501,42.382221 -o boston.parquet -t building` ``` D SELECT id, ST_AREA(ST_GeomFromWKB(geometry)) as area, ST_Area_Spheroid(ST_geomFromWKB(geometry)) AS cartesian_area FROM 'boston.parquet' limit...

@marklit just taking a look at this one and seen that your output from the zip is `land.gpkg` but the st_read uses `test.gpkg`