31 places near Middletown, Middlesex, Connecticut, United States
filter by placetype:
  1. Macdonough School
    Macdonough School, Middlesex, Connecticut, United States (POI)
  2. St John School
    St John School, Middlesex, Connecticut, United States (POI)
  3. Saint Mary of Czestochowa School
    Saint Mary of Czestochowa School, Middlesex, Connecticut, United States (POI)
  4. South Farms
    South Farms, Middlesex, Connecticut, United States (Suburb)
  5. Middletown
    Middletown, Middlesex, Connecticut, United States (Town)
  6. Portland
    Portland, Middlesex, Connecticut, United States (Town)
  7. New England
    New England, United States (Colloquial)
  8. East Coast
    East Coast, United States (Colloquial)
  9. US Eastern States
    US Eastern States, United States (Colloquial)
  10. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)

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

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

        
0.019 seconds ⌛

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