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

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

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

        
0.059 seconds ⌛

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