Timeline for can geoserver select one of many rasters from a postgis table
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 23, 2015 at 21:37 | vote | accept | apricity | ||
| Nov 23, 2015 at 17:48 | answer | added | Andrea Aime | timeline score: 0 | |
| Nov 13, 2015 at 6:30 | comment | added | user30184 | I have not done this myself, but the "mosaic" table is what I meant. If you add YEAR or any other attribute into that it should be possible to filter the "granules" with CQL_FILTER. In this question column named "UUID" was used with success osgeo-org.1560.x6.nabble.com/…. | |
| Nov 13, 2015 at 1:53 | comment | added | apricity | @user30184 When you say add a YEAR attribute to the "image mosaic table" do you mean there just needs to be a column called 'YEAR' in my raster table... ie rid, rast, YEAR or is there another place I need to specify YEAR so that geoserver knows about it? I have another table called mosaic that has columns name, tiletable, minx, miny, maxx, maxy, resx, resy - year doesn't need to be added to that table does it? | |
| Nov 13, 2015 at 0:47 | comment | added | user30184 |
It should work simply by adding an attribute (for example YEAR) into your image mosaic table and then adding into GetMaps &CQL_FILTER=YEAR=2015
|
|
| Nov 12, 2015 at 20:41 | comment | added | apricity | First, since I'm storing rasters in the postgis table, I'm using geoserver's Image Mosaic JDBC as per this link postgis raster. Second, when using Image Magic JDBC, the option to "Configure new SQL view..." isn't available. Instead I'm only presented with the link "Configure new Coverage view..." which is something completely different. | |
| Nov 12, 2015 at 20:27 | comment | added | Master Bee | You can try to build a view. docs.geoserver.org/2.7.0/user/data/database/sqlview.html | |
| Nov 12, 2015 at 17:51 | history | asked | apricity | CC BY-SA 3.0 |