16 places near Casas de Valdelamadera, Ciudad Real, Castilla-La Mancha, España
filter by placetype:
  1. Casas de Valdelamadera
    Casas de Valdelamadera, Ciudad Real, Castilla-La Mancha, España (Town)
  2. Tajo River
    Tajo River, Cáceres, Extremadura, España (Drainage)
  3. Rio Guardiana
    Rio Guardiana, España (Drainage)
  4. Piedrabuena
    Piedrabuena, Ciudad Real, Castilla-La Mancha, España (LocalAdmin)
  5. Ciudad Real
    Ciudad Real, Castilla-La Mancha, España (County)
  6. Europe/Madrid
    Europe/Madrid, España (Timezone)
  7. Castilla-La Mancha
    Castilla-La Mancha, España (State)
  8. España
    España, España (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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

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

        
0.049 seconds ⌛

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