23 places near Valdemarin, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Aravaca
    Aravaca, Madrid, Comunidad de Madrid, España (Suburb)
  2. Valdemarin
    Valdemarin, Madrid, Comunidad de Madrid, España (Suburb)
  3. Casa Comontes
    Casa Comontes, Madrid, Comunidad de Madrid, España (Suburb)
  4. Casa Monrea
    Casa Monrea, Madrid, Comunidad de Madrid, España (Suburb)
  5. Ciudad Universitaria
    Ciudad Universitaria, Madrid, Comunidad de Madrid, España (Suburb)
  6. Madrid
    Madrid, 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.135 seconds ⌛; show me the details?

        
0.135 seconds ⌛

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