Hi,
I would say that it will not work out-of-the-box because GeoServer does not
have X/Y or CSV datastore and what could be done with Mapserver through the
GDAL virtual format http://www.gdal.org/drv_vrt.html is not supported. But if
you absolutely need such feature it is for sure doable. You can contract a
Geoserver developer to make a new datastore or if you are in a hurry you can
install Mapserver to read X/Y data from Oracle, publish it as WMS and cascade
that layer with Geoserver.
The real question is: Why would you like to do so? You do not need to pay for
Oracle locator and with it you can add a new column of datatype SDO_GEOM into
your table and populate it from your X and Y columns. If you have an old system
in production and X/Y are updated from some application, make a trigger and do
inserts and updates into SDO_GEOM every time when X or Y are touched.
-Jukka Rahkonen-
Lähettäjä: Nachtigall, Jens (init) [mailto:jens.nachtig...@init.de]
Lähetetty: 12. syyskuuta 2014 15:52
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
A "does not work, you must use a spatial db to hold point coordinates" would
help me, too ;) Does nobody know?
Cheers,
Jens
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
