[mapserver-users] Pie chart does not show

[julia paredes]

Hi all I want to create a pie chart for some data. The problem that I'm facing 
is that i'm not getting any errors when I test the layer using shp2img; 
however, I just get a white image. This is my mapfile: MAP EXTENT 
-20037508 -20037508 20037508 20037508 SIZE 400 400 IMAGETYPE 
PNG LAYER NAME "Survey" TYPE CHART CONNECTIONTYPE OGR 
CONNECTION "MSSQL:server=myserver;database=data;uid=me;pwd=key" DATA 
"SELECT Option, COUNT(*) AS RESULT FROM Survey GROUP BY Option" PROCESSING 
"CHART_TYPE=pie" PROCESSING "CHART_SIZE=30" STATUS ON CLASSITEM 
'Option' CLASS EXPRESSION '1' NAME "one" STYLE  
   SIZE [RESULT] COLOR 255 244 237 END END CLASS
 EXPRESSION '2' NAME "two" STYLE SIZE [RESULT] 
COLOR 255 217 191 END END CLASS EXPRESSION '3' 
NAME "three" STYLE SIZE [RESULT] COLOR 255 186 
140 END END CLASS EXPRESSION '4' NAME "Four"
 STYLE SIZE [RESULT] COLOR 255 186 0 END
 END END END Any ideas of what could be missing in my mapfile? Thanks   
 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Pie chart does not show

[thomas bonfort]

Hi,
Not sure what your're trying to obtain, or how to write mssql queries,
but charts work when your data query returns rows that are of the
form:

[geometry,attribute1,attribute2,attribute3,...]

each pie slice is defined with a mapserver CLASS:

CLASS
  NAME "attribute1"
  STYLE
SIZE [attribute1]
COLOR r1 g1 b1
  END
END
CLASS
  NAME "attribute2"
  STYLE
SIZE [attribute2]
COLOR r2 g2 b2
  END
END

--
thomas

On Tue, Jul 3, 2012 at 12:59 AM, julia paredes  wrote:
> Hi all
>
> I want to create a pie chart for some data. The problem that I'm facing is
> that i'm not getting any errors when I test the layer using shp2img;
> however, I just get a white image. This is my mapfile:
>
> MAP
> EXTENT -20037508 -20037508 20037508 20037508
> SIZE 400 400
> IMAGETYPE PNG
> LAYER
> NAME "Survey"
> TYPE CHART
> CONNECTIONTYPE OGR
> CONNECTION "MSSQL:server=myserver;database=data;uid=me;pwd=key"
> DATA "SELECT Option, COUNT(*) AS RESULT FROM Survey GROUP BY Option"
> PROCESSING "CHART_TYPE=pie"
> PROCESSING "CHART_SIZE=30"
> STATUS ON
> CLASSITEM 'Option'
> CLASS
> EXPRESSION '1'
> NAME "one"
> STYLE
> SIZE [RESULT]
> COLOR 255 244 237
> END
> END
> CLASS
> EXPRESSION '2'
> NAME "two"
> STYLE
> SIZE [RESULT]
> COLOR 255 217 191
> END
> END
> CLASS
> EXPRESSION '3'
> NAME "three"
> STYLE
> SIZE [RESULT]
> COLOR 255 186 140
> END
> END
> CLASS
> EXPRESSION '4'
> NAME "Four"
> STYLE
> SIZE [RESULT]
> COLOR 255 186 0
> END
> END
> END
> END
>
>
> Any ideas of what could be missing in my mapfile?
>
> Thanks
>
> ___
> 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