38 places near Columbia, Richland, South Carolina, United States
filter by placetype:
  1. City of Columbia Police Station
    City of Columbia Police Station, Richland, South Carolina, United States (POI)
  2. St Peters Catholic School
    St Peters Catholic School, Richland, South Carolina, United States (POI)
  3. Colonial Center
    Colonial Center, Richland, South Carolina, United States (POI)
  4. Columbia Station
    Columbia Station, Richland, South Carolina, United States (POI)
  5. Olympia
    Olympia, Richland, South Carolina, United States (Suburb)
  6. Arsenal Hill
    Arsenal Hill, Richland, South Carolina, United States (Suburb)
  7. Congaree Vista
    Congaree Vista, Richland, South Carolina, United States (Suburb)
  8. Downtown
    Downtown, Richland, South Carolina, United States (Suburb)
  9. Elmwood Park
    Elmwood Park, Richland, South Carolina, United States (Suburb)
  10. Gervais Street Corridor
    Gervais Street Corridor, Richland, South Carolina, United States (Suburb)

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

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

        
0.416 seconds ⌛

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