30 places near Three Kings, Auckland, New Zealand
filter by placetype:
  1. Mount Roskill
    Mount Roskill, Auckland, New Zealand (Suburb)
  2. Hillsborough
    Hillsborough, Auckland, New Zealand (Suburb)
  3. Mount Roskill South
    Mount Roskill South, 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.037 seconds ⌛; show me the details?

        
0.037 seconds ⌛

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