[OpenLayers-Users] Oracle Spatial and GML

[David Fawcett]

I don't know if MapServer's Oracle Spatial drivers can work with
Locator, and it would be an additional layer, but you could always use
MapServer to read your features and spit out geoJson, KML, etc.

Otherwise, you could likely use the OGR python module to read your
features and spit out lots of different formats.  (although you would
need an OGR compiled against the Oracle client libraries.

David.

On Thu, Dec 18, 2008 at 1:26 PM, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
> Or you could just dump Oracle and go with PostGIS which has AsWKT, AsGML and
> AsGeoJSON
> and too many other functions to itemize -
>
> http://postgis.refractions.net/documentation/manual-svn/ch07.html
>
> 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.
>
>
> -----Original Message-----
> From: users-bounces at openlayers.org on behalf of Sparks, Witt
> Sent: Thu 12/18/2008 2:19 PM
> To: Christopher Schmidt
> Cc: users at openlayers.org
> Subject: Re: [OpenLayers-Users] Oracle Spatial and GML
>
> 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
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
>
>
>
>
>
> ________________________________
>
> 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.
>
> ________________________________
>
> Help make the earth a greener place. If at all possible resist printing this
> email and join us in saving paper.
>
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
>
>