17 places near Rotoroa Island, Auckland, New Zealand
filter by placetype:
  1. Auckland
    Auckland, Auckland, New Zealand (Town)
  2. Cowes
    Cowes, Auckland, New Zealand (Town)
  3. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  4. Auckland City
    Auckland City, Auckland, New Zealand (Colloquial)
  5. Rotoroa Island
    Rotoroa Island, Auckland, New Zealand (Island)
  6. Waiheke Island
    Waiheke Island, Auckland, New Zealand (Island)
  7. North Island
    North Island, New Zealand (Island)
  8. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  9. Auckland
    Auckland, Auckland, New Zealand (State)
  10. Waikato
    Waikato, Waikato, New Zealand (State)

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.196838,
                  -36.81554
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}