18 places near El Guavio, Santafe de Bogota D.c., Distrito Especial, Colombia
filter by placetype:
  1. El Guavio
    El Guavio, Santafe de Bogota D.c., Distrito Especial, Colombia (Suburb)
  2. Bogotá
    Bogotá, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  3. La Candelaria
    La Candelaria, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  4. Antonio Nariño
    Antonio Nariño, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  5. Los Mártires
    Los Mártires, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  6. Magdalena River
    Magdalena River, Colombia (Drainage)
  7. Santafe de Bogota D.c.
    Santafe de Bogota D.c., Distrito Especial, Colombia (County)
  8. America/Bogota
    America/Bogota (Timezone)
  9. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  10. Distrito Especial
    Distrito Especial, Distrito Especial, Colombia (State)

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

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

        
0.075 seconds ⌛

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