On 09/02/2011 14:02, Julien Cigar wrote:
couldn't you use WHERE ST_GeometryType(col) = "ST_Point" ?
also note that to avoid a seqscan you should create an appropriate index:CREATE INDEX your_index ON your_table(ST_GeometryType(geom)) WHERE ST_GeometryType(geom) = 'ST_Point';
On 09/02/2011 13:50, kaipi wrote:I have a PostGIS database with polygon, line and point features. I want to make a Mapserver layer, that only displays the point features. AFAIK without such filtering Mapserver would render in a Point-Type-Layer also the polygon features as points. How would a FILTER or EXPRESSION look like to tell Mapserver to only query for point features ? Thanks, Harry -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Filter-Point-features-from-PostGIS-Layer-tp6753585p6753585.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
-- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced.
<<attachment: jcigar.vcf>>
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
