<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [OpenLayers-Users] Oracle Spatial and GML</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Or you could just dump Oracle and go with PostGIS which has AsWKT, AsGML and AsGeoJSON<BR>
and too many other functions to itemize -<BR>
<BR>
<A HREF="http://postgis.refractions.net/documentation/manual-svn/ch07.html">http://postgis.refractions.net/documentation/manual-svn/ch07.html</A><BR>
<BR>
Though I guess it depends what you need Oracle Locator for. If your whole application stack relies on an Oracle database, then I guess PostGIS might not be an option.<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: users-bounces@openlayers.org on behalf of Sparks, Witt<BR>
Sent: Thu 12/18/2008 2:19 PM<BR>
To: Christopher Schmidt<BR>
Cc: users@openlayers.org<BR>
Subject: Re: [OpenLayers-Users] Oracle Spatial and GML<BR>
<BR>
Yeah, I'd rather use WKT, but as far as I can tell oracle's get_WKT()<BR>
function only comes with spatial. We're currently using Locator, which<BR>
is a subset of spatial included free with oracle.<BR>
<BR>
I may end out buying spatial...<BR>
<BR>
Thanks for your help!<BR>
<BR>
-----Original Message-----<BR>
From: Christopher Schmidt [<A HREF="mailto:crschmidt@metacarta.com">mailto:crschmidt@metacarta.com</A>]<BR>
Sent: Thursday, December 18, 2008 11:56 AM<BR>
To: Sparks, Witt<BR>
Cc: users@openlayers.org<BR>
Subject: Re: [OpenLayers-Users] Oracle Spatial and GML<BR>
<BR>
On Thu, Dec 18, 2008 at 11:50:46AM -0700, Sparks, Witt wrote:<BR>
> Thanks for the (incredibly quick) response.<BR>
><BR>
> Looking at the oracle spatial docs more closely, you're right, it says<BR>
> that SDO_UTIL.TO_GMLGEOMETRY produces a "GML fragment."<BR>
><BR>
> I'll look around and see if there's a way I can get oracle to produce<BR>
a<BR>
> full GML document. I'll respond again if I find something.<BR>
<BR>
Since your'e just using the Geometry, I'd really go for WKT --<BR>
serializing a 'full' GML document for geometry seems unneccesary. If you<BR>
are going to actually get the database to give you attributes to go<BR>
along with it, however, something like GML (or GeoJSON) seem like a good<BR>
idea.<BR>
<BR>
I'm assuming you're taking the output from Oracle and pushing it through<BR>
some web application framework; at that point, you could wrap your<BR>
geometry in a featureMember, and stick in the properties as well, which<BR>
might help you get the feature you want.<BR>
<BR>
> Thanks.<BR>
><BR>
> -----Original Message-----<BR>
> From: Christopher Schmidt [<A HREF="mailto:crschmidt@metacarta.com">mailto:crschmidt@metacarta.com</A>]<BR>
> Sent: Thursday, December 18, 2008 9:47 AM<BR>
> To: Sparks, Witt<BR>
> Cc: users@openlayers.org<BR>
> Subject: Re: [OpenLayers-Users] Oracle Spatial and GML<BR>
><BR>
> On Thu, Dec 18, 2008 at 09:31:20AM -0700, Sparks, Witt wrote:<BR>
> > Hello,<BR>
> ><BR>
> > <BR>
> ><BR>
> > I'm trying to select GML from an oracle spatial table and use it to<BR>
> > create an OpenLayers.Feature.Vector object.<BR>
> > Oracle is giving me the following GML (for a point layer):<BR>
> <BR>
> This is a single Geometry; OpenLayers, generally speaking, parses<BR>
> features or feature collections. I believe the GML parser will only<BR>
work<BR>
> on FeatureCollections by default. Can you produce a featureCollection<BR>
> including this point?<BR>
><BR>
> > <gml:Point srsName="SDO:8307"<BR>
xmlns:gml="<A HREF="http://www.opengis.net/gml">http://www.opengis.net/gml</A>"><BR>
> ><BR>
> > <gml:coordinates decimal="." cs="," ts=" ">-94.653001,41.497753<BR>
> > </gml:coordinates><BR>
> ><BR>
> > </gml:Point><BR>
><BR>
> Regards,<BR>
> --<BR>
> Christopher Schmidt<BR>
> MetaCarta<BR>
<BR>
--<BR>
Christopher Schmidt<BR>
MetaCarta<BR>
_______________________________________________<BR>
Users mailing list<BR>
Users@openlayers.org<BR>
<A HREF="http://openlayers.org/mailman/listinfo/users">http://openlayers.org/mailman/listinfo/users</A><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>