19 places near Apure, Tenerife, Magdalena, Colombia
filter by placetype:
  1. Apure
    Apure, Tenerife, Magdalena, Colombia (Town)
  2. Magdalena River
    Magdalena River, Colombia (Drainage)
  3. Plato
    Plato, Magdalena, Colombia (County)
  4. Tenerife
    Tenerife, Magdalena, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Magdalena
    Magdalena, Magdalena, Colombia (State)
  8. Sucre
    Sucre, Sucre, Colombia (State)
  9. Colombia
    Colombia, Colombia (Country)
  10. Caribbean Sea
    Caribbean Sea (Sea)

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

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

        
0.023 seconds ⌛

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