Re: [mapserver-users] WFS Spatial Filter Problem
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-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_srsEPSG: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 OUTLINECOLOR125 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
Re: [mapserver-users] WFS Spatial Filter Problem
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-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_srsEPSG: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 OUTLINECOLOR125 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
Re: [mapserver-users] WFS Spatial Filter Problem
Perhaps the problem comes from the HTTP server (wrong (Fast)CGI config, ...) ? Take a look at your your error.log On 08/10/2011 14:35, 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-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_srsEPSG: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 OUTLINECOLOR125 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
Re: [mapserver-users] WFS Spatial Filter Problem
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-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_srsEPSG: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 OUTLINECOLOR125 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
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; ## Recommended wfs_srsEPSG: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 OUTLINECOLOR125 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
Re: [mapserver-users] WFS Spatial Filter Problem
Hi again, Another thing I just noticed is that the getCapabilities doesn't list any logical operator: ogc:Scalar_Capabilities ogc:Logical_Operators/ ogc:Comparison_Operators ogc:Simple_Comparisons/ ogc:Like/ ogc:Between/ /ogc:Comparison_Operators /ogc:Scalar_Capabilities According to http://mapserver.org/ogc/filter_encoding.html#currently-supported-features the operators AND OR and NOT should be supported. Shouldn't they be listed then? Even in the example in the documentation they are not listed: http://mapserver.org/ogc/filter_encoding.html#server-side However, it seems that it doesn't make a difference at least in my case. The getCapabilities response is the same with a POSTGIS connection and with a shapefile (both containing the same data). 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
RE: [mapserver-users] WFS Spatial Filter Problem
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_srsEPSG: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 OUTLINECOLOR125 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
Re: [mapserver-users] WFS Spatial Filter Problem
Hi there! These are things that I've tried in the meantime: - Manually sending the request to the server, but without different results compared to using OpenLayers functions. Also trying to force the usage of the proxy.cgi by containing it in the URL, but didn't bring up different results. - Thought about the solution as suggested by the John, but substituting a Polygon with a BBOX only works for rectangular Polygons! I need to be able to specify arbitrary Polygons/Shapes. I am sure the solution proposed by him will work, because it will be just a request just like the one that already works. - Thought about trying a newer version of the MapServer. However, I run is the newest ms4w on my local machone and I remember that I had the same problem a few weeks ago. Furthermore, John had the same problem with MapServer 6.0.0, and since then nothing changed about WFS or filter encoding according to the release announcements. - Thought sending a GET request instead of a POST request could solve the problem! They provided examples in the documentation with links, something they definitely wouldn't have done in case those examples wouldn't work! However, even GET requests didn't work! What is strange: Also got errors with code 500. Shouldn't the mapserver return some error message? I AM CONFUSED! Please hlp! Regards, Bryan On 05/08/2011 15:04, John Callahan wrote: This thread may or may not help: http://osgeo-org.1803224.n2.nabble.com/WFS-intersect-request-td6458533.html I have not tried using AND compound filters. The following format does work for me using the BBOX filter. ogc:BBOX ogc:PropertyNameSHAPE/ogc:PropertyName gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:26957 gml:lowerCorner149081.76574899518 163078.62572595105/gml:lowerCorner gml:upperCorner205627.85303800018 194899.95291598293/gml:upperCorner /gml:Envelope /ogc:BBOX - John *** John Callahan, Research Scientist Delaware Geological Survey University of Delaware URL: http://www.dgs.udel.edu 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
Re: [mapserver-users] WFS Spatial Filter Problem
Bryan, Is it possible for you to provide a sample data/map/request that I can try that would reproduce your problems? If that is the case, please send it to me directly and I will test it with the latest MapServer and possibly provide answers. regards, Assefa On 08/08/2011 10:58 AM, Bryan Hempen wrote: Hi there! These are things that I've tried in the meantime: - Manually sending the request to the server, but without different results compared to using OpenLayers functions. Also trying to force the usage of the proxy.cgi by containing it in the URL, but didn't bring up different results. - Thought about the solution as suggested by the John, but substituting a Polygon with a BBOX only works for rectangular Polygons! I need to be able to specify arbitrary Polygons/Shapes. I am sure the solution proposed by him will work, because it will be just a request just like the one that already works. - Thought about trying a newer version of the MapServer. However, I run is the newest ms4w on my local machone and I remember that I had the same problem a few weeks ago. Furthermore, John had the same problem with MapServer 6.0.0, and since then nothing changed about WFS or filter encoding according to the release announcements. - Thought sending a GET request instead of a POST request could solve the problem! They provided examples in the documentation with links, something they definitely wouldn't have done in case those examples wouldn't work! However, even GET requests didn't work! What is strange: Also got errors with code 500. Shouldn't the mapserver return some error message? I AM CONFUSED! Please hlp! Regards, Bryan On 05/08/2011 15:04, John Callahan wrote: This thread may or may not help: http://osgeo-org.1803224.n2.nabble.com/WFS-intersect-request-td6458533.html I have not tried using AND compound filters. The following format does work for me using the BBOX filter. ogc:BBOX ogc:PropertyNameSHAPE/ogc:PropertyName gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:26957 gml:lowerCorner149081.76574899518 163078.62572595105/gml:lowerCorner gml:upperCorner205627.85303800018 194899.95291598293/gml:upperCorner /gml:Envelope /ogc:BBOX - John *** John Callahan, Research Scientist Delaware Geological Survey University of Delaware URL: http://www.dgs.udel.edu 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 -- Assefa Yewondwossen Software Analyst Email: yass...@dmsolutions.ca http://www.dmsolutions.ca/ Phone: (613) 565-5056 (ext 14) Fax: (613) 565-0925 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WFS Spatial Filter Problem
Hi Bryan, could you show how you send the request manually to the server? Might it be possible to send by mail your geodata and your wfs_file? Best regards, Kai Original-Nachricht Datum: Mon, 08 Aug 2011 16:58:30 +0200 Von: Bryan Hempen bhem...@sciops.esa.int An: John Callahan john.calla...@udel.edu CC: mapserver-users@lists.osgeo.org Betreff: Re: [mapserver-users] WFS Spatial Filter Problem Hi there! These are things that I've tried in the meantime: - Manually sending the request to the server, but without different results compared to using OpenLayers functions. Also trying to force the usage of the proxy.cgi by containing it in the URL, but didn't bring up different results. - Thought about the solution as suggested by the John, but substituting a Polygon with a BBOX only works for rectangular Polygons! I need to be able to specify arbitrary Polygons/Shapes. I am sure the solution proposed by him will work, because it will be just a request just like the one that already works. - Thought about trying a newer version of the MapServer. However, I run is the newest ms4w on my local machone and I remember that I had the same problem a few weeks ago. Furthermore, John had the same problem with MapServer 6.0.0, and since then nothing changed about WFS or filter encoding according to the release announcements. - Thought sending a GET request instead of a POST request could solve the problem! They provided examples in the documentation with links, something they definitely wouldn't have done in case those examples wouldn't work! However, even GET requests didn't work! What is strange: Also got errors with code 500. Shouldn't the mapserver return some error message? I AM CONFUSED! Please hlp! Regards, Bryan On 05/08/2011 15:04, John Callahan wrote: This thread may or may not help: http://osgeo-org.1803224.n2.nabble.com/WFS-intersect-request-td6458533.html I have not tried using AND compound filters. The following format does work for me using the BBOX filter. ogc:BBOX ogc:PropertyNameSHAPE/ogc:PropertyName gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:26957 gml:lowerCorner149081.76574899518 163078.62572595105/gml:lowerCorner gml:upperCorner205627.85303800018 194899.95291598293/gml:upperCorner /gml:Envelope /ogc:BBOX - John *** John Callahan, Research Scientist Delaware Geological Survey University of Delaware URL: http://www.dgs.udel.edu 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. = -- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] WFS Spatial Filter Problem
Sorry, I forgot to mention the Error message: !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN htmlhead title500 Internal Server Error/title /headbody h1Internal Server Error/h1 pThe server encountered an internal error or misconfiguration and was unable to complete your request./p pPlease contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error./p pMore information about this error may be available in the server error log./p hr addressApache/2.2.3 (Red Hat) Server at localhost Port 80/address /body/html Thanks, Bryan On 05/08/2011 13:02, Bryan Hempen wrote: The problem: I am trying to implement something similar to http://openlayers.org/dev/examples/wfs-spatial-filter.html with my own data served by MapServer through a WFS. I just changed some lines in the code to make it work with MapServer, so the code is almost equal to the code in the example at the moment. So far it's working fine UNTIL I drag the polygon to apply the spatial filter! According to the getCapabitilies the server should be able to handle the request: ... ogc:Spatial_Capabilities ogc:Spatial_Operators ogc:Equals/ ogc:Disjoint/ ogc:Touches/ ogc:Within/ ogc:Overlaps/ ogc:Crosses/ ogc:Intersect/ ogc:Contains/ ogc:DWithin/ ogc:BBOX/ /ogc:Spatial_Operators /ogc:Spatial_Capabilities ... Both WFS GetFeature requests are sent via HTTP POST. The first one that works (called on page load) looks like this: wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; xmlns:xsi=http ://www.w3.org/2001/XMLSchema-instance service=WFS version=1.0.0 xsi:schemaLocation=http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd; wfs:Query typeName=omega ogc:Filter xmlns:ogc=http://www .opengis.net/ogc ogc:BBOX ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Box xmlns:gml=http: //www.opengis.net/gml srsName=EPSG:4326 gml:coordinates decimal=. cs=, ts= 135.45,-47.425 157.95,-36.175/gml:coordinates /gml:Box /ogc:BBOX /ogc:Filter /wfs:Query /wfs:GetFeature The request not working looks like this: wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; service=WFS version=1.0.0 xsi:schemaLocation=http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd; wfs:Query xmlns:ms=http://mapserver.gis.umn.edu/mapserver; typeName=ms:omega ogc:Filter xmlns:ogc=http://www.opengis.net/ogc; ogc:And ogc:Intersects ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Polygon xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:4326 gml:outerBoundaryIs gml:LinearRing gml:coordinates decimal=. cs=, ts= 145.72880866081,-40.709423872828 145.83867194206,-42.752880904078 148.34355475456,-40.995068404078 145.72880866081,-40.709423872828/gml:coordinates /gml:LinearRing /gml:outerBoundaryIs /gml:Polygon /ogc:Intersects ogc:BBOX ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Box xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:4326 gml:coordinates decimal=. cs=, ts= 135.45,-47.40302734375 157.95,-36.15302734375/gml:coordinates /gml:Box /ogc:BBOX /ogc:And /ogc:Filter /wfs:Query /wfs:GetFeature Does anyone have an idea? Any help is appreciated, I am stuck. The setup: * OS: Red Hat Enterprise Linux 5.4 * PostgreSQL 8.2 * PostGIS 1.3 * MapServer 5.6.5 * OpenLayers, one of the latest versions. ProxyHost set and working (calling the proxy.cgi shows OpenLayers website) 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 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.
Re: [mapserver-users] WFS Spatial Filter Problem
This thread may or may not help: http://osgeo-org.1803224.n2.nabble.com/WFS-intersect-request-td6458533.html I have not tried using AND compound filters. The following format does work for me using the BBOX filter. ogc:BBOX ogc:PropertyNameSHAPE/ogc:PropertyName gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:26957 gml:lowerCorner149081.76574899518 163078.62572595105/gml:lowerCorner gml:upperCorner205627.85303800018 194899.95291598293/gml:upperCorner /gml:Envelope /ogc:BBOX - John *** John Callahan, Research Scientist Delaware Geological Survey University of Delaware URL: http://www.dgs.udel.edu *** On Fri, Aug 5, 2011 at 7:02 AM, Bryan Hempen bhem...@sciops.esa.int wrote: ** The problem: I am trying to implement something similar to http://openlayers.org/dev/examples/wfs-spatial-filter.html with my own data served by MapServer through a WFS. I just changed some lines in the code to make it work with MapServer, so the code is almost equal to the code in the example at the moment. So far it's working fine UNTIL I drag the polygon to apply the spatial filter! According to the getCapabitilies the server should be able to handle the request: ... ogc:Spatial_Capabilities ogc:Spatial_Operators ogc:Equals/ ogc:Disjoint/ ogc:Touches/ ogc:Within/ ogc:Overlaps/ ogc:Crosses/ ogc:Intersect/ ogc:Contains/ ogc:DWithin/ ogc:BBOX/ /ogc:Spatial_Operators /ogc:Spatial_Capabilities ... Both WFS GetFeature requests are sent via HTTP POST. The first one that works (called on page load) looks like this: wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs;http://www.opengis.net/wfsxmlns:xsi=http :// www.w3.org/2001/XMLSchema-instance service=WFS version=1.0.0 xsi:schemaLocation=http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd;http://www.opengis.net/wfshttp://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd wfs:Query typeName=omega ogc:Filter xmlns:ogc=http://www .opengis.net/ogchttp://www%C2%A0.opengis.net/ogc ogc:BBOX ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Box xmlns:gml=http: //www.opengis.net/gmlhttp:%C2%A0//www.opengis.net/gmlsrsName=EPSG:4326 gml:coordinates decimal=. cs=, ts= 135.45,-47.425 157.95,-36.175/gml:coordinates /gml:Box /ogc:BBOX /ogc:Filter /wfs:Query /wfs:GetFeature The request not working looks like this: wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs;http://www.opengis.net/wfsxmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;http://www.w3.org/2001/XMLSchema-instanceservice=WFS version=1.0.0 xsi:schemaLocation=http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd;http://www.opengis.net/wfshttp://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd wfs:Query xmlns:ms=http://mapserver.gis.umn.edu/mapserver;http://mapserver.gis.umn.edu/mapservertypeName=ms:omega ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;http://www.opengis.net/ogc ogc:And ogc:Intersects ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Polygon xmlns:gml=http://www.opengis.net/gml;http://www.opengis.net/gmlsrsName=EPSG:4326 gml:outerBoundaryIs gml:LinearRing gml:coordinates decimal=. cs=, ts= 145.72880866081,-40.709423872828 145.83867194206,-42.752880904078 148.34355475456,-40.995068404078 145.72880866081,-40.709423872828/gml:coordinates /gml:LinearRing /gml:outerBoundaryIs /gml:Polygon /ogc:Intersects ogc:BBOX ogc:PropertyNamemsGeometry/ogc:PropertyName gml:Box xmlns:gml=http://www.opengis.net/gml;http://www.opengis.net/gmlsrsName=EPSG:4326 gml:coordinates decimal=. cs=, ts= 135.45,-47.40302734375 157.95,-36.15302734375/gml:coordinates /gml:Box /ogc:BBOX /ogc:And /ogc:Filter /wfs:Query /wfs:GetFeature Does anyone have an idea? Any help is appreciated, I am stuck. The setup: - OS: Red Hat Enterprise Linux 5.4 - PostgreSQL 8.2 - PostGIS 1.3 - MapServer 5.6.5 - OpenLayers, one of the latest versions. ProxyHost set and working (calling the proxy.cgi shows OpenLayers website) 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