[Geoserver-users] Accessing to table (no layer), with coordiinate column form GeoServer

GeoServer GeoServer User
1

Hi all!.
I’ve a table in ORACLE (no spatial), with colums in which there are points coordinates and

I’d like use this data to create a layer in GeoServer.

Is there any manner to use this data directly form GeoServer or I’ve to transform the data in shp or text file and then use it?

Thank you very much in advance

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl
https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

2

Hi,
You might be able to do it using “geomFromWKT” if you convert the data into WKT.http://docs.geoserver.org/stable/en/user/filter/function_reference.html?highlight=filter

Alternately possibly using a SQL View where the conversion is done in the database:
http://docs.geoserver.org/stable/en/user/data/database/sqlview.html?highlight=sql%20view

But that’ll require figuring out how to write an Oracle query that does that.

Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

On 15 October 2013 10:26, cesare gerbino <cesaregerbino@anonymised.com> wrote:

Hi all!.
I’ve a table in ORACLE (no spatial), with colums in which there are points coordinates and

I’d like use this data to create a layer in GeoServer.

Is there any manner to use this data directly form GeoServer or I’ve to transform the data in shp or text file and then use it?

Thank you very much in advance

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl
https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Hi Jonathan and Jukka, thank you very much for your very useful
suggestions!!!

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Accessing-to-table-no-layer-with-coordiinate-column-form-GeoServer-tp5083634p5084951.html
Sent from the GeoServer - User mailing list archive at Nabble.com.