Re: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change occurs up too high in the hierarchy of Mapfile

2014-12-15 Thread Basques, Bob (CI-StPaul) 
New issue added.

Bobb



From: Lime, Steve D (MNIT)
Sent: Monday, December 15, 2014 4:09 PM
To: Basques, Bob (CI-StPaul)
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

Looking at the code it's definitely a bug. The configuration updater doesn't 
take into account styles within a label so it applies the snippet you send to 
the label object. If your snippet contained reference to an attribute a  label 
doesn't support then you'd get a parsing error. Because 'color' is supported by 
both it happily changes the wrong color. Can you file a ticket?

Steve


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

Re: [mapserver-users] [EXTERNAL] Re: Postgres SQL oddity . . .

2014-12-15 Thread Smith, Michael ERDC-RDE-CRREL-NH 
Bob,

If you want to keep * in the select, you have to alias the table name and add 
that to the *.

Eg,
DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
L.*
from
Loc l
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

From: , "Bob (CI-StPaul)" 
mailto:bob.basq...@ci.stpaul.mn.us>>
Date: Monday, December 15, 2014 at 5:07 PM
To: "Rahkonen Jukka (Tike)" 
mailto:jukka.rahko...@mmmtike.fi>>, 
"mapserver-users@lists.osgeo.org" 
mailto:mapserver-users@lists.osgeo.org>>
Subject: [EXTERNAL] Re: [mapserver-users] Postgres SQL oddity . . .
Resent-From: Michael Smith 
mailto:michael.sm...@usace.army.mil>>

Vname is NOT distinct in the data table.

I got the SQL to pass by dropping the “ * “ from the SQL, but ran into a 
different problem, how to run a logical expression against a POSTGRES call, 
looks like it only works with SHP files.  Crap!!

Bobb



From: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi]
Sent: Monday, December 15, 2014 4:01 PM
To: Basques, Bob (CI-StPaul); 
mapserver-us...@osgeo.org
Subject: Re: Postgres SQL oddity . . .


Hi,



If vname is unique in your table, why do you need to do "select distinct" on it?

I would make a blind guess with an alias name select distinct on (vname) 
vname_distinct



Usually it is not as easy, though



-Jukka Rahkonen-






Basques, Bob wrote:

> I'm trying to display a set of GPS points from a layer in Postrgres . . .

> Getting this error however:

http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsd">
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference "vname" is ambiguous
LINE 1: select "elapsed_min","vname",encode(ST_AsBinary(ST_Force2D("...



from this Call:

DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb

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

Re: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change occurs up too high in the hierarchy of Mapfile

2014-12-15 Thread Basques, Bob (CI-StPaul) 
Will do.

bobb

From: Lime, Steve D (MNIT)
Sent: Monday, December 15, 2014 4:09 PM
To: Basques, Bob (CI-StPaul)
Cc: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

Looking at the code it's definitely a bug. The configuration updater doesn't 
take into account styles within a label so it applies the snippet you send to 
the label object. If your snippet contained reference to an attribute a  label 
doesn't support then you'd get a parsing error. Because 'color' is supported by 
both it happily changes the wrong color. Can you file a ticket?

Steve


From: Basques, Bob (CI-StPaul)
Sent: Monday, December 15, 2014 10:53 AM
To: Lime, Steve D (MNIT)
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

V6.4.1



From: Lime, Steve D (MNIT)
Sent: Monday, December 15, 2014 10:50 AM
To: Basques, Bob (CI-StPaul); 
mapserver-us...@osgeo.org
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

Which version are you running?

From: 
mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Basques, Bob 
(CI-StPaul)
Sent: Saturday, December 13, 2014 9:35 PM
To: mapserver-us...@osgeo.org
Subject: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change 
occurs up too high in the hierarchy of Mapfile

All,

Using this CGI fragment:

. . .?map_layer[Points].class[0].LABEL[0].STYLE[0]=color+0+255+0& . . .

and I'm trying to set the color in this mapfile fragment inside of the STYLE 
(inside of the LABEL bloc):

NAME "GPS History"
TEXT "[seq]"
LABEL
#   OUTLINECOLOR 255 255 255
COLOR 255 255 254
FONT "arial-bold"
TYPE truetype
SIZE 9
POSITION cc
#PARTIALS false
FORCE true
STYLE
GEOMTRANSFORM  labelpoly
COLOR 255 0 0
#OUTLINECOLOR  0 0 0
OUTLINECOLOR 0 0 0
WIDTH 1
END
END

The change is occurring however at the COLOR value in the LABEL (text-color), 
not at the STYLE level (background polygon color).  I assume this is something 
that hasn't been run into by anyone since the background label polys were 
implemented, and there being two different levels where the COLOR value can be 
set inside a single code block, or am I missing something?

Thanks


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

Re: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change occurs up too high in the hierarchy of Mapfile

2014-12-15 Thread Lime, Steve D (MNIT) 
Looking at the code it's definitely a bug. The configuration updater doesn't 
take into account styles within a label so it applies the snippet you send to 
the label object. If your snippet contained reference to an attribute a  label 
doesn't support then you'd get a parsing error. Because 'color' is supported by 
both it happily changes the wrong color. Can you file a ticket?

Steve


From: Basques, Bob (CI-StPaul)
Sent: Monday, December 15, 2014 10:53 AM
To: Lime, Steve D (MNIT)
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

V6.4.1



From: Lime, Steve D (MNIT)
Sent: Monday, December 15, 2014 10:50 AM
To: Basques, Bob (CI-StPaul); 
mapserver-us...@osgeo.org
Subject: RE: [mapserver-users] BUG (??) in CGI variable substitution. COLOR 
change occurs up too high in the hierarchy of Mapfile

Which version are you running?

From: 
mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Basques, Bob 
(CI-StPaul)
Sent: Saturday, December 13, 2014 9:35 PM
To: mapserver-us...@osgeo.org
Subject: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change 
occurs up too high in the hierarchy of Mapfile

All,

Using this CGI fragment:

. . .?map_layer[Points].class[0].LABEL[0].STYLE[0]=color+0+255+0& . . .

and I'm trying to set the color in this mapfile fragment inside of the STYLE 
(inside of the LABEL bloc):

NAME "GPS History"
TEXT "[seq]"
LABEL
#   OUTLINECOLOR 255 255 255
COLOR 255 255 254
FONT "arial-bold"
TYPE truetype
SIZE 9
POSITION cc
#PARTIALS false
FORCE true
STYLE
GEOMTRANSFORM  labelpoly
COLOR 255 0 0
#OUTLINECOLOR  0 0 0
OUTLINECOLOR 0 0 0
WIDTH 1
END
END

The change is occurring however at the COLOR value in the LABEL (text-color), 
not at the STYLE level (background polygon color).  I assume this is something 
that hasn't been run into by anyone since the background label polys were 
implemented, and there being two different levels where the COLOR value can be 
set inside a single code block, or am I missing something?

Thanks


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

Re: [mapserver-users] Postgres SQL oddity . . .

2014-12-15 Thread Basques, Bob (CI-StPaul) 
Ahh, fixed it.  Mapserver doesn't like the ' * ' in the SQL , at least not on 
the end . . . hmm, I wonder if it needs (should be)  to be escaped in a 
subquery??  I took that out and added in a couple of key columns I needed . . .

This works now:

DATA "the_geom from (

select
distinct on (vname) vname,
  the_line as the_geom,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min  -- Compiled minutes 
since last major move of asset.
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

Bobb



From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Basques, Bob 
(CI-StPaul)
Sent: Monday, December 15, 2014 3:48 PM
To: mapserver-us...@osgeo.org
Subject: [mapserver-users] Postgres SQL oddity . . .

I'm trying to display a set of GPS points from a layer in Postrgres . . .

Getting this error however:

http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsd">
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference "vname" is ambiguous
LINE 1: select "elapsed_min","vname",encode(ST_AsBinary(ST_Force2D("...



from this Call:

DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb

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

Re: [mapserver-users] Postgres SQL oddity . . .

2014-12-15 Thread Basques, Bob (CI-StPaul) 
Vname is NOT distinct in the data table.

I got the SQL to pass by dropping the " * " from the SQL, but ran into a 
different problem, how to run a logical expression against a POSTGRES call, 
looks like it only works with SHP files.  Crap!!

Bobb



From: Rahkonen Jukka (Tike) [mailto:jukka.rahko...@mmmtike.fi]
Sent: Monday, December 15, 2014 4:01 PM
To: Basques, Bob (CI-StPaul); mapserver-us...@osgeo.org
Subject: Re: Postgres SQL oddity . . .


Hi,



If vname is unique in your table, why do you need to do "select distinct" on it?

I would make a blind guess with an alias name select distinct on (vname) 
vname_distinct



Usually it is not as easy, though



-Jukka Rahkonen-






Basques, Bob wrote:

> I'm trying to display a set of GPS points from a layer in Postrgres . . .

> Getting this error however:

http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsd">
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference "vname" is ambiguous
LINE 1: select "elapsed_min","vname",encode(ST_AsBinary(ST_Force2D("...



from this Call:

DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb

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

Re: [mapserver-users] Postgres SQL oddity . . .

2014-12-15 Thread Rahkonen Jukka (Tike) 
Hi,


If vname is unique in your table, why do you need to do "select distinct" on it?

I would make a blind guess with an alias name select distinct on (vname) 
vname_distinct


Usually it is not as easy, though


-Jukka Rahkonen-





Basques, Bob wrote:

> I'm trying to display a set of GPS points from a layer in Postrgres . . .

> Getting this error however:

http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsd";>
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference "vname" is ambiguous
LINE 1: select "elapsed_min","vname",encode(ST_AsBinary(ST_Force2D("...



from this Call:

DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb


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

[mapserver-users] Postgres SQL oddity . . .

2014-12-15 Thread Basques, Bob (CI-StPaul) 
I'm trying to display a set of GPS points from a layer in Postrgres . . .

Getting this error however:

http://www.opengis.net/ogc 
http://schemas.opengis.net/wms/1.3.0/exceptions_1_3_0.xsd";>
msDrawMap(): Image handling error. Failed to draw layer named 'AVL_Plot_00to96'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:  column 
reference "vname" is ambiguous
LINE 1: select "elapsed_min","vname",encode(ST_AsBinary(ST_Force2D("...



from this Call:

DATA "the_geom from (

select
distinct on (vname) vname,
st_length(st_transform(the_line, 26993)) as 
feet,
(DATE_PART('day', now() - acqtime) * 24 +
DATE_PART('hour', now() - acqtime) * 60 
+
DATE_PART('minute', now() - acqtime)
) as elapsed_min,  -- Compiled minutes 
since last major move of asset.
*
from
loc
where
st_length(st_transform(the_line, 26993)) > 30  
-- GPS error
order by
vname desc

) as subquery using unique vname using 
srid=200068"

What I don't understand is how VNAME can be ambiguous when calling only one 
table (loc)??  The SQL works fine in PGADMIN.   Does the using unique vname 
have something to do with the problem, which seems to be required.

Help??

Thanks.

bobb


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

Re: [mapserver-users] RoadMap for MapServer

2014-12-15 Thread Lime, Steve D (MNIT) 
The changes for that pull request look to be pretty modest. Have you tried 
creating a patch and applying to the 6.4 branch?

From: Gregor Karzelek [mailto:gregor.karze...@heller-ig.com]
Sent: Wednesday, December 10, 2014 2:30 AM
To: Lime, Steve D (MNIT); Mapserver-users
Subject: Re: RoadMap for MapServer

Hi Steve,

Thanks for the info.
The feature we would like to use most is: 
https://github.com/mapserver/mapserver/pull/4877 so that we can use runtime 
substitution in WEB->METADATA.


Gregor


Gregor Karzelek
Systemarchitekt
HELLER Ingenieurgesellschaft mbH
Otto-Hesse-Straße 19 / T9
64293 Darmstadt
Tel.: +49 6151 66846-16
Fax: +49 6151 66846-22
E-Mail: gregor.karze...@heller-ig.com
Internet: www.heller-ig.com
Geschäftsführer: Dipl.-Ing. Henning Balck, Dipl.-Ing. Christian Komma
Handelsregister: Amtsgericht Darmstadt HRB 8310
Ust.-Ident.-Nr.: DE 217 293 137


Am 09.12.2014 um 20:51 schrieb Lime, Steve D (MNIT) 
mailto:steve.l...@state.mn.us>>:

The 7.0 release documents are pretty thin. The plan was to release this past 
summer but it’s dragged on much longer than I’d hoped (my fault). I’m still 
hoping you’ll see a beta in the next couple of weeks. What feature in 
particular are you waiting on?

Steve

From: 
mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Gregor Karzelek
Sent: Tuesday, December 09, 2014 8:57 AM
To: Mapserver-users
Subject: [mapserver-users] RoadMap for MapServer

HI,

Is there somewhere a roadmap for MapServer available?
The last stable version released is 6.4.1 from January this year and since then 
a feature was implemented we would really like to use.
But, as it is a „live“ system, we would like to use a stable, officially 
released version of MapServer and no self-compiled.


Best regards
Gregor Karzelek


Gregor Karzelek
Systemarchitekt
HELLER Ingenieurgesellschaft mbH
Otto-Hesse-Straße 19 / T9
64293 Darmstadt
Tel.: +49 6151 66846-16
Fax: +49 6151 66846-22
E-Mail: gregor.karze...@heller-ig.com
Internet: www.heller-ig.com
Geschäftsführer: Dipl.-Ing. Henning Balck, Dipl.-Ing. Christian Komma
Handelsregister: Amtsgericht Darmstadt HRB 8310
Ust.-Ident.-Nr.: DE 217 293 137

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

Re: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change occurs up too high in the hierarchy of Mapfile

2014-12-15 Thread Lime, Steve D (MNIT) 
Which version are you running?

From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Basques, Bob 
(CI-StPaul)
Sent: Saturday, December 13, 2014 9:35 PM
To: mapserver-us...@osgeo.org
Subject: [mapserver-users] BUG (??) in CGI variable substitution. COLOR change 
occurs up too high in the hierarchy of Mapfile

All,

Using this CGI fragment:

. . .?map_layer[Points].class[0].LABEL[0].STYLE[0]=color+0+255+0& . . .

and I'm trying to set the color in this mapfile fragment inside of the STYLE 
(inside of the LABEL bloc):

NAME "GPS History"
TEXT "[seq]"
LABEL
#   OUTLINECOLOR 255 255 255
COLOR 255 255 254
FONT "arial-bold"
TYPE truetype
SIZE 9
POSITION cc
#PARTIALS false
FORCE true
STYLE
GEOMTRANSFORM  labelpoly
COLOR 255 0 0
#OUTLINECOLOR  0 0 0
OUTLINECOLOR 0 0 0
WIDTH 1
END
END

The change is occurring however at the COLOR value in the LABEL (text-color), 
not at the STYLE level (background polygon color).  I assume this is something 
that hasn't been run into by anyone since the background label polys were 
implemented, and there being two different levels where the COLOR value can be 
set inside a single code block, or am I missing something?

Thanks


bobb

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