You can nab a function from: http://www.fergusonhouse.com/blog/index.cfm/2006/7/27/coldfusion-geocode -distance-calc
It's pure spherical trig, so the distances you come out with are very accurate. Ken Ferguson 214.636.6126 www.fergusonhouse.com -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 11:46 AM To: CF-Talk Subject: RE: Zipcodes addresses and all that jazz Why not just calculate it yourself? Get a table with lat and long, and use a function to calculate the distance. I found one fairly easy when I build something like this a while ago. > -----Original Message----- > From: Turetsky, Seth [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 17, 2006 9:11 AM > To: CF-Talk > Subject: RE: Zipcodes addresses and all that jazz > > Cool stuff. > So with esri, can you do the routing without showing a map, ie for backend > systems? I would like to get the estimated distance between two zip > codes, store it in a table. And potentially do that for x number of > records. > > -----Original Message----- > From: Paul Hastings [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 16, 2006 10:32 PM > To: CF-Talk > Subject: Re: Zipcodes addresses and all that jazz > > Turetsky, Seth wrote: > > I don't know much about ESRI, but Microsoft allows to get driving > > directions and distance in their JS API(definitely free), google and > > yahoo(I believe) do not. M$'s other web service API(not sure about > > price), which I have not used and not sure if CF can use it, is also > > very extensive. To me, more impressive than google/yahoo. > > so does esri, though these are mostly proof-of-concept for flashforms > (except the last one, we had a survey team's GPS die & the backup didn't > do projections): > > http://www.sustainablegis.com/projects/routing/ > http://www.sustainablegis.com/projects/geocode/flashforms/ > http://www.sustainablegis.com/projects/projection/gcs2utm.cfm > > esri's a *real* GIS company. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
