Skip to content

Commit a847fa9

Browse files
clark2668clark2668
committed
Fix the cable delays in stations A4 and A5
1 parent 8cf1c7d commit a847fa9

File tree

4 files changed

+34
-39
lines changed

4 files changed

+34
-39
lines changed

‎AraEvent/calib/AntennaInfo.sqlite‎

-19 KB
Binary file not shown.

‎dbScripts/AntennaInfo.sqlite‎

-19 KB
Binary file not shown.

‎dbScripts/howToRun.txt‎

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,13 +1,10 @@
11
use the following commands:
22

3-
43
sqlite3 dbname.db < makeAntInfoATRI.sql
54

6-
75
This is a friendly reminder that when you generate AntennaInfo.sqlite, please load both ATRI and ICRR antenans into it.
86

97
That is, you should do both command right after eachother (the file will not overwrite):
108

119
sqlite3 AntennaInfo.sqlite < makeAntInfoATRI.sql
1210
sqlite3 AntennaInfo.sqlite < makeAntInfoICRR.sql
13-

‎dbScripts/makeAntInfoATRI.sql‎

Lines changed: 34 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -610,94 +610,92 @@ insert into ARA03_2018 VALUES(19, "S4", "SA4", "kSurface",
610610
0,0,0,0,
611611
0,0,0,25,116,0);
612612

613-
614-
--NEEDS TO BE CHECKED (Note made by UAL 01/25/2019)- ARA04 and ARA05 have the same cable delays and also antennas in one string have the same cable delays (this is true for all the strings).
615-
616613
-- ARA04 information
617614
-- Updated by UAL (01/25/2019). Updated the X, Y and Z coordinates of the station, the foamChanNum, the channel mappings and the cable delays. I used Yue Pan's AntennaInfoV3.sqlite to get the right channel mappings (daqChanNum) and cable delays (which I am not sure about). Used this file: https://www.overleaf.com/read/bpvxgfrhqhzh to get the surveyor coordinates which I then converted Ara Station Centric Coordinate system.
615+
-- Updated by BAC (04/24/2019). Updated the cable delays for all deep channels.
618616

619617
insert into ARA04 VALUES(0 , "BH1", "TVPol", "kVertical",
620618
0, 17, 1, 0, 2, "kBicone",
621-
-12.6388,22.5182,-163.16,132.3,
619+
-12.6388,22.5182,-163.16,18.62,
622620
0,0,0,0,
623621
0,0,0,140,800,0);
624622
insert into ARA04 VALUES(1 , "BH2", "TVPol", "kVertical",
625623
1, 9, 5, 0, 2, "kBicone",
626-
11.8342,5.40161,-159.5,132.3,
624+
11.8342,5.40161,-159.5,18.62,
627625
0,0,0,0,
628626
0,0,0,140,800,0);
629627
insert into ARA04 VALUES(2 , "BH3", "TVPol", "kVertical",
630628
2, 1, 9, 0, 2, "kBicone",
631-
7.93627,-21.847,-163.52,132.3,
629+
7.93627,-21.847,-163.52,18.62,
632630
0,0,0,0,
633631
0,0,0,140,800,0);
634632
insert into ARA04 VALUES(3 , "BH4", "TVPol", "kVertical",
635633
3, 29, 13, 0, 2, "kBicone",
636-
-13.183,-4.55271,-165.27,132.3,
634+
-13.183,-4.55271,-165.27,18.62,
637635
0,0,0,0,
638636
0,0,0,140,800,0);
639637

640638
insert into ARA04 VALUES(4 , "BH1", "BVPol", "kVertical",
641639
4, 16, 0, 0, 4, "kBicone",
642-
-12.6388,22.5182,-192.84,120.54,
640+
-12.6388,22.5182,-192.84,132.3,
643641
0,0,0,0,
644642
0,0,0,140,800,0);
645643
insert into ARA04 VALUES(5 , "BH2", "BVPol", "kVertical",
646644
5, 8, 4, 0, 4, "kBicone",
647-
11.8342,5.40161,-189.23,120.54,
645+
11.8342,5.40161,-189.23,132.3,
648646
0,0,0,0,
649647
0,0,0,140,800,0);
650648
insert into ARA04 VALUES(6 , "BH3", "BVPol", "kVertical",
651649
6, 0, 8, 0, 4, "kBicone",
652-
7.93627,-21.847,-193.3,120.54,
650+
7.93627,-21.847,-193.3,132.3,
653651
0,0,0,0,
654652
0,0,0,140,800,0);
655653
insert into ARA04 VALUES(7 , "BH4", "BVPol", "kVertical",
656654
7, 28, 12, 0, 4, "kBicone",
657-
-13.183,-4.55271,-194.9,120.54,
655+
-13.183,-4.55271,-194.9,132.3,
658656
0,0,0,0,
659657
0,0,0,140,800,0);
660658

661659
insert into ARA04 VALUES(8, "BH1", "THPol", "kHorizontal",
662660
0, 19, 3, 0, 1, "kQuadSlot",
663-
-12.6388,22.5182,-160.15,18.62,
661+
-12.6388,22.5182,-160.15,6.86,
664662
0,0,0,0,
665663
0,0,0,140,800,0);
666664
insert into ARA04 VALUES(9 , "BH2", "THPol", "kHorizontal",
667665
1, 11, 7, 0, 1, "kQuadSlot",
668-
11.8342,5.40161,-156.54,18.62,
666+
11.8342,5.40161,-156.54,6.86,
669667
0,0,0,0,
670668
0,0,0,140,800,0);
671669
insert into ARA04 VALUES(10 , "BH3", "THPol", "kHorizontal",
672670
2, 3, 11, 0, 1, "kQuadSlot",
673-
7.93627,-21.847,-160.54,18.62,
671+
7.93627,-21.847,-160.54,6.86,
674672
0,0,0,0,
675673
0,0,0,140,800,0);
676674
insert into ARA04 VALUES(11, "BH4", "THPol", "kHorizontal",
677675
3, 31, 15, 0, 1, "kQuadSlot",
678-
-13.183,-4.55271,-162.35,18.62,
676+
-13.183,-4.55271,-162.35,6.86,
679677
0,0,0,0,
680678
0,0,0,140,800,0);
681679

682680

683681
insert into ARA04 VALUES(12, "BH1", "BHPol", "kHorizontal",
684682
4, 18, 2, 0, 3, "kQuadSlot",
685-
-12.6388,22.5182,-189.89,6.86,
683+
-12.6388,22.5182,-189.89,120.54,
686684
0,0,0,0,
687685
0,0,0,140,800,0);
688686
insert into ARA04 VALUES(13, "BH2", "BHPol", "kHorizontal",
689687
5, 10, 6, 0, 3, "kQuadSlot",
690-
11.8342,5.40161,-186.16,6.86,
688+
11.8342,5.40161,-186.16,120.54,
691689
0,0,0,0,
692690
0,0,0,140,800,0);
693691
insert into ARA04 VALUES(14, "BH3", "BHPol", "kHorizontal",
694692
6, 2, 10, 0, 3, "kQuadSlot",
695-
7.93627,-21.847,-190.3,6.86,
693+
7.93627,-21.847,-190.3,120.54,
696694
0,0,0,0,
697695
0,0,0,140,800,0);
698696
insert into ARA04 VALUES(15, "BH4", "BHPol", "kHorizontal",
699697
7, 30, 14, 0, 3, "kQuadSlot",
700-
-13.183,-4.55271,-191.99,6.86,
698+
-13.183,-4.55271,-191.99,120.54,
701699
0,0,0,0,
702700
0,0,0,140,800,0);
703701

@@ -725,90 +723,90 @@ insert into ARA04 VALUES(19, "S4", "SA4", "kSurface",
725723

726724
-- ARA05 information
727725
-- Updated by UAL (01/25/2019). Updated the X, Y and Z coordinates of the station, the foamChanNum, the channel mappings and the cable delays. I used Yue Pan's AntennaInfoV3.sqlite to get the right channel mappings (daqChanNum) and cable delays (which I am not sure about). Used this file: https://www.overleaf.com/read/bpvxgfrhqhzh to get the surveyor coordinates which I then converted Ara Station Centric Coordinate system.
728-
726+
-- Updated by BAC (04/24/2019). Updated the cable delays for all deep channels.
729727

730728
insert into ARA05 VALUES(0 , "BH1", "TVPol", "kVertical",
731729
0, 9, 1, 0, 2, "kBicone",
732-
23.8258,-1.6605,-165.46,132.3,
730+
23.8258,-1.6605,-165.46,18.62,
733731
0,0,0,0,
734732
0,0,0,140,800,0);
735733
insert into ARA05 VALUES(1 , "BH2", "TVPol", "kVertical",
736734
1, 1, 5, 0, 2, "kBicone",
737-
-3.94569,-12.6275,-164.67,132.3,
735+
-3.94569,-12.6275,-164.67,18.62,
738736
0,0,0,0,
739737
0,0,0,140,800,0);
740738
insert into ARA05 VALUES(2 , "BH3", "TVPol", "kVertical",
741739
2, 29, 9, 0, 2, "kBicone",
742-
-15.4036,18.0452,-161.34,132.3,
740+
-15.4036,18.0452,-161.34,18.62,
743741
0,0,0,0,
744742
0,0,0,140,800,0);
745743
insert into ARA05 VALUES(3 , "BH4", "TVPol", "kVertical",
746744
3, 17, 13, 0, 2, "kBicone",
747-
11.4825,25.1047,-147.93,132.3,
745+
11.4825,25.1047,-147.93,18.62,
748746
0,0,0,0,
749747
0,0,0,140,800,0);
750748

751749
insert into ARA05 VALUES(4 , "BH1", "BVPol", "kVertical",
752750
4, 8, 0, 0, 4, "kBicone",
753-
23.8258,-1.6605,-195.32,120.54,
751+
23.8258,-1.6605,-195.32,132.3,
754752
0,0,0,0,
755753
0,0,0,140,800,0);
756754
insert into ARA05 VALUES(5 , "BH2", "BVPol", "kVertical",
757755
5, 0, 4, 0, 4, "kBicone",
758-
-3.94569,-12.6275,-194.52,120.54,
756+
-3.94569,-12.6275,-194.52,132.3,
759757
0,0,0,0,
760758
0,0,0,140,800,0);
761759
insert into ARA05 VALUES(6 , "BH3", "BVPol", "kVertical",
762760
6, 28, 8, 0, 4, "kBicone",
763-
-15.4036,18.0452,-191.28,120.54,
761+
-15.4036,18.0452,-191.28,132.3,
764762
0,0,0,0,
765763
0,0,0,140,800,0);
766764
insert into ARA05 VALUES(7 , "BH4", "BVPol", "kVertical",
767765
7, 16, 12, 0, 4, "kBicone",
768-
11.4825,25.1047,-177.72,120.54,
766+
11.4825,25.1047,-177.72,132.3,
769767
0,0,0,0,
770768
0,0,0,140,800,0);
771769

772770
insert into ARA05 VALUES(8, "BH1", "THPol", "kHorizontal",
773771
0, 11, 3, 0, 1, "kQuadSlot",
774-
23.8258,-1.6605,-162.53,18.62,
772+
23.8258,-1.6605,-162.53,6.86,
775773
0,0,0,0,
776774
0,0,0,140,800,0);
777775
insert into ARA05 VALUES(9 , "BH2", "THPol", "kHorizontal",
778776
1, 3, 7, 0, 1, "kQuadSlot",
779-
-3.94569,-12.6275,-161.75,18.62,
777+
-3.94569,-12.6275,-161.75,6.86,
780778
0,0,0,0,
781779
0,0,0,140,800,0);
782780
insert into ARA05 VALUES(10 , "BH3", "THPol", "kHorizontal",
783781
2, 31, 11, 0, 1, "kQuadSlot",
784-
-15.4036,18.0452,-158.39,18.62,
782+
-15.4036,18.0452,-158.39,6.86,
785783
0,0,0,0,
786784
0,0,0,140,800,0);
787785
insert into ARA05 VALUES(11, "BH4", "THPol", "kHorizontal",
788786
3, 19, 15, 0, 1, "kQuadSlot",
789-
11.4825,25.1047,-145.01,18.62,
787+
11.4825,25.1047,-145.01,6.86,
790788
0,0,0,0,
791789
0,0,0,140,800,0);
792790

793791

794792
insert into ARA05 VALUES(12, "BH1", "BHPol", "kHorizontal",
795793
4, 10, 2, 0, 3, "kQuadSlot",
796-
23.8258,-1.6605,-192.35,6.86,
794+
23.8258,-1.6605,-192.35,120.54,
797795
0,0,0,0,
798796
0,0,0,140,800,0);
799797
insert into ARA05 VALUES(13, "BH2", "BHPol", "kHorizontal",
800798
5, 2, 6, 0, 3, "kQuadSlot",
801-
-3.94569,-12.6275,-191.37,6.86,
799+
-3.94569,-12.6275,-191.37,120.54,
802800
0,0,0,0,
803801
0,0,0,140,800,0);
804802
insert into ARA05 VALUES(14, "BH3", "BHPol", "kHorizontal",
805803
6, 30, 10, 0, 3, "kQuadSlot",
806-
-15.4036,18.0452,-188.12,6.86,
804+
-15.4036,18.0452,-188.12,120.54,
807805
0,0,0,0,
808806
0,0,0,140,800,0);
809807
insert into ARA05 VALUES(15, "BH4", "BHPol", "kHorizontal",
810808
7, 18, 14, 0, 3, "kQuadSlot",
811-
11.4825,25.1047,-174.74,6.86,
809+
11.4825,25.1047,-174.74,120.54,
812810
0,0,0,0,
813811
0,0,0,140,800,0);
814812

0 commit comments

Comments
 (0)