<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Times New Roman","serif"}
span.e-mailformatvorlage17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.e-mailformatvorlage18
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.E-MailFormatvorlage21
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.E-MailFormatvorlage22
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.SprechblasentextZchn
{font-family:"Tahoma","sans-serif"}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 70.85pt 2.0cm 70.85pt}
-->
</style><style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1" lang="DE" link="blue" vlink="purple">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi,<br>
<br>
I would say that if your service is advertising geojson as a supported WFS outputformat in GetCapabilities it should also support all standard WFS requests and parameters and MaxFeatures is such an important parameter that at least that should work for all
outputformats. I suggest you to file a bug into github https://github.com/mapserver. The developers woud like to get also a repeatable test case with a small shapefile and mapfile.<br>
<br>
-Jukka Rahkonen-<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF416319"><font color="#000000" face="Tahoma" size="2">Jacob Mendt wrote:<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi List,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">i did some further testing and meet some unexpecting behavior. If I doesn’t use “MAXFEATURES” in my WFS-Request I get back a GeoJSON Response. Is that wanted behavior or do I miss something?</span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Kind regards,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"><br>
JM</span></p>
<p class="MsoNormal"> </p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Jacob Mendt [mailto:jacobmendt@googlemail.com]
<br>
<b>Gesendet:</b> Dienstag, 22. Juli 2014 09:51<br>
<b>An:</b> 'Rahkonen Jukka (Tike)'; mapserver-users@lists.osgeo.org<br>
<b>Betreff:</b> AW: [mapserver-users] Problems with getting geojson running as WFS response</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Jukka,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">yes i tried this. But the behavior stays the same.</span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D" lang="EN-US">JM</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Rahkonen Jukka (Tike) [<a href="mailto:jukka.rahkonen@mmmtike.fi" target="_blank">mailto:jukka.rahkonen@mmmtike.fi</a>]
<br>
<b>Gesendet:</b> Dienstag, 22. </span><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"" lang="EN-US">Juli 2014 09:30<br>
<b>An:</b> Jacob Mendt; </span><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank"><span lang="EN-US">mapserver-users@lists.osgeo.org</span></a></span><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"" lang="EN-US"><br>
<b>Betreff:</b> Re: [mapserver-users] Problems with getting geojson running as WFS response</span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:black">Hi,<br>
<br>
Have you tried to request geojson with its MIMETYPE as &format=</span><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:black" lang="EN-US">application/json; subtype=geojson ?<br>
<br>
-Jukka Rahkonen-</span><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:black"></span></p>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><span style="font-size:12.0pt; font-family:"Times New Roman","serif"; color:black">
<hr align="center" size="2" width="100%">
</span></div>
<div id="divRpF729656">
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:black">Jacob Mendt wrote:</span><span style="font-size:12.0pt; font-family:"Times New Roman","serif"; color:black"></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="color:black" lang="EN-US">> Hey List,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">> i am right now trying to bring get my Mapserver (Version 6.0.0) WFS running with GeoJSON. But I always get back an empty response. I tried several approaches and my WFS runs with a GML response.
So maybe somebody could give me hint. Here is my mapfile:</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">MAP</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> …</span><span style="color:black"></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:black" lang="EN-US">PROJECTION</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt; text-indent:35.4pt"><span style="color:black" lang="EN-US">"init=epsg:4314"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:black" lang="EN-US">END</span><span style="color:black"></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:black" lang="EN-US">EXTENT 5.83333301544189 47.2000007629395 23.0000019073486 56</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span>
<span style="color:black"></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:black" lang="EN-US">…</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># OUTPUTFORMAT</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># NAME "geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># DRIVER "OGR/GEOJSON"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># MIMETYPE "application/json; subtype=geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># FORMATOPTION "STORAGE=stream"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># FORMATOPTION "FORM=SIMPLE"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"># END</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US">OUTPUTFORMAT</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> NAME "geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> DRIVER "TEMPLATE"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black"> FORMATOPTION "FILE=/home/test/messtischblatt.js"</span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black"> </span>
<span style="color:black" lang="EN-US">MIMETYPE "application/json; subtype=geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US">END</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US">WEB</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> METADATA</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> "wfs_srs" "epsg:900913 epsg:4314 EPSG:3857 EPSG:4326 EPSG:3978"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> "wfs_getfeature_formatlist" "geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US"> END</span><span style="color:black"></span></p>
<p class="MsoNormal" style="margin-left:35.4pt"><span style="color:black" lang="EN-US">END # WEB</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> # geojson layer</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> LAYER</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> TEMPLATE "messtischblatt.js"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> STATUS ON</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> NAME "test"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> TYPE POLYGON</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> EXTENT 649304.652862922 6090078.57976033 2559975.30438738 7538210.86255982</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> DATA "boundingbox from (SELECT * FROM layer ORDER BY titel, time) as foo using unique id using srid=900913"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> CONNECTIONTYPE postgis</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> CONNECTION "dbname=*** user=*** password=*** host=*** "</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> #DATA "messtischblatt"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> #CONNECTIONTYPE OGR</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> #CONNECTION "PG: dbname=*** user=*** password=*** host=***"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> PROJECTION</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> "init=epsg:900913"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> END</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> METADATA</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> "wfs_title" "Test WFS"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> "wfs_srs" "EPSG:4326 EPSG:4314 EPSG:900913 "</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> "wfs_enable_request" "*"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> "wfs_getfeature_formatlist" "geojson"</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> END</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> END</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">END # MAP# Tile Index</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">I test it with a couple of approaches. It tried both Outputformats and both ways of defining a postgis data source. But in any case I get back an empty response. With the template approach I used the
following template:</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">[resultset layer=test]</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">{</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> “type”: “FeatureCollection”,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> “features”: [</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> [feature trimlast=”,”]</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> {</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> “type”: “Feature”,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> “id”: “[id]”,</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> …</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> }</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> [/feature]</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> ]</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">}</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">[/resultset]</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">I run my mapserver also with DEBUG level 5. I got the following log output:</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">[Mon Jul 21 18:10:21 2014].528584 msFreeMap(): freeing map at 0x19447b0.</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">[Mon Jul 21 18:10:22 2014].387718 CGI Request 1 on process 4362</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">[Mon Jul 21 18:10:22 2014].521952 mapserv request processing time (msLoadMap not incl.): 0.134s</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">My test request is:</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"><a href="http://localhost/cgi-bin/mtbows?map=./test.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&TYPENAME=test&MAXFEATURES=100&srsname=EPSG:900913&bbox=1518929.826549386,6766016.954331277,2693002.5808462612,7384239.639015725&outputformat=geojson" target="_blank">http://localhost/cgi-bin/mtbows?map=./test.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&TYPENAME=test&MAXFEATURES=100&srsname=EPSG:900913&bbox=1518929.826549386,6766016.954331277,2693002.5808462612,7384239.639015725&outputformat=geojson</a></span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">Could somebody give me an advice?</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">Kind regards, </span>
<span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US">JM</span><span style="color:black"></span></p>
<p class="MsoNormal"><span style="color:black" lang="EN-US"> </span><span style="color:black"></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>