使用Python从数据库表中测量经纬度和经度坐标之间距离

import pymysql
from geopy.distance import geodesic

# 假设数据库信息如下
host = 'localhost'
user = 'root'
password = 'password'
database = 'your_database'

# 连接数据库
conn = pymysql.connect(host=host, user=user, password=password, database=database)

# 创建游标
cur = conn.cursor()

# 执行查询
cur.execute("SELECT latitude, longitude FROM locations")

# 获取查询结果
rows = cur.fetchall()

# 假设我们想要计算距离的目标坐标是(40.7128, -74.0060)，即纽约市的经纬度坐标
target_latitude = 40.7128
target_longitude = -74.0060

for row in rows:
    latitude = row[0]
    longitude = row[1]
    
    # 计算距离
    distance = geodesic((target_latitude, target_longitude), (latitude, longitude)).kilometers
    print(f"距离目标坐标的距离为：{distance}公里")