24 places near Collado Mediano, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Collado Mediano
    Collado Mediano, Madrid, Comunidad de Madrid, España (Town)
  2. Alpedrete
    Alpedrete, Madrid, Comunidad de Madrid, España (Town)
  3. Urbanización la Serranilla
    Urbanización la Serranilla, Madrid, Comunidad de Madrid, España (Town)
  4. Urbanización Fuente Del Vaso
    Urbanización Fuente Del Vaso, Madrid, Comunidad de Madrid, España (Town)
  5. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  6. Ebro River
    Ebro River, España (Drainage)
  7. Alpedrete
    Alpedrete, Madrid, Comunidad de Madrid, España (LocalAdmin)
  8. Collado Mediano
    Collado Mediano, Madrid, Comunidad de Madrid, España (LocalAdmin)
  9. Guadarrama
    Guadarrama, Madrid, Comunidad de Madrid, España (LocalAdmin)
  10. Madrid
    Madrid, Comunidad de Madrid, España (County)

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

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

        
0.035 seconds ⌛

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