30 places near Kaipatiki Local Board, Auckland, New Zealand
filter by placetype:
  1. Campbells Bay
    Campbells Bay, Auckland, New Zealand (Suburb)
  2. Mairangi Bay
    Mairangi Bay, Auckland, New Zealand (Suburb)
  3. Forrest Hill
    Forrest Hill, Auckland, New Zealand (Suburb)
  4. Meadowood
    Meadowood, Auckland, New Zealand (Suburb)
  5. Sunnynook
    Sunnynook, Auckland, New Zealand (Suburb)
  6. Sunset North
    Sunset North, Auckland, New Zealand (Suburb)
  7. Totaravale
    Totaravale, Auckland, New Zealand (Suburb)
  8. Wairau Park
    Wairau Park, Auckland, New Zealand (Suburb)
  9. Windsor Park
    Windsor Park, 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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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