ivo://\getConfig{ivoa}{authority}/~?\rdId/
2018-07-18T11:44:26Z
20
BGDS time series
From the Bochum Galactic Disk Survey, time series have been obtained in the
r and i bands on an (up to) nightly basis. Depending on the field, the time
series contain up to more than 300 nights over more than 7 years. Each
measurement represents the averaged flux over 10 minutes of observation
(from 9 averaged 10s images).
The Bochum Galactic Disk Survey is an ongoing project to monitor the
stellar content of the Galactic disk in a 6 degree wide stripe centered on
the Galactic plane. The data has been recorded since mid-2010 in Sloan r
and i simultaneously with the Robotic Bochum Twin Telescope (RoBoTT) at the
Universitaetssternwarte Bochum near Cerro Armazones in the Chilean Atacama
desert. It contains measurements of about 2x10^7 stars over more than seven
years. Additionally, intermittent measurements in Johnson UVB and Sloan z
have been recorded as well.
ivo://org.gavo.dc/bgds/l2/ssaBGDS DR2 Lightcurves
surveys
galaxy-planes
milky-way-galaxy
variable-stars
broad-band-photometry
time-domain-astronomy
Hackstein, M.; Haas, M.; Fein, C.; Chini, R.
Robotic Bochum Twin Telescope (RoBoTT)
Universitätssternwarte Bochum near Cerro
Armazones
2015AN....336..590H
Research
Survey
timeseries
If you use GDS data, please cite
:bibcode:`2015AN....336..590H`.
BGDS light curves DR2
Optical
Position ICRS "ra" "dec"
ra:RA, dec:DEC,
err_mag: MAGERR,
amp: AMP,
flux: FLUX, err_flux: FLUXERR,
nobs: NOBS,
re.search("GDS_([^/]*)", \\\\inputRelativePath).group(1)
band, filter, pathspec
b, Johnson B, B_j
u, Johnson U, U_j
v, Johnson V, V_j
z, SDSS z, z_s
//scs#pgs-pos-index
BGDS wideband photometry in the \filter band. A union of all
the BGDS measurements is available in phot_all.
obs_id
band, filter, pathspec
i, SDSS i, i_s
r, SDSS r, r_s
//scs#pgs-pos-index
BGDS mean broadband photometry and lightcurves measurements
in the \filter band. All BGDS broadband mean photometry
is available in phot_all.
('\\pubDIDBase' || obs_id)
All mean photometry of bgds in one table. It may be simpler
to write queries against the split-band tables phot_band.
Measurements in different fields and bands have not been merged, as
that procedure is too error-prone in crowded milky way regions.
CREATE VIEW \curtable AS (SELECT \colNames FROM (
SELECT 'Johnson B' as band_name,
b.*
FROM \schema.phot_b as b
UNION ALL
SELECT 'Johnson U' as band_name,
u.*
FROM \schema.phot_u as u
UNION ALL
SELECT 'Johnson V' as band_name,
v.*
FROM \schema.phot_v as v
UNION ALL
SELECT 'SDSS z' as band_name,
z.*
FROM \schema.phot_z as z
UNION ALL
SELECT 'SDSS i' as band_name,
obs_id, ra, dec, mean_mag, err_mag, amp, flux, err_flux, nobs
FROM \schema.phot_i as i
UNION ALL
SELECT 'SDSS r' as band_name,
obs_id, ra, dec, mean_mag, err_mag, amp, flux, err_flux, nobs
FROM \schema.phot_r as r
) as allbands)
BGDS mean phot
BGDS Mean Photometry Cone Search
Extracted sources from the Bochum Galactic
Disk Survey. We provide mean photometry in U, B, V, z, r, and i
bands. Note that sources in different bands are not matched.
Also, sources sitting in the regions imaged in multiple fields
have not been matched even within one band.
In i and r, BGDS light curves are available. See related
services for details.
testQuery.ra: 100.14501
testQuery.dec: -1.65446
testQuery.sr: 0.0001
This table contains about metadata about the photometric time
series from BGDS in IVOA SSA format. The actual data is
available through a datalink service or in the phot_i and
phot_r tables.
tsdl
ssa_pubDID
//ssap#mixc
TimeInterval UTC TOPOCENTER "time_min" "time_max"
CREATE VIEW \curtable AS (SELECT \colNames FROM
(SELECT
obs_id as obs_id,
amp as amp,
mean_mag as mean_mag,
field as field,
'\getConfig{web}{serverURL}/bgds/l/tsdl/dlget?ID='||obs_id as accref,
NULL::text as owner,
NULL::date as embargo,
'application/x-votable+xml'::TEXT as mime,
10000 as accsize,
'BGDS ' || band || ' time series for ' || obs_id as ssa_dstitle,
NULL::text as ssa_creatorDID,
'\pubDIDBase' || obs_id as ssa_pubDID,
NULL::timestamp as ssa_cdate,
NULL::timestamp as ssa_pdate,
band as ssa_bandpass,
NULL::text as ssa_cversion,
field as ssa_targname,
NULL::text as ssa_targclass,
NULL::real as ssa_redshift,
NULL::spoint as ssa_targetpos,
NULL::real as ssa_snr,
NULL::real as ssa_aperture,
ssa_location,
time_mean as ssa_dateObs,
time_max-time_min as ssa_timeExt,
specmid as ssa_specmid,
specend-specstart as ssa_specext,
specstart as ssa_specstart,
specend as ssa_specend,
length as ssa_length,
'timeseries'::TEXT as ssa_dstype,
'ivo://org.gavo.dc/org'::TEXT as ssa_publisher,
'Hackstein, M. et al'::TEXT as ssa_creator,
'BGDS time series'::TEXT as ssa_collection,
'\metaString{instrument}'::TEXT as ssa_instrument,
'survey'::TEXT as ssa_datasource,
'archival'::TEXT as ssa_creationtype,
'\metaString{source}'::TEXT as ssa_reference,
NULL::real as ssa_fluxStatError,
NULL::real as ssa_fluxSysError,
'ABSOLUTE'::TEXT as ssa_fluxcalib,
NULL::real as ssa_binSize,
NULL::real as ssa_spectStatError,
NULL::real as ssa_spectSysError,
'ABSOLUTE'::TEXT as ssa_speccalib,
NULL::real as ssa_specres,
time_min as time_min,
time_max as time_max,
ra as ra,
dec as dec,
mjds as mjds,
mags as mags
FROM (
SELECT
'SDSS i' as band,
6.65e-7 as specstart,
8.39e-7 as specend,
7.44e-7 as specmid,
* FROM \schema.phot_i
UNION ALL
SELECT
'SDSS r' as band,
5.42e-7 as specstart,
6.99e-7 as specend,
6.12e-7 as specmid,
* FROM \schema.phot_r) as src) as q)
Bochum Galactic Disk Survey (BGDS) light
curves browser service
accref, ssa_bandpass, mean_mag, amp
BGDS TS SSAP
survey
archival
MAXREC=1
query
Bochum Galactic Disk Survey (BGDS) light
curves
This service exposes the
Light curves of stars produced by the Bochum Galactic Disk Survey;
several million light curves are provided in the SDSS i and r bands.
The lightcurves are published per-band. This is DR1; for new
work, use DR2
parsed = pql.PQLFloatPar.fromLiteral(
inPars.get("TIME", None), "TIME")
yield parsed.getSQLForInterval(
"time_min", "time_max", outPars)
band_short, band_human, band_ucd, effective_wavelength
i, SDSS/i, em.opt.I, 7.44e-7
r, SDSS/r, em.opt.R, 6.12e-7
epochs, mags, errors = (
self.sourceToken.row["mjds"],
self.sourceToken.row["mags"],
self.sourceToken.row["mag_errs"])
labels = ["obs_time", "phot", "mag_error"]
for tup in zip(epochs, mags, errors):
res = dict(zip(labels, tup))
res["field"] = self.sourceToken.row["field"]
yield res
with base.getTableConn() as conn:
res = list(conn.queryToDicts(
"SELECT * FROM \schema.ssa_time_series WHERE obs_id=%(obs_id)s"
" LIMIT 2",
{"obs_id": self.sourceToken.obsId}))
return res[0]
pars = targetTable.getParamDict()
imgId = "MAGIC/%s/%s/%f"%(
pars["field"], pars["filter"], @obs_time)
@stamp_url = ("http://dc.g-vo.org/bgds/q/dl/dlget?ID="
+urllib.parse.quote(imgId)
+"&CIRCLE=%s+%s+%s"%(pars["ra"], pars["dec"], 0.01))
BGDS time series datalink
This service produces time series datasets for Bochum
Galactic Disk Survey lightcurves.
from gavo import svcs
class TSDescriptor(ProductDescriptor):
def __init__(self, pubDID):
# We accept "local" pubDIDs (without ivo://...?), too
if pubDID.startswith("ivo://"):
self.pubDID = pubDID
self.obsId = pubDID.split("?")[-1].split("/")[-1]
else:
self.obsId = pubDID
self.pubDID = '\pubDIDBase'+pubDID
self.band = self.obsId.split("-")[3]
# ward off SQL injection
if self.band not in "ir":
raise svcs.UnknownURI(
"No time series for band %s"%self.band)
self.suppressAutoLinks = True
with base.getTableConn() as conn:
res = list(conn.queryToDicts(
"SELECT * FROM \schema.phot_%s"
" WHERE obs_id=%%(obsId)s"%self.band,
{"obsId": self.obsId}))
if not res:
raise svcs.UnknownURI(
"BGDS has no lightcurve for %s"%self.obsId)
self.row = res[0]
return TSDescriptor(pubDID)
yield descriptor.makeLink(
makeAbsoluteURL("\rdId/tsdl/dlget?ID=%s"%(descriptor.pubDID)),
description="BGDS time series for %s."%(
descriptor.obsId),
contentType="application/x-votable+xml",
contentLength=15000,
contentQualifier="#timeseries")
yield descriptor.makeLink(
makeAbsoluteURL("\rdId/preview/qp/%s"%(descriptor.obsId)),
description="Preview for %s"%descriptor.obsId,
contentType="image/png",
contentLength="2000")
from gavo import rsc
dd = rd.getById("make_instance")
descriptor.data = rsc.Data.createWithTable(dd,
rd.getById("instance_"+descriptor.band))
descriptor.data = rsc.makeData(
dd,
data=descriptor.data,
forceSource=descriptor)
from gavo import formats
return (base.votableType,
formats.getFormatted("vodml", descriptor.data))
obs_id
A service returning PNG thumbnails for time series. It takes
the obs id for which to generate a preview from the remaining
fragments.
from gavo.svcs import UnknownURI
from gavo.helpers.processing import SpectralPreviewMaker
obsId = inputTable.getParam("obs_id")
# always go through a mapping here or you'll create a SQL injection.
try:
srcTable = {
"r": "bgds.phot_r",
"i": "bgds.phot_i",
}[obsId.split("-")[3]]
except KeyError:
raise UnknownURI("No time series in the %s band here"%
obsId.split("-")[3])
with base.getUntrustedConn() as conn:
res = list(conn.query(
"SELECT mjds, mags FROM %s WHERE obs_id=%%(obs_id)s"%
srcTable, {"obs_id": obsId}))
if not res:
raise UnknownURI("No time series for obs id %s."%obsId)
return "image/png", SpectralPreviewMaker.get2DPlot(
list(zip(*res[0])))
meanphot/scs.xml
rows = self.getVOTableRows()
rows.sort(key=lambda r: r["band_name"])
self.assertTrue(set(r["band_name"] for r in rows).issuperset(
set(["Johnson B", "SDSS z"])))
self.assertAlmostEqual(rows[0]["mean_mag"], 17.506620407104492)
self.assertEqual(rows[-1]["obs_id"], "BGDS-0644-0035-z-100.1449700-1.6543900")
ssa/ssap.xml
rows = self.getVOTableRows()
self.assertEqual(len(rows), 1)
self.assertEqual(rows[0]["ssa_pubDID"],
"ivo://org.gavo.dc/~?bgds/l/BGDS-0644-0035-i-100.1144144-1.6555938")
self.assertAlmostEqual(rows[0]["time_max"], 57800.038588)
self.assertTrue(rows[0]["accref"].endswith(
"bgds/l/tsdl/dlget?ID=BGDS-0644-0035-i-100.1144144-1.6555938"))
tsform/form',
'
SDSS i
',)
]]>tsdl/dlget
row = self.getFirstVOTableRow(rejectExtras=False)
self.assertAlmostEqual(row["obs_time"], 55467.348507)
self.assertAlmostEqual(row["phot"], 16.1383553, 6)
self.assertEqual(row["stamp_url"],
EqualingRE(r"http://dc.g-vo.org/bgds/q/dl/dlget\\?ID=MAGIC/0644-0035/SDSS%20i/55467.348507&CIRCLE=100.11441440.*\\+-1.6555938008.*\\+0.01"))
self.assertXpath("//v:GROUP[@name='photcal']"
"/v:PARAM[@name='filterIdentifier']", dict(
ucd="meta.id;instr.filter",
value="SDSS/i"))
tsdl/dlmeta
bySemantics = dict((row["semantics"], row)
for row in self.getVOTableRows())
self.assertTrue(bySemantics["#this"]["access_url"].endswith(
"/bgds/l/tsdl/dlget?ID=ivo://org.gavo.dc/~"
"?bgds/l/BGDS-0644-0035-r-100.2782207-1.6564102"))
self.assertEqual(bySemantics["#this"]["content_qualifier"],
"#timeseries")
self.assertTrue(bySemantics["#preview"]["access_url"].endswith(
"/bgds/l/preview/qp/BGDS-0644-0035-r-100.2782207-1.6564102"))
preview/qp/BGDS-0644-0035-b-100.2782207-1.6564102
self.assertHasStrings("No time series in the b band here")
self.assertHTTPStatus(404)
preview/qp/BGDS-0644-0035-r-100.2782207-1.6564102
self.assertHasStrings(
"PNG",
"qV0r")
# well, the latter is just binary nonsense and is subject to change