import sqlite3import bd_gc_84import csvimport timestart =time.clock()print("正在运行..................")#新建csv文件file = open('dezhou.csv', 'w', encoding='utf-8', newline="")csv_writer = csv.writer(file)csv_writer.writerow(["x","y","count","cityId","date"])#打开数据库con = sqlite3.connect("E:\BaiDuMap\hydata.db") c = con.cursor()i = 0for row in c.execute("select * from heatmapdata where cityId = 372"):# if i >= 100000:#break# print(row)#百度墨卡托转百度经纬度bd09mcTobd09ll = bd_gc_84.mercatortobd09(row[0],row[1])# print(bd09mcTobd09ll)#百度经纬度转国测bd09togc = bd_gc_84.bd09togcj02(bd09mcTobd09ll[0],bd09mcTobd09ll[1])# print(bd09togc)#国测转84gcto84 = bd_gc_84.gcj02towgs84(bd09togc[0],bd09togc[1])# print(gcto84)#写入文件csv_writer.writerow([gcto84[0],gcto84[1],row[2],row[3],row[4]])i = i + 1#利用百度接口进行转换# url = "https://api./geoconv/v1/?coords=" + x + "," + y + "&from=6&to=3&ak=TAnwBKfyivSOa4iqeO6Gw6lRhNF3zKel"# print (url)#关闭文档file.close()print("运行结束！")#关闭数据库c.close()con.close()print("转换数据总量：" + str(i))end = time.clock()print("运行时间:" + "%.3f"%(end-start)+"秒")
