[Mapserver-users] store and draw route

[Alexandros Chimarios]

Dont think so that you can query them as a LINE .... but alternatively you may 
create a new table or view and using PL/SQL you can define a script of making 
those lines from points stored in your db.


On Thursday 03 June 2004 09:53, Fu Chen wrote:
> yes, I really wanna use this solution.
> But we store the route in several discrete point not a native LINE. Is
> there some method to query this points out as a LINE geometry element?
>
>
> -----Original Message-----
> From: mapserver-users-admin at lists.gis.umn.edu
> [mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Alexandros
> Chimarios
> Sent: Thursday, June 03, 2004 2:36 PM
> To: Fu Chen; mapserver-users at lists.gis.umn.edu
> Subject: Re: [Mapserver-users] store and draw route
>
>
> Storing the workers track in a Postgis enabled Postgres database and
> defining a leayer in your map file of  data type LINE may solve your
> problem.
>
> On Thursday 03 June 2004 04:44, Fu Chen wrote:
> > Hi!
> > I try to use mapserver and postgis to record and render the some mobile
> > worker's route. Those routes are record by a data table like (workorID,
> > time, position). In the webgis interface, we try to draw a route map by
> > mapserver.
> > Queried by the workor's ID, the position is sort by the time. then these
> > points is linked with a line. We would like to draw a circle(or other
> > symbol) on the key point if it is possible. I don't know how to write map
> > file or mapscript to get the feature. Anybody can give me some
> > suggestion? Thank you!
> >
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users