27 places near Columbiana, Shelby, Alabama, United States
filter by placetype:
  1. Shelby County High School
    Shelby County High School, Shelby, Alabama, United States (POI)
  2. Elvin Hill Elementary School
    Elvin Hill Elementary School, Shelby, Alabama, United States (POI)
  3. Hillsdale
    Hillsdale, Shelby, Alabama, United States (Suburb)
  4. Columbiana
    Columbiana, Shelby, Alabama, United States (Town)
  5. Old Southwest
    Old Southwest, United States (Colloquial)
  6. Southern States
    Southern States, United States (Colloquial)
  7. South Atlantic States
    South Atlantic States, United States (Colloquial)
  8. East Coast
    East Coast, United States (Colloquial)
  9. US Eastern States
    US Eastern States, United States (Colloquial)
  10. Deep South
    Deep South, United States (Colloquial)

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

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

        
0.046 seconds ⌛

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