20 places near Waipa River, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Te Awamutu
    Te Awamutu, Waipa District, Waikato, New Zealand (Town)
  3. Ngahinapouri
    Ngahinapouri, Waipa District, Waikato, New Zealand (Town)
  4. Te Rore
    Te Rore, Waipa District, Waikato, New Zealand (Town)
  5. Te Pahu
    Te Pahu, Waipa District, Waikato, New Zealand (Town)
  6. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  7. Waipa River
    Waipa River, Waikato, New Zealand (Drainage)
  8. North Island
    North Island, New Zealand (Island)
  9. Waipa District
    Waipa District, Waikato, New Zealand (County)
  10. Waikato District
    Waikato District, Waikato, New Zealand (County)

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

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

        
0.031 seconds ⌛

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