I have a problem that has me stumped. I am trying to place text on a map as a LABEL which I can successfully do with the following code:
LAYER CONNECTIONTYPE postgis NAME "CartographicText" CONNECTION "user=postgres dbname=MasterMap host=localhost" DATA "geom FROM (SELECT toid, featurecode, textstring, orientation/10 AS orientation, fontnumber, anchorposition, textstyle, geom FROM cartographictext) AS foo USING UNIQUE toid" METADATA "IMAGEFORMAT" "AGGA" END STATUS DEFAULT MINSCALEDENOM 1 MAXSCALEDENOM 1300 SYMBOLSCALEDENOM 1250 TYPE ANNOTATION LABELITEM textstring CLASS # Road Name Or Classification EXPRESSION ([featurecode] = 10169) LABEL TYPE truetype FONT arial SIZE 10 MAXSIZE 30 MINSIZE 0 COLOR 0 0 0 ANTIALIAS TRUE ANGLE [orientation] END # LABEL END # CLASS CLASS # Building or Structure Text EXPRESSION ([featurecode] = 10026) LABEL TYPE truetype FONT arial SIZE 7 MAXSIZE 21 MINSIZE 0 COLOR 0 0 0 ANTIALIAS TRUE ANGLE [orientation] END # LABEL END # CLASS END # LAYER I want to add POSITION based on [anchorposition] from the database. The database grid for anchorposition is as follows: 2 5 8 1 4 7 0 3 6 Whereas MapServer is as follows ul uc ur cl cc cr ll lc lr Which is probably: 0 1 2 3 4 5 6 7 8 The question is: Is it possible to take the values from the database and convert them for use within the LABEL e.g. 2 = ul = "POSITION ul" or 5 = uc = "POSITION uc"? I would also like to be able to change the Font based on [fontnumber] from the database e.g. 0 = Arial = "FONT arial" or 1 = Times = "FONT times" Are these things possible? Many thanks. Regards, Donald Kerr _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users