[mapserver-users] Oracle Spatial and MAXFEATURES, not implemented?
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.00 maxx:667551.923077
maxy:517.00
---
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
--
Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: peter.hopfgart...@r3-gis.com
Tel. : +39 0473 494949
Fax : +39 0473 069902
www : http://www.r3-gis.com
XING : http://www.xing.com/go/invita/8917535
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Oracle Spatial and MAXFEATURES, not implemented?
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.00 maxx:667551.923077
maxy:517.00
---
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
Re: [mapserver-users] Oracle Spatial and MAXFEATURES, not implemented?
On Fri, 2010-05-07 at 10:03 -0400, Yewondwossen Assefa wrote:
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,
Hello Yewondwossen.
Thank you for the pointer! I've applied the diff
http://trac.osgeo.org/mapserver/changeset/9593?format=diffnew=9593 to
the 5.6.3 source and it works perfectly!
Thank you and have a nice week end,
Peter
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.00 maxx:667551.923077
maxy:517.00
---
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
--
Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: peter.hopfgart...@r3-gis.com
Tel. : +39 0473 494949
Fax : +39 0473 069902
www : http://www.r3-gis.com
XING : http://www.xing.com/go/invita/8917535
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
