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
couldn't you use WHERE ST_GeometryType(col) = 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
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