14 places near Santa Rosa de Cabal, Risaralda, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Villamaria
    Villamaria, Caldas, Colombia (County)
  3. Pereira
    Pereira, Risaralda, Colombia (County)
  4. Santa Rosa de Cabal
    Santa Rosa de Cabal, Risaralda, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Risaralda
    Risaralda, Risaralda, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. South America
    South America (Continent)
  10. Central America
    Central America (Supername)

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": [
                  -75.53933,
                  4.81978
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}