Skip to main content
Archived

Support native spatial predicates in PostGIS

Related products:Transformers

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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

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