24 places near Rosebank, Auckland, New Zealand
filter by placetype:
  1. Waterview
    Waterview, Auckland, New Zealand (Suburb)
  2. Avondale North
    Avondale North, Auckland, New Zealand (Suburb)
  3. Rosebank
    Rosebank, Auckland, New Zealand (Suburb)
  4. Avondale Central
    Avondale Central, Auckland, New Zealand (Suburb)
  5. Auckland
    Auckland, Auckland, New Zealand (Town)
  6. Avondale
    Avondale, Auckland, New Zealand (Town)
  7. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  8. Waitakere
    Waitakere, Auckland, New Zealand (Town)
  9. South Auckland
    South Auckland, Auckland, New Zealand (Colloquial)
  10. Waitakere City
    Waitakere City, Auckland, New Zealand (Colloquial)

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": [
                  174.68483,
                  -36.887379
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}