addrtab.sql

计算卫星天线角度

create table addrtab(addrname varchar(10) not null,
                     接收地经度 float(10) not null,
                     接收地纬度 float(10) not null,
                     primary key(addrname));

 insert into addrtab values ( '合肥 ', ' 31.52 ', '117.17');
 insert into addrtab values (  '安庆 ', ' 30.31 ', '117.02');
 insert into addrtab values (  '蚌埠 ', ' 32.56 ', '117.21');
 insert into addrtab values (  '亳州 ', ' 33.52 ', '115.47');
 insert into addrtab values (  '巢湖 ', ' 31.36 ', '117.52');
 insert into addrtab values (  '滁州 ', ' 32.18 ', '118.18');
 insert into addrtab values (  '阜阳 ', ' 32.54 ', '115.48');
 insert into addrtab values (  '贵池 ', ' 30.39 ', '117.28');
 insert into addrtab values (  '淮北 ', ' 33.57 ', '116.47');
 insert into addrtab values (  '淮南 ', ' 32.37 ', '116.58');
 insert into addrtab values (  '黄山 ', ' 29.43 ', '118.18');
 insert into addrtab values (  '界首 ', ' 33.15 ', '115.21');
 insert into addrtab values ( '六安 ', ' 31.44 ', '116.28');
 insert into addrtab values (  '马鞍山 ',  '31.43 ', '118.28');
 insert into addrtab values (  '明光 ', ' 32.47 ', '117.58');
 insert into addrtab values (  '宿州 ', ' 33.38 ', '116.58');
 insert into addrtab values (  '天长 ', ' 32.41 ', '118.59');
 insert into addrtab values (  '铜陵 ', ' 30.56 ', '117.48');
 insert into addrtab values (  '芜湖 ', ' 31.19 ', '118.22');
 insert into addrtab values (  '宣州 ', ' 30.57 ', '118.44');
insert into addrtab values ( '澳门 ', ' 21.33 ', '115.07');
insert into addrtab values ( '北京 ', ' 39.55 ', '116.24');
 insert into addrtab values ( ' 福州 ', ' 26.05 ', '119.18');
 insert into addrtab values ( ' 长乐 ', ' 25.58 ', '119.31');
 insert into addrtab values ( ' 福安 ', ' 27.06 ', '119.39');
 insert into addrtab values ( ' 福清 ', ' 25.42 ', '119.23');
 insert into addrtab values ( ' 建瓯 ', ' 27.03 ', '118.20');
 insert into addrtab values ( ' 建阳 ', ' 27.21 ', '118.07');
 insert into addrtab values ( ' 晋江 ', ' 24.49 ', '118.35');
 insert into addrtab values (  '龙海 ', ' 24.26 ', '117.48');
 insert into addrtab values (  '龙岩 ', ' 25.06 ', '117.01');
 insert into addrtab values (  '南安 ', ' 24.57 ', '118.23');
 insert into addrtab values (  '南平 ', ' 26.38 ', '118.10');
 insert into addrtab values (  '宁德 ', ' 26.39 ', '119.31');
 insert into addrtab values (  '莆田 ', ' 24.26 ', '119.01');
 insert into addrtab values (  '泉州 ', ' 24.56 ', '118.36');
 insert into addrtab values (  '三明 ', ' 26.13 ', '117.36');
 insert into addrtab values (  '邵武 ', ' 27.20 ', '117.29');
 insert into addrtab values (  '石狮 ', ' 24.44 ', '118.38');
 insert into addrtab values (  '武夷山', '  27.46 ', '118.02');
 insert into addrtab values (  '厦门 ', ' 24.27 ', '118.06');
 insert into addrtab values (  '永安 ', ' 25.58 ', '117.23');
 insert into addrtab values (  '漳平 ', ' 25.17 ', '117.24');
 insert into addrtab values (  '漳州 ', ' 24.31 ', '117.39');
 insert into addrtab values (  '兰州 ', ' 36.04 ', '103.51');
 insert into addrtab values (  '白银 ', ' 36.33 ', '104.12');
 insert into addrtab values (  '敦煌 ', ' 40.08 ', '94.41');
 insert into addrtab values (  '嘉峪关', '  39.48 ', '98.14');
 insert into addrtab values (  '金昌 ', ' 38.28 ', '102.10');
 insert into addrtab values (  '酒泉 ', ' 39.44 ', '98.31');
 insert into addrtab values (  '临夏 ', ' 35.37 ', '103.12');
 insert into addrtab values (  '平凉 ', ' 35.32 ', '106.40');
 insert into addrtab values (  '天水 ', ' 34.37 ', '105.42');
 insert into addrtab values (  '武威 ', ' 37.56 ', '102.39');
 insert into addrtab values (  '西峰 ', ' 35.45 ', '107.40');
 insert into addrtab values (  '玉门 ', ' 39.49 ', '97.35');
 insert into addrtab values (  '张掖 ', ' 38.56 ', '100.26');
 insert into addrtab values (  '广州 ', ' 23.08 ', '113.14');
 insert into addrtab values (  '潮阳 ', ' 23.16 ', '116.36');
 insert into addrtab values (  '潮州 ', ' 23.40 ', '116.38');
 insert into addrtab values (  '澄海 ', ' 23.28 ', '116.46');
 insert into addrtab values (  '从化 ', ' 23.33 ', '113.33');
 insert into addrtab values (  '东莞 ', ' 23.02 ', '113.45');
 insert into addrtab values (  '恩平 ', ' 22.12 ', '112.19');
 insert into addrtab values (  '佛山 ', ' 23.02 ', '113.06');
 insert into addrtab values (  '高明 ', ' 22.53 ', '112.50');
 insert into addrtab values (  '高要 ', ' 23.02 ', '112.26');
 insert into addrtab values (  '高州 ', ' 21.54 ', '110.50');
 insert into addrtab values (  '鹤山 ', ' 22.46 ', '112.57');
 insert into addrtab values (  '河源 ', ' 23.43 ', '114.41');
 insert into addrtab values (  '花都 ', ' 23.23 ', '113.12');
 insert into addrtab values (  '化州 ', ' 21.39 ', '110.37');
 insert into addrtab values (  '惠阳 ', ' 22.48 ', '114.28');
 insert into addrtab values (  '惠州 ', ' 23.05 ', '114.22');
 insert into addrtab values (  '江门 ', ' 22.35 ', '113.04');
 insert into addrtab values (  '揭阳 ', ' 22.32 ', '116.21');
 insert into addrtab values (  '开平 ', ' 22.22 ', '112.40');
 insert into addrtab values (  '乐昌 ', ' 25.09 ', '113.21');
 insert into addrtab values ( '雷州 ', ' 20.54 ', '110.04');
 insert into addrtab values (  '廉江 ', ' 21.37 ', '110.17');
 insert into addrtab values (  '连州 ', ' 24.48 ', '112.23');
 insert into addrtab values (  '罗定 ', ' 22.46 ', '111.33');
 insert into addrtab values (  '茂名 ', ' 21.40 ', '110.53');
 insert into addrtab values (  '梅州 ', ' 24.19 ', '116.07');
 insert into addrtab values (  '南海 ', ' 23.01 ', '113.09');
 insert into addrtab values (  '番禺 ', ' 22.57 ', '113.22');
 insert into addrtab values (  '普宁 ', ' 23.18 ', '116.10');
 insert into addrtab values (  '清远 ', ' 23.42 ', '113.01');
 insert into addrtab values (  '三水 ', ' 23.10 ', '112.52');
 insert into addrtab values (  '汕头 ', ' 23.22 ', '116.41');
 insert into addrtab values (  '汕尾 ', ' 22.47 ', '115.21');
 insert into addrtab values (  '韶关 ', ' 24.48 ', '113.37');
 insert into addrtab values (  '深圳 ', ' 22.33 ', '114.07');
 insert into addrtab values (  '顺德 ', ' 22.50 ', '113.15');
 insert into addrtab values (  '四会 ', ' 23.21 ', '112.41');
 insert into addrtab values (  '台山 ', ' 22.15 ', '112.48');
 insert into addrtab values (  '吴川 ', ' 21.26 ', '110.47');
 insert into addrtab values (  '新会 ', ' 22.32 ', '113.01');
 insert into addrtab values (  '兴宁 ', ' 24.09 ', '115.43');
 insert into addrtab values (  '阳春 ', ' 22.10 ', '111.48');
 insert into addrtab values (  '阳江 ', ' 21.50 ', '111.58');
 insert into addrtab values (  '英德 ', ' 24.10 ', '113.22');
 insert into addrtab values (  '云浮 ', ' 22.57 ', '112.02');
 insert into addrtab values (  '增城 ', ' 23.18 ', '113.49');
 insert into addrtab values (  '湛江 ', ' 21.11 ', '110.24');
 insert into addrtab values ( ' 肇庆 ', ' 23.03 ', '112.27');
 insert into addrtab values ( ' 中山 ', ' 22.31 ', '113.22');
 insert into addrtab values ( ' 珠海 ', ' 22.17 ', '113.34');
 insert into addrtab values ( ' 南宁 ', ' 22.48 ', '108.19');
 insert into addrtab values ( ' 北海 ', ' 21.28 ', '109.07');
 insert into addrtab values ( ' 北流 ', ' 22.42 ', '110.21');
 insert into addrtab values ( ' 百色 ', ' 23.54 ', '106.36');
 insert into addrtab values ( ' 防城港', '  21.37 ', '108.20');
 insert into addrtab values ( ' 贵港 ', ' 23.06 ', '109.36');
 insert into addrtab values ( ' 桂林 ', ' 25.17 ', '110.17');
 insert into addrtab values ( ' 桂平 ', ' 23.22 ', '110.04');
 insert into addrtab values ( ' 河池 ', ' 24.42 ', '108.03');
 insert into addrtab values ( ' 合山 ', ' 23.47 ', '108.52');
 insert into addrtab values ( ' 柳州 ', ' 23.19 ', '109.24');
 insert into addrtab values ( ' 赁祥 ', ' 22.07 ', '106.44');
 insert into addrtab values ( ' 钦州 ', ' 21.57 ', '108.37');
 insert into addrtab values ( ' 梧州 ', ' 23.29 ', '111.20');
 insert into addrtab values ( ' 玉林 ', ' 22.38 ', '110.09');
 insert into addrtab values ( ' 宜州 ', ' 24.28 ', '108.40');
 insert into addrtab values ( ' 贵阳 ', ' 26.35 ', '106.42');
 insert into addrtab values ( ' 安顺 ', ' 26.14 ', '105.55');
 insert into addrtab values ( ' 毕节 ', ' 27.18 ', '105.18');
 insert into addrtab values ( ' 赤水 ', ' 28.34 ', '105.42');
 insert into addrtab values ( ' 都匀 ', ' 26.15 ', '107.31');
 insert into addrtab values ( ' 凯里 ', ' 26.35 ', '107.58');
 insert into addrtab values ( ' 六盘水', '  26.35 ', '104.50');
 insert into addrtab values ( ' 清镇 ', ' 26.33 ', '106.27');
 insert into addrtab values ( ' 铜仁 ', ' 27.43 ', '109.12');
 insert into addrtab values ( ' 兴义 ', ' 25.05 ', '104.53');
 insert into addrtab values ( ' 遵义 ', ' 27.42 ', '106.55');
 insert into addrtab values ( ' 海口 ', ' 20.02 ', '110.20');
 insert into addrtab values ( ' 儋州 ', ' 19.31 ', '109.34');
 insert into addrtab values ( ' 琼海 ', ' 19.14 ', '110.28');
 insert into addrtab values ( ' 琼山 ', ' 19.59 ', '110.21');
 insert into addrtab values ( ' 三亚 ', ' 18.14 ', '109.31');
 insert into addrtab values ( ' 通什 ', ' 18.46 ', '109.31');
 insert into addrtab values ( ' 石家庄', ' 38.02 ', '114.30');
 insert into addrtab values ( ' 安国 ', ' 38.24 ', '115.20');
 insert into addrtab values ( ' 保定 ', ' 38.51 ', '115.30');
 insert into addrtab values ( ' 霸州 ', ' 39.06 ', '116.24');
 insert into addrtab values ( ' 泊头 ', ' 38.04 ', '116.34');
 insert into addrtab values ( ' 沧州 ', ' 38.18 ', '116.52');
 insert into addrtab values ( ' 承德 ', ' 40.59 ', '117.57');
 insert into addrtab values ( ' 定州 ', ' 38.30 ', '115.00');
 insert into addrtab values ( ' 丰南 ', ' 39.34 ', '118.06');
 insert into addrtab values ( ' 高碑店', ' 39.20 ', '115.51');
 insert into addrtab values ( ' 蒿城 ', ' 38.02 ', '114.50');
 insert into addrtab values ( ' 邯郸 ', ' 36.36 ', '114.28');
 insert into addrtab values ( ' 河间 ', ' 38.26 ', '116.05');
 insert into addrtab values ( ' 衡水 ', ' 37.44 ', '115.42');
 insert into addrtab values ( ' 黄骅 ', ' 38.21 ', '117.21');
 insert into addrtab values ( ' 晋州 ', ' 38.02 ', '115.02');
 insert into addrtab values ( ' 冀州 ', ' 37.34 ', '115.33');
 insert into addrtab values ( ' 廓坊 ', ' 39.31 ', '116.42');
 insert into addrtab values ( ' 鹿泉 ', ' 38.04 ', '114.19');
 insert into addrtab values ( ' 南宫 ', ' 37.22 ', '115.23');
 insert into addrtab values ( ' 秦皇岛 ', ' 39.55 ', '119.35');
 insert into addrtab values ( ' 任丘 ', ' 38.42 ', '116.07');
 insert into addrtab values ( ' 三河 ', ' 39.58 ', '117.04');
 insert into addrtab values ( ' 沙河 ', ' 36.51 ', '114.30');
 insert into addrtab values ( ' 深州 ', ' 38.01 ', '115.32');
 insert into addrtab values ( ' 唐山 ', ' 39.36 ', '118.11');
 insert into addrtab values ( ' 武安 ', ' 36.42 ', '114.11');
 insert into addrtab values ( ' 邢台 ', ' 37.04 ', '114.30');
 insert into addrtab values ( ' 辛集 ', ' 37.54 ', '115.12');
 insert into addrtab values ( ' 新乐 ', ' 38.20 ', '114.41');
 insert into addrtab values ( ' 张家口 ', ' 40.48 ', '114.53');
 insert into addrtab values ( ' 涿州 ', ' 39.29 ', '115.59');
 insert into addrtab values ( ' 遵化 ', ' 40.11 ', '117.58');
 insert into addrtab values ( ' 郑州 ', ' 34.46 ', '11340');
 insert into addrtab values ( ' 安阳 ', ' 36.06 ', '114.21');
 insert into addrtab values ( ' 长葛 ', ' 34.12 ', '113.47');
 insert into addrtab values ( ' 登封 ', ' 34.27 ', '113.02');
 insert into addrtab values ( ' 邓州 ', ' 32.42 ', '112.05');
 insert into addrtab values ( ' 巩义 ', ' 34.46 ', '112.58');
 insert into addrtab values ( ' 鹤壁 ', ' 35.54 ', '114.11');
 insert into addrtab values ( ' 辉县 ', ' 35.27 ', '113.47');
 insert into addrtab values ( ' 焦作 ', ' 35.14 ', '113.12');
 insert into addrtab values ( ' 济源 ', ' 35.04 ', '112.35');
 insert into addrtab values ( ' 开封 ', ' 34.47 ', '114.21');
 insert into addrtab values ( ' 灵宝 ', ' 34.31 ', '110.52');
 insert into addrtab values ( ' 林州 ', ' 36.03 ', '113.49');
 insert into addrtab values ( ' 漯河 ', ' 33.33 ', '114.02');
 insert into addrtab values ( ' 洛阳 ', ' 34.41 ', '112.27');
 insert into addrtab values ( ' 南阳 ', ' 33.00 ', '112.32');
 insert into addrtab values ( ' 平顶山', ' 33.44 ', '113.17');
 insert into addrtab values ( ' 濮阳 ', ' 35.44 ', '115.01');
 insert into addrtab values ( ' 沁阳 ', ' 35.05 ', '112.57');
 insert into addrtab values ( ' 汝州 ', ' 34.09 ', '112.50');
 insert into addrtab values ( ' 三门峡 ', ' 34.47 ', '111.12');
 insert into addrtab values ( ' 商丘 ', ' 34.26 ', '115.38');
 insert into addrtab values ( ' 卫辉 ', ' 35.24 ', '114.03');
 insert into addrtab values ( ' 舞钢 ', ' 33.17 ', '113.30');
 insert into addrtab values ( ' 项城 ', ' 33.26 ', '114.54');
 insert into addrtab values ( ' 荥阳 ', ' 34.46 ', '113.21');
 insert into addrtab values ( ' 新密 ', ' 34.31 ', '113.22');
 insert into addrtab values ( ' 新乡 ', ' 35.18 ', '113.52');
 insert into addrtab values ( ' 信阳 ', ' 32.07 ', '114.04');
 insert into addrtab values ( ' 新郑 ', ' 34.24 ', '113.43');
 insert into addrtab values ( ' 许昌 ', ' 34.01 ', '113.49');
 insert into addrtab values ( ' 偃师 ', ' 34.43 ', '112.47');