18 places near Botón de Leiva, Guamal, Magdalena, Colombia
filter by placetype:
  1. Botón de Leiva
    Botón de Leiva, Guamal, Magdalena, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. San Fernando
    San Fernando, Bolivar, Colombia (County)
  4. Guamal
    Guamal, Magdalena, Colombia (County)
  5. San Sebastian de Buenavista
    San Sebastian de Buenavista, Magdalena, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Bolivar
    Bolivar, Bolivar, Colombia (State)
  8. Magdalena
    Magdalena, Magdalena, Colombia (State)
  9. Colombia
    Colombia, Colombia (Country)
  10. Caribbean Sea
    Caribbean Sea (Sea)

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

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

        
0.047 seconds ⌛

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