14 places near Apulo, Cundinamarca, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Anapoima
    Anapoima, Cundinamarca, Colombia (County)
  3. Apulo
    Apulo, Cundinamarca, Colombia (County)
  4. Tocaima
    Tocaima, Cundinamarca, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. South America
    South America (Continent)
  10. Central America
    Central America (Supername)

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

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

        
0.029 seconds ⌛

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