18 places near Malambo, Atlantico, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Malambo
    Malambo, Atlantico, Colombia (County)
  3. Sitio Nuevo
    Sitio Nuevo, Magdalena, Colombia (County)
  4. America/Bogota
    America/Bogota (Timezone)
  5. Atlantico
    Atlantico, Atlantico, Colombia (State)
  6. Bolivar
    Bolivar, Bolivar, Colombia (State)
  7. Colombia
    Colombia, Colombia (Country)
  8. Caribbean Sea
    Caribbean Sea (Sea)
  9. Atlantic Ocean
    Atlantic Ocean (Ocean)
  10. North America
    North America (Continent)

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

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

        
0.014 seconds ⌛

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