23 places near 28023, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Aravaca
    Aravaca, Madrid, Comunidad de Madrid, España (Suburb)
  2. Casa Monrea
    Casa Monrea, Madrid, Comunidad de Madrid, España (Suburb)
  3. Colonia Alfar
    Colonia Alfar, Madrid, Comunidad de Madrid, España (Town)
  4. La Estación
    La Estación, Madrid, Comunidad de Madrid, España (Town)
  5. Madrid
    Madrid, Madrid, Comunidad de Madrid, España (Town)
  6. Pozuelo de Alarcón
    Pozuelo de Alarcón, Madrid, Comunidad de Madrid, España (Town)
  7. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  8. Madrid
    Madrid, Madrid, Comunidad de Madrid, España (LocalAdmin)
  9. Pozuelo de Alarcón
    Pozuelo de Alarcón, 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.02 seconds ⌛; show me the details?

        
0.02 seconds ⌛

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