Creating a POI in text edit?

 

Hi, I took a look at a csv file with POIs. And I did the same (i though) but it didnt turn out right. I did it in textedit. Can anyone take a look:
THE FILE:
https://www.dropbox.com/s/olrg8820f85mmzu/poi-sormlandsleden...

THE COORDINATES:
https://www.dropbox.com/s/9kulvjeop2y977i/kordinater.txt

Maby I should do it in excel, right? I think the line breaks or the commas got screwed up.

you used commas rather than periods

You used commas to separate the coordinates rather than periods.

59.17570, 18.07271, 1 Björkhagen.
59,15857, 18,12673, 2 Skogshyddan

These should be periods rather than commas.

--
Illiterate? Write for free help.

Start small

I suggest you work small when learning and then expand your project. Lets take the 1st 10 lines

Line 2 has commas, not periods in the lon & lat numbers.

Lines 6-10 need a comma separating the lon & lat, not the apostrophy.

Lines 6 & 7 have something messed up in the Lon coordinates. Use the following format for LON & LAT coordinate numbers - nnn.nnnnn

Use this format for each POI - Lon,Lat,POI Name. Spaces after the commas separating the fields are not necessary.

I don't know if the colon is legal in the POI Name field unless the entire field is enclosed in quotes, I could be wrong on this though.

59.17570, 18.07271, 1 Bj÷rkhagen.
59,15857, 18,12673, 2 Skogshyddan
59,13872, 18,16157, 3 Alby friluftsgσrd
59,10079, 18,14256, 4 Tyresta by
59,09856, 18,07930, 5 Handen (Rudans gσrd)
58,55.399'17,55299, 5:1 KvarnΣngens IP, NynΣshamn
58,58.844'17,52926, 5:2 Vansta, ╓smo
59,04135' 17,57477, 5:3 Hemfosa
59,09250' 18,01374, 6 Paradiset
59,13695' 17,59050, 6:1 Huddinge (Sj÷dalen)

--
Harley BOOM GTS, Zumo 665, (2) Nuvi 765Ts, 1450LMT, 1350LM & others | 2019 Harley Ultra Limited Shrine - Peace Officer Dark Blue

Welcome

aksello wrote:

Hi, I took a look at a csv file with POIs. And I did the same (i though) but it didnt turn out right. I did it in textedit. Can anyone take a look:
THE FILE:
https://www.dropbox.com/s/olrg8820f85mmzu/poi-sormlandsleden...

THE COORDINATES:
https://www.dropbox.com/s/9kulvjeop2y977i/kordinater.txt

Maby I should do it in excel, right? I think the line breaks or the commas got screwed up.

Welcome to the site.

First - if you have not backed up your units, do so NOW - see http://www.poi-factory.com/node/30394

Next,as bear007 has indicated, why not start small and get used to the syntax. I would suggest something close to your home so you can use simulation to check out what you have done. See http://www.poi-factory.com/node/31482

Here is what POI Loader says about csv files

Creating .CSV Files

POI Loader accepts .csv files that contain longitude, latitude, speed alert information, and optional comments. You can create .csv files using a text editor, MS Excel, or a similar program.

POI Loader assumes a .csv file utilizes the following format for each POI (brackets [ ] denote optional text):

,,["][@]["],["] [comment]["]

Longitude and latitude must appear in WGS84 decimal degrees format (ddd.ddddd; negative numbers indicate West and South).

If you include quotes around the name or comment, you can include line breaks in the text.

The following are examples of Custom POIs in the proper format:

-94.81549,38.80390,Bonita

-94.79731,38.81099,Ridgeview@25

-94.74240,38.81952,Heritage Park,Perfect site for a picnic

-94.76416,38.81227,Garmin,"1200 E. 151st Street

Olathe,KS 66062
913/397.8300""

Just be careful with your typing - make sure to use periods in lat and lon; separate fields with commas; putting quotes around the name is usually a good idea.

thanks for all the good help

thanks for all the good help and effort.

Im not exactly sure about all suggestions but is this ok:
59,17570. 18,07271, "1 Björkhagen"

59,15857. 18,12673, "2 Skogshyddan"

59,13872. 18,16157, "3 Alby friluftsgård"

59,10079. 18,14256, "4 Tyresta by"

59,09856. 18,07930, "5 Handen (Rudans gård)"

58,55399. 17,55299, "5:1 Kvarnängens IP, Nynäshamn"

58,58844. 17,52926, "5:2 Vansta, Ösmo"

Not Correct

Your example has errors.

The coordinates should be type as follows:

59.17570,18.07271,"1 Bjorkhagen"
59.15857,18.12673,"2 Skogshyddan"

Etc, etc, etc

The coordinates in decimal format separated by a comma !

Edit: Aren't the coordinates reversed ????

I think it should be :

Longitude,Latitude,"Info"
18.07271,59.17570,"1 Bjorkhagen"
18.12673,59.15857,"2 Skogshyddan"

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

almost

The "Quotes are good" but the ,comma is a nono, you need a .period

58,58844. 17,52926, BAD
58.58844, 17.52926, GOOD

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7 - Toyota Entune NAV

thanks, perfect info. Great

thanks, perfect info. Great info: Longitude,Latitude,"Info"

.

Rather than creating the files from scratch you may want to check out this free program which was created by one of our members

http://turboccc.wikispaces.com/Extra_POI_Editor

Coordinates are off

aksello wrote:

thanks, perfect info. Great info: Longitude,Latitude,"Info"

59.17570,18.07271 Puts it in Lissmavägen 4
142 91 Skogås, Sweden 86 m SE

18.07271,59.17570 puts it in the Arabian Sea.

--
Nuvi 2460LMT.

Visualization time, I agree is needed

GadgetGuy2008 wrote:

Rather than creating the files from scratch you may want to check out this free program which was created by one of our members

http://turboccc.wikispaces.com/Extra_POI_Editor

Go get and install EPE. Just do a file > open and point it to your POI file.

Then use it to see where your POIs are.

Report what you find please.

Please can anyone look at this problem

Everything looks good on the unit now, I get allt the POI, the icon works, I can serach and see tham on map.

But they are all about 10km wrong!!!!!
The coordinates are ok, but somehow they all end up wrong?

These are the original coordinates:
https://www.dropbox.com/s/fj3e34chmydy1vt/kordinater_sormlan...

And my csv file:
https://www.dropbox.com/s/olrg8820f85mmzu/poi-sormlandsleden...

Aha

aksello wrote:

Everything looks good on the unit now, I get allt the POI, the icon works, I can serach and see tham on map.

But they are all about 10km wrong!!!!!
The coordinates are ok, but somehow they all end up wrong?

These are the original coordinates:
https://www.dropbox.com/s/fj3e34chmydy1vt/kordinater_sormlan...

And my csv file:
https://www.dropbox.com/s/olrg8820f85mmzu/poi-sormlandsleden...

Your original coords are in degrees and decimal minutes. You need to convert these to decimal degrees for use as a POI file:

http://science.nature.nps.gov/im/units/mwr/documents/Howtoco...

Way to go, CraigW

I totally missed that.

Latitude and longitude are not converted correctly.

aksello wrote:

Everything looks good on the unit now, I get allt the POI, the icon works, I can serach and see tham on map.

But they are all about 10km wrong!!!!!
The coordinates are ok, but somehow they all end up wrong?

These are the original coordinates:
https://www.dropbox.com/s/fj3e34chmydy1vt/kordinater_sormlan...

And my csv file:
https://www.dropbox.com/s/olrg8820f85mmzu/poi-sormlandsleden...

You did not due a conversion from decimal degree minute seconds to decimal degrees.

http://www.csgnetwork.com/gpscoordconv.html

EDIT: You guys are fast!

--
Nuvi 2460LMT.

;-)

pwohlrab wrote:

EDIT: You guys are fast!

wink

And don't forget

You are now talking about East Longitude .

No minus sign (-) in front of longitude .and if you use
Google Earth it would be 59.XXXXN,18.XXXXE

idea

--
MrKenFL- "Money can't buy you happiness .. But it does bring you a more pleasant form of misery." NUVI 260, Nuvi 1490LMT & Nuvi 2595LMT all with 2014.4 maps !

i persist :-)

Quote:

You did not due a conversion from decimal degree minute seconds to decimal degrees.

http://www.csgnetwork.com/gpscoordconv.html

Hi, which field to use on the link above if my coordinates are like this:
018.07271, 59.17570,

thanks!!

You're close, but...

aksello wrote:
Quote:

You did not due a conversion from decimal degree minute seconds to decimal degrees.

http://www.csgnetwork.com/gpscoordconv.html

Hi, which field to use on the link above if my coordinates are like this:
018.07271, 59.17570,

thanks!!

Your example above is decimal degrees, but it is not the correct value from your desired E18° 7.271' and N59° 17.570' for Björkhagen from your source. You need to convert each of your original values from the one system to the other. Your correct Björkhagen values are E18.12118° and N59.29283° after the conversion (adding a -, I think, for any East and South coords).

exhausting

Ok, so I take these values: N 58°41.532' E 016°48.650'
If I use the calculator http://www.csgnetwork.com/gpscoordconv.html

which of the fields is the correct one. The last "box" looks about right, and I got this value: 59.29283

regarding the "-", i loaded the first version to my gps and besides from the circa 10 km offset, it worked without a "-", so i think i will try without.

Minus for west and south

.

--
Striving to make the NYC Metro area project the best.

You need both -- or...

aksello wrote:

Ok, so I take these values: N 58°41.532' E 016°48.650'
If I use the calculator http://www.csgnetwork.com/gpscoordconv.html

which of the fields is the correct one. The last "box" looks about right, and I got this value: 59.29283

regarding the "-", i loaded the first version to my gps and besides from the circa 10 km offset, it worked without a "-", so i think i will try without.

If I understand your question, you need both: both a latitude and a longitude to identify a location on the globe.

Or--if you mean which "conversion box" from the link then yes, the third one is correct, the one where you enter your values in the DDD MM.MMMM boxes and get decimal degrees as the answer.

Oops

camerabob wrote:

Minus for west and south
.

Oops to my East thought!

Google Earth does the conversion, too

Go to "Tools" in Google Earth and select decimal coordinates. Then enter one of YOUR coordinates and let GE take you there. Click on the yellow stick pin and the latitude and longitude will be displayed in decimal.

--
"No misfortune is so bad that whining about it won't make it worse."

go to itouchmap

plunder wrote:

Go to "Tools" in Google Earth and select decimal coordinates. Then enter one of YOUR coordinates and let GE take you there. Click on the yellow stick pin and the latitude and longitude will be displayed in decimal.

Go to http://www.itouchmap.com/latlong.html it's easier and you can correct the position by moving the pointer. All 4 formats are shown as well.

--
Illiterate? Write for free help.

Done....

Is there a way to see you custom POI file in garmin basecamp? either the csv file or the generated gpi file. Ive spend a couple of hours recalculating the coordinates, now I just want to check them on a big map

unfortunately

aksello wrote:

Is there a way to see you custom POI file in garmin basecamp? either the csv file or the generated gpi file. Ive spend a couple of hours recalculating the coordinates, now I just want to check them on a big map

I don't think it's possible as a POI file. If you enter all the points it will display them but then it will also want to store them on the unit as favorites.

Basecamp will read a GPX file, but I don't think it handles CSV files.

--
Illiterate? Write for free help.

EPE

aksello wrote:

Is there a way to see you custom POI file in garmin basecamp? either the csv file or the generated gpi file. Ive spend a couple of hours recalculating the coordinates, now I just want to check them on a big map

EPE (Extra POI Editor) will let you do this.

Try it, please