25 places near Tri Cities Airport, Colbert, Alabama, United States
filter by placetype:
  1. Tri Cities Airport
    Tri Cities Airport, Colbert, Alabama, United States (Airport)
  2. Richmond Hills
    Richmond Hills, Colbert, Alabama, United States (Suburb)
  3. Trenholm Heights
    Trenholm Heights, Colbert, Alabama, United States (Suburb)
  4. Valdosta
    Valdosta, Colbert, Alabama, United States (Suburb)
  5. Tuscumbia
    Tuscumbia, Colbert, Alabama, United States (Town)
  6. Old Southwest
    Old Southwest, United States (Colloquial)
  7. Southern States
    Southern States, United States (Colloquial)
  8. US Eastern States
    US Eastern States, United States (Colloquial)
  9. Deep South
    Deep South, United States (Colloquial)
  10. Gulf of Mexico Coast
    Gulf of Mexico Coast, United States (Colloquial)

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

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

        
0.023 seconds ⌛

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