17 places near Ovejas, Sucre, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. El Carmen de Bolivar
    El Carmen de Bolivar, Bolivar, Colombia (County)
  3. Ovejas
    Ovejas, Sucre, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. Bolivar
    Bolivar, Bolivar, Colombia (State)
  6. Sucre
    Sucre, Sucre, 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.041 seconds ⌛; show me the details?

        
0.041 seconds ⌛

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