[ gpsdrive ] gpsdrive, mapnik, openstreetmap and poi's

[Ross Scanlon]

Additionally with this I have a problem with the postgres database.


Running gpsdrive from a terminal I get the following output:

DB: Using waypoints from local user file.
DB: Using waypoints from OpenStreetMap database.
Read 576 POI-Types from geoinfo.db

(GpsDrive:5448): Gtk-CRITICAL **: gtk_widget_hide_all: assertion `GTK_IS_WIDGET (widget)' failed

(GpsDrive:5448): Gtk-CRITICAL **: gtk_widget_hide_all: assertion `GTK_IS_WIDGET (widget)' failed
db_postgis_query: an error occured while trying to read from the database!
query: SELECT name,poi,ASTEXT(way) AS geometry FROM planet_osm_point WHERE SetSRID(way,-1) && SetSRID('BOX3D(16501573.52197114 -2342682.17857044 , 16577761.52197114 -2288166.17857044)'::box3d,-1) AND poi IN ('waypoint','waypoint.flag') LIMIT 20000;
/home/ross/.gpsdrive/way.txt reloaded


Thank you for using GpsDrive!



If I then feed the query to psql as below:


ross at ubuntu8:~$ echo "SELECT name,poi,ASTEXT(way) AS geometry FROM planet_osm_point WHERE SetSRID(way,-1) && SetSRID('BOX3D(16501573.52197114  -2342682.17857044 , 16577761.52197114 -2288166.17857044)'::box3d,-1) AND poi IN ('waypoint','waypoint.flag') LIMIT 20000;" | psql -d gis
ERROR:  column "poi" does not exist
LINE 1: SELECT name,poi,ASTEXT(way) AS geometry FROM planet_osm_poin...
                    ^


It returns the error above.



So why is the column "poi" not in the database?

What should have created the column in the database?




-- 


 Regards
 Ross
 ross at theinternethost.com.au

 -------------------------------------------
 The Internet Hosting Company
 Low Cost, High Value web Hosting and Design
 http://www.theinternethost.com.au
 P: 07 4945 3820
 F: 07 4945 3825
 E: info at theinternethost.com.au
 -------------------------------------------
 Looking for Linux, It's all here
 http://www.theinternethost.com.au/store/
 -------------------------------------------