25 places near Midland, Cabarrus, North Carolina, United States
filter by placetype:
  1. Deer Run
    Deer Run, Cabarrus, North Carolina, United States (Suburb)
  2. Old Mill Village
    Old Mill Village, Cabarrus, North Carolina, United States (Suburb)
  3. Midland
    Midland, Cabarrus, North Carolina, United States (Town)
  4. Southern States
    Southern States, United States (Colloquial)
  5. South Atlantic States
    South Atlantic States, United States (Colloquial)
  6. The Carolinas
    The Carolinas, United States (Colloquial)
  7. East Coast
    East Coast, United States (Colloquial)
  8. US Eastern States
    US Eastern States, United States (Colloquial)
  9. Gulf of Mexico Coast
    Gulf of Mexico Coast, United States (Colloquial)
  10. Middle America
    Middle America, United States (Colloquial)

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

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

        
0.071 seconds ⌛

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