16 places near Cachipay, 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. Anolaima
    Anolaima, Cundinamarca, Colombia (County)
  4. Cachipay
    Cachipay, Cundinamarca, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Boyaca
    Boyaca, Boyaca, Colombia (State)
  7. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  8. Distrito Especial
    Distrito Especial, Distrito Especial, Colombia (State)
  9. Colombia
    Colombia, Colombia (Country)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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.455833,
                  4.72699
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}