search for: geomfromtext

I''m trying to determine how/if I can use MySql''s spatial extensions with ActiveRecord. The spatial extensions usually require inserts in the following format: INSERT INTO `locations` (name, point) VALUES ("location name",GeomFromText(''POINT(<lng> <lat>'')); And reads as SELECT name, AsText(point) AS point FROM locations; While I understand there''s methods to issue custom finder commands, I don''t recall seeing anything about custom inserts/updates. Does anyone have any recommend...

...# generate voronoi edges tiles = tile.list(voro) # combine edges into polygons sink("voronoi.sql") # redirect output to file for (i in 1:length(tiles)) { # write out polygons tile = tiles[[i]] cat("insert into mytable (the_geom) values(geomfromtext('POLYGON((") for (j in 1:length(tile$x)) { cat (tile$x[[j]],' ',tile$y[[j]],",") } cat (tile$x[[1]],' ',tile$y[[1]]) #close polygon cat ("))',32718));\n") # add SRID and newline } sink()...

Does anyone have any recommendations for working with zip code distance ranges? I need to calculate the distances between US zip codes. Thanks! -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060711/f133d7de/attachment-0001.html