Skip to content

CRS /schema error on read for geospatial data #375

@knaaptime

Description

@knaaptime

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

Image

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?

  • Yes, I have

Did you include all relevant configuration to reproduce the issue?

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions