That's what I wanted to, at first, but the query is really to heavy to be on-the-fly via GeoServer. So I have to create this materialized view on postgis (8min execution time !!) to build a new layer... maybe this should be a new table ?

Le 31/05/2016 à 18:06, Blome, Guido (62-24) a écrit :
Hi Ivan,

I`m using materialized Views in Geoserver by building an SQL-View.
You just have to paste the SELECT Statement in the form behind the link "configure 
SQL View" and it works. But your right they don't appear in the normal Featuretype 
list.
But with the described workaround it works.


Cheers, Guido

Guido Blome

Bundesstadt Bonn
Amt für Bodenmanagement und Geoinformation
Stadthaus, Berliner Platz 2, 53111 Bonn
Telefon +49(0)2 28.77 3009
Telefax +49(0)2 28.77 2618
E-Mail [email protected]
Internet www.bonn.de

Bleiben Sie mit dem mehrmals in der Woche erscheinenden Newsletter 'BonnLive online' 
auf dem Laufenden. Informationen aus dem Rathaus, Veranstaltungstipps und aktuelle 
Nachrichten jetzt im Abo, kostenlos unter www.bonn.de<http://www.bonn.de>
Recyclingpapierfreundlichste Stadt Deutschlands 2010 bis 2015.
Bitte prüfen Sie, ob diese Mail wirklich ausgedruckt werden muss.

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Kinaxia         
Gabriel VATIN
Docteur en Géomatique
Ingénieur de recherche
Tél : 06.63.92.94.42
Email : [email protected] <mailto:[email protected]>
http://www.kinaxia.fr

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to