27 places near Columbia, Houston, Alabama, United States
filter by placetype:
  1. Interior Plains
    Interior Plains, United States (Colloquial)
  2. Continental United States
    Continental United States, United States (Colloquial)
  3. Southwest Georgia
    Southwest Georgia, Georgia, United States (Colloquial)
  4. East South Central States
    East South Central States, United States (Colloquial)
  5. Houston
    Houston, Alabama, United States (County)
  6. Early
    Early, Georgia, United States (County)
  7. America/New_York
    America/New_York, United States (Timezone)
  8. America/Chicago
    America/Chicago, United States (Timezone)
  9. Alabama
    Alabama, Alabama, United States (State)
  10. Georgia
    Georgia, Georgia, United States (State)

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

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

        
0.01 seconds ⌛

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