16 places near Khammam, Andhra Pradesh, India
filter by placetype:
  1. Krishna Sagar
    Krishna Sagar, Khammam, Andhra Pradesh, India (Town)
  2. Krishna River
    Krishna River, India (Drainage)
  3. Godavari River
    Godavari River, India (Drainage)
  4. Khammam
    Khammam, Andhra Pradesh, India (County)
  5. Asia/Kolkata
    Asia/Kolkata (Timezone)
  6. Andhra Pradesh
    Andhra Pradesh, Andhra Pradesh, India (State)
  7. India
    India, India (Country)
  8. Bay of Bengal
    Bay of Bengal (Sea)
  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.01 seconds ⌛; show me the details?

        
0.01 seconds ⌛

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