14 places near Rosario Isla del, Cartagena, Bolivar, Colombia
filter by placetype:
  1. Rosario Isla del
    Rosario Isla del, Cartagena, Bolivar, Colombia (Island)
  2. Cartagena
    Cartagena, Bolivar, Colombia (County)
  3. America/Bogota
    America/Bogota (Timezone)
  4. Bolivar
    Bolivar, Bolivar, Colombia (State)
  5. Caribbean Sea
    Caribbean Sea (Sea)
  6. Atlantic Ocean
    Atlantic Ocean (Ocean)
  7. North America
    North America (Continent)
  8. South America
    South America (Continent)
  9. British West Indies
    British West Indies (Supername)
  10. Central America
    Central America (Supername)

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

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

        
0.021 seconds ⌛

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