23 places near Cao Jia Du, 上海市, 上海直辖市, 中國
  1. Changning
    Changning, 上海市, 上海直辖市, 中國 (Suburb)
  2. Jing'an
    Jing'an, 上海市, 上海直辖市, 中國 (Suburb)
  3. Cao Jia Du
    Cao Jia Du, 上海市, 上海直辖市, 中國 (Suburb)
  4. Jing An Si
    Jing An Si, 上海市, 上海直辖市, 中國 (Suburb)
  5. 上海市
    上海市, 上海市, 上海直辖市, 中國 (Town)
  6. Huangpu River
    Huangpu River, 上海市, 上海直辖市, 中國 (Drainage)
  7. 闵行区
    闵行区, 上海市, 上海直辖市, 中國 (LocalAdmin)
  8. 普陀區
    普陀區, 上海市, 上海直辖市, 中國 (LocalAdmin)
  9. 徐匯區
    徐匯區, 上海市, 上海直辖市, 中國 (LocalAdmin)
  10. 昌宁
    昌宁, 上海市, 上海直辖市, 中國 (LocalAdmin)

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

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

        
0.02 seconds ⌛

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