14 places near Marquetalia, Caldas, Colombia
filter by placetype:
  1. Marquetalia
    Marquetalia, Marquetalia, Caldas, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Marquetalia
    Marquetalia, Caldas, Colombia (County)
  4. Pensilvania
    Pensilvania, Caldas, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Caldas
    Caldas, Caldas, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Atlantic Ocean
    Atlantic Ocean (Ocean)
  9. South America
    South America (Continent)
  10. Central America
    Central America (Supername)

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

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

        
0.026 seconds ⌛

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