25 places near Columbus, Columbia, Wisconsin, United States
filter by placetype:
  1. Columbus Middle School
    Columbus Middle School, Columbia, Wisconsin, United States (POI)
  2. Columbus Elementary School
    Columbus Elementary School, Columbia, Wisconsin, United States (POI)
  3. Columbus
    Columbus, Columbia, Wisconsin, United States (Town)
  4. Mid West
    Mid West, United States (Colloquial)
  5. US Western States
    US Western States, United States (Colloquial)
  6. US Eastern States
    US Eastern States, United States (Colloquial)
  7. Northeastern States
    Northeastern States, United States (Colloquial)
  8. Canada International Border States
    Canada International Border States, United States (Colloquial)
  9. Great Lakes Region
    Great Lakes Region, 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.053 seconds ⌛; show me the details?

        
0.053 seconds ⌛

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