On Wed, Jan 7, 2015 at 8:06 AM, Jeff Johnson <[email protected]> wrote: > On 1/5/2015 8:54 AM, Jeff Johnson wrote: > Just so you know what it is that I am doing, I am importing addresses in a > single string and I need to break them out into Address, City, State, Zip > and then I need to add County.
Texas A&M has a free online address standardization service at <http://geoservices.tamu.edu/Services/AddressNormalization/> . They have batch and interactive modes, as well as an API available. You can see how well the interactive parser works with some samples of your data before trying to do a batch job. Note that this will not give you county information, which kind of makes sense as cities frequently cross county boundaries. For counties you probably would want to feed the parsed addresses through a geocoder service, also available at the TAMU website. hth dt -- Dave Thayer Denver, CO _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAAo+qoWA4x=Qo-Y8e3bPd2n0=gpN0kvP7yBUNtpObs=1+xg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
