Hello PostGIS Community,
I have a Problem. I have a table with a geometry collection (polygon and point).
QGIS can not read the geometry collection, so I want to create a view for the polygon type and the point type. My SQL function for the polygon type looks like this:
CREATE VIEW parcel_polygons AS (
row_number() OVER(ORDER BY inspire_local DESC) AS OID
, geom::geometry(Polygon, 25833)
WHERE GeometryType(geom) = ‘GEOMETRYCOLLECTION(POLYGON)’
I do not get any errors and the view is created. Unfortunately, the view is empty.
What am I doing wrong?
Thanks for any help,