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#publishSSAPMIXC
1
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")