一、背景
接到一个数据需求,是从我们的Mongo中导出的,但要取的值得到很深的层级,尝试写了半天Mongo的查询查不出来,问了半天大模型给的也不对,于是考虑写代码的方式
二、数据格式
// 1
{
"_id": ObjectId("65d367751de88e5f7305338e"),
"districtName": "朝阳区",
"year": "2024",
"cityCode": "110000",
"bizcircleId": "161",
"bizcircleName": "CBD商圈",
"isShowOut": "102300000001",
"modules": [
{
"id": "0",
"code": "0",
"displayName": "封面",
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "a",
"code": "a",
"displayName": "商圈楼盘分布图",
"englishName": "Distribution Of Business District Real Estate",
"submodules": [
{
"list": [
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"belongType": "2",
"dealAmount": "0",
"avgDealprice": "8.39",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"belongType": "2",
"dealAmount": "0",
"avgDealprice": "9.55",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"belongType": "2",
"map_x": "116.459871",
"map_y": "39.918146",
"dealAmount": "0",
"avgDealprice": "9.09",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"belongType": "2",
"map_x": "116.460154",
"map_y": "39.920838",
"dealAmount": "0",
"avgDealprice": "9.38",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"belongType": "2",
"dealAmount": "0",
"avgDealprice": "9.6",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"belongType": "2",
"map_x": "116.461138",
"map_y": "39.903885",
"dealAmount": "2",
"avgDealprice": "10.06",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"belongType": "1,2",
"map_x": "116.471373",
"map_y": "39.912671",
"dealAmount": "1",
"avgDealprice": "11.77",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"belongType": "2",
"map_x": "116.468655",
"map_y": "39.911689",
"dealAmount": "0",
"avgDealprice": "5.59",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"belongType": "2",
"map_x": "116.458727",
"map_y": "39.923352",
"dealAmount": "0",
"avgDealprice": "5.51",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("11897"),
"resblockName": "金桐拾贰",
"belongType": "1",
"map_x": "116.460864",
"map_y": "39.920687",
"dealAmount": "0",
"avgDealprice": "0",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"belongType": "2",
"map_x": "116.471910",
"map_y": "39.924525",
"dealAmount": "1",
"avgDealprice": "10.51",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"belongType": "1,2",
"map_x": "116.471402",
"map_y": "39.923987",
"dealAmount": "0",
"avgDealprice": "21.3",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("6901"),
"resblockName": "尊悦光华",
"belongType": "1",
"map_x": "116.463016",
"map_y": "39.918581",
"dealAmount": "0",
"avgDealprice": "9.1",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"belongType": "2",
"map_x": "116.465854",
"map_y": "39.913217",
"dealAmount": "0",
"avgDealprice": "8.87",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"belongType": "2,1",
"map_x": "116.462153",
"map_y": "39.923909",
"dealAmount": "12",
"avgDealprice": "5.82",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"belongType": "2",
"map_x": "116.464913",
"map_y": "39.923461",
"dealAmount": "0",
"avgDealprice": "11.44",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"belongType": "2",
"map_x": "116.481327",
"map_y": "39.915586",
"dealAmount": "1",
"avgDealprice": "9.83",
"_class": "com.test.job.marketreport.document.ResblockRankItem2"
}
],
"id": "rl_a",
"type": "resblock_location",
"_class": "com.test.job.marketreport.document.ReportSubmoduleHouseList"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "b",
"code": "b",
"displayName": "整体价值介绍",
"englishName": "Overall Value Introduction",
"submodules": [
{
"submodules": [
{
"metrics": [
{
"displayName": "二手楼盘均价(万/㎡)",
"value": "10.02",
"subvalue": "29",
"upOrDown": 0,
"gain": "-2.24%"
},
{
"displayName": "一手楼盘均价(万/㎡)",
"value": "8.93",
"subvalue": "20",
"upOrDown": 0,
"gain": "0%"
}
],
"name": "成交均价",
"type": "metric",
"_class": "com.test.job.marketreport.document.ReportSubmoduleMetric"
},
{
"metrics": [
{
"displayName": "二手成交量(套)",
"value": "17",
"subvalue": "2"
},
{
"displayName": "一手成交量(套)",
"value": "0"
},
{
"displayName": "换手率",
"value": "3%",
"subvalue": "20"
}
],
"name": "成交量",
"type": "metric",
"_class": "com.test.job.marketreport.document.ReportSubmoduleMetric"
},
{
"metrics": [
{
"displayName": "单位租金(元/㎡/月)",
"value": "252",
"subvalue": "8",
"upOrDown": 1,
"gain": "2.02%"
},
{
"displayName": "租金回报率",
"value": "3.02%",
"subvalue": "8",
"upOrDown": 1,
"gain": "0%"
}
],
"name": "租金",
"type": "metric",
"_class": "com.test.job.marketreport.document.ReportSubmoduleMetric"
}
],
"type": "vbox",
"_class": "com.test.job.marketreport.document.ReportSubmoduleList"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "c",
"code": "c",
"displayName": "好不好卖",
"englishName": "Sell Well",
"submodules": [
{
"value": "商圈房屋存量",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "c_1",
"subtype": "pie",
"title": "一手、二手存量占比",
"displayMode": "percentage",
"data": [
{
"name": "二手·7318户",
"value": NumberInt("95")
},
{
"name": "一手·339户",
"value": NumberInt("4")
}
],
"id": "65d367751de88e5f7305338e_c_1",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "c_2",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
},
{
"value": "商圈成交量",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "c_3",
"subtype": "bar",
"title": "一手二手成交量趋势",
"unit": "套",
"unit2": "套",
"x": [
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月",
"1月"
],
"y": [
{
"name": "二手",
"type": "bar",
"unit": "套",
"data": [
"16",
"19",
"16",
"19",
"21",
"4",
"16",
"17",
"12",
"12",
"18",
"17"
]
},
{
"name": "一手",
"type": "bar",
"unit": "套",
"data": [
"0",
"5",
"0",
"8",
"6",
"1",
"2",
"3",
"8",
"2",
"0",
"0"
]
}
],
"id": "65d367751de88e5f7305338e_c_3",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"value": "1月一手无成交。二手成交量为17套;环比减少1套,同比减少1套。",
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "c_4",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
},
{
"value": "换手率",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "c_5",
"subtype": "line",
"title": "换手率趋势",
"unit": "%",
"x": [
"2019年",
"2020年",
"2021年",
"2022年",
"2023年"
],
"y": [
{
"type": "line",
"data": [
3,
2.41,
4,
2,
3
]
}
],
"id": "65d367751de88e5f7305338e_c_5",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"value": "2023年换手率为3%,同比上涨1个百分点。",
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "c_6",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "d",
"code": "d",
"displayName": "投资回报率",
"englishName": "Return On Investment",
"submodules": [
{
"value": "土地价值",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"submodules": [
{
"value": "土地价值",
"editable": false,
"type": "landTitle"
},
{
"value": "暂无成交",
"editable": false,
"type": "landValue"
},
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "d_1",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
},
{
"value": "成交价趋势",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "d_2",
"subtype": "line",
"title": "成交价趋势",
"unit": "万/㎡",
"x": [
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月",
"1月"
],
"y": [
{
"name": "一手",
"type": "line",
"data": [
"12.83",
"7.19",
"7.19",
"7.34",
"7.38",
"8.39",
"6.64",
"6.18",
"8.09",
"8.93",
"8.93",
"8.93"
]
},
{
"name": "二手",
"type": "line",
"data": [
"10.16",
"10.35",
"10.86",
"10.86",
"10.9",
"10.38",
"10.68",
"10.59",
"10.6",
"10.47",
"10.25",
"10.02"
]
}
],
"id": "65d367751de88e5f7305338e_d_2",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"value": "1月一手成交均价为8.93万/㎡,环比持平,同比下降30.4%。二手成交均价为10.02万/㎡,环比下降2.24%,同比下降3.19%。",
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "d_3",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
},
{
"value": "房价涨幅",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "d_4",
"subtype": "line",
"title": "房价涨幅趋势",
"unit": "%",
"x": [
"2019年",
"2020年",
"2021年",
"2022年",
"2023年"
],
"y": [
{
"type": "line",
"data": [
"-9.0600",
"-5.700",
"6.6100",
"-2.8300",
"-1.2200"
]
}
],
"id": "65d367751de88e5f7305338e_d_4",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"value": "2023年成交均价相比去年上涨1.61%。",
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "d_5",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
},
{
"value": "租金回报率",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"subid": "d_6",
"subtype": "line",
"title": "租金回报率趋势",
"unit": "%",
"x": [
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月",
"1月"
],
"y": [
{
"type": "line",
"data": [
"2.9400",
"3.00",
"2.8500",
"2.7500",
"2.7900",
"2.9500",
"2.8600",
"2.7300",
"2.7800",
"2.700",
"2.8500",
"3.0200"
]
}
],
"id": "65d367751de88e5f7305338e_d_6",
"type": "chart",
"_class": "com.test.job.marketreport.document.ReportSubmoduleChart"
},
{
"submodules": [
{
"editable": true,
"type": "title2"
},
{
"editable": true,
"type": "title3"
},
{
"value": "1月租金回报率为3.02%,环比增加0.17个百分点;同比增加0.11个百分点。",
"editable": true,
"type": "content"
},
{
"editable": true,
"type": "title3"
},
{
"editable": true,
"type": "content"
}
],
"submodulesReference": [ ],
"id": "d_7",
"type": "conclusion",
"_class": "com.test.job.marketreport.document.ReportSubmoduleConclusion"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "e",
"code": "e",
"displayName": "未来升值潜力",
"englishName": "Future Appreciation Potential",
"submodules": [ ],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "f",
"code": "f",
"displayName": "该买哪个盘",
"englishName": "Which Plate Should I Buy",
"submodules": [
{
"value": "豪盘榜",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"value": "套均总价排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"套均总价(万)"
],
"list": [
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "8500",
"belongType": "1"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "4800",
"belongType": "2"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "4650",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "2777",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "2734",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "2180",
"belongType": "2"
},
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"value": "2174",
"belongType": "2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"value": "2163",
"belongType": "2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"value": "2031",
"belongType": "2"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"value": "1976",
"belongType": "2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"value": "1897",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "1825",
"belongType": "1"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "1743",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "1663",
"belongType": "2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "1531",
"belongType": "1"
},
{
"resblockId": NumberInt("6901"),
"resblockName": "尊悦光华",
"value": "1473",
"belongType": "1"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"value": "1207",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "1180",
"belongType": "2"
},
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"value": "901",
"belongType": "2"
},
{
"resblockId": NumberInt("11897"),
"resblockName": "金桐拾贰",
"belongType": "1"
}
],
"rankTitle": "套均总价排名",
"id": "f_1",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "成交均价排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"成交均价(万/㎡)"
],
"list": [
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "21.3",
"belongType": "1"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "12.37",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "11.77",
"belongType": "1"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "11.65",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "11.44",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "10.51",
"belongType": "2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "10.06",
"belongType": "2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "9.94",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "9.83",
"belongType": "2"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"value": "9.6",
"belongType": "2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"value": "9.55",
"belongType": "2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"value": "9.38",
"belongType": "2"
},
{
"resblockId": NumberInt("6901"),
"resblockName": "尊悦光华",
"value": "9.1",
"belongType": "1"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"value": "9.09",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "8.87",
"belongType": "2"
},
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"value": "8.39",
"belongType": "2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "5.82",
"belongType": "1"
},
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"value": "5.59",
"belongType": "2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"value": "5.51",
"belongType": "2"
},
{
"resblockId": NumberInt("11897"),
"resblockName": "金桐拾贰",
"belongType": "1"
}
],
"rankTitle": "成交均价排名",
"id": "f_2",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "单位租金排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"单位租金(元/㎡/月)"
],
"list": [
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "385.26",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "357.5",
"belongType": "2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "248.18",
"belongType": "2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "220.95",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "213.22",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "206.96",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "152.58",
"belongType": "2"
}
],
"rankTitle": "单位租金排名",
"id": "f_3",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "好卖盘",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"value": "商圈内新房成交量排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"成交量(套)"
],
"list": [
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "0",
"belongType": "1"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "0",
"belongType": "1"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "0",
"belongType": "1"
},
{
"resblockId": NumberInt("6901"),
"resblockName": "尊悦光华",
"value": "0",
"belongType": "1"
},
{
"resblockId": NumberInt("11897"),
"resblockName": "金桐拾贰",
"belongType": "1"
}
],
"rankTitle": "商圈内新房成交量排名",
"id": "f_4",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "商圈内二手楼盘成交量排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"成交量(套)"
],
"list": [
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "12",
"belongType": "2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "2",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "1",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "1",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "1",
"belongType": "2"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "0",
"belongType": "2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"value": "0",
"belongType": "2"
}
],
"rankTitle": "商圈内二手楼盘成交量排名",
"id": "f_5",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "商圈内二手楼盘换手率排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"换手率"
],
"list": [
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "4.29%",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "3.37%",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "3.05%",
"belongType": "2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"value": "2.88%",
"belongType": "2"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"value": "2.85%",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "2.78%",
"belongType": "2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "2.42%",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "2.31%",
"belongType": "2"
},
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"value": "1.45%",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "1.39%",
"belongType": "2"
},
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"value": "0.67%",
"belongType": "2"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"value": "0.12%",
"belongType": "2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"value": "0%",
"belongType": "2"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "0%",
"belongType": "2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"value": "0%",
"belongType": "2"
}
],
"rankTitle": "商圈内二手楼盘换手率排名",
"id": "f_6",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
},
{
"value": "高投资回报率",
"type": "title1",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"value": "二手租金回报率排名",
"type": "dataTable",
"_class": "com.test.job.marketreport.document.ReportSubmoduleAdvice"
},
{
"names": [
"楼盘名称",
"租金回报率"
],
"list": [
{
"resblockId": NumberInt("597246"),
"resblockName": "万科大都会",
"value": "5.78%",
"belongType": "2"
},
{
"resblockId": NumberInt("6098"),
"resblockName": "银泰中心",
"value": "4.84%",
"belongType": "2"
},
{
"resblockId": NumberInt("8118"),
"resblockName": "首创天禧",
"value": "3.97%",
"belongType": "2"
},
{
"resblockId": NumberInt("597245"),
"resblockName": "中骏.世界城",
"value": "3.81%",
"belongType": "2"
},
{
"resblockId": NumberInt("597373"),
"resblockName": "富力十号",
"value": "2.96%",
"belongType": "2"
},
{
"resblockId": NumberInt("597253"),
"resblockName": "梵悦108",
"value": "2.86%",
"belongType": "2"
},
{
"resblockId": NumberInt("2378"),
"resblockName": "新城国际",
"value": "2.67%",
"belongType": "2"
},
{
"resblockId": NumberInt("597683"),
"resblockName": "世贸国际公寓",
"value": "2.65%",
"belongType": "2"
},
{
"resblockId": NumberInt("9935"),
"resblockName": "禧瑞都",
"value": "2.36%",
"belongType": "2"
},
{
"resblockId": NumberInt("597505"),
"resblockName": "蓝堡国际公寓",
"value": "2.33%",
"belongType": "2"
},
{
"resblockId": NumberInt("1394"),
"resblockName": "御金台",
"value": "2.24%",
"belongType": "2"
},
{
"resblockId": NumberInt("600067"),
"resblockName": "乐成公馆",
"value": "2.18%",
"belongType": "2"
},
{
"resblockId": NumberInt("600040"),
"resblockName": "温莎大道",
"value": "2%",
"belongType": "2"
},
{
"resblockId": NumberInt("47"),
"resblockName": "金地国际花园",
"value": "1.86%",
"belongType": "2"
},
{
"resblockId": NumberInt("600103"),
"resblockName": "通用时代国际公寓",
"value": "1.27%",
"belongType": "2"
}
],
"rankTitle": "二手租金回报率排名",
"id": "f_8",
"type": "rank",
"_class": "com.test.job.marketreport.document.ReportSubmoduleRank2"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "g",
"code": "g",
"displayName": "商圈排行榜Top10",
"englishName": "Business District Ranking",
"submodules": [
{
"tabs": [
{
"title": "二手楼盘均价",
"submodules": [
{
"_id": "g_1",
"names": [
"商圈名称",
"成交均价(万/㎡)"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "19.38"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "18.12"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "16.99"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "16.72"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭",
"value": "16.35"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城",
"value": "15.37"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭",
"value": "14.68"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "14.03"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "13.82"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门",
"value": "13.82"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "13.28"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "12.64"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "12.64"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "11.95"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "11.88"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "11.79"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "11.79"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "11.76"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "11.7"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "11.39"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门",
"value": "11.37"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "11.33"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "11.27"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "10.98"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "10.93"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "10.75"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "10.75"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "10.69"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "10.02"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "9.11"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "9.1"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "9.07"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "9"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "8.87"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街",
"value": "8.78"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "8.29"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "8.23"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "8.22"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店",
"value": "8.13"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "7.97"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "7.54"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "7.08"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "7.06"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥",
"value": "7.01"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "6.95"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "6.47"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "6.39"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "6.1"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "5.48"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "5.44"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "3.98"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
}
],
"rankTitle": "二手楼盘均价"
}
]
},
{
"title": "一手楼盘均价",
"submodules": [
{
"_id": "g_2",
"names": [
"商圈名称",
"成交均价(万/㎡)"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "18.38"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "18"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "17.59"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门",
"value": "13.47"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门",
"value": "12.87"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "12.66"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "12.29"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "12.15"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "11.8"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "11.4"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺",
"value": "10.68"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "10.49"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "9.7"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "9.68"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "9.19"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "8.99"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "8.98"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄",
"value": "8.97"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "8.94"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "8.93"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "8.9"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "8.81"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区",
"value": "8.73"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "8.67"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "8.57"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "8.18"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "8.11"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "7.88"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "6.87"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "6.86"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "6.8"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "6.79"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "6.49"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "6.35"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "6.27"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "6.2"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "6"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "5.79"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "5.54"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "5.46"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "5.08"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟",
"value": "4.92"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "3.88"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "3.72"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区",
"value": "2.99"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
}
],
"rankTitle": "一手楼盘均价"
}
]
},
{
"title": "二手房价涨幅",
"submodules": [
{
"_id": "g_3",
"names": [
"商圈名称",
"价格涨幅"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "9.64%"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城",
"value": "9.55%"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "6.84%"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "6.53%"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "4.54%"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "4.44%"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "3.95%"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "3.2%"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "3.12%"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "2.22%"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "1.98%"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "1.75%"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭",
"value": "1.73%"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "0.93%"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "0.85%"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "0.08%"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "0"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "0"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "0"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "0"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门",
"value": "0"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "0"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店",
"value": "0"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥",
"value": "0"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "0"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街",
"value": "0"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "0"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "0"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "0"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门",
"value": "0"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "-0.33%"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "-0.44%"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "-0.81%"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "-0.85%"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "-0.88%"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "-1.16%"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭",
"value": "-1.57%"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "-1.75%"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "-2.24%"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "-2.31%"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "-2.32%"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "-2.75%"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "-4.36%"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "-4.37%"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "-4.94%"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "-6.9%"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "-7.41%"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "-17.79%"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "-17.92%"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门",
"value": ""
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园",
"value": ""
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸",
"value": ""
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺",
"value": ""
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区",
"value": ""
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单",
"value": ""
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海",
"value": ""
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟",
"value": ""
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山",
"value": ""
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云",
"value": ""
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔",
"value": ""
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆",
"value": ""
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷",
"value": ""
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海",
"value": ""
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口",
"value": ""
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺",
"value": ""
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四",
"value": ""
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门",
"value": ""
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼",
"value": ""
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥",
"value": ""
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷",
"value": ""
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四",
"value": ""
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子",
"value": ""
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区",
"value": ""
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫",
"value": ""
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫",
"value": ""
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区",
"value": ""
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门",
"value": ""
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体",
"value": ""
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外",
"value": ""
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄",
"value": ""
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井",
"value": ""
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店",
"value": ""
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门",
"value": ""
}
],
"rankTitle": "二手房价涨幅"
}
]
},
{
"title": "二手成交量",
"submodules": [
{
"_id": "g_4",
"names": [
"商圈名称",
"成交量(套)"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "23"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "17"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "14"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "13"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "11"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "10"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "10"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "10"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "10"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "9"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "9"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "9"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "8"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "7"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "6"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "5"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "5"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "4"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "4"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "4"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "4"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭",
"value": "3"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "3"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "3"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "3"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "3"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "3"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "2"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "2"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城",
"value": "2"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "1"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "1"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "1"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭",
"value": "1"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "1"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "0"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "0"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "0"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "0"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门",
"value": "0"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门",
"value": "0"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "0"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门",
"value": "0"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店",
"value": "0"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥",
"value": "0"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄",
"value": "0"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "0"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸",
"value": "0"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区",
"value": "0"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟",
"value": "0"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔",
"value": "0"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆",
"value": "0"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口",
"value": "0"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门",
"value": "0"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街",
"value": "0"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "0"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "0"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "0"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门",
"value": "0"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺",
"value": "0"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
}
],
"rankTitle": "二手成交量"
}
]
},
{
"title": "一手成交量",
"submodules": [
{
"_id": "g_5",
"names": [
"商圈名称",
"成交量(套)"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "49"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "41"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门",
"value": "40"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "34"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "18"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "13"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "10"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺",
"value": "8"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "8"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "4"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "4"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "3"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "3"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "2"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "2"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "1"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "1"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "1"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "1"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "1"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "1"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "1"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "0"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "0"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "0"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "0"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "0"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "0"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "0"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门",
"value": "0"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭",
"value": "0"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "0"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "0"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "0"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门",
"value": "0"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店",
"value": "0"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥",
"value": "0"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄",
"value": "0"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "0"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "0"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "0"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "0"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "0"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "0"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "0"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城",
"value": "0"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭",
"value": "0"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "0"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸",
"value": "0"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区",
"value": "0"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟",
"value": "0"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔",
"value": "0"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆",
"value": "0"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口",
"value": "0"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "0"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门",
"value": "0"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街",
"value": "0"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "0"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区",
"value": "0"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门",
"value": "0"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "0"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
}
],
"rankTitle": "一手成交量"
}
]
},
{
"title": "换手率",
"submodules": [
{
"_id": "g_6",
"names": [
"商圈名称",
"换手率"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥",
"value": "11%"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地",
"value": "9%"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山",
"value": "8%"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门",
"value": "7%"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山",
"value": "4%"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "4%"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街",
"value": "4%"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "4%"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "4%"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "4%"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "4%"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "4%"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "4%"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "3%"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "3%"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "3%"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "3%"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "3%"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "3%"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "3%"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "3%"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "3%"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门",
"value": "3%"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "3%"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "3%"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "3%"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "3%"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "2%"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "2%"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "2%"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "2%"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体",
"value": "2%"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "2%"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门",
"value": "2%"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "2%"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "2%"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "2%"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城",
"value": "2%"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "2%"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "2%"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "2%"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区",
"value": "2%"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园",
"value": "1%"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门",
"value": "1%"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭",
"value": "1%"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "1%"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城",
"value": "1%"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭",
"value": "1%"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "1%"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海",
"value": "--"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺",
"value": "--"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门",
"value": "--"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外",
"value": "--"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井",
"value": "--"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店",
"value": "--"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门",
"value": "--"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店",
"value": "--"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄",
"value": "--"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体",
"value": "--"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园",
"value": "--"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区",
"value": "--"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸",
"value": "--"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区",
"value": "--"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟",
"value": "--"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山",
"value": "--"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云",
"value": "--"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔",
"value": "--"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆",
"value": "--"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷",
"value": "--"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海",
"value": "--"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口",
"value": "--"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺",
"value": "--"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四",
"value": "--"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门",
"value": "--"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼",
"value": "--"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥",
"value": "--"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷",
"value": "--"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四",
"value": "--"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子",
"value": "--"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区",
"value": "--"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫",
"value": "--"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫",
"value": "--"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区",
"value": "--"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门",
"value": "--"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单",
"value": "--"
}
],
"rankTitle": "换手率"
}
]
},
{
"title": "单位租金",
"submodules": [
{
"_id": "g_7",
"names": [
"商圈名称",
"单位租金(元/㎡/月)"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "357"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "339"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "329"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "322"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "292"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "277"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "271"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "252"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "244"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "243"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "230"
},
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "228"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "226"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "226"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "214"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "206"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "204"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "202"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "199"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "191"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "190"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "189"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "187"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "179"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "177"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "172"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "159"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "154"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "145"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "134"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "123"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "121"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "110"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺"
}
],
"rankTitle": "单位租金"
}
]
},
{
"title": "租金回报率",
"submodules": [
{
"_id": "g_8",
"names": [
"商圈名称",
"租金回报率"
],
"type": "rank",
"list": [
{
"bizcircleId": NumberInt("215"),
"bizcircleName": "昌平别墅区",
"value": "3.93%"
},
{
"bizcircleId": NumberInt("206"),
"bizcircleName": "西钓鱼台",
"value": "3.57%"
},
{
"bizcircleId": NumberInt("191"),
"bizcircleName": "东坝",
"value": "3.54%"
},
{
"bizcircleId": NumberInt("943"),
"bizcircleName": "孙河中央别墅区",
"value": "3.46%"
},
{
"bizcircleId": NumberInt("945"),
"bizcircleName": "天竺中央别墅区",
"value": "3.3%"
},
{
"bizcircleId": NumberInt("179"),
"bizcircleName": "西大望路",
"value": "3.17%"
},
{
"bizcircleId": NumberInt("942"),
"bizcircleName": "大湖中央别墅区",
"value": "3.04%"
},
{
"bizcircleId": NumberInt("161"),
"bizcircleName": "CBD",
"value": "3.02%"
},
{
"bizcircleId": NumberInt("195"),
"bizcircleName": "通州别墅区",
"value": "2.99%"
},
{
"bizcircleId": NumberInt("177"),
"bizcircleName": "燕莎",
"value": "2.89%"
},
{
"bizcircleId": NumberInt("165"),
"bizcircleName": "丽都",
"value": "2.75%"
},
{
"bizcircleId": NumberInt("170"),
"bizcircleName": "王府井",
"value": "2.74%"
},
{
"bizcircleId": NumberInt("189"),
"bizcircleName": "亚运村小营",
"value": "2.66%"
},
{
"bizcircleId": NumberInt("944"),
"bizcircleName": "后沙峪中央别墅区",
"value": "2.48%"
},
{
"bizcircleId": NumberInt("198"),
"bizcircleName": "大兴城南别墅区",
"value": "2.42%"
},
{
"bizcircleId": NumberInt("721"),
"bizcircleName": "宣武门",
"value": "2.35%"
},
{
"bizcircleId": NumberInt("163"),
"bizcircleName": "东直门",
"value": "2.31%"
},
{
"bizcircleId": NumberInt("201"),
"bizcircleName": "大红门",
"value": "2.29%"
},
{
"bizcircleId": NumberInt("162"),
"bizcircleName": "朝阳公园",
"value": "2.21%"
},
{
"bizcircleId": NumberInt("208"),
"bizcircleName": "西山别墅区",
"value": "2.18%"
},
{
"bizcircleId": NumberInt("199"),
"bizcircleName": "丽泽商务区",
"value": "2.09%"
},
{
"bizcircleId": NumberInt("214"),
"bizcircleName": "奥北别墅区",
"value": "2.08%"
},
{
"bizcircleId": NumberInt("167"),
"bizcircleName": "朝青",
"value": "2.05%"
},
{
"bizcircleId": NumberInt("166"),
"bizcircleName": "望京",
"value": "1.98%"
},
{
"bizcircleId": NumberInt("175"),
"bizcircleName": "金融街",
"value": "1.97%"
},
{
"bizcircleId": NumberInt("203"),
"bizcircleName": "中关村",
"value": "1.91%"
},
{
"bizcircleId": NumberInt("768"),
"bizcircleName": "德胜门",
"value": "1.83%"
},
{
"bizcircleId": NumberInt("186"),
"bizcircleName": "太阳宫",
"value": "1.82%"
},
{
"bizcircleId": NumberInt("187"),
"bizcircleName": "奥林匹克公园",
"value": "1.74%"
},
{
"bizcircleId": NumberInt("209"),
"bizcircleName": "紫竹院",
"value": "1.71%"
},
{
"bizcircleId": NumberInt("204"),
"bizcircleName": "万柳",
"value": "1.55%"
},
{
"bizcircleId": NumberInt("765"),
"bizcircleName": "北苑",
"value": "1.54%"
},
{
"bizcircleId": NumberInt("212"),
"bizcircleName": "西北旺",
"value": "1.29%"
},
{
"bizcircleId": NumberInt("200"),
"bizcircleName": "世界公园"
},
{
"bizcircleId": NumberInt("164"),
"bizcircleName": "工体"
},
{
"bizcircleId": NumberInt("168"),
"bizcircleName": "安定门"
},
{
"bizcircleId": NumberInt("169"),
"bizcircleName": "后海"
},
{
"bizcircleId": NumberInt("171"),
"bizcircleName": "东单"
},
{
"bizcircleId": NumberInt("172"),
"bizcircleName": "永定门"
},
{
"bizcircleId": NumberInt("173"),
"bizcircleName": "崇文门"
},
{
"bizcircleId": NumberInt("174"),
"bizcircleName": "陶然亭"
},
{
"bizcircleId": NumberInt("176"),
"bizcircleName": "西直门外"
},
{
"bizcircleId": NumberInt("178"),
"bizcircleName": "建国门"
},
{
"bizcircleId": NumberInt("180"),
"bizcircleName": "双井"
},
{
"bizcircleId": NumberInt("181"),
"bizcircleName": "十八里店"
},
{
"bizcircleId": NumberInt("182"),
"bizcircleName": "小红门"
},
{
"bizcircleId": NumberInt("183"),
"bizcircleName": "高碑店"
},
{
"bizcircleId": NumberInt("184"),
"bizcircleName": "五方桥"
},
{
"bizcircleId": NumberInt("185"),
"bizcircleName": "管庄"
},
{
"bizcircleId": NumberInt("188"),
"bizcircleName": "奥体"
},
{
"bizcircleId": NumberInt("192"),
"bizcircleName": "姚家园"
},
{
"bizcircleId": NumberInt("196"),
"bizcircleName": "通州新城"
},
{
"bizcircleId": NumberInt("197"),
"bizcircleName": "亦庄开发区"
},
{
"bizcircleId": NumberInt("202"),
"bizcircleName": "燕西别墅区"
},
{
"bizcircleId": NumberInt("205"),
"bizcircleName": "世纪城"
},
{
"bizcircleId": NumberInt("207"),
"bizcircleName": "玉渊潭"
},
{
"bizcircleId": NumberInt("210"),
"bizcircleName": "马甸"
},
{
"bizcircleId": NumberInt("211"),
"bizcircleName": "清河上地"
},
{
"bizcircleId": NumberInt("213"),
"bizcircleName": "海淀北部新区"
},
{
"bizcircleId": NumberInt("216"),
"bizcircleName": "石景山"
},
{
"bizcircleId": NumberInt("217"),
"bizcircleName": "门头沟"
},
{
"bizcircleId": NumberInt("218"),
"bizcircleName": "房山"
},
{
"bizcircleId": NumberInt("219"),
"bizcircleName": "密云"
},
{
"bizcircleId": NumberInt("220"),
"bizcircleName": "怀柔"
},
{
"bizcircleId": NumberInt("221"),
"bizcircleName": "延庆"
},
{
"bizcircleId": NumberInt("222"),
"bizcircleName": "平谷"
},
{
"bizcircleId": NumberInt("521"),
"bizcircleName": "中南海"
},
{
"bizcircleId": NumberInt("522"),
"bizcircleName": "新街口"
},
{
"bizcircleId": NumberInt("523"),
"bizcircleName": "白塔寺"
},
{
"bizcircleId": NumberInt("524"),
"bizcircleName": "西四"
},
{
"bizcircleId": NumberInt("525"),
"bizcircleName": "北海景山"
},
{
"bizcircleId": NumberInt("526"),
"bizcircleName": "前门"
},
{
"bizcircleId": NumberInt("527"),
"bizcircleName": "鼓楼"
},
{
"bizcircleId": NumberInt("528"),
"bizcircleName": "雍和宫北新桥"
},
{
"bizcircleId": NumberInt("529"),
"bizcircleName": "南锣鼓巷"
},
{
"bizcircleId": NumberInt("530"),
"bizcircleName": "东四"
},
{
"bizcircleId": NumberInt("531"),
"bizcircleName": "故宫南北池子"
},
{
"bizcircleId": NumberInt("532"),
"bizcircleName": "金宝街"
},
{
"bizcircleId": NumberInt("767"),
"bizcircleName": "泛CBD东别墅区"
},
{
"bizcircleId": NumberInt("769"),
"bizcircleName": "故宫"
},
{
"bizcircleId": NumberInt("772"),
"bizcircleName": "雍和宫"
},
{
"bizcircleId": NumberInt("778"),
"bizcircleName": "潮白河别墅区"
},
{
"bizcircleId": NumberInt("782"),
"bizcircleName": "西直门"
},
{
"bizcircleId": NumberInt("785"),
"bizcircleName": "朝阳门"
},
{
"bizcircleId": NumberInt("1343"),
"bizcircleName": "分钟寺"
}
],
"rankTitle": "租金回报率"
}
]
}
],
"id": "tabs_g",
"type": "tabs",
"_class": "com.test.job.marketreport.document.ReportSubmoduleTabs"
}
],
"_class": "com.test.job.marketreport.document.ReportModule"
},
{
"id": "h",
"code": "h",
"displayName": "封底",
"_class": "com.test.job.marketreport.document.ReportModule"
}
],
"reportType": "208700000001",
"reportAttr": "bizcircle",
"reportOrder": NumberInt("20243"),
"reportTimeName2": "1月豪宅市场兹讯",
"districtId": "110105",
"month": "01",
"letter": "",
"share": "",
"_class": "com.alibaba.fastjson.JSONObject"
}
三、Mongo导出SQL(失败)
我要取modules数组中第三部分整体价值介绍中submodules数组的第一个数组下submodules数组下metrics下的value值,试着SQL写了很多次,感觉就是一直点下去的事,但尝试着总不行。以下是我的几个尝试:
第一个这种写法各种改都不行
db.getCollection("bizcircleReport").find({ "reportOrder": { "$gt": 202103 } }, { "modules.2.submodules.0.submodules.0.metrics.value": 1, "_id": 0 });
db.getCollection("bizcircleReport").find(
{ "reportOrder": { "$gt": 20213 }, "reportType": "208700000001" },
{
"cityCode": 1,
"year": 1,
"month": 1,
"districtName": 1,
"bizcircleId": 1,
"bizcircleName": 1,
"reportOrder":1,
"_id": 0,
"modules": { "$slice": 3},
"modules.2": 1
}
);
四、代码导出
先用"modules": { "$slice": 3}筛检一部分数据导出为json格式的,然后代码读取把每个值用英文逗号分割,保存为csv就是一个格一个值了
String fileName = "C:\\Users\\11562\\Desktop\\report.csv";
FileWriter fileWriter = new FileWriter(fileName);
BufferedWriter bufferedWriter = new BufferedWriter(fileWriter);
bufferedWriter.write("城市,年,月,区域,商圈,二手楼盘均价(万/㎡),一手楼盘均价(万/㎡),二手成交量(套),一手成交量(套),换手率,单位租金(元/㎡/月),租金回报率");
bufferedWriter.newLine();
String path = "C:\\Users\\11562\\Documents\\WXWork\\1688852348837010\\Cache\\File\\2024-04\\Result_1.json";
BufferedReader reader = new BufferedReader(new InputStreamReader(new FileInputStream(path)));
String json = reader.lines().collect(Collectors.joining());
JSONArray jsonArray = JSONObject.parseArray(json);
for (Object o : jsonArray) {
JSONObject itemJson = (JSONObject) o;
Integer year = itemJson.getInteger("year");
Integer month = itemJson.getInteger("month");
Integer cityCode = itemJson.getInteger("cityCode");
String districtName = itemJson.getString("districtName");
String bizcircleName = itemJson.getString("bizcircleName");
if (year < 2021 || (year == 2021 && month<3)){
continue;
}
JSONArray modules = itemJson.getJSONArray("modules");
//整体价值介绍
JSONObject modules3 = (JSONObject)modules.get(2);
JSONArray submodules1 = modules3.getJSONArray("submodules");
JSONObject submodules2 = (JSONObject)submodules1.get(0);
//成交均价
JSONObject metrics1 = (JSONObject)submodules2.getJSONArray("submodules").get(0);
JSONObject metrics11 =(JSONObject)metrics1.getJSONArray("metrics").get(0);
JSONObject metrics12 =(JSONObject)metrics1.getJSONArray("metrics").get(1);
//成交量
JSONObject metrics2 = (JSONObject)submodules2.getJSONArray("submodules").get(1);
JSONObject metrics21 =(JSONObject)metrics2.getJSONArray("metrics").get(0);
JSONObject metrics22 =(JSONObject)metrics2.getJSONArray("metrics").get(1);
JSONObject metrics23 =(JSONObject)metrics2.getJSONArray("metrics").get(2);
//租金
JSONObject metrics3 = (JSONObject)submodules2.getJSONArray("submodules").get(2);
JSONObject metrics31 =(JSONObject)metrics3.getJSONArray("metrics").get(0);
JSONObject metrics32 =(JSONObject)metrics3.getJSONArray("metrics").get(1);
// 写入数据
bufferedWriter.write(cityCode+","+year+","+month+","+districtName.replaceAll(",",",")+","+bizcircleName
+","+(metrics11.getBigDecimal("value")==null ? "":metrics11.getBigDecimal("value"))
+","+(metrics12.getBigDecimal("value")==null ? "":metrics12.getBigDecimal("value"))
+","+(metrics21.getBigDecimal("value")==null ? "":metrics21.getBigDecimal("value"))
+","+(metrics22.getBigDecimal("value")==null ? "":metrics22.getBigDecimal("value"))
+","+(StringUtils.isEmpty(metrics23.getString("value"))? "":metrics23.getString("value"))
+","+(metrics31.getBigDecimal("value")==null ? "":metrics31.getBigDecimal("value"))
+","+(StringUtils.isEmpty(metrics32.getString("value"))? "":metrics32.getString("value"))
);
bufferedWriter.newLine();
}
bufferedWriter.close();
结果:
四、感悟
作为一个技术人很容易陷入细节,刚开始总觉得一级级往下的事,没有很复杂,结果尝试了很久总导着有问题,最后跳出思维,想着既然Mongo查询的语句没有那么擅长就用代码吧,很快就写完了。所以不要纠结怎么SQL查询写不出来这些,无论是什么形式,结果出来了就好。
最近太忙了,以后有空知道咋用SQL查询了,再更新博客
伙伴们你们要是有兴趣或者知道咋写,也可以告诉我怎么直接SQL出来