27 places near Sandy Grove, Davidson, North Carolina, United States
filter by placetype:
  1. Arbor Acres
    Arbor Acres, Davidson, North Carolina, United States (Suburb)
  2. Colonial Heights
    Colonial Heights, Davidson, North Carolina, United States (Suburb)
  3. Lexington
    Lexington, Davidson, North Carolina, United States (Town)
  4. Sandy Grove
    Sandy Grove, Davidson, North Carolina, United States (Town)
  5. Lake High Rock
    Lake High Rock, Rowan, North Carolina, United States (Drainage)
  6. Southern States
    Southern States, United States (Colloquial)
  7. South Atlantic States
    South Atlantic States, United States (Colloquial)
  8. The Carolinas
    The Carolinas, United States (Colloquial)
  9. East Coast
    East Coast, United States (Colloquial)
  10. US Eastern States
    US Eastern States, United States (Colloquial)

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

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

        
0.034 seconds ⌛

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