Yup,

> LAYER
>   CONNECTIONTYPE postgis
>   NAME "roads"
>   CONNECTION "user=postgres dbname=ca_hwy host=localhost"
>   DATA "the_geom FROM (SELECT roads.oid AS oid, roads.the_geom AS
> the_geom, roads.fename AS fename FROM roads) AS named_roads USING UNIQUE
> oid USING SRID=-1"
>   STATUS ON
>   TYPE LINE
>   LABELITEM fename
>   CLASS
>     SIZE 2
>     COLOR 0 0 0
>     LABEL
>       POSITION auto
>       ANGLE follow
>       SHADOWCOLOR 120 255 120
>       SHADOWSIZE 1 1
>       SIZE 8
>       COLOR 0 192 0
>       FONT sans-bold
>       TYPE truetype
>       BUFFER 4
>       MINDISTANCE 200
>       ANTIALIAS TRUE
>     END
>   END
> END

-Steve W

Jeshua Lacock wrote:

Greetings,

I am working on a tutorial for MapServer using a Postgis backend, and I just want to check if I am setting a correct example. This is my first .map file so please forgive me for my noob question.

Is there a way to have text labels and lines on the same layer? Instead of two Postgis queries, I was wondering if it is possible to do with a single query.

Here is the pertinent portion of my .map files:

LAYER
  CONNECTIONTYPE postgis
  NAME "roads"
  CONNECTION "user=postgres dbname=ca_hwy host=localhost"
DATA "the_geom FROM (SELECT roads.oid AS oid, roads.the_geom AS the_geom, roads.fename AS fename FROM roads) AS named_roads USING UNIQUE oid USING SRID=-1"
  STATUS ON
  TYPE ANNOTATION
  LABELITEM fename
  CLASS
    LABEL
      POSITION auto
      ANGLE follow
      SHADOWCOLOR 120 255 120
      SHADOWSIZE 1 1
      SIZE 8
      COLOR 0 192 0
      FONT sans-bold
      TYPE truetype
      BUFFER 4
      MINDISTANCE 200
      ANTIALIAS TRUE
    END
  END
END

LAYER
  CONNECTIONTYPE postgis
  NAME "roads"
  CONNECTION "user=postgres dbname=ca_hwy host=localhost"
  DATA "the_geom FROM roads USING UNIQUE oid USING SRID=-1"
  STATUS ON
  TYPE LINE
  CLASS
    SIZE 2
    COLOR 0 0 0
  END
END


Thanks,

Jeshua Lacock, Owner
<http://OpenOSX.com>
phone: 877.240.1364

_______________________________________________
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

Reply via email to