Bart, Not a true answer to your question, but it fails for me as well if I include a basic spatial filter (ogc:And) with the attribute query.
John Fletcher Latitude Geographics Group Ltd. [EMAIL PROTECTED] www.latitudegeo.com Head Office: 204 Market Square Victoria, BC Canada V8W 3C6 Tel: (250) 381-8130 Fax: (250) 381-8132 Geocortex Internet Mapping (www.geocortex.net) - Helping people succeed with web-based geography -----Original Message----- From: UMN MapServer Users List [mailto:[EMAIL PROTECTED] On Behalf Of Bart van den Eijnden (OSGIS) Sent: Wednesday, March 14, 2007 11:30 AM To: [email protected] Subject: Re: [UMN_MAPSERVER-USERS] ArcSDE and SLD WMS (attribute queries) Hi John, thanks for the info. I did get attribute queries to work, but what I can't get to work is a combination of a spatial filter and an attribute filter (combined with an ogc:And). Did anyone ever try that successfully? Best regards, Bart Bart, The Government of BC has an application which uses non-spatial filters in SLD documents to Mapserver, with an SDE back-end: http://openmaps.gov.bc.ca/imfows13/imf.jsp?site=idt Find Imagery --> Air Photos --> Search For Air Photos Zoom in to the resultant features, activate the "Centres" tool, and draw a box around a number of Air Photo centre points. This will show three separate SDE layers styled using an SLD with a filter (non-spatial), two of which have alternate symbolization and thus a more complex filter clause in the SLD. Incidentally, the other imagery types (Orthophotos, Satellite Imagery, etc) are primarily backed by shapefiles, so are not relevant to this discussion. I did run into timeout problems getting the SLD to work when there were > > 200 or so individual features that needed to be identified with the filter. I had been using a single PropertyIsEqualTo clause for each feature which I was able to change to a handful of PropertyIsBetween clauses due to the convenient sequential numbering of the ID values which I was filtering. This change allows the SLD filter to work quite well. Regards, John Fletcher Latitude Geographics Group Ltd. [EMAIL PROTECTED] www.latitudegeo.com Head Office: 204 Market Square Victoria, BC Canada V8W 3C6 Tel: (250) 381-8130 Fax: (250) 381-8132 Geocortex Internet Mapping (www.geocortex.net) - Helping people succeed with web-based geography -- Bart van den Eijnden OSGIS, Open Source GIS http://www.osgis.nl
