39 lines
5.3 KiB
SQL
39 lines
5.3 KiB
SQL
use uav_airspace;
|
|
-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: uav_airspace
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.33
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Dumping data for table `airport`
|
|
--
|
|
|
|
LOCK TABLES `airport` WRITE;
|
|
/*!40000 ALTER TABLE `airport` DISABLE KEYS */;
|
|
INSERT INTO `airport` VALUES (1034,'ZGCD',NULL,'桃花源机场',NULL,NULL,28.918944,111.639667,1,NULL,NULL,28.918944,111.639667),(1035,'ZGCJ',NULL,'芷江机场',NULL,NULL,27.443889,109.705194,5,NULL,NULL,27.443889,109.705194),(1036,'ZGDY',NULL,'荷花机场',NULL,NULL,29.102917,110.443667,1,NULL,NULL,29.102917,110.443667),(1039,'ZGHA',NULL,'黄花机场',NULL,NULL,28.189083,113.219778,1,NULL,NULL,28.189083,113.219778),(1041,'ZGHY',NULL,'南岳机场',NULL,NULL,26.717222,112.618056,1,NULL,NULL,26.717222,112.618056),(1045,'ZGLG',NULL,'零陵机场',NULL,NULL,26.333889,111.609444,5,NULL,NULL,26.333889,111.609444),(1175,'ZUTR',NULL,'铜仁凤凰机场',NULL,NULL,27.884306,109.309389,1,NULL,NULL,27.884306,109.309389),(1265,'ZGSS',NULL,'白云机场',NULL,NULL,23.32,112.965,1,NULL,NULL,23.178,112.888),(1310,'ZJSY',NULL,'三亚凤凰机场',NULL,NULL,18.3031,109.412,1,NULL,NULL,18.3075,109.422),(1382,'ZSPD',NULL,'上海浦东机场',NULL,NULL,31.1433,121.792,1,NULL,NULL,31.1475,121.802),(1383,'ZSSL',NULL,'上海龙华机场',NULL,NULL,31.1639,121.454,1,NULL,NULL,31.1681,121.464),(1384,'ZHOP',NULL,'上街机场',NULL,NULL,34.8419,113.273,1,NULL,NULL,34.8472,113.286),(1388,'ZBXT',NULL,'邢台机场',NULL,NULL,37.0706,114.505,1,NULL,NULL,37.0769,114.517),(1394,'ZSZN',NULL,'济南遥墙国际机场',NULL,NULL,36.81,117.874,1,NULL,NULL,36.857,117.221),(1416,'ZSDY',NULL,'东营机场',NULL,NULL,37.5086,118.789,1,NULL,NULL,37.5156,118.801),(1426,'ZSZS',NULL,'舟山普陀山机场',NULL,NULL,29.9342,122.361,1,NULL,NULL,29.9378,122.372),(1427,'ZSIM',NULL,'诸城机场',NULL,NULL,36.0283,119.438,1,NULL,NULL,36.0342,119.45),(1428,'ZHZX',NULL,'荆门漳河机场',NULL,NULL,31.1064,112.401,1,NULL,NULL,30.987,112.074),(1429,'ZGUH',NULL,'珠海九洲机场',NULL,NULL,22.2531,113.589,1,NULL,NULL,22.2556,113.601),(1433,'ZSWX',NULL,'硕放机场',NULL,NULL,31.4944,120.429,1,NULL,NULL,31.4983,120.44),(1434,'ZWAK',NULL,'阿克苏机场',NULL,NULL,41.26,80.285,1,NULL,NULL,41.2672,80.2933),(1436,'ZWAT',NULL,'阿勒泰机场',NULL,NULL,47.75,88.0833,1,NULL,NULL,47.7575,88.0931),(1440,'VMMC',NULL,'澳门机场',NULL,NULL,22.15,113.588,1,NULL,NULL,22.1525,113.6),(1455,'ZUAS',NULL,'安顺机场',NULL,NULL,26.2611,105.872,1,NULL,NULL,26.2633,105.882),(1456,'ZHAY',NULL,'安阳机场',NULL,NULL,36.13,114.338,1,NULL,NULL,36.138,114.353),(1457,'ZSBB',NULL,'蚌埠机场',NULL,NULL,32.9303,117.367,1,NULL,NULL,32.9347,117.379),(1466,'ZSAQ',NULL,'安庆机场',NULL,NULL,30.5811,117.048,1,NULL,NULL,30.5844,117.06),(1470,'ZGBH',NULL,'北海福成机场',NULL,NULL,21.54,109.293,1,NULL,NULL,21.5433,109.304),(1598,'ZBCN',NULL,'赤峰玉龙机场',NULL,NULL,42.2528,118.898,1,NULL,NULL,42.165,118.853),(1600,'ZYTL',NULL,'大连机场',NULL,NULL,38.965,121.546,1,NULL,NULL,38.9719,121.558),(1601,'ZUDZ',NULL,'成都双流机场',NULL,NULL,29.6364,105.773,1,NULL,NULL,30.566,103.958),(1602,'ZHDY',NULL,'宜昌三峡机场',NULL,NULL,30.8,111.804,1,NULL,NULL,30.554,111.492),(1603,'ZLTE',NULL,'敦煌机场',NULL,NULL,40.3983,99.7933,1,NULL,NULL,40.173,94.811),(1723,'ZBBD',NULL,'保定机场',NULL,NULL,38.8333,115.52,1,NULL,NULL,38.8397,115.532),(1818,'ZBTJ',NULL,'天津塘沽机场',NULL,NULL,38.904,117.671,2,NULL,NULL,38.904,117.671),(1819,'ZGLD',NULL,'云浮罗定机场',NULL,NULL,22.713,111.613,2,NULL,NULL,22.713,111.613),(1820,'ZYYJ',NULL,'阳江合山机场',NULL,NULL,21.9647,112.114,2,NULL,NULL,21.9647,112.114),(1821,'ZXXA',NULL,'兴安通用机场',NULL,NULL,25.602,110.68,2,NULL,NULL,25.602,110.68),(1822,'JZNY',NULL,'北京南苑机场',NULL,NULL,39.799,116.4094,4,NULL,NULL,39.799,116.4094),(1823,'JZXA',NULL,'西安试飞中心',NULL,NULL,34.6598,109.241,4,NULL,NULL,34.6598,109.241),(1824,'JZCD',NULL,'中航工业成飞',NULL,NULL,30.696,103.981,4,NULL,NULL,30.696,103.981),(1825,'ZBAD',NULL,'北京大兴国际机场',NULL,NULL,39.505357,116.417514,1,NULL,NULL,39.505357,116.417514),(1826,'ZUTF',NULL,'天府国际机场',NULL,NULL,30.308269,104.444648,1,NULL,NULL,30.308269,104.444648);
|
|
/*!40000 ALTER TABLE `airport` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2024-06-17 11:08:28
|