Yes, that particular ID should return a name of "Madison". Also, I attempted
to use acres and that column also has a value. I have labeled layers that
have come from shapefiles in nearly the same manner (minus the postgis
connection), and their labels print properly.
Paul Ramsey-3 wrote:
>
> You're restricting your result to field_in of 50204. Does that record
> have values for the field_name?
>
> On Jun 23, 2008, at 2:07 PM, osprey44 wrote:
>
>>
>> I have a particular layer in which I cannot seem to display the
>> labels. The
>> shape displays correctly. I have tried multiple columns to use as the
>> label, but all do not show. Below is the specific chunk of the map
>> file:
>>
>> LAYER
>> NAME "field"
>> TYPE POLYGON
>> STATUS ON
>> CONNECTION "user=web password=apacheweb08 dbname=base_dev
>> host=localhost
>> port=5432"
>> CONNECTIONTYPE postgis
>> DATA "field_boundary from (select fb.field_id as field_id,
>> fb.field_id as
>> OID, fb.field_boundary as field_boundary, fb.acres as acres,
>> f.field_name as
>> field_name from field_boundary fb, fields f where
>> fb.field_id=f.field_id) as
>> field_boundary"
>> FILTER "field_id in ('50204')"
>> LABELITEM "field_name"
>> CLASS
>> STYLE
>> OUTLINECOLOR 255 0 0
>> COLOR -1 -1 -1
>> WIDTH 3
>> END
>> LABEL
>> TYPE TRUETYPE
>> FONT arial
>> SIZE 10
>> ANTIALIAS TRUE
>> COLOR 0 0 0
>> OUTLINECOLOR 0 0 0
>> POSITION AUTO
>> END
>> END
>> PROJECTION
>> "init=epsg:4326"
>> END
>> DEBUG ON
>> END
>> http://www.nabble.com/file/p18078514/fieldMap.jpg
>> --
>> View this message in context:
>> http://www.nabble.com/No-Labels-on-PostGIS-Layer-tp18078514p18078514.html
>> Sent from the Mapserver - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> mapserver-users mailing list
>> [email protected]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
> --
> Paul Ramsey
> [EMAIL PROTECTED]
> +1 250 885 0632
>
> _______________________________________________
> mapserver-users mailing list
> [email protected]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
--
View this message in context:
http://www.nabble.com/No-Labels-on-PostGIS-Layer-tp18078514p18079028.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
