18 places near Waikanae River, Kapiti Coast District, Wellington, New Zealand
filter by placetype:
  1. Paraparaumu
    Paraparaumu, Kapiti Coast District, Wellington, New Zealand (Town)
  2. Paraparaumu Beach
    Paraparaumu Beach, Kapiti Coast District, Wellington, New Zealand (Town)
  3. Waikanae
    Waikanae, Kapiti Coast District, Wellington, New Zealand (Town)
  4. Otaihanga
    Otaihanga, Kapiti Coast District, Wellington, New Zealand (Town)
  5. Waikanae Beach
    Waikanae Beach, Kapiti Coast District, Wellington, New Zealand (Town)
  6. Waikanae River
    Waikanae River, Kapiti Coast District, Wellington, New Zealand (Drainage)
  7. North Island
    North Island, New Zealand (Island)
  8. Kapiti Coast District
    Kapiti Coast District, Wellington, New Zealand (County)
  9. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  10. Wellington
    Wellington, Wellington, New Zealand (State)

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

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

        
0.015 seconds ⌛

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