27 places near Sunnyvale, Auckland, New Zealand
filter by placetype:
  1. New Lynn
    New Lynn, Auckland, New Zealand (Town)
  2. Waitakere
    Waitakere, Auckland, New Zealand (Town)
  3. South Auckland
    South Auckland, Auckland, New Zealand (Colloquial)
  4. Waitakere City
    Waitakere City, Auckland, New Zealand (Colloquial)
  5. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  6. Henderson-Massey Local Board
    Henderson-Massey Local Board, Auckland, New Zealand (Colloquial)
  7. North Island
    North Island, New Zealand (Island)
  8. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  9. Auckland
    Auckland, Auckland, New Zealand (State)
  10. Waikato
    Waikato, Waikato, New Zealand (State)

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

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

        
0.011 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"
      }
    }
  ],
  "from": 10
}