24 places near Sikhrani, Ghaziabad, Uttar Pradesh, India
filter by placetype:
  1. Sabzi Mandi
    Sabzi Mandi, Central Delhi, Delhi, India (Suburb)
  2. New Delhi
    New Delhi, Delhi, India (Town)
  3. Dharoti Khurd
    Dharoti Khurd, Ghaziabad, Uttar Pradesh, India (Town)
  4. Jafarabad Ganauli
    Jafarabad Ganauli, Ghaziabad, Uttar Pradesh, India (Town)
  5. Sikhrani
    Sikhrani, Ghaziabad, Uttar Pradesh, India (Town)
  6. Shakar Pulla
    Shakar Pulla, Ghaziabad, Uttar Pradesh, India (Town)
  7. Sharfuddinpur Javli
    Sharfuddinpur Javli, Ghaziabad, Uttar Pradesh, India (Town)
  8. Indus River
    Indus River, Punjab, Pakistan (Drainage)
  9. Yamuna River
    Yamuna River, India (Drainage)
  10. Ghaziabad
    Ghaziabad, Uttar Pradesh, India (County)

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

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

        
0.044 seconds ⌛

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