: RE: [mapserver-users] Plotting points as a line from sqlite
database
Ian,
Take a look at 2.4.0-RC5
http://www.gaia-gis.it/spatialite-2.4.0-5/spatialite-sql-2.4-5.html#p5
Look under "SQL utility functions [non-standard] for geometric objects"
David.
-Original Message-
From: I
y 28, 2011 12:41 PM
To: Fawcett, David (MPCA); Stephen Woodbridge; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Plotting points as a line from sqlite database
Gents,
Thanks for these ideas, however I cannot seem to find a MakeLine
function in spatialite 2.4.0.
Where should I
(MPCA)
Sent: Thursday, June 30, 2011 6:44 AM
To: Stephen Woodbridge; mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] Plotting points as a line from sqlite
database
ST_MAKELINE() does exist in recent versions of Spatialite.
It doesn't appear to have made it in to the docs, but i
Assuming you are using something like Openlayers as the client you
could use json to return the data pts formatted as a linestring. This
would give you better options to show attribute data as a popup etc.
like in the example
http://openlayers.org/dev/examples/vector-formats.html
On Wed, Jun
-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge
Sent: Wednesday, June 29, 2011 10:49 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Plotting points as a line from sqlite database
On 6/29/2011 10:13 PM, Ian Walberg wrote:
> I hope this isn't too stup
On 6/29/2011 10:13 PM, Ian Walberg wrote:
I hope this isn't too stupid a question.
Would like to display a list of positions in an sqlite database as a
line, to show the flight path of an aircraft. The data is in the db as
Lat, Long and point (lat, long)
We can display the positions as individu