一, 点表 (3857 坐标系)
1. 建表
创建包含空间数据的表 mytable.
- CREATE TABLE pointtable (
- id SERIAL PRIMARY KEY,
- name VARCHAR(128),
- geom GEOMETRY(Point, 3857)
- );
2. 添加 Gist 索引
CREATE INDEX pointtable_gix ON pointtable USING Gist (geom);
3. 插入数据
- INSERT INTO pointtable (name, geom) VALUES ('p1',
- st_transform(ST_GeomFromText('POINT(105.1 30)', 4326),3857)
- );
- INSERT INTO pointtable (name,geom) VALUES ('p2',
- st_transform(ST_GeomFromText('POINT(105.1 30)', 4326),3857)
- );
- INSERT INTO pointtable (name,geom) VALUES ('p3',
- st_transform(ST_GeomFromText('POINT(105.1 30)', 4326),3857)
- );
- st_transform(ST_GeomFromText('POINT(105.1 30)', 4326),3857)
来源: http://www.bubuko.com/infodetail-3755424.html