34 places near Fairview, Hamilton, Tennessee, United States
filter by placetype:
  1. Colonial Shores
    Colonial Shores, Hamilton, Tennessee, United States (Suburb)
  2. Fairview
    Fairview, Hamilton, Tennessee, United States (Suburb)
  3. Northshore Hills
    Northshore Hills, Hamilton, Tennessee, United States (Suburb)
  4. Ridge Lake North
    Ridge Lake North, Hamilton, Tennessee, United States (Suburb)
  5. Riverchase
    Riverchase, Hamilton, Tennessee, United States (Suburb)
  6. Hixson-North River
    Hixson-North River, Hamilton, Tennessee, United States (Suburb)
  7. Big Ridge
    Big Ridge, Hamilton, Tennessee, United States (Suburb)
  8. Riverwood
    Riverwood, Hamilton, Tennessee, United States (Suburb)
  9. Chattanooga
    Chattanooga, Hamilton, Tennessee, United States (Town)
  10. Harrison
    Harrison, Hamilton, Tennessee, United States (Town)

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

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

        
0.022 seconds ⌛

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