18 places near Douglas Corner, Western Bay of Plenty District, Bay of Plenty, New Zealand
filter by placetype:
  1. Hamilton
    Hamilton, Hamilton City, Waikato, New Zealand (Town)
  2. Douglas Corner
    Douglas Corner, Western Bay of Plenty District, Bay of Plenty, New Zealand (Town)
  3. Mangatoi
    Mangatoi, Western Bay of Plenty District, Bay of Plenty, New Zealand (Town)
  4. Te Ranga
    Te Ranga, Western Bay of Plenty District, Bay of Plenty, New Zealand (Town)
  5. Waikato River
    Waikato River, Waikato, New Zealand (Drainage)
  6. Alderman Islands
    Alderman Islands, Bay of Plenty, New Zealand (Island)
  7. North Island
    North Island, New Zealand (Island)
  8. Western Bay of Plenty District
    Western Bay of Plenty District, Bay of Plenty, New Zealand (County)
  9. Pacific/Auckland
    Pacific/Auckland, New Zealand (Timezone)
  10. Bay of Plenty
    Bay of Plenty, Bay of Plenty, 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": [
                  176.263428,
                  -37.883228
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}