10-04-2018 02:51 AM
We have 2 layers in oracle spatial, a boundary layer and another containing lot polygons.
When I do the spatial filter in Geomedia using select set and change the spatial operator I get different results but not as expected.
If I use operator "Inside" I will get 178 records
and while using "Entirely inside" I will get 184 records
To find out the missing records I exported the data to a local file which showed me the missing records located much inside the boundary feature. (Pls checck the attached screenshot)
Is this expected? or is this a possible bug?
I am using GM Pro 16.5 Build 2614
10-04-2018 04:17 PM
I have seen similar results in past. Ended up being the oracle geometry. Oracle was very fussy about the geometry.
Use Oracle SQL SDO Validate_Geometry commands to check / fix invalid geometry.
10-04-2018 04:49 PM
GeoMedia is passing the spatial filter as a SQL statement to Oracle to process. Oracle passes the results back so the issue is most likely comming from the data / database. Have you spatially indexed your oracle data?
You may want to look at the GeoMedia Oracle Object Model (GOOM) Package which contains some nice easy to use spatial indexing tools. It also has a Quick Start .pdf guide that gives good info even if you do not install the package.