Hi Joe,
You should use the SDO_GEOMETRY data type that comes with Oracle Spatial
(on Oracle Enterprise version) and Oracle Locator (all others).
see the socs here:
http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_objrelschema.htm
regards, michael
On Thu, Jan 5, 2012 at 6:59 PM, Tito, Joe <joseph.t...@sparta.com> wrote:
> 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
>
>
------------------------------------------------------------------------------
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
