Brooklyniancommunity archive · read-onlyContact

Google Maps

modsquad
modsquad
edited November -1 in The Lounge / Random Stuff
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?

Comments

  • konakazi
    konakazi
    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
    modsquad
    Thanks konakazi! This is going to be fun!
  • ps sarah
    ps sarah
    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
    modsquad
    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
    arches
    What format are the addresses in now? Sounds like a job for the "text to columns" function in Excel.
  • modsquad
    modsquad
    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
    bullyboy
    Good grief.