Hi
Andrea probably meant ” GeoServer is NOTable to do joins”. However, I wonder if this isn’t made exactly for that
http://www.iderc.co.cu/index.php/servicio-tjs/56.html
I can’t find it from https://github.com/geoserver/geoserver/tree/master/src/community though.
-Jukka Rahkonen-
···
Andrea Aime wrote:
On Thu, Feb 27, 2014 at 9:36 AM, Guillermo Heras <gheras@anonymised.com> wrote:
Hello
I have geoserver 2.4 with the spatial data in a postgresql+postgis database
and some additional alphanumerical data in a corporate oracle 11 database.
For some layers, I need to access data in the oracle database and join it
with the spatial data to do the right representation. I’ll leave an example:
PostgreSQL → table “places” (id, name, corp_code, the_geom)
Oracle11 → table “CORP_PLACES” (code, status)
I have both databases set as datasources and both tables published. But for
the WMS service of “places” I need to style them more or less like this: if
status is 1, then the symbol must be red; if status is blue, then the symbol
must be green.
How can I combine the data from the two different data sources to publish it
together?
GeoServer is now able to do joins from two different data source (yet, if someone
wants to sponsor it, that would be great), but I believe you can create a joining
view in Postgresql using the foreign data wrappers:
http://wiki.postgresql.org/wiki/Foreign_data_wrappers
Cheers
Andrea
–
== Our support, Your Success! Visit http://opensdi.geo-solutions.it 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://twitter.com/geosolutions_it