19 places near Waihou River, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Mangaiti
    Mangaiti, Matamata Piako District, Waikato, New Zealand (Town)
  3. Tirohia
    Tirohia, Hauraki District, Waikato, New Zealand (Town)
  4. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  5. Waihou River
    Waihou River, Waikato, New Zealand (Drainage)
  6. Coromandel Peninsula
    Coromandel Peninsula, New Zealand (Colloquial)
  7. North Island
    North Island, New Zealand (Island)
  8. Matamata Piako District
    Matamata Piako District, Waikato, New Zealand (County)
  9. Hauraki District
    Hauraki District, Waikato, New Zealand (County)
  10. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)

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

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

        
0.033 seconds ⌛

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