18 places near Clemencia, Bolivar, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Cartagena
    Cartagena, Bolivar, Colombia (County)
  3. Clemencia
    Clemencia, Bolivar, Colombia (County)
  4. Santa Catalina
    Santa Catalina, Bolivar, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Caribbean Sea
    Caribbean Sea (Sea)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. North America
    North America (Continent)

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

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

        
0.017 seconds ⌛

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