20 places near Lake Arapuni, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Waotu
    Waotu, South Waikato District, Waikato, New Zealand (Town)
  3. Wharepapa South
    Wharepapa South, Waipa 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 Arapuni
    Lake Arapuni, Waikato, New Zealand (Drainage)
  7. North Island
    North Island, New Zealand (Island)
  8. South Waikato District
    South Waikato District, Waikato, New Zealand (County)
  9. Otorohanga District
    Otorohanga District, Waikato, New Zealand (County)
  10. Waipa District
    Waipa District, Waikato, New Zealand (County)

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

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

        
0.028 seconds ⌛

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