GPS

[Walter Vaughan]

I do this in SQL not filePro with ZipCodes. I have a Zip Code/Lat_Long table
that I reference and most of the lifting is done in a WHERE clause

WHERE     (3959 * ACOS(COS(RADIANS(37.9747)) *
COS(RADIANS(dbo.COM_ZipCode.Latitude)) *
COS(RADIANS(dbo.COM_ZipCode.Longitude) - RADIANS(- 87.5558)) 
                      + SIN(RADIANS(37.9747)) *
SIN(RADIANS(dbo.COM_ZipCode.Latitude))) < 100)

That would give me zip codes within a hundred miles of Evansville IN
(37.9747, 87.5558). Note latitude is used twice in formula

Never had to develop this for filePro. Sorry :(

-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com]
On Behalf Of Ted B Dodd
Sent: Tuesday, January 27, 2015 6:49 PM
To: filepro-list at lists.celestial.com
Subject: GPS

I need an algorithm of sorts.  I have the coordinates of a container stored
in a record and they are in two fields.  For example, one field will contain
35.64321 as the North coordinate and 101.45675 as the West coordinate. (I
strip off the negative sign)  If a person calls at a different coordinate I
need way of finding the closest container.    Can someone please help with
the calculation?


Ted B
Aka ted-b-dodd at big-foot.com
Remove the dashes


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list