> 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:250257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
