[mapserver-users] Different color for each row and it's child

Mon Sep 15 13:38:50 PDT 2008

Sharing the snippet of mapfile would help...

Steve

>>> On 9/15/2008 at 3:35 PM, in message
<944DCD961F4CD649BCEBB52E3C929F650270805A at usd-am-xch-01.am.trimblecorp.net>,
"Lee Keel" <lee_keel at trimble.com> wrote:
> David,
> 
>  
> 
> Thanks for the reply, but I can't seem to get this to work.  When I
> change my mapfile to use this new attribute column, that layer (and most
> all my others) go away and I get this as the response in FF:
> 
>  
> 
> <HTML>
> 
>  
> 
> <HEAD><TITLE>MapServer Message</TITLE></HEAD>
> 
>  
> 
> <!-- MapServer version 5.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
> OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT
> 
>  
> 
> =SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
> SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> 
>  
> 
>  SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
> SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS
> 
>  
> 
> =GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE -->
> 
>  
> 
> <BODY BGCOLOR="#FFFFFF">
> 
>  
> 
> getSymbol(): Symbol definition error. Parsing error near
> (symcolor):(line 1684)
> 
>  
> 
> </BODY></HTML>
> 
>  
> 
> I added the column to my query and add that column name, in [] to my
> class item.  Is there something that I am missing?  
> 
>  
> 
> Please note:  I have looked at the
> http://mapserver.gis.umn.edu/development/rfc/ms-rfc-19/ page and I think
> I understand what is required.  But now I am thinking that this is not
> in MS4W 2.2.6.  Can anyone answer if that is the case?  And if so, is
> there another solution like this around that version?
> 
>  
> 
> Thanks in advance,
> 
> Lee
> 
>  
> 
> From: Fawcett, David [mailto:David.Fawcett at state.mn.us] 
> Sent: Monday, September 15, 2008 9:51 AM
> To: Lee Keel; mapserver-users at lists.osgeo.org 
> Subject: RE: [mapserver-users] Different color for each row and it's
> child
> 
>  
> 
> I would suggest creating a column in table A to store a color value and
> pre-populating it.  You would want to store the RGB triplet (e.g. '255 0
> 0').  I assume that you could have some sort of a stored proc that gets
> triggered when a new record gets added.  
> 
>  
> 
> Using the new attribute binding in MapServer 5, you could then just set
> the feature color by specifying the column name in the style in your map
> file layer definition.  
> 
>  
> 
> Something like:
> 
>  
> 
> STYLE
> 
>    COLOR [myColorColumn]
> 
>    OUTLINECOLOR 0 0 0
> 
> END
> 
>  
> 
> As soon as someone kicks the MapServer site server and it restarts, I
> suggest looking at the map file reference document under style.  
> 
>  
> 
> Also, make sure that your color column is specified in the query in your
> data statement.  
> 
>  
> 
> David.
> 
> 	-----Original Message-----
> 	From: mapserver-users-bounces at lists.osgeo.org 
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Lee Keel
> 	Sent: Monday, September 15, 2008 9:33 AM
> 	To: mapserver-users at lists.osgeo.org 
> 	Subject: [mapserver-users] Different color for each row and it's
> child
> 
> 	I had a client request something that sounds really cool, but I
> don't know how to do it (or if it is even possible in mapserver).
> 
> 	 
> 
> 	First, my setup:
> 
> 	I am running MS4W 2.6 on windows xp against postgis 8.2
> database.  I have table A that has anywhere from 4 to 35 rows.  And
> table B which could have several hundred rows each relating back to one
> of the rows from table A.
> 
> 	 
> 
> 	For Example:
> 
> 	TableA
> 
> 	 
> 
> 	ID                            Name
> 
> 	1                                             t
> 
> 	2                                             t2
> 
> 	3                                             t3
> 
> 	4                                             t4
> 
> 	 
> 
> 	 
> 
> 	TableB
> 
> 	ID            ta_id                      Value
> 
> 	1              1                              something
> 
> 	2              1                              something else
> 
> 	3              1                              test
> 
> 	4              2                              foo
> 
> 	5              2                              bar
> 
> 	6              3                              done
> 
> 	 
> 
> 	Now my problem:
> 
> 	The client would like to see all the rows rendered from tableA
> as different colors.  These colors can be random, it doesn't matter.  On
> top of this, they want to see all the associated rows in tableB as the
> same color as their parent from tableA.
> 
> 	 
> 
> 	Can I add a column to tableA and use that as a value in the
> mapfile for the style?  And if so, how?
> 
> 	 
> 
> 	I would greatly appreciate any help that anyone can provide.
> 
> 	 
> 
> 	Thanks in advance,
> 
> 	Lee