20 places near Sikheda, Ghaziabad, Uttar Pradesh, India
filter by placetype:
  1. Pilkhua Dehat
    Pilkhua Dehat, Ghaziabad, Uttar Pradesh, India (Town)
  2. Khera
    Khera, Ghaziabad, Uttar Pradesh, India (Town)
  3. Sikheda
    Sikheda, Ghaziabad, Uttar Pradesh, India (Town)
  4. Haval
    Haval, Ghaziabad, Uttar Pradesh, India (Town)
  5. Indus River
    Indus River, Punjab, Pakistan (Drainage)
  6. Yamuna River
    Yamuna River, India (Drainage)
  7. Bulandshahr
    Bulandshahr, Uttar Pradesh, India (County)
  8. Ghaziabad
    Ghaziabad, Uttar Pradesh, India (County)
  9. Asia/Kolkata
    Asia/Kolkata (Timezone)
  10. Asia/Karachi
    Asia/Karachi (Timezone)

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

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

        
0.009 seconds ⌛

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