PostGIS常用函数整理

创建空间数据表

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;