On Dec 27, 2007 6:20 PM, Joerg Ostertag (OSM Munich/Germany)
<[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://svana.org/kleptog/
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
