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

[Ross Scanlon]

Amazing what a fresh mind does (i originally wrote this at midnight last night).

I have solved this now so no need to answer.

Regards
Ross



On Tue, 3 Jun 2008 10:35:51 +1000
Ross Scanlon <info at 4x4falcon.com> wrote:

> 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?
> 
>