19 places near Huangpu River, 上海市, 上海直辖市, 中國
filter by placetype:
  1. 龙华镇
    龙华镇, 上海市, 上海直辖市, 中國 (Suburb)
  2. 上海市
    上海市, 上海市, 上海直辖市, 中國 (Town)
  3. Huangpu River
    Huangpu River, 上海市, 上海直辖市, 中國 (Drainage)
  4. 川沙县
    川沙县, 上海市, 上海直辖市, 中國 (LocalAdmin)
  5. 松江区
    松江区, 上海市, 上海直辖市, 中國 (LocalAdmin)
  6. 闵行区
    闵行区, 上海市, 上海直辖市, 中國 (LocalAdmin)
  7. 徐匯區
    徐匯區, 上海市, 上海直辖市, 中國 (LocalAdmin)
  8. 浦西
    浦西, 上海市, 上海直辖市, 中國 (Colloquial)
  9. 上海市
    上海市, 上海直辖市, 中國 (County)
  10. Asia/Shanghai
    Asia/Shanghai, 中國 (Timezone)

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

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

        
0.028 seconds ⌛

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