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