def get_eventbmap(pos) -> BMap:
#[(lo,la),(lo,la)]这种格式即可
BAIDU_AK = "HOTBRAfU1jGcQKHBX15ucKsfZO722eyN"
center = (117.20, 39.12)
c = BMap()
c.add_schema(
baidu_ak=BAIDU_AK,
center=[117.20, 39.12],
zoom=10,
is_roam=False,
)
sequence = []
for i in range(len(pos)):
c.add_coordinate(str(i), pos[i][0], pos[i][1]) #[(posindex,lo,la)]
sequence.append((str(i), 0.1)) #这里名字和pos要对应
c.add(
"投诉坐标", #系列名称
sequence,
type_="scatter", #"heatmap" 可以切换显示的类型热力图或散点图
label_opts=opts.LabelOpts(formatter="{b}"),
symbol_size=5)
c.set_series_opts(effect_opts=opts.EffectOpts(is_show=True),
label_opts=opts.LabelOpts(is_show=False))
c.add_control_panel(
scale_control_opts=opts.BMapScaleControlOpts(),
navigation_control_opts=opts.BMapNavigationControlOpts(),
maptype_control_opts=opts.BMapTypeControlOpts())
#c.set_global_opts(visualmap_opts=opts.VisualMapOpts())
return c
def test_bmap():
b = BMap()
b.add_schema(baidu_ak='iMplFNfYyAf4e7EleegtObtcOZdliriG',center=[116.395645,39.929986],zoom=9)
# 定义坐标对应的名称，添加到坐标库中 add_coordinate(name, lng, lat)
engine = create_engine('mysql+pymysql://root:123456@localhost:3306/house')
# 查询语句，选出employee表中的所有数据
sql = '''select * from 4sstore_beijing;'''
# read_sql_query的两个参数: sql语句， 数据库连接
df = pd.read_sql_query(sql, engine)
data_pair=[]
for index,row in df.iterrows():
b.add_coordinate(row['name'], float(row['lng']),float(row['lat']))
data_pair.append((row['name'], None))
# Geo 图类型，有 scatter, effectScatter, heatmap, lines 4 种，建议使用
# from pyecharts.globals import GeoType
# GeoType.GeoType.EFFECT_SCATTER，GeoType.HEATMAP，GeoType.LINES
# 将数据添加到地图上
b.add('bmap', data_pair, "scatter" ,symbol_size=5)
# 设置样式
b.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
b.set_global_opts(
visualmap_opts=opts.VisualMapOpts(is_piecewise=False),
title_opts=opts.TitleOpts(title="北京4s店分布")
)
return b
def get_bmap(pos) -> BMap:
BAIDU_AK = "HOTBRAfU1jGcQKHBX15ucKsfZO722eyN"
#center = (117.20, 39.12)
c = BMap()
c.add_schema(baidu_ak=BAIDU_AK,
center=[117.20, 39.12],
zoom=10,
is_roam=False)
sequence = []
for i in range(len(pos)):
#print(pos[i])
c.add_coordinate(pos[i][0], pos[i][2], pos[i][1])
sequence.append((str(i), 5))
c.add(
"投诉坐标", #系列名称
sequence,
type_="scatter", #"heatmap" 可以切换显示的类型热力图或散点图
label_opts=opts.LabelOpts(formatter="{b}"),
symbol_size=4 #scatter大小
)
#.add("bmap",
#[{"coord":[117.21, 39.13],"sim":10},{"coord":[117.20, 39.13],"sim":20},{"coord":[117.21, 39.12],"sim":5}],
#[list(z) for z in zip(Faker.provinces, Faker.values())],#zip将迭代对像打包成元组最后的结果是[['浙江',v1],['广东',v2]]
#[[117.21, 39.13],[117.20, 39.12],[117.22, 39.10],[117.25, 39.11],[117.19, 39.02],[117.20, 39.12]],
#type_="heatmap",
#label_opts=opts.LabelOpts(formatter="{b}"))
c.set_series_opts(
effect_opts=opts.EffectOpts(is_show=True),
label_opts=opts.LabelOpts(is_show=False),
)
c.add_control_panel(
scale_control_opts=opts.BMapScaleControlOpts(),
navigation_control_opts=opts.BMapNavigationControlOpts(),
maptype_control_opts=opts.BMapTypeControlOpts())
#copyright_control_opts=opts.BMapCopyrightTypeOpts(copyright_="我的")
#geo_location_control_opts=opts.BMapGeoLocationControlOpts()
#overview_map_opts=opts.BMapOverviewMapControlOpts(is_open=True),
#c.set_global_opts(visualmap_opts=opts.VisualMapOpts(pos_left="right"))
return c
"featureType": "building",
"elementType": "all",
"stylers": {
"color": "#d1d1d1"
}
}, {
"featureType": "label",
"elementType": "labels.text.fill",
"stylers": {
"color": "#999999"
}
}]
})
coord = prepare_coord(load_street_pickle())
for s, (long, lat) in coord.items():
m.add_coordinate(s, long, lat)
speed, n_slice = read_speed()
# Match T-GCN expand 3 times... (don't know why)
idx_map = list(range(0, 114 - 12 - 3 - 1)) + list(range(114, 143 - 12 - 3))
pred_speed, n_slice1 = read_pred_speed()
assert len(idx_map) == n_slice1
m.add(series_name="actual",
type_="heatmap",
data_pair=get_data_pair(speed, 0)).add(
series_name="predict",
type_="heatmap",
data_pair=get_data_pair(pred_speed, 0),
).add_control_panel(
copyright_control_opts=opts.BMapCopyrightTypeOpts(position=3),
maptype_control_opts=opts.BMapTypeControlOpts(
type_=BMapType.MAPTYPE_CONTROL_DROPDOWN),
from pyecharts.charts import BMap
from pyecharts import options as opts
from parse_xml import get_coordinate_list
baidu_log_offset = 0.010598
baidu_lat_offset = 0.00203
# 不习惯链式调用的开发者依旧可以单独调用方法
bmap = BMap(init_opts=opts.InitOpts(width='2000px', height='1000px'))
bmap.add_schema(baidu_ak='GvrsNgKWZokjb1yG7gOphfmHFsrBn8AL',
center=[113.975994, 22.59844],
zoom=16)
coordinate_list = get_coordinate_list('build/my-data.xml')
bunch_points = [[i[2], 1] for i in coordinate_list]
for i, v in enumerate(coordinate_list):
bmap.add_coordinate(v[2], baidu_log_offset + v[0], baidu_lat_offset + v[1])
bmap.add('shenzhen', bunch_points, label_opts=opts.LabelOpts(is_show=False))
bmap.set_global_opts(legend_opts=opts.LegendOpts(is_show=False))
bmap.render()
def plot_map(point_data, path):
point_data = point_data[point_data['remarks'] != 'no_result']
data = point_data[['lat_BaiDu', 'long_BaiDu', 'behavior', 'label']].copy()
data.columns = ['lat', 'lon', 'behavior', 'label']
# 地图中心
map_center = [data['lon'].mean(), data['lat'].mean()]
# 初始化百度地图
bd_map = BMap(init_opts=opts.InitOpts(width="1920px", height="1080px"))
bd_map.add_schema(baidu_ak=KEY,
center=map_center,
zoom=8, is_roam=True,
map_style=None,
)
color = ['red', 'green', 'blue', 'yellow', 'gold', 'cyan', 'magenta', 'purple']
behavior_list = data.drop_duplicates(['behavior'])['behavior'].copy() # 剔除重复的数据文件路径
i = 0
for behavior in behavior_list:
behavior_data = data[data['behavior'] == behavior]
# behavior_color = color_choice() # 从color列表中随机抽取一个颜色
behavior_color = color[i]
i = i + 1
map_data = []
# 利用BMap.add_coordinate 将坐标值赋值给一个地点名称，并增加近BMap对象地理信息中
for j in range(len(behavior_data)):
name = behavior + str(j)
longitude = behavior_data['lon'].iloc[j]
latitude = behavior_data['lat'].iloc[j]
bd_map.add_coordinate(name=name,
longitude=longitude,
latitude=latitude
)
map_data.append((name, 1))
# 将地点增加到百度地图
bd_map = bd_map.add(
series_name=behavior,
type_="scatter",
data_pair=map_data,
symbol_size=20,
effect_opts=opts.EffectOpts(),
label_opts=opts.LabelOpts(formatter="{b}", position="left", is_show=False),
itemstyle_opts=opts.ItemStyleOpts(color=behavior_color),
)
# 显示聚类分析的结果
label_list = data.drop_duplicates(['label'])['label'].copy()
map_data = []
for label in label_list:
if label == -1:
continue
else:
label_data = data[data['label'] == label]
# 将聚类点命名增加至地图地名空间
name = '高风险路段_' + str(label)
bd_map.add_coordinate(name=name,
longitude=label_data['lon'].mean(),
latitude=label_data['lat'].mean()
)
map_data.append((name, len(label_data)))
# 将地点增加到百度地图
bd_map = bd_map.add(
series_name='高风险行为频发路段',
type_="scatter",
data_pair=map_data,
symbol_size=50,
# blur_size=500,
is_selected=True, # 是否选中图例
effect_opts=opts.EffectOpts(),
label_opts=opts.LabelOpts(formatter="{b}", position="right", is_show=False),
itemstyle_opts=opts.ItemStyleOpts(color='rgba(138,43,226, 0.8)'),
)
# 将绘图结果输出至网页文件
bd_map = bd_map.add_control_panel(maptype_control_opts=opts.BMapTypeControlOpts(position=1),
)
# 设置图例
bd_map = bd_map.set_global_opts(legend_opts=opts.LegendOpts(is_show=True,
item_height=50,
),
title_opts=opts.TitleOpts(title="新奥危险货物运输高风险路段聚类分析图"),
)
bd_map = bd_map.render(path)
# 用浏览器打开文件
webbrowser.open(path)
return bd_map
def plot_scatter_map(route_data, path):
route_data = route_data[route_data['speed'] > 10.0]
data = route_data[['lat_BaiDu', 'long_BaiDu', 'behavior', 'label']].copy()
data.columns = ['lat', 'lon', 'behavior', 'label']
# 地图中心
map_center = [data['lon'].mean(), data['lat'].mean()]
# 初始化百度地图
bd_map = BMap(init_opts=opts.InitOpts(width="1920px", height="1080px"))
bd_map.add_schema(
baidu_ak=KEY,
center=map_center,
zoom=8,
is_roam=True,
map_style=None,
)
color = [
'red', 'green', 'blue', 'yellow', 'gold', 'cyan', 'magenta', 'purple'
]
# 将数据分为异常路段和正常路段
normal_route = data[data['label'] <= -0.0].copy()
risk_route = data[data['label'] > 0.0].copy()
# 绘制正常路段散点图，颜色为绿色
normal_map_data = []
# 利用BMap.add_coordinate 将坐标值赋值给一个地点名称，并增加近BMap对象地理信息中
for i in range(len(normal_route)):
name = 'low_risk' + str(i)
longitude = normal_route['lon'].iloc[i]
latitude = normal_route['lat'].iloc[i]
bd_map.add_coordinate(name=name,
longitude=longitude,
latitude=latitude)
normal_map_data.append((name, -1))
# 绘制高风险路段散点图，颜色为红色
risk_map_data = []
# 利用BMap.add_coordinate 将坐标值赋值给一个地点名称，并增加近BMap对象地理信息中
for j in range(len(risk_route)):
name = 'high_risk' + str(j)
longitude = risk_route['lon'].iloc[j]
latitude = risk_route['lat'].iloc[j]
bd_map.add_coordinate(name=name,
longitude=longitude,
latitude=latitude)
risk_map_data.append((name, -1))
# 将低风险轨迹散点标识在百度地图上
bd_map = bd_map.add(
series_name='低风险路段',
type_="scatter",
data_pair=normal_map_data,
symbol_size=10,
effect_opts=opts.EffectOpts(),
label_opts=opts.LabelOpts(formatter="{b}",
position="left",
is_show=False),
itemstyle_opts=opts.ItemStyleOpts(color='green'),
)
# 将高风险轨迹散点标识在百度地图上
bd_map = bd_map.add(
series_name='高风险路段',
type_="scatter",
data_pair=risk_map_data,
symbol_size=20,
effect_opts=opts.EffectOpts(),
label_opts=opts.LabelOpts(formatter="{b}",
position="left",
is_show=False),
itemstyle_opts=opts.ItemStyleOpts(color='red'),
)
# 将绘图结果输出至网页文件
bd_map = bd_map.add_control_panel(
maptype_control_opts=opts.BMapTypeControlOpts(position=1), )
# 设置图例
bd_map = bd_map.set_global_opts(
legend_opts=opts.LegendOpts(
is_show=True,
item_height=50,
),
title_opts=opts.TitleOpts(title="新奥危险货物运输高风险路段聚类分析图"),
)
# 将地图加载到网页
bd_map = bd_map.render(path)
# 用浏览器打开文件
webbrowser.open(path)
return bd_map
# bd_map.add_coordinate(name=name,
# longitude=longitude,
# latitude=latitude
# )
# normal_map_data.append((name, -1))
# 绘制高风险路段散点图，颜色为红色
risk_map_data = []
# 利用BMap.add_coordinate 将坐标值赋值给一个地点名称，并增加近BMap对象地理信息中
for j in range(len(risk_route)):
name = 'high_risk' + str(j)
longitude = risk_route['long_BaiDu'].iloc[j]
latitude = risk_route['lat_GPS'].iloc[j]
bd_map.add_coordinate(name=name,
longitude=longitude,
latitude=latitude)
risk_map_data.append((name, -1))
# bd_map = bd_map.add(
# series_name='低风险路段',
# type_="scatter",
# data_pair=normal_map_data,
# symbol_size=10,
# effect_opts=opts.EffectOpts(),
# label_opts=opts.LabelOpts(formatter="{b}", position="left", is_show=False),
# itemstyle_opts=opts.ItemStyleOpts(color='green'),
# )
# 将高风险轨迹散点标识在百度地图上
bd_map = bd_map.add(
output = 'json'
ak = 'Z2hzbMkqq4hgAS0IPHgRYPoRfjP9QBee'
url = 'http://api.map.baidu.com/place/v2/search?q=华中科技大学食堂®ion=武汉&output=' + output + '&ak=' + ak
r = requests.get(url)
r_js = r.json()
for i in range(0, 9):
names = r_js['results'][i]['name']
lng_ = r_js['results'][i]['location']['lng']
lat_ = r_js['results'][i]['location']['lat']
print(names, lng_, lat_)
c = BMap()
c.width = "1000px"
c.height = "800px"
c.add_schema(baidu_ak='Z2hzbMkqq4hgAS0IPHgRYPoRfjP9QBee',
center=[114.421214, 30.519139],
zoom=17)
for i in range(0, 9):
c.add_coordinate(r_js['results'][i]['name'],
r_js['results'][i]['location']['lng'],
r_js['results'][i]['location']['lat'])
c.add("华中科技大学食堂", [(r_js['results'][i]['name'], "#404a59")],
color="#404a59")
c.set_global_opts(title_opts=opts.TitleOpts(title="BMap-基本示例"),
visualmap_opts=opts.VisualMapOpts(is_piecewise=True))
c.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
c.render()
'''driver = webdriver.Chrome()
driver.get("F:///pyecharts/untitled/html/road.html")
driver.get("http://127.0.0.1:8848/untitled/road.html")'''
def heatmap() -> Line:
sql1 = """
SELECT
CONCAT(city, '市', region, POSITION) AS pos,
longitude,
latitude,
AVG(rent)
FROM
house
WHERE city = '北京'
AND longitude != 0
AND latitude != 0
GROUP BY pos;
"""
sql2 = """
SELECT
CONCAT(city, '市', region, POSITION) AS pos,
longitude,
latitude,
AVG(rent)
FROM
house
WHERE city = '上海'
AND longitude != 0
AND latitude != 0
GROUP BY pos;
"""
sql3 = """
SELECT
CONCAT(city, '市', region, POSITION) AS pos,
longitude,
latitude,
AVG(rent)
FROM
house
WHERE city = '广州'
AND longitude != 0
AND latitude != 0
GROUP BY pos;
"""
sql4 = """
SELECT
CONCAT(city, '市', region, POSITION) AS pos,
longitude,
latitude,
AVG(rent)
FROM
house
WHERE city = '深圳'
AND longitude != 0
AND latitude != 0
GROUP BY pos;
"""
with connection.cursor() as cursor:
cursor.execute(sql1)
rows1 = cursor.fetchall()
cursor.execute(sql2)
rows2 = cursor.fetchall()
cursor.execute(sql3)
rows3 = cursor.fetchall()
cursor.execute(sql4)
rows4 = cursor.fetchall()
data1 = []
coord = []
for row in rows1:
coord.append([row[0], row[1], row[2]])
data1.append((row[0], row[3]))
data2 = []
for row in rows2:
coord.append([row[0], row[1], row[2]])
data2.append((row[0], row[3]))
data3 = []
for row in rows3:
coord.append([row[0], row[1], row[2]])
data3.append((row[0], row[3]))
data4 = []
for row in rows4:
coord.append([row[0], row[1], row[2]])
data4.append((row[0], row[3]))
# 添加坐标
b = BMap()
for item in coord:
b.add_coordinate(item[0], item[1], item[2])
sql1 = ""
c = (b.add_schema(baidu_ak="ecW4FwdyIvse01ZzuQpYeiFsqOlTqmnv",
center=[120.13066322374, 30.240018034923],
zoom=5,
is_roam=True).add(
"北京",
data1,
type_="heatmap",
label_opts=opts.LabelOpts(formatter="{b}"),
).add(
"上海",
data2,
type_="heatmap",
label_opts=opts.LabelOpts(formatter="{b}"),
).add(
"广州",
data3,
type_="heatmap",
label_opts=opts.LabelOpts(formatter="{b}"),
).add(
"深圳",
data4,
type_="heatmap",
label_opts=opts.LabelOpts(formatter="{b}"),
).set_global_opts(
title_opts=opts.TitleOpts(title="各地小区租房均价热力图"),
visualmap_opts=opts.VisualMapOpts(
max_=10000,
min_=900)).dump_options_with_quotes())
return c
def locate():
# 对数据进行绘图
station_data = pd.read_csv("station.csv",header = 0, sep = '\t')
latitude = station_data['lat'].values
longitude = station_data['lng'].values
index = station_data['station_id'].values
length = len(latitude)
mag = [1] * length
#可视化
BMaps = BMap()
data_pair = dict.fromkeys(index, 0)
user = pd.read_csv("mobile.csv",header = 0, sep = '\t')
locate = user['station_id'].values
count = user['count'].values
for i in range(len(locate)):
try:
if count[i] >= 10:
data_pair[locate[i]] += int(count[i])
except:
pass
for i in range(len(index)):
BMaps.add_coordinate(index[i], longitude[i], latitude[i])
BMaps.add_schema(baidu_ak = 'UoW1wfwAiRoBPYeh52XzdUGGoByxmUN2',
center=(121.37, 31.23),
zoom=10,
map_style={
"styleJson": [
{
"featureType": "water",
"elementType": "all",
"stylers": {"color": "#031628"},
},
{
"featureType": "land",
"elementType": "geometry",
"stylers": {"color": "#000102"},
},
{
"featureType": "highway",
"elementType": "all",
"stylers": {"color": "#50A3BA"},
},
{
"featureType": "local",
"elementType": "geometry",
"stylers": {"color": "#000000"},
},
{
"featureType": "railway",
"elementType": "geometry.fill",
"stylers": {"color": "#000000"},
},
{
"featureType": "railway",
"elementType": "geometry.stroke",
"stylers": {"color": "#08304b"},
},
{
"featureType": "building",
"elementType": "geometry.fill",
"stylers": {"color": "#000000"},
},
{
"featureType": "all",
"elementType": "labels.text.fill",
"stylers": {"color": "#857f7f"},
},
{
"featureType": "all",
"elementType": "labels.text.stroke",
"stylers": {"color": "#000000"},
},
{
"featureType": "building",
"elementType": "geometry",
"stylers": {"color": "#022338"},
},
{
"featureType": "green",
"elementType": "geometry",
"stylers": {"color": "#062032"},
},
{
"featureType": "boundary",
"elementType": "all",
"stylers": {"color": "#465b6c"},
},
{
"featureType": "manmade",
"elementType": "all",
"stylers": {"color": "#022338"},
},
{
"featureType": "label",
"elementType": "all",
"stylers": {"visibility": "on"},
},
]
})
# 添加数据点
data_pair = [list(z) for z in zip(data_pair.keys(), data_pair.values())]
BMaps.add('次数', data_pair,type_="scatter",symbol_size=3, label_opts=opts.LabelOpts(is_show=False))
pieces = [
{'max': 10000, 'label': '10000以下', 'color': '#50A3BA'},
{'min': 10000, 'max': 20000, 'label': '10000-20000', 'color': '#E2C568'},
{'min': 20000, 'max': 30000, 'label': '20000-30000', 'color': '#D94E5D'},
{'min': 30000, 'max': 40000, 'label': '30000-40000', 'color': '#3700A4'},
{'min': 40000, 'label': '40000+', 'color': '#81AE9F'},
]
BMaps.set_global_opts(
visualmap_opts=opts.VisualMapOpts(is_piecewise=True, pieces= pieces, pos_top='top', pos_left = 'right'),
title_opts=opts.TitleOpts(title="基站频率分布>10")
)
#导出图像
BMaps.render('基站频率分布10.html')
