24 places near Madisonville, Ralls, Missouri, United States
filter by placetype:
  1. Great Lakes Region
    Great Lakes Region, United States (Colloquial)
  2. Middle America
    Middle America, United States (Colloquial)
  3. Interior Plains
    Interior Plains, United States (Colloquial)
  4. Continental United States
    Continental United States, United States (Colloquial)
  5. West North Central States
    West North Central States, United States (Colloquial)
  6. East North Central States
    East North Central States, United States (Colloquial)
  7. Ralls
    Ralls, Missouri, United States (County)
  8. America/Chicago
    America/Chicago, United States (Timezone)
  9. Missouri
    Missouri, Missouri, United States (State)
  10. United States
    United States, United States (Country)

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

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

        
0.076 seconds ⌛

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