On Thu, Dec 18, 2008 at 11:50:46AM -0700, Sparks, Witt wrote: > Thanks for the (incredibly quick) response. > > Looking at the oracle spatial docs more closely, you're right, it says > that SDO_UTIL.TO_GMLGEOMETRY produces a "GML fragment." > > I'll look around and see if there's a way I can get oracle to produce a > full GML document. I'll respond again if I find something.
Since your'e just using the Geometry, I'd really go for WKT -- serializing a 'full' GML document for geometry seems unneccesary. If you are going to actually get the database to give you attributes to go along with it, however, something like GML (or GeoJSON) seem like a good idea. I'm assuming you're taking the output from Oracle and pushing it through some web application framework; at that point, you could wrap your geometry in a featureMember, and stick in the properties as well, which might help you get the feature you want. > Thanks. > > -----Original Message----- > From: Christopher Schmidt [mailto:[email protected]] > Sent: Thursday, December 18, 2008 9:47 AM > To: Sparks, Witt > Cc: [email protected] > Subject: Re: [OpenLayers-Users] Oracle Spatial and GML > > On Thu, Dec 18, 2008 at 09:31:20AM -0700, Sparks, Witt wrote: > > Hello, > > > > > > > > I'm trying to select GML from an oracle spatial table and use it to > > create an OpenLayers.Feature.Vector object. > > Oracle is giving me the following GML (for a point layer): > > This is a single Geometry; OpenLayers, generally speaking, parses > features or feature collections. I believe the GML parser will only work > on FeatureCollections by default. Can you produce a featureCollection > including this point? > > > <gml:Point srsName="SDO:8307" xmlns:gml="http://www.opengis.net/gml";> > > > > <gml:coordinates decimal="." cs="," ts=" ">-94.653001,41.497753 > > </gml:coordinates> > > > > </gml:Point> > > Regards, > -- > Christopher Schmidt > MetaCarta -- Christopher Schmidt MetaCarta _______________________________________________ Users mailing list [email protected] http://openlayers.org/mailman/listinfo/users
