Hi,
You must have geometries in a column of type SDO_GEOMETRY. You can alter your
existing table and populate the sdo_geometry field from your x and y columns
with a SQL query. But if you have never heard about sdo_geometry before I would
recommend to use a few days by reading Oracle Spatial documents.
-Jukka Rahkonen-
________________________________
Lähettäjä: Guntu, Ashok (IS) (Contr) [mailto:[email protected]]
Lähetetty: 8. maaliskuuta 2012 17:14
Vastaanottaja: Guntu, Ashok (IS) (Contr); [email protected]
Aihe: [Geoserver-users] GeoServer with oracle (not spatial)
Hi,
I am new to GeoServer and am trying to create a layer using the data I have
in oracle 10g database. I am able to connect to my database and see all my
tables. I am also able to create a view. But anywhere in the documentation, I
was unable to find what kind of view/table is required to create a layer out of
it. I have used a table with columns like latitude and longitude and tried to
create a layer but was not successful. Is there any documentation which tells
me what the data model should be.
Any help is appreciated. Thanks in advance.
Ashok
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
