[mapserver-users] Error with Filter = no results
Daniel Hardes
hardes at 3dis.de
Thu Feb 2 05:09:56 PST 2017
Thank you. EXTENT was the missing setting
Am 02.02.2017 um 13:45 schrieb Seth G:
>
> Hi Daniel,
>
> Does setting the EXTENT for your map or layer make any difference?
>
> Also try adding the projections you want to use to the MAP METADATA
> section.
>
> "wfs_srs" "EPSG:32632 EPSG:4326"
>
> Regards,
>
> Seth
>
>
> On 02/02/2017 10:19, Daniel Hardes wrote:
>>
>> Same query without srsName. I tried it with WFS 1.0.0, 1.1.0, 2.0.0
>> and no results.
>>
>>
>> Am 02.02.2017 um 09:33 schrieb Rahkonen Jukka (MML):
>>> What happens if you remove srsName from the filter? It can be hard to know how to reproject from EPSG:32632 into unknown. WFS 1.0.0 is anyway tied to the default srs. I would also consider saving data into PostGIS with proper SRID.
>>>
>>> -Jukka Rahkonen-
>>>
>>> ----- Alkuperäinen viesti -----
>>> Lähettäjä: "Daniel Hardes"<hardes at 3dis.de>
>>> Lähetetty: 2.2.2017 10:22
>>> Vastaanottaja:"mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org>
>>> Aihe: [mapserver-users] Error with Filter = no results
>>>
>>> Hello,
>>> i have a question with the Filter parameter.
>>> without a filter, mapserver does a normal SQL query like:
>>>
>>> select "pkid","set","id","lod","type","source","referencepoint","boundingbox",encode(ST_AsBinary(ST_Force_2D("groundsurface"),'NDR'),'hex') as geom,"id" from building where groundsurface && ST_GeomFromText('POLYGON((691642.41999 5334989.72599,691642.41999 5335172.82301,691979.17301 5335172.82301,691979.17301 5334989.72599,691642.41999 5334989.72599))',-1) limit 101
>>>
>>> but if i add an BBox filter, i got a wrong polygon:
>>> select "pkid","set","id","lod","type","source","referencepoint","boundingbox",encode(ST_AsBinary(ST_Force_2D("groundsurface"),'NDR'),'hex') as geom,"id" from building where groundsurface && ST_GeomFromText('POLYGON((-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785))',-1) and (st_intersects(groundsurface,ST_GeomFromText('POLYGON ((691813.1405204038600000 5335101.3663145527000000, 691813.1405204038600000 5335921.3585226759000000, 692960.5523786536700000 5335921.3585226759000000, 692960.5523786536700000 5335101.3663145527000000, 691813.1405204038600000 5335101.3663145527000000))',-1)) = TRUE)
>>>
>>> ... The polygon:
>>>
>>> 'POLYGON((-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785,-0.999888179649133 -0.999999999990785))',-1
>>> is wrong. A normal SQL query without these values, gets my desired result.
>>>
>>> My map File:
>>> --------------------------------------------------------------
>>> MAP
>>> NAME "sample"
>>>
>>> SIZE 800 400
>>> DEBUG 5
>>> OUTPUTFORMAT
>>> NAME "geojson"
>>> DRIVER "OGR/GEOJSON"
>>> MIMETYPE "application/json; subtype=geojson"
>>> FORMATOPTION "STORAGE=stream"
>>> FORMATOPTION "FORM=SIMPLE"
>>> END
>>>
>>> CONFIG MS_ERRORFILE "ms_error.log"
>>> PROJECTION
>>> "init=epsg:32632"
>>>
>>> END
>>>
>>> WEB
>>> METADATA
>>> ows_enable_request "*"
>>> END
>>> END
>>>
>>> LAYER
>>> DEBUG 5
>>> NAME "poly"
>>> STATUS DEFAULT
>>> TYPE POLYGON
>>> METADATA
>>> "wfs_srs" "EPSG:32632"
>>> "wms_transparent" "true"
>>> "wfs_getfeature_formatlist" "geojson"
>>> END
>>> PROJECTION
>>> 'init=epsg:32632'
>>> END
>>> CONNECTIONTYPE postgis
>>> CONNECTION "host=localhost port=5432 user=postgres password=xxxxx dbname=map_daniel"
>>> DATA "groundsurface from building using SRID=-1 using unique id"
>>> CLASS
>>> STYLE
>>> COLOR "#88888888"
>>> ANTIALIAS true
>>> END
>>> END
>>> END
>>> END
>>> -------------------------------------------------------------
>>> And the Request:
>>> http://localhost:8081/cgi-bin/mapserv.exe?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&SRSNAME=EPSG:32632&TYPENAMES=poly&COUNT=100&outputformat1=geojson&map=C:\Users\d.hardes\Documents\map.map&Filter=<Filter><BBOX><PropertyName>poly</PropertyName><Box srsName="EPSG:32632"> <coordinates>691813.1405204039,5335101.366314553 692960.5523786537,5335921.358522676</coordinates></Box></BBOX></Filter>
>>>
>>> And result
>>> <?xml version='1.0' encoding="UTF-8" ?>
>>> <wfs:FeatureCollection
>>> xmlns:ms="http://mapserver.gis.umn.edu/mapserver"
>>> xmlns:wfs="http://www.opengis.net/wfs"
>>> xmlns:gml="http://www.opengis.net/gml"
>>> xmlns:ogc="http://www.opengis.net/ogc"
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> xsi:schemaLocation="http://www.opengis.net/wfs
>>> http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
>>> http://mapserver.gis.umn.edu/mapserver
>>> http://localhost:8081/cgi-bin/mapserv.exe?SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=poly&OUTPUTFORMAT=XMLSCHEMA">
>>> <gml:boundedBy>
>>> <gml:null>missing</gml:null>
>>> </gml:boundedBy>
>>> </wfs:FeatureCollection>
>>>
>>>
>>> where is the Error in my settings?
>>>
>>
>> --
>>
>> 3DIS GmbH <http://www.3dis.de>
>>
>>
>>
>> Daniel Hardes
>> Mail: hardes at 3dis.de <mailto:kalkofen at 3dis.de>| Tel.: +49 (0)2861 8919 84
>>
>> 3DIS GmbH
>> Konrad-Zuse-Straße 6 D - 46397 Bocholt
>> www.3dis.de <http://www.3dis.de>
>>
>> 3DIS GmbH | Geschäftsführung: Gerrit Hoven, Andreas Steffens |
>> Amtsgericht Coesfeld | HRB 12986
>>
>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
--
3DIS GmbH <http://www.3dis.de>
Daniel Hardes
Mail: hardes at 3dis.de <mailto:kalkofen at 3dis.de>| Tel.: +49 (0)2861 8919 84
3DIS GmbH
Konrad-Zuse-Straße 6 D - 46397 Bocholt
www.3dis.de <http://www.3dis.de>
3DIS GmbH | Geschäftsführung: Gerrit Hoven, Andreas Steffens |
Amtsgericht Coesfeld | HRB 12986
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170202/d629fdaf/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 5468 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170202/d629fdaf/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3dis_64_126.png
Type: image/png
Size: 5468 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170202/d629fdaf/attachment-0003.png>
More information about the mapserver-users
mailing list