24 places near 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. East South Central States
    East South Central States, United States (Colloquial)
  4. Houston
    Houston, Alabama, United States (County)
  5. America/New_York
    America/New_York, United States (Timezone)
  6. America/Chicago
    America/Chicago, United States (Timezone)
  7. Alabama
    Alabama, Alabama, United States (State)
  8. United States
    United States, United States (Country)
  9. North America
    North America (Continent)
  10. Central America
    Central America (Supername)

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

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

        
0.028 seconds ⌛

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