egg+sequelize+postgis 空间数据新增

一、建立空间表，建议使用下边的代码建立空间表不建议使用navicat去建表

CREATE TABLE city( id int4,name varchar(25), geom geometry(POINT,4326) );

二、egg中建立model

module.exports = app => {
    const { INTEGER, STRING, GEOMETRY } = app.Sequelize;
    const City = app.model.define("city", {
        id: { type: INTEGER, primaryKey: true, autoIncrement: true },
        name: STRING,
        geom: GEOMETRY
    }, {
        freezeTableName: true, //直接查找设置的表名，默认是表名加s或者es
        timestamps: false,
    });

    return City;
}

 三、数据插入到空间表中

（1）直接执行sql命令如下

INSERT INTO city(id,name,geom)VALUES(0,'郑州',st_geomfromtext('SRID=4326;point(113.34 34.23)'))

(2) 使用sequelize插入空间数据

async addCityPoint() {
    const { model, request } = this.ctx
    let result = await model.City.create({
      name: '1',
      geom: {
        type: 'Point',
        coordinates: [39.807222, -76.984722],
        crs: { type: 'name', properties: { name: 'EPSG:4326' } }
      }
    })
    this.ctx.body = result
  }