Skip to Main Content
Forums

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!

Oracle 11g calculate items in a polygon

592815Jun 28 2013 — edited Jul 4 2013

Friends,

I'm new in geo. We have a table contains item information with a position (latitude and longtitude).

The user requests to get item's name in polygon of ABCD areas with below  4 points value (latitude and longtitude)

A: 35N;104W

B: 34N; 112W

C: 33N,97 W

D: 32N, 108W

How do I find these items in requested polygon ABCD area?

select item_Name, time FROM TEST_POS p

WHERE  (GET_TEXT (p.lat_lon.sdo_point.y) between yya and yyb')

and (GET_TEXT (p.lat_lon.sdo_point.x) between xxa and xxb')

and  (p.date < (sysdate -1)

where put c and d condition of latitude and longtitude?

Thanks for help!!

newdba
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2013
Added on Jun 28 2013
#database-key-features, #spatial
10 comments
1,141 views