<div dir="ltr">Hei!<div><br></div><div>Thanks, guys!</div><div><br></div><div>I tried all the different coordinate orders ( with the good old axis orientation in mind), but I was missing the layer PROJECTION parameter like Seth suggested.</div><div>It seems it is a combination of three things here:</div><div><ul><li>PROJECTION missing in LAYER</li><li>Coordinate order in the request</li><li>Wfs_srs needs to be there like it was, but the main one is only needed. 3301 in my case<br></li></ul></div><div>All in all, got it working, big thanks :) !<br></div><div><br></div><div>Cheers,</div><div>Sander</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Nov 25, 2021 at 11:12 AM Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="FI" style="overflow-wrap: break-word;">
<div class="gmail-m_-983444571717208768WordSection1">
<p class="MsoNormal"><span lang="EN-US">(resending to the list without the original mail, list has rather (too?) strict size limits, 40 KB)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Perhaps you fell into the infamous axis order trap. With WFS 1.1.x and 2.0 the coordinates of EPSG:4326 most be in latitude-longiture oreder. I modified you mapfile a bit for my test
data that are in EPSG:3067, and this request<br>
<a href="http://localhost:8060/cgi-bin/mapserv.exe?map=c:/ms4w_data/wfstest.map&service=WFS&version=2.0.0&request=GetFeature&TypeNames=ms:testi_virolaisille&BBOX=60.1870614692821,24.9810192523929,60.2794267964524,25.1561900521738,urn:ogc:def:crs:EPSG::4326" target="_blank">http://localhost:8060/cgi-bin/mapserv.exe?map=c:/ms4w_data/wfstest.map&service=WFS&version=2.0.0&request=GetFeature&TypeNames=ms:testi_virolaisille&BBOX=60.1870614692821,24.9810192523929,60.2794267964524,25.1561900521738,urn:ogc:def:crs:EPSG::4326</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">finds buildings from the database. The SQL that Mapserver generates is:
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">[Thu Nov 25 10:23:51 2021].654000 msPostGISLayerWhichShapes query: SELECT "fid"::text,"id"::text,"mtk_id"::text,"sijaintitarkkuus"::text,"aineistolahde"::text,"alkupvm"::text,"kohdeluokka"::text,"korkeustarkkuus"::text,"kayttotarkoitus"::text,"kerrosluku"::text,"pohjankorkeus"::text,"korkeusarvo"::text,ST_AsBinary(("geom"),'NDR')
as geom,"fid"::text FROM rakennus WHERE "geom" && ST_GeomFromText('POLYGON((388034.000000002 6673671.81841385,388034.000000002 6684239.6439825,398034 6684239.6439825,398034 6673671.81841385,388034.000000002 6673671.81841385))',3067)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Notice that the re-projected polygon seems to be the envelope of the rotated bbox from the transformation and therefore it is bigger than the polygon that would be achieved by connecting
the projected corner points as this test with gdaltranform shows. <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">gdaltransform -s_srs epsg:4326 -t_srs epsg:3067
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">24.9810192523929 60.1870614692821<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">388034.000000002 6673956 0<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">25.1561900521738 60.279426796452<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">398033.999999999 6683955.99999996 0<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I add also my mapfile, I apologize that it is just a fast modification of some old mapfile and is not the cleanest possible.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">MAP<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONFIG "MS_ERRORFILE" "/ms4w_data/ms_error.txt"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> EXTENT 19970 6597278 749676 7785300<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> PROJECTION<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "init=epsg:3067"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> OUTPUTFORMAT<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "OGRGML"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> DRIVER "OGR/GML"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> FORMATOPTION "STORAGE=stream"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> FORMATOPTION "LCO:COORDINATE_PRECISION=10"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> OUTPUTFORMAT<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> NAME "GeoJSON"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> DRIVER "OGR/GEOJSON"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> MIMETYPE "application/json; subtype=geojson; charset=utf-8"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> FORMATOPTION "STORAGE=stream"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> FORMATOPTION "FORM=SIMPLE"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> FORMATOPTION "LCO:COORDINATE_PRECISION=10"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> LAYER<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">
</span><span>NAME "testi_virolaisille"<u></u><u></u></span></p>
<p class="MsoNormal"><span> STATUS ON<u></u><u></u></span></p>
<p class="MsoNormal"><span> DEBUG 10<u></u><u></u></span></p>
<p class="MsoNormal"><span> </span><span lang="EN-US">TYPE polygon<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> <u></u>
<u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> PROJECTION<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "init=epsg:3067"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> METADATA<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "ows_title" "viro_testi"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "ows_abstract" "viro_testi"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_getfeature_formatlist" "GeoJSON"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> # "gml_featureid" "id"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "gml_include_items" "all"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> # "gml_types" "auto"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_srs" "EPSG:3067 EPSG:3857 EPSG:4326"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONNECTIONTYPE POSTGIS<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONNECTION "host=localhost port=5432 dbname= user= password= "<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> DATA "geom from rakennus using SRID=3067"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> CLASS<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> STYLE<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> COLOR 255 0 0
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> WEB<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> MINSCALE 10<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> MAXSCALE 1550000<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> METADATA<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wms_title" "wfs_test"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_onlineresource"
<a href="http://localhost:8060/cgi-bin/mapserv.exe?map=c:%5Cms4w_data%5Cwfstest.map" target="_blank">
http://localhost:8060/cgi-bin/mapserv.exe?map=c:\ms4w_data\wfstest.map</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">
</span><span lang="SV">"wms_srs" "EPSG:4326 EPSG:900913 EPSG:3857 EPSG:31370"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="SV"> </span><span lang="EN-US">"wms_enable_request" "*"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wms_feature_info_mime_type" "text/html"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wms_format" "image/png"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_title" "wfs_test"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_srs" "EPSG:3067 EPSG:3857 EPSG:4326"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_enable_request" "*"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> "wfs_precision" "10"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> #"wfs_feature_info_mime_type" "text/html"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"> END
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">END<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span>-Jukka Rahkonen-<u></u><u></u></span></p>
</div>
</div>
_______________________________________________<br>
MapServer-users mailing list<br>
<a href="mailto:MapServer-users@lists.osgeo.org" target="_blank">MapServer-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote></div>