19 places near Ararua, Kaipara District, Northland, New Zealand
filter by placetype:
  1. Matakohe
    Matakohe, Kaipara District, Northland, New Zealand (Town)
  2. Taipuha
    Taipuha, Kaipara District, Northland, New Zealand (Town)
  3. Whangarei
    Whangarei, Whangarei District, Northland, New Zealand (Town)
  4. Ararua
    Ararua, Kaipara District, Northland, New Zealand (Town)
  5. Wairoa River
    Wairoa River, Northland, New Zealand (Drainage)
  6. North Auckland Peninsula
    North Auckland Peninsula, New Zealand (Colloquial)
  7. Pouto Peninsula
    Pouto Peninsula, Kaipara District, Northland, New Zealand (Colloquial)
  8. North Island
    North Island, New Zealand (Island)
  9. Kaipara District
    Kaipara District, Northland, New Zealand (County)
  10. Whangarei District
    Whangarei District, Northland, New Zealand (County)

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

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

        
0.046 seconds ⌛

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