23 places near Ottawa River, Canada
filter by placetype:
  1. Mattawan
    Mattawan, Nipissing, Ontario, Canada (Town)
  2. Papineau-Cameron
    Papineau-Cameron, Nipissing, Ontario, Canada (Town)
  3. Ottawa River
    Ottawa River, Canada (Drainage)
  4. East Coast
    East Coast, United States (Colloquial)
  5. US Eastern States
    US Eastern States, United States (Colloquial)
  6. Northeastern States
    Northeastern States, United States (Colloquial)
  7. Canada International Border States
    Canada International Border States, United States (Colloquial)
  8. Great Lakes Region
    Great Lakes Region, United States (Colloquial)
  9. Great North Woods
    Great North Woods, United States (Colloquial)
  10. Middle America
    Middle America, United States (Colloquial)

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

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

        
0.051 seconds ⌛

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