31 places near Totaravale, Auckland, New Zealand
filter by placetype:
  1. Auckland
    Auckland, Auckland, New Zealand (Town)
  2. East Coast Bays
    East Coast Bays, Auckland, New Zealand (Town)
  3. Glenfield
    Glenfield, Auckland, New Zealand (Town)
  4. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  5. North Shore
    North Shore, Auckland, New Zealand (Town)
  6. North Shore City
    North Shore City, Auckland, New Zealand (Colloquial)
  7. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  8. Auckland City
    Auckland City, Auckland, New Zealand (Colloquial)
  9. Kaipatiki Local Board
    Kaipatiki Local Board, Auckland, New Zealand (Colloquial)
  10. North Island
    North Island, New Zealand (Island)

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

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

        
0.046 seconds ⌛

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