python之地图类信息爬取

复制代码
import requests
import bs4
import Mysql
import time
import pymysql
db = pymysql.connect(host="localhost",port=3306,user='root',password='Njx200259',db="sjz_kg")
update = db.cursor()


head = {
    "User-Agent":"""Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.82"""
}

longitude = 114.397948
latitude = 38.08732

while longitude<114.664416 and latitude>37.778511:
    print('开始')
    url="https://ditu.amap.com/service/regeo?longitude="+str(longitude)+"&latitude="+str(latitude)
    print("\n"+url)
    params = {
        "longitude": str(str(longitude)),
        "latitude": str(str(latitude))
    }
    r = requests.get(url,headers = head,params = params)
    r.encoding="utf-8"
    road_data=r.json()["data"]["road_list"]
    for road in road_data:
        name=road["name"]
        level=road["level"]
        print(name+" : "+level)
        print("UPDATE road set road_level = "+str(level)+" where road_name = '"+name+"'")
        update.execute("UPDATE road set road_level = "+str(level)+" where road_name = '"+name+"'")
        db.commit()

    longitude=longitude+0.001
    if(longitude>114.664416):
        longitude=114.397948
        latitude = latitude - 0.001
复制代码

 

posted @   子过杨梅  阅读(52)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 单线程的Redis速度为什么快?
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 展开说说关于C#中ORM框架的用法!
点击右上角即可分享
微信分享提示