27 places near Hungary, Hartford, Connecticut, United States
filter by placetype:
  1. Hungary
    Hungary, Hartford, Connecticut, United States (Suburb)
  2. Mechanicsville
    Mechanicsville, Hartford, Connecticut, United States (Suburb)
  3. Salmon Brook
    Salmon Brook, Hartford, Connecticut, United States (Suburb)
  4. East Granby
    East Granby, Hartford, Connecticut, United States (Town)
  5. Granby
    Granby, Hartford, Connecticut, United States (Town)
  6. Suffield
    Suffield, Hartford, 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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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