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-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bryan Hempen Sent: Tuesday, August 09, 2011 4:15 AM Cc: mapserver-users@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. =================================================================================================
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
