Currently if initiating features are sent to a FeatureReader with a null geometry and the spatial filter is set to Envelope Intersects the feature reader returns every single record in the table. Initiators with null geometries should be output via the rejected port where the FeatureReader is using a spatialfilter
Archived
Improve handling of null geometries by FeatureReader with SpatialFilter
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.
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.
+2Recreated in 2017 - easy to see why with following...
From log with Null geometry:
ORACLE Reader: Executing SQL Statement `SELECT "COUNTY"."GID", "COUNTY"."NAME", "COUNTY"."GEOM" FROM "COUNTY"' to obtain features for feature type `COUNTY'From log with Box geometry:
ORACLE Reader: Executing SQL Statement `SELECT "COUNTY"."GID", "COUNTY"."NAME", "COUNTY"."GEOM" FROM ( SELECT * FROM "COUNTY" A WHERE (MDSYS.SDO_RELATE( A.GEOM, mdsys.sdo_geometry(2003,29902,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(280000,410000,400000,440000)),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE') ) "COUNTY" WHERE 1 = 1' to obtain features for feature type `COUNTY'
+22- Safer
PR 78826 has been filed to address this. Once the fix has been implemented, we'll update the idea here. We appreciate your involvement in helping us make FME even better!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.