15 places near Lake Rotorua, Rotorua District, Bay of Plenty, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Lake Rotorua
    Lake Rotorua, Rotorua District, Bay of Plenty, New Zealand (Drainage)
  3. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  4. North Island
    North Island, New Zealand (Island)
  5. Rotorua District
    Rotorua District, New Zealand (County)
  6. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  7. Bay of Plenty
    Bay of Plenty, Bay of Plenty, New Zealand (State)
  8. Waikato
    Waikato, Waikato, New Zealand (State)
  9. New Zealand
    New Zealand, New Zealand (Country)
  10. Australia
    Australia (Continent)

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

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

        
0.026 seconds ⌛

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