Hartmuth Schachinger ha scritto:
> Is it possible to combine data from different datastores. I want to
> create a datastore, that gets its geometry from postgis and some
> attribute data from mysql. Is it possible to create such a datastore. I
> want to distribute this data as WFS and if possible as WMS.
GeoServer 2.0 has a module, called app-schema, that can do this kind of
mapping (among many other, powerful feature), but it's hard
to use at the moment as there is no UI to configure it, and it will work
for WFS only.
The module is documented here:
http://docs.geoserver.org/trunk/en/user/data/app-schema/index.htmlA simpler alternative is to setup a periodic job that copies the
mysql table contents to postgres and then build a joining view
there.
You can then publish the view using GeoServer (remember to register
the geometry columns contained in the view in the geometry__columns
table so that GS will know the geometry type and the spatial reference
system of the geometries).
Cheers
Andrea
--
Andrea Aime
OpenGeo -
http://opengeo.orgExpert service straight from the developers.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-july_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users
