17 places near Badillo, Puerto Wilches, Santander, Colombia
filter by placetype:
  1. Badillo
    Badillo, Puerto Wilches, Santander, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Simiti
    Simiti, Bolivar, Colombia (County)
  4. Puerto Wilches
    Puerto Wilches, Santander, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Santander
    Santander, Santander, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Caribbean Sea
    Caribbean Sea (Sea)
  10. Atlantic Ocean
    Atlantic Ocean (Ocean)

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

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

        
0.033 seconds ⌛

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