18 places near Majagual, Sucre, Colombia
filter by placetype:
  1. Magdalena River
    Magdalena River, Colombia (Drainage)
  2. Achi
    Achi, Bolivar, Colombia (County)
  3. Majagual
    Majagual, Sucre, Colombia (County)
  4. Sucre
    Sucre, Sucre, Colombia (County)
  5. America/Bogota
    America/Bogota (Timezone)
  6. Antioquia
    Antioquia, Antioquia, Colombia (State)
  7. Bolivar
    Bolivar, Bolivar, 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.04 seconds ⌛; show me the details?

        
0.04 seconds ⌛

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