在空间表中查找城市之间的距离

import requests

def get_city_coordinates(city):
    url = "https://apis.map.qq.com/ws/geocoder/v1/"
    params = {
        "address": city,
        "key": "your_api_key"
    }
    response = requests.get(url, params=params)
    data = response.json()
    location = data["result"]["location"]
    return location["lat"], location["lng"]

def calculate_distance(city1, city2):
    lat1, lng1 = get_city_coordinates(city1)
    lat2, lng2 = get_city_coordinates(city2)
    url = "https://apis.map.qq.com/ws/distance/v1/"
    params = {
        "mode": "driving",
        "from": f"{lat1},{lng1}",
        "to": f"{lat2},{lng2}",
        "key": "your_api_key"
    }
    response = requests.get(url, params=params)
    data = response.json()
    distance = data["result"]["elements"][0]["distance"]
    return distance

city1 = "北京"
city2 = "上海"
distance = calculate_distance(city1, city2)
print(f"The distance between {city1} and {city2} is {distance} meters.")