31 places near South Roxana, Madison, Illinois, United States
filter by placetype:
  1. South Roxana Elementary School
    South Roxana Elementary School, Madison, Illinois, United States (POI)
  2. Bethel Christian Academy
    Bethel Christian Academy, Madison, Illinois, United States (POI)
  3. Edwardsville
    Edwardsville, Madison, Illinois, United States (Town)
  4. Hartford
    Hartford, Madison, Illinois, United States (Town)
  5. Roxana
    Roxana, Madison, Illinois, United States (Town)
  6. South Roxana
    South Roxana, Madison, Illinois, United States (Town)
  7. Mid West
    Mid West, United States (Colloquial)
  8. US Western States
    US Western States, United States (Colloquial)
  9. Southwestern States
    Southwestern States, United States (Colloquial)
  10. Old Southwest
    Old Southwest, United States (Colloquial)

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

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

        
0.009 seconds ⌛

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