33 places near Royal Oak, Auckland, New Zealand
filter by placetype:
  1. Greenlane
    Greenlane, Auckland, New Zealand (Suburb)
  2. Hillsborough
    Hillsborough, Auckland, New Zealand (Suburb)
  3. One Tree Hill
    One Tree Hill, Auckland, New Zealand (Suburb)
  4. Royal Oak
    Royal Oak, Auckland, New Zealand (Suburb)
  5. Three Kings
    Three Kings, Auckland, New Zealand (Suburb)
  6. Epsom South
    Epsom South, Auckland, New Zealand (Suburb)
  7. Onehunga North
    Onehunga North, Auckland, New Zealand (Suburb)
  8. Oranga
    Oranga, Auckland, New Zealand (Suburb)
  9. Greenwoods Corner
    Greenwoods Corner, Auckland, New Zealand (Suburb)
  10. Onehunga Central
    Onehunga Central, Auckland, New Zealand (Suburb)

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

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

        
0.063 seconds ⌛

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