wkt空间数据导入postgis数据库中
WKT数据导入postgis空间数据库中
1、创建表格
CREATE TABLE wg(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL
);
2、添加几何字段
SELECT AddGeometryColumn('public', 'wg', 'shape', 4326, 'POLYGON', 2)
INSERT INTO wg (id,name,shape)
3、添加几何数据和字段
VALUES (1,'北京', ST_GeomFromText('POLYGON((106.076314 32.753701,106.071810 32.757590,106.071679 32.758162,106.071541 32.758767,106.076314 32.753701))', 4326));
select * from wg
4、结果