36 places near MSA Cincinnati-Middletown, United States
filter by placetype:
  1. Cincinnati
    Cincinnati, Hamilton, Ohio, United States (Town)
  2. Covington
    Covington, Kenton, Kentucky, United States (Town)
  3. Highland Heights
    Highland Heights, Campbell, Kentucky, United States (Town)
  4. Newport
    Newport, Campbell, Kentucky, United States (Town)
  5. Taylor Mill
    Taylor Mill, Kenton, Kentucky, United States (Town)
  6. Wilder
    Wilder, Campbell, Kentucky, United States (Town)
  7. Mid West
    Mid West, United States (Colloquial)
  8. Old Southwest
    Old Southwest, United States (Colloquial)
  9. Southern States
    Southern States, United States (Colloquial)
  10. South Atlantic States
    South Atlantic States, United States (Colloquial)

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

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

        
0.02 seconds ⌛

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