16 places near Ratahan, Minahasa, Sulawesi Utara, Republik Indonesia
filter by placetype:
  1. Ratahan
    Ratahan, Minahasa, Sulawesi Utara, Republik Indonesia (Town)
  2. Melanesia
    Melanesia (Colloquial)
  3. Sulawesi
    Sulawesi, Republik Indonesia (Island)
  4. Minahasa
    Minahasa, Sulawesi Utara, Republik Indonesia (County)
  5. Minahasa Selatan
    Minahasa Selatan, Sulawesi Utara, Republik Indonesia (County)
  6. Asia/Jayapura
    Asia/Jayapura, Republik Indonesia (Timezone)
  7. Asia/Makassar
    Asia/Makassar, Republik Indonesia (Timezone)
  8. Maluku Utara
    Maluku Utara, Republik Indonesia (State)
  9. Sulawesi Utara
    Sulawesi Utara, Sulawesi Utara, Republik Indonesia (State)
  10. Republik Indonesia
    Republik Indonesia, Republik Indonesia (Country)

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

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

        
0.034 seconds ⌛

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