problem with annotation and postgis grouped road names...

[John Cole]

Hello,
  I'm still having some problems getting an annotation layer to draw using
grouped road names.  Drawing all of the roads is quick but cluttered.
Drawing the grouped road names does not return an error but it doesn't draw
any labels either.  My data is tiger roads from the ESRI website.

I'm attaching a jpg of the two statements.

Here is my layer statement:

LAYER
	NAME Highways_anno
	STATUS default
	GROUP roads
	CONNECTIONTYPE postgis
	CONNECTION "user=mapserver password=mapserver dbname=florence
host=localhost" 
	#DATA "the_geom from tgr_roads" # roads.jpg
	DATA "the_geom FROM (SELECT collect(the_geom) AS the_geom, rd_name
FROM tgr_roads GROUP BY rd_name) AS new_table USING UNIQUE rd_name USING
SRID=-1" # grouped_names.jpg
	TYPE annotation
	LABELITEM "rd_name"
	MAXSCALE 12000

	CLASS
		LABEL
			COLOR 0 0 0
			TYPE TRUETYPE
			ANGLE AUTO
			FONT arial
			SIZE 8
			ANTIALIAS TRUE
			POSITION CC
			MINDISTANCE 10
			BUFFER 5
		END
	END
END

This is postgis 1.0.1 and mapserver 4.4 and 4.6.

Any help would be appreciated.

Thanks,

John Cole


-------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: grouped_names.jpg
Type: image/jpeg
Size: 8005 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050621/b2b070a6/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: roads.jpg
Type: image/jpeg
Size: 22698 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050621/b2b070a6/attachment-0001.jpg>