19 places near Coatesville, Auckland, New Zealand
filter by placetype:
  1. Paremoremo
    Paremoremo, Auckland, New Zealand (Suburb)
  2. Auckland
    Auckland, Auckland, New Zealand (Town)
  3. Coatesville
    Coatesville, Auckland, New Zealand (Town)
  4. North Shore
    North Shore, Auckland, New Zealand (Town)
  5. Redvale
    Redvale, Auckland, New Zealand (Town)
  6. Riverhead
    Riverhead, Auckland, New Zealand (Town)
  7. North Shore City
    North Shore City, Auckland, New Zealand (Colloquial)
  8. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  9. North Island
    North Island, New Zealand (Island)
  10. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)

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

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

        
0.025 seconds ⌛

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