Custom Query (1155 matches)

moved from #1039

Using "admin" as username/e-mail and "admin" as a password there is an error thrown.

You can test this behavior in nightly build 9530 ​http://aiolos.survey.ntua.gr/gisvm/dev/osgeo-live-debug-build9530.iso

The next problems have been found by following the Kosmo Desktop Quickstart with the LiveDVD 6.5 beta1 ISO:

• Layer visibility checkboxes don't work
  
• PostGIS layers can be loaded but doesn't show anything in the map

Hi,

gpsdrive runs Mapnik to generate map tiles on-the-fly using the OSM data loaded into PostGIS and shapefiles from Natural Earth for the coastline, world city names, etc.

This failed in beta1.iso (cleanly, it just reverts to static satellite image backdrop) since the shapefiles moved, specifically 10m_land.shp isn't where it used to be and had a name change. I've fixed those in SVN now, but the transition to PostGIS 2 now causes a crash:

terminate called after throwing an instance of 'mapnik::datasource_exception'
  what():  :
ERROR:  function asbinary(geometry) does not exist
LINE 1: SELECT AsBinary("way") AS geom,"aeroway","amenity","building...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Full sql was: 'SELECT AsBinary("way") AS geom,"aeroway","amenity","building","highway",\
"landuse","leisure","man_made","military","natural","power","railway","tourism" from \
 (select * from planet_osm_polygon order by z_order,way_area desc)\
 as leisure WHERE "way" && SetSRID('BOX3D(-134041.6 6972313.6,-130457.6 6975180.799999999)'::box3d, 900913)'

Aborted (core dumped)

hopefully a PostGIS expert can provide some tips, I'm not seeing any asbinary() or AsBinary() in the gpsdrive source code.

​http://gpsdrive.svn.sourceforge.net/viewvc/gpsdrive/trunk/src/database_postgis.c?revision=HEAD&view=markup

​http://gpsdrive.svn.sourceforge.net/viewvc/gpsdrive/trunk/src/database_postgis.h?revision=HEAD&view=markup

in the mean time I've just set mapnik=0 in the ~/.gpsdrive rc file (see gisvm/bin/install_gpsdrive.sh) to disable mapnik mode.

thanks for any pointers, Hamish