What happens?
Hi, thanks for all your work on this. I think the recent 1.5 release induced a bug related to how CRS attributes in the schema are stored or read, which prevents reading geospatial data from parquet files.
To Reproduce
import duckdb
df = duckdb.read_parquet("s3://spatial-ucr/census/administrative/counties.parquet")
df.df()
this works fine on 1.4.4 and gives a table like this
but using duckdb version 1.5 gives
NotImplementedException: Not implemented Error: Unsupported type "GEOMETRY('{"$schema":"https://proj.org/schemas/v0.7/projjson.schema.json","type":"GeographicCRS","name":"WGS 84","datum":{"type":"GeodeticReferenceFrame","name":"World Geodetic System 1984","ellipsoid":{"name":"WGS 84","semi_major_axis":6378137,"inverse_flattening":298.257223563}},"coordinate_system":{"subtype":"ellipsoidal","axis":[{"name":"Geodetic latitude","abbreviation":"Lat","direction":"north","unit":"degree"},{"name":"Geodetic longitude","abbreviation":"Lon","direction":"east","unit":"degree"}]},"scope":"unknown","area":"World","bbox":{"south_latitude":-90,"west_longitude":-180,"north_latitude":90,"east_longitude":180},"id":{"authority":"EPSG","code":4326}}')" for DuckDB -> NumPy conversion
(happening on all architectures)
OS:
osx
DuckDB Package Version:
1.5
Python Version:
3.14
Full Name:
eli knaap
Affiliation:
uci
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration to reproduce the issue?