22 places near Te Aroha Aerodrome, Matamata Piako District, Waikato, New Zealand
  1. Te Aroha Aerodrome
    Te Aroha Aerodrome, Matamata Piako District, Waikato, New Zealand (Airport)
  2. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  3. Mangaiti
    Mangaiti, Matamata Piako District, Waikato, New Zealand (Town)
  4. Tahuna
    Tahuna, Matamata Piako District, Waikato, New Zealand (Town)
  5. Tirohia
    Tirohia, Hauraki District, Waikato, New Zealand (Town)
  6. Elstow
    Elstow, Matamata Piako District, Waikato, New Zealand (Town)
  7. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  8. Waihou River
    Waihou River, Waikato, New Zealand (Drainage)
  9. Coromandel Peninsula
    Coromandel Peninsula, New Zealand (Colloquial)
  10. North Island
    North Island, New Zealand (Island)

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

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

        
0.032 seconds ⌛

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