16 places near El Café, Cartagena del Chaira, Caqueta, Colombia
filter by placetype:
  1. El Café
    El Café, 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. Solano
    Solano, Caqueta, Colombia (County)
  7. Puerto Leguizamo
    Puerto Leguizamo, Putumayo, Colombia (County)
  8. America/Bogota
    America/Bogota (Timezone)
  9. Caqueta
    Caqueta, Caqueta, Colombia (State)
  10. Colombia
    Colombia, Colombia (Country)

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

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

        
0.041 seconds ⌛

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