21 places near Mangakahia River, Northland, New Zealand
filter by placetype:
  1. Nukutawhiti
    Nukutawhiti, Whangarei District, Northland, New Zealand (Town)
  2. Whangarei
    Whangarei, Whangarei District, Northland, New Zealand (Town)
  3. Opouteke
    Opouteke, Whangarei District, Northland, New Zealand (Town)
  4. Twin Bridges
    Twin Bridges, Whangarei District, Northland, New Zealand (Town)
  5. Wairoa River
    Wairoa River, Northland, New Zealand (Drainage)
  6. Mangakahia River
    Mangakahia River, Northland, New Zealand (Drainage)
  7. North Auckland Peninsula
    North Auckland Peninsula, New Zealand (Colloquial)
  8. North Island
    North Island, New Zealand (Island)
  9. Motukiore Island
    Motukiore Island, Northland, New Zealand (Island)
  10. Far North District
    Far North District, Northland, New Zealand (County)

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

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

        
0.023 seconds ⌛

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