Re: [mapserver-users] Finding (and modifying?) status codes of mapserver responses

[deduikertjes]

Thomas,

Thank you.
Interesting remark you make on the WMS-spec. Never thought of that.
You say that I can add a config option to return something other than 
200. I suppose by that you mean that such a config option does not 
exits, but that I can hack it in?


Can you please elaborate a bit on how non 200 status codes on service 
exception reports could break a client. No map is no map?


Marco


On 19-10-16 14:50, thomas bonfort wrote:

Marco,
It's the WMS spec itself that requires 200 response codes. You can 
hack the code or even add a configuration option to return something 
other than 200, but you'll risk breaking your clients. Also note that 
checking for specific text is not going to work all the time, as the 
client can request an "inimage" exception text, i.e. returned as 
pixels in a png image.


--
thomas

On Wed, Oct 19, 2016 at 9:03 AM deduikertjes <deduikert...@xs4all.nl 
<mailto:deduikert...@xs4all.nl>> wrote:


Finding and modifying status codes

I'd like to find out (and maybe modify) the HTML status codes
mapserver
attaches to a WMS service exception report.

I deploy mapserver behind Nginx with supervisord as a fastcgi
provider and
process manager. Nginx does caching of responses on getmap requests.

As I don't want Service Exception reports to be cached I've added a
directive to the Nginx config not to cache error documents containing
'serviceException'.
This is not working properly, I think because nginx only regards a
response
as an error when a non-200 status code is attached.

So I'm trying to find the status codes mapserver attaches to a
response.
If I do from command line mapserv7
QUERY_STRING="map=my.map=WMS=1.1.1=GetMap&(rest
of valid wms request)" I see the headers (and the png) when te
request leads
to a response containing a map.
If I do the same with a request that generates an service
exception report I
get back error messages instead of the response I see in my browser.

So, how to find out the headers of the response before it goes trough
supervisord an nginx?
Or does anyone know what status code the header contains?
And the million dollar question: can we stick a 500 status code
header on
the response if it's not there?

Any help greatly appreciated, MArco



--
View this message in context:

http://osgeo-org.1560.x6.nabble.com/Finding-and-modifying-status-codes-of-mapserver-responses-tp5291371.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
<mailto: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

[mapserver-users] Finding (and modifying?) status codes of mapserver responses

[deduikertjes]

Finding and modifying status codes

I'd like to find out (and maybe modify) the HTML status codes mapserver
attaches to a WMS service exception report.

I deploy mapserver behind Nginx with supervisord as a fastcgi provider and
process manager. Nginx does caching of responses on getmap requests.

As I don't want Service Exception reports to be cached I've added a
directive to the Nginx config not to cache error documents containing
'serviceException'.
This is not working properly, I think because nginx only regards a response
as an error when a non-200 status code is attached.

So I'm trying to find the status codes mapserver attaches to a response.
If I do from command line mapserv7
QUERY_STRING="map=my.map=WMS=1.1.1=GetMap&(rest
of valid wms request)" I see the headers (and the png) when te request leads
to a response containing a map.
If I do the same with a request that generates an service exception report I
get back error messages instead of the response I see in my browser.

So, how to find out the headers of the response before it goes trough
supervisord an nginx?
Or does anyone know what status code the header contains?
And the million dollar question: can we stick a 500 status code header on
the response if it's not there?

Any help greatly appreciated, MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Finding-and-modifying-status-codes-of-mapserver-responses-tp5291371.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [SOLVED] Re: Filtering NULL values from Postgis Layer in Mapserver 7

[deduikertjes]

Lime, Steve D (MNIT) wrote
>> It still would be very nice to have an option to ignore empty fields/
>> NULL
>> values/ missing values like - with a single config option. Shall I
>> file
>> a feature request for that?
> 
> How would such a feature be different than FILTER or the native_filter
> PROCESSING option? Just trying to understand what convenience we might be
> able to introduce. --Steve

Steve,

I see you point. With the FILTER or native_filter PROCESSING option and
careful management of the FILTER expression one can achieve a proper
filtering of missing values.

On the other hand it would be very convenient (imo) to have a setting on
LAYER level (or even one at MAP level which can be overridden on LAYER
level) like:
   MISSING_VALUE [string] 
where [string] then can be "EMPTY" "NULL" "-" or whatever.
The desired behaviour would then be that every expression where the
MISSING_VALUE appears is always evaluated as false.  

MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Filtering-NULL-values-from-Postgis-Layer-in-Mapserver-7-tp5280893p5281457.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] [SOLVED] Re: Filtering NULL values from Postgis Layer in Mapserver 7

[deduikertjes]

Steve, 

thank you


Lime, Steve D (MNIT) wrote
> The filter option is still there - it's just implemented as a processing
> option instead. So what was:
> 
>   FILTER 'myitem != NULL'
> 
> Becomes:
> 
>   PROCESSING 'NATIVE_FILTER=myitem != NULL'
>   
> Steve  

I can confirm that making the FILTER a PROCESSING option indeed works, even
with runtime substitution. (using = NULL does not work, IS NULL must be
used)

So the mapserver6 style line:
   FILTER (NOT (%MY_VAR1% IS NULL OR %MY_VAR2% IS NULL)) 
in mapserver 7 becomes:
   PROCESSING 'NATIVE_FILTER=(NOT (%MY_VAR1% IS NULL OR %MY_VAR2% IS NULL))'

So I summarize:
   - CLASS EXPRESSIONS will treat NULL values in numerical fields as zero
(and I presume it does the same for empty numeric fields in shapefiles). It
is not possible to prevent this behaviour.
   - To prevent NULL values from being rendered a FILTER must be applied, or
a subselect in the DATA statement must be used.
   - In mapserver 6 that can be a native filter with a syntax like FILTER
(NOT (%MY_VAR1% IS NULL OR %MY_VAR2% IS NULL)) 
   - In mapserver 7 that filter must be added as a processing option with a
syntax like PROCESSING 'NATIVE_FILTER=(NOT (%MY_VAR1% IS NULL OR %MY_VAR2%
IS NULL))'

It still would be very nice to have an option to ignore empty fields/ NULL
values/ missing values like - with a single config option. Shall I file
a feature request for that?

MArco




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Filtering-NULL-values-from-Postgis-Layer-in-Mapserver-7-tp5280893p5281145.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Filtering NULL values from Postgis Layer in Mapserver 7

[deduikertjes]

Andreas, 

Thank you. 

hmm, that's very interesting. Lets see if I understand correctly:

I observe that in the CLASS EXPRESSIONs in a Postgis layer NULL is treated
as zero for numeric fields. So NULL gets visualized in the class where zero
is visualized. In my opinion that is not very desirable. I actually would
expect a default behaviour where NULL values will not match any CLASS
EXPRESSION.

In Mapserver 6 we luckily had the FILTER option to filter out the NULL
values to remedy this behaviour. Not very elegant but very doable.

Now in Mapserver 7 we lost the FILTER option and have to write a subselect
in the DATA statement to get rid of NULL values. That seems to be a rather
complicated solution for something which seems to be a very common task.

Or am I missing something and is there a way to avoid that NULL values end
up as being treated as 0?

MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Filtering-NULL-values-from-Postgis-Layer-in-Mapserver-7-tp5280893p5281035.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Filtering NULL values from Postgis Layer in Mapserver 7

[deduikertjes]

Hi,

In mapserver 6 I use the following to filter out records containing NULL
values in a Postgis layer (I am using runtime substitution for MY_VAR1 and
MY_VAR2):

FILTER (NOT (%MY_VAR1% IS NULL OR %MY_VAR2% IS NULL)) 

This is working fine, but doesn't work in mapserver 7 anymore as documented
in  http://mapserver.org/MIGRATION_GUIDE.html#mapserver-6-4-to-7-0-migration
  
According to that page I have to write the FILTER statement in the MapServer
expression syntax.

So now I'm trying to do so but I am not winning. I cannot find a way to
properly detect NULL values using MapServer expression syntax. Is there any
way writing such a filter without using a PROCESSING 'NATIVE_FILTER='
construct?

Any help greatly appreciated, MArco




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Filtering-NULL-values-from-Postgis-Layer-in-Mapserver-7-tp5280893.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Rendering of Symbols outside map window

[deduikertjes]

My pull request (https://github.com/mapserver/mapserver/pull/5199) 
implements a gutter in WMS mode.


It is rather unobtrusive and straightforward. I am using it in 
production for quit some time now.
I could not find any side effects, but I did not try in combination with 
labeling or extremely large symbols.


Maybe a nice moment to review and/ or test by Patrick?

MArco

On 17-02-16 18:01, Lime, Steve D (MNIT) wrote:


My memory is lousy I guess. Expanding the search rect used based on 
style sizes and to account for the use case Thomas mentions seems 
logical to me (more efficient), that or a gutter (probably easier). 
Needs a small RFC IMHO as I’m sure there would be side effects.


In terms of what might be done immediately in Patrick’s case.

-I wonder if using CIRCLE shapes might work. A circle must be defined 
by a minimum bounding rectangle. That is, two points that define the 
smallest square that can contain it. These two points are the two 
opposite corners of said box. Since the which shapes function operates 
on bounding boxes it should identify any of the circles that intersect 
the map extent.


-Issues like this are also handled correctly with tiling (mapcache) if 
I’m not mistaken – and you can define a metatile gutter. Maybe that 
could be used. You could set up tiling and then make arbitrary WMS 
calls against mapcache if you had to, or even just use the tiles directly.


-Go the PostGIS route as suggested by Ambrogio…

Steve

*From:*deduikertjes [mailto:deduikert...@xs4all.nl]
*Sent:* Tuesday, February 16, 2016 1:44 AM
*To:* thomas bonfort <thomas.bonf...@gmail.com>; Lime, Steve D (MNIT) 
<steve.l...@state.mn.us>
*Cc:* Patrick Meis <m...@stadt-muenster.de>; 
mapserver-users@lists.osgeo.org

*Subject:* Re: [mapserver-users] Rendering of Symbols outside map window


>>>That's something we may want to fix.

If I remember correctly, Mapserver in  tile mode draws a slightly 
larger tile and crops that one (something configurable with GUTTER or 
so). I wrote my the code in my pull request along the same principle.
Adjusting the query extent when doing whichshapes() and account for 
the size of symbols when adjusting  the clipping rectangle once the 
feature is obtained might be more efficient?


But maybe this discussion shoud be done in mapserver-dev?

MArco

On 15-02-16 21:23, thomas bonfort wrote:

Steve,

IIRC, we account for the size of symbols when adjusting our
clipping rectangle once we have obtained a feature, but we do not
adjust the query extent when doing whichshapes(). That's something
we may want to fix.

Another use-case would also be when the DATA statement does
something like "ST_Buffer(the_geom,...) as the geom"

--

thomas

On 15 February 2016 at 17:44, Lime, Steve D (MNIT)
<steve.l...@state.mn.us <mailto:steve.l...@state.mn.us>> wrote:

I know. We use to account for that explicitly.



*From:*deduikertjes [deduikert...@xs4all.nl
<mailto:deduikert...@xs4all.nl>]
*Sent:* Monday, February 15, 2016 2:44 AM
*To:* Lime, Steve D (MNIT); Patrick Meis


*Cc:* mapserver-users@lists.osgeo.org
<mailto:mapserver-users@lists.osgeo.org>
*Subject:* Re: [mapserver-users] Rendering of Symbols outside
map window

Steve,

I think the key part in the question is here:

" and the center point of the symbol is no longer inside the
map window".

To my experience a symbol doesn't get drawn at all when the
point which is symbolized is outside the requested extent (WMS
mode at least).

To solve that I created the mentioned pull request.

Or do I miss something?

MArco


On 13-02-16 00:17, Lime, Steve D (MNIT) wrote:

This should already be happening. The drawing code
traverses a layer's class/styles to commute a selection
and clipping rectangle that is larger than the map extent.




*From:*mapserver-users
[mapserver-users-boun...@lists.osgeo.org
<mailto:mapserver-users-boun...@lists.osgeo.org>] on
behalf of mdprive [deduikert...@xs4all.nl
<mailto:deduikert...@xs4all.nl>]
*Sent:* Friday, February 12, 2016 4:15 PM
*To:* Patrick Meis
*Cc:* mapserver-users@lists.osgeo.org
<mailto:mapserver-users@lists.osgeo.org>
*Subject:* Re: [mapserver-users] Rendering of Symbols
outside map window

Hi Patrick,

i've submitted a pull request for extending the map by a
buffer and then clipping it, so that partial symbols on
the edge get rendered as we

Re: [mapserver-users] Rendering of Symbols outside map window

[deduikertjes]

>>>That's something we may want to fix.

If I remember correctly, Mapserver in  tile mode draws a slightly larger 
tile and crops that one (something configurable with GUTTER or so). I 
wrote my the code in my pull request along the same principle.
Adjusting the query extent when doing whichshapes() and account for the 
size of symbols when adjusting  the clipping rectangle once the feature 
is obtained might be more efficient?


But maybe this discussion shoud be done in mapserver-dev?

MArco

On 15-02-16 21:23, thomas bonfort wrote:

Steve,
IIRC, we account for the size of symbols when adjusting our clipping 
rectangle once we have obtained a feature, but we do not adjust the 
query extent when doing whichshapes(). That's something we may want to 
fix.
Another use-case would also be when the DATA statement does something 
like "ST_Buffer(the_geom,...) as the geom"


--
thomas

On 15 February 2016 at 17:44, Lime, Steve D (MNIT) 
<steve.l...@state.mn.us <mailto:steve.l...@state.mn.us>> wrote:


I know. We use to account for that explicitly.

----
*From:* deduikertjes [deduikert...@xs4all.nl
<mailto:deduikert...@xs4all.nl>]
*Sent:* Monday, February 15, 2016 2:44 AM
*To:* Lime, Steve D (MNIT); Patrick Meis

*Cc:* mapserver-users@lists.osgeo.org
<mailto:mapserver-users@lists.osgeo.org>
*Subject:* Re: [mapserver-users] Rendering of Symbols outside map
window

Steve,

I think the key part in the question is here:

" and the center point of the symbol is no longer inside the map
window".

To my experience a symbol doesn't get drawn at all when the point
which is symbolized is outside the requested extent (WMS mode at
least).

To solve that I created the mentioned pull request.

Or do I miss something?

MArco


On 13-02-16 00:17, Lime, Steve D (MNIT) wrote:

This should already be happening. The drawing code traverses a
layer's class/styles to commute a selection and clipping
rectangle that is larger than the map extent.


*From:* mapserver-users [mapserver-users-boun...@lists.osgeo.org
<mailto:mapserver-users-boun...@lists.osgeo.org>] on behalf of
mdprive [deduikert...@xs4all.nl <mailto:deduikert...@xs4all.nl>]
*Sent:* Friday, February 12, 2016 4:15 PM
*To:* Patrick Meis
*Cc:* mapserver-users@lists.osgeo.org
<mailto:mapserver-users@lists.osgeo.org>
*Subject:* Re: [mapserver-users] Rendering of Symbols outside map
window

Hi Patrick,

i've submitted a pull request for extending the map by a buffer
and then clipping it, so that partial symbols on the edge get
rendered as well (wms non tiled mode).

maybe you can build from sources and use this patch to solve your
problem.

marco

-- 



Op 11 feb. 2016 om 21:54 heeft Ambrogio Foletti
<afole...@gmail.com <mailto:afole...@gmail.com>> het volgende
geschreven:


Hello Patrick,

if you are using PostGIS as datasource, I would solve the
problem by integrating a st_buffer in the DATA element itself ;)
The added bonus is that you will get the attribute values from a
GetFeatureInfo (if implemented) in the whole buffer zone.
If not, you can try to use tile mode, and add some metabuffer
(see mapserver doc <http://mapserver.org/output/tile_mode.html>)

Cheers!
A. Foletti

2016-02-05 10:58 GMT+01:00 Patrick Meis <m...@stadt-muenster.de
<mailto:m...@stadt-muenster.de>>:

Hallo,

i have stumbled on a problem.

I am simulating a buffering of point-data with the help of
symbols, which I have set to

sizeunit = meters

size = 760

These rather big symbols disappear from my map when I zoom
in and

the center point of the symbol is no longer inside the map
window.

But a significant part of the symbol should still be displayed.

Is there any possibility of extending the rendered map, so
that the symbols of my points

are still rendered even when they are outside my map window?

Greetz

Patrick


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





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
<mailto: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] Rendering of Symbols outside map window

[deduikertjes]

Steve,

I think the key part in the question is here:

" and the center point of the symbol is no longer inside the map window".

To my experience a symbol doesn't get drawn at all when the point which 
is symbolized is outside the requested extent (WMS mode at least).


To solve that I created the mentioned pull request.

Or do I miss something?

MArco


On 13-02-16 00:17, Lime, Steve D (MNIT) wrote:
This should already be happening. The drawing code traverses a layer's 
class/styles to commute a selection and clipping rectangle that is 
larger than the map extent.



*From:* mapserver-users [mapserver-users-boun...@lists.osgeo.org] on 
behalf of mdprive [deduikert...@xs4all.nl]

*Sent:* Friday, February 12, 2016 4:15 PM
*To:* Patrick Meis
*Cc:* mapserver-users@lists.osgeo.org
*Subject:* Re: [mapserver-users] Rendering of Symbols outside map window

Hi Patrick,

i've submitted a pull request for extending the map by a buffer and 
then clipping it, so that partial symbols on the edge get rendered as 
well (wms non tiled mode).


maybe you can build from sources and use this patch to solve your problem.

marco

--


Op 11 feb. 2016 om 21:54 heeft Ambrogio Foletti > het volgende geschreven:



Hello Patrick,

if you are using PostGIS as datasource, I would solve the problem by 
integrating a st_buffer in the DATA element itself ;) The added bonus 
is that you will get the attribute values from a GetFeatureInfo (if 
implemented) in the whole buffer zone.
If not, you can try to use tile mode, and add some metabuffer (see 
mapserver doc )


Cheers!
A. Foletti

2016-02-05 10:58 GMT+01:00 Patrick Meis >:


Hallo,

i have stumbled on a problem.

I am simulating a buffering of point-data with the help of
symbols, which I have set to

sizeunit = meters

size = 760

These rather big symbols disappear from my map when I zoom in and

the center point of the symbol is no longer inside the map window.

But a significant part of the symbol should still be displayed.

Is there any possibility of extending the rendered map, so that
the symbols of my points

are still rendered even when they are outside my map window?

Greetz

Patrick


___
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] Is there a way to convert a QGIS layout into a .map file?

[deduikertjes]

Rahkonen Jukka (MML) wrote
 Hi,
 
 The SLD output of QGIS can be good but I am not so sure how good Mapserver
 is with importing SLD. That could be tested through WMS GetMap and SLD=
 or with SLD_BODY= but there is no tool for converting SLD into layer
 styles as text which could be saved and used in static mapfiles, or is
 there?
 
 -Jukka Rahkonen-

You can do this conversion by python-mapscript. The rt_mapserver_plugins
uses this technique.

By the way the SLD export contains a bug on negative values (all ready
reported by Maarten Tromp).



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Re-Is-there-a-way-to-convert-a-QGIS-layout-into-a-map-file-tp5194108p5194413.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Ok, with all the help I came to the following results:

Compile the current development version (6.5-dev) from GitHub  Install.
Results:

Simple Spatial WFS queries require a  non-empty 
ogc:PropertyName/ogc:PropertyName.
Setting it too ogc:PropertyNamefoo/ogc:PropertyName proved to be
sufficient.
Query speed is indeed very fast now.

Using WMS-dimensions as described on
http://mapserver.org/ogc/wms_dimension.html does work in 
6.4 but not in 6.5-dev. As I have need for them I recompiled mapserver
with a 
-DCMAKE_INSTALL_PREFIX=/usr/local/bin switch so I can run mapserver 6.4
en 6.5-dev next to each 
other. GetMap requests are routed to mapserver 6.4 and GetFeature
requests are routed to 6.5-dev.

Using the WMS-dimensons on 6.5-dev yields the following error:

ServiceExceptionReport version=1.1.1ServiceException
msDrawMap(): Image handling error. Failed to draw layer named 'jan2014_low'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: 
operator does not exist: = numeric
LINE 1: ...32.505600397 6790506.21879132))',900913) and  = 0.9...
 ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.
 
/ServiceException/ServiceExceptionReport

Its seems that the dimension parameter is not inserted in the layer filter
expression.
Should I create a bug report for this?

MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988p5171806.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Done, opened ticket: https://github.com/mapserver/mapserver/issues/5032


thomas bonfort wrote
 Yes Marco, Please open a ticket for this.
 
 thanks,
 thomas





--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988p5171815.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Steve,

Thank you for the suggestion. Mapserver 7 is an interesting option 
indeed. I cannot find a date when it is due. Do you have any knowledge 
of that?


I'm not looking forward to build mapserver from sources. I had not so 
good experiences with that in the past.
So I've been looking around in GitHub to find closed tickets which are 
related to the way the backend is queried or performance is improved.

I couldn't find any. Could you please point me to the relevant ticket(s)?

Thank you, MArco




On 03-11-14 19:06, Lime, Steve D (MNIT) wrote:

MapServer 7.0 should fix issues like this. A more general solution to the one 
presented in #4049 has been added to that version. You might try the 
development version and see how it goes.  I'm surprised simple queries aren't 
working well though since older versions of MapServer have optimizations 
specific to PostGIS for those simple cases.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of deduikertjes
Sent: Monday, November 03, 2014 9:56 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] WFS query slow on large postgis table (and small 
table disappointing as well)

Hi List,

I'm experiencing real slow performance when doing WFS queries on a postgis 
table with about 150 records.

A simple spatial query (which features in a box) takes about 1 to 2 minutes.
In postgis the same query takes less than a second. Same story for attribute 
queries.
Indeed on a postgis table with some 6 records things are still very very 
slow.

WMS on the other hand is flying taking less than a second for rendering most 
tiles.

By using the debug functions I see that mapserver fetches all features in the 
map extent (set at map level) and then starts filtering feature by feature 
which takes a long time.

I found ticket http://trac.osgeo.org/mapserver/ticket/4049 which seems to be 
related.

Is there any way to speed up this kind of WFS queries? Is there any progress on 
the ticket?

Any help appreciated, MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
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 query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Even,

Thank you.

Examples of slow and fast queries:

Slow queries (not very complex) like:

wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; service=WFS 
version=1.1.0 xsi:schemaLocation=http://www.opengis.net/wfs 
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
wfs:Query typeName=hb:jan2014_high srsName=EPSG:900913 
xmlns:hb=http://maps.md2.com/schemas/hb_wfs.xsd;

ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:Intersects
ogc:PropertyName/ogc:PropertyName
gml:Polygon xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:900913
gml:exterior
gml:LinearRing
gml:posList493014.59839229 6795936.8942158 493014.59839229 
6796022.885872601 493102.97870623 6796022.885872601 493102.97870623 
6795936.8942158 493014.59839229 6795936.8942158/gml:posList

/gml:LinearRing
/gml:exterior
/gml:Polygon
/ogc:Intersects
/ogc:Filter
/wfs:Query
/wfs:GetFeature

fast queries (only with small bbox) like:

wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; service=WFS 
version=1.1.0 xsi:schemaLocation=http://www.opengis.net/wfs 
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd 
http://maps.md2.com/schemas/hb_wfs.xsd 
http://x/maps//rc1/services/basic/default.map?service=WFSversion=1.1.0request=DescribeFeatureTypetypeName=jan2014_high; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;

wfs:Query typeName=feature:jan2014_high srsName=EPSG:900913
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:And
ogc:BBOX
ogc:PropertyNamemsGeometry/ogc:PropertyName
gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:900913
gml:lowerCorner491667.6470239 6795223.3576443/gml:lowerCorner
gml:upperCorner494192.4576141 6796212.2616977/gml:upperCorner
/gml:Envelope
/ogc:BBOX
ogc:PropertyIsLessThan
ogc:PropertyNamevalue/ogc:PropertyName
ogc:Literal0/ogc:Literal
/ogc:PropertyIsLessThan
/ogc:And
/ogc:Filter
/wfs:Query
/wfs:GetFeature

Marco
On 04-11-14 10:41, Even Rouault wrote:

Le lundi 03 novembre 2014 16:56:12, vous avez écrit :

Hi List,

I'm experiencing real slow performance when doing WFS queries on a postgis
table with about 150 records.

A simple spatial query (which features in a box) takes about 1 to 2
minutes. In postgis the same query takes less than a second. Same story
for attribute queries.
Indeed on a postgis table with some 6 records things are still very
very slow.

WMS on the other hand is flying taking less than a second for rendering
most tiles.

By using the debug functions I see that mapserver fetches all features in
the map extent (set at map level) and then starts filtering feature by
feature which takes a long time.

I found ticket http://trac.osgeo.org/mapserver/ticket/4049 which seems to
be related.

Is there any way to speed up this kind of WFS queries? Is there any
progress on the ticket?

Can you show the exact WFS request you send to mapserver and that is slow to
run ? BBOX requests should use postgis spatial filtering. Perhaps you use
something more complex ?


Any help appreciated, MArco



--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-
and-small-table-disappointing-as-well-tp5170988.html Sent from the
Mapserver - User mailing list archive at Nabble.com.
___
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 query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Hi Steve, List,

Hmm, I compiled mapserver from sources (GitHub Master). Actually that 
was not that bad, all tough I did not find out how to run the mapserver 
from ubuntu packages next to the one I compiled myself.


The new mapserver is working ... a bit.
The new mapserver doesn't support custom dimensions (yet ?) which I do 
use. So, for now I've removed that from the client side requests and 
getmap requests are fine .


Then do a simple query like:

   wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; service=WFS
   version=1.1.0 xsi:schemaLocation=http://www.opengis.net/wfs
   http://schemas.opengis.net/wfs/1.1.0/wfs.xsd;
   xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
wfs:Query typeName=hb:jan2014_high srsName=EPSG:900913
   xmlns:hb=http://maps.md2.com/schemas/hb_wfs.xsd;
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:Intersects
   ogc:PropertyName/ogc:PropertyName
   gml:Polygon
   xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:900913
gml:exterior
gml:LinearRing
gml:posList493014.59839229
   6795936.8942158 493014.59839229 6796022.885872601 493102.97870623
   6796022.885872601 493102.97870623
   6795936.8942158 493014.59839229 6795936.8942158/gml:posList
/gml:LinearRing
/gml:exterior
/gml:Polygon
/ogc:Intersects
/ogc:Filter
   /wfs:Query
   /wfs:GetFeature


Resulting in an error:
msWFSGetFeature(): WFS server error. Invalid or Unsupported FILTER in 
GetFeature : Filter ogc=http://www.opengis.net/ogc; Intersects 
PropertyName / Polygon gml=http://www.opengis.net/gml; 
srsName=EPSG:900913 exterior LinearRing posList492858.14135005 
6795805.518073499 492858.14135005 6796116.0435008 493197.33066301 
6796116.0435008 493197.33066301 6795805.518073499 492858.14135005 
6795805.518073499/posList /LinearRing /exterior /Polygon 
/Intersects /Filter
(Mapserver 6.4 accepts this query and returns a result (albeit taking 
long)).


A simple query like this works:
wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; service=WFS 
version=1.1.0 xsi:schemaLocation=http://www.opengis.net/wfs 
http://schemas.opengis.net/wfs/1.1.0/wfs.xsd 
http://maps.md2.com/schemas/hb_wfs.xsd 
http://x/maps//rc1/services/basic/default.map?service=WFSversion=1.1.0request=DescribeFeatureTypetypeName=jan2014_high; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;

wfs:Query typeName=feature:jan2014_high srsName=EPSG:900913
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:And
ogc:BBOX
ogc:PropertyNamemsGeometry/ogc:PropertyName
gml:Envelope xmlns:gml=http://www.opengis.net/gml; srsName=EPSG:900913
gml:lowerCorner491667.6470239 6795223.3576443/gml:lowerCorner
gml:upperCorner494192.4576141 6796212.2616977/gml:upperCorner
/gml:Envelope
/ogc:BBOX
ogc:PropertyIsLessThan
ogc:PropertyNamevalue/ogc:PropertyName
ogc:Literal0/ogc:Literal
/ogc:PropertyIsLessThan
/ogc:And
/ogc:Filter
/wfs:Query
/wfs:GetFeature

but that one was already reasonably fast.

Any pointers very much appreciated.

MArco



On 03-11-14 19:06, Lime, Steve D (MNIT) wrote:

MapServer 7.0 should fix issues like this. A more general solution to the one 
presented in #4049 has been added to that version. You might try the 
development version and see how it goes.  I'm surprised simple queries aren't 
working well though since older versions of MapServer have optimizations 
specific to PostGIS for those simple cases.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of deduikertjes
Sent: Monday, November 03, 2014 9:56 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] WFS query slow on large postgis table (and small 
table disappointing as well)

Hi List,

I'm experiencing real slow performance when doing WFS queries on a postgis 
table with about 150 records.

A simple spatial query (which features in a box) takes about 1 to 2 minutes.
In postgis the same query takes less than a second. Same story for attribute 
queries.
Indeed on a postgis table with some 6 records things are still very very 
slow.

WMS on the other hand is flying taking less than a second for rendering most 
tiles.

By using the debug functions I see that mapserver fetches all features in the 
map extent (set at map level) and then starts filtering feature by feature 
which takes a long time.

I found ticket http://trac.osgeo.org/mapserver/ticket/4049 which seems to be 
related.

Is there any way to speed up this kind of WFS queries? Is there any progress on 
the ticket?

Any help appreciated, MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988.html
Sent from

Re: [mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Even,

I use functionality as described on: 
http://mapserver.org/ogc/wms_dimension.html
I referred to it by 'custom dimensions' to distinguish from wms time and 
elevation dimensions.


MArco



On 04-11-14 20:55, Even Rouault wrote:

Le mardi 04 novembre 2014 20:39:51, mdprive a écrit :

Even,

Thank you. i'll try to convince my geoext viewer to set a non empty
PropertyName. Up till now that proves to be not so easy.

Any hints on the custom dimensions?

I'm not sure what you mean with custom dimensions



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

[mapserver-users] WFS query slow on large postgis table (and small table disappointing as well)

[deduikertjes]

Hi List,

I'm experiencing real slow performance when doing WFS queries on a postgis
table with about 150 records.

A simple spatial query (which features in a box) takes about 1 to 2 minutes.
In postgis the same query takes less than a second. Same story for attribute
queries.
Indeed on a postgis table with some 6 records things are still very very
slow.

WMS on the other hand is flying taking less than a second for rendering most
tiles.

By using the debug functions I see that mapserver fetches all features in
the map extent (set at map level) and then starts filtering feature by
feature which takes a long time.

I found ticket http://trac.osgeo.org/mapserver/ticket/4049 which seems to be
related.

Is there any way to speed up this kind of WFS queries? Is there any progress
on the ticket?

Any help appreciated, MArco



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-query-slow-on-large-postgis-table-and-small-table-disappointing-as-well-tp5170988.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Fwd: Re: [MapProxy] more opacity questions

[DeDuikertjes]

Oliver,

Thank you. This is very informative.
Indeed the layer has transparency and areas that have to be semi 
transparent on blending.


Does this limitation of PIL mean that if the source wms serves images 
with transparency AND semi transparent features (and Mapproxy config 
does NOT have any transparency settings) the result of a multi-layer 
request will have these problems?


Can these PIL problems be mitigated by having the source WMS serve 
images on a white background and set mapproxy transparency color to white?


Marco
Op 8-1-2012 13:35, Oliver Tonnhofer schreef:

Hi Marco,

On 07.01.2012, at 20:27, DeDuikertjes wrote:

Here you can find some example images in different shades of black-opaque:

http://178.63.74.185/hosting/demo/demo1.png
http://178.63.74.185/hosting/demo/demo2.png
http://178.63.74.185/hosting/demo/demo3.png

So you have a layer that already has transparency and you want the filled areas 
to be semi-transparent. The image blending function of PIL does not support the 
alpha channel. The transparent areas in your image are blended over with your 
opacity value, but even if these areas are transparent they still have color 
value, and in your case they are either black or white.

It should be possible to work around that with some image processing during the 
blending, but that would require more than just a single line patch…


Regards,
Oliver


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

[mapserver-users] Re: having trouble with label size

[deduikertjes]

Hi,

I've solved similar problems by setting a SYMBOLSCALE at the layer level as
described in
http://osgeo-org.1803224.n2.nabble.com/fixed-label-size-in-map-units-tp4903182p4903182.html

succes, MArco
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/having-trouble-with-label-size-tp4939619p4941199.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: mapserver as a tiling client for an untiled WMS

[deduikertjes]

So I've tried for real.

First I created a WMS to act as the untiled WMS which I wanted to access.
Then I created a mapfile which consumes this WMS, and a client to view the
results. Everything OK. The client shows the map as it should be.

The layer defintion to consume the WMS:
LAYER
  NAME my_untiled_WMS
  TYPE RASTER
  STATUS off
  
  CONNECTIONTYPE WMS
  CONNECTION http://my_untiled_WMS_url;

  METADATA
wms_srs EPSG:28992
wms_namemy_root_layer
wms_server_version  1.1.1
wms_format  image/png
wms_exceptions_format  application/vnd.ogc.se_xml

  END
  DEBUG 5
END

Then I replaced this LAYER definition by things like:
LAYER
  NAME my_untiled_WMS
  DEBUG 5
  PROJECTION
   init=epsg:28992
  END
  
  TYPE RASTER
  STATUS off
  
  
  DATA /var/www/html/tmp/test.xml
  EXTENT 102790.553 430082.85 182959.978 487853.15
  OFFSITE 0 0 0
METADATA
   wms_title my_root_layer
   wms_extent102790.553 430082.85 182959.978 487853.15
   wms_srs EPSG:28992
   wms_server_version  1.1.1
   wms_format  image/png
   wms_exceptions_format  application/vnd.ogc.se_xml
END
PROCESSING CLOSE_CONNECTION=DEFER
END 

Test XML being things like:
GDAL_WMS
   Service name=WMS
   Version1.1.1/Version
  ServerUrlhttp://my_untiled_WMS_url/ServerUrl
 SRSEPSG:28992/SRS
 Layersmy_root_layer/Layers
 Stylesdefault/Styles
 ImageFormatimage/png/ImageFormat
 /Service
 DataWindow
 UpperLeftX10528/UpperLeftX!--minx from the
capabilities of my_untiled_wms  --
 UpperLeftY621876/UpperLeftY  !--maxy from the capabilities
of my_untiled_wms  --
 LowerRightX278026/LowerRightX   !--maxx from the capabilities
of my_untiled_wms  --
 LowerRightY306839/LowerRightY   !--miny from the capabilities
of my_untiled_wms  --
 SizeX1000/SizeX!-- This is the
size limit of my_untiled_wms  --
 SizeY1000/SizeY!-- This is the
size limit of my_untiled_wms  --
 /DataWindow
 ProjectionEPSG:28992/Projection
 BlockSizeX1000/BlockSizeX  !-- not sure, need not set,
or set to 1000? --
 BlockSizeY1000/BlockSizeY  !-- not sure, need not set,
or set to 1000? --
 BandsCount3/BandsCount
   AdviseReadtrue/AdviseRead
   VerifyAdviseReadtrue/VerifyAdviseRead
/GDAL_WMS


I tweaked a lot of the parameters but whatever I do I only get pink tiles
(no images). So I checked the error logs (debug 5). No errors at all. The
error log of the untiled WMS (http://my_untiled_WMS_url) shows that this WMS
never gets accessed.

So I wonder, is this minidriver working at all? Is it testable or
debug-able? How should I proceed. I'm really at loss.

Any help greatly appreciated.
-- 
View this message in context: 
http://n2.nabble.com/mapserver-as-a-tiling-client-for-an-untiled-WMS-tp4917136p4938381.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: mapserver as a tiling client for an untiled WMS

[deduikertjes]

Ok, thank you. Lets try if I understand the format correctly: 

see edits en comments. Will this work in this way?

Thanks for the help, MArco

 GDAL_WMS
   Service name=WMS
   Version1.1.1/Version
 
 ServerUrlhttp://myurl.nl/my_untiled_wms?transparent=true;/ServerUrl
 SRSEPSG:28992/SRS
 Layersmy_root_layer/Layers
 Stylesdefault/Styles
 ImageFormatimage/png/ImageFormat
 /Service
 DataWindow
 UpperLeftX10528/UpperLeftX!--minx from the
 capabilities of my_untiled_wms  --
 UpperLeftY621876/UpperLeftY  !--maxy from the
 capabilities of my_untiled_wms  --
 LowerRightX278026/LowerRightX   !--maxx from the
 capabilities of my_untiled_wms  --
 LowerRightY306839/LowerRightY   !--miny from the
 capabilities of my_untiled_wms  --
 SizeX1000/SizeX!-- This is the
size limit of my_untiled_wms  --
 SizeY1000/SizeX!-- This is the
size limit of my_untiled_wms  --
 !-- TileLevel19/TileLevelThis one is for tiled
 image sources only --
 !-- TileCountX2/TileCountXThis one is for tiled
 image sources only --
 !-- TileCountY1/TileCountYThis one is for tiled
 image sources only --
 /DataWindow
 ProjectionEPSG:28992/Projection
 BlockSizeX1024/BlockSizeX  !-- not sure, need not
 set, or set to 1000? --
 BlockSizeY1024/BlockSizeY  !-- not sure, need not
 set, or set to 1000? --
 BandsCount3/BandsCount
  Cache
 Path/htdocs/orm/gdalwmscache/Path
 Depth2/Depth
 Extension.png/Extension
  /Cache
   AdviseReadtrue/AdviseRead
   VerifyAdviseReadtrue/VerifyAdviseRead
 /GDAL_WMS 
-- 
View this message in context: 
http://n2.nabble.com/mapserver-as-a-tiling-client-for-an-untiled-WMS-tp4917136p4931375.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver as a tiling client for an untiled WMS

[DeDuikertjes]

Michael,

Thank you.

Do I understand correctly that this GDAL WMS Minidriver with this xml 
file for a given map area (bounding box) will do a series of normal 
WMS requests (as opposed to tiled WMS requests) to the server to 
obtain a set of tiles which will be stitched together and incorporated 
in the map?


MArco


Smith, Michael ERDC-CRREL-NH schreef:

Marco,

To use the GDAL WMS Minidriver, create an XML file like below and then
reference that xml file in your MapServer layer. For more info about the
format of the WMS xml, see here http://www.gdal.org/frmt_wms.html

Example xml
---

GDAL_WMS
  Service name=WMS
  Version1.1.1/Version
 ServerUrlhttp://hazards.fema.gov/wmsconnector/wmsconnector/com.esri.wms.E
srimap/NFHL?transparent=true/ServerUrl
SRSEPSG:4326/SRS
LayersFlood_Hazard_Zones_General/Layers
Stylesdefault/Styles
ImageFormatimage/gif/ImageFormat
/Service
DataWindow
UpperLeftX-180.0/UpperLeftX
UpperLeftY90.0/UpperLeftY
LowerRightX180.0/LowerRightX
LowerRightY-90.0/LowerRightY
TileLevel19/TileLevel
TileCountX2/TileCountX
TileCountY1/TileCountY
/DataWindow
ProjectionEPSG:4326/Projection
BlockSizeX1024/BlockSizeX
BlockSizeY1024/BlockSizeY
BandsCount3/BandsCount
 Cache
Path/htdocs/orm/gdalwmscache/Path

Depth2/Depth
Extension.gif/Extension
 /Cache
  AdviseReadtrue/AdviseRead
  VerifyAdviseReadtrue/VerifyAdviseRead
/GDAL_WMS



Mapfile section
---

LAYER
  NAME femaq3
  DATA /data/fema/fema_gen_wms.xml
  OFFSITE 255 255 255
  TYPE raster
  STATUS off
  PROJECTION
proj=latlong
ellps=GRS80
  END
  CLASS
  NAME 100 year floodplain
  SYMBOL 0
COLOR 255 0 0
  END
  CLASS
  NAME 500 year floodplain
  SYMBOL 0
COLOR 255 192 203
  END
END


  

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

[mapserver-users] mapserver as a tiling client for an untiled WMS

[DeDuikertjes]

Dear List,

In my mapserver maps (served as a WMS) I'd like to add a layer from an 
untiled WMS (not under my control).
Simple enough, but this WMS restricts the returned images to a maximum 
number of pixels, and also restricts the scale (only scales larger than 
a certain scale is allowed). The maps I'd like to make of course exceeds 
the limit of pixels.


The solution seems simple enough: chop up the request in a series off 
requests, and stich the returned images together. So basically this is a 
tiling approach. To complicate things a bit, the service is not 
spherical mercator.


I guess I have to use the GDAL-WMS minidriver and/ or TileCache, but 
I've not a clue to how to proceed. Can anyone please point me to some 
usefull examples or give me a short explanation to work from?


any help again greatly appreciated ...

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

[mapserver-users] [SOLVED] More upgrade problems

[DeDuikertjes]

Daniel,

Thank You !
It is the mapfile indeed. The LABEL block stated UTF8.
Changing that to UTF-8 solved the problem.

MArco

Daniel Morissette schreef:
div class=moz-text-flowed style=font-family: 
-moz-fixedDeDuikertjes wrote:


postgis tells me the database ppa_test_database is encoded in UTF8 
and not UTF-8.


So apparently postgis wants to state UTF8 and iconv wants to hear UTF-8.

Is there any way around this?



I don't think MapServer reads the encoding value from PostGIS, it gets 
it from the ENCODING parameter in your LABEL block in your mapfile.


Make sure the ENCODING value in your mapfile are all valid (one of 
them must be using UTF8 instead of UTF-8).


Daniel

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

[mapserver-users] More upgrade problems

[DeDuikertjes]

Dear List,

After the SLD problems occuring when I upgraded from mapserver 5.1-dev 
to 5.6.0 I upgraded form 5.1-dev to 5.4.2.


Everything seemed allright, but after all I ran into a new problem. 
Labels don't work anymore (Yes, I double checked by going back to 5.1-dev).

So I enabled the debugging (level 5) and looked into the error file.

It gives me a LOT of errors like:
[Thu Mar  4 15:14:05 2010].903727 msGetEncodedString(): Unknown 
identifier. Encoding not supported by libiconv (UTF8).


Searching and reading up on this I couldn't find a reason why things 
work in 5.1-dev and work not in 5.4.2.


As ever, any help greatly appreciated!

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

Re: Re: [mapserver-users] More upgrade problems

[DeDuikertjes]

Daniel,

Thank you for your answer.
iconv -l tells me UTF-8 is supported.

My data comes from postgis.
If I look in the postgis database it tells me it's encoded in UTF8.

If I make a database with:
CREATE DATABASE ppa_test_database
 WITH OWNER = x
  ENCODING = 'UTF-8'
  CONNECTION LIMIT = -1;

postgis tells me the database ppa_test_database is encoded in UTF8 and 
not UTF-8.


So apparently postgis wants to state UTF8 and iconv wants to hear UTF-8.

Is there any way around this?

MArco


Daniel Morissette schreef:
div class=moz-text-flowed style=font-family: 
-moz-fixedDeDuikertjes wrote:


It gives me a LOT of errors like:
[Thu Mar  4 15:14:05 2010].903727 msGetEncodedString(): Unknown 
identifier. Encoding not supported by libiconv (UTF8).


Searching and reading up on this I couldn't find a reason why things 
work in 5.1-dev and work not in 5.4.2.




Maybe the difference is caused by a different version of iconv being 
used by the new build?


Anyway, the error message says encoding UTF8 not supported. I 
believe the identifier should be UTF-8 and not UTF8.


FYI, iconv -l can be used at the command-line to list the encodings 
supported by your version of libiconv.


Daniel

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

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Hi,

I would love to, but mapserver makes these expressions from the SLD, not me.

MArco

Yves Jacolin schreef:

Hi,

I guees this is this part which run an error:
error. Failed to parse expression: NL.IMRO.0184.BA127909736-00 = 
NL.IMRO.0184.EP127818521-00


Try to change :
 EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
in :
 EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)

Regards,

Y.
Le mercredi 03 mars 2010 09:01:04, Bart van den Eijnden a écrit :
  

It seems Mapserver does not treat your column as a character column, try
using the following METADATA on your source layer (so not in the temporary
MAP file):

gml_geoidn_type Character

Best regards,
Bart

On Mar 3, 2010, at 8:52 AM, DeDuikertjes wrote:


Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. A layer
definition from this file is (there are a LOT more like that):

LAYER
  CONNECTION host=xxx user=x dbname=xxx
  CONNECTIONTYPE POSTGIS
  DATA 'tc_punt_geometry from NL.IMRO.0184.Zeewijkfase4-0201_aggregated
using unique oid using srid=28992' DUMP TRUE
  GROUP query
  METADATA
wms_srs EPSG:28992 EPSG:900913 EPSG:4326
ows_feature_id  geoidn
ows_group_title query
ows_extent  170861.5122 520007.0618 171570.1698 520546.6582
gml_exclude_items  
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry

ows_title   query_punt
gml_include_items   all
ows_exclude_items   all
  END
  NAME query_punt
  PROCESSING CLOSE_CONNECTION=DEFER
  PROJECTION
init=epsg:28992
  END
  STATUS ON
  TEMPLATE query.html
  TYPE POLYGON
  UNITS METERS
  CLASS
NAME Unknown
EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
STYLE
  ANGLE 360
  COLOR 255 0 255
  OPACITY 40
  SIZE 2
  SYMBOL sld_line_symbol
  WIDTH 1
END
STYLE
  ANGLE 360
  COLOR 255 0 255
  OPACITY 40
  SYMBOL 0
  WIDTH 1
END
STYLE
  ANGLE 360
  OPACITY 40
  OUTLINECOLOR 255 0 255
  SIZE 2
  SYMBOL sld_line_symbol
  WIDTH 1
END
  END
END

MArco

Bart van den Eijnden schreef:
  

Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and check if
something is wrong in there, or post the LAYER definition to the 
mailing list.




/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_chec
k/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map
  

Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:


Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after SLD was
applied
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_chec
k/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed Mar  3 08:21:29
2010].731599 msyyparse(): Expression parser error. syntax error [Wed
Mar  3 08:21:29 2010].731628 msEvalExpression: Expression parser error.
Failed to parse expression: NL.IMRO.0184.BA127909736-00 =
NL.IMRO.0184.EP127818521-00 [Wed Mar  3 08:21:29 2010].731649
msyyparse(): Expression parser error. syntax error And a lot more of
these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 (query_vlak),
0.029s [Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1
(query_lijn), 0.002s [Wed Mar  3 08:21:29 2010].749832 msDrawMap():
Layer 2 (query_punt), 0.003s [Wed Mar  3 08:21:29 2010].750760
msDrawMap(): Drawing Label Cache, 0.000s [Wed Mar  3 08:21:29
2010].750771 msDrawMap() total time: 0.046s [Wed Mar  3 08:21:29
2010].999507 msSaveImage() total time: 0.249s [Wed Mar  3 08:21:29
2010].999706 mapserv request processing time (msLoadMap not incl.):
0.336s [Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at
0x81bf400.

What is going wrong?

MArco

Yewondwossen Assefa schreef:
  

Hi There,

One way to debug would be to set your map file in debug, something
like this: CONFIG  MS_ERRORFILE
f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the sld has
been applied. That might give a  hint on what went wrong.

best regards,

DeDuikertjes wrote:


Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0
(FGS). I use it as a WMS. Everything looks fine, but I've one anoying
problem:

When I do a getmap-request with an SLD I get an empty image back,
while 5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv executable
with the new one.

an example of a getmap request which fails on 5.6.0 and succeeds in
5.1-dev is:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/
data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-02
01.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMa
pSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSLD_BODY=%3C%3Fx
ml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3Csld

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Bart,

I've tried to do so, no difference in either error file or temporary 
mapfile expressions


MArco

Bart van den Eijnden schreef:

It seems Mapserver does not treat your column as a character column, try using 
the following METADATA on your source layer (so not in the temporary MAP file):

gml_geoidn_type Character

Best regards,
Bart

On Mar 3, 2010, at 8:52 AM, DeDuikertjes wrote:

  

Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. A layer 
definition from this file is (there are a LOT more like that):

LAYER
  CONNECTION host=xxx user=x dbname=xxx
  CONNECTIONTYPE POSTGIS
  DATA 'tc_punt_geometry from NL.IMRO.0184.Zeewijkfase4-0201_aggregated using 
unique oid using srid=28992'
  DUMP TRUE
  GROUP query
  METADATA
wms_srs EPSG:28992 EPSG:900913 EPSG:4326
ows_feature_id  geoidn
ows_group_title query
ows_extent  170861.5122 520007.0618 171570.1698 520546.6582
gml_exclude_items   
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry
ows_title   query_punt
gml_include_items   all
ows_exclude_items   all
  END
  NAME query_punt
  PROCESSING CLOSE_CONNECTION=DEFER
  PROJECTION
init=epsg:28992
  END
  STATUS ON
  TEMPLATE query.html
  TYPE POLYGON
  UNITS METERS
  CLASS
NAME Unknown
EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
STYLE
  ANGLE 360
  COLOR 255 0 255
  OPACITY 40
  SIZE 2
  SYMBOL sld_line_symbol
  WIDTH 1
END
STYLE
  ANGLE 360
  COLOR 255 0 255
  OPACITY 40
  SYMBOL 0
  WIDTH 1
END
STYLE
  ANGLE 360
  OPACITY 40
  OUTLINECOLOR 255 0 255
  SIZE 2
  SYMBOL sld_line_symbol
  WIDTH 1
END
  END
END

MArco



Bart van den Eijnden schreef:


Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and check if 
something is wrong in there, or post the LAYER definition to the  mailing list.

 
  

/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map
   


Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:

 
  

Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after SLD was applied 
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed
 Mar  3 08:21:29 2010].731599 msyyparse(): Expression parser error. syntax error
[Wed Mar  3 08:21:29 2010].731628 msEvalExpression: Expression parser error. 
Failed to parse expression: NL.IMRO.0184.BA127909736-00 = 
NL.IMRO.0184.EP127818521-00
[Wed Mar  3 08:21:29 2010].731649 msyyparse(): Expression parser error. syntax 
error
And a lot more of these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 (query_vlak), 0.029s
[Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1 (query_lijn), 0.002s
[Wed Mar  3 08:21:29 2010].749832 msDrawMap(): Layer 2 (query_punt), 0.003s
[Wed Mar  3 08:21:29 2010].750760 msDrawMap(): Drawing Label Cache, 0.000s
[Wed Mar  3 08:21:29 2010].750771 msDrawMap() total time: 0.046s
[Wed Mar  3 08:21:29 2010].999507 msSaveImage() total time: 0.249s
[Wed Mar  3 08:21:29 2010].999706 mapserv request processing time (msLoadMap 
not incl.): 0.336s
[Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at 0x81bf400.

What is going wrong?

MArco


Yewondwossen Assefa schreef:
   


Hi There,

One way to debug would be to set your map file in debug, something like this:
CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the sld has been 
applied. That might give a  hint on what went wrong.

best regards,

DeDuikertjes wrote:
 
  

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying problem:

When I do a getmap-request with an SLD I get an empty image back, while
5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv executable with
the new one.

an example of a getmap request which fails on 5.6.0 and succeeds in
5.1-dev is:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-0201.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSLD_BODY=%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3Csld%3AStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3Csld%3ANamedLayer%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AUserStyle%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AFeatureTypeStyle%3E%3Csld%3ARule%3E%3Cogc%3AFilter%3E%3Cogc%3APropertyIsEqualTo%3E%3Cogc%3APropertyName%3Egeoidn%3C%2Fogc%3APropertyName%3E

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Bart,

The ticket refers to WFS OCG filter rgex tests for numeric values.
So, it seems to extend to WMS as well (need to expand the ticket ?).

Does this mean that I have te wait for this to be fixed, and then 
packaged in FGS?

(mapserver compilation is something I cannot do).

Now to check that I understand well:
The expression which is generated on the basis of the SLD should not read:

EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)

but should read:

EXPRESSION ([geoidn] == NL.IMRO.0184.EP127818521-00)

Note the two sets of double quotes and the second = 



MArco



Bart van den Eijnden schreef:

Then I fear you have run into (like myself):

http://trac.osgeo.org/mapserver/ticket/3289

Assefa can confirm this. Btw the fix was only done in trunk, should it not be 
done in the 5.6 branch as well?

Best regards,
Bart

On Mar 3, 2010, at 9:41 AM, DeDuikertjes wrote:

  

Bart,

I've tried to do so, no difference in either error file or temporary mapfile 
expressions

MArco

Bart van den Eijnden schreef:


It seems Mapserver does not treat your column as a character column, try using 
the following METADATA on your source layer (so not in the temporary MAP file):

gml_geoidn_type Character

Best regards,
Bart

On Mar 3, 2010, at 8:52 AM, DeDuikertjes wrote:

 
  

Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. A layer 
definition from this file is (there are a LOT more like that):

LAYER
 CONNECTION host=xxx user=x dbname=xxx
 CONNECTIONTYPE POSTGIS
 DATA 'tc_punt_geometry from NL.IMRO.0184.Zeewijkfase4-0201_aggregated using 
unique oid using srid=28992'
 DUMP TRUE
 GROUP query
 METADATA
   wms_srs EPSG:28992 EPSG:900913 EPSG:4326
   ows_feature_id  geoidn
   ows_group_title query
   ows_extent  170861.5122 520007.0618 171570.1698 520546.6582
   gml_exclude_items   
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry
   ows_title   query_punt
   gml_include_items   all
   ows_exclude_items   all
 END
 NAME query_punt
 PROCESSING CLOSE_CONNECTION=DEFER
 PROJECTION
   init=epsg:28992
 END
 STATUS ON
 TEMPLATE query.html
 TYPE POLYGON
 UNITS METERS
 CLASS
   NAME Unknown
   EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
   STYLE
 ANGLE 360
 COLOR 255 0 255
 OPACITY 40
 SIZE 2
 SYMBOL sld_line_symbol
 WIDTH 1
   END
   STYLE
 ANGLE 360
 COLOR 255 0 255
 OPACITY 40
 SYMBOL 0
 WIDTH 1
   END
   STYLE
 ANGLE 360
 OPACITY 40
 OUTLINECOLOR 255 0 255
 SIZE 2
 SYMBOL sld_line_symbol
 WIDTH 1
   END
 END
END

MArco



Bart van den Eijnden schreef:
   


Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and check if 
something is wrong in there, or post the LAYER definition to the  mailing list.

  
  

/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map
  


Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:

  
  

Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after SLD was applied 
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed
 Mar  3 08:21:29 2010].731599 msyyparse(): Expression parser error. syntax error
[Wed Mar  3 08:21:29 2010].731628 msEvalExpression: Expression parser error. 
Failed to parse expression: NL.IMRO.0184.BA127909736-00 = 
NL.IMRO.0184.EP127818521-00
[Wed Mar  3 08:21:29 2010].731649 msyyparse(): Expression parser error. syntax 
error
And a lot more of these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 (query_vlak), 0.029s
[Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1 (query_lijn), 0.002s
[Wed Mar  3 08:21:29 2010].749832 msDrawMap(): Layer 2 (query_punt), 0.003s
[Wed Mar  3 08:21:29 2010].750760 msDrawMap(): Drawing Label Cache, 0.000s
[Wed Mar  3 08:21:29 2010].750771 msDrawMap() total time: 0.046s
[Wed Mar  3 08:21:29 2010].999507 msSaveImage() total time: 0.249s
[Wed Mar  3 08:21:29 2010].999706 mapserv request processing time (msLoadMap 
not incl.): 0.336s
[Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at 0x81bf400.

What is going wrong?

MArco


Yewondwossen Assefa schreef:
  


Hi There,

One way to debug would be to set your map file in debug, something like this:
CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the sld has been 
applied. That might give a  hint on what went wrong.

best regards,

DeDuikertjes wrote:
  
  

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying problem:

When I do a getmap-request with an SLD I get

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

List,

Is it known what is the latest mapserver version that does not have this 
bug?


MArco

Bart van den Eijnden schreef:

Marco,

filter code is used by both WFS and SLD WMS.

The second = is not necessary, =, == and eq are the same for strings.

Best regards,
Bart

On Mar 3, 2010, at 10:01 AM, DeDuikertjes wrote:

  

Bart,

The ticket refers to WFS OCG filter rgex tests for numeric values.
So, it seems to extend to WMS as well (need to expand the ticket ?).

Does this mean that I have te wait for this to be fixed, and then packaged in 
FGS?
(mapserver compilation is something I cannot do).

Now to check that I understand well:
The expression which is generated on the basis of the SLD should not read:

EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)

but should read:

EXPRESSION ([geoidn] == NL.IMRO.0184.EP127818521-00)

Note the two sets of double quotes and the second = 


MArco



Bart van den Eijnden schreef:


Then I fear you have run into (like myself):

http://trac.osgeo.org/mapserver/ticket/3289

Assefa can confirm this. Btw the fix was only done in trunk, should it not be 
done in the 5.6 branch as well?

Best regards,
Bart

On Mar 3, 2010, at 9:41 AM, DeDuikertjes wrote:

 
  

Bart,

I've tried to do so, no difference in either error file or temporary mapfile 
expressions

MArco

Bart van den Eijnden schreef:
   


It seems Mapserver does not treat your column as a character column, try using 
the following METADATA on your source layer (so not in the temporary MAP file):

gml_geoidn_type Character

Best regards,
Bart

On Mar 3, 2010, at 8:52 AM, DeDuikertjes wrote:

  
  

Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. A layer 
definition from this file is (there are a LOT more like that):

LAYER
CONNECTION host=xxx user=x dbname=xxx
CONNECTIONTYPE POSTGIS
DATA 'tc_punt_geometry from NL.IMRO.0184.Zeewijkfase4-0201_aggregated using 
unique oid using srid=28992'
DUMP TRUE
GROUP query
METADATA
  wms_srs EPSG:28992 EPSG:900913 EPSG:4326
  ows_feature_id  geoidn
  ows_group_title query
  ows_extent  170861.5122 520007.0618 171570.1698 520546.6582
  gml_exclude_items   
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry
  ows_title   query_punt
  gml_include_items   all
  ows_exclude_items   all
END
NAME query_punt
PROCESSING CLOSE_CONNECTION=DEFER
PROJECTION
  init=epsg:28992
END
STATUS ON
TEMPLATE query.html
TYPE POLYGON
UNITS METERS
CLASS
  NAME Unknown
  EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
  STYLE
ANGLE 360
COLOR 255 0 255
OPACITY 40
SIZE 2
SYMBOL sld_line_symbol
WIDTH 1
  END
  STYLE
ANGLE 360
COLOR 255 0 255
OPACITY 40
SYMBOL 0
WIDTH 1
  END
  STYLE
ANGLE 360
OPACITY 40
OUTLINECOLOR 255 0 255
SIZE 2
SYMBOL sld_line_symbol
WIDTH 1
  END
END
END

MArco



Bart van den Eijnden schreef:
  


Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and check if 
something is wrong in there, or post the LAYER definition to the  mailing list.

   
  

/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map
 


Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:

   
  

Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after SLD was applied 
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed
 Mar  3 08:21:29 2010].731599 msyyparse(): Expression parser error. syntax error
[Wed Mar  3 08:21:29 2010].731628 msEvalExpression: Expression parser error. 
Failed to parse expression: NL.IMRO.0184.BA127909736-00 = 
NL.IMRO.0184.EP127818521-00
[Wed Mar  3 08:21:29 2010].731649 msyyparse(): Expression parser error. syntax 
error
And a lot more of these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 (query_vlak), 0.029s
[Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1 (query_lijn), 0.002s
[Wed Mar  3 08:21:29 2010].749832 msDrawMap(): Layer 2 (query_punt), 0.003s
[Wed Mar  3 08:21:29 2010].750760 msDrawMap(): Drawing Label Cache, 0.000s
[Wed Mar  3 08:21:29 2010].750771 msDrawMap() total time: 0.046s
[Wed Mar  3 08:21:29 2010].999507 msSaveImage() total time: 0.249s
[Wed Mar  3 08:21:29 2010].999706 mapserv request processing time (msLoadMap 
not incl.): 0.336s
[Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at 0x81bf400.

What is going wrong?

MArco


Yewondwossen Assefa schreef:
 


Hi There,

One way to debug would be to set your map file in debug, something like this:
CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Ok, thank you for the confirmation.

For now I've installed 5.4.2. This one doesn't have the bug.

And thank you all for the accurate help to pinpoint the problem and to 
learn me a few new tricks.


MArco

Yewondwossen Assefa schreef:

Bart van den Eijnden wrote:

Then I fear you have run into (like myself):

http://trac.osgeo.org/mapserver/ticket/3289

Assefa can confirm this. Btw the fix was only done in trunk, should 
it not be done in the 5.6 branch as well?


  
The fix was back ported to the 5.6 branch and should be available for 
the next 5.6.2 release.


best regards,



Best regards,
Bart

On Mar 3, 2010, at 9:41 AM, DeDuikertjes wrote:

 

Bart,

I've tried to do so, no difference in either error file or temporary 
mapfile expressions


MArco

Bart van den Eijnden schreef:
   
It seems Mapserver does not treat your column as a character 
column, try using the following METADATA on your source layer (so 
not in the temporary MAP file):


gml_geoidn_type Character

Best regards,
Bart

On Mar 3, 2010, at 8:52 AM, DeDuikertjes wrote:

 
 

Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. 
A layer definition from this file is (there are a LOT more like 
that):


LAYER
 CONNECTION host=xxx user=x dbname=xxx
 CONNECTIONTYPE POSTGIS
 DATA 'tc_punt_geometry from 
NL.IMRO.0184.Zeewijkfase4-0201_aggregated using unique oid using 
srid=28992'

 DUMP TRUE
 GROUP query
 METADATA
   wms_srs EPSG:28992 EPSG:900913 EPSG:4326
   ows_feature_id  geoidn
   ows_group_title query
   ows_extent  170861.5122 520007.0618 171570.1698 
520546.6582
   gml_exclude_items   
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry 


   ows_title   query_punt
   gml_include_items   all
   ows_exclude_items   all
 END
 NAME query_punt
 PROCESSING CLOSE_CONNECTION=DEFER
 PROJECTION
   init=epsg:28992
 END
 STATUS ON
 TEMPLATE query.html
 TYPE POLYGON
 UNITS METERS
 CLASS
   NAME Unknown
   EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
   STYLE
 ANGLE 360
 COLOR 255 0 255
 OPACITY 40
 SIZE 2
 SYMBOL sld_line_symbol
 WIDTH 1
   END
   STYLE
 ANGLE 360
 COLOR 255 0 255
 OPACITY 40
 SYMBOL 0
 WIDTH 1
   END
   STYLE
 ANGLE 360
 OPACITY 40
 OUTLINECOLOR 255 0 255
 SIZE 2
 SYMBOL sld_line_symbol
 WIDTH 1
   END
 END
END

MArco



Bart van den Eijnden schreef:
  

Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and 
check if something is wrong in there, or post the LAYER 
definition to the  mailing list.


   
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map 

  

Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:

   

Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after 
SLD was applied 
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed 
Mar  3 08:21:29 2010].731599 msyyparse(): Expression parser 
error. syntax error
[Wed Mar  3 08:21:29 2010].731628 msEvalExpression: Expression 
parser error. Failed to parse expression: 
NL.IMRO.0184.BA127909736-00 = NL.IMRO.0184.EP127818521-00
[Wed Mar  3 08:21:29 2010].731649 msyyparse(): Expression parser 
error. syntax error

And a lot more of these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 
(query_vlak), 0.029s
[Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1 
(query_lijn), 0.002s
[Wed Mar  3 08:21:29 2010].749832 msDrawMap(): Layer 2 
(query_punt), 0.003s
[Wed Mar  3 08:21:29 2010].750760 msDrawMap(): Drawing Label 
Cache, 0.000s

[Wed Mar  3 08:21:29 2010].750771 msDrawMap() total time: 0.046s
[Wed Mar  3 08:21:29 2010].999507 msSaveImage() total time: 0.249s
[Wed Mar  3 08:21:29 2010].999706 mapserv request processing 
time (msLoadMap not incl.): 0.336s
[Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at 
0x81bf400.


What is going wrong?

MArco


Yewondwossen Assefa schreef:
 

Hi There,

One way to debug would be to set your map file in debug, 
something like this:

CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the 
sld has been applied. That might give a  hint on what went wrong.


best regards,

DeDuikertjes wrote:
   

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 
5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying 
problem:


When I do a getmap-request with an SLD I get an empty image 
back, while

5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv 
executable with

the new one.

an example of a getmap request which

[mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying problem:

When I do a getmap-request with an SLD I get an empty image back, while
5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv executable with
the new one.

an example of a getmap request which fails on 5.6.0 and succeeds in
5.1-dev is:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-0201.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSLD_BODY=%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3Csld%3AStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3Csld%3ANamedLayer%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AUserStyle%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AFeatureTypeStyle%3E%3Csld%3ARule%3E%3Cogc%3AFilter%3E%3Cogc%3APropertyIsEqualTo%3E%3Cogc%3APropertyName%3Egeoidn%3C%2Fogc%3APropertyName%3E%3Cogc%3ALiteral%3ENL.IMRO.0184.EP127818521-00%3C%2Fogc%3ALiteral%3E%3C%2Fogc%3APropertyIsEqualTo%3E%3C%2Fogc%3AFilter%3E%3Csld%3APolygonSymbolizer%3E%3Csld%3AFill%3E%3Csld%3ACssParameter%20name%3D%22fill%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22fill-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3
E%3C%2Fsld%3AFill%3E%3Csld%3AStroke%3E%3Csld%3ACssParameter%20name%3D%22stroke%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-width%22%3E2%3C%2Fsld%3ACssParameter%3E%3C%2Fsld%3AStroke%3E%3C%2Fsld%3APolygonSymbolizer%3E%3Csld%3ALineSymbolizer%3E%3Csld%3AStroke%3E%3Csld%3ACssParameter%20name%3D%22stroke%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-width%22%3E2%3C%2Fsld%3ACssParameter%3E%3C%2Fsld%3AStroke%3E%3C%2Fsld%3ALineSymbolizer%3E%3C%2Fsld%3ARule%3E%3C%2Fsld%3AFeatureTypeStyle%3E%3C%2Fsld%3AUserStyle%3E%3C%2Fsld%3ANamedLayer%3E%3C%2Fsld%3AStyledLayerDescriptor%3ESRS=EPSG%3A900913BBOX=625312.21905694,6921632.3781404,627462.0104771,6922637.4056294WIDTH=1800HEIGHT=841

any help greatly appreciated, MArco



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

Re: [mapserver-users] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Hi,

And if I do the same request without the SLD:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-0201.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSRS=EPSG%3A900913BBOX=625312.21905694,6921632.3781404,627462.0104771,6922637.4056294WIDTH=1800HEIGHT=841

the result is an image and the error file says:
[Wed Mar  3 08:40:28 2010].43084 msDrawMap(): Layer 0 (query_vlak), 0.046s
[Wed Mar  3 08:40:28 2010].45806 msDrawMap(): Layer 1 (query_lijn), 0.003s
[Wed Mar  3 08:40:28 2010].47602 msDrawMap(): Layer 2 (query_punt), 0.002s
[Wed Mar  3 08:40:28 2010].47700 msDrawMap(): Drawing Label Cache, 0.000s
[Wed Mar  3 08:40:28 2010].47712 msDrawMap() total time: 0.062s
[Wed Mar  3 08:40:28 2010].288683 msSaveImage() total time: 0.241s
[Wed Mar  3 08:40:28 2010].288878 mapserv request processing time 
(msLoadMap not incl.): 0.331s

[Wed Mar  3 08:40:28 2010].288898 msFreeMap(): freeing map at 0x879a928.

MArco

Yewondwossen Assefa schreef:

Hi There,

One way to debug would be to set your map file in debug, something 
like this:

CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the sld has 
been applied. That might give a  hint on what went wrong.


best regards,

DeDuikertjes wrote:

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying problem:

When I do a getmap-request with an SLD I get an empty image back, while
5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv executable with
the new one.

an example of a getmap request which fails on 5.6.0 and succeeds in
5.1-dev is:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-0201.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSLD_BODY=%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3Csld%3AStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3Csld%3ANamedLayer%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AUserStyle%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AFeatureTypeStyle%3E%3Csld%3ARule%3E%3Cogc%3AFilter%3E%3Cogc%3APropertyIsEqualTo%3E%3Cogc%3APropertyName%3Egeoidn%3C%2Fogc%3APropertyName%3E%3Cogc%3ALiteral%3ENL.IMRO.0184.EP127818521-00%3C%2Fogc%3ALiteral%3E%3C%2Fogc%3APropertyIsEqualTo%3E%3C%2Fogc%3AFilter%3E%3Csld%3APolygonSymbolizer%3E%3Csld%3AFill%3E%3Csld%3ACssParameter%20name%3D%22fill%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22fill-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3 

E%3C%2Fsld%3AFill%3E%3Csld%3AStroke%3E%3Csld%3ACssParameter%20name%3D%22stroke%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-width%22%3E2%3C%2Fsld%3ACssParameter%3E%3C%2Fsld%3AStroke%3E%3C%2Fsld%3APolygonSymbolizer%3E%3Csld%3ALineSymbolizer%3E%3Csld%3AStroke%3E%3Csld%3ACssParameter%20name%3D%22stroke%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22stroke-width%22%3E2%3C%2Fsld%3ACssParameter%3E%3C%2Fsld%3AStroke%3E%3C%2Fsld%3ALineSymbolizer%3E%3C%2Fsld%3ARule%3E%3C%2Fsld%3AFeatureTypeStyle%3E%3C%2Fsld%3AUserStyle%3E%3C%2Fsld%3ANamedLayer%3E%3C%2Fsld%3AStyledLayerDescriptor%3ESRS=EPSG%3A900913BBOX=625312.21905694,6921632.3781404,627462.0104771,6922637.4056294WIDTH=1800HEIGHT=841 



any help greatly appreciated, MArco



___
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] getmap request with SLD failing after upgrade to 5.6.0

[DeDuikertjes]

Bart,

Thanks for the suggestion. I've opened up the temporary MAP file. A 
layer definition from this file is (there are a LOT more like that):


LAYER
   CONNECTION host=xxx user=x dbname=xxx
   CONNECTIONTYPE POSTGIS
   DATA 'tc_punt_geometry from 
NL.IMRO.0184.Zeewijkfase4-0201_aggregated using unique oid using 
srid=28992'

   DUMP TRUE
   GROUP query
   METADATA
 wms_srs EPSG:28992 EPSG:900913 EPSG:4326
 ows_feature_id  geoidn
 ows_group_title query
 ows_extent  170861.5122 520007.0618 171570.1698 520546.6582
 gml_exclude_items   
tc_multi_geometry,tc_vlak_geometry,tc_lijn_geometry,tc_punt_geometry

 ows_title   query_punt
 gml_include_items   all
 ows_exclude_items   all
   END
   NAME query_punt
   PROCESSING CLOSE_CONNECTION=DEFER
   PROJECTION
 init=epsg:28992
   END
   STATUS ON
   TEMPLATE query.html
   TYPE POLYGON
   UNITS METERS
   CLASS
 NAME Unknown
 EXPRESSION ([geoidn] = NL.IMRO.0184.EP127818521-00)
 STYLE
   ANGLE 360
   COLOR 255 0 255
   OPACITY 40
   SIZE 2
   SYMBOL sld_line_symbol
   WIDTH 1
 END
 STYLE
   ANGLE 360
   COLOR 255 0 255
   OPACITY 40
   SYMBOL 0
   WIDTH 1
 END
 STYLE
   ANGLE 360
   OPACITY 40
   OUTLINECOLOR 255 0 255
   SIZE 2
   SYMBOL sld_line_symbol
   WIDTH 1
 END
   END
 END

MArco



Bart van den Eijnden schreef:

Hi Marco,

Mapserver has saved a temporary MAP file, please open it up and check if 
something is wrong in there, or post the LAYER definition to the  mailing list.

  

/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map




Best regards,
Bart

On Mar 3, 2010, at 8:30 AM, DeDuikertjes wrote:

  

Thank you,

I've did as you said, but can't get a clue on what's going on.
The error file shows:

[Wed Mar  3 08:21:29 2010].677158 msApplySLD(): Map file after SLD was applied 
/var/www/cgi-bin/../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/4b8e0df9_52ef_0._sld.map[Wed
 Mar  3 08:21:29 2010].731599 msyyparse(): Expression parser error. syntax error
[Wed Mar  3 08:21:29 2010].731628 msEvalExpression: Expression parser error. 
Failed to parse expression: NL.IMRO.0184.BA127909736-00 = 
NL.IMRO.0184.EP127818521-00
[Wed Mar  3 08:21:29 2010].731649 msyyparse(): Expression parser error. syntax 
error
And a lot more of these expression errors.
Then followed by
[Wed Mar  3 08:21:29 2010].745454 msDrawMap(): Layer 0 (query_vlak), 0.029s
[Wed Mar  3 08:21:29 2010].747286 msDrawMap(): Layer 1 (query_lijn), 0.002s
[Wed Mar  3 08:21:29 2010].749832 msDrawMap(): Layer 2 (query_punt), 0.003s
[Wed Mar  3 08:21:29 2010].750760 msDrawMap(): Drawing Label Cache, 0.000s
[Wed Mar  3 08:21:29 2010].750771 msDrawMap() total time: 0.046s
[Wed Mar  3 08:21:29 2010].999507 msSaveImage() total time: 0.249s
[Wed Mar  3 08:21:29 2010].999706 mapserv request processing time (msLoadMap 
not incl.): 0.336s
[Wed Mar  3 08:21:29 2010].999723 msFreeMap(): freeing map at 0x81bf400.

What is going wrong?

MArco


Yewondwossen Assefa schreef:


Hi There,

One way to debug would be to set your map file in debug, something like this:
CONFIG  MS_ERRORFILE f:/msapps/gmap-ms40/htdocs/gmap.log
DEBUG 5
and check the logs. It should show you the map file after the sld has been 
applied. That might give a  hint on what went wrong.

best regards,

DeDuikertjes wrote:
  

Hi List,

Finally I managed to upgrade mapserver 5.1-dev (FWTools) to 5.6.0 (FGS).
I use it as a WMS. Everything looks fine, but I've one anoying problem:

When I do a getmap-request with an SLD I get an empty image back, while
5.1-dev gives me a proper result.
Other getmap requests work fine.
I tested this several times by swapping the old mapserv executable with
the new one.

an example of a getmap request which fails on 5.6.0 and succeeds in
5.1-dev is:
https://85.12.17.114/cgi-bin/mapserv?map=../html/viewerfabriek-alpha/data/vf_80.101.100.35_check/4b8d40f7e0787/NL.IMRO.0184.Zeewijkfase4-0201.mapLAYERS=queryFORMAT=pngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSLD_BODY=%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22utf-8%22%3F%3E%3Csld%3AStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3Csld%3ANamedLayer%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AUserStyle%3E%3Csld%3AName%3Equery%3C%2Fsld%3AName%3E%3Csld%3AFeatureTypeStyle%3E%3Csld%3ARule%3E%3Cogc%3AFilter%3E%3Cogc%3APropertyIsEqualTo%3E%3Cogc%3APropertyName%3Egeoidn%3C%2Fogc%3APropertyName%3E%3Cogc%3ALiteral%3ENL.IMRO.0184.EP127818521-00%3C%2Fogc%3ALiteral%3E%3C%2Fogc%3APropertyIsEqualTo%3E%3C%2Fogc%3AFilter%3E%3Csld%3APolygonSymbolizer%3E%3Csld%3AFill%3E%3Csld%3ACssParameter%20name%3D%22fill%22%3E%23FF00FF%3C%2Fsld%3ACssParameter%3E%3Csld%3ACssParameter%20name%3D%22fill-opacity%22%3E0.4%3C%2Fsld%3ACssParameter%3 
E%3C%2Fsld%3AFill%3E%3Csld%3AStroke%3E%3Csld

Re: Re: [mapserver-users] high quality print from external wms

[DeDuikertjes]

Hi,

WMS services do often have an upper limit for the output image size.

According to WMS specs they should advertise that in response to a 
getcapabilities request.
Despite that, Mapserver doesn't always do that. At least my version 
(5.1) doesn't.


Piecing together an image from smaller pieces isn't that easy when 
labels are involved (and perhaps also when hatch symbols are involved).


Cheers, MArco


Rahkonen Jukka schreef:

Hi,

WMS servers have often an upper limit for the output image size.  If
that is the case you can not do anything else than capture the print
area in smaller pieces and combine them with your application.  Test the
service by sending WMS calls manually with different HEIGHT and WIDTH
parameters.

-Jukka Rahkonen-
 
 Puolesta Basti2025 wrote:


 
  

Hi all,
i got an external wms included in my mapfile, like this:

 LAYER
NAME 'grenzen_5'
TYPE RASTER
STATUS ON
CONNECTION 'http://..?SERVICE=S;'
CONNECTIONTYPE WMS
METADATA
'wms_srs' 'EPSG:31467'
'wms_title' 'Grenzen 5'
'wms_name' 'grenzen_5'
'wms_format' 'image/png'
'wms_server_version' '1.1.1'
'wms_onlineresource'
'http://..SERVICE=Sversion=1.1.
1service=Srequest=GetLegendGraphiclayer=grenzen_5for
mat=age/pngSTYLEÞfault'
END
END

Normaly the wms is not able to print with 288dpi.

My question is, how can i mod my mapfile so that i can use 
high quality

print with an external wms.

thx,
basti 
--
View this message in context: 
http://n2.nabble.com/high-quality-print-from-external-wms-tp45

00369p4500369.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
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: Re: Re: [mapserver-users] ShapeObj from WKT help please

[DeDuikertjes]

Hi Antony,

Ah, you need attributes as well ...
In that case I think it's easiest to use postgis.
First load the data and attributes into postgis (it can natively read WKT).
Than you can do whatever you want with it (sky is the limit).

OpenJump and Qgis can both directly connect to postgis to do the 
necessary work.


MArco

touny schreef:
hi Marco, 
Thank YOu for your help. I have allready installed openJump GIS, but Now I

dont know how can I add data into it. The only data I have is storwed in MS
excel. it is tab vith lots of atributes, and wkt geometry is in one column.
any idea?

Antony


deduikertjes wrote:
  
The opensource OpenJUMP GIS can read your WKT format and write shp (And 
what's more, it's a very nice GIS to do spatial processing)


Marco

Josh Hevenor schreef:


http://mapserver.org/mapscript/php/index.html#shapeobj-class

The second constructor will build this for you...

ShapeObj ms_shapeObjFromWkt(string wkt)

Or if you have a spreadsheet you could look at adding the whole thing to
your mapfile, or converting it to shapefile (etc.) with ogr2ogr. 


http://mapserver.org/input/vector/VirtualSpatialData.html?highlight=ovf


Josh



touny wrote:
  
  
POLYGON((x y,x y,x y,x y)) 


Can You help me, where can I display/export data in this format into
SHP. 
I have recieved from my boss data in XLS with this geometry.. but I dont
know how to work with it. 
Does anyone know? 

Anthony 
  




No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.423 / Virus Database: 270.14.32/2460 - Release Date:

10/26/09 08:10:00

  


  
  

___
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: Re: [mapserver-users] ShapeObj from WKT help please

[DeDuikertjes]

The opensource OpenJUMP GIS can read your WKT format and write shp (And 
what's more, it's a very nice GIS to do spatial processing)


Marco

Josh Hevenor schreef:

http://mapserver.org/mapscript/php/index.html#shapeobj-class

The second constructor will build this for you...

ShapeObj ms_shapeObjFromWkt(string wkt)

Or if you have a spreadsheet you could look at adding the whole thing to your mapfile, or converting it to shapefile (etc.) with ogr2ogr. 


http://mapserver.org/input/vector/VirtualSpatialData.html?highlight=ovf


Josh



touny wrote:
  
POLYGON((x y,x y,x y,x y)) 

Can You help me, where can I display/export data in this format into SHP. 
I have recieved from my boss data in XLS with this geometry.. but I dont
know how to work with it. 
Does anyone know? 

Anthony 
  




No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.423 / Virus Database: 270.14.32/2460 - Release Date: 10/26/09 08:10:00


  



  

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

Re: [mapserver-users] ShapeObj from WKT help please

[DeDuikertjes]

As far as I can see from this snippet I guess it's the space between 
POLYGON and (. Besides that make sure that there are no linebreaks in 
the string.


MArco

joel ml schreef:

help
whats the error en el next code made in java?

:


shapeObj shape=ll;
shape=ape.fromWKT(POLYGON (309038.2109318934 7642746.71351495, 282648.41216525325 
7611988.745112174, 348475.28671546053 7606977.030844433, 309038.2109318934 
7642746.71351495));

launch error:


Exception in thread AWT-EventQueue-0 java.lang.UnknownError: msGEOSShapeFromWKT(): GEOS 
library error. Error reading WKT geometry POLYGON (309038.2109318934 7642746.71351495, 
282648.41216525325 7611988.745112174, 348475.28671546053 7606977.030844433, 309038.2109318934 
7642746.71351495).;msGEOSError(): GEOS library error. Unknown exception thrown
at edu.umn.gis.mapscript.mapscriptJNI.shapeObj_fromWKT(Native Method)
at edu.umn.gis.mapscript.shapeObj.fromWKT(shapeObj.java:108)



I'm using the package ms4w 2.3.1


- MapServer 5.2.1 CGI and MapScript (CSharp, Java, PHP, 
  Python)


curl-7.15.1
expat-2.0.1
fcgi-2.4.0
fits-3.0.2
freetype-2.1.10
fribidi-0.19.1
gd-2.0.35

gdal-1.6.0 RC2
geos-2.2.3
gettext-0.13
hdf5
jbigkit-1.6
jpeg-6b
libecwj2-3.3
libgeotiff-1.2.3
libiconv-1.9.1
libintl-0.11.5
libpng-1.2.8
libxml2-2.6.23.win32
mapserver-5.2.1
ming-0.2a
mrsid-6.0.7.1407
mysql-5.0.18-win32
netcdf-3.6.1
PDFlib-Lite-6.0.2

php-5.2.6
postgresql-8.3.3
proj-4.6.1
Python-2.5.1
regex-0.12
sqlite3
SWIG-1.3.33

tiff-cvs (02/04/08)
xerces-c-2.7.0
zlib-1.2.3


  Yahoo! Cocina

Encontra las mejores recetas con Yahoo! Cocina.


http://ar.mujer.yahoo.com/cocina/

  

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

Re: [mapserver-users] remote SLD problem [solved]

[DeDuikertjes]

Dear list

Shot in the dark was right on target.

/usr/sbin/setsebool -P httpd_can_network_connect=1

fixed the problem (Centos 5.2)

MArco

DeDuikertjes schreef:

Guillaume,

Thank you,
it is.
By the way I found out that mapserv is actually running as apache
apache can acces the SLD file
(found out via: su -c 'wget -qO- 
http://mydomain.nl/plancheck_test/data/0999_check/bestplan.sld' -s 
/bin/sh apache)


So, I've not a single clue what's goin on.
shot in the dark: SELINUX?

MArco

Guillaume Sueur schreef:

Hi,

Try to make your sld file readable by any user.

Regards,

Guillaume

Le lundi 28 septembre 2009 à 18:14 +0200, DeDuikertjes a écrit :
 

Hello,

this is my problem, please help
mapserver is running ok, and this gives me a nice picture:
http://mydomain.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/0999_check/NL.IMRO.0999.BP200801-0005/wkt/NL.IMRO.0999.BP200801-0005.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=6.36411,51.8821,6.37681,51.8897Layers=NL.IMRO.0999.BP200801-0005Format=image/pngwidth=800height=600SRS=EPSG:4326 



Now, I'd like to use a SLD to do some styling. So I've made myself a 
nice SLD and I use the url:
http://check.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/0999_check/NL.IMRO.0999.BP200801-0005/wkt/NL.IMRO.0999.BP200801-0005.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapBBOX=6.36411,51.8821,6.37681,51.8897Layers=NL.IMRO.0999.BP200801-0005Format=image/pngwidth=800height=600SRS=EPSG:4326SLD=http://mydomain.nl/plancheck_test/data/0999_check/bestplan.sld 



ok, the SLD is at the specified location and I can view it with my 
browser.

mapserver returns an error document with:

msHTTPExecuteRequests(): HTTP request error. HTTP: request failed 
with curl error code 7 (Failed to connect to 85.12.17.114: 
Permission denied) for 
http://mydomain.nl/plancheck_test/data/0999_check/bestplan.sld


That puzzled me for a while, but then I tried (from the box where 
mapserver runs):
su -c 'wget 
http://mydomain.nl/plancheck_test/data/0999_check/bestplan.sld' -s 
/bin/sh nobody


that returns:
bestplan.sld: Permission denied

So user nobody can't get to the SLD. I believe mapserver is running 
as nobody because I believe  apache does.

I think that's the problem.

But then, how to solve this?
Any help greatly appreciated ...

MArco



___
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

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

[mapserver-users] getfeatureinfo problems

[DeDuikertjes]

Dear list,

yesterday I reported problems with my WFS server. I could not fix that 
up till now.


I have another possibly related problem.
My WMS is set up allright, getcapabilities is ok, I can see the map, pan 
zoom, etc, no problems.


When I do an Identify (GetFeatureInfo request), I get back an 
exception-report, with no items in (so essentially an ampty exception 
report).

The query just doesn't seem to find the data.
Clicking inside a feature and outside does differ (outside doesn't give 
an exception report).


I've enabled debugging and this is the output when I do a GetFeatureInfo 
request:


[Fri Jun 26 13:21:11 2009].498623 CGI Request 1 on process 1525
[Fri Jun 26 13:21:11 2009].518710 msPOSTGISLayerOpen called datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn using 
srid=28992
[Fri Jun 26 13:21:11 2009].518735 MSPOSTGISLayerOpen -- shared connection not 
available.
[Fri Jun 26 13:21:11 2009].523422 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].523453 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].523466 msPOSTGISLayerWhichShapes called
[Fri Jun 26 13:21:11 2009].523490 msPOSTGISLayerParseData: unique column = geoidn, 
srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].523796 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from 
NL.IMRO.0026.SVBBU-0001 WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and 
(tc_vlak_geometry  setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )
[Fri Jun 26 13:21:11 2009].535912 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].535925 msPOSTGISLayerClose datastatement: tc_vlak_geometry 
from NL.IMRO.0026.SVBBU-0001 using unique geoidn using srid=28992
[Fri Jun 26 13:21:11 2009].535931 msPOSTGISLayerClose -- closing query_result
[Fri Jun 26 13:21:11 2009].536007 
msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].536017 msConnPoolClose(host=localhost user=tc_check 
dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].538905 msPOSTGISLayerOpen called datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn using 
srid=28992
[Fri Jun 26 13:21:11 2009].538914 MSPOSTGISLayerOpen -- shared connection not 
available.
[Fri Jun 26 13:21:11 2009].543298 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].543314 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].543319 in msPOSTGISLayerGetItems  (find column names)
[Fri Jun 26 13:21:11 2009].543329 msPOSTGISLayerParseData: unique column = geoidn, 
srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].545217 msPOSTGISLayerInitItemInfo called
[Fri Jun 26 13:21:11 2009].545230 msPOSTGISLayerGetShape called for record = 0
[Fri Jun 26 13:21:11 2009].545239 msPOSTGISLayerParseData: unique column = geoidn, 
srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].545253 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT geoidn::text,idealisatie::text,tc_multi_geometry::text,tc_lijn_geometry::text,tc_punt_geometry::text,asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR') from NL.IMRO.0026.SVBBU-0001 WHERE geoidn = 0 
[Fri Jun 26 13:21:11 2009].547105 msFreeMap(): freeing map at 0x943d518.

[Fri Jun 26 13:21:11 2009].547114 msPOSTGISLayerClose datastatement: tc_vlak_geometry 
from NL.IMRO.0026.SVBBU-0001 using unique geoidn using srid=28992
[Fri Jun 26 13:21:11 2009].547119 msPOSTGISLayerClose -- query_result is NULL
[Fri Jun 26 13:21:11 2009].547124 
msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)


Just as with the WFS problem, there is no data returning. The WFS does show the exposed columns, never any data in. 


I've not a clue of how to proceed, or how to get extra debug info.
Please help !

MArco
[Fri Jun 26 13:21:11 2009].547132 msConnPoolClose(host=localhost user=tc_check 
dbname=80.101.100.35,0x9457b38)


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

Re: [mapserver-users] getfeatureinfo problems

[DeDuikertjes]

Jukka,

Thank you, I've tried the SQL statement:

DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from 
NL.IMRO.0026.SVBBU-0001 WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and 
(tc_vlak_geometry  setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )

with the first DECLARE part omitted, so:
SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text 
from NL.IMRO.0026.SVBBU-0001 WHERE 
(geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry  
setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )


This returns two rows.
I've tried
SELECT 
geoidn::text,idealisatie::text,tc_multi_geometry::text,tc_lijn_geometry::text,tc_punt_geometry::text,asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR') 
from NL.IMRO.0026.SVBBU-0001 WHERE geoidn = 0


also, which returns 0 rows.
This is as expected from this query as it asks for WHERE geoidn = 0
geoidn never is 0.

Why does mapserver come to this query? I've never asked for geidn to be 
zero!
If I remove the WHERE geoidn = 0 I get a result for all the layers on 
the point (all the layers in fact).
Somehow this WHERE geoidn = 0 condition is constructed false. Ist should 
be something like WHERE geoidn = geoidNL.IMRO.0026.SVBBU-0001


I've not a clue where that wrong query clause comes from.

MArco
P.S. In earlier attempts I've renamed the tables with identical results.




Rahkonen Jukka schreef:

Hi,

Have you tried to run the SQL queries from logfile directly?  I wonder if for 
example this part is correct and finds any data:

 WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry  
setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )

Just a guess, but perhaps odd table name makes some trouble.  How about reneming or 
copying the table temporarily to something wiht more simple name, like test?

-Jukka Rahkonen-




DeDuikertjes wrote:

Dear list,

yesterday I reported problems with my WFS server. I could not fix that 
up till now.


I have another possibly related problem.
My WMS is set up allright, getcapabilities is ok, I can see the map, pan 
zoom, etc, no problems.


When I do an Identify (GetFeatureInfo request), I get back an 
exception-report, with no items in (so essentially an ampty exception 
report).

The query just doesn't seem to find the data.
Clicking inside a feature and outside does differ (outside doesn't give 
an exception report).


I've enabled debugging and this is the output when I do a GetFeatureInfo 
request:


[Fri Jun 26 13:21:11 2009].498623 CGI Request 1 on process 1525
[Fri Jun 26 13:21:11 2009].518710 msPOSTGISLayerOpen called datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn using 
srid=28992
[Fri Jun 26 13:21:11 2009].518735 MSPOSTGISLayerOpen -- shared connection not 
available.
[Fri Jun 26 13:21:11 2009].523422 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].523453 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].523466 msPOSTGISLayerWhichShapes called
[Fri Jun 26 13:21:11 2009].523490 msPOSTGISLayerParseData: unique column = geoidn, 
srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].523796 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from 
NL.IMRO.0026.SVBBU-0001 WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and 
(tc_vlak_geometry  setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )
[Fri Jun 26 13:21:11 2009].535912 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].535925 msPOSTGISLayerClose datastatement: tc_vlak_geometry 
from NL.IMRO.0026.SVBBU-0001 using unique geoidn using srid=28992
[Fri Jun 26 13:21:11 2009].535931 msPOSTGISLayerClose -- closing query_result
[Fri Jun 26 13:21:11 2009].536007 
msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].536017 msConnPoolClose(host=localhost user=tc_check 
dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].538905 msPOSTGISLayerOpen called datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn using 
srid=28992
[Fri Jun 26 13:21:11 2009].538914 MSPOSTGISLayerOpen -- shared connection not 
available.
[Fri Jun 26 13:21:11 2009].543298 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].543314 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].543319 in msPOSTGISLayerGetItems  (find column names)
[Fri Jun 26 13:21:11 2009].543329 msPOSTGISLayerParseData

Re: [mapserver-users] WFS returning empty features

[DeDuikertjes]

List,

Thanks to Bart van den Eijnden the problem is solved.
I used a using unique clause on a column which was unique, but not 
integer.

So I now create my postgis tables with a CREAT TABLE  WITH OIDS

and I use a using unique oid clause in the DATA statement.

As often, details do matter.

Thanks for all the responses and efforts.

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

Re: [mapserver-users] getfeatureinfo problems

[DeDuikertjes]

List,

Thanks to Bart van den Eijnden the problem is solved.
I used a using unique clause on a column which was unique, but not 
integer.

So I now create my postgis tables with a CREAT TABLE  WITH OIDS

and I use a using unique oid clause in the DATA statement.

As often, details do matter.

Thanks for all the responses and efforts.

MArco




DeDuikertjes wrote:

Dear list,

yesterday I reported problems with my WFS server. I could not fix 
that up till now.


I have another possibly related problem.
My WMS is set up allright, getcapabilities is ok, I can see the map, 
pan zoom, etc, no problems.


When I do an Identify (GetFeatureInfo request), I get back an 
exception-report, with no items in (so essentially an ampty exception 
report).

The query just doesn't seem to find the data.
Clicking inside a feature and outside does differ (outside doesn't 
give an exception report).


I've enabled debugging and this is the output when I do a 
GetFeatureInfo request:


[Fri Jun 26 13:21:11 2009].498623 CGI Request 1 on process 1525
[Fri Jun 26 13:21:11 2009].518710 msPOSTGISLayerOpen called 
datastatement: tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using 
unique geoidn using srid=28992
[Fri Jun 26 13:21:11 2009].518735 MSPOSTGISLayerOpen -- shared 
connection not available.
[Fri Jun 26 13:21:11 2009].523422 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)

[Fri Jun 26 13:21:11 2009].523453 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].523466 msPOSTGISLayerWhichShapes called
[Fri Jun 26 13:21:11 2009].523490 msPOSTGISLayerParseData: unique 
column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].523796 query_string_0_6:DECLARE mycursor 
BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text 
from NL.IMRO.0026.SVBBU-0001 WHERE 
(geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry  
setSRID( 'BOX3D(155984.407968748 468982.233317728,156024.590926508 
469022.416275488)'::BOX3D,28992) )

[Fri Jun 26 13:21:11 2009].535912 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].535925 msPOSTGISLayerClose datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn 
using srid=28992
[Fri Jun 26 13:21:11 2009].535931 msPOSTGISLayerClose -- closing 
query_result
[Fri Jun 26 13:21:11 2009].536007 
msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].536017 msConnPoolClose(host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)
[Fri Jun 26 13:21:11 2009].538905 msPOSTGISLayerOpen called 
datastatement: tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using 
unique geoidn using srid=28992
[Fri Jun 26 13:21:11 2009].538914 MSPOSTGISLayerOpen -- shared 
connection not available.
[Fri Jun 26 13:21:11 2009].543298 
msConnPoolRegister(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)

[Fri Jun 26 13:21:11 2009].543314 msPOSTGISLayerFreeItemInfo called
[Fri Jun 26 13:21:11 2009].543319 in msPOSTGISLayerGetItems  (find 
column names)
[Fri Jun 26 13:21:11 2009].543329 msPOSTGISLayerParseData: unique 
column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001

[Fri Jun 26 13:21:11 2009].545217 msPOSTGISLayerInitItemInfo called
[Fri Jun 26 13:21:11 2009].545230 msPOSTGISLayerGetShape called for 
record = 0
[Fri Jun 26 13:21:11 2009].545239 msPOSTGISLayerParseData: unique 
column = geoidn, srid='28992', geom_column_name = tc_vlak_geometry, 
table_name=NL.IMRO.0026.SVBBU-0001
[Fri Jun 26 13:21:11 2009].545253 msPOSTGISLayerGetShape: DECLARE 
mycursor2 BINARY CURSOR FOR SELECT 
geoidn::text,idealisatie::text,tc_multi_geometry::text,tc_lijn_geometry::text,tc_punt_geometry::text,asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR') 
from NL.IMRO.0026.SVBBU-0001 WHERE geoidn = 0 [Fri Jun 26 13:21:11 
2009].547105 msFreeMap(): freeing map at 0x943d518.
[Fri Jun 26 13:21:11 2009].547114 msPOSTGISLayerClose datastatement: 
tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique geoidn 
using srid=28992
[Fri Jun 26 13:21:11 2009].547119 msPOSTGISLayerClose -- query_result 
is NULL
[Fri Jun 26 13:21:11 2009].547124 
msConnPoolRelease(geoidNL.IMRO.0026.SVBBU-0001_vlak,host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)



Just as with the WFS problem, there is no data returning. The WFS 
does show the exposed columns, never any data in.

I've not a clue of how to proceed, or how to get extra debug info.
Please help !

MArco
[Fri Jun 26 13:21:11 2009].547132 msConnPoolClose(host=localhost 
user=tc_check dbname=80.101.100.35,0x9457b38)



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

[mapserver-users] WFS returning empty features

[DeDuikertjes]

Dear List,

I've mapserver all set up.
The mapfile is working and produces a nice and working WMS.

The WFS is giving me troubles.
It returns a valid capabilities document with no warnings
A getfeature request returns GML, with the bounds defined, but otherwise 
with NO features.

This for a layer which draws perfectly well in the WMS.

uDig sees all colums (attributes) of the layer, but every column is empty.

I've not a clue what I am doing wrong.

any help greatly appreciated.

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

Re: [mapserver-users] WFS returning empty features

[DeDuikertjes]

Roy, List,

i'm using MapServer version 5.1-dev

I've set the map extent. I did not set layer extents. Is that necessary?

MArco

Roy Braam schreef:

What  version of mapserver are you using? Have you set the map extent and layer 
extents?
  
Roy



  _  


From: DeDuikertjes [mailto:deduikert...@xs4all.nl]
To: mapserver-users@lists.osgeo.org
Sent: Wed, 24 Jun 2009 15:12:29 +0200
Subject: [mapserver-users] WFS returning empty features

Dear List,
  
  I've mapserver all set up.

  The mapfile is working and produces a nice and working WMS.
  
  The WFS is giving me troubles.

  It returns a valid capabilities document with no warnings
  A getfeature request returns GML, with the bounds defined, but otherwise 
  with NO features.

  This for a layer which draws perfectly well in the WMS.
  
  uDig sees all colums (attributes) of the layer, but every column is empty.
  
  I've not a clue what I am doing wrong.
  
  any help greatly appreciated.
  
  MArco

  ___
  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 returning empty features

[DeDuikertjes]

Roy, Jukka, List,

I've tried adding extents to each layer: no succes
I've

gml_include_items all
gml_featureid geoidn

in the layer metadata

MArco

Here is a snippet of the mapfile:

MAP
   NAME NL.IMRO.0026.SVBBU-0001
   IMAGETYPE png
   UNITS METERS
   EXTENT 155016 467631 156758 470080
   PROJECTION
  init=epsg:28992
   END
  
   WEB   
   METADATA

   ows_title   NL.IMRO.0026.SVBBU-0001
   wms_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map;
   wfs_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map;


   wfs_srs   EPSG:28992
   wms_srs   EPSG:28992
   END
   END
LAYER
   name geoidNL.IMRO.0026.SVBBU-0001_vlak

   GROUP geoidNL.IMRO.0026.SVBBU-0001

   PROJECTION
  init=epsg:28992
   END

   EXTENT 155016 467631 156758 470080

   METADATA
   ows_group_title geoidNL.IMRO.0026.SVBBU-0001
   ows_title   geoidNL.IMRO.0026.SVBBU-0001_vlak
   gml_include_items all
   gml_featureid geoidn
   END

   STATUS off
   TYPE polygon
   DUMP true

   CONNECTIONTYPE postgis
   CONNECTION host=localhost user=tc_check dbname=80.101.100.35
   DATA 'tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique 
geoidn using srid=28992'

   FILTER geoidn='geoidNL.IMRO.0026.SVBBU-0001'
   OPACITY 30
   TEMPLATE dummy.html
   CLASS
   STYLE
   COLOR 0 0 0
   OUTLINECOLOR 255 0 0
   END
   END
END




Rahkonen Jukka schreef:

Hi,

Do you have something in gml_include_items in the layer metadata?

-Jukka Rahkonen-

DeDuikertjes wrote:

Roy, List,

i'm using MapServer version 5.1-dev

I've set the map extent. I did not set layer extents. Is that necessary?

MArco

Roy Braam schreef:
  

What  version of mapserver are you using? Have you set the map extent and layer 
extents?
  
Roy



  _  


From: DeDuikertjes [mailto:deduikert...@xs4all.nl]
To: mapserver-users@lists.osgeo.org
Sent: Wed, 24 Jun 2009 15:12:29 +0200
Subject: [mapserver-users] WFS returning empty features

Dear List,
  
  I've mapserver all set up.

  The mapfile is working and produces a nice and working WMS.
  
  The WFS is giving me troubles.

  It returns a valid capabilities document with no warnings
  A getfeature request returns GML, with the bounds defined, but otherwise 
  with NO features.

  This for a layer which draws perfectly well in the WMS.
  
  uDig sees all colums (attributes) of the layer, but every column is empty.
  
  I've not a clue what I am doing wrong.
  
  any help greatly appreciated.
  
  MArco

  ___
  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


  

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

Re: [mapserver-users] WFS returning empty features

[DeDuikertjes]

Bart,

Thanks, Tried to widen that. No luck ..
Is the request ok (i try in the browser)? :
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.mapSERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=geoidNL.IMRO.0026.SVBBU-0001_vlak

it returns:
wfs:FeatureCollection xsi:schemaLocation=http://www.opengis.net/wfs 
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd 
http://mapserver.gis.umn.edu/mapserver 
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.mapSERVICE=WFSVERSION=1.0.0REQUEST=DescribeFeatureTypeTYPENAME=geoidNL.IMRO.0026.SVBBU-0001_vlakOUTPUTFORMAT=XMLSCHEMA;


gml:boundedBy

gml:Box srsName=EPSG:28992

gml:coordinates
155065.29,467655.922000 156442.422000,470040.75
/gml:coordinates
/gml:Box
/gml:boundedBy
/wfs:FeatureCollection

On closer inspection uDig does something strange. On zoom to layer it 
zooms to the wrong area (but shows no features there either).


MArco

bart...@osgis.nl schreef:

Try and widen your MAP-EXTENT.

Best regards,
Bart

  

Roy, Jukka, List,

I've tried adding extents to each layer: no succes
I've

gml_include_items all
gml_featureid geoidn

in the layer metadata

MArco

Here is a snippet of the mapfile:

MAP
NAME NL.IMRO.0026.SVBBU-0001
IMAGETYPE png
UNITS METERS
EXTENT 155016 467631 156758 470080
PROJECTION
   init=epsg:28992
END

WEB
METADATA
ows_title   NL.IMRO.0026.SVBBU-0001
wms_onlineresource
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map;
wfs_onlineresource
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map;

wfs_srs   EPSG:28992
wms_srs   EPSG:28992
END
END
LAYER
name geoidNL.IMRO.0026.SVBBU-0001_vlak

GROUP geoidNL.IMRO.0026.SVBBU-0001

PROJECTION
   init=epsg:28992
END

EXTENT 155016 467631 156758 470080

METADATA
ows_group_title geoidNL.IMRO.0026.SVBBU-0001
ows_title   geoidNL.IMRO.0026.SVBBU-0001_vlak
gml_include_items all
gml_featureid geoidn
END

STATUS off
TYPE polygon
DUMP true

CONNECTIONTYPE postgis
CONNECTION host=localhost user=tc_check dbname=80.101.100.35
DATA 'tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique
geoidn using srid=28992'
FILTER geoidn='geoidNL.IMRO.0026.SVBBU-0001'
OPACITY 30
TEMPLATE dummy.html
CLASS
STYLE
COLOR 0 0 0
OUTLINECOLOR 255 0 0
END
END
END




Rahkonen Jukka schreef:


Hi,

Do you have something in gml_include_items in the layer metadata?

-Jukka Rahkonen-

DeDuikertjes wrote:

Roy, List,

i'm using MapServer version 5.1-dev

I've set the map extent. I did not set layer extents. Is that necessary?

MArco

Roy Braam schreef:

  

What  version of mapserver are you using? Have you set the map extent
and layer extents?

Roy


  _

From: DeDuikertjes [mailto:deduikert...@xs4all.nl]
To: mapserver-users@lists.osgeo.org
Sent: Wed, 24 Jun 2009 15:12:29 +0200
Subject: [mapserver-users] WFS returning empty features

Dear List,

  I've mapserver all set up.
  The mapfile is working and produces a nice and working WMS.

  The WFS is giving me troubles.
  It returns a valid capabilities document with no warnings
  A getfeature request returns GML, with the bounds defined, but
otherwise
  with NO features.
  This for a layer which draws perfectly well in the WMS.

  uDig sees all colums (attributes) of the layer, but every column is
empty.

  I've not a clue what I am doing wrong.

  any help greatly appreciated.

  MArco
  ___
  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



  

___
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 returning empty features

[DeDuikertjes]

Mlinden,

Thanks, did set the wfs_extent as I expected you to have suggested that 
. No succes.

Widened als Bart suggested, No succes.

It's doing something as the bounding box changes.

MArco

mlin...@zeelandnet.nl schreef:

Do as Roy says.

Calculate (with a postgis query) the extent of ALL the features for the
given layer.
Use this extent to set the wms_extent (do not know if I name it
correctly, no access to my development machine at this moment).

This will help mapserver find objects.

  

What  version of mapserver are you using? Have you set the map extent and
layer extents?

Roy


  _

From: DeDuikertjes [mailto:deduikert...@xs4all.nl]
To: mapserver-users@lists.osgeo.org
Sent: Wed, 24 Jun 2009 15:12:29 +0200
Subject: [mapserver-users] WFS returning empty features

Dear List,

  I've mapserver all set up.
  The mapfile is working and produces a nice and working WMS.

  The WFS is giving me troubles.
  It returns a valid capabilities document with no warnings
  A getfeature request returns GML, with the bounds defined, but otherwise
  with NO features.
  This for a layer which draws perfectly well in the WMS.

  uDig sees all colums (attributes) of the layer, but every column is
empty.

  I've not a clue what I am doing wrong.

  any help greatly appreciated.

  MArco
  ___
  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





Milo van der Linden

a href=http://somafm.com/;img
src=http://somafm.com/linktous/450x25sfm1.gif; alt=SomaFM border=0
width=450 height=25 /a


___
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 returning empty features

[DeDuikertjes]

Guillaume,

Tried that.
I did a selection on the columns. No features, but stranger still, uDig 
sees all the columns.

That shouldn't be possible.

Might there be a problem with the grouping of the layers which is 
somehow connected.

In the WMS the layers get grouped as specified, in the WFS they don't.

MArco



Guillaume Sueur schreef:

Hi,

Just an idea cause your layer looks ok :
try to specify your columns names in the gml_include_items thing.

and check it out

hope it helps

Guillaume

DeDuikertjes a écrit :

Roy, Jukka, List,

I've tried adding extents to each layer: no succes
I've

gml_include_items all
gml_featureid geoidn

in the layer metadata

MArco

Here is a snippet of the mapfile:

MAP
   NAME NL.IMRO.0026.SVBBU-0001
   IMAGETYPE png
   UNITS METERS
   EXTENT 155016 467631 156758 470080
   PROJECTION
  init=epsg:28992
   END
 WEB  METADATA
   ows_title   NL.IMRO.0026.SVBBU-0001
   wms_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map; 

   wfs_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001.map; 



   wfs_srs   EPSG:28992
   wms_srs   EPSG:28992
   END
   END
LAYER
   name geoidNL.IMRO.0026.SVBBU-0001_vlak

   GROUP geoidNL.IMRO.0026.SVBBU-0001

   PROJECTION
  init=epsg:28992
   END

   EXTENT 155016 467631 156758 470080

   METADATA
   ows_group_title geoidNL.IMRO.0026.SVBBU-0001
   ows_title   geoidNL.IMRO.0026.SVBBU-0001_vlak
   gml_include_items all
   gml_featureid geoidn
   END

   STATUS off
   TYPE polygon
   DUMP true

   CONNECTIONTYPE postgis
   CONNECTION host=localhost user=tc_check dbname=80.101.100.35
   DATA 'tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique 
geoidn using srid=28992'

   FILTER geoidn='geoidNL.IMRO.0026.SVBBU-0001'
   OPACITY 30
   TEMPLATE dummy.html
   CLASS
   STYLE
   COLOR 0 0 0
   OUTLINECOLOR 255 0 0
   END
   END
END




Rahkonen Jukka schreef:

Hi,

Do you have something in gml_include_items in the layer metadata?

-Jukka Rahkonen-

DeDuikertjes wrote:

Roy, List,

i'm using MapServer version 5.1-dev

I've set the map extent. I did not set layer extents. Is that 
necessary?


MArco

Roy Braam schreef:
 
What  version of mapserver are you using? Have you set the map 
extent and layer extents?

  Roy


  _ From: DeDuikertjes [mailto:deduikert...@xs4all.nl]
To: mapserver-users@lists.osgeo.org
Sent: Wed, 24 Jun 2009 15:12:29 +0200
Subject: [mapserver-users] WFS returning empty features

Dear List,
I've mapserver all set up.
  The mapfile is working and produces a nice and working WMS.
The WFS is giving me troubles.
  It returns a valid capabilities document with no warnings
  A getfeature request returns GML, with the bounds defined, but 
otherwise   with NO features.

  This for a layer which draws perfectly well in the WMS.
uDig sees all colums (attributes) of the layer, but every 
column is empty.

I've not a clue what I am doing wrong.
any help greatly appreciated.
MArco
  ___
  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


  

___
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 returning empty features

[DeDuikertjes]

List,

To help on debugging I've forced an error in the postgis connection te 
see the actual query. This is:


'DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text 
from NL.IMRO.0026.SVBBU-0001x WHERE 
(geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry  
setSRID( 'BOX3D(140016 460631,166758 490080)'::BOX3D,28992) )'


I've also got rid off all destracting details so I've ended up with the 
mapfile on the end of this message.


MArco

MAP
   NAME NL.IMRO.0026.SVBBU-0001
   IMAGETYPE png
   UNITS METERS
   EXTENT 140016 460631 166758 490080
   PROJECTION
  init=epsg:28992
   END
  
   WEB   
   METADATA

   ows_title   NL.IMRO.0026.SVBBU-0001
   wms_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001-test.map;
   wfs_onlineresource  
http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001-test.map;


   wfs_srs   EPSG:28992
   wms_srs   EPSG:28992
   END
   END
LAYER
   name geoidNL.IMRO.0026.SVBBU-0001_vlak

   PROJECTION
  init=epsg:28992
   END

  
   METADATA

   ows_title   geoidNL.IMRO.0026.SVBBU-0001_vlak
   gml_include_items geoidn,idealisatie
   #gml_featureid geoidn
   wfs_featureidgeoidn
   wfs_extent140016 460631 166758 490080
  
   END


   STATUS on
   TYPE polygon
   DUMP true

   CONNECTIONTYPE postgis
   CONNECTION host=localhost user=tc_check dbname=80.101.100.35
   DATA 'tc_vlak_geometry from NL.IMRO.0026.SVBBU-0001 using unique 
geoidn using srid=28992'

   FILTER geoidn='geoidNL.IMRO.0026.SVBBU-0001'
  
   TEMPLATE dummy.html

   CLASS
   STYLE
   COLOR 0 0 0
   OUTLINECOLOR 255 0 0
   END
   END
END


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

[mapserver-users] Postgis data source: quoting table name problem

[DeDuikertjes]

Dear List,

I've extensively searched the archives, saw a couple of more or less
related posts, but couldn't find any solutions for my problem.

In my mapserver application I use postgis as a data source.
In my application the tables containing geometry columns do need to have
odd characters like . and - in their names (for clarity: the table names
that is, not the column names).
Postgis allows this by double qouting the table name in functions,
queries and sql statements.

So in mapserver I like to do that as well as in the following example:

DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique geoidn'

Unfortunately that fails with a message from the WMS:

msDrawMap(): Image handling error. Failed to draw layer named
'geoidNL.IMRO.SVBBU-102-_vlak'. prepare_database(): Query error. Error
executing POSTGIS DECLARE (the actual query) statement: 'DECLARE
mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text
from nl_imro_0026_svbbu_0001 WHERE tc_vlak_geometry 
setSRID('BOX3D(155016 467631,156758 470080)'::BOX3D,
find_srid('','nl_imro_0026_svbbu_0001','tc_vlak_geometry') )'
Postgresql reports the error as 'ERROR: find_srid() - couldnt find the
corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS
table? Is there an uppercase/lowercase missmatch? ' More Help: Error
with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using
unique column name using SRID=srid#' Make sure you put in the 'using
unique column name' and 'using SRID=#' clauses in. For more help, please
see http://postgis.refractions.net/documentation/ Mappostgis.c - version
of Jan 23/2004

Removing the quotes works fine and gives a map from the WMS.
Of course removing the quotes in this example is no problem because
there are no odd characters like . and -.
When tablenames do have these characters, the query of course fails.

Are there any workarounds for this problem other than renaming tables to
names without odd characters?
(and yes, I've tried to add using srid = 28992 to the DATA string, but
that doesn't help).
(and yes, I've tried escaping double quotes like DATA 'tc_vlak_geometry
from \nl_imro_0026_svbbu_0001\ using unique geoidn')

Any help greatly appreciated.

MArco

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

Re: [mapserver-users] Postgis data source: quoting table name problem

[DeDuikertjes]

Milo, List,

changing to

DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique geoidn using 
SRID = 28992'

and also 


DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique geoidn using 
srid = 28992'

fails, but:


DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique 
geoidn using SRID=28992'


and

DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique 
geoidn using srid=28992'


both work as it should.

I allready tried things like that before, but apparently got something 
wrong in the details like having spaces around the =


Great, thank you very much.

MArco



Milo van der Linden schreef:

Hello Marco,


If you do not specify ...using unique geoidnd using SRID=28992'
mapserver will search the table for srid information, again sending the
table name in a query to the database as seen in the error message.

I agree that this might be a tiny bug, but it might be a workaround to
define the srid in the DATA clause.

Kind regards,

Milo van der Linden



On Mon, 2009-06-22 at 15:02 +0200, DeDuikertjes wrote:
  

Dear List,

I've extensively searched the archives, saw a couple of more or less
related posts, but couldn't find any solutions for my problem.

In my mapserver application I use postgis as a data source.
In my application the tables containing geometry columns do need to have
odd characters like . and - in their names (for clarity: the table names
that is, not the column names).
Postgis allows this by double qouting the table name in functions,
queries and sql statements.

So in mapserver I like to do that as well as in the following example:

DATA 'tc_vlak_geometry from nl_imro_0026_svbbu_0001 using unique geoidn'

Unfortunately that fails with a message from the WMS:

msDrawMap(): Image handling error. Failed to draw layer named
'geoidNL.IMRO.SVBBU-102-_vlak'. prepare_database(): Query error. Error
executing POSTGIS DECLARE (the actual query) statement: 'DECLARE
mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text
from nl_imro_0026_svbbu_0001 WHERE tc_vlak_geometry 
setSRID('BOX3D(155016 467631,156758 470080)'::BOX3D,
find_srid('','nl_imro_0026_svbbu_0001','tc_vlak_geometry') )'
Postgresql reports the error as 'ERROR: find_srid() - couldnt find the
corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS
table? Is there an uppercase/lowercase missmatch? ' More Help: Error
with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using
unique column name using SRID=srid#' Make sure you put in the 'using
unique column name' and 'using SRID=#' clauses in. For more help, please
see http://postgis.refractions.net/documentation/ Mappostgis.c - version
of Jan 23/2004

Removing the quotes works fine and gives a map from the WMS.
Of course removing the quotes in this example is no problem because
there are no odd characters like . and -.
When tablenames do have these characters, the query of course fails.

Are there any workarounds for this problem other than renaming tables to
names without odd characters?
(and yes, I've tried to add using srid = 28992 to the DATA string, but
that doesn't help).
(and yes, I've tried escaping double quotes like DATA 'tc_vlak_geometry
from \nl_imro_0026_svbbu_0001\ using unique geoidn')

Any help greatly appreciated.

MArco

___
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