16 places near San Andres y Providencia, San Andres y Providencia, Colombia
filter by placetype:
  1. Saint Andrews Island
    Saint Andrews Island, Colombia (Island)
  2. San Andrés
    San Andrés, San Andres y Providencia, Colombia (County)
  3. America/Bogota
    America/Bogota (Timezone)
  4. San Andres y Providencia
    San Andres y Providencia, San Andres y Providencia, Colombia (State)
  5. Colombia
    Colombia, Colombia (Country)
  6. Caribbean Sea
    Caribbean Sea (Sea)
  7. Atlantic Ocean
    Atlantic Ocean (Ocean)
  8. North America
    North America (Continent)
  9. South America
    South America (Continent)
  10. British West Indies
    British West Indies (Supername)

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

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

        
0.02 seconds ⌛

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