16 places near 4764, 商丘市, 河南省, 中國
filter by placetype:
  1. Yangtze River
    Yangtze River, 中國 (Drainage)
  2. Huang River
    Huang River, 忻州市, 山西省, 中國 (Drainage)
  3. 夏邑县
    夏邑县, 商丘市, 河南省, 中國 (LocalAdmin)
  4. 永城市
    永城市, 商丘市, 河南省, 中國 (LocalAdmin)
  5. 虞城县
    虞城县, 商丘市, 河南省, 中國 (LocalAdmin)
  6. 商丘市
    商丘市, 河南省, 中國 (County)
  7. 宿州市
    宿州市, 安徽省, 中國 (County)
  8. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)
  9. 河南省
    河南省, 河南省, 中國 (State)
  10. 安徽省
    安徽省, 中國 (State)

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": [
                  116.18235,
                  34.20924
                ]
              }
            }
          }
        }
      ],
      "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"
      }
    }
  ]
}