GPS Forums

GPS POI Tools Forum

File is Geo Coded and I want to Map it What do I use

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
poidbs_ wrote:
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


GPS POI Tools



Page 1 of 1
Permalink File is Geo Coded and I want to Map it What do I use