使用Sequelize和postgis在多边形中查找点

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'postgres',
  host: 'localhost',
});

const Polygon = sequelize.define('Polygon', {
  geometry: {
    type: DataTypes.GEOMETRY('POLYGON'),
    allowNull: false,
  },
});

(async () => {
  await sequelize.sync({ force: true });

  // 插入多边形数据
  await Polygon.create({
    geometry: {
      type: 'Polygon',
      coordinates: [[
        [0, 0],
        [0, 10],
        [10, 10],
        [10, 0],
        [0, 0],
      ]],
    },
  });

  // 查询包含点的多边形
  const point = {
    type: 'Point',
    coordinates: [5, 5],
  };
  const polygons = await Polygon.findAll({
    where: sequelize.where(
      sequelize.fn('ST_Contains', sequelize.col('geometry'), sequelize.fn('ST_GeomFromGeoJSON', JSON.stringify(point))),
      true
    ),
  });

  console.log(polygons);
})();