17 places near Bojaca, Cundinamarca, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Santafe de Bogota D.c.
    Santafe de Bogota D.c., Distrito Especial, Colombia (County)
  3. Bojaca
    Bojaca, Cundinamarca, Colombia (County)
  4. Madrid
    Madrid, Cundinamarca, Colombia (County)
  5. Tena
    Tena, Cundinamarca, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Boyaca
    Boyaca, Boyaca, Colombia (State)
  8. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  9. Distrito Especial
    Distrito Especial, Distrito Especial, 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.024 seconds ⌛; show me the details?

        
0.024 seconds ⌛

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