[postgis-users] HELP - Geometrycollection - CREATE VIEW - Empty Table

Tõnis Kärdi Tonis.Kardi at kemit.ee
Thu Dec 14 05:11:14 PST 2017

Hi Oli,

Have you checked the distinct values you are getting for geometrytype? Something in the lines of

select distinct geometrytype(geom) from cp_parcel_postgis;


I think the geometrytype of a geometrycollection is simply 'GEOMETRYCOLLECTION'. So most probably the filter you are using filters everything out.

All the best,

Saatja: postgis-users <postgis-users-bounces at lists.osgeo.org> ofoerster at posteo.de <ofoerster at posteo.de> nimel
Saadetud: 14. detsember 2017 14:30
Adressaat: postgis-users at lists.osgeo.org
Teema: [postgis-users] HELP - Geometrycollection - CREATE VIEW - Empty  Table

Hello PostGIS Community,

I have a Problem. I have a table with a geometry collection (polygon and
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
     , inspire_local
     , inspire_namespace
     , label
     , nationalcadref
     , areavalue
     , validfrom
     , beginlifespanversion
     , zoning
     , geom::geometry(Polygon, 25833)
     FROM cp_parcel_postgis

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,
postgis-users mailing list
postgis-users at lists.osgeo.org

More information about the postgis-users mailing list