Here is the relevant portion of my mapfile:
CONNECTIONTYPE POSTGIS CONNECTION "dbname=contours host=localhost user=contour_xxxx password=xxx" PROCESSING "CLOSE_CONNECTION=DEFER" DATA "wkb_geometry from contours USING UNIQUE ogc_fid USING contourinterval=40"
I want to limit the contours returned to only include
As you can see from the Postgres log (below), contourinterval isn't even
referenced in the query...
select "contourelevation", encode(ST_AsBinary(ST_Force2D("wkb_geometry"),'NDR'),'hex') as geom, "ogc_fid" from contours where wkb_geometry && ST_GeomFromText('POLYGON((-111.939697265625 33.4213636331582,-111.939697265625 33.4323499612832,-111.9287109375 33.4323499612832,-111.9287109375 33.4213636331582,-111.939697265625 33.4213636331582))',find_srid('','contours','wkb_geometry'))
I've tried all sorts of subselects and examples found on the web, nothing works. BTW, I assume 'contourelevation' is pulled because it is my LABELITEM. The data is USGS contour data.