from ReadAreaList import * import decode_mapbar import sqlite3 conn = sqlite3.connect(cur_file_dir() + '/../fetchDianPin/dianpinData.db') cur = conn.cursor() cur.execute('select shopId,poi from shop_list') poilist = {} for sid, poi in cur: point = decodeDP_POI(poi) point2 = decode_mapbar.croodOffsetDecrypt(point['lng'], point['lat']) poilist[sid] = {'lat': point2[1], 'lng': point2[0]} cur.close() for sid in poilist: point = poilist[sid] conn.execute('update shop_list set lat=?,lng=? where shopId=?', (point['lat'], point['lng'], sid)) conn.commit()
import sqlite3 import math import MinRound import os import decode_mapbar import pylab import json db=sqlite3.connect('../fetchDianPin/AreaShop.db') dc=db.cursor() all_point=[] dc.execute('select shopId,tags,shopname,lat,lng from mastershop') for shopId,tags,shopname,lat,lng in dc: tags=tags.split(',') newp=decode_mapbar.croodOffsetDecrypt(lng,lat) all_point.append({'name':shopname,'point':(newp[1],newp[0]),'tags':tags,'shopid':shopId}) dc.close() #猜测初始中心,选择某些点作为中心,这些点周围的点属于这些中心 newcenter=[] all_point_copy=all_point[:] while len(all_point_copy)>0: nc={'c':all_point_copy[0],'l':[]} pt=all_point_copy[0]['point'] newcenter.append(nc) point_rm=[] del all_point_copy[0] for i in range(0,len(all_point_copy)): nowpt=all_point_copy[i] nowpt_p=nowpt['point']
from ReadAreaList import * import decode_mapbar import sqlite3 conn = sqlite3.connect(cur_file_dir()+'/../fetchDianPin/dianpinData.db') cur=conn.cursor() cur.execute('select shopId,poi from shop_list') poilist={} for sid,poi in cur: point=decodeDP_POI(poi) point2=decode_mapbar.croodOffsetDecrypt(point['lng'],point['lat']) poilist[sid]={'lat':point2[1],'lng':point2[0]} cur.close() for sid in poilist: point=poilist[sid] conn.execute('update shop_list set lat=?,lng=? where shopId=?',(point['lat'],point['lng'],sid)) conn.commit()