27 places near Hillcrest, Auckland, New Zealand
filter by placetype:
  1. Birkenhead
    Birkenhead, Auckland, New Zealand (Suburb)
  2. Hillcrest
    Hillcrest, Auckland, New Zealand (Suburb)
  3. Marlborough
    Marlborough, Auckland, New Zealand (Suburb)
  4. Northcote
    Northcote, Auckland, New Zealand (Suburb)
  5. Northcote West
    Northcote West, Auckland, New Zealand (Suburb)
  6. Akoranga
    Akoranga, Auckland, New Zealand (Suburb)
  7. Westlake
    Westlake, Auckland, New Zealand (Suburb)
  8. Northcote Central
    Northcote Central, Auckland, New Zealand (Suburb)
  9. Sunnybrae
    Sunnybrae, 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.031 seconds ⌛; show me the details?

        
0.031 seconds ⌛

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