Versions Compared

Key

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

...

SELECT
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
 INTO mydb.[RRL_584630948352256_PS1det]
 FROM mydb.[RRL_584630948352256_PS1] o
JOIN Detection d on d.ObjID = o.ObjID

Results

Below are the first 10 entries out of 92 total entries

objIDraMeandecMeanradecraErrdecErrdetectIDobstimeexptimeairmasspsffluxpsffluxErrpsfQfpsfQfPerfectpsfLikelihoodpsfChiSqextNSigmazpapFluxapFluxErrimageIDfilterIDskyskyerrinfoflaginfoflag2infoflag3qualityFlaggMeanPSFMaggMeanPSFMagErrgMeanPSFMagNptrMeanPSFMagrMeanPSFMagErrrMeanPSFMagNptiMeanPSFMagiMeanPSFMagErriMeanPSFMagNptzMeanPSFMagzMeanPSFMagErrzMeanPSFMagNptyMeanPSFMagyMeanPSFMagErryMeanPSFMagNptrMeanKronMagrMeanKronMagErrnDetectionsngnrninznygFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfectyFlagsyQfPerfect
10985046341482086746.341469861.5419990646.341465831.541999130.009303729981184010.0096892500296235120566112773000015056157.6114477301.096539974212650.0003124180075246844.38540018876665E-060.9983540177345280.998354017734528-0.9961450099945070.87238597869873-0.0048311301507055824.26659965515140.0003128749958705162.82292990050337E-065126337345.3173800552031E-054.96299981023185E-06102760517128744837766017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341471011.541995840.008864640258252620.0093005802482366620566183473000013956157.6185191301.084640026092530.0003087979857809844.30704994869302E-060.9978860020637510.997886002063751-0.7512199878692630.885471999645233-0.31703200936317424.26460075378420.0003070069942623382.80717995337909E-065126477345.40842011105269E-054.96676011607633E-06102760517128744837766017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341470321.541994860.0164823997765780.018109099939465520546351973000014956155.6353733301.070350050926210.0004264760063961151.07013001979794E-050.9975069761276250.997506976127625-0.4019590020179750.956974983215332-0.83812701702117923.28190040588380.0004324890032876285.24767983733909E-065117357350.0002806730044540021.65041001309874E-05102760517128241521286017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341475291.542007290.01820969954133030.018521599471569120546391473000014356155.6393177301.066750049591060.0004794780106749391.25105998449726E-050.9970269799232480.997026979923248-0.1146790012717251.0324399471283-1.5775099992752123.27949905395510.0004396490112412725.31304021933465E-065117437350.0003930029924958941.91349008673569E-05102760453128912609926017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341486711.54200090.0101944999769330.0099984798580408121134710673000008656214.471324431.073590040206910.0003368649922776973.1451399991056E-060.9988809823989870.9708110094070430.9731330275535580.5710170269012450.033678598701953924.47299957275390.0003403179871384052.1996900159138E-065314177317.04271997165051E-061.81308996616281E-0610276051712873749126017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341470481.54200660.009333900175988670.0087078996002674121134841073000008256214.4843629431.062520027160640.000319473008858042.96693997370312E-060.9993789792060850.9882529973983760.1089930012822150.5604010224342351.6027400493621824.47739982604980.0003297629882581532.17397996493673E-065314377317.01579983797274E-061.76822004505084E-0610276051712873749126017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.34147131.541998190.003330020001158120.0033882700372487321055709366000007956206.5712068451.11612999439240.0005187939968891442.92105005428311E-060.9983270168304440.9983270168304440.6735990047454831.160140037536620.42121300101280224.57939910888670.0005225139902904632.58356999438547E-065269996633.55550982931163E-052.70530995294394E-061027605171281248154246017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341466261.542002410.003471419913694260.0035481599625221055844266000009156206.5846906451.152729988098140.0005161250010132792.92271010948753E-060.9979069828987120.76691597700119-0.2888930141925811.1114000082016-1.0605499744415324.57810020446780.0005118770059198142.55920008385147E-065270196633.64152001566254E-052.64890991275024E-06102760517128348806017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341475381.541999940.003994400147348640.0045131701044738321055177875000008056206.5180227401.058740019798280.0004756159905809912.96145003630954E-060.9990019798278810.9990019798278810.9099370241165161.048359990119930.11311800032854124.68020057678220.000480396993225442.4879000193323E-065269417522.86260001303162E-052.47058005697909E-0610276051712873749126017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.5419990646.341472621.54199390.00364916003309190.0040896399877965521055304675000007356206.530699401.061169981956480.0005306359962560243.04362993119867E-060.9992439746856690.999243974685669-0.5486170053482061.09794998168945-0.59983402490615824.67889976501460.0005283370264805852.61910008703126E-065269617522.90354000753723E-052.51040000875946E-0610276051712873749126017.63990020751950.0298919994384051217.19619941711430.04488600045442581317.48119926452640.04934100061655042317.50720024108890.05795700103044511017.52680015563960.02181899920105931017.21780014038090.04143000021576889214183017131150000.9995040297508241150000.9997199773788451150000.9995329976081851150000.998973011970521150000.99940699338913

...

Query #3: Get the forced detections

SELECT o.ID_GAIA,o.GAIARA, o.GAIADec, o.Gmag, o.period,
o.objID, o.raMean, o.decMean,
fwm.detectID, fwm.obstime, fwm.exptime, fwm.airmass, fwm.Fpsfflux, fwm.FpsffluxErr, fwm.FpsfQf, fwm.FpsfQfPerfect, fwm.FpsfChiSq, fwm.zp, fwm.FapFlux, fwm.FapFluxErr,
fwm.forcedWarpID, fwm.filterID,
fwm.Fsky, fwm.Fskyerr, fwm.Finfoflag, fwm.Finfoflag2, fwm.Finfoflag3,
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 mydb.[RRL__584630948352256_PS1forceddet]
FROM mydb.[RRL_584630948352256_PS1] o
JOIN ForcedWarpMeasurement fwm on fwm.ObjID = o.ObjID

Results

...

Below are the first 10 entries out of 84 total entries

0.55547145720003502196488E998145998145765097456400035949633503E85638E5692E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555471162600033984161849E998072998072749982464100034841629292E37593E50972E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555473533700025460488525E9993249993241026309700026287528175E09933E17848E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555474455700037089216762E99895899895809638368500037172440599E86901E97909E6399029892196204488648120493415072057957526802181921780414399950499972999533998973999407073590003240307634E999711973116630758460900033791319088E48615E49863E63990298921962044886481204934150720579575268021819217804143999504999729995330.555470625200030059180449E999801989282589187455700033229518906E36515E61688E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555470663000523414368E99911899911887650647580005268774996E30874E7956E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.55547129480002697232236E9990899990892416146520002844410379E71303E50396E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555470996500034984472148E99891799874131018470600035388325995E14166E47287E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994070.555471798200030532353239E9997999777898418400031577618451E13619E48642E63990298921962044886481204934150720579575268021819217804143999504999729995339989739994071
objIDraMeandecMeandetectIDobstimeexptimeairmassFpsffluxFpsffluxErrFpsfQfFpsfQfPerfectFpsfChiSqzpFapFluxFapFluxErrforcedWarpIDfilterIDFskyFskyerrFinfoflagFinfoflag2Finfoflag3qualityFlaggMeanPSFMaggMeanPSFMagErrgMeanPSFMagNptrMeanPSFMagrMeanPSFMagErrrMeanPSFMagNptiMeanPSFMagiMeanPSFMagErriMeanPSFMagNptzMeanPSFMagzMeanPSFMagErrzMeanPSFMagNptyMeanPSFMagyMeanPSFMagErryMeanPSFMagNptrMeanKronMagrMeanKronMagErrnDetectionsngnrninznygFlagsgQfPerfectrFlagsrQfPerfectiFlagsiQfPerfectzFlagszQfPerfectyFlagsyQfPerfect
primaryDetectionbestDetection58463094835225646.3414689159231.5419981082525217.4408
10985046341482086746.341469861.54199906247611931553588969055507.3712258431.
14572000503540.
0003502189938444642.
648800091265E-060.
99814498424530.
99814498424530.
7650970220565824.
45639991760250.
0003594960144255312.
33503010349523E-064252165316.
85637999708888E-081.
56919998062222E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611933378950069855507.3823453431.
116260051727290.
000339841004461052.
61849004346004E-060.
9980720281600950.
9980720281600950.
74998199939727824.
46409988403320.
000348416011547672.
29292004405579E-064252165415.
37593010108139E-081.
50972005030781E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611940787768655455871.5445119431.
353369951248170.
0002546040050219743.
88524995287298E-060.
9993240237236020.
9993240237236021.
1026300191879324.
09700012207030.
0002628749934956432.
28175008487597E-064252165711.
09932997816031E-073.
17848002850951E-0616986988901080043526017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611951739935260255871.5567211431.
445569992065430.
0003708919975906613.
16761997964932E-060.
9989579916000370.
9989579916000371.
0963799953460724.
36849975585940.
0003717239887919282.
40599001699593E-064252165818.
86901005969776E-081.
9790900296357E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.44080.55547
99940699338913
10985046341482086746.341469861.54199906247611950693036981856214.471324431.
073590040206910.
0003240299993194643.
07633990814793E-060.
9997109770774840.
9731159806251530.
63075798749923724.
46089935302730.
0003379129921086132.
1908799681114E-064252165913.
48615003531449E-091.
4986300129749E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
1150000.9989731150000.9994071158463094835225646.3414689159231.5419981082525217.4408
9995329976081851150000.998973011970521150000.99940699338913
10985046341482086746.341469861.54199906247611948867675881056214.4843629431.
062520027160640.
000300590996630492.
80448989542492E-060.
9998009800910950.
9892820119857790.
58918702602386524.
45569992065430.
0003322949924040592.
18906006921316E-06425216601-1.
36515003745785E-081.
61688001298899E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611973751642652256620.367559431.
066300034523010.
0005234139971435073.
3680000797176E-060.
9991179704666140.
9991179704666140.
87650597095489524.
47579956054690.
0005268700188025832.
74996000371175E-064252166115.
30874011417382E-081.
7956000419872E-0616986988901247815686017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611978368732495456630.3025631431.
129480004310610.
0002697200106922542.
32235993280483E-060.
9990890026092530.
9990890026092531.
2416100502014224.
46520042419430.
0002844409900717442.
03790000341542E-06425216621-8.
71303029725823E-121.
5039599929878E-0616986988901247815686017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247611992810560028256630.3156559431.
099650025367740.
0003498439909890292.
72148008662043E-060.
9989169836044310.
9987409710884091.
3101799488067624.
47060012817380.
0003538829914759842.
25994995162182E-064252166311.
1416600109726E-081.
47287005347607E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1158463094835225646.3414689159231.5419981082525217.4408
99940699338913
10985046341482086746.341469861.54199906247612547344525033055859.5429067431.
179819941520690.
000305322988424452.
5323899990326E-060.
9997000098228450.
9997000098228451.
7789800167083724.
4183998107910.
0003157760074827822.
18451009459386E-064252166412.
13619006927956E-081.
4864200466036E-06169869889073410566017.
63990020751950.
0298919994384051217.
19619941711430.
04488600045442581317.
48119926452640.
04934100061655042317.
50720024108890.
05795700103044511017.
52680015563960.
02181899920105931017.
21780014038090.
04143000021576889214183017131150000.
9995040297508241150000.
9997199773788451150000.
9995329976081851150000.
998973011970521150000.
1
99940699338913


The following figures show the PS1 i-band light curve for the RR Lyrae based on the detection and force detection aperture and PSF photometry:

...