2021-12-03T14:19:57Z 20 \getConfig{web}{sitename} Obscore Form This is a form-based service allowing users to run simple queries against \getConfig{web}{sitename}'s ivoa.obscore table, with some nods to users looking of data near the optical waveband. For serious use, the `obscore table`_ should be queried through TAP. Note that queries without spatial constraints may take time out. You probably ought to switch to async TAP if you really want to run such queries. .. _obscore table: /tableinfo/ivoa.obscore?tapinfo=true virtual-observatories \metaString{publisher} \getConfig{web}{serverURL} Research Archive with base.getTableConn() as conn: for row in conn.query("SELECT spatial, temporal, spectral" " FROM dc.rdmeta" " WHERE sourcerd='__system__/obscore'"): if None in row: # If any part of coverage is missing, skip the whole thing return yield { "spatial": row[0], "temporal": " ".join(str(v) for v in row[1]), "spectral": " ".join(str(v) for v in row[2])} \spatial \temporal \spectral obscore web from gavo import base with base.getTableConn() as conn: limits = dict((r[0], r[1:]) for r in conn.query("SELECT column_name, min_value, max_value" " FROM dc.simple_col_stats" " WHERE tablename='ivoa.ObsCore'" " AND column_name in ('em_min', 'em_max')")) if limits: yield {"obscore_emmin": utils.formatFloat(float(limits["em_min"][0])*1e10), "obscore_emmax": utils.formatFloat(float(limits["em_max"][1])*1e10)} \obscore_emmin .. \obscore_emmax obscore = parent.parent.queriedTable minCol = svcs.InputKey.fromColumn( obscore.getColumnByName("em_min"), inputUnit="Angstrom") maxCol = svcs.InputKey.fromColumn( obscore.getColumnByName("em_max"), inputUnit="Angstrom") try: tree = vizierexprs.parseNumericExpr(inPars[inputKeys[0].name]) except utils.ParseException as msg: raise base.ValidationError( f"Bad VizieR syntax: {msg}", "BAND") res = vizierexprs.NumericIntervalFlattener( ).getSQLFor(tree, (minCol, maxCol), outPars) yield res from gavo import base, stc with base.getTableConn() as conn: limits = dict((r[0], r[1:]) for r in conn.query("SELECT column_name, min_value, max_value" " FROM dc.simple_col_stats" " WHERE tablename='ivoa.ObsCore'" " AND column_name in ('t_min', 't_max')")) if limits: yield {"obscore_tmin": stc.mjdToDateTime(float(limits["t_min"][0]) ).date().isoformat(), "obscore_tmax": stc.mjdToDateTime(float(limits["t_max"][1]) ).date().isoformat()} \obscore_tmin .. \obscore_tmax obscore = parent.parent.queriedTable minCol = svcs.InputKey.fromColumn( obscore.getColumnByName("t_min")) maxCol = svcs.InputKey.fromColumn( obscore.getColumnByName("t_max")) try: tree = vizierexprs.parseDateExprToMJD(inPars[inputKeys[0].name]) except utils.ParseException as msg: raise base.ValidationError( f"Bad VizieR syntax: {msg}", "BAND") res = vizierexprs.NumericIntervalFlattener( ).getSQLFor(tree, (minCol, maxCol), outPars) yield res return "x".join(str(s) if s else "1" for s in data) web self.assertHasStrings("<p>Matched: ") web self.assertHasStrings("<p>Matched: ") web self.assertHasStrings("<p>Matched: ") web self.assertHasStrings("<p>Matched: ")