17 places near Tetabuan Pulau, Division Sandakan, Sabah, Malaysia
filter by placetype:
  1. Sandakan
    Sandakan, Division Sandakan, Sabah, Malaysia (LocalAdmin)
  2. Labuk & Sugut
    Labuk & Sugut, Division Sandakan, Sabah, Malaysia (LocalAdmin)
  3. Borneo
    Borneo (Colloquial)
  4. Kanawi Pulau
    Kanawi Pulau, Division Sandakan, Sabah, Malaysia (Island)
  5. Pulau Linkabo Island
    Pulau Linkabo Island, Division Sandakan, Sabah, Malaysia (Island)
  6. Tetabuan Pulau
    Tetabuan Pulau, Division Sandakan, Sabah, Malaysia (Island)
  7. Division Sandakan
    Division Sandakan, Sabah, Malaysia (County)
  8. Asia/Manila
    Asia/Manila (Timezone)
  9. Asia/Kuching
    Asia/Kuching, Malaysia (Timezone)
  10. Indian Ocean
    Indian Ocean (Ocean)

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.691856,
                  6.02247
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}