-
Notifications
You must be signed in to change notification settings - Fork 89
Geo查询
iamazy edited this page Sep 23, 2019
·
6 revisions
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]]]]