17 places near Kaipara Flats, Auckland, New Zealand
filter by placetype:
  1. Auckland
    Auckland, Auckland, New Zealand (Town)
  2. Kaipara Flats
    Kaipara Flats, Auckland, New Zealand (Town)
  3. Kourawhero
    Kourawhero, Auckland, New Zealand (Town)
  4. Hoteo River
    Hoteo River, Rodney District, Auckland, New Zealand (Drainage)
  5. Rodney District
    Rodney District, Auckland, New Zealand (Colloquial)
  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. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  10. Auckland
    Auckland, Auckland, New Zealand (State)

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

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

        
0.014 seconds ⌛

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