_
From: mapserver-users-boun...@lists.osgeo.org
[mapserver-users-boun...@lists.osgeo.org] on behalf of Worth Lutz
[w...@mindspring.com]
Sent: Tuesday, December 02, 2014 4:00 PM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] An interesting SQL linestring building problem
from po
:00'
group by
vname, acqtime
order by
acqtime
From: Basques, Bob (CI-StPaul)
Sent: Wednesday, December 03, 2014 10:06 PM
To: mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] An interesting SQL linestring building problem
from postgres.
Al
I've done something similar.
I don't have it in front of me at the moment but a postgres select can
do this.
Look in Postgres for "window" and "row_number".
You use the postgres "OVER" clause to group the items and then
row_number to get a key for color.
SELECT
a,
b,
c,
ro
On 12/2/2014 2:56 PM, Basques, Bob (CI-StPaul) wrote:
All,
I have a bunch of individual LINE segments in Postgres and want to
display them via MapServer like so:
First:
·Get a chunk of them based on a set of IDs (a set of three for example)
and a begin/end timestamp (got this figured out alr
All,
I have a bunch of individual LINE segments in Postgres and want to display them
via MapServer like so:
First:
* Get a chunk of them based on a set of IDs (a set of three for
example) and a begin/end timestamp (got this figured out already)
* Take the result and combine