21 places near Apotu, Whangarei District, Northland, New Zealand
filter by placetype:
  1. Kauri
    Kauri, Whangarei District, Northland, New Zealand (Town)
  2. Whangarei
    Whangarei, Whangarei District, Northland, New Zealand (Town)
  3. Apotu
    Apotu, Whangarei District, Northland, New Zealand (Town)
  4. Matarau
    Matarau, 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. Motukiore Island
    Motukiore Island, Northland, New Zealand (Island)
  9. Motutara Island
    Motutara 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.042 seconds ⌛; show me the details?

        
0.042 seconds ⌛

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