Yep, data consistency is a pain no matter what. I work for a global firm, so yes our tables are very complex, but we have that many more data entry and DBAs...that I've never seen. They are employed, so I'm not too worried about them :)
As for this project, the addresses are already in the database, I just need to pull them out and compare. Wait, that sounded easier than it is. I had it working for the US doing the geocoding solution on the fly, but it was very slow even for one record. I want to do it x number of times and globally, not as simple :( -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 2:25 PM To: CF-Talk Subject: Re: Zipcodes addresses and all that jazz 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:250201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
