[mapserver-users] Filter Point features from PostGIS Layer

[Julien Cigar]

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


-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jcigar.vcf
Type: text/x-vcard
Size: 292 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110902/91481c2c/jcigar.vcf