Any reason why you're not considering PostGIS to handle the geodata? It's *way* more mature than the native MySQL stuff.

http://wiki.rubyonrails.com/rails/pages/PostgreSQL

So ActiveRecord/Postgres seems to be doable. Getting the PostGIS/OGC data elements out seems to be the next hurdle. Java and C bindings are native to the project. Maybe some SWIG magic to add ActiveRecord support? Or as someone previously mentioned in this thread, there are Ruby bindings for ogr2ogr out there in the wild.

My $0.02,
s

Scott Davis
[EMAIL PROTECTED]



On Feb 1, 2006, at 1:03 PM, Tom Longson (nym) wrote:

No team, nothing found yet. I put out a call on the Ruby on Rails list.

Would be interested in getting this knocked out at least for POINT.

The syntax is dead simple imo.

CREATE TABLE narf (egad POINT);
INSERT INTO narf (GeomFromText('POINT(1 1)'));
SELECT x(egad), y(egad) FROM narf;

(I think that's it, I didn't double check the syntax)

nym

On 2/1/06, Kevin Elliott <[EMAIL PROTECTED]> wrote:
wondering if any of you wankers were playing with it. It doesn't seem

/me waves

At the cost of sounding cliché, me too!

like it has support for MySQL's spatial datatypes/functions
unfortunately. I was hoping to be able to throw up a geo app quickly yet avoid the amaturish thing of storing x and y coordinates in double

It's often quicker that way (database wise).

fields. I'm thinking about trying to extend rails to support these
datatypes but wanted to see if anyone was doing similar work first.

Not that I know of, interesting idea. Ping the Rails list?

As a relative new Rails developer, but thoroughly assimilated, I have been curious about this too. It might be something fairly easy to add if you're very familiar with the geospatial features in MySQL. I'm still looking at the geo functions in MySQL, and haven't had a chance to interface with it directly yet, but I'm interested. Perhaps we can team up and chunk out some code. Have you put together a small team or found something existing yet?

Kevin

_______________________________________________
Geowanking mailing list
[email protected]
http://lists.burri.to/mailman/listinfo/geowanking

_______________________________________________
Geowanking mailing list
[email protected]
http://lists.burri.to/mailman/listinfo/geowanking

_______________________________________________
Geowanking mailing list
[email protected]
http://lists.burri.to/mailman/listinfo/geowanking

Reply via email to