Python pymysql 经纬度坐标位置 计算 kmeans 欧氏距离 曼哈顿距离 计算机课程毕设

/* Navicat Premium Data Transfer Source Server : MySQL Source Server Type : MySQL Source Server Version : 80023 Source Host : localhost:3306 Source Schema : dr289 Target Server Type : MySQL Target Server Version : 80023 File Encoding : 65001 Date: 02/03/2022 19:48:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for location -- ---------------------------- DROP TABLE IF EXISTS `location`; CREATE TABLE `location` ( `longitude` double NULL DEFAULT NULL, `latitude` double NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of location -- ---------------------------- INSERT INTO `location` VALUES (4.54, 4.54); INSERT INTO `location` VALUES (5.22, 5.22); INSERT INTO `location` VALUES (4.75, 4.75); INSERT INTO `location` VALUES (4.68, 4.68); INSERT INTO `location` VALUES (5.18, 5.18); INSERT INTO `location` VALUES (4.64, 4.64); INSERT INTO `location` VALUES (4.87, 4.87); INSERT INTO `location` VALUES (4.76, 4.76); INSERT INTO `location` VALUES (5.43, 5.43); INSERT INTO `location` VALUES (5.29, 5.29); INSERT INTO `location` VALUES (5.16, 5.16); INSERT INTO `location` VALUES (5.16, 5.16); INSERT INTO `location` VALUES (4.97, 4.97); INSERT INTO `location` VALUES (4.58, 4.58); INSERT INTO `location` VALUES (4.64, 4.64); INSERT INTO `location` VALUES (5.42, 5.42); INSERT INTO `location` VALUES (4.65, 4.65); INSERT INTO `location` VALUES (4.87, 4.87); INSERT INTO `location` VALUES (4.58, 4.58); INSERT INTO `location` VALUES (4.94, 4.94); INSERT INTO `location` VALUES (4.84, 4.84); INSERT INTO `location` VALUES (4.88, 4.88); INSERT INTO `location` VALUES (5.21, 5.21); INSERT INTO `location` VALUES (4.76, 4.76); INSERT INTO `location` VALUES (4.87, 4.87); INSERT INTO `location` VALUES (4.95, 4.95); INSERT INTO `location` VALUES (5.41, 5.41); INSERT INTO `location` VALUES (5.42, 5.42); INSERT INTO `location` VALUES (4.71, 4.71); INSERT INTO `location` VALUES (5.43, 5.43); INSERT INTO `location` VALUES (5.25, 5.25); INSERT INTO `location` VALUES (5.49, 5.49); INSERT INTO `location` VALUES (4.53, 4.53); INSERT INTO `location` VALUES (5, 5); INSERT INTO `location` VALUES (5.03, 5.03); INSERT INTO `location` VALUES (4.95, 4.95); INSERT INTO `location` VALUES (4.7, 4.7); INSERT INTO `location` VALUES (4.85, 4.85); INSERT INTO `location` VALUES (5.07, 5.07); INSERT INTO `location` VALUES (5.34, 5.34); INSERT INTO `location` VALUES (5.05, 5.05); INSERT INTO `location` VALUES (4.93, 4.93); INSERT INTO `location` VALUES (5.28, 5.28); INSERT INTO `location` VALUES (5.1, 5.1); INSERT INTO `location` VALUES (4.52, 4.52); INSERT INTO `location` VALUES (4.99, 4.99); INSERT INTO `location` VALUES (5.07, 5.07); INSERT INTO `location` VALUES (5.38, 5.38); INSERT INTO `location` VALUES (5.34, 5.34); INSERT INTO `location` VALUES (5.43, 5.43); INSERT INTO `location` VALUES (4.6, 4.6); INSERT INTO `location` VALUES (4.52, 4.52); INSERT INTO `location` VALUES (4.86, 4.86); INSERT INTO `location` VALUES (5.23, 5.23); INSERT INTO `location` VALUES (5.13, 5.13); INSERT INTO `location` VALUES (5.3100000000000005, 5.3100000000000005); INSERT INTO `location` VALUES (4.65, 4.65); INSERT INTO `location` VALUES (5.03, 5.03); INSERT INTO `location` VALUES (4.85, 4.85); INSERT INTO `location` VALUES (5.09, 5.09); INSERT INTO `location` VALUES (5.0600000000000005, 5.0600000000000005); INSERT INTO `location` VALUES (4.93, 4.93); INSERT INTO `location` VALUES (4.94, 4.94); INSERT INTO `location` VALUES (5.49, 5.49); INSERT INTO `location` VALUES (4.99, 4.99); INSERT INTO `location` VALUES (4.63, 4.63); INSERT INTO `location` VALUES (4.76, 4.76); INSERT INTO `location` VALUES (5.03, 5.03); INSERT INTO `location` VALUES (5.33, 5.33); INSERT INTO `location` VALUES (4.96, 4.96); INSERT INTO `location` VALUES (5.42, 5.42); INSERT INTO `location` VALUES (4.75, 4.75); INSERT INTO `location` VALUES (4.96, 4.96); INSERT INTO `location` VALUES (5.28, 5.28); INSERT INTO `location` VALUES (5.13, 5.13); INSERT INTO `location` VALUES (5.11, 5.11); INSERT INTO `location` VALUES (4.74, 4.74); INSERT INTO `location` VALUES (4.58, 4.58); INSERT INTO `location` VALUES (5.34, 5.34); INSERT INTO `location` VALUES (5.36, 5.36); INSERT INTO `location` VALUES (4.64, 4.64); INSERT INTO `location` VALUES (5.03, 5.03); INSERT INTO `location` VALUES (5.01, 5.01); INSERT INTO `location` VALUES (5.04, 5.04); INSERT INTO `location` VALUES (5.44, 5.44); INSERT INTO `location` VALUES (4.55, 4.55); INSERT INTO `location` VALUES (5.4, 5.4); INSERT INTO `location` VALUES (4.51, 4.51); INSERT INTO `location` VALUES (5.02, 5.02); INSERT INTO `location` VALUES (5.02, 5.02); INSERT INTO `location` VALUES (5.38, 5.38); INSERT INTO `location` VALUES (5.07, 5.07); INSERT INTO `location` VALUES (4.87, 4.87); INSERT INTO `location` VALUES (5.45, 5.45); INSERT INTO `location` VALUES (5.27, 5.27); INSERT INTO `location` VALUES (5.28, 5.28); INSERT INTO `location` VALUES (5.36, 5.36); INSERT INTO `location` VALUES (5.11, 5.11); INSERT INTO `location` VALUES (4.74, 4.74); INSERT INTO `location` VALUES (5.08, 5.08); INSERT INTO `location` VALUES (5.12, 5.12); INSERT INTO `location` VALUES (5.12, 5.12); INSERT INTO `location` VALUES (5.05, 5.05); INSERT INTO `location` VALUES (5.42, 5.42); INSERT INTO `location` VALUES (4.55, 4.55); INSERT INTO `location` VALUES (4.79, 4.79); INSERT INTO `location` VALUES (5.17, 5.17); INSERT INTO `location` VALUES (4.79, 4.79); INSERT INTO `location` VALUES (5.45, 5.45); INSERT INTO `location` VALUES (5.44, 5.44); INSERT INTO `location` VALUES (4.76, 4.76); INSERT INTO `location` VALUES (4.64, 4.64); INSERT INTO `location` VALUES (5.49, 5.49); INSERT INTO `location` VALUES (5.3, 5.3); INSERT INTO `location` VALUES (5.23, 5.23); INSERT INTO `location` VALUES (4.74, 4.74); INSERT INTO `location` VALUES (5.08, 5.08); INSERT INTO `location` VALUES (5.36, 5.36); INSERT INTO `location` VALUES (4.54, 4.54); INSERT INTO `location` VALUES (5.15, 5.15); INSERT INTO `location` VALUES (4.53, 4.53); INSERT INTO `location` VALUES (5.33, 5.33); INSERT INTO `location` VALUES (4.74, 4.74); INSERT INTO `location` VALUES (4.67, 4.67); INSERT INTO `location` VALUES (4.71, 4.71); INSERT INTO `location` VALUES (5.26, 5.26); INSERT INTO `location` VALUES (5.38, 5.38); INSERT INTO `location` VALUES (4.71, 4.71); INSERT INTO `location` VALUES (5.43, 5.43); INSERT INTO `location` VALUES (5.04, 5.04); INSERT INTO `location` VALUES (4.53, 4.53); INSERT INTO `location` VALUES (4.85, 4.85); INSERT INTO `location` VALUES (5.11, 5.11); INSERT INTO `location` VALUES (4.63, 4.63); INSERT INTO `location` VALUES (4.89, 4.89); INSERT INTO `location` VALUES (4.58, 4.58); INSERT INTO `location` VALUES (4.58, 4.58); INSERT INTO `location` VALUES (5.01, 5.01); INSERT INTO `location` VALUES (5.25, 5.25); INSERT INTO `location` VALUES (5.24, 5.24); INSERT INTO `location` VALUES (5.37, 5.37); INSERT INTO `location` VALUES (5.17, 5.17); INSERT INTO `location` VALUES (4.88, 4.88); INSERT INTO `location` VALUES (5.28, 5.28); INSERT INTO `location` VALUES (4.84, 4.84); INSERT INTO `location` VALUES (5.3100000000000005, 5.3100000000000005); INSERT INTO `location` VALUES (5.25, 5.25); INSERT INTO `location` VALUES (4.6, 4.6); INSERT INTO `location` VALUES (5.02, 5.02); INSERT INTO `location` VALUES (4.91, 4.91); INSERT INTO `location` VALUES (5.33, 5.33); INSERT INTO `location` VALUES (4.61, 4.61); INSERT INTO `location` VALUES (5.0600000000000005, 5.0600000000000005); INSERT INTO `location` VALUES (5.49, 5.49); INSERT INTO `location` VALUES (5.07, 5.07); INSERT INTO `location` VALUES (4.76, 4.76); INSERT INTO `location` VALUES (4.69, 4.69); INSERT INTO `location`