24 places near Colmenar del Arroyo, Madrid, Comunidad de Madrid, España
filter by placetype:
  1. Chapinería
    Chapinería, Madrid, Comunidad de Madrid, España (Town)
  2. Colmenar del Arroyo
    Colmenar del Arroyo, Madrid, Comunidad de Madrid, España (Town)
  3. Navas del Rey
    Navas del Rey, Madrid, Comunidad de Madrid, España (Town)
  4. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  5. Chapinería
    Chapinería, Madrid, Comunidad de Madrid, España (LocalAdmin)
  6. Colmenar del Arroyo
    Colmenar del Arroyo, Madrid, Comunidad de Madrid, España (LocalAdmin)
  7. Navas del Rey
    Navas del Rey, Madrid, Comunidad de Madrid, España (LocalAdmin)
  8. Robledo de Chavela
    Robledo de Chavela, Madrid, Comunidad de Madrid, España (LocalAdmin)
  9. San Martín de Valdeiglesias
    San Martín de Valdeiglesias, 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.03 seconds ⌛; show me the details?

        
0.03 seconds ⌛

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