(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 it can
: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 be looking
: 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: Ian Walberg
...@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 stupid a question.
Would
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
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 individual dots but not as a line, I
fear the
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