Skip to main content
Archived

Support native spatial predicates in PostGIS

Related products:Transformers
  • March 8, 2017
  • 0 replies
  • 25 views
J
Forum|alt.badge.img

Currently if you use Feature Reader (PostGIS) with a Spatial filter of anything other than Envelope Intersects, the log says:

2017-03-08 09:22:40| 306.5|  0.0|INFORM|Notice - reader format `POSTGIS' does not support querying by spatial predicate, but supports envelope queries.  FME will create equivalent results by performing spatial predicate calculations locally.  Performance should not be affected.

Obviously PostGIS *does* support the FeatureReader spatial predicates and many others besides -

http://postgis.net/docs/reference.html#Spatial_Relationships_Measurements

It would be nice if FME could use these native filters rather than read in all data within the envelope and use its internal spatial filter to decide which to keep/remove. I'd be surprised if there wouldn't be a performance gain doing it entirely in the database, despite what the log say.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,724
Posts
124,149
Replies
41,216
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.