maemo.org - Talk - POI's for mapper

maemo.org - Talk (https://talk.maemo.org/index.php)

- Applications (https://talk.maemo.org/forumdisplay.php?f=41)

- - POI's for mapper (https://talk.maemo.org/showthread.php?t=4357)

POI's for mapper

Can anyone point me to where I can get POI's to use in the mapper?

Re: POI's for mapper

???

for the most part you create your own Points Of Interest.

if your lucky, someone may have a few speed trap or traffic light camera points, but not much else, i dont think

Re: POI's for mapper

I hate to be so ignorant..but what do you mean..or how..do you create your own points of interest?

Re: POI's for mapper

You can add POIs to your POI database by using the "tap-and-hold" (context) menu on a point on the map and selecting "Location -> Add POI".

Re: POI's for mapper

Hello

I have interesting POI's (KML, CSV, GPX or OV2 format) which should be converted to sqlite .db -format. But how it can be done?
I'd prefer to use Linux PC for conversion and then upload db file to N770.

There are FON WiFi hot-spot POI's what I'd like to get into N770, from maps.fon.com

Thanks,
--
Tobler

Re: POI's for mapper

Tobler
I have a small shell script /awk prog to do this. I have downloaded sqlite 2.8.17 ( sqlite3 does not read Maemo Mappers poi.db! ) to my Linux box. I copy poi.db( probably unnecessary) and csv file to the sqlite folder and run :-
./csv2sql WiFi.csv | ./sqlite poi.db 13
where 13 is a category either added or allready there within MM.
The script is as follows :-

Code:

cat "$1"| tr -d "\r" | awk -v Categ="$2" '

BEGIN { FS="," }

{

 Inv="\x27"

 Lat=$2

 Lon=$1

 Label=$3

 Desc=$4

 Sql="INSERT INTO poi(lat,lon,label,desc,cat_id) VALUES("

 Close=");"

 Label = Inv Label Inv

 if ( Desc == "" ) {

   Desc = Inv Inv

 } else {

   Desc = Inv Desc Inv

 }

 printf("%s%s,%s,%s,%s,%s%s \n",Sql,Lat,Lon,Label,Desc,Categ,Close)

}'

The

Code:

tr -d "\r"

is there to remove a troublesome ^M from the original file ( Transferring an MS file to Linux ). The script is only expecting 4 columns of which the last may be blank. It does not correctly handle columns like addresses seperated with commas ie "14 St Johns St, Banbury" but as we have the lat long anyway and accurate Google maps I have not bothered to play with it. In fact I usually just remove the forth column and leave a "," .
As usual 'Use at your oun risk'

Edit: The csv files I have are all in the order "Lon,Lat,Label,Desc" hence the swap of $2 $1. If the other way round make it Lat=$1,Lon=$2

Re: POI's for mapper

Please ignore my previous post.
There is now a new version wich will handle csv's much cleaner.

Gnuite Thanks for this app its brilliant. Any chance of adding the ability to use named dbs instead of just poi.db. Maybe just the ability to store a number someware and swap out with poi.db when req'd.
Cheers

Code:

##########################################################################

#

#  Poi csv file converter for Maemo Mapper on Nokia 770/800

#  written by Rick Cull 3/2/2007

#  copywright gpl2 

#  Take two parameters :-

#                         poi.csv and Category

#

#      The category must allready be in the poi.db before running this script

#      use context menu/Location/Add Poi - Edit Categories to add any new

#      before running.

##########################################################################  

cat $1|tr -d "\r"|awk -v Categ="$2" '

{

NewString=""

NextChr=""

tmpStr=""

Len=length($0)

Count=1

CountStr=1

while ( Count <= Len ) {

  NextChr=substr($0,Count,1)

  if ( NextChr !~ /"/ ){

     NewString=NewString NextChr

  } else {

     Count=Count + 1

     CountStr=Count

     tmpStr=substr($0,CountStr,1)

     while ( tmpStr !~ /"/ ) {

       if ( tmpStr !~ /,/ ) {

          NewString=NewString tmpStr

       } else {

          NewString=NewString " "

       }

       CountStr=CountStr + 1

       Count=Count + 1

       tmpStr=substr($0,CountStr,1)

     }

  }

  Count=Count + 1

}



split(NewString,Col,",")

Inv=sprintf("\"")

Lat=Col[2]

Lon=Col[1]

Label=Col[3]

Desc=Col[4]

Sql="INSERT INTO poi(lat,lon,label,desc,cat_id) VALUES("

Close=");"

Label = Inv Label Inv

if ( Desc == "" ) {

  Desc = Inv Inv

} else {

  Desc = Inv Desc Inv

}

printf("%s%s,%s,%s,%s,%s%s \n",Sql,Lat,Lon,Label,Desc,Categ,Close)

}'

The attached tarfile is UK pois from Garmin

Edit: The attachments didnt seem to stick.

Re: POI's for mapper

GPSBabel tool can be usefull to convert POI into different formats
www.gpsbabel.org

Re: POI's for mapper

Quote:

Originally Posted by rcull (Post 33012)

Gnuite Thanks for this app its brilliant. Any chance of adding the ability to use named dbs instead of just poi.db. Maybe just the ability to store a number someware and swap out with poi.db when req'd.

You can specify the filename of the database file in the Settings dialog box. Is that what you mean?

Re: POI's for mapper

Gnuite
Sorry I wasn,t very clear I realise the path can be changed, maybe I have a different usage pattern but would normally change poi sets much more often than I'd change maps. I was thinking of something more like the enable (context/edit poi/edit categories ) list but at a similar level to Maps which would maybe work just the same as now or if there is any size overhead to the poi.db then swap in/out different dbs.

I'm not being picky here I think this is the most usefull prog for the tablet :D :D

Re: POI's for mapper

Couldn't get rcull's script + sqlite to work on the n770, but I might try later on my desktop.

I'm going in to town tomorrow and it would be nice to get the KML of the fon hotspots into maemo mapper but I've not yet been successful. Googled, checked this forum (boy are those captchas hard!) tried winmapper, this script etc...

I hope gnuite will have the time and interest to make KML import into mapper a breeze. Thanks for a very good app.

Re: POI's for mapper

check out this thread about "Poi_loader".

http://www.internettablettalk.com/fo...ght=poi_loader

It is a windows app, but it will import gpx waypoints into poi.db

I used it sucessfully on a geocaching pocket query file.
I found the attached png icon (must change to a .jpg for mapper)

Re: POI's for mapper

So I accidentally deleted my poi.db file and can't figure out how to make a new one. I have the N800 and sqlite3. I've restarted maemo (which I was told would simply add a new one and it doesn't). I've also tried adding a new one in xterminal but must be doing something wrong. Does anyone have a empty poi.db file they can post or a way to make a new one? Thanks

Re: POI's for mapper

Quote:

Originally Posted by hawkfanz (Post 45114)

Make sure that the directory in which the poi.db file is supposed to be (as indicated in the "POI" tab of the Settings dialog) exists and is writable. Maemo Mapper will create the database file on startup, if it doesn't exist and that directory does (and is writable).

Re: POI's for mapper

New Version of Poi_Loader see:-

http://www.rikcull.f2s.com/poi_loader06.zip

Any bug reports or feature requests welcome.

Rick