18 places near Mareretu, Kaipara District, Northland, New Zealand
filter by placetype:
  1. Mareretu
    Mareretu, Kaipara District, Northland, New Zealand (Town)
  2. Maungaturoto
    Maungaturoto, Kaipara District, Northland, New Zealand (Town)
  3. Taipuha
    Taipuha, Kaipara District, Northland, New Zealand (Town)
  4. Whangarei
    Whangarei, Whangarei 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. North Island
    North Island, New Zealand (Island)
  8. Kaipara District
    Kaipara District, Northland, New Zealand (County)
  9. Whangarei District
    Whangarei District, Northland, New Zealand (County)
  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.037 seconds ⌛; show me the details?

        
0.037 seconds ⌛

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