Results 1 to 2 of 2

Thread: Geographic location selects

  1. 04-25-2003, 10:26 AM #1
    zeker00
    zeker00 is offline Registered User
    Join Date
    Apr 2003
    Posts
    1

    Question 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
    Reply With Quote Reply With Quote
  2. 04-25-2003, 10:54 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    give some sample data and the desired output, so that we can guide you in right direction.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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