[MAPSERVER-USERS] No Labels on PostGIS Layer

[Paul Ramsey]

Work it back to basics. Does it work without the join? There's nothing
obviously wrong with your map entry, that I can eyeball.

P

On Mon, Jun 23, 2008 at 2:35 PM, osprey44 <haak at agintegrated.com> wrote:
>
> 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
>>> mapserver-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>>
>> --
>> Paul Ramsey
>> pramsey at cleverelephant.ca
>> +1 250 885 0632
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>