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.
All,
Made some progress:
select
row_number
[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 postgres.
I've done something similar.
I don't have
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
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
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,
