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 <[EMAIL PROTECTED]> wrote:
From: Stefan Schwarzer <[EMAIL PROTECTED]>
Subject: [mapserver-users] queryByPoint + PostGIS layers + USING statement
To: mapserver-users@lists.osgeo.org
Date: Monday, July 21, 2008, 8:00 AM
Hi there,
it seems that it's mandatory for postgis layers to use the
"USING"
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,
Stef
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
