26 places near 06051, Hartford, Connecticut, United States
filter by placetype:
  1. Roosevelt Middle School
    Roosevelt Middle School, Hartford, Connecticut, United States (POI)
  2. Chamberlain School
    Chamberlain School, Hartford, Connecticut, United States (POI)
  3. Elm Hill
    Elm Hill, Hartford, Connecticut, United States (Suburb)
  4. New Britain
    New Britain, Hartford, Connecticut, United States (Town)
  5. Newington
    Newington, Hartford, Connecticut, United States (Town)
  6. New England
    New England, United States (Colloquial)
  7. East Coast
    East Coast, United States (Colloquial)
  8. US Eastern States
    US Eastern States, United States (Colloquial)
  9. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)
  10. Northeastern States
    Northeastern States, United States (Colloquial)

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

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

        
0.027 seconds ⌛

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