CSV file coordinates question...

 

Hi All,

Can anyone tell me how coordinates like, for example, -122.40495 and 37.78151 are "found" to denote a specific location, on a map. I'd like to learn how to "find" these coordinates and then by following the formatting of an existing CSV file, enter them into a new CSV file.

Thanks for your time.

Regards,

Tailspin

--
Sullivan's Law: Murphy was an optimist!

It's simple longitude & latitude

--
*Keith* MacBook Pro *wifi iPad(2012) w/BadElf GPS & iPhone6 + Navigon*

Here is what I did,

Here is what I did, hopefully this will work for you:

Download Google Earth (http://earth.google.com/)

Open earth and select the tools menu at the top then select options.

Near the center of the options dialog change Show/Lat Long to degrees. Click OK.

Open earth and type an address in the fly to field (you could just zoom to your spot if you wish).

At the top of the screen you will see a little push pin. Click it (you can drag this around once it is placed on the screen).

A dialog will open with lat and long information.

I cut and paste the long (without the degree sym) to my csv file. then a comma.

Then cust and paste the lat, then a comma.

give it a name, then a comma.

give it a description, then a comma.

Repeat.

It will look like this in the csv file:
-111.864969,33.626887,"Scottsdale","Skatepark"
-111.953177,33.338685,"Tempe","Skatepark"

It is possible to save the items from google as KML files. Then use a third party program to convert. But, if you aren't doing hundreds then cutting and pasting works great.

--
+ Garmin nuvi 350 + Garmin nuvi 755T

Refer to FAQ

tailspin wrote:

Hi All,

Can anyone tell me how coordinates like, for example, -122.40495 and 37.78151 are "found" to denote a specific location, on a map. I'd like to learn how to "find" these coordinates and then by following the formatting of an existing CSV file, enter them into a new CSV file.

See FAQ @http://www.poi-factory.com/node/821
This lists several sites you can go to in order to determine lat and long data.

--
Garmin StreetPilot c530, Mapsource

CSV file coordinates question... "Thanks"

I want to send a thank you to all who helped me with my coordinates question. Your help is very much appreciated...

Regards,

Tailspin

--
Sullivan's Law: Murphy was an optimist!