13 places near El Cerrito, Valle del Cauca, Colombia
filter by placetype:
  1. El Cerrito
    El Cerrito, Valle del Cauca, Colombia (County)
  2. Ginebra
    Ginebra, Valle del Cauca, Colombia (County)
  3. Palmira
    Palmira, Valle del Cauca, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. Valle del Cauca
    Valle del Cauca, Valle del Cauca, Colombia (State)
  6. Colombia
    Colombia, Colombia (Country)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  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.033 seconds ⌛; show me the details?

        
0.033 seconds ⌛

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