[mapserver-users] queryByPoint + PostGIS layers + USING statement
boolean10001 at yahoo.com
Mon Jul 21 10:53:50 EDT 2008
If you want to retrieve geometry with a specify projection, i suggest you to set it inside the
postgres geometry_columns table, to simplify the query in the map file.
When you upload some shape file to the database via shp2pgsql utility, you can specify
the SRID of the projection, if not, SRID sets to -1.
If you're an expert user, you can alter the values of the geometry_columns table.
IC Carlos Ruiz
--- On Mon, 7/21/08, Stefan Schwarzer <stefan.schwarzer at grid.unep.ch> wrote:
From: Stefan Schwarzer <stefan.schwarzer at grid.unep.ch>
Subject: [mapserver-users] queryByPoint + PostGIS layers + USING statement
To: mapserver-users at lists.osgeo.org
Date: Monday, July 21, 2008, 8:00 AM
it seems that it's mandatory for postgis layers to use the
statement in the query.
My layer parameters look a bit like this:
DATA 'the_geom FROM ( SELECT xxxx FROM xxx LEFT JOIN xxxx WHERE xxx)
AS foo USING UNIQUE uid USING srid=4326) '
But nevertheless, mapserver doesn't like it...
Can anyone give me a hint what is wrong with that?
Thanks for any advice,
mapserver-users mailing list
mapserver-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapserver-users