SDB地理空间点无效

bejyjqdl  于 2021-07-24  发布在  Java
关注(0)|答案(1)|浏览(472)

我正在使用azure的cosmos数据库,并通过azure门户中的sqlquery进行测试。我的收藏中有些是有效的,有些是无效的。我无法从geojson规范判断我是否缺少需求。我的所有观点都通过了geojsonlint测试:https://geojsonlint.com/
什么可能导致无效积分?据我所知,地点都是一样的。
我的问题:

  1. SELECT *
  2. FROM events1 e
  3. WHERE ST_ISVALID(e.location)

运行查询将返回以下有效值:

  1. [
  2. {
  3. "id": "b4b49b65-dfad-40f3-943b-753553507d2c",
  4. "name": "OG Olympics",
  5. "location": {
  6. "type": "Point",
  7. "coordinates": [
  8. 41.900697426935544,
  9. 12.480266913771628
  10. ]
  11. },
  12. "events": "Hockey",
  13. "time": "00:00:00",
  14. "recurring": null,
  15. "date": null,
  16. "difficulty": "Expert",
  17. "ages": "Senior",
  18. "admin": null,
  19. "private": null,
  20. "_rid": "Maw1AIaRiRoHAAAAAAAAAA==",
  21. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoHAAAAAAAAAA==/",
  22. "_etag": "\"11003fb9-0000-0700-0000-5f2f15cf0000\"",
  23. "_attachments": "attachments/",
  24. "_ts": 1596921295
  25. },
  26. {
  27. "id": "f2d063e3-5654-475d-8e97-7412dc77fcfb",
  28. "name": "Test Event DenverCC",
  29. "location": {
  30. "type": "Point",
  31. "coordinates": [
  32. 100.2093,
  33. -15.868
  34. ]
  35. },
  36. "events": "Basketball",
  37. "time": "18:00:00",
  38. "recurring": null,
  39. "date": null,
  40. "difficulty": "Intermediate",
  41. "ages": "Senior",
  42. "admin": null,
  43. "private": null,
  44. "_rid": "Maw1AIaRiRoJAAAAAAAAAA==",
  45. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoJAAAAAAAAAA==/",
  46. "_etag": "\"1300a79d-0000-0700-0000-5f304fc80000\"",
  47. "_attachments": "attachments/",
  48. "_ts": 1597001672
  49. },
  50. {
  51. "id": "10000",
  52. "name": "OG Olympics 2",
  53. "location": {
  54. "type": "Point",
  55. "coordinates": [
  56. 41.000697426935545,
  57. -12.080266913771627
  58. ]
  59. },
  60. "events": "Hockey",
  61. "time": "00:00:00",
  62. "recurring": null,
  63. "date": null,
  64. "difficulty": "Expert",
  65. "ages": "Senior",
  66. "admin": null,
  67. "private": null,
  68. "_rid": "Maw1AIaRiRoKAAAAAAAAAA==",
  69. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoKAAAAAAAAAA==/",
  70. "_etag": "\"13003499-0000-0700-0000-5f304d580000\"",
  71. "_attachments": "attachments/",
  72. "_ts": 1597001048
  73. }

]
但它返回的结果是无效的:

  1. {
  2. "id": "1000",
  3. "name": "Sunday Morning Hockey",
  4. "location": {
  5. "type": "Point",
  6. "coordinates": [
  7. 39,
  8. -105
  9. ]
  10. },
  11. "events": "hockey",
  12. "time": "09:00",
  13. "recurring": "true",
  14. "date": "2020-08-02",
  15. "difficulty": "all levels",
  16. "ages": "all ages",
  17. "admin": "1000",
  18. "private": "false",
  19. "_rid": "Maw1AIaRiRoBAAAAAAAAAA==",
  20. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoBAAAAAAAAAA==/",
  21. "_etag": "\"13008c9f-0000-0700-0000-5f3050d70000\"",
  22. "_attachments": "attachments/",
  23. "_ts": 1597001943
  24. }
  25. {
  26. "id": "9f373e04-0cfc-4121-927d-a6256dbe06c6",
  27. "name": "test1",
  28. "location": {
  29. "type": "Point",
  30. "coordinates": [
  31. 39.731441899363105,
  32. -104.98381230980158
  33. ]
  34. },
  35. "events": "Basketball",
  36. "time": "00:00:00",
  37. "recurring": null,
  38. "date": null,
  39. "difficulty": "Expert",
  40. "ages": "Adult",
  41. "admin": null,
  42. "private": null,
  43. "_rid": "Maw1AIaRiRoLAAAAAAAAAA==",
  44. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoLAAAAAAAAAA==/",
  45. "_etag": "\"13005999-0000-0700-0000-5f304d760000\"",
  46. "_attachments": "attachments/",
  47. "_ts": 1597001078
  48. }
  49. {
  50. "id": "be01bc12-d28e-4368-b6de-0f3e84dbe13c",
  51. "name": "test2",
  52. "location": {
  53. "type": "Point",
  54. "coordinates": [
  55. 39.72082849205111,
  56. -104.98461395502092
  57. ]
  58. },
  59. "events": "Hockey",
  60. "time": "00:00:00",
  61. "recurring": null,
  62. "date": null,
  63. "difficulty": "Expert",
  64. "ages": "Adult",
  65. "admin": null,
  66. "private": null,
  67. "_rid": "Maw1AIaRiRoMAAAAAAAAAA==",
  68. "_self": "dbs/Maw1AA==/colls/Maw1AIaRiRo=/docs/Maw1AIaRiRoMAAAAAAAAAA==/",
  69. "_etag": "\"1300219a-0000-0700-0000-5f304de10000\"",
  70. "_attachments": "attachments/",
  71. "_ts": 1597001185
  72. }
px9o7tmv

px9o7tmv1#

花了一段时间才意识到,但geojson期望在点中翻转坐标。所以当Map返回一个带有[纬度,经度]的点类型时。地理信息[经度,纬度]

相关问题