16 places near Puerto Berrio Airport, Puerto Berrio, Antioquia, Colombia
filter by placetype:
  1. Puerto Berrio Airport
    Puerto Berrio Airport, Puerto Berrio, Antioquia, Colombia (Airport)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Puerto Berrio
    Puerto Berrio, Antioquia, Colombia (County)
  4. Cimitarra
    Cimitarra, Santander, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Antioquia
    Antioquia, Antioquia, Colombia (State)
  7. Boyaca
    Boyaca, Boyaca, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. North America
    North America (Continent)

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

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

        
0.022 seconds ⌛

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