Skip to main content
Question

Extracting multi geometries from PostGIS database with featurereader


I am trying to read data from a large PostGIS database. Because the database is so large I am using the featurereader and the initiator as a spatialfilter.

However, I discovered that not all the data from the PostGIS database is loaded. The PostGIS database contains tables with multiple geometry types. For example there is one table called "wall" containing both polyline and polygon geometries.

It seems like the featurereader uses the first encountered geometry type from a feature and ignores all other types. In my case it only loads polyline geometries from the wall table.

Is there a way to also load the other geometries with the featurereader? Or another way to load a large PostGIS database while using a spatialfilter where I do not have this problem?

2 replies

david_r
Evangelist
  • October 14, 2019

You may want to contact Safe support for this one, in addition to voting for this (old) idea:

https://knowledge.safe.com/idea/30260/postgis-reader-should-handle-multiple-geometry-col.html

 


jorge_vidinha
Contributor
Forum|alt.badge.img+2

Could an sqlcreator/sqlexecutor with an SQL filter by  ST_GeometryType() or GeometryType()  be helpfull ? 

ST_GeometryType() -> 'ST_Linestring', 'ST_Polygon','ST_MultiPolygon' etc 

GeometryType()  -> 'LINESTRING', 'POLYGON', 'MULTIPOINT', ...

ST_GeometryType(geom) = 'ST_LineString'

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings