[mapserver-users] WFS Spatial Filter Problem

Daniel Morissette dmorissette at mapgears.com
Wed Aug 10 11:52:57 EDT 2011


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


-- 
Daniel Morissette
http://www.mapgears.com/
Provider of Professional MapServer Support since 2000



More information about the mapserver-users mailing list