11 places near North Mangsee Island, Sabah, Malaysia
filter by placetype:
  1. Borneo
    Borneo (Colloquial)
  2. North Mangsee Island
    North Mangsee Island, Sabah, Malaysia (Island)
  3. Asia/Manila
    Asia/Manila (Timezone)
  4. Indian Ocean
    Indian Ocean (Ocean)
  5. South China Sea
    South China Sea (Sea)
  6. Asia
    Asia (Continent)
  7. Indo China
    Indo China (Supername)
  8. South East Asia
    South East Asia (Supername)
  9. Oceania
    Oceania (Supername)
  10. Far East
    Far East (Supername)

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

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

        
0.02 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  117.300003,
                  7.51667
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}