我对DocumentDB相当陌生,我对MongoDB有经验。
这是我的简单文档:
{
"id": "747941cfb829_1453640096710",
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
0,
0
],
[
10,
10
],
[
10,
0
],
[
0,
0
]
]
]
},
"name": "name",
"_rid": "Px12AM4QPgBsAAAAAAAAAA==",
"_self": "dbs/Px12AA==/colls/Px12AM4QPgA=/docs/Px12AM4QPgBsAAAAAAAAAA==/",
"_etag": "\"07006019-0000-0000-0000-573395f50000\"",
"_attachments": "attachments/",
"_ts": 1462998499}
这是我的查询:
SELECT * FROM root r WHERE ST_WITHIN({'type':'Point','coordinates':[-122.02625, 37.4718]}, r.geometry)
当我运行此查询时,它返回文档,但该点不在多边形内。有人知道会发生什么吗?
谢谢
您以顺时针方式指定了多边形,在本地将其解释为该多边形之外的所有内容。如果将其更改为逆时针方向(如下所示),您将获得预期的结果。
{
"id": "747941cfb829_1453640096710",
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
0,
0
],
[
10,
0
],
[
10,
10
],
[
0,
0
]
]
]
},
"name": "name"
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句