addrtab.sql

计算卫星天线角度

 insert into addrtab values ( ' 赤峰 ', ' 42.17 ', '118.58');
 insert into addrtab values ( ' 东胜 ', ' 39.48 ', '109.59');
 insert into addrtab values ( ' 二连浩特 ', ' 43.38 ', '111.58');
 insert into addrtab values ( ' 额尔古纳 ', ' 50.13 ', '120.11');
 insert into addrtab values ( ' 丰镇 ', ' 40.27 ', '113.09');
 insert into addrtab values ( ' 根河 ', ' 50.48 ', '121.29');
 insert into addrtab values ( ' 海拉尔 ', ' 49.12 ', '119.39');
 insert into addrtab values ( ' 霍林郭勒 ', ' 45.32 ', '119.38');
 insert into addrtab values ( ' 集宁 ', ' 41.02 ', '113.06');
 insert into addrtab values ( ' 临河 ', ' 40.46 ', '107.22');
 insert into addrtab values ( ' 满洲里 ', ' 49.35 ', '117.23');
 insert into addrtab values ( ' 通辽 ', ' 43.37 ', '122.16');
 insert into addrtab values ( ' 乌兰浩特 ', ' 46.03 ', '122.03');
 insert into addrtab values ( ' 乌海 ', ' 39.40 ', '106.48');
 insert into addrtab values ( ' 锡林浩特 ', ' 43.57 ', '116.03');
 insert into addrtab values ( ' 牙克石 ', ' 49.17 ', '120.40');
 insert into addrtab values ( ' 扎兰屯 ', ' 48.00 ', '122.47');
 insert into addrtab values ( ' 银川 ', ' 38.27 ', '106.16');
 insert into addrtab values ( ' 青铜峡 ', ' 37.56 ', '105.59');
 insert into addrtab values ( ' 石嘴山 ', ' 39.02 ', '106.22');
 insert into addrtab values ( ' 吴忠 ', ' 37.59 ', '106.11');
 insert into addrtab values ( ' 西宁 ', ' 36.38 ', '101.48');
 insert into addrtab values ( ' 德令哈 ', ' 37.22 ', '97.23');
 insert into addrtab values ( ' 格尔木 ', ' 36.26 ', '94.55');
 insert into addrtab values ( ' 济南 ', ' 36.40 ', '117.00');
 insert into addrtab values ( ' 安丘 ', ' 36.25 ', '119.12');
 insert into addrtab values ( ' 滨州 ', ' 37.22 ', '118.02');
 insert into addrtab values ( ' 昌邑 ', ' 39.52 ', '119.24');
 insert into addrtab values ( ' 德州 ', ' 37.26 ', '116.17');
 insert into addrtab values ( ' 东营 ', ' 37.27 ', '118.30');
 insert into addrtab values ( ' 肥城 ', ' 36.14 ', '116.46');
 insert into addrtab values ( ' 高密 ', ' 36.22 ', '119.44');
 insert into addrtab values ( ' 菏泽 ', ' 35.14 ', '115.26');
 insert into addrtab values ( ' 胶南 ', ' 35.53 ', '119.58');
 insert into addrtab values ( ' 胶州 ', ' 36.17 ', '120.00');
 insert into addrtab values ( ' 即墨 ', ' 36.22 ', '120.28');
 insert into addrtab values ( ' 济宁 ', ' 35.23 ', '116.33');
 insert into addrtab values ( ' 莱芜 ', ' 36.12 ', '117.40');
 insert into addrtab values ( ' 莱西 ', ' 36.52 ', '120.31');
 insert into addrtab values ( ' 莱阳 ', ' 36.58 ', '120.42');
 insert into addrtab values ( ' 莱州 ', ' 37.10 ', '119.57');
 insert into addrtab values ( ' 乐陵 ', ' 37.44 ', '117.12');
 insert into addrtab values ( ' 聊城 ', ' 36.26 ', '115.57');
 insert into addrtab values ( ' 临清 ', ' 36.51 ', '115.42');
 insert into addrtab values ( ' 临沂 ', ' 35.03 ', '118.20');
 insert into addrtab values ( ' 龙口 ', ' 37.39 ', '120.21');
 insert into addrtab values ( ' 蓬莱 ', ' 37.48 ', '120.45');
 insert into addrtab values ( ' 平度 ', ' 36.47 ', '119.58');
 insert into addrtab values ( ' 青岛 ', ' 36.03 ', '120.18');
 insert into addrtab values ( ' 青州 ', ' 36.42 ', '118.28');
 insert into addrtab values ( ' 曲阜 ', ' 35.36 ', '116.58');
 insert into addrtab values ( ' 日照 ', ' 35.23 ', '119.32');
 insert into addrtab values ( ' 荣成 ', ' 37.10 ', '122.25');
 insert into addrtab values ( ' 乳山 ', ' 36.54 ', '121.31');
 insert into addrtab values ( ' 寿光 ', ' 36.53 ', '118.44');
 insert into addrtab values ( ' 泰安 ', ' 36.11 ', '117.08');
 insert into addrtab values ( ' 滕州 ', ' 35.06 ', '117.09');
 insert into addrtab values ( ' 潍坊 ', ' 36.43 ', '119.06');
 insert into addrtab values ( ' 威海 ', ' 37.31 ', '122.07');
 insert into addrtab values ( ' 文登 ', ' 37.12 ', '122.03');
 insert into addrtab values ( ' 新泰 ', ' 35.54 ', '117.45');
 insert into addrtab values ( ' 烟台 ', ' 37.32 ', '121.24');
 insert into addrtab values ( ' 兖州 ', ' 35.32 ', '116.49');
 insert into addrtab values ( ' 禹城 ', ' 36.56 ', '116.39');
 insert into addrtab values ( ' 枣庄 ', ' 34.52 ', '117.33');
 insert into addrtab values ( ' 章丘 ', ' 36.43 ', '117.32');
 insert into addrtab values ( ' 招远 ', ' 37.21 ', '120.23');
 insert into addrtab values ( ' 诸城 ', ' 35.59 ', '119.24');
 insert into addrtab values ( ' 淄博 ', ' 36.48 ', '118.03');
 insert into addrtab values ( ' 邹城 ', ' 35.24 ', '116.58');
 insert into addrtab values ( ' 太原 ', ' 37.54 ', '112.33');
 insert into addrtab values ( ' 长治 ', ' 36.11 ', '113.06');
 insert into addrtab values ( ' 大同 ', ' 40.06 ', '113.17');
 insert into addrtab values ( ' 高平 ', ' 35.48 ', '112.55');
 insert into addrtab values ( ' 古交 ', ' 37.54 ', '112.09');
 insert into addrtab values ( ' 河津 ', ' 35.35 ', '110.41');
 insert into addrtab values ( ' 侯马 ', ' 35.37 ', '111.21');
 insert into addrtab values ( ' 霍州 ', ' 36.34 ', '111.42');
 insert into addrtab values ( ' 介休 ', ' 37.02 ', '111.55');
 insert into addrtab values ( ' 晋城 ', ' 35.30 ', '112.51');
 insert into addrtab values ( ' 临汾 ', ' 36.05 ', '111.31');
 insert into addrtab values ( ' 潞城 ', ' 36.21 ', '113.14');
 insert into addrtab values ( ' 朔州 ', ' 39.19 ', '112.26');
 insert into addrtab values ( ' 孝义 ', ' 37.08 ', '111.48');
 insert into addrtab values ( ' 忻州 ', ' 38.24 ', '112.43');
 insert into addrtab values ( ' 阳泉 ', ' 37.51 ', '113.34');
 insert into addrtab values ( ' 永济 ', ' 34.52 ', '110.27');
 insert into addrtab values ( ' 原平 ', ' 38.43 ', '112.42');
 insert into addrtab values ( ' 榆次 ', ' 37.41 ', '112.43');
 insert into addrtab values ( ' 运城 ', ' 35.02 ', '110.59');
 insert into addrtab values ( ' 西安 ', ' 34.17 ', '108.57');
 insert into addrtab values ( ' 安康 ', ' 32.41 ', '109.01');
 insert into addrtab values ( ' 宝鸡 ', ' 34.22 ', '107.09');
 insert into addrtab values ( ' 韩城 ', ' 35.28 ', '110.27');
 insert into addrtab values ( ' 汉中 ', ' 33.04 ', '107.01');
 insert into addrtab values ( ' 华阴 ', ' 34.34 ', '110.05');
 insert into addrtab values ( ' 商州 ', ' 33.52 ', '109.57');
 insert into addrtab values ( ' 铜川 ', ' 35.06 ', '109.07');
 insert into addrtab values ( ' 渭南 ', ' 34.30 ', '109.30');
 insert into addrtab values ( ' 咸阳 ', ' 34.20 ', '108.43');
 insert into addrtab values ( ' 兴平 ', ' 34.18 ', '108.29');
 insert into addrtab values ( ' 延安 ', ' 36.35 ', '109.28');
 insert into addrtab values ( ' 榆林 ', ' 38.18 ', '109.47');
 insert into addrtab values ( ' 上海 ', ' 31.14 ', '121.29');
 insert into addrtab values ( ' 成都 ', ' 30.40 ', '104.04');
 insert into addrtab values ( ' 巴中 ', ' 31.51 ', '106.43');
 insert into addrtab values ( ' 崇州 ', ' 30.39 ', '103.40');
 insert into addrtab values ( ' 达川 ', ' 31.14 ', '107.29');
 insert into addrtab values ( ' 德阳 ', ' 31.09 ', '104.22');
 insert into addrtab values ( ' 都江堰 ', ' 31.01 ', '103.37');
 insert into addrtab values ( ' 峨眉山 ', ' 29.36 ', '103.29');
 insert into addrtab values ( ' 涪陵 ', ' 29.42 ', '107.22');
 insert into addrtab values ( ' 广汉 ', ' 30.58 ', '104.15');
 insert into addrtab values ( ' 广元 ', ' 32.28 ', '105.51');
 insert into addrtab values ( ' 华蓥 ', ' 30.26 ', '106.44');
 insert into addrtab values ( ' 简阳 ', ' 30.24 ', '104.32');
 insert into addrtab values ( ' 江油 ', ' 31.48 ', '104.42');
 insert into addrtab values ( ' 阆中 ', ' 31.36 ', '105.58');
 insert into addrtab values ( ' 乐山 ', ' 29.36 ', '103.44');
 insert into addrtab values ( ' 泸州 ', ' 28.54 ', '105.24');
 insert into addrtab values ( ' 绵阳 ', ' 31.30 ', '104.42');
 insert into addrtab values ( ' 南充 ', ' 30.49 ', '106.04');
 insert into addrtab values ( ' 内江 ', ' 29.36 ', '105.02');
 insert into addrtab values ( ' 攀枝花 ', ' 26.34 ', '101.43');
 insert into addrtab values ( ' 彭州 ', ' 30.59 ', '103.57');
 insert into addrtab values ( ' 邛崃 ', ' 30.26 ', '103.28');
 insert into addrtab values ( ' 遂宁 ', ' 30.31 ', '105.33');
 insert into addrtab values ( ' 万县 ', ' 30.50 ', '108.21');
 insert into addrtab values ( ' 万源 ', ' 32.03 ', '108.03');
 insert into addrtab values ( ' 西昌 ', ' 27.54 ', '102.16');
 insert into addrtab values ( ' 雅安 ', ' 29.59 ', '102.59');
 insert into addrtab values ( ' 宜宾 ', ' 28.47 ', '104.34');
 insert into addrtab values ( ' 自贡 ', ' 29.23 ', '104.46');
 insert into addrtab values ( ' 资阳 ', ' 30.09 ', '104.38');
 insert into addrtab values ( ' 台北 ', ' 25.03 ', '121.30');
 insert into addrtab values ( ' 天津 ', ' 39.02 ', '117.12');
 insert into addrtab values ( ' 拉萨 ', ' 29.39 ', '91.08');
 insert into addrtab values ( ' 日喀则 ', ' 29.16 ', '88.51');
 insert into addrtab values ( ' 香港 ', ' 21.23 ', '115.12');
 insert into addrtab values ( ' 乌鲁木齐 ', ' 43.45 ', '87.36');
 insert into addrtab values ( ' 阿克苏 ', ' 41.09 ', '80.19');
 insert into addrtab values ( ' 阿勒泰 ', ' 47.50 ', '88.12');
 insert into addrtab values ( ' 阿图什 ', ' 39.42 ', '76.08');
 insert into addrtab values ( ' 博乐 ', ' 44.57 ', '82.08');
 insert into addrtab values ( ' 昌吉 ', ' 44.02 ', '87.18');
 insert into addrtab values ( ' 阜康 ', ' 44.09 ', '87.58');
 insert into addrtab values ( ' 哈密 ', ' 42.50 ', '93.28');
 insert into addrtab values ( ' 和田 ', ' 37.09 ', '79.55');
 insert into addrtab values ( ' 克拉玛依 ', ' 45.36 ', '84.51');
 insert into addrtab values ( ' 喀什 ', ' 39.30 ', '75.59');
 insert into addrtab values ( ' 库尔勒 ', ' 41.46 ', '86.07');
 insert into addrtab values ( ' 奎屯 ', ' 44.27 ', '84.56');
 insert into addrtab values ( ' 石河子 ', ' 44.18 ', '86.00');
 insert into addrtab values ( ' 塔城 ', ' 46.46 ', '82.59');
 insert into addrtab values ( ' 吐鲁番 ', ' 42.54 ', '89.11');
 insert into addrtab values ( ' 伊宁 ', ' 43.55 ', '81.20');
 insert into addrtab values ( ' 昆明 ', ' 25.04 ', '102.42');
 insert into addrtab values ( ' 保山 ', ' 25.08 ', '99.10');
 insert into addrtab values ( ' 楚雄 ', ' 25.01 ', '101.32');
 insert into addrtab values ( ' 大理 ', ' 25.34 ', '100.13');
 insert into addrtab values ( ' 东川 ', ' 26.06 ', '103.12');
 insert into addrtab values ( ' 个旧 ', ' 23.21 ', '103.09');
 insert into addrtab values ( ' 景洪 ', ' 22.01 ', '100.48');
 insert into addrtab values ( ' 开远 ', ' 23.43 ', '103.13');
 insert into addrtab values ( ' 曲靖 ', ' 25.30 ', '103.48');
 insert into addrtab values ( ' 瑞丽 ', ' 24.00 ', '97.50');
 insert into addrtab values ( ' 思茅 ', ' 22.48 ', '100.58');
 insert into addrtab values ( ' 畹町 ', ' 24.06 ', '98.04');
 insert into addrtab values ( ' 宣威 ', ' 26.13 ', '104.06');
 insert into addrtab values ( ' 玉溪 ', ' 24.22 ', '102.32');
 insert into addrtab values ( ' 昭通 ', ' 27.20 ', '103.42');
 insert into addrtab values ( ' 杭州 ', ' 30.16 ', '120.10');
 insert into addrtab values ( ' 慈溪 ', ' 30.11 ', '121.15');
 insert into addrtab values ( ' 东阳 ', ' 29.16 ', '120.14');
 insert into addrtab values ( ' 奉化 ', ' 29.39 ', '121.24');
 insert into addrtab values ( ' 富阳 ', ' 30.03 ', '119.57');
 insert into addrtab values ( ' 海宁 ', ' 30.32 ', '120.42');
 insert into addrtab values ( ' 湖州 ', ' 30.52 ', '120.06');
 insert into addrtab values ( ' 建德 ', ' 29.29 ', '119.16');
 insert into addrtab values ( ' 江山 ', ' 28.45 ', '118.37');
 insert into addrtab values ( ' 嘉兴 ', ' 30.46 ', '120.45');
 insert into addrtab values ( ' 金华 ', ' 29.07 ', '119.39');
 insert into addrtab values ( ' 兰溪 ', ' 29.12 ', '119.28');
 insert into addrtab values ( ' 临海 ', ' 28.51 ', '121.08');
 insert into addrtab values ( ' 丽水 ', ' 28.27 ', '119.54');
 insert into addrtab values ( ' 龙泉 ', ' 28.04 ', '119.08');
 insert into addrtab values ( ' 宁波 ', ' 29.52 ', '121.33');
 insert into addrtab values ( ' 平湖 ', ' 30.42 ', '121.01');
 insert into addrtab values ( ' 衢州 ', ' 28.58 ', '118.52');
 insert into addrtab values ( ' 瑞安 ', ' 27.48 ', '120.38');
 insert into addrtab values ( ' 上虞 ', ' 30.01 ', '120.52');
 insert into addrtab values ( ' 绍兴 ', ' 30.00 ', '120.34');
 insert into addrtab values ( ' 台州 ', ' 28.41 ', '121.27');
 insert into addrtab values ( ' 桐乡 ', ' 30.38 ', '120.32');
 insert into addrtab values ( ' 温岭 ', ' 28.22 ', '121.21');
 insert into addrtab values ( ' 温州 ', ' 28.01 ', '120.39');
 insert into addrtab values ( ' 萧山 ', ' 30.09 ', '120.16');
 insert into addrtab values ( ' 义乌 ', ' 29.18 ', '120.04');
 insert into addrtab values ( ' 乐清 ', ' 28.08 ', '120.58');
 insert into addrtab values ( ' 余杭 ', ' 30.26 ', '120.18');
 insert into addrtab values ( ' 余姚 ', ' 30.02 ', '121.10');
 insert into addrtab values ( ' 永康 ', ' 29.54 ', '120.01');
 insert into addrtab values ( ' 舟山 ', ' 30.01 ', '122.06');
 insert into addrtab values ( ' 诸暨 ', ' 29.43 ', '120.14');
 insert into addrtab values ( '重庆', ' 29.35 ', '106.33');
 insert into addrtab values ( ' 合川 ', ' 30.02 ', '106.15');
 insert into addrtab values ( ' 江津 ', ' 29.18 ', '106.16');
 insert into addrtab values ( ' 南川 ', ' 29.10 ', '107.05');
 insert into addrtab values ( ' 永川 ', ' 29.23 ', '105.53');