postgis常用函数

postgis常用函数

SELECT * FROM china LIMIT 5;
--基本的查询语句
--SELECT geom FROM china WHERE china."name"='东城区';
--SELECT geom FROM china WHERE china."name"='西城区';
--SELECT * FROM china WHERE china."name"='朝阳区';
--SELECT geom FROM china WHERE china."name"='石景山区';
--SELECT * FROM china WHERE china."name"='通州区';
--SELECT geom FROM china WHERE china."name"='海淀区';
--SELECT geom FROM china WHERE china."name"='丰台区';
--SELECT geom FROM china WHERE china."name"='大兴区';
--SELECT geom FROM china WHERE china."name"='房山区';
--SELECT geom FROM china WHERE china."name"='门头沟区';

--空间关系查询
--SELECT st_disjoint(a.geom, b.geom) from china a, china b where a.name='石景山区'  and b."name"='丰台区';--是否相连
--SELECT st_intersects(a.geom, b.geom) FROM china a,china b where a.name='海淀区'  and b."name"='丰台区';--是否相交
--SELECT st_distance(a.geom, b.geom) FROM china a,china b where a.name='海淀区'  and b."name"='朝阳区';--求距离
--SELECT st_dwithin(a.geom, b.geom,2) FROM china a,china b where a.name='海淀区'  and b."name"='朝阳区';--是否距离包含
--SELECT st_touches(a.geom, b.geom) FROM china a,china b where a.name='海淀区'  and b."name"='石景山区';--是否接触
--SELECT st_overlaps(a.geom, b.geom) FROM china a,china b where a.name='丰台区'  and b."name"='海淀区';--是否重叠

--Geometry Accessors查询
--SELECT st_area(geom) FROM china where china.name='丰台区' ;--求面积
--SELECT st_length(geom) FROM china WHERE china.name='海淀区';--求长度
--SELECT st_numpoints(geom) FROM china where china.name='海淀区';--求线上的点数
--SELECT st_geometrytype(geom) FROM china where china.name='漠河县';--判断几个类型
--SELECT st_astext(geom) FROM china WHERE china.name='海淀区';--几何空间数据转换成空间数据文本格式
--SELECT st_srid(geom) FROM china WHERE china.name='海淀区';--返回当前几何空间数据的SRID值
--SELECT st_isclosed(geom) FROM china where china.name='海淀区';--判断是否闭合
--SELECT st_isempty(geom) FROM china where china.name='海淀区';--判断是否为空
--SELECT st_isring(geom) FROM china where china.name='海淀区';--判断起始点和终点坐标是否相同
--SELECT st_isvalid(geom) FROM china where china.name='海淀区';--判断是否可用

--SELECT st_issimple(geom) FROM china where china.name='海淀区';