Hello Andrea,
Thanks for the response. I came up with a work around that works pretty
smoothly. Perhaps in the future it could be integrated it into an extension
of the PostGIS JDBC connection. Since the PostGIS doesn't set a limit on
the number of bands within a raster dataset we have a large collection of
rasters, well over 500 in our system. The example I am currently are 16
cereal crops around the world. What I ended up doing was ingesting the
multiband raster into a single raster_table, gli.cereals with views
o_2_cereals... o_16_cereals. Then I create a view for each CREATE VIEW
gli.o_16_barley AS SELECT r.rid, st_band(r.rast, 1) AS rast FROM
gli.o_16_cereals r; This is done for all of the datasets. The view are
essentially queries on the cereals table so you aren't duplicating your
data, but using the function st_band allows you to extract a single band.
Then the metadata table is created barley_mosaic and each view information
is placed within the table. something like: 'insert into
gli.barley_mosaic(name, tiletable) values ('gli.barley_mosaic',
'gli.o_16_barley');' make the xml and you are set to go.
I plan to implement this for a temporal stack of meris 300m satellite data.
On Mon, Oct 12, 2015 at 10:18 AM, Andrea Aime <[email protected]>
wrote:
> On Mon, Oct 12, 2015 at 4:27 PM, David Haynes II <[email protected]> wrote:
>
>> Seems that CQL expressions are not supported for this yet? Is there
>> another way I can go about it. Visualization works fine if I specify a new
>> SLD with the SourceChannelName set to band value (0-10)
>>
>
> Hi, no, band combining expressions are not yet supported in any form.
> Using cql directly in SLD is rather elegant, I admit, it would require
> quite a bit of work and API breakage in GeoTools though.
>
> A rendering transformation based on the Jiffle language
> <https://github.com/mbedward/jiffle> would be less invasive and higher
> performing,
> and we have the beginning of that solution written in this pull request
> https://github.com/geotools/geotools/pull/534
> but yeah, also this would require resourcing to make it happen
>
> Cheers
> Andrea
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/it488V for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
> -------------------------------------------------------
>
--
David Haynes, Ph.D.
Research Associate Terra Populus
Minnesota Population Center
612-626-3933
www.terrapop.org
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
