Coordinated microlensing survey observations with Kepler K2/C9 using VST The Kepler satellite has observed the Galactic center in a campaign lasting from April until the end of June 2016 (K2/C9). The main objective of the 99 hours for the microlensing program 097.C-0261(A) using the ESO VLT Survey Telescope (VST) was to monitor the superstamp (i.e., the actually downloaded region of K2/C9) in service mode for improving the event coverage and securing some color-information. Due to weather conditions, the majority of images were taken in the red band. These are part of the present release. The exact pointing strategy was adjusted to cover the superstamp with 6 pointings and to contain as many microlensing events from earlier seasons as possible. In addition, a two-point dither was requested to reduce the impact of bad pixels and detector gaps. Consequently, some events were getting more coverage and have been observed with different CCDs. The large footprint of roughly 1 square degree and the complementary weather conditions at Cerro Paranal have lead to the coverage of 147 events (this resource's events table), but ~60 of those were already at baseline. 2017-04-05T08:00:00Z 100 light-curves exoplanets gravitational-microlensing time-domain-astronomy Hundertmark, M.; Korhonen, H.; Jørgensen, U.; Street, R; Penny, M.; Tsapras, Y.; Dominik, M.; Kerins, E.; Cassan, A.; Snodgrass, C.; Bachelet, E.; Bramich, D.; Bozza, V. VST ESO pointed archival http://archive.eso.org/wdb/wdb/eso/sched_rep_arc/query?progid=097.C-0261(A) Research Archive timeseries Optical ivo://org.gavo.dc/~?k2c9vst/data/ K2/C9 Microlensing Events Time UTC HELIOCENTER "t_0" Position ICRS Epoch J2000.0 "raj2000" "dej2000" 5/7198,7216-7217,7220-7221,7226-7227,7266 6/28782-28783,28796,28798-28799,28823,28829,28854-28855,28860-28861,28863,28872-28873,28875-28877,28888-28889,28892-28893,28898,28902-28903,28920,28922-28923,29056,29058-29059,29205,29253,29255,29261 56693 57663 t_e: t_E(d), t_0: t_0(HJD), t_alert: t_alert(HJD), u_0: u_0(E), a_0: A_0, ogle_name: Ogle Name, moa_name: MOA Name Each event needs a unique id; there are records that were detected both by MOA and by OGLE; we expand them to two different events. On the other hand, some events have no positions. These we swallow. if @RA=='00:00:00': return if @ogle_name: @event_id = @ogle_name yield row if @moa_name: @event_id = @moa_name yield row 1*("Y"==vars["During Campaign"] )+2*("Y"==vars["In Footprint"] )+4*("Y"==vars["In Superstamp"]) The columns common to the photpoints table and the time series instance. These are the coefficients of the transformation polynoms of the reference frame to the transformed reference frame (for which the kernel is computed). The transformation equations are:: xct = c[0]*xc + c[1]*yc + dx yct = c[2]*xc + c[3]*yc + dy where c is given in corr_coeff, dx and dy are from the columns, Photometric Points Obtained by K2/C9 followup previews image, obs_time, df, e_df, rf, e_rf, phot, e_phot, cal_mag, exp_time, fwhm, sky_background, airmass, phot_scale_factor, chi2_px, dx, dy, a, b, c, d rd.getById("subparse") accref = getInputsRelativePath(self.sourceToken) pubdid = getStandardPubDID(accref) yield "products", locals() event_id = accref.split("/")[-1].split("_")[0] for row in subGrammar.parse(self.sourceToken): row["event_id"] = event_id row["accref"] = accref yield "points", row @accref "\schema.photpoints" "application/votable+xml" \fullDLURL{dl} \standardPreviewPath "image/png" \inputRelativePath.split("/")[-1] //ssap#mixc//obscore#publishSSAPMIXC1 CREATE MATERIALIZED VIEW \curtable AS ( SELECT \colNames FROM ( SELECT '\schema/data/' || did as accref, CAST (NULL as text) as owner, CAST (NULL as date) as embargo, 'application/x-votable+xml'::TEXT as mime, 20000 as accsize, 'K2C9 VST ' || did as ssa_dstitle, CAST (NULL as text) as ssa_creatordid, '\pubdidroot' || did as ssa_pubDID, CAST (NULL as timestamp) as ssa_cdate, NOW()::timestamp as ssa_pdate, 'SDSS r'::text as ssa_bandpass, CAST (NULL as text) as ssa_cversion, event_id as ssa_targname, 'LensingEv'::text as ssa_targclass, CAST (NULL as real) as ssa_redshift, spoint(RADIANS(raj2000), RADIANS(dej2000)) as ssa_targetpos, CAST (NULL as real) as ssa_snr, spoint(RADIANS(raj2000), RADIANS(dej2000)) as ssa_location, avg_aperture/3600. as ssa_aperture, t_0 as ssa_dateObs, (obs_end-obs_start)*3600*24 as ssa_timeExt, CAST (5.8e-7 as real) as ssa_specmid, CAST (1.5e-7 as real) as ssa_specext, CAST (5e-7 as real) as ssa_specstart, CAST (6.5e-7 as real) as ssa_specend, n_points as ssa_length, 'timeseries'::text as ssa_dstype, '\metaString{publisher}'::TEXT as ssa_publisher, 'Hundertmark, M.; et al'::TEXT as ssa_creator, 'K2C9 VST'::TEXT as ssa_collection, 'VST'::TEXT as ssa_instrument, '\metaString{ssap.dataSource}'::text as ssa_datasource, '\metaString{ssap.creationType}'::text as ssa_creationtype, 'TBD'::TEXT as ssa_reference, avg_err as ssa_fluxStatError, CAST (NULL as real) as ssa_fluxSysError, CAST ('UNCALIBRATED' as text) as ssa_fluxcalib, CAST (NULL as real) as ssa_binsize, CAST (NULL as real) as ssa_spectStatError, CAST (NULL as real) as ssa_spectSysError, CAST ('UNCALIBRATED' as text) as ssa_speccalib, CAST (NULL as real) as ssa_specres, obs_start as t_min_mjd, obs_end as t_max_mjd, t_0 as t_0 FROM \schema.events JOIN ( SELECT did, event_id, min(obs_time)-2400000.5 as obs_start, max(obs_time)-2400000.5 as obs_end, count(*) as n_points, avg(e_df) as avg_err, avg(fwhm) as avg_aperture FROM \schema.photpoints GROUP BY did, event_id) as obses USING (event_id) ) as col_defs ) //timeseries#phot-0 (ivoa:Measurement) { value: @df statError: @e_df } (ivoa:Measurement) { value: @phot statError: @e_phot } (ds:Dataset) { dataProductType: TIMESERIES title: @title curation: (ds:Curation) { calibLevel: 1 publisher: (ds:Publisher) { name: "GAVO Data Center" publisherId: "ivo://org.gavo.dc" } publisherDID: @pubdid } } (ndcube:Cube) { independent_axes: [@obs_time] dependent_axes: [@df @phot] } (phot:PhotCal) { filterIdentifier: "VST/OmegaCAM.r_SDSS" effectiveWavelength: 6.25e-7 value: @df } did = self.sourceToken["accref"].split("/")[-1] evpat = did.split("_")[0]+"%" td = rd.getById("events") row = td.doSimpleQuery( fragments="event_id like %(evpat)s", params=locals())[0] row["id"] = did return row did = self.sourceToken["accref"].split("/")[-1] td = rd.getById("photpoints") return td.doSimpleQuery(fragments="did=%(did)s", params=locals()) K2/C9 VST datalink service "k2c9vst/q#timeseries" False "#timeseries" from gavo import rsc descriptor.data = rsc.makeData( rd.getById("make_instance"), forceSource=descriptor.ssaRow) from gavo.formats import votablewrite return ("application/x-votable+xml;version=1.5", votablewrite.getAsVOTable(descriptor.data, version=(1,5))) K2C9 VST Time Series Browser Interface if inPars["t_0"]: from gavo.svcs import vizierexprs expr = vizierexprs.parseDateExpr(inPars["t_0"]) newPars = {} fragment = expr.asSQL(inputKeys[0], newPars) for key, val in newPars.iteritems(): outPars[key] = dateTimeToJdn(val) yield fragment ssa_dstitle, t_0, t_min_mjd, t_max_mjd VOTable k2c9vst ssap query ssap.dataSource: pointed ssap.testQuery: MAXREC=1 ssap.creationType: archival auto lit = inPars["TIME"] if lit is None: return ranges = pql.PQLFloatPar.fromLiteral(lit, 'TIME') if ranges is None: # null string return yield ranges.getSQLForInterval( "t_min_mjd", "t_max_mjd", outPars) ssa/ssap.xml rows = self.getVOTableRows() self.assertEqual(len(rows), 1) row = rows[0] self.assertAlmostEqual(row['ssa_dateObs']/2457545.952, 1) self.assertTrue(row["accref"].endswith( "/getproduct/k2c9vst/data/OGLE-2016-BLG-0979_VST_r_SDSS67.t"), "Bad accref") /getproduct/k2c9vst/data/OGLE-2016-BLG-0979_VST_r_SDSS67.t self.assertXpath("//v:PARAM[@name='raj2000']", { "value": "270.97629166666667" }) self.assertXpath("//v:PARAM[@name='title']", { "value": "K2C9 VST OGLE-2016-BLG-0979_VST_r_SDSS67.t", "ucd": "meta.title;obs"}) rows = self.getVOTableRows() self.assertEqual(len(rows), 32) self.assertAlmostEqual(rows[0]["obs_time"], 2457490.82951368) self.assertAlmostEqual(rows[-1]["corr_coeff"][2], 1.8290700551371053e-11) dl/dlget self.assertHTTPStatus(404) self.assertHasStrings("No spectrum with this pubDID known here", "~?k2c9/borken") /getproduct/k2c9vst/data/OGLE-2016-BLG-0979_VST_r_SDSS67.t?preview=True self.assertHasStrings(b"\\x89PNG", b"\\x7e\\xbd\\xc0\\xd7\\xc0\\xb8")