26 places near MSA Hartford-West Hartford-East Hartford, Connecticut, United States
filter by placetype:
  1. Middle America
    Middle America, United States (Colloquial)
  2. Continental United States
    Continental United States, United States (Colloquial)
  3. Connecticut River Valley
    Connecticut River Valley, Connecticut, United States (Colloquial)
  4. Appalachian Trail
    Appalachian Trail, United States (Colloquial)
  5. Hartford
    Hartford, Connecticut, United States (County)
  6. Middlesex
    Middlesex, Connecticut, United States (County)
  7. New Haven
    New Haven, Connecticut, United States (County)
  8. America/New_York
    America/New_York, United States (Timezone)
  9. Connecticut
    Connecticut, Connecticut, United States (State)
  10. New York
    New York, New York, United States (State)

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

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

        
0.021 seconds ⌛

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