15 places near San Juan, Santafe de Bogota D.c., Distrito Especial, Colombia
filter by placetype:
  1. San Juan
    San Juan, Santafe de Bogota D.c., Distrito Especial, 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. San Bernardo
    San Bernardo, Cundinamarca, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Cundinamarca
    Cundinamarca, Cundinamarca, Colombia (State)
  7. Distrito Especial
    Distrito Especial, Distrito Especial, Colombia (State)
  8. Colombia
    Colombia, Colombia (Country)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. South America
    South America (Continent)

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

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

        
0.024 seconds ⌛

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