Notices
Page 1 of 2 1 2
Reply
Thread Tools
fldude99 is offline fldude99
2007-01-27 , 21:02
Posts: 101 | Thanked: 14 times | Joined on Jan 2007
#1
Can anyone point me to where I can get POI's to use in the mapper?
 
brendan's Avatar
brendan is offline brendan
2007-01-27 , 23:05
Posts: 531 | Thanked: 79 times | Joined on Oct 2006 @ This side of insane, that side of genius
#2
???

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
__________________
Nokia n800
OS 2008
Pharos iGPS 360-BT
ElmScan 5 BlueTooth
BlackBerry Bold (9000)
AT&T Wireless
 
fldude99 is offline fldude99
2007-01-28 , 04:41
Posts: 101 | Thanked: 14 times | Joined on Jan 2007
#3
I hate to be so ignorant..but what do you mean..or how..do you create your own points of interest?
 
gnuite's Avatar
gnuite is offline gnuite
2007-01-28 , 06:59
Posts: 1,245 | Thanked: 421 times | Joined on Dec 2005
#4
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".
 
Tobler is offline Tobler
2007-02-01 , 18:08
Posts: 3 | Thanked: 2 times | Joined on Dec 2006
#5
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
 
rcull's Avatar
rcull is offline rcull
2007-02-01 , 21:30
Posts: 299 | Thanked: 168 times | Joined on Jun 2006 @ Wales UK
#6
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
Last edited by rcull; 2007-02-01 at 21:33.
 
rcull's Avatar
rcull is offline rcull
2007-02-02 , 16:07
Posts: 299 | Thanked: 168 times | Joined on Jun 2006 @ Wales UK
#7
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.
Last edited by rcull; 2007-02-02 at 16:10.
 
tebra is offline tebra
2007-02-03 , 20:50
Posts: 8 | Thanked: 0 times | Joined on Jan 2007
#8
GPSBabel tool can be usefull to convert POI into different formats
www.gpsbabel.org
 
gnuite's Avatar
gnuite is offline gnuite
2007-02-04 , 19:19
Posts: 1,245 | Thanked: 421 times | Joined on Dec 2005
#9
Originally Posted by rcull View Post
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?
 
rcull's Avatar
rcull is offline rcull
2007-02-05 , 19:34
Posts: 299 | Thanked: 168 times | Joined on Jun 2006 @ Wales UK
#10
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
 
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools

 
Forum Jump


All times are GMT. The time now is 11:08.

Contact Us - Home - Archive - Top