32 places near Puketapapa Local Board, Auckland, New Zealand
filter by placetype:
  1. Mount Roskill
    Mount Roskill, Auckland, New Zealand (Suburb)
  2. Balmoral
    Balmoral, Auckland, New Zealand (Suburb)
  3. Hillsborough
    Hillsborough, Auckland, New Zealand (Suburb)
  4. Roskill
    Roskill, Auckland, New Zealand (Suburb)
  5. Royal Oak
    Royal Oak, Auckland, New Zealand (Suburb)
  6. Sandringham
    Sandringham, Auckland, New Zealand (Suburb)
  7. Three Kings
    Three Kings, Auckland, New Zealand (Suburb)
  8. Epsom South
    Epsom South, Auckland, New Zealand (Suburb)
  9. Mount Eden South
    Mount Eden South, 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.021 seconds ⌛; show me the details?

        
0.021 seconds ⌛

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