-
Geographic location selects
I have two needs... First, given a table with decimal LATITUDE/LONGITUDE pairs stored, I want to do a <select> into a cursor (or table) for those records within 5.0NM of a target location.
Second, and more difficult, would be performing the <select> but looking for all records within a one-to-N-sided area (specified as decimal LAT/LONG pairs in a clockwise order with point_n extending to point_1 to close the area}.
Can someone point me towards available library/functions that could aid us? This is in support of a non-profit nature group so want to keep cost down.
TIA!
zeker00
-
give some sample data and the desired output, so that we can guide you in right direction.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|