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()
