...
Code Block | ||
---|---|---|
| ||
-- Data ID search for raw (uniqueness=GLOBAL) in any collection:
SELECT uid, site FROM dataset_raw WHERE instrument=? AND exposure=? AND detector=?;
-- Data ID search for object (uniqueness=STANDARD) in a type=RUN collection:
SELECT uid, site FROM dataset_object
WHERE run_uid=? AND site=? AND skymap=? AND tract=? AND patch=?;
-- Data ID search for object (uniqueness=STANDARD) in a type=TAGGED collection:
SELECT uid, site FROM dataset_tag_object
WHERE collection=? AND skymap=? AND tract=? AND patch=?;
-- Temporal search for bias (uniqueness=NONSINGULAR) in a type=CALIBRATION collection:
SELECT uid, site FROM dataset_validity_bias
WHERE collection=? AND instrument=? AND detector=? AND datetime_begin < ? AND datetime_end > ?; |
...