28 places near East Haven, Colbert, Alabama, United States
filter by placetype:
  1. Highland Park Elementary School
    Highland Park Elementary School, Colbert, Alabama, United States (POI)
  2. Mcbride Elementary School
    Mcbride Elementary School, Colbert, Alabama, United States (POI)
  3. East Haven
    East Haven, Colbert, Alabama, United States (Suburb)
  4. Washington Park
    Washington Park, Colbert, Alabama, United States (Suburb)
  5. Muscle Shoals
    Muscle Shoals, Colbert, Alabama, United States (Town)
  6. Sheffield
    Sheffield, Colbert, Alabama, United States (Town)
  7. Tuscumbia
    Tuscumbia, Colbert, Alabama, United States (Town)
  8. Old Southwest
    Old Southwest, United States (Colloquial)
  9. Southern States
    Southern States, United States (Colloquial)
  10. US Eastern States
    US Eastern States, United States (Colloquial)

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

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

        
0.051 seconds ⌛

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