true 42adc10b-0120-8b08-14df-000000302270 true D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION 42adc10b-0120-8b08-14df-000000302270 P2FrameMeta 113891995474759576,261887437010025731,899251006542,629410100004,3,6294101,54163.374374,3929.87,739.10,0.908,0.908,41.53,6.03,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.5474192614493347,4.9159167120451617,0.182,0.182,-999.000000,-999.000000,-999.000000,8.307,21.744,0.004,41.53,6.03,0.091,0.006,300.00,1.00,1.0,1 42adc10b-0120-8b08-14df-000000302270 P2FrameMeta true info.ipaw.pc3.PSLoadWorkflow.LoadConstants$ColumnRange@13d5f21 ad460131-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv.hdr true org.apache.derby.impl.jdbc.EmbedStatement40@c77c8 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 42adc10b-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv P2ImageMeta 113191992826421637,261887437010025729,899251006442,629410100002,3,6294101,54163.374374,854.73,1552.92,1.095,1.095,10.56,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.2826045506832031,4.3259022734874835,0.220,0.219,-999.000000,-999.000000,-999.000000,2.112,23.231,0.021,10.56,5.00,0.150,0.029,300.00,1.00,1.0,1 111291984573189741,261887437030025144,899251008386,629410100015,3,6294103,54163.374374,1610.65,1607.06,1.095,1.095,5.03,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,198.4573033618334534,2.7493765305981124,0.219,0.219,-999.000000,-999.000000,-999.000000,1.007,24.035,0.043,5.03,5.00,0.119,0.060,300.00,1.00,1.0,1 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA org.apache.derby.impl.jdbc.EmbedStatement40@1ea71d4 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA false 3\SampleData/J062941 ad460131-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270 62941,1,3,1,1,1,1,1,1,4,0.010000,0.030000,200,300,54163.374374,30.000000,2.123098,198.604004,4.039800 flow.LoadAppLogic$DatabaseEntry@1784911 true org.apache.derby.impl.jdbc.EmbedStatement40@92fa70 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA java.io.BufferedReader@831c19 42adc10b-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270 112051986299712706,261887437040025450,899251007839,629410100013,3,6294104,54163.374374,1840.02,2565.90,1.095,1.095,8.13,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,198.6299195347268949,3.3769976803421886,0.219,0.219,-999.000000,-999.000000,-999.000000,1.625,23.515,0.027,8.13,5.00,0.151,0.037,300.00,1.00,1.0,1 org.apache.derby.impl.jdbc.EmbedStatement40@1c78066 D:\Personal\challenge\pc3\PC3\SampleData/J062941 false 112001974607522214,261887437030025142,899251007660,629410100011,3,6294103,54163.374374,1355.03,706.68,1.095,1.095,5.70,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,197.4607829714881859,3.3346572222679316,0.219,0.219,-999.000000,-999.000000,-999.000000,1.140,23.900,0.038,5.70,5.00,0.195,0.053,300.00,1.00,1.0,1 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA 6294104,62941,4,1,3,1000.0,100.00,300.0,1.00,38575,12.000,22.037,0.01,0.030,50,75,4096,4096,1.10,1,0.86,0.68,2.00,-999.0,-999.0,0.020,0.050,4,0,990,991,992,993,994,995,996,997,25.000,-0.100,"AST__TAN","AST__TAN",1.000,1.000,1024.000,1024.000,1.000,0.000,0.000,1.000,1,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0. D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION J062941 info.ipaw.pc3.PSLoadWorkflow.LoadConstants$ColumnRange@31dcf0 D:\Personal\challenge\pc3\PC3\SampleData/J062941 info.ipaw.pc3.PSLoadWorkflow.LoadConstants$ColumnRange@afa071 42adc10b-0120-8b08-14df-000000302270 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA ad460131-0120-8b08-14df-000000302270 90) AND "dec" != -999 42adc10b-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA true ad460131-0120-8b08-14df-000000302270 114141976663280727,261887437020023689,899251008415,629410100017,3,6294102,54163.374374,2433.34,2887.41,1.095,1.095,6.88,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,197.6664351372567978,5.1167910741789493,0.220,0.219,-999.000000,-999.000000,-999.000000,1.376,23.696,0.032,6.88,5.00,0.005,0.044,300.00,1.00,1.0,1 42adc10b-0120-8b08-14df-000000302270 -999.000000,-999.000000,1.526,23.584,0.028,7.63,5.00,0.086,0.040,300.00,1.00,1.0,1 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 ad460131-0120-8b08-14df-000000302270 org.apache.derby.impl.jdbc.EmbedResultSet40@1bb3ce6 r, sgSep, dataRelease info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 111731993878304489,261887437040025448,899251006851,629410100007,3,6294104,54163.374374,1188.27,1734.62,1.095,1.095,7.88,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.3878357787176014,3.1117642590922769,0.219,0.219,-999.000000,-999.000000,-999.000000,1.576,23.549,0.028,7.88,5.00,0.321,0.039,300.00,1.00,1.0,1 360) AND ra != -999 9) AND decErr != -999 true 42adc10b-0120-8b08-14df-000000302270 org.apache.derby.impl.jdbc.EmbedStatement40@c77c8 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION 112671979320961807,261887437030025143,899251007686,629410100012,3,6294103,54163.374374,3364.95,1686.83,1.095,1.095,7.43,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,197.9320790249946924,3.8927708567261310,0.220,0.219,-999.000000,-999.000000,-999.000000,1.486,23.613,0.029,7.43,5.00,0.196,0.041,300.00,1.00,1.0,1 111701983841043824,261887437030025145,899251008414,629410100016,3,6294103,54163.374374,1765.90,407.22,1.095,1.095,11.47,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,198.3841345484139538,3.0861333212961197,0.219,0.219,-999.000000,-999.000000,-999.000000,2.294,23.141,0.019,11.47,5.00,0.095,0.027,300.00,1.00,1.0,1 lysisVer, p1Recip, p2Recip, p3Recip, nP2Images, astroScat, photoScat, nAstRef, nPhoRef, expStart, expTime, airmass, raBore, decBore true 111991983087497766,261887437030025146,899251008474,629410100018,3,6294103,54163.374374,1207.67,1350.25,1.095,1.095,15.89,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,198.3087074230189728,3.3312493396607046,0.219,0.219,-999.000000,-999.000000,-999.000000,3.179,22.787,0.014,15.89,5.00,0.319,0.019,300.00,1.00,1.0,1 42adc10b-0120-8b08-14df-000000302270 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 42adc10b-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA ad460131-0120-8b08-14df-000000302270 .70,1.095,1.095,6.40,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.2410872578668659,4.7174852133910221,0.220,0.219,-999.000000,-999.000000,-999.000000,1.281,23.774,0.034,6.40,5.00,0.117,0.047,300.00,1.00,1.0,1 6294103,62941,3,1,3,1000.0,100.00,300.0,1.00,38106,12.000,22.037,0.01,0.030,50,75,4096,4096,1.10,1,0.86,0.68,2.00,-999.0,-999.0,0.020,0.050,3,0,990,991,992,993,994,995,996,997,25.000,-0.100,"AST__TAN","AST__TAN",1.000,1.000,1024.000,1024.000,1.000,0.000,0.000,1.000,1,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0. org.apache.derby.impl.jdbc.EmbedStatement40@c77c8 java.io.BufferedReader@166c4b0 true [Ljava.lang.String;@1bc1a83 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 ad460131-0120-8b08-14df-000000302270 P2Detection ad460131-0120-8b08-14df-000000302270 [Ljava.lang.String;@14f2478 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 [Ljava.lang.String;@1d13c26 info.ipaw.pc3.PSLoadWorkflow.LoadConstants$ColumnRange@8fe392 4,2911.59,3703.98,1.095,1.095,17.04,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,197.7465819161107845,2.9380605970329912,0.219,0.219,-999.000000,-999.000000,-999.000000,3.407,22.711,0.013,17.04,5.00,0.145,0.018,300.00,1.00,1.0,1 ad460131-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 true P2Detection D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION org.apache.derby.impl.jdbc.EmbedStatement40@dda65 ad460131-0120-8b08-14df-000000302270 true jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 org.apache.derby.impl.jdbc.EmbedResultSet40@1387e8c info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 org.apache.derby.impl.jdbc.EmbedStatement40@c77c8 0000,2.410,23.087,0.018,12.05,5.00,0.481,0.025,300.00,1.00,1.0,1 imageID, frameID, ccdID, photoCalID, filterID, bias, biasScat, sky, skyScat, nDetect, magSat, completMag, astroScat, photoScat, nAstRef, nPhoRef, nx, ny, psfFwhm, psfModelID, psfSigMajor, psfSigMinor, psfTheta, psfExtra1, psfExtra2, apResid, dapResid, detectorID, qaFlags, detrend1, detrend2, detrend3, detrend4, detrend5, detrend6, detrend7, detrend8, photoZero, photoColor, projection1, projection2, crval1, crval2, crpix1, crpix2, pc001001, pc001002, pc002001, pc002002, polyOrder, pca1x3y0, pca1x2y1, pca1x1y2, pca1x0y3, pca1x2y0, pca1x1y1, pca1x0y2, pca2x3y0, pca2x2y1, pca2x1y2, pca2x0y3, pca2x2y0, pca2x1y1, pca2x0y2 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 42adc10b-0120-8b08-14df-000000302270 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 org.apache.derby.impl.jdbc.EmbedStatement40@69a380 113051994625753320,261887437010025733,899251008380,629410100014,3,6294101,54163.374374,428.02,3748.25,1.095,1.095,4.41,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.4626106659029574,4.2107381925476721,0.220,0.219,-999.000000,-999.000000,-999.000000,0.882,24.179,0.049,4.41,5.00,0.220,0.069,300.00,1.00,1.0,1 42adc10b-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 org.apache.derby.impl.jdbc.EmbedResultSet40@a07e00 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA 6294101,62941,1,1,3,1000.0,100.00,300.0,1.00,38891,12.000,22.037,0.01,0.030,50,75,4096,4096,1.10,1,0.86,0.68,2.00,-999.0,-999.0,0.020,0.050,1,0,990,991,992,993,994,995,996,997,25.000,-0.100,"AST__TAN","AST__TAN",1.000,1.000,1024.000,1024.000,1.000,0.000,0.000,1.000,1,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0. org.apache.derby.impl.jdbc.EmbedResultSet40@155c5eb D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION 00.00,1.00,1.0,1 true D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA 6294102,62941,2,1,3,1000.0,100.00,300.0,1.00,36791,12.000,22.037,0.01,0.030,50,75,4096,4096,1.10,1,0.86,0.68,2.00,-999.0,-999.0,0.020,0.050,2,0,990,991,992,993,994,995,996,997,25.000,-0.100,"AST__TAN","AST__TAN",1.000,1.000,1024.000,1024.000,1.000,0.000,0.000,1.000,1,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0.,0. D:\Personal\challenge\pc3\PC3\SampleData\J062941\csv_ready.csv java.io.BufferedReader@146877 org.apache.derby.impl.jdbc.EmbedStatement40@137146d true true org.apache.derby.impl.jdbc.EmbedResultSet40@64798e 112571999509798778,261887437040025449,899251007155,629410100008,3,6294104,54163.374374,93.30,1556.03,1.095,1.095,5.44,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,199.9510640091665152,3.8153133613727643,0.220,0.219,-999.000000,-999.000000,-999.000000,1.089,23.950,0.040,5.44,5.00,0.177,0.056,300.00,1.00,1.0,1 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009;create=true jdbc:derby:;databaseName=J062941_LoadDB;user=IPAW;password=pc3_load-2009 42adc10b-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION D:\Personal\challenge\pc3\PC3\SampleData\J062941 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA 1.00,0,-999,-999,2008-05-21,0,198.9360868002645475,4.7469408813337326,0.220,0.219,-999.000000,-999.000000,-999.000000,1.134,23.906,0.038,5.67,5.00,0.252,0.054,300.00,1.00,1.0,1 ad460131-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 ction.csv#P2DETECTION ad460131-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270 false 42adc10b-0120-8b08-14df-000000302270 114091976101640469,261887437020023687,899251006601,629410100005,3,6294102,54163.374374,2821.32,1347.55,1.095,1.095,6.72,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,197.6100750264776593,5.0749909427179052,0.220,0.219,-999.000000,-999.000000,-999.000000,1.344,23.721,0.032,6.72,5.00,0.516,0.045,300.00,1.00,1.0,1 D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv org.apache.derby.impl.jdbc.EmbedStatement40@1836c59 java.io.BufferedReader@18e501c D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA P2ImageMeta ] true 42adc10b-0120-8b08-14df-000000302270 true java.io.BufferedReader@831c19 D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv.hdr true true 42adc10b-0120-8b08-14df-000000302270 java.io.BufferedReader@18e501c D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv#P2DETECTION info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA 42adc10b-0120-8b08-14df-000000302270 ] ad460131-0120-8b08-14df-000000302270 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA ] 302270 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 [Ljava.lang.String;@1dbd0c7 java.io.BufferedReader@166c4b0 D:\Personal\challenge\pc3\PC3\SampleData\J062941\csv_ready.csv D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA org.apache.derby.impl.jdbc.EmbedResultSet40@3729f7 java.io.BufferedReader@146877 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2FrameMeta.csv#P2FRAMEMETA info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 D:\Personal\challenge\pc3\PC3\SampleData/J062941\P2_J062941_B001_P2fits0_20081115_P2ImageMeta.csv#P2IMAGEMETA 42adc10b-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 J062941 true info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 9) AND raErr != -999 org.apache.derby.impl.jdbc.EmbedResultSet40@16c4812 D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv D:\Personal\challenge\pc3\PC3\SampleData\J062941\P2_J062941_B001_P2fits0_20081115_P2Detection.csv.hdr 51008506,629410100019,3,6294103,54163.374374,178.01,2595.33,1.095,1.095,10.57,5.00,0.86,0.68,2.00,0.00,1.00,0,-999,-999,2008-05-21,0,198.2657872174975182,3.8711163546958325,0.220,0.219,-999.000000,-999.000000,-999.000000,2.113,23.230,0.021,10.57,5.00,-0.220,0.029,300.00,1.00,1.0,1 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 info.ipaw.pc3.PSLoadWorkflow.LoadAppLogic$DatabaseEntry@1784911 true 42adc10b-0120-8b08-14df-000000302270 ad460131-0120-8b08-14df-000000302270 42adc10b-0120-8b08-14df-000000302270