<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'>If you want to retrieve geometry with a specify projection, i suggest you to set it inside the<br>postgres geometry_columns table, to simplify the query in the map file.<br><br>When you upload some shape file to the database via shp2pgsql utility, you can specify <br>the SRID of the projection, if not, SRID sets to -1.<br><br>If you're an expert user, you can alter the values of the geometry_columns table.<br><br><div><strong><font color="#0000bf">IC Carlos Ruiz</font></strong></div><div><strong><font color="#0000bf"></font></strong> </div><br><br>--- On <b>Mon, 7/21/08, Stefan Schwarzer <i><stefan.schwarzer@grid.unep.ch></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Stefan Schwarzer <stefan.schwarzer@grid.unep.ch><br>Subject: [mapserver-users] queryByPoint + PostGIS
layers + USING statement<br>To: mapserver-users@lists.osgeo.org<br>Date: Monday, July 21, 2008, 8:00 AM<br><br><pre>Hi there,<br><br>it seems that it's mandatory for postgis layers to use the<br>"USING" <br>statement in the query.<br><br>My layer parameters look a bit like this:<br><br> DATA 'the_geom FROM ( SELECT xxxx FROM xxx LEFT JOIN xxxx WHERE xxx) <br>AS foo USING UNIQUE uid USING srid=4326) '<br><br>But nevertheless, mapserver doesn't like it...<br><br>Can anyone give me a hint what is wrong with that?<br><br>Thanks for any advice,<br><br>Stef<br>_______________________________________________<br>mapserver-users mailing list<br>mapserver-users@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/mapserver-users</pre></blockquote></td></tr></table><br>