25 places near Takapuna, Auckland, New Zealand
filter by placetype:
  1. Takapuna
    Takapuna, Auckland, New Zealand (Suburb)
  2. Milford
    Milford, Auckland, New Zealand (Suburb)
  3. Akoranga
    Akoranga, Auckland, New Zealand (Suburb)
  4. Hauraki
    Hauraki, Auckland, New Zealand (Suburb)
  5. Westlake
    Westlake, Auckland, New Zealand (Suburb)
  6. Northcote Central
    Northcote Central, Auckland, New Zealand (Suburb)
  7. Auckland
    Auckland, Auckland, New Zealand (Town)
  8. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  9. North Shore
    North Shore, Auckland, New Zealand (Town)
  10. Lake Pupuke
    Lake Pupuke, North Shore City, Auckland, New Zealand (Drainage)

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

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

        
0.033 seconds ⌛

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