Geo查询

目前支持的Geo查询geo_bounding_box,geo_distance,geo_polygon

示例

select * from student where location.coordinate between [30,70] and [20,50]   --geo_bounding_box
select * from student where location.coordinate in [[30.132,50],[40,60],[50,212]]  --geo_polygon
select * from student where location.coordinate=[40,30] and distance='100km'  --geo_distance

--geo_shape
-- 语法: where [field] shaped as [shape] [relation] [coordinates]
select * from student where location.coordinate shaped as envelope within [[10,10],[20,20]]
select * from student where location.coordinate shaped as multilinestring contains [[[10,10],[20,20]],[[11,11],[21,21]]]
select * from student where location.coordinate shaped as multipolygon disjoint [[[[10,10],[20,20],[11,11],[21,21]]],[[[10,10],[20,20],[11,11],[21,21]]]]