Google Maps

modsquad · January 2009

I have about 100 addresses in lower Manhattan that have to be put in some order that makes for the most efficient way to walk from one to the next. It involves monthly checking of sprinkler systems. Is there a way in Google Maps that allows for the listing of multiple addresses without using the "get directions" feature. If I can "see" the addresses I can figure the walking route without Google's lines and arrows cluttering the map. Am I stupid or what?

konakazi · January 2009

You can add locations to Google Maps and it will put thumb tacks on those spots with the information you entered about those locations.

Add a place:

1. Search for the place you wish to add to determine if it is already listed.
2. If it is not, in the left panel, click Add a place to the map. A marker appears in the center of the map.
3. Drag the marker to the correct location or enter an address. Click Next.
4. Add details for the place and click Save.

modsquad · January 2009

Thanks konakazi! This is going to be fun!

ps sarah · January 2009

You can also cut and paste the list here:

http://www.batchgeocode.com/

It will map them out for you without having to do them one by one.

modsquad · January 2009

Thanks Sarah, If rerunning the single route by hand works in saving time then it might be worth learning how to use excel and dumping the 600+ addresses. The last spread sheet I used was Lotus 1 2 3 on the original IBM PC. Ha! Carnivore is probably still using it in between games of Tempest.

arches · January 2009

What format are the addresses in now? Sounds like a job for the "text to columns" function in Excel.

modsquad · January 2009

arches wrote: What format are the addresses in now? Sounds like a job for the "text to columns" function in Excel.

They are typed as in "typewriter", with lines drawn between them with a wooden ruler and xeroxed each month in order to be taken into the field and filled in with information. These lists are from 1953 and there was an attempt to make a walking route based on a Hagstrom Manhattan map but as the list grew over the last 50 years the effort to relist was given up. I'm actually billing them to do the inspections but see such an incredible waste of time walking back and forth that I couldn't resist trying to reorganize.
I appreciate a lot of old school technology to the point of being prejudice but it boggles the mind when you walk into a company that functions like it was 1960.

bullyboy · January 2009

Good grief.

Google Maps

Comments

Howdy, Stranger!

Categories