The grid (core) · console.warn

the GeoParquet metadata does not say which C...

Printed by The grid (core), prefixed [lattice], since 1.73.0.

Warnings reference › source.duckdb.spatial.crs.*

Identifier: source.duckdb.spatial.crs.*
Raised by: The grid (core)
Since: 1.73.0

What happened

The file's geo metadata gives the column a null or unreadable crs, which GeoParquet defines as unknown. The adapter uses the coordinates as stored, as longitude/latitude; if they are projected (metres), every spatial filter and every map position is wrong.

The fix

Name the system the file is in.

The smallest fix

duckdbAdapter({ connection, from: "read_parquet('depots.parquet')", spatial: { crs: 27700 } })

Reference

Covered in full at the API reference.