Active Topics
-
Error after installing Leste on sdcard (17)
to Maemo 7 / Leste by Arno_11 - 2 hrs, 31 mins ago -
Maemo 20th Anniversary (4)
to Brainstorm by teroyk - 1 day, 7 hrs ago -
Nokia Booklet 3G (RX-75) Drivers (64)
to Alternatives by teroyk - 1 day, 7 hrs ago -
Porting apps to Leste (46)
to Maemo 7 / Leste by teroyk - 3 days, 11 hrs ago - more...
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?
 |
|
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
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
Nokia n800
OS 2008
Pharos iGPS 360-BT
ElmScan 5 BlueTooth
BlackBerry Bold (9000)
AT&T Wireless
|
|
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?
 |
|
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".
|
|
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
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
 |
|
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 :-
The
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.
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)
}'
Code:
tr -d "\r"
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.
|
|
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
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.
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.
|
|
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
www.gpsbabel.org
|
|
2007-02-04
, 19:19
|
|
Posts: 1,245 |
Thanked: 421 times |
Joined on Dec 2005
|
#9
|
Originally Posted by rcull
You can specify the filename of the database file in the Settings dialog box. Is that what you mean?
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.
|
|
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
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
