17 places near 90000, Division Sandakan, Sabah, Malaysia
filter by placetype:
  1. Kinabatangan
    Kinabatangan, Division Sandakan, Sabah, Malaysia (LocalAdmin)
  2. Sandakan
    Sandakan, Division Sandakan, Sabah, Malaysia (LocalAdmin)
  3. Borneo
    Borneo (Colloquial)
  4. Tawitawi
    Tawitawi, Autonomous Region in Muslim Mindanao, Philippines (County)
  5. Division Sandakan
    Division Sandakan, Sabah, Malaysia (County)
  6. Asia/Manila
    Asia/Manila (Timezone)
  7. Asia/Kuching
    Asia/Kuching, Malaysia (Timezone)
  8. Sabah
    Sabah, Sabah, Malaysia (State)
  9. Malaysia
    Malaysia, Malaysia (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

Search again including deprecated places, unknown places, places that visit Null Island or everything?

This query took 0.025 seconds ⌛; show me the details?

        
0.025 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  118.336357,
                  5.5983
                ]
              }
            }
          }
        }
      ],
      "must_not": [
        {
          "terms": {
            "woe:placetype": [
              0,
              11,
              25
            ]
          }
        },
        {
          "term": {
            "geom:latitude": {
              "value": 0.0
            }
          }
        },
        {
          "term": {
            "geom:longitude": {
              "value": 0.0
            }
          }
        },
        {
          "exists": {
            "field": "woe:superseded_by"
          }
        }
      ]
    }
  },
  "aggs": {
    "placetypes": {
      "terms": {
        "field": "woe:placetype_name",
        "size": 10000
      }
    }
  },
  "sort": [
    {
      "woe:scale": {
        "order": "desc",
        "mode": "max"
      }
    },
    {
      "woe:id": {
        "order": "asc",
        "mode": "max"
      }
    }
  ]
}