17 places near Krishnarajasagara, Mandya, Karnataka, India
filter by placetype:
  1. Hebbalu
    Hebbalu, Mysore, Karnataka, India (Town)
  2. Krishnarajasagara
    Krishnarajasagara, Mandya, Karnataka, India (Town)
  3. Hulikere
    Hulikere, Mandya, Karnataka, India (Town)
  4. Mandya
    Mandya, Karnataka, India (County)
  5. Mysore
    Mysore, Karnataka, India (County)
  6. Asia/Kolkata
    Asia/Kolkata (Timezone)
  7. Karnataka
    Karnataka, Karnataka, India (State)
  8. Puducherry
    Puducherry, India (State)
  9. India
    India, India (Country)
  10. Indian Ocean
    Indian Ocean (Ocean)

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

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

        
0.157 seconds ⌛

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