[mapserver-users] Strange Behaviour with getFeature
using POSTmethod and more than one typename
Yewondwossen Assefa
yassefa at dmsolutions.ca
Tue Apr 13 10:21:56 EDT 2010
David Alda Fernandez de Lezea wrote:
> Assefa,
>
> I'm using version 5.2.1, but we are not sure if we are going to migrate
> or not.
> This is what I get:
>
>
I was able to reproduce the problem. I have entered a bug for it [1] and
prepared patches for different versions of Mapserver. Please check the
bug and update it if that works for you. As I mentioned, this should not
happen with current trunk version.
[1]: http://trac.osgeo.org/mapserver/ticket/3430
best regards
> Request:
>
> <?xml version="1.0" ?><wfs:GetFeature service="WFS" version="1.1.0"
> outputFormat="text/xml;
> subtype=gml/3.1.1"xmlns:wfs="http://www.opengis.net/wfs"
> xmlns:ogc="http://www.opengis.net/ogc"xmlns:xsi="http://www.w3.org/2001/
> XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs
> ../wfs/1.1.0/WFS.xsd">
> <wfs:Query typeName="PoligonosSigpac">
> <ogc:Filter>
> <ogc:Or>
> <PropertyIsEqualTo><ogc:PropertyName>GID</ogc:PropertyName><Literal>1</L
> iteral></PropertyIsEqualTo>
> <PropertyIsEqualTo><ogc:PropertyName>GID</ogc:PropertyName><Literal>65</
> Literal></PropertyIsEqualTo>
> <PropertyIsEqualTo><ogc:PropertyName>GID</ogc:PropertyName><Literal>197<
> /Literal></PropertyIsEqualTo>
> <PropertyIsEqualTo><ogc:PropertyName>GID</ogc:PropertyName><Literal>245<
> /Literal></PropertyIsEqualTo>
> </ogc:Or>
> </ogc:Filter>
> </wfs:Query>
> </wfs:GetFeature>
>
> Debug info of the request:
>
> [Tue Apr 13 14:05:51 2010].39000 CGI Request 1 on process 3408
> [Tue Apr 13 14:05:51 2010].54000 msOracleSpatialLayerOpen called with:
> GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS) USING UNIQUE gid SRID
> 82337
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerOpen. Shared
> connection not available. Creating one.
> [Tue Apr 13 14:05:51 2010].164000
> msConnPoolRegister(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerGetItems was
> called.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerInitItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerClose was called.
> Layer name: PoligonosSigpac. Layer connection:
> admcarto/admcarto at ORA10GEX
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerClose. Cleaning
> Oracle Cache.
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerClose. Release the
> Oracle Pool.
> [Tue Apr 13 14:05:51 2010].164000
> msConnPoolRelease(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].164000
> msConnPoolClose(admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].164000 msOracleSpatialLayerOpen called with:
> GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS) USING UNIQUE gid SRID
> 82337
> [Tue Apr 13 14:05:51 2010].210000 msOracleSpatialLayerOpen. Shared
> connection not available. Creating one.
> [Tue Apr 13 14:05:51 2010].210000
> msConnPoolRegister(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].226000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].226000 msOracleSpatialLayerWhichShapes was
> called.
> [Tue Apr 13 14:05:51 2010].226000 msOracleSpatialLayerWhichShapes. Using
> this Sql to retrieve the data: SELECT gid, GEOMETRY FROM (SELECT * FROM
> GX_SIGPAC_POLIGONOS) WHERE (GID= 1) Or ( (GID= 65) Or ( (GID= 197)
> Or (GID= 245) ) ) AND SDO_FILTER( GEOMETRY, MDSYS.SDO_GEOMETRY(2003,
> 82337,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(463498
> .785,4702415.35,603167.124,4811812.82) ),'querytype=window') = 'TRUE'
> [Tue Apr 13 14:05:51 2010].257000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].257000 msOracleSpatialLayerClose was called.
> Layer name: PoligonosSigpac. Layer connection:
> admcarto/admcarto at ORA10GEX
> [Tue Apr 13 14:05:51 2010].257000 msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.
> [Tue Apr 13 14:05:51 2010].257000 msOracleSpatialLayerClose. Cleaning
> Oracle Cache.
> [Tue Apr 13 14:05:51 2010].257000 msOracleSpatialLayerClose. Release the
> Oracle Pool.
> [Tue Apr 13 14:05:51 2010].257000
> msConnPoolRelease(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].257000
> msConnPoolClose(admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].288000 msOracleSpatialLayerOpen called with:
> GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS) USING UNIQUE gid SRID
> 82337
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerOpen. Shared
> connection not available. Creating one.
> [Tue Apr 13 14:05:51 2010].335000
> msConnPoolRegister(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerGetItems was
> called.
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerInitItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerGetShape was
> called. Using the record = 65.
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerGetShape. Sql:
> SELECT GID, PROVINCIA, MUNICIPIO, POLIGONO, DN_SURFACE, DN_PERIMET,
> FECHA_INI, FECHA_FIN, GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS)
> WHERE gid = 65 AND (GID= 1) Or ( (GID= 65) Or ( (GID= 197) Or
> (GID= 245) ) )
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerGetShape was
> called. Using the record = 1.
> [Tue Apr 13 14:05:51 2010].335000 msOracleSpatialLayerGetShape. Sql:
> SELECT GID, PROVINCIA, MUNICIPIO, POLIGONO, DN_SURFACE, DN_PERIMET,
> FECHA_INI, FECHA_FIN, GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS)
> WHERE gid = 1 AND (GID= 1) Or ( (GID= 65) Or ( (GID= 197) Or
> (GID= 245) ) )
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerGetShape was
> called. Using the record = 197.
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerGetShape. Sql:
> SELECT GID, PROVINCIA, MUNICIPIO, POLIGONO, DN_SURFACE, DN_PERIMET,
> FECHA_INI, FECHA_FIN, GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS)
> WHERE gid = 197 AND (GID= 1) Or ( (GID= 65) Or ( (GID= 197) Or
> (GID= 245) ) )
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerGetShape was
> called. Using the record = 245.
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerGetShape. Sql:
> SELECT GID, PROVINCIA, MUNICIPIO, POLIGONO, DN_SURFACE, DN_PERIMET,
> FECHA_INI, FECHA_FIN, GEOMETRY FROM (SELECT * FROM GX_SIGPAC_POLIGONOS)
> WHERE gid = 245 AND (GID= 1) Or ( (GID= 65) Or ( (GID= 197) Or
> (GID= 245) ) )
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerClose was called.
> Layer name: PoligonosSigpac. Layer connection:
> admcarto/admcarto at ORA10GEX
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerClose. Cleaning
> Oracle Cache.
> [Tue Apr 13 14:05:51 2010].351000 msOracleSpatialLayerClose. Release the
> Oracle Pool.
> [Tue Apr 13 14:05:51 2010].351000
> msConnPoolRelease(PoligonosSigpac,admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].351000
> msConnPoolClose(admcarto/admcarto at ORA10GEX,01C6FA48)
> [Tue Apr 13 14:05:51 2010].367000 mapserv request processing time
> (msLoadMap not incl.): 0.328s
> [Tue Apr 13 14:05:51 2010].367000 msFreeMap(): freeing map at 015D5F68.
> [Tue Apr 13 14:05:51 2010].367000 msOracleSpatialLayerClose was called.
> Layer name: PoligonosSigpac. Layer connection:
> admcarto/admcarto at ORA10GEX
>
> And the WFS response is
>
> <?xml version='1.0' encoding="ISO-8859-1" ?>
> <wfs:FeatureCollection
> xmlns:ms="http://mapserver.gis.umn.edu/mapserver"
> xmlns:gml="http://www.opengis.net/gml"
> xmlns:wfs="http://www.opengis.net/wfs"
> xmlns:ogc="http://www.opengis.net/ogc"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://mapserver.gis.umn.edu/mapserver
> http://192.168.1.65/cgi-bin/mapserv.exe?map=../htdocs/MFD/ejemplo_wfs.ma
> p&SERVICE=WFS&VERSION=1.1.0&REQUEST=DescribeFeatureType&
> TYPENAME=PoligonosSigpac&OUTPUTFORMAT=text/xml; subtype=gml/3.1.1
> http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd">
> <gml:boundedBy>
> <gml:Envelope srsName="EPSG:23030">
> <gml:lowerCorner>507876.512623
> 4725415.908118</gml:lowerCorner>
> <gml:upperCorner>559140.632916
> 4754027.254311</gml:upperCorner>
> </gml:Envelope>
> </gml:boundedBy>
> <gml:featureMember>
> <ms:PoligonosSigpac gml:id="PoligonosSigpac.65">
> <gml:boundedBy>
> <gml:Envelope srsName="EPSG:23030">
> <gml:lowerCorner>507876.512623
> 4725415.908118</gml:lowerCorner>
> <gml:upperCorner>509654.924986
> 4727430.060275</gml:upperCorner>
> </gml:Envelope>
> </gml:boundedBy>
> <ms:msGeometry>
> <gml:Polygon srsName="EPSG:23030">
> <gml:exterior>
> <gml:LinearRing>
> <gml:posList srsDimension="2">508370.140478
> 4727315.545819 508335.867232 4727320.996035 508290.659396 4727330.184342
> 508247.515061 4727336.285225 508213.831723 4727342.360368 508177.893761
> 4727350.759952 508139.217777 4727358.067493 508106.542691 4727365.168198
> 508073.350896 4727379.742591 508042.031529 4727396.059870 508021.380782
> 4727407.028376 508000.141383 4727416.507020 507972.680877 4727426.806950
> 507960.779080 4727430.060275 507959.520472 4727426.009949 507955.353514
> 4727413.672367 507951.761294 4727403.038770 507940.152078 4727366.678616
> 507937.929127 4727359.369470 507935.747217 4727352.190681 507931.581751
> 4727338.475568 507925.955179 4727317.629036 507923.366757 4727305.684210
> 507921.980341 4727299.288189 507919.924662 4727289.763994 507919.501512
> 4727287.557569 507918.853104 4727284.206032 507917.556317 4727277.475035
> 507915.993360 4727269.347569 507915.966036 4727269.226537 507909.529718
> 4727241.919508 507903.103010 4727212.164555 507898.301770 4727189.894905
> 507893.683300 4727163.865132 507889.994402 4727135.453636 507884.446852
> 4727105.252936 507880.796683 4727084.976475 507879.258052 4727067.466825
> 507878.242666 4727054.723344 507877.734988 4727048.337643 507876.512623
> 4727036.468857 507901.689121 4727031.341055 507926.183367 4727028.446425
> 507950.525888 4727026.156712 507985.608118 4727022.743920 508015.284939
> 4727015.052783 508037.247246 4727010.861835 508069.146425 4727005.174678
> 508092.282870 4727000.994582 508089.277872 4726969.642533 508087.296632
> 4726943.531951 508091.298917 4726897.081602 508091.919707 4726888.779807
> 508095.065469 4726846.758955 508095.191947 4726838.419352 508095.297109
> 4726830.694036 508092.830917 4726814.132651 508089.703848 4726793.158617
> 508085.562445 4726764.690657 508079.301398 4726740.334254 508071.215454
> 4726708.734296 508069.656907 4726702.756900 508063.176492 4726678.000025
> 508053.145208 4726642.227951 508051.852827 4726637.619109 508046.386304
> 4726597.040250 508038.952405 4726541.743555 508037.000605 4726531.400374
> 508031.302195 4726501.152871 508023.621785 4726462.842562 508019.804997
> 4726432.336636 508016.059925 4726405.097817 508015.962530 4726400.257673
> 508015.308803 4726365.883391 508015.405821 4726335.465775 508014.912053
> 4726323.057972 508013.470935 4726286.700232 508011.971896 4726229.176607
> 508026.512006 4726179.071223 508028.904353 4726170.827332 508029.393851
> 4726169.143198 508052.468188 4726108.567252 508076.090025 4726049.928038
> 508080.642042 4726038.819900 508081.337592 4726037.117395 508096.646573
> 4725999.727449 508110.989526 4725966.441124 508111.375126 4725965.548032
> 508135.743929 4725914.905260 508171.199684 4725844.226772 508189.399434
> 4725807.873613 508196.585760 4725793.529576 508215.254371 4725790.535992
> 508231.024486 4725788.004400 508266.390519 4725782.331577 508365.455593
> 4725766.413314 508384.879769 4725763.402485 508410.519989 4725759.421944
> 508415.527148 4725758.646178 508455.969121 4725752.366183 508482.986724
> 4725717.215961 508500.347456 4725694.638053 508549.570764 4725629.125610
> 508597.013173 4725566.161632 508639.042793 4725510.358187 508661.455261
> 4725479.819566 508685.813878 4725447.338141 508698.078900 4725431.269762
> 508709.807420 4725415.908118 508711.487492 4725417.883472 508733.088271
> 4725443.330116 508756.273369 4725470.295994 508777.245610 4725492.903124
> 508802.260121 4725517.507312 508825.441333 4725541.727637 508843.070387
> 4725557.629135 508859.256350 4725568.828423 508874.812880 4725578.137470
> 508892.829081 4725586.528245 508911.747862 4725592.593292 508928.211276
> 4725596.179365 508947.038186 4725598.893604 508971.631261 4725603.486218
> 508999.339589 4725610.009670 509019.870954 4725616.914807 509041.116605
> 4725623.727859 509053.963702 4725625.075653 509067.102026 4725624.283070
> 509089.336347 4725620.756662 509113.982155 4725616.460957 509140.307380
> 4725614.531722 509153.526752 4725614.791186 509157.138904 4725614.861116
> 509167.618268 4725615.061137 509168.462930 4725615.080871 509169.966848
> 4725615.110786 509172.109418 4725615.150854 509180.137179 4725615.310417
> 509186.276462 4725615.430251 509205.415827 4725615.455669 509214.659310
> 4725615.467964 509228.463752 4725619.870295 509245.908707 4725628.801078
> 509266.850646 4725641.710991 509286.002956 4725657.634278 509307.178433
> 4725680.606300 509330.024251 4725712.488152 509356.982911 4725744.692101
> 509386.382826 4725774.209528 509409.755112 4725802.238955 509426.577993
> 4725823.706889 509447.670860 4725851.146957 509460.888344 4725872.554211
> 509474.960082 4725896.922525 509489.527443 4725925.359035 509501.304870
> 4725950.096571 509516.172709 4725984.583590 509526.792406 4726012.139830
> 509540.353888 4726042.641390 509551.154943 4726068.019906 509557.839801
> 4726090.479430 509561.384907 4726109.081215 509564.069424 4726124.312406
> 509564.459679 4726140.061664 509563.434889 4726161.123694 509563.562161
> 4726183.322863 509562.440193 4726210.118337 509562.503494 4726238.860770
> 509562.431992 4726260.799050 509564.975677 4726278.515222 509568.175738
> 4726293.300360 509574.010192 4726314.790726 509582.411063 4726337.494658
> 509588.746614 4726354.089853 509590.306503 4726373.079837 509588.785093
> 4726395.714195 509589.159036 4726428.142939 509586.513898 4726468.897948
> 509580.573918 4726498.972400 509573.997242 4726532.685311 509573.068354
> 4726558.894677 509575.920317 4726586.952209 509572.188843 4726628.850585
> 509577.842121 4726666.927146 509582.722965 4726692.539553 509584.190067
> 4726728.907009 509594.120718 4726772.043630 509603.691208 4726797.541556
> 509614.372955 4726828.700161 509624.999798 4726854.832516 509636.123603
> 4726879.038872 509645.984773 4726902.666407 509654.924986 4726936.735984
> 509633.800419 4726939.982883 509615.464111 4726942.786946 509610.608762
> 4726943.534132 509591.104806 4726946.653103 509545.242065 4726954.743305
> 509500.390426 4726961.606574 509497.354986 4726962.077105 509435.379554
> 4726973.962128 509417.054136 4726978.981980 509410.081899 4726981.345977
> 509377.700548 4726992.331730 509329.754895 4727007.792288 509320.449810
> 4727009.017684 509313.575740 4727009.911284 509290.453359 4727023.534700
> 509246.101320 4727047.554498 509207.617401 4727068.343281 509164.381481
> 4727089.898530 509126.277006 4727109.673721 509090.098268 4727132.337059
> 509067.768835 4727149.275826 509058.801415 4727160.228632 509043.970678
> 4727181.626407 509041.508058 4727185.188064 509023.025734 4727211.151228
> 509012.704374 4727218.006912 508979.662832 4727236.458496 508957.605756
> 4727250.317101 508956.849909 4727250.790819 508945.237337 4727258.091705
> 508943.616432 4727258.545691 508937.242692 4727260.343164 508930.999465
> 4727262.094273 508920.106433 4727265.161095 508877.586291 4727276.312974
> 508840.171674 4727284.213916 508836.024080 4727284.757777 508803.990153
> 4727288.933371 508767.495442 4727291.614218 508746.759555 4727292.732835
> 508712.381656 4727293.722635 508668.513405 4727296.264416 508636.606992
> 4727297.415920 508604.852191 4727298.120986 508564.557869 4727297.680078
> 508531.128179 4727298.113485 508492.603378 4727299.164420 508458.641561
> 4727302.445701 508425.942066 4727306.547768 508385.948362 4727313.023936
> 508370.140478 4727315.545819 </gml:posList>
> </gml:LinearRing>
> </gml:exterior>
> </gml:Polygon>
> </ms:msGeometry>
> </ms:PoligonosSigpac>
> </gml:featureMember>
> <gml:featureMember>
> <ms:PoligonosSigpac gml:id="PoligonosSigpac.1">
> <gml:boundedBy>
> <gml:Envelope srsName="EPSG:23030">
> <gml:lowerCorner>529575.602797
> 4753999.660256</gml:lowerCorner>
> <gml:upperCorner>529612.280989
> 4754027.254311</gml:upperCorner>
> </gml:Envelope>
> </gml:boundedBy>
> <ms:msGeometry>
> <gml:Polygon srsName="EPSG:23030">
> <gml:exterior>
> <gml:LinearRing>
> <gml:posList srsDimension="2">529580.641695
> 4754027.254311 529578.565694 4754018.588615 529575.602797 4754006.232999
> 529577.786673 4754005.739761 529605.580625 4753999.660256 529607.454087
> 4754004.536595 529608.306230 4754006.764963 529609.983399 4754011.165731
> 529610.151849 4754011.752883 529611.822510 4754017.661573 529612.280989
> 4754019.190118 529580.641695 4754027.254311 </gml:posList>
> </gml:LinearRing>
> </gml:exterior>
> </gml:Polygon>
> </ms:msGeometry>
> </ms:PoligonosSigpac>
> </gml:featureMember>
> <gml:featureMember>
> <ms:PoligonosSigpac gml:id="PoligonosSigpac.65">
> <gml:boundedBy>
> <gml:Envelope srsName="EPSG:23030">
> <gml:lowerCorner>507876.512623
> 4725415.908118</gml:lowerCorner>
> <gml:upperCorner>509654.924986
> 4727430.060275</gml:upperCorner>
> </gml:Envelope>
> </gml:boundedBy>
> <ms:msGeometry>
> <gml:Polygon srsName="EPSG:23030">
> <gml:exterior>
> <gml:LinearRing>
> <gml:posList srsDimension="2">508370.140478
> 4727315.545819 508335.867232 4727320.996035 508290.659396 4727330.184342
> 508247.515061 4727336.285225 508213.831723 4727342.360368 508177.893761
> 4727350.759952 508139.217777 4727358.067493 508106.542691 4727365.168198
> 508073.350896 4727379.742591 508042.031529 4727396.059870 508021.380782
> 4727407.028376 508000.141383 4727416.507020 507972.680877 4727426.806950
> 507960.779080 4727430.060275 507959.520472 4727426.009949 507955.353514
> 4727413.672367 507951.761294 4727403.038770 507940.152078 4727366.678616
> 507937.929127 4727359.369470 507935.747217 4727352.190681 507931.581751
> 4727338.475568 507925.955179 4727317.629036 507923.366757 4727305.684210
> 507921.980341 4727299.288189 507919.924662 4727289.763994 507919.501512
> 4727287.557569 507918.853104 4727284.206032 507917.556317 4727277.475035
> 507915.993360 4727269.347569 507915.966036 4727269.226537 507909.529718
> 4727241.919508 507903.103010 4727212.164555 507898.301770 4727189.894905
> 507893.683300 4727163.865132 507889.994402 4727135.453636 507884.446852
> 4727105.252936 507880.796683 4727084.976475 507879.258052 4727067.466825
> 507878.242666 4727054.723344 507877.734988 4727048.337643 507876.512623
> 4727036.468857 507901.689121 4727031.341055 507926.183367 4727028.446425
> 507950.525888 4727026.156712 507985.608118 4727022.743920 508015.284939
> 4727015.052783 508037.247246 4727010.861835 508069.146425 4727005.174678
> 508092.282870 4727000.994582 508089.277872 4726969.642533 508087.296632
> 4726943.531951 508091.298917 4726897.081602 508091.919707 4726888.779807
> 508095.065469 4726846.758955 508095.191947 4726838.419352 508095.297109
> 4726830.694036 508092.830917 4726814.132651 508089.703848 4726793.158617
> 508085.562445 4726764.690657 508079.301398 4726740.334254 508071.215454
> 4726708.734296 508069.656907 4726702.756900 508063.176492 4726678.000025
> 508053.145208 4726642.227951 508051.852827 4726637.619109 508046.386304
> 4726597.040250 508038.952405 4726541.743555 508037.000605 4726531.400374
> 508031.302195 4726501.152871 508023.621785 4726462.842562 508019.804997
> 4726432.336636 508016.059925 4726405.097817 508015.962530 4726400.257673
> 508015.308803 4726365.883391 508015.405821 4726335.465775 508014.912053
> 4726323.057972 508013.470935 4726286.700232 508011.971896 4726229.176607
> 508026.512006 4726179.071223 508028.904353 4726170.827332 508029.393851
> 4726169.143198 508052.468188 4726108.567252 508076.090025 4726049.928038
> 508080.642042 4726038.819900 508081.337592 4726037.117395 508096.646573
> 4725999.727449 508110.989526 4725966.441124 508111.375126 4725965.548032
> 508135.743929 4725914.905260 508171.199684 4725844.226772 508189.399434
> 4725807.873613 508196.585760 4725793.529576 508215.254371 4725790.535992
> 508231.024486 4725788.004400 508266.390519 4725782.331577 508365.455593
> 4725766.413314 508384.879769 4725763.402485 508410.519989 4725759.421944
> 508415.527148 4725758.646178 508455.969121 4725752.366183 508482.986724
> 4725717.215961 508500.347456 4725694.638053 508549.570764 4725629.125610
> 508597.013173 4725566.161632 508639.042793 4725510.358187 508661.455261
> 4725479.819566 508685.813878 4725447.338141 508698.078900 4725431.269762
> 508709.807420 4725415.908118 508711.487492 4725417.883472 508733.088271
> 4725443.330116 508756.273369 4725470.295994 508777.245610 4725492.903124
> 508802.260121 4725517.507312 508825.441333 4725541.727637 508843.070387
> 4725557.629135 508859.256350 4725568.828423 508874.812880 4725578.137470
> 508892.829081 4725586.528245 508911.747862 4725592.593292 508928.211276
> 4725596.179365 508947.038186 4725598.893604 508971.631261 4725603.486218
> 508999.339589 4725610.009670 509019.870954 4725616.914807 509041.116605
> 4725623.727859 509053.963702 4725625.075653 509067.102026 4725624.283070
> 509089.336347 4725620.756662 509113.982155 4725616.460957 509140.307380
> 4725614.531722 509153.526752 4725614.791186 509157.138904 4725614.861116
> 509167.618268 4725615.061137 509168.462930 4725615.080871 509169.966848
> 4725615.110786 509172.109418 4725615.150854 509180.137179 4725615.310417
> 509186.276462 4725615.430251 509205.415827 4725615.455669 509214.659310
> 4725615.467964 509228.463752 4725619.870295 509245.908707 4725628.801078
> 509266.850646 4725641.710991 509286.002956 4725657.634278 509307.178433
> 4725680.606300 509330.024251 4725712.488152 509356.982911 4725744.692101
> 509386.382826 4725774.209528 509409.755112 4725802.238955 509426.577993
> 4725823.706889 509447.670860 4725851.146957 509460.888344 4725872.554211
> 509474.960082 4725896.922525 509489.527443 4725925.359035 509501.304870
> 4725950.096571 509516.172709 4725984.583590 509526.792406 4726012.139830
> 509540.353888 4726042.641390 509551.154943 4726068.019906 509557.839801
> 4726090.479430 509561.384907 4726109.081215 509564.069424 4726124.312406
> 509564.459679 4726140.061664 509563.434889 4726161.123694 509563.562161
> 4726183.322863 509562.440193 4726210.118337 509562.503494 4726238.860770
> 509562.431992 4726260.799050 509564.975677 4726278.515222 509568.175738
> 4726293.300360 509574.010192 4726314.790726 509582.411063 4726337.494658
> 509588.746614 4726354.089853 509590.306503 4726373.079837 509588.785093
> 4726395.714195 509589.159036 4726428.142939 509586.513898 4726468.897948
> 509580.573918 4726498.972400 509573.997242 4726532.685311 509573.068354
> 4726558.894677 509575.920317 4726586.952209 509572.188843 4726628.850585
> 509577.842121 4726666.927146 509582.722965 4726692.539553 509584.190067
> 4726728.907009 509594.120718 4726772.043630 509603.691208 4726797.541556
> 509614.372955 4726828.700161 509624.999798 4726854.832516 509636.123603
> 4726879.038872 509645.984773 4726902.666407 509654.924986 4726936.735984
> 509633.800419 4726939.982883 509615.464111 4726942.786946 509610.608762
> 4726943.534132 509591.104806 4726946.653103 509545.242065 4726954.743305
> 509500.390426 4726961.606574 509497.354986 4726962.077105 509435.379554
> 4726973.962128 509417.054136 4726978.981980 509410.081899 4726981.345977
> 509377.700548 4726992.331730 509329.754895 4727007.792288 509320.449810
> 4727009.017684 509313.575740 4727009.911284 509290.453359 4727023.534700
> 509246.101320 4727047.554498 509207.617401 4727068.343281 509164.381481
> 4727089.898530 509126.277006 4727109.673721 509090.098268 4727132.337059
> 509067.768835 4727149.275826 509058.801415 4727160.228632 509043.970678
> 4727181.626407 509041.508058 4727185.188064 509023.025734 4727211.151228
> 509012.704374 4727218.006912 508979.662832 4727236.458496 508957.605756
> 4727250.317101 508956.849909 4727250.790819 508945.237337 4727258.091705
> 508943.616432 4727258.545691 508937.242692 4727260.343164 508930.999465
> 4727262.094273 508920.106433 4727265.161095 508877.586291 4727276.312974
> 508840.171674 4727284.213916 508836.024080 4727284.757777 508803.990153
> 4727288.933371 508767.495442 4727291.614218 508746.759555 4727292.732835
> 508712.381656 4727293.722635 508668.513405 4727296.264416 508636.606992
> 4727297.415920 508604.852191 4727298.120986 508564.557869 4727297.680078
> 508531.128179 4727298.113485 508492.603378 4727299.164420 508458.641561
> 4727302.445701 508425.942066 4727306.547768 508385.948362 4727313.023936
> 508370.140478 4727315.545819 </gml:posList>
> </gml:LinearRing>
> </gml:exterior>
> </gml:Polygon>
> </ms:msGeometry>
> </ms:PoligonosSigpac>
> </gml:featureMember>
> <gml:featureMember>
> <ms:PoligonosSigpac gml:id="PoligonosSigpac.65">
> <gml:boundedBy>
> <gml:Envelope srsName="EPSG:23030">
> <gml:lowerCorner>507876.512623
> 4725415.908118</gml:lowerCorner>
> <gml:upperCorner>509654.924986
> 4727430.060275</gml:upperCorner>
> </gml:Envelope>
> </gml:boundedBy>
> <ms:msGeometry>
> <gml:Polygon srsName="EPSG:23030">
> <gml:exterior>
> <gml:LinearRing>
> <gml:posList srsDimension="2">508370.140478
> 4727315.545819 508335.867232 4727320.996035 508290.659396 4727330.184342
> 508247.515061 4727336.285225 508213.831723 4727342.360368 508177.893761
> 4727350.759952 508139.217777 4727358.067493 508106.542691 4727365.168198
> 508073.350896 4727379.742591 508042.031529 4727396.059870 508021.380782
> 4727407.028376 508000.141383 4727416.507020 507972.680877 4727426.806950
> 507960.779080 4727430.060275 507959.520472 4727426.009949 507955.353514
> 4727413.672367 507951.761294 4727403.038770 507940.152078 4727366.678616
> 507937.929127 4727359.369470 507935.747217 4727352.190681 507931.581751
> 4727338.475568 507925.955179 4727317.629036 507923.366757 4727305.684210
> 507921.980341 4727299.288189 507919.924662 4727289.763994 507919.501512
> 4727287.557569 507918.853104 4727284.206032 507917.556317 4727277.475035
> 507915.993360 4727269.347569 507915.966036 4727269.226537 507909.529718
> 4727241.919508 507903.103010 4727212.164555 507898.301770 4727189.894905
> 507893.683300 4727163.865132 507889.994402 4727135.453636 507884.446852
> 4727105.252936 507880.796683 4727084.976475 507879.258052 4727067.466825
> 507878.242666 4727054.723344 507877.734988 4727048.337643 507876.512623
> 4727036.468857 507901.689121 4727031.341055 507926.183367 4727028.446425
> 507950.525888 4727026.156712 507985.608118 4727022.743920 508015.284939
> 4727015.052783 508037.247246 4727010.861835 508069.146425 4727005.174678
> 508092.282870 4727000.994582 508089.277872 4726969.642533 508087.296632
> 4726943.531951 508091.298917 4726897.081602 508091.919707 4726888.779807
> 508095.065469 4726846.758955 508095.191947 4726838.419352 508095.297109
> 4726830.694036 508092.830917 4726814.132651 508089.703848 4726793.158617
> 508085.562445 4726764.690657 508079.301398 4726740.334254 508071.215454
> 4726708.734296 508069.656907 4726702.756900 508063.176492 4726678.000025
> 508053.145208 4726642.227951 508051.852827 4726637.619109 508046.386304
> 4726597.040250 508038.952405 4726541.743555 508037.000605 4726531.400374
> 508031.302195 4726501.152871 508023.621785 4726462.842562 508019.804997
> 4726432.336636 508016.059925 4726405.097817 508015.962530 4726400.257673
> 508015.308803 4726365.883391 508015.405821 4726335.465775 508014.912053
> 4726323.057972 508013.470935 4726286.700232 508011.971896 4726229.176607
> 508026.512006 4726179.071223 508028.904353 4726170.827332 508029.393851
> 4726169.143198 508052.468188 4726108.567252 508076.090025 4726049.928038
> 508080.642042 4726038.819900 508081.337592 4726037.117395 508096.646573
> 4725999.727449 508110.989526 4725966.441124 508111.375126 4725965.548032
> 508135.743929 4725914.905260 508171.199684 4725844.226772 508189.399434
> 4725807.873613 508196.585760 4725793.529576 508215.254371 4725790.535992
> 508231.024486 4725788.004400 508266.390519 4725782.331577 508365.455593
> 4725766.413314 508384.879769 4725763.402485 508410.519989 4725759.421944
> 508415.527148 4725758.646178 508455.969121 4725752.366183 508482.986724
> 4725717.215961 508500.347456 4725694.638053 508549.570764 4725629.125610
> 508597.013173 4725566.161632 508639.042793 4725510.358187 508661.455261
> 4725479.819566 508685.813878 4725447.338141 508698.078900 4725431.269762
> 508709.807420 4725415.908118 508711.487492 4725417.883472 508733.088271
> 4725443.330116 508756.273369 4725470.295994 508777.245610 4725492.903124
> 508802.260121 4725517.507312 508825.441333 4725541.727637 508843.070387
> 4725557.629135 508859.256350 4725568.828423 508874.812880 4725578.137470
> 508892.829081 4725586.528245 508911.747862 4725592.593292 508928.211276
> 4725596.179365 508947.038186 4725598.893604 508971.631261 4725603.486218
> 508999.339589 4725610.009670 509019.870954 4725616.914807 509041.116605
> 4725623.727859 509053.963702 4725625.075653 509067.102026 4725624.283070
> 509089.336347 4725620.756662 509113.982155 4725616.460957 509140.307380
> 4725614.531722 509153.526752 4725614.791186 509157.138904 4725614.861116
> 509167.618268 4725615.061137 509168.462930 4725615.080871 509169.966848
> 4725615.110786 509172.109418 4725615.150854 509180.137179 4725615.310417
> 509186.276462 4725615.430251 509205.415827 4725615.455669 509214.659310
> 4725615.467964 509228.463752 4725619.870295 509245.908707 4725628.801078
> 509266.850646 4725641.710991 509286.002956 4725657.634278 509307.178433
> 4725680.606300 509330.024251 4725712.488152 509356.982911 4725744.692101
> 509386.382826 4725774.209528 509409.755112 4725802.238955 509426.577993
> 4725823.706889 509447.670860 4725851.146957 509460.888344 4725872.554211
> 509474.960082 4725896.922525 509489.527443 4725925.359035 509501.304870
> 4725950.096571 509516.172709 4725984.583590 509526.792406 4726012.139830
> 509540.353888 4726042.641390 509551.154943 4726068.019906 509557.839801
> 4726090.479430 509561.384907 4726109.081215 509564.069424 4726124.312406
> 509564.459679 4726140.061664 509563.434889 4726161.123694 509563.562161
> 4726183.322863 509562.440193 4726210.118337 509562.503494 4726238.860770
> 509562.431992 4726260.799050 509564.975677 4726278.515222 509568.175738
> 4726293.300360 509574.010192 4726314.790726 509582.411063 4726337.494658
> 509588.746614 4726354.089853 509590.306503 4726373.079837 509588.785093
> 4726395.714195 509589.159036 4726428.142939 509586.513898 4726468.897948
> 509580.573918 4726498.972400 509573.997242 4726532.685311 509573.068354
> 4726558.894677 509575.920317 4726586.952209 509572.188843 4726628.850585
> 509577.842121 4726666.927146 509582.722965 4726692.539553 509584.190067
> 4726728.907009 509594.120718 4726772.043630 509603.691208 4726797.541556
> 509614.372955 4726828.700161 509624.999798 4726854.832516 509636.123603
> 4726879.038872 509645.984773 4726902.666407 509654.924986 4726936.735984
> 509633.800419 4726939.982883 509615.464111 4726942.786946 509610.608762
> 4726943.534132 509591.104806 4726946.653103 509545.242065 4726954.743305
> 509500.390426 4726961.606574 509497.354986 4726962.077105 509435.379554
> 4726973.962128 509417.054136 4726978.981980 509410.081899 4726981.345977
> 509377.700548 4726992.331730 509329.754895 4727007.792288 509320.449810
> 4727009.017684 509313.575740 4727009.911284 509290.453359 4727023.534700
> 509246.101320 4727047.554498 509207.617401 4727068.343281 509164.381481
> 4727089.898530 509126.277006 4727109.673721 509090.098268 4727132.337059
> 509067.768835 4727149.275826 509058.801415 4727160.228632 509043.970678
> 4727181.626407 509041.508058 4727185.188064 509023.025734 4727211.151228
> 509012.704374 4727218.006912 508979.662832 4727236.458496 508957.605756
> 4727250.317101 508956.849909 4727250.790819 508945.237337 4727258.091705
> 508943.616432 4727258.545691 508937.242692 4727260.343164 508930.999465
> 4727262.094273 508920.106433 4727265.161095 508877.586291 4727276.312974
> 508840.171674 4727284.213916 508836.024080 4727284.757777 508803.990153
> 4727288.933371 508767.495442 4727291.614218 508746.759555 4727292.732835
> 508712.381656 4727293.722635 508668.513405 4727296.264416 508636.606992
> 4727297.415920 508604.852191 4727298.120986 508564.557869 4727297.680078
> 508531.128179 4727298.113485 508492.603378 4727299.164420 508458.641561
> 4727302.445701 508425.942066 4727306.547768 508385.948362 4727313.023936
> 508370.140478 4727315.545819 </gml:posList>
> </gml:LinearRing>
> </gml:exterior>
> </gml:Polygon>
> </ms:msGeometry>
> </ms:PoligonosSigpac>
> </gml:featureMember>
> </wfs:FeatureCollection>
>
> -----Mensaje original-----
> De: Yewondwossen Assefa [mailto:yassefa at dmsolutions.ca]
> Enviado el: martes, 13 de abril de 2010 13:09
> Para: David Alda Fernandez de Lezea
> CC: mapserver-users at lists.osgeo.org
> Asunto: Re: [mapserver-users] Strange Behaviour with getFeature using
> POSTmethod and more than one typename
>
> David,
>
>> Assefa,
>>
>> Thanks for your response. I had that configured in the waye you told
>>
> me this is what I get:
>
>> [Fri Apr 09 11:24:45 2010].725000 CGI Request 1 on process 1948 [Fri
>>
> Apr 09 11:24:46 2010].37000 mapserv request processing time (msLoadMap
> not incl.): 0.312s [Fri Apr 09 11:24:46 2010].37000 msFreeMap(): freeing
> map at 015D60B8.
>
>>
>>
>>> You should be able to check then the query sent to the oracle db and
>>>
> that might give your more hints.
>
>>>
>>>
>> Where I can view the query sent to Oracle??
>>
>> Thanks.
>>
>>
>>
> I forgot to mention that you also need to have the debug statement in
> your layer for layer specific debug output in oracle.
>
> Layer
> ....
> DEBUG 5
> ...
> END
>
> I am not sure what version of MapServer your are using, but you should
> if not already (and possiible) upgrade to 5.6.3 or the trunk version
> from svn. Both have a lot more debugging information for the oracle
> spatial.
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst
Email: yassefa at dmsolutions.ca
http://www.dmsolutions.ca/
Phone: (613) 565-5056 (ext 14)
Fax: (613) 565-0925
----------------------------------------------------------------
More information about the mapserver-users
mailing list