On Feb 20, 2012, at 4:44 PM, Puneet Kishor wrote:
> I have a kml with a bunch of styles to color polygons. Is there a quick/easy
> way to extract them and convert them to MapServer layer classification rules?
>
the above actually turned out to be a lot easier than I thought... about 4
lines of Perl.
Now, I have a table with geometry, and colors for each feature.
CREATE TABLE t (attr, hex_color, the_geom);
How can I color the polys in the layer with the hex_color values? Looking at
the map file docs, I came up with something like so
LAYER
NAME "foo"
DATA "the_geom FROM (SELECT gid, rgb(hex_color) AS rgb_color, the_geom
FROM t) tmp USING UNIQUE gid USING srid=4326"
STATUS ON
TYPE POLYGON
CLASS
STYLE
COLOR [rgb_color]
OUTLINECOLOR 68 68 68
END
END
END
END
where rgb() converts "hex_color" to a string of RGB triplets. So, "000000"
becomes "0 0 0".
Is the above correct? For now, it doesn't seem to be working for me.
Many tia,
--
Puneet Kishor_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
