Hi, In Oracle try something like
select trunc(DUMMY.GEOLOC.SDO_POINT.X) EASTING, trunc(DUMMY.GEOLOC.SDO_POINT.Y) NORTHING FROM MY_TABLE DUMMY; Create lat and long fields and modify the query to do update. Use transform if you need to reproject coordinates from some other SRID. Don't trunc if you want all the decimals. -Jukka Rahkonen- > -----Alkuperäinen viesti----- > Lähettäjä: Mustafa646 [mailto:[email protected]] > Lähetetty: 1. helmikuuta 2012 11:40 > Vastaanottaja: [email protected] > Aihe: [Geoserver-users] Converting geometry field into set of > google latlng > > For storing Geospatial data, Geometry field is used in SQL > server or Oracle > Spatial. I want to know is there any way where we can convert > this geometry > field into set of latitudes and longitudes. > > > -- > View this message in context: > http://osgeo-org.1560.n6.nabble.com/Converting-geometry-field- > into-set-of-google-latlng-tp4355788p4355788.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > -------------------------------------------------------------- > ---------------- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft > developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, > CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
