ruby-on-rails - 无法使用PostGIS/RGeo保存多边形

如何使用PostGIS adapter for Rails保存多边形？在我的模型中，我有：

self.rgeo_factory_generator = RGeo::Geos.factory_generator
set_rgeo_factory_for_column(:bounds, RGeo::Geographic.spherical_factory(:srid => 4326))

但是，当我尝试将多边形保存到数据库时，它不会产生任何错误，但始终无法存储多边形：

1.9.3p194 :011 > n.bounds = "POLYGON(-149.737965876574 61.1952881991104, -149.71848377896 61.1953198415937, -149.718483761252 61.1952938698801, -149.718483872402 61.1951924591105)"
 => "POLYGON(-149.737965876574 61.1952881991104, -149.71848377896 61.1953198415937, -149.718483761252 61.1952938698801, -149.718483872402 61.1951924591105)"
1.9.3p194 :012 > n.save
   (0.2ms)  BEGIN
   (0.3ms)  COMMIT
 => true
1.9.3p194 :013 > n.bounds
 => nil

我怎样才能让它工作？

最佳答案

它是无效的WKT并且无法解析，原因有二：
没有戒指。需要在坐标数组周围添加另一组括号。
戒指没有关上。重复起点作为终点。
有效的WKT应该是这样的：

POLYGON((-149.737965876574 61.1952881991104, -149.71848377896 61.1953198415937, -149.718483761252 61.1952938698801, -149.718483872402 61.1951924591105, -149.737965876574 61.1952881991104))

关于ruby-on-rails - 无法使用PostGIS/RGeo保存多边形，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/13790131/