Sunday, March 04, 2007

Map Multiple Locations / Find Address Coordinates

location based services


Locate multiple addresses - calculate distances - make your own mashup map - instantly. Take any kind of street address list, for example copied from Excel, and geocode the addresses to get latitude and longitude coordinates using the tool below. The data can then be mapped in your browser, downloaded into Google Earth, saved to a web page, or transferred back into your spreadsheet. You can also use this tool to calculate distances to multiple addresses from a single point, or get quick driving directions to multiple destinations. Mapping multiple locations with your own custom data takes seconds, just follow the 6 steps below to plot your own data on a fully interactive multi-point map. It's fast, easy, and - free to use!
Step #1Start by putting your data in a compatible delimited format(tab-delimited is easier for copying from an external source, bar-delimited should be used for hand entry):
Tab Delimited (Download Excel Map Template) Bar ("") Delimited
Step #2Copy/paste addresses into the table below, or try it out with the example data provided:(if you only have one address, you can use our Single Address Lookup Tool) # Example of tab-delimited source, just copy/paste your own tab-delimited file over this
# Make sure the FIRST LINE CONTAINS COLUMN NAMES, you can have as many columns as you want
Address City State Zipcode Name Phone Number Group URL Image
1 Crossgates Mall Road Albany NY 12203 Apple Store Cross Gates (518) 869-3192 Example Group 1 http://www.apple.com/retail/crossgates/ http://images.apple.com/retail/crossgates/images/crossgates_vert110804.jpg
116 Galleria Buffalo NY 14225 Apple Store Walden Galleria (716) 685-2762 Example Group 2 http://www.apple.com/retail/walden/
630 Old Country Rd. Garden City NY 11530 Apple Store Roosevelt Field (516) 248-3347 Example Group 3 http://www.apple.com/retail/rooseveltfield/ http://images.apple.com/retail/rooseveltfield/images/rooseveltfield_vert110105.jpg
160 Walt Whitman Rd. Huntington Station NY 11746 Apple Store Walt Whitman (631) 425-1563 Example Group 3 http://www.apple.com/retail/waltwhitman/ http://images.apple.com/retail/waltwhitman/images/waltwhitman_vert100405.jpg
9553 Carousel Center Drive Syracuse NY 13290 Apple Store Carousel (315) 422-8484 Example Group 2 http://www.apple.com/retail/carousel/
2655 Richmond Ave. Space #2600 Staten Island NY 10314 Apple Store Staten Island (718) 477-4180 Example Group 1 http://www.apple.com/retail/statenisland/
7979 Victor Road Victor NY 14564 Apple Store Eastview (585) 421-3030 Example Group 1 http://www.apple.com/retail/eastview/
1591 Palisades Center Drive West Nyack NY 10994 Apple Store Palisades (845) 353-6756 Example Group 2 http://www.apple.com/retail/palisades/
125 Westchester Ave. White Plains NY 10601 Apple Store The Westchester (914) 428-1877 Example Group 3 http://www.apple.com/retail/thewestchester/
103 Prince Street New York NY 10012 Apple Store SoHo (212) 226-3126 Example Group 2 http://www.apple.com/retail/soho/ http://images.apple.com/retail/soho/images/soho_vertical102804.jpg
(example file will load automatically upon selecting a format, click here to turn off example loading.
toggleExample(0);
)
Step #3Click "Validate Source" to ensure data format is readable and populate column data:

Step #4
Select appropriate columns from the drop-downs below. Use address/city/state for exact map, or city/state or zip can be used for regional map:
Location Fields

Map Fields (not required)
Address

Title

City

Description
All Remaining Fields
State / Province

Group By
Don't Group
Zip

URL
Use Google Maps
Image URL
Yahoo! Location Map
Map Options
(Note: URLs and Image URLs should start with "http://" or they will not work properly.)
Calculate (straight line) distance from first address in miles kilometers Show field names in map description (when using "All Remaining Fields" option)
Select a default map view to show street satellite hybrid
Step #5Click "Run Geocoder" and wait for geocoding to finish:

Step #6
Geocoding results are below, you can copy/paste this back into a spreadsheet or import into a database. Right click on the form below and click "Select All", then right click again and click "Copy." Formatting is maintained but 2 columns containing coordinates are added: bg_lat (latitude), bg_long (longitude):
You're done! Now that you have coordinates for your data, want to see your results on a map? Below is a map of the first 100 geocoded results. Click on each point to get the information from that record.


More Mapping OptionsNow that you've geocoded your custom address data,want to display it on your own web page? or download it into Google Earth?:


google_ad_client = "pub-4866411333549870"; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "E0E0E0"; google_color_bg = "FFFFFF"; google_color_link = "0000CC"; google_color_url = "008000"; google_color_text = "000000";
What could I use this for?
Plot Multiple Address Points on a Map - Copy directly from spreadsheet program such as Excel or the free equivalent OpenOffice Calc.
Multiple Destination Driving Directions - Location points are linked to Google Maps for driving directions ("Calculate Distance" option.)
Distance Calculator - Calculate the distance in miles or kilometers to several locations from a single address.
Satellite Photos - Addresses are linked to Google Maps for satellite photos and driving directions.
Make your own Google Earth KML - Quickly create KML files with your address data for 3D viewing data in Google Earth.
Locate several address coordinates for use in development of a online map mashup using Yahoo Maps or Google Maps.
Save your multiple mapped locations and associated data to a web page for later use.
Import latitude/longitude coordinates into a SQL database for usage in a GIS application.
Plan a road trip - make yourself a road trip map for your next vacation, include hotel addresses and sites to see.
Plot a list of real-estate property addresses on a map with photos to link from a web site or for emphasis in a presentation.
House Hunters - use a saved location map to keep a reference index of your favorite properties.
Outlook and Thunderbird both support exporting their address book to tab-delimited formats, use this tool to make a map of your contacts list.
Get center coordinates (centroids) for a listing of zip codes, cities, or states.
For quick single address geocodes, zip code, city or state centroids use our Single Address Lookup Tool
Kids - you now have your own personal paper route mapper!
This free service is supported by donations and advertising. If you find this service useful, please feel free to send a donation by clicking the donate button on the right. Your support is appreciated, and will go towards paying maintenance on the server and funding the development of new features.
What is geocoding?To Geocode, is to take a street address and convert it into latitude and longitude coordinates so that it can be displayed on a map. It can also be used to validate address data, or pull back unknown fields such as zip code. It works by finding the associated block face with an address, example: 123 Sesame St, the block would likely be 100-200 Sesame St. When trying to locate the segment the street number, street name, street direction, street type, and the city/state or zip code are all used. Once the segment is found, the location of the address is estimated along the line by using the street address number and the block range (this is the least accurate part of the process.) Simply put: Geocoding makes locating addresses and viewing multiple locations on a map instantly possible.
What makes this geocoder unique?Geocoding on the web is not a new concept, in fact there are many free geocoders available on the web, but this is the first free browser based geocoding service to provide coordinate lookup in bulk and map multiple locations. This tool maps many addresses all at once, rather than one at a time. BatchGeocode.com also provides a more accurate geocoding dataset than others, most of which use TIGER data, which is known to be inaccurate up to several hundred feet in some areas. The Yahoo! Geocoding API which this site uses is based on uses a much more powerful commercial street dataset, one well known as an industry standards for transportation data. Your data will also be kept secure, check here for more information on data security and privacy.
How do I host the map on my site?Just run through the geocoder as normal, and then use the "Save to Map to a Web Page" button. You will have the opportunity to specify a name and description for your map, then you will be sent to the web page where your map is hosted. Just copy the URL and post a link to it on your web site, or send it to a friend, or keep it for yourself. We will not distribute the URL to anyone. To update your data, simply create a new map and update your links. Check our blog for information on creating a static URL for your map.
Data CoverageRight now street level geocoding is only available in the United States and Canada. Country, State, and City level geocoding is available for Europe, Asia, Central and South America, and Australia. We expect Yahoo! will continue to expand coverage of their street level data to the rest of the world soon, keep checking back! The name of the coordinate system used is WGS84, this is the decimal degrees version of the coordinate system commonly used in GPS devices.
About the TechnologyThis tool makes primary use of ON-Demand JavaScript and JSON to dynamically call and interact with the Yahoo! Geocoding API. When bulk geocoding is taking place the end-user browser interacts directly with Yahoo! servers allowing the 5,000 query per day limit to be extended to the end-user IP address. ON-Demand JavaScript + JSON is used instead of the common XMLHttpRequest interface, most commonly associated with AJAX, because it allows for communicating with a different domain other than the one the page is served from. The rest of the tech is a small JavaScript application that parses the user's tabular input and sends it line by line to the Yahoo! geocoding service. BatchGeocode.com's ability to interact across many domains makes it once of the first true Web 2.0 applications that really works!

No comments: