21 places near Melinsau, Division Sandakan, Sabah, Malaysia
filter by placetype:
  1. Kampong Melinsau
    Kampong Melinsau, Division Sandakan, Sabah, Malaysia (Town)
  2. Melinsau
    Melinsau, Division Sandakan, Sabah, Malaysia (Town)
  3. Ranau
    Ranau, Division Pantai Barat Selatan, Sabah, Malaysia (LocalAdmin)
  4. Kota Marudu
    Kota Marudu, Division Kudat, Sabah, Malaysia (LocalAdmin)
  5. Labuk & Sugut
    Labuk & Sugut, Division Sandakan, Sabah, Malaysia (LocalAdmin)
  6. Borneo
    Borneo (Colloquial)
  7. Division Pantai Barat Selatan
    Division Pantai Barat Selatan, Sabah, Malaysia (County)
  8. Division Sandakan
    Division Sandakan, Sabah, Malaysia (County)
  9. Division Kudat
    Division Kudat, Sabah, Malaysia (County)
  10. Asia/Manila
    Asia/Manila (Timezone)

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

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

        
0.022 seconds ⌛

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