17 places near San Bernardo, San Bernardo, Cundinamarca, Colombia
filter by placetype:
  1. San Bernardo
    San Bernardo, San Bernardo, Cundinamarca, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Santafe de Bogota D.c.
    Santafe de Bogota D.c., Distrito Especial, Colombia (County)
  4. Arbelaez
    Arbelaez, Cundinamarca, Colombia (County)
  5. Pandi
    Pandi, Cundinamarca, Colombia (County)
  6. San Bernardo
    San Bernardo, Cundinamarca, Colombia (County)
  7. America/Bogota
    America/Bogota (Timezone)
  8. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  9. Distrito Especial
    Distrito Especial, Distrito Especial, 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.028 seconds ⌛; show me the details?

        
0.028 seconds ⌛

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