26 places near Rosehill, Auckland, New Zealand
filter by placetype:
  1. Papakura South
    Papakura South, Auckland, New Zealand (Suburb)
  2. Pahurehure
    Pahurehure, Auckland, New Zealand (Suburb)
  3. Rosehill
    Rosehill, Auckland, New Zealand (Suburb)
  4. Papakura Central
    Papakura Central, Auckland, New Zealand (Suburb)
  5. Ardmore
    Ardmore, Auckland, New Zealand (Town)
  6. Auckland
    Auckland, Auckland, New Zealand (Town)
  7. Drury
    Drury, Auckland, New Zealand (Town)
  8. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  9. Opaheke
    Opaheke, Auckland, New Zealand (Town)
  10. Papakura
    Papakura, Auckland, New Zealand (Town)

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

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

        
0.014 seconds ⌛

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