[mapserver-users] WFS Spatial Filter Problem

2011-08-05 Thread Bryan Hempen 
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:


...














...

Both WFS GetFeature requests are sent via HTTP POST. The first one that 
works (called on page load) looks like this:


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";>


http://www  .opengis.net/ogc">

msGeometry

135.45,-47.425 
157.95,-36.175







The request not working looks like this:

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";>
http://mapserver.gis.umn.edu/mapserver"; 
typeName="ms:omega">

http://www.opengis.net/ogc";>


msGeometry
http://www.opengis.net/gml"; srsName="EPSG:4326">


145.72880866081,-40.709423872828 145.83867194206,-42.752880904078 
148.34355475456,-40.995068404078 
145.72880866081,-40.709423872828






msGeometry
http://www.opengis.net/gml"; srsName="EPSG:4326">
135.45,-47.40302734375 
157.95,-36.15302734375








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

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-05 Thread Bryan Hempen 

Sorry, I forgot to mention the Error message:



500 Internal Server Error

Internal Server Error
The server encountered an internal error or
misconfiguration and was unable to complete
your request.
Please 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.
More information about this error may be available
in the server error log.

Apache/2.2.3 (Red Hat) Server at localhost Port 80


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:


...














...

Both WFS GetFeature requests are sent via HTTP POST. The first one 
that works (called on page load) looks like this:


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";>


http://www  .opengis.net/ogc">

msGeometry

135.45,-47.425 
157.95,-36.175







The request not working looks like this:

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";>
http://mapserver.gis.umn.edu/mapserver"; 
typeName="ms:omega">

http://www.opengis.net/ogc";>


msGeometry
http://www.opengis.net/gml"; srsName="EPSG:4326">


145.72880866081,-40.709423872828 145.83867194206,-42.752880904078 
148.34355475456,-40.995068404078 
145.72880866081,-40.709423872828






msGeometry
http://www.opengis.net/gml"; srsName="EPSG:4326">
135.45,-47.40302734375 
157.95,-36.15302734375








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

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-05 Thread John Callahan 
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.


SHAPE
http://www.opengis.net/gml"; srsName="EPSG:26957">
149081.76574899518 163078.62572595105
205627.85303800018 194899.95291598293



- 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  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:
>
> ...
>   
> 
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
> 
>   
> ...
>
> Both WFS GetFeature requests are sent via HTTP POST. The first one that
> works (called on page load) looks like this:
>
>  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";
> >
> 
> http://www  
> .opengis.net/ogc"
> >
> 
> msGeometry
> srsName="EPSG:4326">
> 135.45,-47.425 157.95,-36.175
> 
> 
> 
> 
> 
>
> The request not working looks like this:
>
>  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";
> >
>xmlns:ms="http://mapserver.gis.umn.edu/mapserver";typeName="ms:omega">
>  xmlns:ogc="http://www.opengis.net/ogc";
> >
>   
> 
>   msGeometry
>xmlns:gml="http://www.opengis.net/gml";srsName="EPSG:4326">
> 
>   
> 145.72880866081,-40.709423872828 145.83867194206,-42.752880904078
> 148.34355475456,-40.995068404078
> 145.72880866081,-40.709423872828
>   
> 
>   
> 
> 
>   msGeometry
>xmlns:gml="http://www.opengis.net/gml";srsName="EPSG:4326">
> 135.45,-47.40302734375 157.95,-36.15302734375
>   
> 
>   
> 
>   
> 
>
> 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
>
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-08 Thread Bryan Hempen 

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.



SHAPE
http://www.opengis.net/gml"; srsName="EPSG:26957">
149081.76574899518 163078.62572595105
205627.85303800018 194899.95291598293



- 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

2011-08-08 Thread Yewondwossen Assefa 

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.



SHAPE
http://www.opengis.net/gml"; 
srsName="EPSG:26957">

149081.76574899518 163078.62572595105
205627.85303800018 194899.95291598293



- 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

2011-08-08 Thread Kai Behncke 
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 
> An: John Callahan 
> 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.
> >
> > 
> > SHAPE
> > http://www.opengis.net/gml";
> srsName="EPSG:26957">
> > 149081.76574899518 163078.62572595105
> > 205627.85303800018 194899.95291598293
> > 
> > 
> >
> > - 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

2011-08-09 Thread Bryan Hempen 

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_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
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

2011-08-09 Thread Bryan Hempen 

Hi again,

Another thing I just noticed is that the getCapabilities doesn't list 
any logical operator:











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

2011-08-09 Thread Fawcett, David (MPCA) 
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
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

2011-08-10 Thread Bryan Hempen 

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_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
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 a

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-10 Thread Julien Cigar 
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_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
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 addres

AW: [mapserver-users] WFS Spatial Filter Problem

2011-08-10 Thread Eichner, Andreas - SID-NLKM 

Hi,

HTTP error code 500 means: Internal Server error and is usually reported when 
the (F)CGI process dies. Probably a simple NULL pointer dereference due to a 
missing check which results in a segmentation fault... Ever tried the thing 
with shp2img? If this also segfaults try recompiling with debug enabled and run 
it trough gdb.

Greets.

> -Ursprüngliche Nachricht-
> Von: mapserver-users-boun...@lists.osgeo.org 
> [mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag 
> von Bryan Hempen
> Gesendet: Mittwoch, 10. August 2011 14:35
> An: Fawcett, David (MPCA)
> Cc: mapserver-users@lists.osgeo.org
> Betreff: 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.ma
> p&" 
> <http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.ma
> p&>  ## Recommended
>   "wfs_srs"

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-10 Thread Daniel Morissette 
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_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
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 addres

Re: [mapserver-users] WFS Spatial Filter Problem

2011-08-16 Thread Bryan Hempen 

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_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
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

=

Re: AW: [mapserver-users] WFS Spatial Filter Problem

2011-08-17 Thread Bryan Hempen 

Hey guys,

my current status report. I have tried the following list of things:

- as proposed by Andreas, used shp2img. Works perfectly fine!

- as proposed by Julien, took a look at the Apache error log. Here is a 
small excerpt of what it shows:


[Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] 
3c3400-3c3403d000
r-xp  fd:00 3123859
/usr/lib64/libldap_r-2.3.so.0

.2.31, referer: http://ssols02.esac.esa.int/psa/bhempen/tree.html

...

[Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] 
3c34a1c000-3c34a1d000
rw-p 0001c000 fd:00 3118384
/usr/lib64/libgeos_c.so.1.6.2

, referer: http://ssols02.esac.esa.int/psa/bhempen/tree.html

...

[Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] Premature end 
of scrip
t headers: mapserv, referer: 
http://ssols02.esac.esa.int/psa/bhempen/tree.html


In case it could be useful to see the whole log, please just tell me.

Now, to wrap things up again adding some new insights by testing with 
different versions of the MapServer. This is what happened:



When I try to use the WFS FE Spatial Filter Intersect with MapServer 
5.6.5 on a PostGIS layer, it doesn't work and I get an Error 500.
When, however, I use a WFS FE Spatial Filter like Intersect with 
MapServer 5.6.5 on a shapefile layer with the SAME data as the PostGIS 
layer contains, it works!
When I try to use the WFS FE Spatial Filter BBOX with MapServer 5.6.5 on 
a PostGIS layer, it works!
When I use a WFS FE non-spatial filter like PropertyIsEqualTo and/or 
combined with logical filters like AND or OR combined with the WFS FE 
Spatial Filter BBOX with MapServer 5.6.5 on a shapefile layer or a 
PostGIS layer with the the SAME data, it works!
When I try to use the WFS FE Spatial Filter Intersect with MapServer 
6.0.1 on a PostGIS layer, sometimes no results are returned and 
sometimes only some. The results are not accurate.
When I try to use the WFS FE Spatial Filter Intersect with MapServer 
6.0.1 on a shapefile layer, sometimes no results are returned and 
sometimes only some. The results are not accurate.
When I use a WFS FE non-spatial filter like PropertyIsEqualTo and/or 
combined with logical filters like AND or OR combined with the WFS FE 
Spatial Filter BBOX with MapServer 6.0.1 on a shapefile layer or a 
PostGIS layer with the the SAME data, it seems to work, but I am not 
100% sure.


Therefore: No problem with Apache setup, mapfiles, data, 
client/requests. Should be a MapServer bug...


Using the same PostGIS db and shapefile all the time and mapfiles 
modified as minimal as possible.


Kind regards,
Bryan

On 10/08/2011 15:16, Eichner, Andreas - SID-NLKM wrote:

Hi,

HTTP error code 500 means: Internal Server error and is usually reported when 
the (F)CGI process dies. Probably a simple NULL pointer dereference due to a 
missing check which results in a segmentation fault... Ever tried the thing 
with shp2img? If this also segfaults try recompiling with debug enabled and run 
it trough gdb.

Greets.


-Ursprüngliche Nachricht-
Von: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag
von Bryan Hempen
Gesendet: Mittwoch, 10. August 2011 14:35
An: Fawcett, David (MPCA)
Cc: mapserver-users@lists.osgeo.org
Betreff: 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

AW: AW: [mapserver-users] WFS Spatial Filter Problem

2011-08-17 Thread Eichner, Andreas - SID-NLKM 

OK, now run the CGI on the command line and append the QUERY_STRING parameter 
carrying the request parameters:

$ /usr/lib/cgi-bin/mapserv 
QUERY_STRING='map=&service=WFS&request=GetCapabilities'

This should give you the capabilities document. If that works use your failing 
one. This should expectedly fail. If you can't guess right now what causes the 
crash you can now use gdb to locate the error if you compiled with the debug 
option enabled. Let us know when you find more detailes about the cause.

Regards


> -Ursprüngliche Nachricht-
> Von: Bryan Hempen [mailto:bhem...@sciops.esa.int] 
> Gesendet: Mittwoch, 17. August 2011 11:55
> An: Eichner, Andreas - SID-NLKM
> Cc: mapserver-users@lists.osgeo.org
> Betreff: Re: AW: [mapserver-users] WFS Spatial Filter Problem
> 
> Hey guys,
> 
> my current status report. I have tried the following list of things:
> 
> - as proposed by Andreas, used shp2img. Works perfectly fine!
> 
> - as proposed by Julien, took a look at the Apache error log. 
> Here is a 
> small excerpt of what it shows:
> 
> [Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] 
> 3c3400-3c3403d000
> r-xp  fd:00 3123859
> /usr/lib64/libldap_r-2.3.so.0
> .2.31, referer: http://ssols02.esac.esa.int/psa/bhempen/tree.html
> 
> ...
> 
> [Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] 
> 3c34a1c000-3c34a1d000
> rw-p 0001c000 fd:00 3118384
> /usr/lib64/libgeos_c.so.1.6.2
> , referer: http://ssols02.esac.esa.int/psa/bhempen/tree.html
> 
> ...
> 
> [Wed Aug 17 10:42:15 2011] [error] [client 10.68.180.121] 
> Premature end 
> of scrip
> t headers: mapserv, referer: 
> http://ssols02.esac.esa.int/psa/bhempen/tree.html
> 
> In case it could be useful to see the whole log, please just tell me.
> 
> Now, to wrap things up again adding some new insights by testing with 
> different versions of the MapServer. This is what happened:
> 
> 
> When I try to use the WFS FE Spatial Filter Intersect with MapServer 
> 5.6.5 on a PostGIS layer, it doesn't work and I get an Error 500.
> When, however, I use a WFS FE Spatial Filter like Intersect with 
> MapServer 5.6.5 on a shapefile layer with the SAME data as 
> the PostGIS 
> layer contains, it works!
> When I try to use the WFS FE Spatial Filter BBOX with 
> MapServer 5.6.5 on 
> a PostGIS layer, it works!
> When I use a WFS FE non-spatial filter like PropertyIsEqualTo and/or 
> combined with logical filters like AND or OR combined with the WFS FE 
> Spatial Filter BBOX with MapServer 5.6.5 on a shapefile layer or a 
> PostGIS layer with the the SAME data, it works!
> When I try to use the WFS FE Spatial Filter Intersect with MapServer 
> 6.0.1 on a PostGIS layer, sometimes no results are returned and 
> sometimes only some. The results are not accurate.
> When I try to use the WFS FE Spatial Filter Intersect with MapServer 
> 6.0.1 on a shapefile layer, sometimes no results are returned and 
> sometimes only some. The results are not accurate.
> When I use a WFS FE non-spatial filter like PropertyIsEqualTo and/or 
> combined with logical filters like AND or OR combined with the WFS FE 
> Spatial Filter BBOX with MapServer 6.0.1 on a shapefile layer or a 
> PostGIS layer with the the SAME data, it seems to work, but I am not 
> 100% sure.
> 
> Therefore: No problem with Apache setup, mapfiles, data, 
> client/requests. Should be a MapServer bug...
> 
> Using the same PostGIS db and shapefile all the time and mapfiles 
> modified as minimal as possible.
> 
> Kind regards,
> Bryan
> 
> On 10/08/2011 15:16, Eichner, Andreas - SID-NLKM wrote:
> > Hi,
> >
> > HTTP error code 500 means: Internal Server error and is 
> usually reported when the (F)CGI process dies. Probably a 
> simple NULL pointer dereference due to a missing check which 
> results in a segmentation fault... Ever tried the thing with 
> shp2img? If this also segfaults try recompiling with debug 
> enabled and run it trough gdb.
> >
> > Greets.
> >
> >> -----Ursprüngliche Nachricht-
> >> Von: mapserver-users-boun...@lists.osgeo.org
> >> [mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag
> >> von Bryan Hempen
> >> Gesendet: Mittwoch, 10. August 2011 14:35
> >> An: Fawcett, David (MPCA)
> >> Cc: mapserver-users@lists.osgeo.org
> >> Betreff: Re: [mapserver-users] WFS Spatial Filter Problem
> >>
> >> Hi David,
> >>
> >> I enabled debugging using the following settings:
> >>
> >>  CONFIG "MS_ERRORFILE" "/home/bhempen/ms_error.txt"
> >>