20 places near Lake Waipapa, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Mangakino
    Mangakino, Taupo District, Waikato, New Zealand (Town)
  3. Wiltsdown
    Wiltsdown, South Waikato District, Waikato, New Zealand (Town)
  4. Arohena
    Arohena, Otorohanga District, Waikato, New Zealand (Town)
  5. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  6. Lake Waipapa
    Lake Waipapa, Waikato, New Zealand (Drainage)
  7. North Island
    North Island, New Zealand (Island)
  8. Taupo District
    Taupo District, New Zealand (County)
  9. South Waikato District
    South Waikato District, Waikato, New Zealand (County)
  10. Otorohanga District
    Otorohanga District, Waikato, New Zealand (County)

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

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

        
0.042 seconds ⌛

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