25 places near 上海市, 上海市, 上海直辖市, 中國
filter by placetype:
  1. North Railway Station
    North Railway Station, 上海市, 上海直辖市, 中國 (POI)
  2. Hongkou
    Hongkou, 上海市, 上海直辖市, 中國 (Suburb)
  3. Zhabei
    Zhabei, 上海市, 上海直辖市, 中國 (Suburb)
  4. Ni Cheng Qiao
    Ni Cheng Qiao, 上海市, 上海直辖市, 中國 (Suburb)
  5. Huangpu
    Huangpu, 上海市, 上海直辖市, 中國 (Suburb)
  6. 上海市
    上海市, 上海市, 上海直辖市, 中國 (Town)
  7. Huangpu River
    Huangpu River, 上海市, 上海直辖市, 中國 (Drainage)
  8. 川沙县
    川沙县, 上海市, 上海直辖市, 中國 (LocalAdmin)
  9. 闵行区
    闵行区, 上海市, 上海直辖市, 中國 (LocalAdmin)
  10. 虹口區
    虹口區, 上海市, 上海直辖市, 中國 (LocalAdmin)

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

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

        
0.012 seconds ⌛

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