Hi Rick - > Use case 1: I'm mapping a series of model results (Runoff Risk Advisory > Forecast). For each of the days of the forecast (today, tomorrow, day after > that) I have a layer defined, each with its own table; the one you see on > the page is chosen by the radio buttons to the upper right. Every day a big > script chugs through our forecast intake and updates the "three_day_risk" > and "snowmelt" columns for each polygon in each of the three tables. Just > for reference, the tables each look like this: > Column | Type | Modifiers > ------------------------+-----------------------+----------- > gid | integer | not null > the_geom | geometry | not null > name | character varying(65) | not null > descriptio | character varying(81) | > three_day_risk | integer | > ten_day_snowmelt_alert | integer | > > What I would like to do is be able to easily map any day's model results. > When I'm setting up a layer in GeoServer, I have to point it at a table, not > at a query, so the dataset is pretty much fixed at that point.
I think I can answer this use case - can you not just use CQL filters? e.g. you could use the filter "validstart DURING 2006-11-30T01:30:00Z/2006-12-31T01:30:00Z" The syntax is explained here: http://docs.geotools.org/latest/userguide/library/cql/cql.html > Use case 2: I have a bunch of other datasets that are 3D, i.e. they are lat, > lon, time, with nice square pixels. Seems a natural for a raster, except > that I want to store the values in a database, not in an ever-expanding > cloud of GeoTIFF files. (I have to do other things with the data besides > mapping them.) We're using PostGIS right now, and I hope I don't offend > anyone by saying that raster support for PostGIS seems like fusion power, > it's always just around the corner. Can I make it work today? And does > [insert workable PostGIS raster implementation here] allow me to easily > query the data as data, without a ton of rigamarole? For example, I'd like > to say "give me the time series of values for the pixel at [lat,lon] between > April 1 and June 30 2011". > Thanks (as always!) for your knowledgeable assistance, Can't answer this one though - if you find a solution to this please let me know! I believe there's a plugin for NetCDF (i.e. lovely 3d raster standard) for GeoTools but I don't think this has been integrated with Geoserver. Best, Will Temperley ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
