mysql geocode_python mysql 调用高德geo转换经纬度为详细地址

import requests

import pandas as pd

import time

import sys

import pymysql

//python 连接数据库

db = pymysql.Connect(

host=’******’,

port=3306,

user=’******’,

passwd=’******’,

db=’******’,

charset=‘utf8’

)

//高德经纬度转详细地址API

def geocode(location):

parameters = {‘location’: location, ‘key’: ‘******’}

base = ‘http://restapi.amap.com/v3/geocode/regeo’

response = requests.get(base, parameters)

answer = response.json()

return answer[‘regeocode’][‘formatted_address’]

cursor = db.cursor()

cursor.execute(“select ccid,c_bikelong,c_bikelat from ****** where status=0 and ( (c_bikeno is not NULL) or ((c_bikelong is not NULL) and (c_bikelat is not NULL)))”)

results = cursor.fetchall()

for row in results:

print(row)

if row[1] is None:

print(“null”)

continue

if row[1] == 0.0 :

print(“0.0”)

continue

if row[1] == ‘0.0’ :

print(“0.0”)

continue

print(“row1:”+row[1])

print(“row2:”+row[2])

datas = geocode(row[1]+’,’+row[2])

print(“datas”)

print(datas)

if datas is None:

continue

if row[0] is None:

continue

sql = “update ****** set addr=’”+datas+"’,status=1 where ccid = ‘"+row[0]+"’"

print(sql)

try:

cursor.execute(sql)

db.commit()

except Exception as e:

db.rollback()

#db.close()

print(“Error:”+e.message)

db.close()

print(“ok:ok”)

---------------------

作者：arpu5211

来源：CSDN

原文：https://blog.csdn.net/weixin_40919376/article/details/94433083

版权声明：本文为博主原创文章，转载请附上博文链接！