17 places near Wairoa River, Northland, New Zealand
filter by placetype:
  1. Kirikopuni
    Kirikopuni, Kaipara District, Northland, New Zealand (Town)
  2. Tangiteroria
    Tangiteroria, Kaipara District, Northland, New Zealand (Town)
  3. Whangarei
    Whangarei, Whangarei District, Northland, New Zealand (Town)
  4. Wairoa River
    Wairoa River, Northland, New Zealand (Drainage)
  5. North Auckland Peninsula
    North Auckland Peninsula, New Zealand (Colloquial)
  6. North Island
    North Island, New Zealand (Island)
  7. Kaipara District
    Kaipara District, Northland, New Zealand (County)
  8. Whangarei District
    Whangarei District, Northland, New Zealand (County)
  9. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  10. Northland
    Northland, Northland, New Zealand (State)

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

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

        
0.009 seconds ⌛

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