39 places near Columbia, Boone, Missouri, United States
filter by placetype:
  1. Columbia College
    Columbia College, Boone, Missouri, United States (POI)
  2. Stephens College
    Stephens College, Boone, Missouri, United States (POI)
  3. John Ridgeway Elementary School
    John Ridgeway Elementary School, Boone, Missouri, United States (POI)
  4. Robert E. Lee Elementary School
    Robert E. Lee Elementary School, Boone, Missouri, United States (POI)
  5. Ulysses S. Grant Elementary School
    Ulysses S. Grant Elementary School, Boone, Missouri, United States (POI)
  6. Stephens College Childrens School
    Stephens College Childrens School, Boone, Missouri, United States (POI)
  7. Banks
    Banks, Boone, Missouri, United States (Suburb)
  8. Columbia Original Town
    Columbia Original Town, Boone, Missouri, United States (Suburb)
  9. Ellis Library
    Ellis Library, Boone, Missouri, United States (Suburb)
  10. Grasslands
    Grasslands, Boone, Missouri, United States (Suburb)

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

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

        
0.032 seconds ⌛

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