PostGIS常用函数整理

by giser · 2019-04-03

创建空间数据表

create table coor_test(
lon numeric(8,5),
lat numeric(8,5),
geom geometry
);

插入坐标数据

insert into coor_test(lon,lat,geom)
values(116.6201,39.7216,st_geometryfromtext('POINT(116.6201 39.7216)',4326));

查询srid

select st_srid(geom) this_srid,* from coor_test;

转载自：https://blog.csdn.net/wu_boy/article/details/50112645