Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding point in polygon using SDO_CONTAINS not working

719828Aug 28 2009 — edited Aug 28 2009

Hi,

I have an areas table which is being populated with polygons using Mapinfo and I am trying to find out if a specific point is inside this polygon. The data is in WGS84 lat / long (although i have noticed that the SRID is not set accordingly, apparently an issue with creating the geofences from Mapinfo)

I am using the SDO_CONTAINS(geoloc,SDO_GEOMETRY(2003,null,SDO_POINT_TYPE(&LONG, &LAT, null),null,null))

I'm not sure if the issue is to do with Tolerance as the geofences are small only 2sqm approx but when I increase the geofence to approx 50sqm everything seems to work.

This is entry in the user_sdo_geom_metadata table

values('AREAS','GEOLOC',SDO_DIM_ARRAY(SDO_DIM_ELEMENT('Longitude',-180.0,180.0, 0.1),SDO_DIM_ELEMENT('Latitude',-90.0,90.0, 0.1)),null)

Any help would be greatly appreciated.
Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2009

Added on Aug 28 2009

#database-key-features, #spatial

3 comments

1,404 views