13 places near Mercaderes, Cauca, Colombia
filter by placetype:
  1. Amazonia
    Amazonia (Colloquial)
  2. Mercaderes
    Mercaderes, Cauca, Colombia (County)
  3. America/Bogota
    America/Bogota (Timezone)
  4. Cauca
    Cauca, Cauca, Colombia (State)
  5. Narino
    Narino, Narino, 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.049 seconds ⌛; show me the details?

        
0.049 seconds ⌛

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