25 places near Oratia, Auckland, New Zealand
filter by placetype:
  1. Oratia
    Oratia, Auckland, New Zealand (Suburb)
  2. Sunnyvale
    Sunnyvale, Auckland, New Zealand (Suburb)
  3. Glen Eden West
    Glen Eden West, Auckland, New Zealand (Suburb)
  4. Glen Eden South
    Glen Eden South, Auckland, New Zealand (Suburb)
  5. Glen Eden Central
    Glen Eden Central, Auckland, New Zealand (Suburb)
  6. Auckland
    Auckland, Auckland, New Zealand (Town)
  7. Waiatarua
    Waiatarua, Auckland, New Zealand (Town)
  8. Waitakere
    Waitakere, Auckland, New Zealand (Town)
  9. Henderson
    Henderson, Auckland, New Zealand (Town)
  10. Henderson Valley
    Henderson Valley, Auckland, New Zealand (Town)

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

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

        
0.029 seconds ⌛

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