Postgresql 如何在 Sequelize ORM 中插入 PostGIS GEOMETRY 点

在l0oky的答案的基础上，integration test提供了很多关于如何将json用于不同类型的几何体的好线索.基本上，sequelize似乎会将提供的几何体对象字符串化，假设它是有效的GeoJSON，并将其导入PostGIS函数ST_GeoFromGeoJSON.因此，对于几何体对象，只需遵循GeoJSON spec即可.

Points:

var point = { type: 'Point', coordinates: [39.807222,-76.984722]};

User.create({username: 'username', geometry: point }).then(function(newUser) {
...
});

Linestrings:

var line = { type: 'LineString', 'coordinates': [ [100.0, 0.0], [101.0, 1.0] ] };

User.create({username: 'username', geometry: line }).then(function(newUser) {
...
});

Polygons:

var polygon = { type: 'Polygon', coordinates: [
             [ [100.0, 0.0], [101.0, 0.0], [101.0, 1.0],
               [100.0, 1.0], [100.0, 0.0] ]
             ]};

User.create({username: 'username', geometry: polygon }).then(function(newUser) {
...
});

Setting a custom SRID:

var point = { 
  type: 'Point', 
  coordinates: [39.807222,-76.984722],
  crs: { type: 'name', properties: { name: 'EPSG:4326'} }
};

User.create({username: 'username', geometry: point }).then(function(newUser) {
...
});