AWhere, Inc.

Welcome to the AWhere, Inc. Discussion Forums.
Discuss ideas and issues with other AWhere users, search specific topics,
answer a question or post your own questions and maps.
Welcome to AWhere, Inc. Sign in | Join | Help
in Search

After geo-coding my spreadsheet, how do I get it into AWhere?

Last post 09-25-2008, 2:56 PM by rqjeske. 2 replies.
Sort Posts: Previous Next
  •  04-03-2008, 2:53 PM 20

    After geo-coding my spreadsheet, how do I get it into AWhere?

    Go to Add-Ins on the top tool bar.  The drop down menu will contain the choice 'AWhere Import Coordinates'.  This will start the wizard that will guide you through the import process.  Remember to label your spreadsheet columns 'latitude' and 'longitude' so the wizard will pick them up automatically.


    Curt
  •  08-26-2008, 1:07 PM 42 in reply to 20

    (What is geo-coding?) Re: After geo-coding my spreadsheet, how do I get it into AWhere?

    Someone might ask 'What is geo-coding?'...that is the process of determining the latitude and longitude coordinates for a physical address.  You might have a table of your customers' addresses (see a sample of such a table below), and you want to plot those locations on a map.  You can create a map of those locations using AWhere, BUT first, you will need to geo-code each address (give each physical address a lat/long coordinate), because that geo-coding output is what AWhere will need in order to import a table of addresses to create a map of the locations.  There are several websites that provide free geo-coding tools...an example is www.batchgeocode.com .  Follow the instructions on that website to geo-code a table of addresses, which will result in a new table containing your original input addresses, plus two new columns (fields) in the table containing the lat and long coordinates*.  You will then use the 'Import Coordinates' add-in (mentioned in the initial post of this forum thread) to import that table of lat/longs to create a new point map layer in AWhere showing the plotted locations of all of those addresses.

    (Note that for those zip codes in the table below that only have 4-digits, it is understood that there is a leading '0' before those...making it a standard 5-digit zip code.)

    Geo-Coding addresses outside of the U.S. - If your addresses are outside of the U.S., you would want to add one more field to your table...a 'Country' field.  Though, do note that if you are using batchgeocode.com to geo-code addresses in locations outside of the U.S., Canada, or Western Europe, note that you will not likely be able to geo-code down to the street-level, as geo-coding at that precision is not yet available in parts of the world outside of those three regions.  So, the lat/long that is reported back to you for addresses outside of those regions will be just the center of the city, at best...not actual 'on-the-ground' locations.  See the note about 'Data Coverage' near the bottom of the 'batchgeocode.com' homepage for more on that.

    *Tip: before you import (into AWhere) the table of lat/longs (the output from the geo-coding process), you might want to rename the default named lat and long fields to 'Latitude' and 'Longitude', respectively.  The default names that 'batchgeocode.com' gives to those columns ('bg_lat' and 'bg_long', respectively) will not be recognized by the AWhere Import Coordinates add-in as the fields representing latitude and longitude...but if you name them 'Latitude' and 'Longitude' (or 'Lat' and 'Long' will work, too)...AWhere will automatically recognize them (this is what Curt was referring to above when he said to be sure to name the fields in your spreadsheet to 'Latitude' and 'Longitude').

  •  09-25-2008, 2:56 PM 93 in reply to 42

    Re: (What is geo-coding?) Re: After geo-coding my spreadsheet, how do I get it into AWhere?

    To follow-up on that last post in this thread (about Geo-coding)...below is the sample table from that post, but this table below shows the output after that table has been geo-coded.  Note that there are two new fields...Latitude and Longitude.  You would now use AWhere's 'Import Coordinates Add-In' tool to import this table into AWhere in order to create a new point map layer showing the geographic locations of those addresses. 

     (Click here to view a 'Cheat Sheet' with step-by-step instructions for how to import lat/long coordinates.)

    (Side topic - Is Geo-coding the only way to make a table of lat/longs? - If addresses are involved, yes.  But, if you are not dealing with addresses, it is important to clarify that you do not necessarily have to have performed 'geo-coding' in order to have gotten to this point of having a table of Lat/Longs.  A table of lat/longs might also have been the output of a GPS unit that you used while collecting field data, or some other source of lat/long records.  All that to say, a table of lat/long coordinates may be generated/obtained from sources other than geo-coding addresses.)

    Immediately below is the result of using the 'Import Coordinates Add-In' to import that table of lat/longs into AWhere.  The new point map layer that was created by the import process is named 'Sample Imported Points', and is being displayed in the map window (the state boundaries are displayed and labeled only for visual reference).  Also, note that all of the fields from the input table (above) are included as attributes of the new map layer that is created.

    And, to take this demonstration one step further, in the image below I have zoomed the map view down to the location of that West Hartford, CT address from the sample table...it is the pink circle.  Also, I have turned on AWhere's 'MS Virtual Earth' add-in so that Virtual Earth is displayed as the background to the AWhere map window.  Using that as visual reference, you can see that the point that was imported for that address is located along 'Raymond Rd' when displayed on top of the Virtual Earth map.  If you compare its address in the table above, you see that it was positioned correctly on the map.

     

View as RSS news feed in XML