Message | ||
---|---|---|
Posted by poidbs_ File is Geo Coded and I want to Map it What do I use I have a file that is GeoCoded and I want to map it. It has over 10,000 waypoints that I need put into Mapsource for Garmin. I cannot get it to work. Can some one help me PLEASE :( Below is a cut from the CSV file. This should not be so difficult. Longitude Latitude Account Address1 City State Postalcode Main Phone Accuracy -118.418 34.20137 D & B TRANSMISSION 13121 SHERMAN WAY UNIT H NORTH HOLLYWOOD CA 91605 Building -118.315 34.17079 D & D AUTO COLLISION 307 S VICTORY BLVD BURBANK CA 91502 Building -117.208 32.75633 D & D TOWING 3428 PICKETT ST SAN DIEGO CA 92110 Building |
||
Posted by Guest Some help is here... Your file is a TSV (tab separated values). Replace all tabs with commas (CSV) and open it with POI Editor to see if it works: http://garmin.gps-data-team.com/extra/ |
||
Posted by poidbs_ File Geo Coded but Alot of Errors and Miissing Extra data I adjusted the format and had to submit the file with less than 1000 lines at a time and I was able to geocode the locations. BUT, it only geocoded the location and picked up the Accounts name. The remainder of the data was lost. How do I get the entire line of information to be included in the file? |
||
Posted by Guest How to import POI Editor CSV file I replaces all tabs with commas, removed duplicated commas, loaded the file with POI Editor and here is the result: ;Longitude,Latitude,Name,Address 1 -118.418,34.20137,"D & B TRANSMISSION - 13121 SHERMAN WAY UNIT H; NORTH HOLLYWOOD; CA 91605 Building; " -118.315,34.17079,"D & D AUTO COLLISION - 307 S VICTORY BLVD; BURBANK; CA 91502 Building; " -117.208,32.75633,"D & D TOWING - 3428 PICKETT ST; SAN DIEGO; CA 92110 Building; " Cheers
|
||