33 places near MSA Charlotte-Gastonia-Concord, United States
filter by placetype:
  1. Apple Creek
    Apple Creek, Mecklenburg, North Carolina, United States (Suburb)
  2. Mint Hollow
    Mint Hollow, Mecklenburg, North Carolina, United States (Suburb)
  3. Morris Park
    Morris Park, Mecklenburg, North Carolina, United States (Suburb)
  4. Tarawoods
    Tarawoods, Mecklenburg, North Carolina, United States (Suburb)
  5. Eastland
    Eastland, Mecklenburg, North Carolina, United States (Suburb)
  6. East Charlotte
    East Charlotte, Mecklenburg, North Carolina, United States (Suburb)
  7. Charlotte
    Charlotte, Mecklenburg, North Carolina, United States (Town)
  8. Matthews
    Matthews, Mecklenburg, North Carolina, United States (Town)
  9. Mint Hill
    Mint Hill, Mecklenburg, North Carolina, United States (Town)
  10. Southern States
    Southern States, United States (Colloquial)

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": [
                  -80.670471,
                  35.162331
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}