14 places near 28020, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Chamartín
    Chamartín, Madrid, Comunidad de Madrid, España (Suburb)
  2. Chamartín de la Rosa
    Chamartín de la Rosa, Madrid, Comunidad de Madrid, España (Suburb)
  3. Tetuan
    Tetuan, Madrid, Comunidad de Madrid, España (Suburb)
  4. Valdeacederas
    Valdeacederas, Madrid, Comunidad de Madrid, España (Suburb)
  5. Nueva Espana
    Nueva Espana, Madrid, Comunidad de Madrid, España (Suburb)
  6. Castillejos
    Castillejos, Madrid, Comunidad de Madrid, España (Suburb)
  7. Valdezarza
    Valdezarza, Madrid, Comunidad de Madrid, España (Suburb)
  8. Bellas Vistas
    Bellas Vistas, Madrid, Comunidad de Madrid, España (Suburb)
  9. Cuatro Caminos
    Cuatro Caminos, Madrid, Comunidad de Madrid, España (Suburb)
  10. Rios Rosas
    Rios Rosas, 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.053 seconds ⌛; show me the details?

        
0.053 seconds ⌛

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