27 places near Clear Creek, Mecklenburg, North Carolina, United States
filter by placetype:
  1. Clear Creek
    Clear Creek, Mecklenburg, North Carolina, United States (Town)
  2. Mint Hill
    Mint Hill, Mecklenburg, North Carolina, United States (Town)
  3. Southern States
    Southern States, United States (Colloquial)
  4. South Atlantic States
    South Atlantic States, United States (Colloquial)
  5. The Carolinas
    The Carolinas, United States (Colloquial)
  6. East Coast
    East Coast, United States (Colloquial)
  7. US Eastern States
    US Eastern States, United States (Colloquial)
  8. Deep South
    Deep South, United States (Colloquial)
  9. Gulf of Mexico Coast
    Gulf of Mexico Coast, United States (Colloquial)
  10. Middle America
    Middle America, United States (Colloquial)

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

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

        
0.026 seconds ⌛

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