So to clean up the addresses would you build an address form with: Number [ six digit textbox numeric only] Dir [ E.N.S.W. Dropdown] Street [ 30 character text box alpha only] Sufix [ Dropdown with the 25ish approved extensions] zipcode [ 5 digit numeric only] +4 [ 4 digit numeric only]
What a nightmare for your data entry people. they already complain about my dropdowns for MR/Mrs Jr/Sr lol. where's the happy medium? On 8/17/06, Turetsky, Seth <[EMAIL PROTECTED]> wrote: > > Wanted to leave it open, as I may rather have driving distance in the > future. > But also, we want to do this for our UK offices as well. Seems at least > M$'s mapping api's took postal code as well as zip. > > What would a table of worldwide postal/zip codes and lat/long cost? > > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 17, 2006 12:46 PM > 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:250181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
