32 places near Crestview Gardens, St. Clair, Alabama, United States
filter by placetype:
  1. Crestview Gardens
    Crestview Gardens, St. Clair, Alabama, United States (Suburb)
  2. Dellwood
    Dellwood, St. Clair, Alabama, United States (Suburb)
  3. Oak Ridge
    Oak Ridge, St. Clair, Alabama, United States (Suburb)
  4. Woodmont
    Woodmont, St. Clair, Alabama, United States (Suburb)
  5. Glen City
    Glen City, St. Clair, Alabama, United States (Town)
  6. Harrisburg
    Harrisburg, St. Clair, Alabama, United States (Town)
  7. Pell City
    Pell City, St. Clair, Alabama, United States (Town)
  8. Old Southwest
    Old Southwest, United States (Colloquial)
  9. Southern States
    Southern States, United States (Colloquial)
  10. South Atlantic States
    South Atlantic States, United States (Colloquial)

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

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

        
0.034 seconds ⌛

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