17 places near Tubara, Atlantico, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Juan de Acosta
    Juan de Acosta, Atlantico, Colombia (County)
  3. Tubara
    Tubara, Atlantico, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. Atlantico
    Atlantico, Atlantico, Colombia (State)
  6. Colombia
    Colombia, Colombia (Country)
  7. Caribbean Sea
    Caribbean Sea (Sea)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. North America
    North America (Continent)
  10. South America
    South America (Continent)

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

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

        
0.032 seconds ⌛

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