[OpenLayers-Users] Oracle Spatial and GML

[Sparks, Witt]

Yeah, I'd rather use WKT, but as far as I can tell oracle's get_WKT()
function only comes with spatial. We're currently using Locator, which
is a subset of spatial included free with oracle.

I may end out buying spatial...

Thanks for your help!

-----Original Message-----
From: Christopher Schmidt [mailto:crschmidt at metacarta.com] 
Sent: Thursday, December 18, 2008 11:56 AM
To: Sparks, Witt
Cc: users at openlayers.org
Subject: Re: [OpenLayers-Users] Oracle Spatial and GML

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:crschmidt at metacarta.com] 
> Sent: Thursday, December 18, 2008 9:47 AM
> To: Sparks, Witt
> Cc: users at openlayers.org
> 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