25 places near Missouri, Missouri, United States
filter by placetype:
  1. Mid West
    Mid West, United States (Colloquial)
  2. US Western States
    US Western States, United States (Colloquial)
  3. Southwestern States
    Southwestern States, United States (Colloquial)
  4. Old Southwest
    Old Southwest, United States (Colloquial)
  5. Southern States
    Southern States, United States (Colloquial)
  6. US Eastern States
    US Eastern States, United States (Colloquial)
  7. Northeastern States
    Northeastern States, United States (Colloquial)
  8. Civil War Border States
    Civil War Border States, United States (Colloquial)
  9. Great Lakes Region
    Great Lakes Region, 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.018 seconds ⌛; show me the details?

        
0.018 seconds ⌛

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