8 places near Marlborough, St. Louis, Missouri, United States
filter by placetype:
  1. Affton
    Affton, St. Louis, Missouri, United States (Town)
  2. Crestwood
    Crestwood, St. Louis, Missouri, United States (Town)
  3. Grantwood
    Grantwood, St. Louis, Missouri, United States (Town)
  4. Mackenzie
    Mackenzie, St. Louis, Missouri, United States (Town)
  5. Marlborough
    Marlborough, St. Louis, Missouri, United States (Town)
  6. St. Louis
    St. Louis, St. Louis City, Missouri, United States (Town)
  7. Shrewsbury
    Shrewsbury, St. Louis, Missouri, United States (Town)
  8. Webster Groves
    Webster Groves, St. Louis, Missouri, United States (Town)

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

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

        
0.034 seconds ⌛

{
  "query": {
    "bool": {
      "must": [
        {
          "geo_shape": {
            "geometry": {
              "shape": {
                "type": "circle",
                "radius": "1km",
                "coordinates": [
                  -90.337318,
                  38.570862
                ]
              }
            }
          }
        },
        {
          "term": {
            "woe:placetype": 7
          }
        }
      ],
      "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"
      }
    }
  ]
}