#!/usr/bin/python
#coding:utf-8
import xlrd
import xlwt
import requests
import urllib
import math
import re
pattern_x=re.compile(r'"x":(".+?")')
pattern_y=re.compile(r'"y":(".+?")')
def mercator2wgs84(mercator):
#key1=mercator.keys()[0]
#key2=mercator.keys()[1]
point_x=mercator[0]
point_y=mercator[1]
x=point_x/20037508.3427892*180
y=point_y/20037508.3427892*180
y=180/math.pi*(2*math.atan(math.exp(y*math.pi/180))-math.pi/2)
return (x,y)
def get_mercator(addr):
quote_addr=urllib.quote(addr.encode('utf8'))
city=urllib.quote(u'齐齐哈尔市龙'.encode('utf8'))
province=urllib.quote(u'黑龙江省'.encode('utf8'))
if quote_addr.s