Writing a GeoRuby Oracle Adapter for Ruby 1.9 and Rails 3.2.5

Question

We are a GIS RoR-based software company which works with spatial data. At the present time, we directly execute our pure SQL in Oracle, but it's a challenging process, now we consider the idea of switching to GeoRuby.
We want to adopt GeoRuby with our corporation's Oracle database and our Rails environment.
As far as you probably know, there is no well-structured adapter for this purpose.
Presently, I am working on my own spatial oracle adapter. For now, I can create tables and Geometry columns with migrations. Also, I can manage to create models for a table.
For example, with assumption of having a GeoShape model which have two properties (name:string and geom:geometry), I can do:

g = GeoShape.new(:name => "Point1", geom: Point.from_x_y(-1.6, 2.8, 123))

After executing above statement, I have:

=> #<GeoShape id: nil, name: "Point1", geom: <GeoRuby::SimpleFeatures::Point:0x6a3cb030 @srid=123, @with_z=false, @with_m=false, @y=2.8, @x=-1.6, @z=0.0, @m=0.0>, created_at: nil, updated_at: nil>

Now I want to save my model to DB with g.save.

I am getting the following errors which is completely logical becasue the type mismatch between GeoRuby and Oracle types.

INSERT INTO "GEO_SHAPES" ("CREATED_AT", "GEOM", "ID", "NAME", "UPDATED_AT") VALUES (:a1, :a2, :a3, :a4, :a5)  [["created_at", Sun, 01 Jul 2012 04:34:34 UTC +00:00], ["geom", #<GeoRuby::SimpleFeatures::Point:0x6a3d3410 @srid=123, @with_z=false, @with_m=false, @y=2.8, @x=-1.6, @z=0.0, @m=0.0>], ["id", 10053], ["name", "Point1"], ["updated_at", Sun, 01 Jul 2012 04:34:34 UTC +00:00]]
ActiveRecord::StatementInvalid: OCIError: ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR: INSERT INTO "GEO_SHAPES" ("CREATED_AT", "GEOM", "ID", "NAME", "UPDATED_AT") VALUES (:a1, :a2, :a3, :a4, :a5)

Anyone have any idea regarding the process of doing this?
I guess, I must map my GeoRuby structure to corresponding Oracle SDO_Geometry, but I don't have any idea about the process.

Thanks very much for your helps.

score 1 · Answer 1 · answered Jul 01 '12 at 11:43

1

There is a nice gem rgeo

its core is an implementation of the industry standard OGC Simple Features Specification, which provides data representations of geometric objects such as points, lines, and polygons, along with a set of geometric analysis operations. This makes it ideal for modeling geolocation data. It also supports a suite of optional add-on modules that provide various geolocation-related services.

answered Jul 01 '12 at 11:43

Yuri Barbashov

5,407
1
24
20

Unfortunately rgeo lacks support for Oracle and there is no compatible adapter; so the question is indefeasible. – Dave Qorashi Jul 01 '12 at 13:06
so u have to create your own adapter for oracle and share it for community) – Yuri Barbashov Jul 01 '12 at 14:17
Yes, I have the idea in my mind, but, first I prefer GeoRuby, not because it's "good", but only there are some existing oracle adapters which I can take ideas from. – Dave Qorashi Jul 02 '12 at 05:53

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

I could manage to do this. Now I can directly save from GeoRuby models to Oracle DB. The process is illustrated in this thread.

edited May 23 '17 at 12:04

Community

1
1

answered Jul 04 '12 at 18:29

Dave Qorashi

326
2
11

Writing a GeoRuby Oracle Adapter for Ruby 1.9 and Rails 3.2.5

2 Answers2