wkt格式坐标点面查询

wkt格式坐标点面查询
判断函数：判断A是否被B包含 ST_Within(geometry A, geometry B)

1. 将坐标点转换成wkt格式POINT()
2. 使用ST_GeomFromText(text,[])函数构建几何
3. 查看该面中是否包含该点语句
   返回结果为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))’))
4. 查看哪些面包含该点语句
   返回对应数据
   SELECT * FROM aoi WHERE ST_Within(ST_GeomFromText(‘POINT(116.413728 39.94646)’),ST_GeomFromText(geometry)) is true