26 places near Mount Pleasant, Cabarrus, North Carolina, United States
filter by placetype:
  1. Oldenburg
    Oldenburg, Cabarrus, North Carolina, United States (Suburb)
  2. Concord
    Concord, Cabarrus, North Carolina, United States (Town)
  3. Mount Pleasant
    Mount Pleasant, Cabarrus, North Carolina, United States (Town)
  4. Lake High Rock
    Lake High Rock, Rowan, North Carolina, United States (Drainage)
  5. Southern States
    Southern States, United States (Colloquial)
  6. South Atlantic States
    South Atlantic States, United States (Colloquial)
  7. The Carolinas
    The Carolinas, United States (Colloquial)
  8. East Coast
    East Coast, United States (Colloquial)
  9. US Eastern States
    US Eastern States, United States (Colloquial)
  10. Gulf of Mexico Coast
    Gulf of Mexico Coast, United States (Colloquial)

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

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

        
0.027 seconds ⌛

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