28 places near Sunnybrae, Auckland, New Zealand
filter by placetype:
  1. Hillcrest
    Hillcrest, Auckland, New Zealand (Suburb)
  2. Marlborough
    Marlborough, Auckland, New Zealand (Suburb)
  3. Glenfield East
    Glenfield East, Auckland, New Zealand (Suburb)
  4. Glenfield North
    Glenfield North, Auckland, New Zealand (Suburb)
  5. Westlake
    Westlake, Auckland, New Zealand (Suburb)
  6. Wairau Valley
    Wairau Valley, Auckland, New Zealand (Suburb)
  7. Northcote Central
    Northcote Central, Auckland, New Zealand (Suburb)
  8. Sunnybrae
    Sunnybrae, Auckland, New Zealand (Suburb)
  9. Glenfield Central
    Glenfield Central, Auckland, New Zealand (Suburb)
  10. Auckland
    Auckland, Auckland, New Zealand (Town)

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

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

        
0.024 seconds ⌛

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