23 places near Avondale North, Auckland, New Zealand
filter by placetype:
  1. Kelston
    Kelston, 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.048 seconds ⌛; show me the details?

        
0.048 seconds ⌛

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