15 places near Cartagena, Cartagena del Chaira, Caqueta, Colombia
filter by placetype:
  1. Cartagena
    Cartagena, Cartagena del Chaira, Caqueta, Colombia (Town)
  2. Japura River
    Japura River, Brasil (Drainage)
  3. Amazonia
    Amazonia (Colloquial)
  4. Cartagena del Chaira
    Cartagena del Chaira, Caqueta, Colombia (County)
  5. San Vicente del Caguan
    San Vicente del Caguan, Caqueta, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Caqueta
    Caqueta, Caqueta, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. South America
    South America (Continent)

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

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

        
0.03 seconds ⌛

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