[mapserver-users] displaying line starting and ending points

José María Michia jose.maria.michia at gmail.com
Wed Dec 10 09:44:00 EST 2008


Hello,

2008/12/10 Raivo Alla <snaperski at gmail.com>:
> Hello,
>
> I have a question concerning how to draw starting and ending points of
> line features.
> One option is to create a separate points layer in ArcGIS, where all
> the starting and ending points of lines are in.
> But is' t there some better solution or workaround how to get things done ?

Using "Postgis" as data store, let you get the start and end points
from line geometry with something like:

DATA "geom from (SELECT oid,StartPoint(the_geom) FROM line_layer) as
foo using unique oid using SRID=-1"

And for end points:

DATA "geom from (SELECT oid,EndPoint(the_geom) FROM line_layer) as foo
using unique oid using SRID=-1"

See:

http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2572496

I do not know ArcGIS. Maybe there is something similar to this.

Saludos
José María

>
>
> Humbly yours,
> Raivo
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>


More information about the mapserver-users mailing list