27 places near Johnnycake Airport, Hartford, Connecticut, United States
filter by placetype:
  1. Johnnycake Airport
    Johnnycake Airport, Hartford, Connecticut, United States (Airport)
  2. Burlington
    Burlington, Hartford, Connecticut, United States (Town)
  3. Harwinton
    Harwinton, Litchfield, Connecticut, United States (Town)
  4. Torrington
    Torrington, Litchfield, Connecticut, United States (Town)
  5. New England
    New England, United States (Colloquial)
  6. East Coast
    East Coast, United States (Colloquial)
  7. US Eastern States
    US Eastern States, United States (Colloquial)
  8. Middle Atlantic States
    Middle Atlantic States, United States (Colloquial)
  9. Northeastern States
    Northeastern States, United States (Colloquial)
  10. Canada International Border States
    Canada International Border States, United States (Colloquial)

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

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

        
0.017 seconds ⌛

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