duckdb / duckdb/duckdb-spatial

Unimplemented type for cast (MULTIPOLYGON WKB_BLOB -> POLYGON_2D)

Open
#80 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
708
Forks
96
Avg merge
1d 21h
Merged PRs (30d)
5

Description

Is there a timeline for when casts like the following will be supported?

```sql
SELECT ST_GEOMFROMWKB(a.geom) geom2, b.*
FROM st_read('geom_xaa.gpkg') a
LEFT JOIN us_geom b
ON ST_WITHIN(ST_Centroid(ST_GEOMFROMWKB(a.geom))::POINT_2D,
b.geom::POLYGON_2D)
limit 1;
```

```
Error: Conversion Error: Unimplemented type for cast (WKB_BLOB -> POLYGON_2D)
```

```sql
SELECT ST_GEOMFROMWKB(a.geom) geom2, b.*
FROM st_read('geom_xaa.gpkg') a
LEFT JOIN us_geom b ON ST_WITHIN(ST_Centroid(ST_GEOMFROMWKB(a.geom)),
ST_GEOMFROMWKB(b.geom))
limit 1;
```

```
Error: Not implemented Error: Geometry type not supported
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.