35 places near MSA Columbia, South Carolina, United States
filter by placetype:
  1. Irmo
    Irmo, South Carolina, United States (Suburb)
  2. Saint Andrews
    Saint Andrews, Richland, South Carolina, United States (Suburb)
  3. Whitehall
    Whitehall, Lexington, South Carolina, United States (Suburb)
  4. Seven Oaks
    Seven Oaks, Lexington, South Carolina, United States (Suburb)
  5. Lake Murray
    Lake Murray, Lexington, South Carolina, United States (Suburb)
  6. Murraywood
    Murraywood, Lexington, South Carolina, United States (Suburb)
  7. North Area
    North Area, Richland, South Carolina, United States (Suburb)
  8. Columbia
    Columbia, Richland, South Carolina, United States (Town)
  9. Gardendale
    Gardendale, Lexington, South Carolina, United States (Town)
  10. Grenadier
    Grenadier, Lexington, South Carolina, United States (Town)

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

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

        
0.05 seconds ⌛

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