23 places near St. Helens, Columbia, Oregon, United States
filter by placetype:
  1. William Clark Intermediate School
    William Clark Intermediate School, Columbia, Oregon, United States (POI)
  2. St. Helens
    St. Helens, Columbia, Oregon, United States (Town)
  3. Columbia Basin
    Columbia Basin, United States (Colloquial)
  4. Pacific States
    Pacific States, United States (Colloquial)
  5. West Coast
    West Coast, United States (Colloquial)
  6. Pacific Northwest
    Pacific Northwest, United States (Colloquial)
  7. US Western States
    US Western States, United States (Colloquial)
  8. Canada International Border States
    Canada International Border States, United States (Colloquial)
  9. Continental United States
    Continental United States, United States (Colloquial)
  10. Columbia River Plateau
    Columbia River Plateau, United States (Colloquial)

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

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

        
0.041 seconds ⌛

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