tv.sql

计算卫星天线角度

create table tv (卫星名称 varchar(60) not null,卫星经度 float(10) not null,天线仰角 float(10) not null,天线方位角 varchar(50) not null,极化角 float(10) not null,primary key(卫星名称));


insert into tv values('国际703  (InterSat-707)'      ,      '57.0'  ,  '22.88' ,   '南偏西67.30度', '-50.82');
insert into tv values('国际604  (InterSat-604)'      ,       '60.0'   ,   '25.34'  ,   '南偏西65.04度', '-49.62' );
insert into tv values('国际602  (InterSat-602)'      ,       '62.0'   ,   '26.96'  ,   '南偏西63.46度', '-48.74' );
insert into tv values('国际804  (InterSat-804)'      ,       '64.0'   ,   '28.57'  ,   '南偏西61.83度', '-47.79' );
insert into tv values('国际704  (InterSat-704)'      ,       '66.0'   ,   '30.16'  ,   '南偏西60.13度', '-46.77'  );
insert into tv values('泛美4/7  (PanamSat-4/7) '     ,       '68.5'   ,   '32.11'  ,   '南偏西57.91度', '-45.39'  );
insert into tv values('俄星LMI1 (LMI1)'              ,       '75.0'   ,   '37.00'  ,   '南偏西51.58度', '-41.17'  );
insert into tv values('亚太2R   (ApStar-2R)'         ,       '76.5'   ,   '38.07'  ,   '南偏西49.98度', '-40.06'  );
insert into tv values('航向1号  (Luch-1)'            ,       '77.0'   ,   '38.43'  ,   '南偏西49.44度', '-39.67'  );
insert into tv values('泰星2/3  (ThaiCom-2/3) '      ,       '78.5'   ,   '39.47 ' ,   '南偏西47.77度', '-38.48'  );
insert into tv values('快车6号  (Express-6)'         ,       '80.0'   ,   '40.49'  ,   '南偏西46.05度', '-37.22'  );
insert into tv values('印度2E   (InSat-2E)'          ,       '83.0'   ,   '42.45'  ,   '南偏西42.42度', '-34.53'  );
insert into tv values('中卫1号  (ChinaStar-1) '      ,       '87.5'   ,   '45.14'  ,   '南偏西36.49度', '-29.98'  );
insert into tv values('中新1号  (ST-1)'              ,       '88.0'   ,   '45.41'  ,   '南偏西35.79度', '-29.43'  );
insert into tv values('马星1号  (MeaSat-1)'          ,       '91.5'   ,   '47.23'  ,   '南偏西30.71度', '-25.41'  );
insert into tv values('印度2B/2 (CInSat 2B/2C)'      ,       '93.5'   ,   '48.15'  ,   '南偏西27.64度', '-22.94'  );
insert into tv values('国际K-TV (NSS K-TV)'          ,       '95.0'   ,   '48.78'  ,   '南偏西25.26度', '-21.01'  );
insert into tv values('亚洲2号  (AsiaSat-2)'         ,       '100.5'  ,   '50.63'  ,   '南偏西16.02度', '-13.41'  );
insert into tv values('亚洲3号  (AsiaSat-3S)'        ,       '105.5'  ,   '51.58'  ,   '南偏西7.08度' , '-5.94'   );
insert into tv values('百合花   (Bsat-1A/1B)'        ,       '110.0'  ,   '51.80'  ,   '南偏东1.20度' , '1.01'    );
insert into tv values('鑫诺1号  (SinoSat-1)'         ,       '110.5'  ,   '51.79'  ,   '南偏东2.12度' , '1.78'    );
insert into tv values('帕拉帕C2 (Palapa-C2)'         ,       '113.0'  ,   '51.61'  ,   '南偏东6.71度' , '5.64'    );
insert into tv values('中星8号  (待发射)'            ,       '115.5'  ,   '51.23'  ,   '南偏东11.24度', '9.43'    );
insert into tv values('韩星1/2  (KoreaSat-1/2)'      ,       '116.0'  ,   '51.14'  ,   '南偏东12.14度', '10.18 '  );
insert into tv values('泰星1A   (ThaiCom-1A) '       ,       '120.0'  ,   '50.11'  ,   '南偏东19.13度', '15.98 '  );
insert into tv values('亚洲1号  (AsiaSat-1) '        ,       '122.0'  ,   '49.44'  ,   '南偏东22.49度', '18.75 '  );
insert into tv values('日本通信4号 (JcSat-4)'        ,       '124.0'  ,   '48.66'  ,   '南偏东25.74度', '21.40 '  );
insert into tv values('中星6号  (ChinaSat-6)'        ,       '125.0'  ,   '48.24'  ,   '南偏东27.33度', '22.69 '  );
insert into tv values('日本通信3号 (JcSat-3) '       ,       '128.0'  ,   '46.83'  ,   '南偏东31.90度', '26.36 '  );
insert into tv values('亚太1A号 (ApStar-1A)'         ,       '134.0'  ,   '43.50'  ,   '南偏东40.25度', '32.88 '  );
insert into tv values('亚太1号  (ApStar-1) '         ,       '138.0'  ,   '40.96'  ,   '南偏东45.22度', '36.62 '  );
insert into tv values('超鸟C    (SuperBird-C)'       ,       '144.0'  ,   '36.78'  ,   '南偏东51.89度', '41.39 '  );
insert into tv values('马步海   (Agila-2) '          ,       '146.0'  ,   '35.31'  ,   '南偏东53.92度', '42.77 '  );
insert into tv values('超鸟B1   (SuperBird-B1)'      ,       '162.0'  ,   '22.63'  ,   '南偏东67.52度', '50.94 '  );
insert into tv values('泛美8号  (PanamSat-8)'        ,       '166.0'  ,   '19.32'  ,   '南偏东70.36度', '52.32 '  );
insert into tv values('泛美2号  (PanamSat-2)'        ,       '169.0'  ,   '16.81'  ,   '南偏东72.39度', '53.22 '  );
insert into tv values('国际802  (InterSat-802)'      ,       '174.0'  ,   '12.61'  ,   '南偏东75.59度', '54.48 '  );
insert into tv values('国际702  (InterSat-702)'      ,       '177.0'  ,   '10.08'  ,   '南偏东77.43度', '55.10 '  );
insert into tv values('国际701  (InterSat-701)'      ,       '180.0'  ,   '7.55 '  ,   '南偏东79.22度', '55.63 '  );