17 places near San Fernando, Santafe de Bogota D.c., Distrito Especial, Colombia
filter by placetype:
  1. San Fernando
    San Fernando, Santafe de Bogota D.c., Distrito Especial, Colombia (Suburb)
  2. Bogotá
    Bogotá, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  3. Barrios Unidos
    Barrios Unidos, Santafe de Bogota D.c., Distrito Especial, Colombia (Town)
  4. Magdalena River
    Magdalena River, Colombia (Drainage)
  5. Santafe de Bogota D.c.
    Santafe de Bogota D.c., Distrito Especial, Colombia (County)
  6. America/Bogota
    America/Bogota (Timezone)
  7. Boyaca
    Boyaca, Boyaca, Colombia (State)
  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.027 seconds ⌛; show me the details?

        
0.027 seconds ⌛

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