you can let postgres calculate the angle for you: DATA "geom FROM (select geom, toid, orientation/10-90 as orientation from cartographictext) as foo USING UNIQUE toid"
and then use angle [orientation] in your label regards, thomas On Fri, Dec 26, 2008 at 18:36, Donald Kerr <[email protected]> wrote: > I am looking for some help if possible. > > I am putting labels on a map and the angle is stored in database field > called "orientation". Orientation is in 10ths of degrees so I need to divide > by 10 to get degrees. I also need to offset by 90 degrees as the number > starts at east, not north. Ideally I would just like to do the following in > the LABEL definition: > > ANGLE (([orientation]/10)-90) > > ... But it doesn't work - getting pink tiles. > > ANGLE [orientation] does work but obviously the labels are NOT at the right > angle. > > Here's the full layer definition: > > LAYER CONNECTIONTYPE postgis > NAME "CartographicText" > CONNECTION "user=postgres dbname=MasterMap host=localhost" > DATA "geom FROM cartographictext USING UNIQUE toid" > STATUS DEFAULT > > MINSCALEDENOM 1 > MAXSCALEDENOM 1300 > > TYPE ANNOTATION > > DEBUG ON > > LABELITEM textstring > CLASS > EXPRESSION ([featurecode] = 10169) > LABEL > TYPE truetype > FONT arial > SIZE 6 > COLOR 0 0 0 > OUTLINECOLOR 255 255 255 > BACKGROUNDCOLOR 255 0 0 > ANTIALIAS TRUE > ANGLE [orientation] > END # LABEL > END # CLASS > END # LAYER > > > Regards, > > Donald > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
