15 places near Bugalagrande, Bugalagrande, Valle del Cauca, Colombia
filter by placetype:
  1. Bugalagrande
    Bugalagrande, Bugalagrande, Valle del Cauca, Colombia (Town)
  2. Andalucia
    Andalucia, Valle del Cauca, Colombia (County)
  3. Bolivar
    Bolivar, Valle del Cauca, Colombia (County)
  4. Bugalagrande
    Bugalagrande, Valle del Cauca, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Choco
    Choco, Choco, Colombia (State)
  7. Valle del Cauca
    Valle del Cauca, Valle del Cauca, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. South America
    South America (Continent)

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

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

        
0.044 seconds ⌛

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