[mapserver-users] WFS Spatial Filter Problem

Tue Aug 16 06:10:08 EDT 2011

Hi Daniel,

thanks for your input. This, however, was the output of the 
ms_error.txt! Is there anything that can be concluded from that?

Kind regards,
Bryan

On 10/08/2011 17:52, Daniel Morissette wrote:
> Looks like you checked the Apache error_log. With the config that you 
> quoted, you should find the debug info in /home/bhempen/ms_error.txt.
>
>
> On 11-08-10 08:35 AM, Bryan Hempen wrote:
>> Hi David,
>>
>> I enabled debugging using the following settings:
>>
>>      CONFIG "MS_ERRORFILE" "/home/bhempen/ms_error.txt"
>>      DEBUG 5
>>      CONFIG "CPL_DEBUG" "ON"
>>      CONFIG "PROJ_DEBUG" "ON"
>>
>> The only line that shows up after I got an error 500 using the spatial
>> filter is:
>>
>> [Wed Aug 10 14:30:46 2011].451858 CGI Request 1 on process 21100
>>
>> Not really helpful, right?
>>
>> Regards,
>> Bryan
>>
>> On 09/08/2011 15:38, Fawcett, David (MPCA) wrote:
>>>
>>> Bryan,
>>>
>>> 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.
>>>
>>> More on debugging here:
>>> http://mapserver.org/optimization/debugging.html#debugging
>>>
>>> David.
>>>
>>> *From:*mapserver-users-bounces at lists.osgeo.org
>>> [mailto:mapserver-users-bounces at lists.osgeo.org] *On Behalf Of *Bryan
>>> Hempen
>>> *Sent:* Tuesday, August 09, 2011 4:15 AM
>>> *Cc:* mapserver-users at lists.osgeo.org
>>> *Subject:* Re: [mapserver-users] WFS Spatial Filter Problem
>>>
>>> Dear Kai and Assefa,
>>>
>>>
>>>
>>> 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:
>>>
>>> - The request I send is definitely not the problem anymore. It works
>>> with MapServer + shapefile and with GeoServer.
>>>
>>> - I exported only the geometries to the shapefile 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:
>>>
>>> DATA "the_geom from (select * from alldata where
>>> geometrytype(the_geom) = 'POLYGON') as subquery using unique
>>> product_id using SRID=4326"
>>>
>>> Error 500 still occured. Therefore, the data can't be the problem
>>> neither, right?
>>>
>>> - Since I didn't change anything else MapServer must have problems
>>> communicating with the PostGIS database, but why Error 500 then?
>>>
>>> Here is my mapfile:
>>>
>>>
>>> MAP
>>>     NAME "WFS Server"
>>>     STATUS ON
>>>     SIZE 600 400
>>>     SYMBOLSET
>>> "/var/www/html/psa/bhempen/mapservertest/symbols/symbols.sym"
>>>     EXTENT -180 -90 180 90
>>>     UNITS DD
>>>     SHAPEPATH "/var/www/html/psa/bhempen/mapservertest/data/"
>>>     IMAGECOLOR 255 255 255
>>>     FONTSET "/var/www/html/psa/bhempen/mapservertest/fonts/fonts.list"
>>>     MAXSIZE 4096 # needs to be set because otherwise an error will
>>> appear when rendering images on large screens
>>>
>>>
>>> #IMAGECOLOR     200 200 200 #commented out for WFS
>>>
>>> PROJECTION
>>>        'init=epsg:4326'
>>> END
>>>
>>>     WEB
>>>     TEMPLATE  '/var/www/html/psa/bhempen/mapservertest/template.html'
>>>     IMAGEPATH '/var/www/html/psa/bhempen/tmp/'
>>>     IMAGEURL  '/psa/bhempen/tmp/'
>>>       METADATA
>>>             "wfs_title"                  "WFS Demo Server for
>>> MapServer" ## REQUIRED
>>>             "wfs_onlineresource"
>>> "http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&"
>>> <http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&> ##
>>> Recommended
>>>             "wfs_srs"                    "EPSG:4326" ## Recommended
>>>             "wfs_abstract"               "This text describes my WFS
>>> service." ## Recommended
>>>       END
>>>     END
>>>
>>> LAYER
>>>     NAME   "omega"
>>>     STATUS       DEFAULT
>>>     TYPE         POLYGON
>>>     METADATA
>>>         "wfs_title"             "omega footprints" ##REQUIRED
>>>         "wfs_srs"               "EPSG:4326" ## REQUIRED
>>>        "gml_include_items"     "all" ## Optional (serves all
>>> attributes for layer)
>>>         "gml_featureid"         "product_id" ## REQUIRED
>>>     END
>>>     PROJECTION
>>>         "init=epsg:4326"
>>>     END
>>>     CONNECTIONTYPE POSTGIS
>>>     CONNECTION "host=localhost port=xxx dbname=xxx user=xxx 
>>> password=xxx"
>>>     DATA "the_geom from alldata using unique product_id using 
>>> SRID=4326"
>>>     CLASS
>>>         STYLE
>>>             OUTLINECOLOR    125 0 0
>>>         END
>>>     END
>>>     DUMP TRUE             ## REQUIRED
>>> END # layer
>>>
>>> END
>>>
>>>
>>> Does anyone see a problem with the setup?
>>>
>>> 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.
>>>
>>> Kind regards,
>>> Bryan
>>>
>>> ================================================================================================ 
>>>
>>> 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.
>>> ================================================================================================= 
>>>
>>
>> ================================================================================================ 
>>
>> 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.
>> ================================================================================================= 
>>
>>
>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>

================================================================================================
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.
=================================================================================================