wkt格式坐标点面查询
判断函数:判断A是否被B包含 ST_Within(geometry A, geometry B)
- 将坐标点转换成wkt格式POINT()
- 使用ST_GeomFromText(text,[])函数构建几何
- 查看该面中是否包含该点语句
返回结果为true或false
SELECT ST_Within(ST_GeomFromText(‘POINT(116.413728 39.94646)’),ST_GeomFromText(‘POLYGON ((116.43046940092249 40.101310734636954, 116.43037333630049 40.10216565659323, 116.43266731283904 40.10232474085187, 116.43275929808401 40.10143970041427, 116.43046940092249 40.101310734636954))’)) - 查看哪些面包含该点语句
返回对应数据
SELECT * FROM aoi WHERE ST_Within(ST_GeomFromText(‘POINT(116.413728 39.94646)’),ST_GeomFromText(geometry)) is true