Skip to main content
  • EN

HI i am having trouble with feature reader in 2017 in that the WHERE clause is not interacting well with the spatial filter envelope query. If i run either in isolation then the process works but together the work bench fails to run.

feature reader is version 9, fme 2017 version is 2017.1.1.0 (build 17650 - win32)

is anyone else have this issue? i cannot run the where clause in a tester after the feature reader due to the amount of data been extracted. we really need to extract to extents and not the entire data base.

any suggestions or help is greatly appreciated.

Hi @qmangaming, thanks for posting your question!

It looks like this is a known issue that was originally implemented with good intentions, but perhaps isn't doing us good anymore. Is it possible to call any geometry functions from your WHERE clause in order to combine spatial and attribute filtering together? Or perhaps try that from an SQLExecutor? From which format are you attempting to read this large dataset?

Thanks,

Nathan

Hi @qmangaming, thanks for posting your question!

It looks like this is a known issue that was originally implemented with good intentions, but perhaps isn't doing us good anymore. Is it possible to call any geometry functions from your WHERE clause in order to combine spatial and attribute filtering together? Or perhaps try that from an SQLExecutor? From which format are you attempting to read this large dataset?

Thanks,

Nathan

Hi Nathan, thanks for your response.

 

 

I have tried using the sql executor but the reader IBM Informix Spatial is not available in that transformer.

 

 

I am not sure how to incorporate a geometry function into a sql, guess i have some reading ahead of me.

 

 

cheers

 

 

Hi Nathan, thanks for your response.

 

 

I have tried using the sql executor but the reader IBM Informix Spatial is not available in that transformer.

 

 

I am not sure how to incorporate a geometry function into a sql, guess i have some reading ahead of me.

 

 

cheers

 

 

Hi @qmangaming,

 

I'm not very familiar with that format, but I think the documentation here provides a few examples of spatial querying with SQL. Perhaps this is a viable solution. In any case I'll add your question to our existing internal report as perhaps this is something that can be changed going forward. Thanks for posting and contributing to the community!

 

 

Best,

 

Nathan

@qmangaming

HI,

Create a spatial query with a spatial object defining the extent you want to use as a filter.

There is a IBM Informix spatial reader in the Reader Gallery.

Alas, the sql creator/executor does not offer this. So no sql building there...

Reply


Community Stats

30,364
Posts
115,373
Replies
38,147
Members
Terms & ConditionsCookie settings
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.