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

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

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

        
0.022 seconds ⌛

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