[mapserver-users] Plotting points as a line from sqlite database

Mark Korver mark at spatialcloud.com
Thu Jun 30 09:59:02 EDT 2011


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 29, 2011 at 9:13 PM, Ian Walberg <ian.walberg at airborne.aero> 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 individual dots but not as a line, I
> fear the problem is that the data is a point.
>
> As the data is being accumulated we would prefer not to create a new
> line in the database each time if possible.
>
> Any suggestions to what options we have would be appreciated.
>
> Thanks
>
> Ian
> _______________________________________________
> 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