Open Access
Table B.3
Example of a hard query.
| Request | Find all detections, non-detections and forced photometry points for the ZTF object ’ZTF24aamtvxb’. Return all epochs in the same output table, including the following columns: ZTF identifier, epoch date, filter identifier, isdiffpos flag, detection difference magnitude and its uncertainty, 5-sigma magnitude limit, forced difference magnitude and its uncertainty, and a column named ‘table’ (that contains the name of the table of origin for each epoch) |
|---|---|
| Gold SQL Query | SELECT oid, mjd, fid, isdiffpos, magpsf, sigmapsf, NULL as diffmaglim, CAST(NULL AS bigint) as mag, CAST(NULL AS bigint) as e_mag, ’detection’ as table FROM detection WHERE oid = ’ZTF24aamtvxb’ UNION ALL SELECT oid, mjd, fid, NULL as isdiffpos, NULL as magpsf, NULL as sigmapsf, diffmaglim, CAST( NULL AS bigint) as mag , CAST( NULL AS bigint) as e_mag, ’non_detection’ as table FROM non_detection WHERE oid = ’ZTF24aamtvxb’ UNION ALL SELECT oid, mjd, fid, isdiffpos, NULL as magpsf, NULL as sigmapsf, NULL as diffmaglim, mag, e_mag , ’forced_photometry’ as table FROM forced_photometry WHERE oid = ’ZTF24aamtvxb’ |
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.