CREATE VIEW - Geometrycollection - Empty Table

Das Problem hat sich gelöst durch folgende Funktion:

CREATE VIEW parcel_polygons AS (

SELECT
polys_and_points.*
FROM
(SELECT
row_number() OVER(ORDER BY inspire_local DESC) AS OID
, inspire_local
, inspire_namespace
, label
, nationalcadref
, areavalue
, validfrom
, beginlifespanversion
, zoning
, (ST_dump(geom)).geom
FROM cp_parcel_postgis) as polys_and_points
WHERE
st_geometrytype(polys_and_points.geom) = ‘ST_Polygon’
)

Trotzdem Danke für jegliche Unterstützungsbereitschaft :slight_smile: