21 places near Columbia River Plateau, United States
filter by placetype:
  1. Cascadia
    Cascadia, United States (Colloquial)
  2. Eastern Washington
    Eastern Washington, Washington, United States (Colloquial)
  3. Mountain States
    Mountain States, United States (Colloquial)
  4. Benton
    Benton, Washington, United States (County)
  5. America/Los_Angeles
    America/Los_Angeles, United States (Timezone)
  6. Washington
    Washington, Washington, United States (State)
  7. United States
    United States, United States (Country)
  8. North America
    North America (Continent)
  9. Americas
    Americas (Supername)
  10. Northern America
    Northern America (Supername)

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

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

        
0.034 seconds ⌛

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