23 places near Mission Bay, Auckland, New Zealand
filter by placetype:
  1. Orakei
    Orakei, Auckland, New Zealand (Suburb)
  2. Kohimarama
    Kohimarama, Auckland, New Zealand (Suburb)
  3. Mission Bay
    Mission Bay, Auckland, New Zealand (Suburb)
  4. Auckland
    Auckland, Auckland, New Zealand (Town)
  5. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  6. Manukau City
    Manukau City, Auckland, New Zealand (Town)
  7. South Auckland
    South Auckland, Auckland, New Zealand (Colloquial)
  8. Manukau City
    Manukau City, Auckland, New Zealand (Colloquial)
  9. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  10. Auckland City
    Auckland City, Auckland, New Zealand (Colloquial)

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

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

        
0.03 seconds ⌛

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