Versions Compared

Old Version 28

changes.mady.by.user Annalisa Calamida

Saved on

compared with

New Version 29

changes.mady.by.user Armin Rest

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Star CSS J030521.9+013231 (Catalina Sky Survey), 584630948352256 (GAIA) is an RR Lyrae with period = 0.55547 days and coordinates RA = 46.341468915923 and DEC = 1.54199810825252 (ref. GAIA DR2,  2018yCat.1345....0G). In the following, we obtain the PSF and aperture photometry light-curves, both forced and unforced, for this star.

Query #1: Get the ObjID for the star

...

(1 entry, < 1 min)

SELECT SELECT d.ID_GAIA,d.RA_GAIA as GAIARA, d.DEC_GAIA as GAIADec, d.Gmag, d.period,
o.objID,  
o.raMean, o.decMean, o.raMeanErr, o.decMeanErr,
o.qualityFlag,
o.gMeanPSFMag, o.gMeanPSFMagErr, o.gMeanPSFMagNpt,
o.rMeanPSFMag, o.rMeanPSFMagErr, o.rMeanPSFMagNpt,
o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanPSFMagNpt,
o.zMeanPSFMag, o.zMeanPSFMagErr, o.zMeanPSFMagNpt,
o.yMeanPSFMag, o.yMeanPSFMagErr, o.yMeanPSFMagNpt,
o.rMeanKronMag, o.rMeanKronMagErr,
o.nDetections, o.ng, o.nr, o.ni, o.nz,o.ny,
o.gFlags, o.gQfPerfect,
o.rFlags, o.rQfPerfect,
o.iFlags, o.iQfPerfect,
o.zFlags, o.zQfPerfect,
o.yFlags, o.yQfPerfect, soa.primaryDetection, soa.bestDetection  INTO
 INTO mydb.[RRL_584630948352256_PS1] FROM mydb.[rrl_584630948352256] d
CROSS APPLY dbo.fGetNearbyObjEq(46.341468915923, 1.54199810825252, 1.0/60.0) as x
JOIN MeanObjectView o on o.ObjID=x.ObjId
LEFT JOIN StackObjectAttributes AS soa ON soa.objID = x.objID
WHERE o.nDetections>8 
AND soa.primaryDetection>0 
AND o.gQfPerfect>0.85 and o.rQfPerfect>0.85 and o.iQfPerfect>0.85 and o.zQfPerfect>0.85 
AND (o.rmeanpsfmag - o.rmeankronmag < 0.05)

Results

]
FROM dbo.fGetNearbyObjEq(46.341468915923, 1.54199810825252, 1.0/60.0) as x
JOIN MeanObjectView o on o.ObjID=x.ObjId

Results

ID_GAIAGAIARAGAIADECGperiod
objIDraMeandecMeanraMeanErrdecMeanErrqualityFlaggMeanPSFMaggMeanPSFMagErrgMeanPSFMagNptrMeanPSFMagrMeanPSFMagErrrMeanPSFMagNptiMeanPSFMagiMeanPSFMagErriMeanPSFMagNptzMeanPSFMagzMeanPSFMagErrzMeanPSFMagNptyMeanPSFMagyMeanPSFMagErryMeanPSFMagNptrMeanKronMagrMeanKronMagErrnDetectionsngnrninznygFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfectyFlagsyQfPerfect
primaryDetection
bestDetection58463094835225646.3414689159231.5419981082525217.44080.5554679
10985046341482086746.341469861.541999060.
00303
003030000021681190.
00392
003920000046491626017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
999407
99940699338913
11

Query #2: Get the detections

...

(92 entries, < 1 min)

SELECT SELECT o.ID_GAIA,o.GAIARA, o.GAIADec, o.Gmag, o.period,
o.objID, o.raMean, o.decMean,
d.ra, d.dec, d.raErr, d.decErr,
d.detectID, d.obstime, d.exptime, d.airmass, d.psfflux, d.psffluxErr, d.psfQf, d.psfQfPerfect, d.psfLikelihood, d.psfChiSq, d.extNSigma, d.zp, d.apFlux, d.apFluxErr,
d.imageID, d.filterID,
d.sky, d.skyerr, d.infoflag, d.infoflag2, d.infoflag3,
o.qualityFlag,
o.gMeanPSFMag, o.gMeanPSFMagErr, o.gMeanPSFMagNpt,
o.rMeanPSFMag, o.rMeanPSFMagErr, o.rMeanPSFMagNpt,
o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanPSFMagNpt,
o.zMeanPSFMag, o.zMeanPSFMagErr, o.zMeanPSFMagNpt,
o.yMeanPSFMag, o.yMeanPSFMagErr, o.yMeanPSFMagNpt,
o.rMeanKronMag, o.rMeanKronMagErr,
o.nDetections, o.ng, o.nr, o.ni, o.nz,o.ny,
o.gFlags, o.gQfPerfect,
o.rFlags, o.rQfPerfect,
o.iFlags, o.iQfPerfect,
o.zFlags, o.zQfPerfect,
o.yFlags, o.yQfPerfect, o.primaryDetection, o.bestDetection INTO
 INTO mydb.[RRL_584630948352256_PS1det]
FROM  FROM mydb.[RRL_584630948352256_PS1] o
JOIN Detection d on d.ObjID = o.ObjID

Results

ID_GAIAGAIARAGAIADECGperiod
objIDraMeandecMeanradecraErrdecErrdetectIDobstimeexptimeairmasspsffluxpsffluxErrpsfQfpsfQfPerfectpsfLikelihoodpsfChiSqextNSigmazpapFluxapFluxErrimageIDfilterIDskyskyerrinfoflaginfoflag2infoflag3qualityFlaggMeanPSFMaggMeanPSFMagErrgMeanPSFMagNptrMeanPSFMagrMeanPSFMagErrrMeanPSFMagNptiMeanPSFMagiMeanPSFMagErriMeanPSFMagNptzMeanPSFMagzMeanPSFMagErrzMeanPSFMagNptyMeanPSFMagyMeanPSFMagErryMeanPSFMagNptrMeanKronMagrMeanKronMagErrnDetectionsngnrninznygFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfectyFlagsyQfPerfect
primaryDetectionbestDetection
58463094835225646.3414689159231.5419981082525217.44080.55547
10985046341482086746.341469861.5419990646.341465831.541999130.
00930373
009303729981184010.
00968925
0096892500296235120566112773000015056157.6114477301.
09654
096539974212650.
000312418
0003124180075246844.
3854E
38540018876665E-060.
998354
9983540177345280.
998354
998354017734528-0.
996145
9961450099945070.
872386
87238597869873-0.
00483113
0048311301507055824.
2666
26659965515140.
000312875
0003128749958705162.
82293E
82292990050337E-065126337345.
31738E
3173800552031E-054.
963E
96299981023185E-06102760517128744837766017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
9995331150000.998973
9995329976081851150000
.999407
.99897301197052115000
1158463094835225646.3414689159231.5419981082525217.4408
0.
55547
99940699338913
10985046341482086746.341469861.5419990646.341471011.541995840.
00886464
008864640258252620.
00930058
0093005802482366620566183473000013956157.6185191301.
08464
084640026092530.
000308798
0003087979857809844.
30705E
30704994869302E-060.
997886
9978860020637510.
997886
997886002063751-0.
75122
7512199878692630.
885472
885471999645233-0.
317032
31703200936317424.
2646
26460075378420.
000307007
0003070069942623382.
80718E
80717995337909E-065126477345.
40842E
40842011105269E-054.
96676E
96676011607633E-06102760517128744837766017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.341470321.541994860.
0164824
0164823997765780.
0181091
018109099939465520546351973000014956155.6353733301.
07035
070350050926210.
000426476
0004264760063961151.
07013E
07013001979794E-050.
997507
9975069761276250.
997507
997506976127625-0.
401959
4019590020179750.
956975
956974983215332-0.
838127
83812701702117923.
2819
28190040588380.
000432489
0004324890032876285.
24768E
24767983733909E-065117357350.
000280673
0002806730044540021.
65041E
65041001309874E-05102760517128241521286017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.341475291.542007290.
0182097
01820969954133030.
0185216
018521599471569120546391473000014356155.6393177301.
06675
066750049591060.
000479478
0004794780106749391.
25106E
25105998449726E-050.
997027
9970269799232480.
997027
997026979923248-0.
114679
1146790012717251.
03244
0324399471283-1.
57751
5775099992752123.
2795
27949905395510.
000439649
0004396490112412725.
31304E
31304021933465E-065117437350.
000393003
0003930029924958941.
91349E
91349008673569E-05102760453128912609926017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
9995331150000.9989731150000.99940711
9995329976081851150000.998973011970521150000.99940699338913
58463094835225646.3414689159231.5419981082525217.44080.55547
10985046341482086746.341469861.5419990646.341486711.54200090.
0101945
0101944999769330.
00999848
0099984798580408121134710673000008656214.471324431.
07359
073590040206910.
000336865
0003368649922776973.
14514E
1451399991056E-060.
998881
9988809823989870.
970811
9708110094070430.
973133
9731330275535580.
571017
5710170269012450.
0336786
033678598701953924.
473
47299957275390.
000340318
0003403179871384052.
19969E
1996900159138E-065314177317.
04272E
04271997165051E-061.
81309E
81308996616281E-0610276051712873749126017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.341470481.54200660.
0093339
009333900175988670.
0087079
0087078996002674121134841073000008256214.4843629431.
06252
062520027160640.
000319473
000319473008858042.
96694E
96693997370312E-060.
999379
9993789792060850.
988253
9882529973983760.
108993
1089930012822150.
560401
5604010224342351.
60274
6027400493621824.
4774
47739982604980.
000329763
0003297629882581532.
17398E
17397996493673E-065314377317.
0158E
01579983797274E-061.
76822E
76822004505084E-0610276051712873749126017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.34147131.541998190.
00333002
003330020001158120.
00338827
0033882700372487321055709366000007956206.5712068451.
11613
11612999439240.
000518794
0005187939968891442.
92105E
92105005428311E-060.
998327
9983270168304440.
998327
9983270168304440.
673599
6735990047454831.
16014
160140037536620.
421213
42121300101280224.
5794
57939910888670.
000522514
0005225139902904632.
58357E
58356999438547E-065269996633.
55551E
55550982931163E-052.
70531E
70530995294394E-061027605171281248154246017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
9995041150000.999721150000.9995331150000.998973
9995040297508241150000.
9994071158463094835225646.3414689159231.54199810825252
9997199773788451150000.9995329976081851150000.99897301197052115000
17.4408
0.
55547
99940699338913
10985046341482086746.341469861.5419990646.341466261.542002410.
00347142
003471419913694260.
00354816
0035481599625221055844266000009156206.5846906451.
15273
152729988098140.
000516125
0005161250010132792.
92271E
92271010948753E-060.
997907
9979069828987120.
766916
76691597700119-0.
288893
2888930141925811.
1114
1114000082016-1.
06055
0605499744415324.
5781
57810020446780.
000511877
0005118770059198142.
5592E
55920008385147E-065270196633.
64152E
64152001566254E-052.
64891E
64890991275024E-06102760517128348806017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.341475381.541999940.
0039944
003994400147348640.
00451317
0045131701044738321055177875000008056206.5180227401.
05874
058740019798280.
000475616
0004756159905809912.
96145E
96145003630954E-060.
999002
9990019798278810.
999002
9990019798278810.
909937
9099370241165161.
04836
048359990119930.
113118
11311800032854124.
6802
68020057678220.
000480397
000480396993225442.
4879E
4879000193323E-065269417522.
8626E
86260001303162E-052.
47058E
47058005697909E-0610276051712873749126017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
9994071158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.5419990646.341472621.54199390.
00364916
00364916003309190.
00408964
0040896399877965521055304675000007356206.530699401.
06117
061169981956480.
000530636
0005306359962560243.
04363E
04362993119867E-060.
999244
9992439746856690.
999244
999243974685669-0.
548617
5486170053482061.
09795
09794998168945-0.
599834
59983402490615824.
6789
67889976501460.
000528337
0005283370264805852.
6191E
61910008703126E-065269617522.
90354E
90354000753723E-052.
5104E
51040000875946E-0610276051712873749126017.
6399
63990020751950.
029892
0298919994384051217.
1962
19619941711430.
044886
04488600045442581317.
4812
48119926452640.
049341
04934100061655042317.
5072
50720024108890.
057957
05795700103044511017.
5268
52680015563960.
021819
02181899920105931017.
2178
21780014038090.
04143
04143000021576889214183017131150000.
999504
9995040297508241150000.
99972
9997199773788451150000.
999533
9995329976081851150000.
998973
998973011970521150000.
99940711
99940699338913


Query #3: Get the forced detections

...