This was done as part of the http://trac.osgeo.org/mapserver/ticket/2605
and is only available in trunk right now (for the upcoming 6.0 release).
regards,
On 07/05/2010 9:45 AM, Peter Hopfgartner wrote:
I'm trying to limit the maximum number of features, as in the map file
snippet below.
MapServer is 5.6.3.
Anyway, the number of features drawn is not limited, as expected, but
thousands of shapes are processed.
Indeed, enabling -all_debug 5, the query passed to Oracle looks like;
---
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT pln_id, pln_id, the_geom FROM plant_data_map WHERE
SDO_FILTER( the_geom, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE'
msOracleSpatialLayerWhichShapes. Bind values: srid:25832
minx:666798.076923 miny:5169400.000000 maxx:667551.923077
maxy:5170000.000000
---
Indeed, almost 15,000 shapes arrive:
---
msOracleSpatialLayerNextShape on layer 0x101363e0, row_num: 14934
msOracleSpatialLayerNextShape on layer 0x101363e0, Fetched 0 more rows
(14934 total)
msOracleSpatialLayerFreeItemInfo was called.
---
Peeking at the source in maporaclespatial.c, it seems that
layer->maxfeatures is never read and no limitation, maybe looking like
"ROWNUM<= layer->maxfeatures" is added to the SELECT statement.
Regards,
Peter
MAPFILE SNIPPET:
LAYER #----------------16-----------------
GROUP "pflanzennr_black_12"
NAME "Pflanzennr"
STATUS ON
TYPE POINT
PROJECTION
"init=epsg:25832"
END
CONNECTIONTYPE oraclespatial
CONNECTION "{MYUSER}/{MYPASSWD}"
DATA "the_geom from plant_data_map using unique pln_id srid
25832"
PROCESSING "CLOSE_CONNECTION=DEFER"
SIZEUNITS meters
LABELITEM "pln_id"
MAXFEATURES 20
TOLERANCE 1
POSTLABELCACHE TRUE
CLASS
NAME "label"
LABEL
TYPE TRUETYPE
PARTIALS TRUE
FONT "verdana"
COLOR 0 0 0
OUTLINECOLOR 255 255 255
SIZE 6
MINSIZE 6
MAXSIZE 8
POSITION CR
FORCE TRUE
END
END
END
--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst
Email: yass...@dmsolutions.ca
http://www.dmsolutions.ca/
Phone: (613) 565-5056 (ext 14)
Fax: (613) 565-0925
----------------------------------------------------------------
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
