16 places near Derai, Sunamganj, Sylhet, Bangladesh
filter by placetype:
  1. Derai
    Derai, Sunamganj, Sylhet, Bangladesh (Town)
  2. Brahmaputra River
    Brahmaputra River, India (Drainage)
  3. Sunamganj
    Sunamganj, Sylhet, Bangladesh (County)
  4. Asia/Kolkata
    Asia/Kolkata (Timezone)
  5. Asia/Dhaka
    Asia/Dhaka (Timezone)
  6. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  7. Sylhet
    Sylhet, Sylhet, Bangladesh (State)
  8. Bangladesh
    Bangladesh, Bangladesh (Country)
  9. Indian Ocean
    Indian Ocean (Ocean)
  10. Pacific Ocean
    Pacific Ocean (Ocean)

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": [
                  91.349998,
                  24.7833
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}