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.024 seconds ⌛; show me the details?

        
0.024 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"
      }
    }
  ],
  "from": 0
}