35 places near San Isidro, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Estación de Oporto
    Estación de Oporto, Madrid, Comunidad de Madrid, España (POI)
  2. Estación de Urgel
    Estación de Urgel, Madrid, Comunidad de Madrid, España (POI)
  3. Carabanchel
    Carabanchel, Madrid, Comunidad de Madrid, España (Suburb)
  4. Acacias
    Acacias, Madrid, Comunidad de Madrid, España (Suburb)
  5. Moscardo
    Moscardo, Madrid, Comunidad de Madrid, España (Suburb)
  6. Comillas
    Comillas, Madrid, Comunidad de Madrid, España (Suburb)
  7. Zofio
    Zofio, Madrid, Comunidad de Madrid, España (Suburb)
  8. Usera
    Usera, Madrid, Comunidad de Madrid, España (Suburb)
  9. Opanel
    Opanel, Madrid, Comunidad de Madrid, España (Suburb)
  10. Abrantes
    Abrantes, Madrid, Comunidad de Madrid, España (Suburb)

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

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

        
0.029 seconds ⌛

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