...
Host info: http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Test dbserv (Kotlin version): http://lsst-qserv-dax01:8080/sync (Logical database name is a required part of database name. For example, sdss_stripe82_01 should appear as W13_sdss_v2.sdss_stripe82_01 in the queries. "W13_sdss_v2" is logical database name.)
First data set: SDSS stripe 82
DB Name:
"sdss_stripe82_
...
01"
DB Tables:
Catalogs:
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+qserv_areaspec_circle(9.469,-1.152,0.01);' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+qserv_areaspec_box(9.5,-1.23,9.6,-1.22);' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+qserv_areaspec_ellipse(9.469,-1.152,58,36,0);' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepForcedSource+WHERE+qserv_areaspec_poly(9.4, -1.2, 9.6, -1.2, 9.4, -1.1);' \
...
curl -o imagesContainTarget.json -d 'query=SELECT+*+FROM+sdss_stripe82_0001.DeepCoadd+WHERE+\
scisql_s2PtInCPoly(9.462, -1.152, corner1Ra, corner1Decl, corner2Ra, corner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl)=1;' \
...
curl -o imagesContainTheRegion.json -d 'query=SELECT+*+FROM+sdss_stripe82_0001.Science_Ccd_Exposure+WHERE+\
...
curl -o imagesContainedByTheRegionBox.json -d 'query=SELECT+*+FROM+sdss_stripe82_0001.Science_Ccd_Exposure+WHERE+\
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+scisql_s2PtInCircle(coord_ra,coord_decl,9.469,-1.152,0.01)=1;' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+scisql_s2PtInBox(coord_ra,coord_decl,9.5,-1.23,9.6,-1.22)=1;' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepSource+WHERE+scisql_s2PtInEllipse(coord_ra,coord_decl,9.469,-1.152,58,36,0)=1;' \
...
-d 'query=SELECT+*+FROM+sdss_stripe82_0001.RunDeepForcedSource+WHERE+scisql_s2PtInCPoly(coord_ra,coord_decl,9.4, -1.2, 9.6, -1.2, 9.4, -1.1)=1;' \
...
-d 'query=SELECT+<column names>+FROM+sdss_stripe82_0001.RunDeepForcedSource+WHERE+objectId=OBJ_ID;' \
...
-d 'query=SELECT+count(*)+FROM+sdss_stripe82_0001.RunDeepForcedSource+WHERE+objectId=3448068867358968;' \
...
(2) Imgserv (pixel data retrieval), see ImageServ API - v1[CurrentDeprecated]:
"Aliveness" checks:
Is imgserv running?
...
curl -d 'query=SELECT objectId, id, fsrc.exposure_id, fsrc.exposure_time_mid, exp.run, scisql_dnToAbMag(fsrc.flux_psf,exp.fluxMag0) AS g, scisql_dnToAbMagSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, exp.fluxMag0Sigma) AS gErr \
FROM sdss_stripe82_0001.RunDeepForcedSource AS fsrc, sdss_stripe82_0001.Science_Ccd_Exposure AS exp WHERE exp.scienceCcdExposureId = fsrc.exposure_id AND fsrc.exposure_filter_id=1 AND objectId=3448068867358968 \
...
SELECT
objectId,
id,
fsrc.exposure_id,
fsrc.exposure_time_mid,
exp.run,
scisql_dnToAbMag(fsrc.flux_psf, exp.fluxMag0) AS g,
scisql_dnToAbMagSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, exp.fluxMag0Sigma) AS gErr
FROM
sdss_stripe82_0001.RunDeepForcedSource AS fsrc,
sdss_stripe82_0001.Science_Ccd_Exposure AS exp
...
curl -d 'query=SELECT objectId, id, fsrc.exposure_id, fsrc.exposure_time_mid, exp.run, scisql_dnToFlux(fsrc.flux_psf,exp.fluxMag0) AS tsv_flux, scisql_dnToFluxSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, exp.fluxMag0Sigma) AS tsv_fluxErr \
FROM
sdss_stripe82_0001.RunDeepForcedSource AS fsrc,
sdss_stripe82_0001.Science_Ccd_Exposure AS exp
...
SELECT
objectId,
id,
fsrc.exposure_id,
fsrc.exposure_time_mid,
exp.run,
scisql_dnToFlux(fsrc.flux_psf, exp.fluxMag0) AS tsv_flux,
scisql_dnToFluxSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, exp.fluxMag0Sigma) AS tsv_fluxErr
FROM
sdss_stripe82_0001.RunDeepForcedSource AS fsrc,
sdss_stripe82_0001.Science_Ccd_Exposure AS exp
...