2 places near Waterford, Oakland, Michigan, United States
filter by placetype:
  1. John D. Pierce Middle School
    John D. Pierce Middle School, Oakland, Michigan, United States (POI)
  2. Waterford Kettering High School
    Waterford Kettering High School, Oakland, Michigan, United States (POI)

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

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

        
0.045 seconds ⌛

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