19 places near El Madroño, Sevilla, Andalucía, España
filter by placetype:
  1. Berrocal
    Berrocal, Huelva, Andalucía, España (Town)
  2. El Madroño
    El Madroño, Sevilla, Andalucía, España (Town)
  3. Los Casares
    Los Casares, Sevilla, Andalucía, España (Town)
  4. Rio Guardiana
    Rio Guardiana, España (Drainage)
  5. Nerva
    Nerva, Huelva, Andalucía, España (LocalAdmin)
  6. El Madroño
    El Madroño, Sevilla, Andalucía, España (LocalAdmin)
  7. Huelva
    Huelva, Andalucía, España (County)
  8. Sevilla
    Sevilla, Andalucía, España (County)
  9. Europe/Lisbon
    Europe/Lisbon, Portugal (Timezone)
  10. Europe/Madrid
    Europe/Madrid, España (Timezone)

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

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

        
0.019 seconds ⌛

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