27 places near Sunnyvale, Auckland, New Zealand
filter by placetype:
  1. Oratia
    Oratia, Auckland, New Zealand (Suburb)
  2. Glendene
    Glendene, Auckland, New Zealand (Suburb)
  3. Sunnyvale
    Sunnyvale, Auckland, New Zealand (Suburb)
  4. Glen Eden West
    Glen Eden West, Auckland, New Zealand (Suburb)
  5. Henderson South
    Henderson South, Auckland, New Zealand (Suburb)
  6. McLaren Park
    McLaren Park, Auckland, New Zealand (Suburb)
  7. Henderson Central
    Henderson Central, Auckland, New Zealand (Suburb)
  8. Auckland
    Auckland, Auckland, New Zealand (Town)
  9. Waitakere
    Waitakere, Auckland, New Zealand (Town)
  10. Henderson
    Henderson, Auckland, New Zealand (Town)

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

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

        
0.047 seconds ⌛

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