20 places near Lake Rotongaro, Waikato District, Waikato, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Pukekapia
    Pukekapia, Waikato District, Waikato, New Zealand (Town)
  3. Rangiriri
    Rangiriri, Waikato District, Waikato, New Zealand (Town)
  4. Rotongaro
    Rotongaro, Waikato District, Waikato, New Zealand (Town)
  5. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  6. Lake Rotongaro
    Lake Rotongaro, Waikato District, Waikato, New Zealand (Drainage)
  7. South Auckland
    South Auckland, Auckland, New Zealand (Colloquial)
  8. Franklin District
    Franklin District, New Zealand (Colloquial)
  9. North Island
    North Island, New Zealand (Island)
  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.011 seconds ⌛; show me the details?

        
0.011 seconds ⌛

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