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

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

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

        
0.027 seconds ⌛

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