[postgis-users] RE: [Geoserver-users] Time series in postGIS?

[Stephen Crawford]

Andrea,

Is there a good way to define the view so that the dates, which are rows in
the normal table, become columns in the view, and also that the view is
always updated with the most recent date?  What I hope to have is a feature
layer on Geoserver where a GetFeature request will always return the entire
"year to date" without having to use a filter.

Thanks Again,
Steve



-----Original Message-----
From: geoserver-users-bounces at lists.sourceforge.net
[mailto:geoserver-users-bounces at lists.sourceforge.net] On Behalf Of Andrea
Aime
Sent: Tuesday, May 08, 2007 5:00 PM
To: Stephen Crawford
Cc: geoserver-users at lists.sourceforge.net; 'PostGIS Users Discussion'
Subject: Re: [Geoserver-users] Time series in postGIS?

Stephen Crawford ha scritto:
> All,
> 
> I have a question on setting up a postGIS database for use with 
> geoserver; please pardon the double-posting but I wasn't sure where I
should send it.
> 
> I have created quite a few postGIS/geoserver services already, but I 
> haven't yet had a "dynamic" one like this.  I have a set of point 
> locations for which data will be collected daily.  In a "normal" 
> (non-spatial) database I would just have a table with columns for 
> siteID,date,value where siteID and date make up the primary key. But 
> to use with geoserver, it seems like I need to have a row for each 
> location, where the columns are the date, like
> this:
> siteID,date_1,date_2,date_3,.......
> 
> What's the best way to do this?  I plan to use a GetFeature WFS 
> request with geoserver, and would like get all the dates/values back 
> for each location so my client can "animate" through time.

Hum, I would model the database in normal form (as you described in the
first sample) and then build views joining the site and data table, and
register it against the geometry colums so that Geoserver can view that as a
table.
Then use a filter to show the situation at a given time. Hope this helps
Cheers Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the
FREE version of DB2 express and take control of your XML. No limits. Just
data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users