26 places near Farmington, Hartford, Connecticut, United States
filter by placetype:
  1. Farmington High School
    Farmington High School, Hartford, Connecticut, United States (POI)
  2. River Glen
    River Glen, Hartford, Connecticut, United States (Suburb)
  3. Farmington
    Farmington, Hartford, Connecticut, United States (Town)
  4. Unionville
    Unionville, Hartford, Connecticut, United States (Town)
  5. Park River
    Park River, Hartford, Connecticut, United States (Drainage)
  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.031 seconds ⌛; show me the details?

        
0.031 seconds ⌛

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