addrtab.sql

计算卫星天线角度

 insert into addrtab values ( ' 义马 ', ' 34.43 ', '111.55');
 insert into addrtab values ( ' 禹州 ', ' 34.09 ', '113.28');
 insert into addrtab values ( ' 周口 ', ' 33.37 ', '114.38');
 insert into addrtab values ( ' 驻马店 ', ' 32.58 ', '114.01');
 insert into addrtab values ( ' 哈尔滨 ', ' 45.44 ', '126.36');
 insert into addrtab values ( ' 阿城 ', ' 45.32 ', '126.58');
 insert into addrtab values ( ' 安达 ', ' 46.24 ', '125.18');
 insert into addrtab values ( ' 北安 ', ' 48.15 ', '126.31');
 insert into addrtab values ( ' 大庆 ', ' 46.36 ', '125.01');
 insert into addrtab values ( ' 富锦 ', ' 47.15 ', '132.02');
 insert into addrtab values ( ' 海林 ', ' 44.35 ', '129.21');
 insert into addrtab values ( ' 海伦 ', ' 47.28 ', '126.57');
 insert into addrtab values ( ' 鹤岗 ', ' 47.20 ', '130.16');
 insert into addrtab values ( ' 黑河 ', ' 50.14 ', '127.29');
 insert into addrtab values ( ' 佳木斯 ', ' 46.47 ', '130.22');
 insert into addrtab values ( ' 鸡西 ', ' 45.17 ', '130.57');
 insert into addrtab values ( ' 密山 ', ' 45.32 ', '131.50');
 insert into addrtab values ( ' 牡丹江 ', ' 44.35 ', '129.36');
 insert into addrtab values ( ' 讷河 ', ' 48.29 ', '124.51');
 insert into addrtab values ( ' 宁安 ', ' 44.21 ', '129.28');
 insert into addrtab values ( ' 齐齐哈尔 ', ' 47.20 ', '123.57');
 insert into addrtab values ( ' 七台河 ', ' 45.48 ', '130.49');
 insert into addrtab values ( ' 双城 ', ' 45.22 ', '126.15');
 insert into addrtab values ( ' 尚志 ', ' 45.14 ', '127.55');
 insert into addrtab values ( ' 双鸭山 ', ' 46.38 ', '131.11');
 insert into addrtab values ( ' 绥芬河 ', ' 44.25 ', '131.11');
 insert into addrtab values ( ' 绥化 ', ' 46.38 ', '126.59');
 insert into addrtab values ( ' 铁力 ', ' 46.59 ', '128.01');
 insert into addrtab values ( ' 同江 ', ' 47.39 ', '132.30');
 insert into addrtab values ( ' 五常 ', ' 44.55 ', '127.11');
 insert into addrtab values ( ' 五大连池 ', ' 48.38 ', '126.07');
 insert into addrtab values ( ' 伊春 ', ' 47.42 ', '128.56');
 insert into addrtab values ( ' 肇东 ', ' 46.04 ', '125.58');
 insert into addrtab values ( ' 武汉 ', ' 30.35 ', '114.17');
 insert into addrtab values ( ' 安陆 ', ' 31.15 ', '113.41');
 insert into addrtab values ( ' 当阳 ', ' 30.50 ', '111.47');
 insert into addrtab values ( ' 丹江口 ', ' 32.33 ', '108.30');
 insert into addrtab values ( ' 大冶 ', ' 30.06 ', '114.58');
 insert into addrtab values ( ' 恩施 ', ' 30.16 ', '109.29');
 insert into addrtab values ( ' 鄂州 ', ' 30.23 ', '114.52');
 insert into addrtab values ( ' 广水 ', ' 31.37 ', '113.48');
 insert into addrtab values ( ' 洪湖 ', ' 29.48 ', '113.27');
 insert into addrtab values ( ' 黄石 ', ' 30.12 ', '115.06');
 insert into addrtab values ( ' 黄州 ', ' 30.27 ', '114.52');
 insert into addrtab values ( ' 荆门 ', ' 31.02 ', '112.12');
 insert into addrtab values ( ' 荆沙 ', ' 30.18 ', '112.16');
 insert into addrtab values ( ' 老河口 ', ' 32.23 ', '111.40');
 insert into addrtab values ( ' 利川 ', ' 30.18 ', '108.56');
 insert into addrtab values ( ' 麻城 ', ' 31.10 ', '115.01');
 insert into addrtab values ( ' 浦圻 ', ' 29.42 ', '113.51');
 insert into addrtab values ( ' 潜江 ', ' 30.26 ', '112.53');
 insert into addrtab values ( ' 石首 ', ' 29.43 ', '112.24');
 insert into addrtab values ( ' 十堰 ', ' 32.40 ', '110.47');
 insert into addrtab values ( ' 随州 ', ' 31.42 ', '113.22');
 insert into addrtab values ( ' 天门 ', ' 60.39 ', '113.10');
 insert into addrtab values ( ' 武穴 ', ' 29.51 ', '115.33');
 insert into addrtab values ( ' 襄樊 ', ' 32.02 ', '112.08');
 insert into addrtab values ( ' 咸宁 ', ' 29.53 ', '114.17');
 insert into addrtab values ( ' 仙桃 ', ' 30.22 ', '113.27');
 insert into addrtab values ( ' 孝感 ', ' 30.56 ', '113.54');
 insert into addrtab values ( ' 宜昌 ', ' 30.42 ', '111.17');
 insert into addrtab values ( ' 宜城 ', ' 31.42 ', '112.15');
 insert into addrtab values ( ' 应城 ', ' 30.57 ', '113.33');
 insert into addrtab values ( ' 枣阳 ', ' 32.07 ', '112.44');
 insert into addrtab values ( ' 枝城 ', ' 30.23 ', '111.27');
 insert into addrtab values ( ' 钟祥 ', ' 31.10 ', '112.34');
 insert into addrtab values ( ' 长沙 ', ' 28.12 ', '112.59');
 insert into addrtab values ( ' 常德 ', ' 29.02 ', '111.51');
 insert into addrtab values ( ' 郴州 ', ' 25.46 ', '113.02');
 insert into addrtab values ( ' 衡阳 ', ' 26.53 ', '112.37');
 insert into addrtab values ( ' 洪江 ', ' 27.07 ', '109.59');
 insert into addrtab values ( ' 怀化 ', ' 27.33 ', '109.58');
 insert into addrtab values ( ' 津市 ', ' 29.38 ', '111.52');
 insert into addrtab values ( ' 吉首 ', ' 28.18 ', '109.43');
 insert into addrtab values ( ' 耒阳 ', ' 26.24 ', '112.51');
 insert into addrtab values ( ' 冷水江 ', ' 27.42 ', '111.26');
 insert into addrtab values ( ' 冷水滩 ', ' 26.26 ', '111.35');
 insert into addrtab values ( ' 涟源 ', ' 27.41 ', '111.41');
 insert into addrtab values ( ' 醴陵 ', ' 27.40 ', '113.30');
 insert into addrtab values ( ' 临湘 ', ' 29.29 ', '113.27');
 insert into addrtab values ( ' 浏阳 ', ' 28.09 ', '113.37');
 insert into addrtab values ( ' 娄底 ', ' 27.44 ', '111.59');
 insert into addrtab values ( ' 汨罗 ', ' 28.49 ', '113.03');
 insert into addrtab values ( ' 韶山 ', ' 27.54 ', '112.29');
 insert into addrtab values ( ' 邵阳 ', ' 27.14 ', '111.28');
 insert into addrtab values ( ' 武冈 ', ' 26.43 ', '110.37');
 insert into addrtab values ( ' 湘潭 ', ' 27.52 ', '112.53');
 insert into addrtab values ( ' 湘乡 ', ' 27.44 ', '112.31');
 insert into addrtab values ( ' 益阳 ', ' 28.36 ', '112.20');
 insert into addrtab values ( ' 永州 ', ' 26.13 ', '111.37');
 insert into addrtab values ( ' 沅江 ', ' 28.50 ', '112.22');
 insert into addrtab values ( ' 岳阳 ', ' 29.22 ', '113.06');
 insert into addrtab values ( ' 张家界 ', ' 29.08 ', '110.29');
 
 insert into addrtab values ( ' 株洲 ', ' 27.51 ', '113.09');
 insert into addrtab values ( ' 资兴 ', ' 25.58 ', '113.13');
 insert into addrtab values ( ' 长春 ', ' 43.54 ', '125.19');
 insert into addrtab values ( ' 白城 ', ' 45.38 ', '122.50');
 insert into addrtab values ( ' 白山 ', ' 41.56 ', '126.26');
 insert into addrtab values ( ' 大安 ', ' 45.30 ', '124.18');
 insert into addrtab values ( ' 德惠 ', ' 44.32 ', '125.42');
 insert into addrtab values ( ' 敦化 ', ' 43.22 ', '128.13');
 insert into addrtab values ( ' 公主岭 ', ' 43.31 ', '124.49');
 insert into addrtab values ( ' 和龙 ', ' 42.32 ', '129.00');
 insert into addrtab values ( ' 桦甸 ', ' 42.58 ', '126.44');
 insert into addrtab values ( ' 珲春 ', ' 42.52 ', '130.22');
 insert into addrtab values ( ' 集安 ', ' 41.08 ', '126.11');
 insert into addrtab values ( ' 蛟河 ', ' 43.42 ', '127.21');
 insert into addrtab values ( '吉林' , '43.52', '126.33');
 insert into addrtab values ( ' 九台 ', ' 44.09 ', '125.51');
 insert into addrtab values ( ' 辽源 ', ' 42.54 ', '125.09');
 insert into addrtab values ( ' 临江 ', ' 41.49 ', '126.53');
 insert into addrtab values ( ' 龙井 ', ' 42.46 ', '129.26');
 insert into addrtab values ( ' 梅河口 ', ' 42.32 ', '125.40');
 insert into addrtab values ( ' 舒兰 ', ' 44.24 ', '126.57');
 insert into addrtab values ( ' 四平 ', ' 43.10 ', '124.22');
 insert into addrtab values ( ' 松原 ', ' 45.11 ', '124.49');
 insert into addrtab values ( ' 洮南 ', ' 45.20 ', '122.47');
 insert into addrtab values ( ' 通化 ', ' 41.43 ', '125.56');
 insert into addrtab values ( ' 图们 ', ' 42.57 ', '129.51');
 insert into addrtab values ( ' 延吉 ', ' 42.54 ', '129.30');
 insert into addrtab values ( ' 愉树 ', ' 44.49 ', '126.32');
 insert into addrtab values ( ' 南京 ', ' 32.03 ', '118.46');
 insert into addrtab values ( ' 常熟 ', ' 31.39 ', '120.43');
 insert into addrtab values ( ' 常州 ', ' 31.47 ', '119.58');
 insert into addrtab values ( ' 丹阳 ', ' 32.00 ', '119.32');
 insert into addrtab values ( ' 东台 ', ' 32.51 ', '120.19');
 insert into addrtab values ( ' 高邮 ', ' 32.47 ', '119.27');
 insert into addrtab values ( ' 海门 ', ' 31.53 ', '121.09');
 insert into addrtab values ( ' 淮安 ', ' 33.30 ', '119.09');
 insert into addrtab values ( ' 淮阴 ', ' 33.36 ', '119.02');
 insert into addrtab values ( ' 江都 ', ' 32.26 ', '119.32');
 insert into addrtab values ( ' 姜堰 ', ' 32.34 ', '120.08');
 insert into addrtab values ( ' 江阴 ', ' 31.54 ', '120.17');
 insert into addrtab values ( ' 靖江 ', ' 32.02 ', '120.17');
 insert into addrtab values ( ' 金坛 ', ' 31.46 ', '119.33');
 insert into addrtab values ( ' 昆山 ', ' 31.23 ', '120.57');
 insert into addrtab values ( ' 连去港 ', ' 34.36 ', '119.10');
 insert into addrtab values ( ' 溧阳 ', ' 31.26 ', '119.29');
 insert into addrtab values ( ' 南通 ', ' 32.01 ', '120.51');
 insert into addrtab values ( ' 邳州 ', ' 34.19 ', '117.59');
 insert into addrtab values ( ' 启乐 ', ' 31.48 ', '121.39');
 insert into addrtab values ( ' 如皋 ', ' 32.23 ', '120.33');
 insert into addrtab values ( ' 宿迁 ', ' 33.58 ', '118.18');
 insert into addrtab values ( ' 苏州 ', ' 31.19 ', '120.37');
 insert into addrtab values ( ' 太仓 ', ' 31.27 ', '121.06');
 insert into addrtab values ( ' 泰兴 ', ' 32.10 ', '120.01');
 insert into addrtab values ( ' 泰州 ', ' 32.30 ', '119.54');
 insert into addrtab values ( ' 通州 ', ' 32.05 ', '121.03');
 insert into addrtab values ( ' 吴江 ', ' 31.10 ', '120.39');
 insert into addrtab values ( ' 无锡 ', ' 31.34 ', '120.18');
 insert into addrtab values ( ' 兴化 ', ' 32.56 ', '119.50');
 insert into addrtab values ( ' 新沂 ', ' 34.22 ', '118.20');
 insert into addrtab values ( ' 徐州 ', ' 34.15 ', '117.11');
 insert into addrtab values ( ' 盐在 ', ' 33.22 ', '120.08');
 insert into addrtab values ( ' 扬中 ', ' 32.14 ', '119.49');
 insert into addrtab values ( ' 扬州 ', ' 32.23 ', '119.26');
 insert into addrtab values ( ' 宜兴 ', ' 31.21 ', '119.49');
 insert into addrtab values ( ' 仪征 ', ' 32.16 ', '119.10');
 insert into addrtab values ( ' 张家港 ', ' 31.52 ', '120.32');
 insert into addrtab values ( ' 镇江 ', ' 32.11 ', '119.27');
 insert into addrtab values ( ' 南昌 ', ' 28.40 ', '115.55');
 insert into addrtab values ( ' 德兴 ', ' 28.57 ', '117.35');
 insert into addrtab values ( ' 丰城 ', ' 28.12 ', '115.48');
 insert into addrtab values ( ' 赣州 ', ' 28.52 ', '114.56');
 insert into addrtab values ( ' 高安 ', ' 28.25 ', '115.22');
 insert into addrtab values ( ' 吉安 ', ' 27.07 ', '114.58');
 insert into addrtab values ( ' 景德镇 ', ' 29.17 ', '117.13');
 insert into addrtab values ( ' 井冈山 ', ' 26.34 ', '114.10');
 insert into addrtab values ( ' 九江 ', ' 29.43 ', '115.58');
 insert into addrtab values ( ' 乐平 ', ' 28.58 ', '117.08');
 insert into addrtab values ( ' 临川 ', ' 27.59 ', '116.21');
 insert into addrtab values ( ' 萍乡 ', ' 27.37 ', '113.50');
 insert into addrtab values ( ' 瑞昌 ', ' 29.40 ', '115.38');
 insert into addrtab values ( ' 瑞金 ', ' 25.53 ', '116.01');
 insert into addrtab values ( ' 上饶 ', ' 25.27 ', '117.58');
 insert into addrtab values ( ' 新余 ', ' 27.48 ', '114.56');
 insert into addrtab values ( ' 宜春 ', ' 27.47 ', '114.23');
 insert into addrtab values ( ' 鹰潭 ', ' 28.14 ', '117.03');
 insert into addrtab values ( ' 樟树 ', ' 28.03 ', '115.32');
 insert into addrtab values ( ' 沈阳 ', ' 41.48 ', '123.25');
 insert into addrtab values ( ' 鞍山 ', ' 41.07 ', '123.00');
 insert into addrtab values ( ' 北票 ', ' 41.48 ', '120.47');
 insert into addrtab values ( ' 本溪 ', ' 41.18 ', '123.46');
 insert into addrtab values ( ' 朝阳 ', ' 41.34 ', '120.27');
 insert into addrtab values ( ' 大连 ', ' 38.55 ', '121.36');
 insert into addrtab values ( ' 丹东 ', ' 40.08 ', '124.22');
 insert into addrtab values ( ' 大石桥 ', ' 40.37 ', '122.31');
 insert into addrtab values ( ' 东港 ', ' 39.53 ', '124.08');
 insert into addrtab values ( ' 凤城 ', ' 40.28 ', '124.02');
 insert into addrtab values ( ' 抚顺 ', ' 41.51 ', '123.54');
 insert into addrtab values ( ' 阜新 ', ' 42.01 ', '121.39');
 insert into addrtab values ( ' 盖州 ', ' 40.24 ', '122.21');
 insert into addrtab values ( ' 海城 ', ' 40.51 ', '122.43');
 insert into addrtab values ( ' 葫芦岛 ', ' 40.45 ', '120.51');
 insert into addrtab values ( ' 锦州 ', ' 41.07 ', '121.09');
 insert into addrtab values ( ' 开原 ', ' 42.32 ', '124.02');
 insert into addrtab values ( ' 辽阳 ', ' 41.16 ', '123.12');
 insert into addrtab values ( ' 凌海 ', ' 41.10 ', '121.21');
 insert into addrtab values ( ' 凌源 ', ' 41.14 ', '119.22');
 insert into addrtab values ( ' 盘锦 ', ' 41.07 ', '122.03');
 insert into addrtab values ( ' 普兰店 ', ' 39.23 ', '121.58');
 insert into addrtab values ( ' 铁法 ', ' 42.28 ', '123.32');
 insert into addrtab values ( ' 铁岭 ', ' 42.18 ', '123.51');
 insert into addrtab values ( ' 瓦房店 ', ' 39.37 ', '122.00');
 insert into addrtab values ( ' 兴城 ', ' 40.37 ', '120.41');
 insert into addrtab values ( ' 新民 ', ' 41.59 ', '122.49');
 insert into addrtab values ( ' 营口 ', ' 40.39 ', '122.13');
 insert into addrtab values ( ' 庄河 ', ' 39.41 ', '122.58');
 insert into addrtab values ( ' 呼和浩特 ', ' 40.48 ', '111.41');
 insert into addrtab values ( ' 包头 ', ' 40.39 ', '109.49');