23 places near Redvale, Auckland, New Zealand
filter by placetype:
  1. Okura
    Okura, Auckland, New Zealand (Suburb)
  2. Auckland
    Auckland, Auckland, New Zealand (Town)
  3. East Coast Bays
    East Coast Bays, Auckland, New Zealand (Town)
  4. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  5. North Shore
    North Shore, Auckland, New Zealand (Town)
  6. Redvale
    Redvale, Auckland, New Zealand (Town)
  7. Stillwater
    Stillwater, Auckland, New Zealand (Town)
  8. Albany Heights
    Albany Heights, Auckland, New Zealand (Town)
  9. North Shore City
    North Shore City, Auckland, New Zealand (Colloquial)
  10. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)

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

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

        
0.021 seconds ⌛

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