Postgis point table

[Ken Lord]

If the data is not being dynamically generated/updated, I would
suggest that rather than converting the points on the fly every time
you view them, adding overhead to every transaction, that you try the
following ...

If you have access to ArcGIS, there are various free plug-in's
(ETGeowizards for example) you can download that can convert a set of
points into lines.

Or if its not too big of a dataset, use a CAD program to connect the
dots, then import the features back into PostGIS.

Cheers,
Ken Lord
Vancouver BC


On Tue, 23 Nov 2004 12:12:55 +0100, Stéphane RIFF
<stephane.riff at cerene.fr> wrote:
> I have a postgis point table, display GPS coordinate in WGS84.
> It works well with mapserver.
> But now i'd like to show those points in a LINE type layer with mapserver
> but i can't figure how to do it :
> 
> i've tried this in mapfile :
> 
>  DATA
> "geometryfromtext(replace(astext(geomunion(geom)),'MULTIPOINT(','LINESTRING('),4326)
> from <tablename>;"
> 
> but mapserver failed to draw the layer.
> Does somebody already do something like that ???
> Thanks
>