[mapserver-users] queryByPoint + PostGIS layers + USING statement

[Carlos Ruiz]

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

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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080721/87ffb21b/attachment.htm>