25 places near Campbells 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. Castor Bay
    Castor Bay, Auckland, New Zealand (Suburb)
  4. Forrest Hill
    Forrest Hill, Auckland, New Zealand (Suburb)
  5. Sunnynook
    Sunnynook, Auckland, New Zealand (Suburb)
  6. Auckland
    Auckland, Auckland, New Zealand (Town)
  7. East Coast Bays
    East Coast Bays, Auckland, New Zealand (Town)
  8. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  9. North Shore
    North Shore, Auckland, New Zealand (Town)
  10. North Shore City
    North Shore 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.756165,
                  -36.747921
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}