12 places near Rovira, Tolima, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Rovira
    Rovira, Tolima, Colombia (County)
  3. America/Bogota
    America/Bogota (Timezone)
  4. Tolima
    Tolima, Tolima, Colombia (State)
  5. Colombia
    Colombia, Colombia (Country)
  6. Atlantic Ocean
    Atlantic Ocean (Ocean)
  7. South America
    South America (Continent)
  8. Central America
    Central America (Supername)
  9. Latin America
    Latin America (Supername)
  10. Americas
    Americas (Supername)

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

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

        
0.04 seconds ⌛

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