<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi David,<br>
<br>
I enabled debugging using the following settings:<br>
<br>
CONFIG "MS_ERRORFILE" "/home/bhempen/ms_error.txt"<br>
DEBUG 5<br>
CONFIG "CPL_DEBUG" "ON"<br>
CONFIG "PROJ_DEBUG" "ON" <br>
<br>
The only line that shows up after I got an error 500 using the
spatial filter is:<br>
<br>
[Wed Aug 10 14:30:46 2011].451858 CGI Request 1 on process 21100<br>
<br>
Not really helpful, right?<br>
<br>
Regards,<br>
Bryan<br>
<br>
On 09/08/2011 15:38, Fawcett, David (MPCA) wrote:
<blockquote
cite="mid:D2C2A8AE8E016C42A974F644AF21E1390E6E47D832@MNMAIL05.ead.state.mn.us"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">Bryan, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">For testing, I would enable debugging at the MAP
or LAYER level. If you set DEBUG 5, I think that you should
be able to see the query that MapServer is crafting. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">More on debugging here: <a
moz-do-not-send="true"
href="http://mapserver.org/optimization/debugging.html#debugging">http://mapserver.org/optimization/debugging.html#debugging</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);">David.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);"><o:p> </o:p></span></p>
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; border-color:
rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;
font-family:
"Tahoma","sans-serif"; color:
windowtext;">From:</span></b><span style="font-size:
10pt; font-family:
"Tahoma","sans-serif"; color:
windowtext;"> <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>] <b>On
Behalf Of </b>Bryan Hempen<br>
<b>Sent:</b> Tuesday, August 09, 2011 4:15 AM<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [mapserver-users] WFS Spatial Filter
Problem<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Dear Kai and Assefa,<br>
<br>
<br>
<br>
<span class="apple-style-span"><span style="font-size:
13.5pt;"><o:p></o:p></span></span></p>
<div>
<p class="MsoNormal"><span style="font-size: 11pt;
font-family: "Arial","sans-serif";">After
you two guys requested me to send you my setup, I exported
the content in the databasetable to a shapefile so you can
test it. When I tested the spatial filter right after
that, it suddenly worked ! This narrows down the
possibilities:</span><span style="font-size: 13.5pt;"><br>
<br>
- The request I send is definitely not the problem
anymore. It works with MapServer + shapefile and with
GeoServer.<br>
<br>
</span><span style="font-size: 11pt; font-family:
"Arial","sans-serif";">- I exported
only the geometries <span class="apple-style-span">to the
shapefile </span>in the table with geometrytype =
POLYGON because from ~8000 geometries ~10 are linestrings.
So I investigated possible problems with the linestring
geometries by telling the MapServer not to serve them
using a subquery in the mapfile:</span><span
style="font-size: 13.5pt;"><br>
<br>
</span><span style="font-size: 11pt; font-family:
"Arial","sans-serif";">DATA "the_geom
from (select * from alldata where geometrytype(the_geom) =
'POLYGON') as subquery using unique product_id using
SRID=4326"</span><span style="font-size: 13.5pt;"><br>
<br>
Error 500 still occured. Therefore, the data can't be the
problem neither, right?<br>
<br>
</span><span class="apple-style-span"><span
style="font-size: 11pt; font-family:
"Arial","sans-serif";">- Since I
didn't change anything else MapServer must have problems
communicating with the PostGIS database, but why Error
500 then?</span></span><span style="font-size: 13.5pt;"><br>
</span><span style="font-size: 11pt; font-family:
"Arial","sans-serif";"> </span><span
style="font-size: 13.5pt;"><br>
</span><span style="font-size: 11pt; font-family:
"Arial","sans-serif";">Here is my
mapfile:<br>
<br>
<br>
</span><span style="font-size: 13.5pt;">MAP<br>
NAME "WFS Server"<br>
STATUS ON<br>
SIZE 600 400<br>
SYMBOLSET
"/var/www/html/psa/bhempen/mapservertest/symbols/symbols.sym"<br>
EXTENT -180 -90 180 90<br>
UNITS DD<br>
SHAPEPATH
"/var/www/html/psa/bhempen/mapservertest/data/"<br>
IMAGECOLOR 255 255 255<br>
FONTSET
"/var/www/html/psa/bhempen/mapservertest/fonts/fonts.list"<br>
MAXSIZE 4096 # needs to be set because otherwise an
error will appear when rendering images on large screens<br>
<br>
<br>
#IMAGECOLOR 200 200 200 #commented out for WFS<br>
<br>
PROJECTION<br>
'init=epsg:4326'<br>
END<br>
<br>
WEB<br>
TEMPLATE
'/var/www/html/psa/bhempen/mapservertest/template.html'<br>
IMAGEPATH '/var/www/html/psa/bhempen/tmp/'<br>
IMAGEURL '/psa/bhempen/tmp/' <br>
METADATA<br>
"wfs_title" "WFS Demo Server
for MapServer" ## REQUIRED<br>
"wfs_onlineresource" <a
moz-do-not-send="true"
href="http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&">"http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&"</a>
## Recommended<br>
"wfs_srs" "EPSG:4326" ##
Recommended<br>
"wfs_abstract" "This text
describes my WFS service." ## Recommended<br>
END <br>
END<br>
<br>
LAYER<br>
NAME "omega"<br>
STATUS DEFAULT<br>
TYPE POLYGON<br>
METADATA<br>
"wfs_title" "omega footprints"
##REQUIRED<br>
"wfs_srs" "EPSG:4326" ## REQUIRED<br>
"gml_include_items" "all" ## Optional (serves
all attributes for layer)<br>
"gml_featureid" "product_id" ## REQUIRED<br>
END<br>
PROJECTION<br>
"init=epsg:4326"<br>
END<br>
CONNECTIONTYPE POSTGIS<br>
CONNECTION "host=localhost port=xxx dbname=xxx
user=xxx password=xxx"<br>
DATA "the_geom from alldata using unique product_id
using SRID=4326"<br>
CLASS<br>
STYLE<br>
OUTLINECOLOR 125 0 0<br>
END<br>
END<br>
DUMP TRUE ## REQUIRED<br>
END # layer<br>
<br>
END<br>
</span><span style="font-size: 11pt; font-family:
"Arial","sans-serif";"><br>
<br>
</span><o:p></o:p></p>
</div>
<p class="MsoNormal">Does anyone see a problem with the setup? <br>
<br>
Many thanks to Kai and Assefa for the help so far! I am going
to send you the shapefile (which you could import into the
database with pgsql2shp), the mapfile, and my client.<br>
<br>
Kind regards,<br>
Bryan<o:p></o:p></p>
<pre>================================================================================================<o:p></o:p></pre>
<pre>This message and any attachments are intended for the use of the addressee or addressees only. The unauthorised disclosure, <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>use, dissemination or copying (either in whole or in part) of its content is not permitted. If you received this message in <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>error, please notify the sender and delete it from your system. Emails can be altered and their integrity cannot be guaranteed by <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>the sender. <o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Please consider the environment before printing this email.<o:p></o:p></pre>
<pre>=================================================================================================<o:p></o:p></pre>
</div>
</blockquote>
<br>
<PRE>================================================================================================
This message and any attachments are intended for the use of the addressee or addressees only. The unauthorised disclosure,
use, dissemination or copying (either in whole or in part) of its content is not permitted. If you received this message in
error, please notify the sender and delete it from your system. Emails can be altered and their integrity cannot be guaranteed by
the sender.
Please consider the environment before printing this email.
=================================================================================================
</PRE></body>
</html>