16 places near 4766, 商丘市, 河南省, 中國
filter by placetype:
  1. Yangtze River
    Yangtze River, 中國 (Drainage)
  2. Huang River
    Huang River, 忻州市, 山西省, 中國 (Drainage)
  3. 夏邑县
    夏邑县, 商丘市, 河南省, 中國 (LocalAdmin)
  4. 永城市
    永城市, 商丘市, 河南省, 中國 (LocalAdmin)
  5. 商丘市
    商丘市, 河南省, 中國 (County)
  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.025 seconds ⌛; show me the details?

        
0.025 seconds ⌛

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