25 places near Cheatham Middle School, Red River, Texas, United States
filter by placetype:
  1. Clarksville Elementary School
    Clarksville Elementary School, Red River, Texas, United States (POI)
  2. Clarksville High School
    Clarksville High School, Red River, Texas, United States (POI)
  3. Cheatham Middle School
    Cheatham Middle School, Red River, Texas, United States (POI)
  4. Clarksville
    Clarksville, Red River, Texas, United States (Town)
  5. Pine Woods
    Pine Woods, Texas, United States (Colloquial)
  6. US Western States
    US Western States, United States (Colloquial)
  7. Southwestern States
    Southwestern States, United States (Colloquial)
  8. Old Southwest
    Old Southwest, United States (Colloquial)
  9. Southern States
    Southern States, United States (Colloquial)
  10. Mexico International Border States
    Mexico International Border States, United States (Colloquial)

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

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

        
0.031 seconds ⌛

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