On Thu, Dec 15, 2011 at 4:44 PM, Mark Hammond <[email protected]> wrote:
> Wanted Geoserver to serve a WMS layer using spatial data from an Oracle
> table, but select features based on the contents of non-spatial fields
> across multiple tables – the only way to achieve this was to pull together
> all the information together in a Materialised View containing the features
> and all the non-spatial fields that would be filtered on.
>
Not the only way, you can also create a non materialized view with CREATE
VIEW or use a SQL view defined in GeoServer:
http://docs.geoserver.org/latest/en/user/data/sqlview.html
Materialized views are a common way to speed up the view usage in case the
join is expensive and/or some of
the tables are network linked from another, possibly remote, db. I know of
people using them with GeoServer.
> ****
>
> ** **
>
> Have created and populated the materialised view, created spatial indexes
> and added an entry into Oracle’s sdo_geom_metadata table.****
>
> When I come to publish the layer in Geoserver, it can see the view, but
> when I try and publish it, the Native SRS is blank and cannot have anything
> typed in it. As a result, even if I declare an SRS I will not compute
> bounding boxes and will just hang when trying to publish.
>
The native srs is never editable, it's either found or not. But declaring
the SRS shoudl make it work,
if it hangs there indefinitely instead of reporting an error it probably
just mean it's taking a
very long time to compute the bounds... wondering, did you add spatial
indexes to the
materialized view?
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
