Thursday, September 10, 2009

Online Batch Geocoding – Address Locators and Street Networks A Thing Of The Past

Here’s a handy website that will leave you wondering why you ever dealt with standardizing addresses, building address locators, or trying to find a decent street network for geocoding:

The website uses the Yahoo! Geocoding API to locate street addresses and convert them to latitude and longitude coordinates in decimal degrees using the WGS84 coordinate system. Street level geocoding is available for the United States, Canada, and many European countries (see the Data Coverage section on the website for a complete list). The geocoder runs relatively fast and generates accurate results.

How to use:
Ensure that your address data is broken into four fields:
1. Address (house number, street name, and street type)
2. City
3. State/Province or Country (Europe)
4. Zip/Postal Code

If your data is in an Excel spreadsheet, select all of the cells, click copy, and then paste the contents in the space provided on the website (under step #2). Follow the easy instructions and click Run Geocoder. Once it’s done running, two columns are added to the table for latitude and longitude (bg_lat and bg_long). The results are displayed in a text box under Step #6. Follow the instructions for getting this data back into Excel.

Once you have your data back into Excel, you can easily create point features for your addresses. Ensure the new spreadsheet containing the fields for latitude and longitude is saved. In ArcMap 9.x (with ArcView, ArcEditor, or ArcInfo licenses), select Add XY Data… under the Tools menu.

Locate the Excel spreadsheet and set the X and Y values to the appropriate fields in the table. Select an appropriate coordinate system and click OK.

An event layer containing the point features of your addresses are added to the Table of Contents. *To store this layer as a shapefile or feature class, you must export the features in the event layer.* Do this by right clicking the layer in the Table of contents and selecting Data  Export Data…

Navigate to the appropriate directory for storing the data and click OK.

1 comment:

  1. Thanks for this. I'll use it in my new work. Here U have a link to restaurant equipment and restaurangutrustning. So, check it whan you will have a free time :)