25 places near Avon, Houston, Alabama, United States
filter by placetype:
  1. Avon
    Avon, Houston, Alabama, United States (Town)
  2. Cowarts
    Cowarts, Houston, Alabama, United States (Town)
  3. Dothan
    Dothan, Houston, Alabama, United States (Town)
  4. Old Southwest
    Old Southwest, United States (Colloquial)
  5. Southern States
    Southern States, United States (Colloquial)
  6. South Atlantic States
    South Atlantic States, United States (Colloquial)
  7. East Coast
    East Coast, 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.019 seconds ⌛; show me the details?

        
0.019 seconds ⌛

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