On Thu, Feb 27, 2014 at 9:36 AM, Guillermo Heras <[email protected]> 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://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
