19 places near Nyaung U Airport, Mandalay, Myanmar
filter by placetype:
  1. Nyaung U Airport
    Nyaung U Airport, Mandalay, Myanmar (Airport)
  2. Mekong River
    Mekong River, Cambodia (Drainage)
  3. Irrawaddy River
    Irrawaddy River, Sagaing, Myanmar (Drainage)
  4. Salween River
    Salween River, Myanmar (Drainage)
  5. Asia/Kolkata
    Asia/Kolkata (Timezone)
  6. Asia/Rangoon
    Asia/Rangoon (Timezone)
  7. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  8. Mandalay
    Mandalay, Mandalay, Myanmar (State)
  9. Myanmar
    Myanmar, Myanmar (Country)
  10. Bay of Bengal
    Bay of Bengal (Sea)

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

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

        
0.043 seconds ⌛

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