13 places near La Celia, Risaralda, Colombia
filter by placetype:
  1. La Celia
    La Celia, Risaralda, Colombia (County)
  2. Santuario
    Santuario, Risaralda, Colombia (County)
  3. El Aguila
    El Aguila, Valle del Cauca, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. Risaralda
    Risaralda, Risaralda, Colombia (State)
  6. Colombia
    Colombia, Colombia (Country)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  8. South America
    South America (Continent)
  9. Central America
    Central America (Supername)
  10. Latin America
    Latin America (Supername)

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

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

        
0.026 seconds ⌛

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