25 places near Roxana, Randolph, North Carolina, United States
filter by placetype:
  1. Robins Nest
    Robins Nest, Randolph, North Carolina, United States (Suburb)
  2. Roxana
    Roxana, Randolph, North Carolina, United States (Suburb)
  3. Archdale
    Archdale, Randolph, North Carolina, United States (Town)
  4. Progress
    Progress, Randolph, North Carolina, United States (Town)
  5. Trinity
    Trinity, Randolph, North Carolina, United States (Town)
  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.027 seconds ⌛; show me the details?

        
0.027 seconds ⌛

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