Hi, Oracle is using SDO_GEOMETRY datatype and it comes with the Locator option. Locator is not necessarily installed by default into the database. Separately licensed Oracle Spatial gives more options for geoprocessing but Geoserver is happy with the free Locator option.
Oracle does have plenty of documents about Oracle Spatial. Start for example from this http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/toc.htm Creating SDO_GEOMETRY options is a bit tricky but you will find examples from the net. Here is one update address_sample a set a.geometry = mdsys.sdo_geometry(2001, 27700, MDSYS.SDO_POINT_TYPE(a.xcoord, a.ycoord, NULL), NULL, NULL); this updates the geometry field with the SDO_POINT TYPE. -Jukka Rahkonen- Lähettäjä: Tito, Joe [joseph.t...@sparta.com] Lähetetty: 5. tammikuuta 2012 18:59 Vastaanottaja: geoserver-users@lists.sourceforge.net Aihe: [Geoserver-users] Storing lon/lat points in Oracle 11g Could anyone explain how to store longitude/latitude points in an Oracle 11g database so that GeoServer can use them? I know in MySQL you store them as Geometry objects, but I'm having a difficult time finding documentation on Oracle. Here's a few questions I had: 1) What oracle data type do I make my lon/lat column?? 2) How do I insert lon/lat into my column 3) How do I query a lon/lat column and convert it into readable text? If anyone has any good links, please share! Thanks Joe ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
