28 places near Henderson Valley, Auckland, New Zealand
filter by placetype:
  1. Oratia
    Oratia, Auckland, New Zealand (Suburb)
  2. Sunnyvale
    Sunnyvale, Auckland, New Zealand (Suburb)
  3. McLaren Park
    McLaren Park, Auckland, New Zealand (Suburb)
  4. Palm Heights
    Palm Heights, Auckland, New Zealand (Suburb)
  5. Western Heights
    Western Heights, Auckland, New Zealand (Suburb)
  6. Henderson Central
    Henderson Central, Auckland, New Zealand (Suburb)
  7. Auckland
    Auckland, Auckland, New Zealand (Town)
  8. Waiatarua
    Waiatarua, 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.024 seconds ⌛; show me the details?

        
0.024 seconds ⌛

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