17 places near Santa Rosa, Santa Rosa del Sur, Bolivar, Colombia
filter by placetype:
  1. Santa Rosa
    Santa Rosa, Santa Rosa del Sur, Bolivar, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Santa Rosa del Sur
    Santa Rosa del Sur, Bolivar, Colombia (County)
  4. Simiti
    Simiti, Bolivar, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Antioquia
    Antioquia, Antioquia, Colombia (State)
  7. Bolivar
    Bolivar, Bolivar, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Caribbean Sea
    Caribbean Sea (Sea)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.036 seconds ⌛

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