26 places near Mairangi Bay, 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. Murrays Bay
    Murrays Bay, Auckland, New Zealand (Suburb)
  4. Rothesay Bay
    Rothesay Bay, Auckland, New Zealand (Suburb)
  5. Sunnynook
    Sunnynook, Auckland, New Zealand (Suburb)
  6. Windsor Park
    Windsor Park, Auckland, New Zealand (Suburb)
  7. Auckland
    Auckland, Auckland, New Zealand (Town)
  8. East Coast Bays
    East Coast Bays, Auckland, New Zealand (Town)
  9. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  10. North Shore
    North Shore, Auckland, New Zealand (Town)

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

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

        
0.013 seconds ⌛

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