Understanding .csv files
Wed, 08/06/2008 - 3:42am
15 years
|
I have downloaded a couple of .csv files from POI Factory, including Beer Me.csv.
I then look at the file's contents in Excel. In Beer Me, many beer places are just listed by name, no city or state info is included.
I know that these files were not created to be viewed in Excel, but is there an easy way to batch-convert the lat/long info into city and state, or at least state, so I can determine if the file is worth adding to my Garmin 260W.
I can copy one by one into Google maps, but that takes awhile.
Mike L
Breweries
I also wanted to know where the breweries were so I added cities and telephone numbers (I like to call ahead and see what their hours are). I also added Canada and Mexico. If you want it I can email it to you.
Take a peek at this, see if
Take a peek at this, see if this will do the trick!
for those interested:
http://www.pivari.com/csv2kml.htm
Bob
Using Android Based GPS.The above post and my sig reflects my own opinions, expressed for the purpose of informing or inspiring, not commanding. Naturally, you are free to reject or embrace whatever you read.
Broken Link
dog_poop:
Link looks like it's broken.
Tom
Try this link
http://maps.huge.info/reverse.htm
260, 295W, 1490T,2455LMT
csv2kml
[quote=dog_poop]Take a peek at this, see if this will do the trick!
for those interested:
http://www.pivari.com/csv2kml.htm
Bob[/quote]
Here's the corrected link: CSV2KML
Seems like a good tool, thanks for the info.
nuvi 2460LMT
MARINER!!
What is with that avatar?
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold
dead link
dog,
your link is a dead one error 404.
"I can't change the world...But I can change the world in me", U2, Rejoice.
beer me csv
I also wanted to know where the breweries were so I added cities and telephone numbers (I like to call ahead and see what their hours are). I also added Canada and Mexico. If you want it I can email it to you.
emailing to me would be great. also it would help everybody if you made it available on this site
mikelanz81 at gmail dot com
mikelanz -- Garmin nuvi 260W
reverse geocoder
http://maps.huge.info/reverse.htm
thanks for this link, it is very helpful
mikelanz -- Garmin nuvi 260W
would help everybody
it would help everybody if you made it available on this site
mikelanz81 at gmail dot com
Will keep your username handy, needing this file also.
.
What is with that avatar?
nuvi 2460LMT
.csv files?
Hey everyone! I'm pretty much new to this site and the whole GPS technology in general. I own a Garmin 260 and I love it,but one thing I dont understand is how am I supposed to see these POI files or the info contained therein once I downloaded them to the internal memory.Sorry about the dumb question.
Garmin Nuvi 260,Macbook Pro,OSX 10.5
Check where to:
Hey everyone! I'm pretty much new to this site and the whole GPS technology in general. I own a Garmin 260 and I love it,but one thing I dont understand is how am I supposed to see these POI files or the info contained therein once I downloaded them to the internal memory.Sorry about the dumb question.
Extras, Custom pois, and then tap custom pois. they will be there if loaded in your unit...
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ
Don't fret
Hey everyone! I'm pretty much new to this site and the whole GPS technology in general. I own a Garmin 260 and I love it,but one thing I dont understand is how am I supposed to see these POI files or the info contained therein once I downloaded them to the internal memory.Sorry about the dumb question.
Head over to the getting started page (http://www.poi-factory.com/node/1631) and that should help clarify things.
If you still have questions, poke around the discussions, a lot of questions have already been asked. And when all else fails, ask
-- Garmin 660 Ellicott City, MD
Mapping POIs
You might also try these:
http://www.gpsvisualizer.com/map
http://www.wotton.org/map/batchgeo.html
The both will locate the points on Google Maps. The second will also create a Google Earth KML file.
Another way to convert CSVs to KMLs
Converting the CSV to KML and then using Google Earth to see the locations is a pretty good idea!
For the conversion I use POIConverter.js Java Script, it is FREE and works pretty well, just drag and drop CSV files into it, it prompts you whether you want KML or GPX and that's it! Then all you have to do is double-click on the KML file created with the same name as the CSV, but different extension.
This script was written by a member from this site.
Here is the link:
http://dr5274.googlepages.com/poiconverter
If you want to adventure into Java Script, then you can open the script with Notepad and check what and how it does it.
Another idea would be to load the CSV files and browse the locations using the GPS, much quicker than trying to open POI by POI on Google maps.
GARMIN nuvi 760 sites.google.com/site/lschwabe/
Very nice tool
Luis,
Thanks for the link. Simple to use and works well.
Larry ... Garmin Nuvi 650
Got it!
Thanks for the answer.
Garmin Nuvi 260,Macbook Pro,OSX 10.5
Very helpful
You might also try these:
http://www.gpsvisualizer.com/map
http://www.wotton.org/map/batchgeo.html
The both will locate the points on Google Maps. The second will also create a Google Earth KML file.
thanks for the info, I used it on the .csv and it worked great
mikelanz -- Garmin nuvi 260W
try batchgeocode dot com
try batchgeocode dot com
non-native nutmegger