17 places near Mandalay, Mandalay, Myanmar
filter by placetype:
  1. Mekong River
    Mekong River, Cambodia (Drainage)
  2. Irrawaddy River
    Irrawaddy River, Sagaing, Myanmar (Drainage)
  3. Salween River
    Salween River, Myanmar (Drainage)
  4. Asia/Kolkata
    Asia/Kolkata (Timezone)
  5. Asia/Rangoon
    Asia/Rangoon (Timezone)
  6. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  7. Mandalay
    Mandalay, Mandalay, Myanmar (State)
  8. Myanmar
    Myanmar, Myanmar (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.016 seconds ⌛; show me the details?

        
0.016 seconds ⌛

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