19 places near Río Frío, Majagual, Sucre, Colombia
filter by placetype:
  1. Río Frío
    Río Frío, Majagual, Sucre, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Achi
    Achi, Bolivar, Colombia (County)
  4. Guaranda
    Guaranda, Sucre, Colombia (County)
  5. Majagual
    Majagual, Sucre, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Antioquia
    Antioquia, Antioquia, Colombia (State)
  8. Bolivar
    Bolivar, Bolivar, Colombia (State)
  9. Sucre
    Sucre, Sucre, Colombia (State)
  10. Colombia
    Colombia, Colombia (Country)

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

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

        
0.023 seconds ⌛

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