How to map a list of addresses
I have a lsit of addresses of customers
I need to show their location in a MAP of the US
I'm doing this manually and every month I update the map
to reflect new customers.
I need to do this automatically but I can't justify a Mapping packge because is only
20 to 30 customers per map once a month.
is there any way to do this easily and preferably with a freee utility?
PS ALready tried excel MAP button but it only works for states
I need to show their location in a MAP of the US
I'm doing this manually and every month I update the map
to reflect new customers.
I need to do this automatically but I can't justify a Mapping packge because is only
20 to 30 customers per map once a month.
is there any way to do this easily and preferably with a freee utility?
PS ALready tried excel MAP button but it only works for states
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to follow up:
I found the 2003 version on e-bay for 14.99 from several e-bay stores:
http://search.ebay.com/streets-and-trips_Computers-Networking_W0QQsofocusZbsQQsbrftogZ1QQfromZR10QQcatrefZC6QQsacategoryZ58058Q26catrefQ3DC6QQsotrZ2QQsosortpropertyZ1QQsosortorderZ1
I found the 2003 version on e-bay for 14.99 from several e-bay stores:
http://search.ebay.com/streets-and-trips_Computers-Networking_W0QQsofocusZbsQQsbrftogZ1QQfromZR10QQcatrefZC6QQsacategoryZ58058Q26catrefQ3DC6QQsotrZ2QQsosortpropertyZ1QQsosortorderZ1
You could build yourself a grid in excel using longitude and latitude data, if you are indeed bootstrapping this process.
Since your data set is small, you can lookup longitude/latitude/census tract data from here:
http://www.melissadata.com/Lookups/index.htm
You can learn about census tract data from http://www.census.gov/geo/www/cen_tract.html
There's also a Geographic Area Reference Manual (PDF) on that same page.
LandView5 - http://www.census.gov/geo/landview/lv5/lv5.html
Spreadsheet mapping in Excel
http://www.softill.com/inside.html
and their demo http://www.softwareillustrated.com/lib/si/mapland.exe
There's also AGIS for Windows
http://www.agismap.com/download.html
and its screenshots http://www.agismap.com/screens.html
Since your data set is small, you can lookup longitude/latitude/census tract data from here:
http://www.melissadata.com/Lookups/index.htm
You can learn about census tract data from http://www.census.gov/geo/www/cen_tract.html
There's also a Geographic Area Reference Manual (PDF) on that same page.
LandView5 - http://www.census.gov/geo/landview/lv5/lv5.html
Spreadsheet mapping in Excel
http://www.softill.com/inside.html
and their demo http://www.softwareillustrated.com/lib/si/mapland.exe
There's also AGIS for Windows
http://www.agismap.com/download.html
and its screenshots http://www.agismap.com/screens.html
There's also this:
Zambia Map Maker
http://www.cnr.berkeley.edu/~alyons/zm/mapping.html
Use Microsoft Map to Display Postal Code Centers in Excel 2000
http://support.microsoft.com/?kbid=213882
I don't know what apps you have available to you, so you could also try the GIS Lounge:
http://gislounge.com/ll/data.shtml
Zambia Map Maker
http://www.cnr.berkeley.edu/~alyons/zm/mapping.html
Use Microsoft Map to Display Postal Code Centers in Excel 2000
http://support.microsoft.com/?kbid=213882
I don't know what apps you have available to you, so you could also try the GIS Lounge:
http://gislounge.com/ll/data.shtml
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Right now what I'm doing is to get the map for every address from yahoo maps and then cut and past the star
location into a master map, as you might guess the process is not very fast.