19 places near Guaranda, Sucre, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Achi
    Achi, Bolivar, Colombia (County)
  3. Monte Cristo
    Monte Cristo, Bolivar, Colombia (County)
  4. Guaranda
    Guaranda, Sucre, Colombia (County)
  5. Majagual
    Majagual, Sucre, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Antioquia
    Antioquia, Antioquia, Colombia (State)
  8. Bolivar
    Bolivar, Bolivar, Colombia (State)
  9. Sucre
    Sucre, Sucre, Colombia (State)
  10. Colombia
    Colombia, Colombia (Country)

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

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

        
0.037 seconds ⌛

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