[OSM-dev] querying mapnik data

[Martijn van Oosterhout]

On Dec 27, 2007 6:20 PM, Joerg Ostertag (OSM Munich/Germany)
<openstreetmap at ostertag.name> wrote:
> I tried something like:
>
> echo "select osm_id,highway,name from planet_osm_line where highway is not null and way && transform(GeomFromText('POLYGON((48.18605 11.86398,48.18632 11.86398,48.18632 11.86884,48.18605 11.86884,48.18605 11.86398))',4326),3395) limit 5;" | psql  gis
> FEHLER:  AddToPROJ4SRSCache: Cannot find SRID (3395) in spatial_ref_sys

Hmm, in the installation notes on the wiki it skips the part of the
postgis install where the spatial_ref_sys table is populated.
In the postgis source there is a file called spatial_ref_sys.sql which
you need to load to have the transformation in the backend work.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/