21 places near Guadarrama, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Espinar
    Espinar, Segovia, Castilla y León, España (Town)
  2. Guadarrama
    Guadarrama, Madrid, Comunidad de Madrid, España (Town)
  3. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  4. Ebro River
    Ebro River, España (Drainage)
  5. Guadarrama
    Guadarrama, Madrid, Comunidad de Madrid, España (LocalAdmin)
  6. El Espinar
    El Espinar, Segovia, Castilla y León, España (LocalAdmin)
  7. Madrid
    Madrid, Comunidad de Madrid, España (County)
  8. Segovia
    Segovia, Castilla y León, España (County)
  9. Europe/Madrid
    Europe/Madrid, España (Timezone)
  10. Comunidad de Madrid
    Comunidad de Madrid, España (State)

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

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

        
0.065 seconds ⌛

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