19 places near Rocha, Arjona, Bolivar, Colombia
filter by placetype:
  1. Rocha
    Rocha, Arjona, Bolivar, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Cartagena
    Cartagena, Bolivar, Colombia (County)
  4. Arjona
    Arjona, Bolivar, Colombia (County)
  5. San Onofre
    San Onofre, Sucre, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Bolivar
    Bolivar, Bolivar, Colombia (State)
  8. Sucre
    Sucre, Sucre, Colombia (State)
  9. Colombia
    Colombia, Colombia (Country)
  10. Caribbean Sea
    Caribbean Sea (Sea)

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

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

        
0.043 seconds ⌛

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