Date: Thu, 28 Mar 2024 11:46:11 +0000 (UTC) Message-ID: <1549752168.18981.1711626376730@confluence> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_18980_1496524746.1711626371669" ------=_Part_18980_1496524746.1711626371669 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
curl -d 'query=3DSHOW+DATABASES' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync<=
/code>
curl -d 'query=3DSHOW+TABLES' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync=
(show default DB tables)curl -d 'query=3DSHOW TABLES IN wise_2band_00;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0=
/tap/sync
curl -d 'query=3DSELECT+COUNT(*)+FROM+RunDeepSource' http://lsst-qserv-dax01.ncsa.illinois.edu:=
5000/db/v0/tap/sync
Host info: http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sy= nc
Test dbserv (Kotlin version): http://lsst-qserv-dax01:8080/sync (Logical da= tabase 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.)
DB Tables:
 = ; Catalogs:
 = ; Object (Measurements on coadds): table name =3D "R= unDeepSource"
 = ; Forced photometry based on i-band coadds: table name =3D = "RunDeepForcedSource"
 = ; Images:
 = ; Single-band coadded image metadata: table name =3D <= /span>"Science_Ccd_Exposure"
 = ; Calibrated single-epoch image metadata: table name = =3D "DeepCoadd"
The summary of the data loaded is capture in = this ticket: - Getting issue details...= STATUS
1st DB:
&n= bsp; wise_00
T= ables:
&n= bsp; allwise_p3as_psd (source catalog)
&n= bsp; allwise_p3as_mep (forced source catalog)
2= nd DB:
&n= bsp; wise_ext_00
T= ables:
&n= bsp; allwise_p3as_psr (rejected source catalog)
3= rd DB:
&n= bsp; neowiser_yr1_00
Tables:
&n= bsp; neowiser_yr1_p1bs_psd (NEOW= ISE-R Year 1 Single Exposure (L1b) Source Table)
Images:
D= B:
&n= bsp; wise_00
T= ables:
&n= bsp; allwise_p3am_cdd (Atlas coadd images)
&n= bsp; allwise_p3as_cdd (Atlas meta table)
&n= bsp; allsky_4band_p1bm_frm (single exposure images)
&n= bsp; allsky_3band_p1bm_frm (single expsoure images)
&n= bsp; allsky_2band_p1bm_frm (single exposure images)
See detail and updat= ed information about WISE data in PDAC in PDAC v2 data list.
Recommended RA and D= ec to search for WISE: any
 = ; cone, box, ellipse, polygon
Inputs: = ; RA, DEC, radius (all in degree)
URL:<= /p>
 = ; curl -o <output file> \
 = ; -d 'query=3DSELECT+<column names>+FROM+<database n= ame>.<table name>+WHERE+qserv_areaspec_circle(<RA>,&l= t;DEC>,<radius>);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Examples:
 = ; curl -o runDeepSourceConeSdss.json \
 = ; -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.RunDeepSo= urce+WHERE+qserv_areaspec_circle(9.469,-1.152,0.0= 1);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; curl -o forcedSourceConeWise.json\
 = ; -d 'query=3DSELECT+*+FROM+wise_00.allwise_p3as_mep+WHERE+qs= erv_areaspec_circle(9.469,-1.152,0.01);' \
 = ; http://lsst-qserv-dax= 01.ncsa.illinois.edu:5000/db/v0/tap/sync
Inputs: RA, = DEC, minRA, minDec, maxRA, maxDec (all in degree)
URL:<= /p>
 = ; curl -o <output file> \
 = ; -d 'query=3DSELECT+<column names>+FROM+<database n= ame>.<table name>+WHERE+qserv_areaspec_box(minRA,minDEC,maxRA,maxD= ec);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Examples:
 = ; curl -o catalogBox.json \
 = ; -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.RunDeepSource+WH= ERE+qserv_areaspec_box(9.5,-1.23,9.6,-1.22);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Inputs: RA (= degree), DEC (degree), semi-majorAxis (arcsec), semi-minorAxis(arcsec), pos= itionAngle (degree)
Note: = The semi-majorAxis must be longer than the semi-minorAxis
URL:<= /p>
 = ; curl -o <output file> \
 = ; -d 'query=3DSELECT+<column names>+FROM+<database n= ame>.<table name>+WHERE+qserv_areaspec_ellipse(<RA>,<DEC&= gt;,<semi-majorAxis,semi-minorAxis,positionAngle);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Examples:
 = ; curl -o catalogEllipse.json \
 = ; -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.RunDeepSource+WH= ERE+qserv_areaspec_ellipse(9.469,-1.152,58,36,0);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Inputs: Poly= gon vertexes coordinates: v1_RA, v1_DEC; v2_RA, v2_DEC; v3_RA, v3_DEC; ... = (all in degree)
Note: The or= der of the vertex coordinates matters, either clockwise or anticlockwise.= span>
URL:<= /p>
 = ; curl -o <output file> \
 = ; -d 'query=3DSELECT+<column names>+FROM+<database n= ame>.<table name>+WHERE+qserv_areaspec_poly(v1_RA, v1_DEC, v2_RA, = v2_DEC, ...);' \
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Examples:
 = ; curl -o catalogPolygon.json \
 = ; -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.RunDeepForcedSou= rce+WHERE+qserv_areaspec_poly(9.4, -1.2, 9.6, -1.2, 9.4, -1.1);' \= p>
 = ; http://lsst-qs= erv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
Note: The image search commands below can be used for either Sci= ence_Ccd_Exposure or DeepCoadd tables.
Use the function scisql_s2PtInCP= oly to search the images which four corner polygon contains the given targe= t RA and DEC.
Inputs: RA, DEC, corner1Ra, corn= er1Decl, corner2Ra, corner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4= Decl
Example:
The target: (RA, DEC)
The command:
 = ; curl -o imagesCon= tainTarget.json -d 'query=3DSELECT+*+FROM+<database name>.<table n= ame>+WHERE+\
 = ; scisql_s2PtInCPol= y(RA, DEC, <corner1Ra>, <corner1Decl>, <corner2Ra>, <c= orner2Decl>, <corner3Ra>, <corner3Decl>, <corner4Ra>, = <corner4Decl)=3D1;' \
 = ; http://lsst-qserv-dax01.ncsa.illinois.edu:5000/= db/v0/tap/sync
Example f= or SDSS images:
 = ; curl -o imagesCon= tainTarget.json -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.DeepCoadd= +WHERE+\
 = ; scisql_s2PtInCPol= y(9.462, -1.152, corner1Ra, corner1Decl, corner2Ra, corner2Decl, corner3Ra,= corner3Decl, corner4Ra, corner4Decl)=3D1;' \
 = ; http://lsst-qserv-dax01.ncsa.illinois.edu:5000/= db/v0/tap/sync
Example for WISE images:
 = ; curl -o imagesCon= tainTarget.json -d 'query=3DSELECT+*+FROM+wise_00.allwise_p3am_cdd+WHERE+\<= /span>
 = ; scisql_s2PtInCPol= y(9.462, -1.152, ra1, dec1, ra2, dec2, ra3, dec3, ra4, dec4)=3D1;' \=
 = ; http://lsst-qserv-dax01.ncsa.illinois.edu:5000/= db/v0/tap/sync
Call the function scisql_s2PtInC= Poly four times to search the images which contain all the four vortexes of= the given search box.
Inputs of each call: RA_one_corner_of= _box, DEC_of_one_corner_of_box, corner1Ra, corner1Decl, corner2Ra, cor= ner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl
= The search box four corners:
= (9.5, -1.23), (9.5, -1.22= ), (9.6, -1.23), and (9.6, -1.22)
Example for SDSS images:
&n= bsp; = curl -o imagesContainTheRegion.json -d 'query=3DSELECT+*+FROM+sdss_s= tripe82_01.Science_Ccd_Exposure+WHERE+\
&n= bsp; = (scisql_s2PtInCPoly(9.5, -1.23, corner1Ra, corner1Decl, corner2Ra, c= orner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.5, -1.22, corner1Ra, corner1Decl, corner2Ra, c= orner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.6, -1.23, corner1Ra, corner1Decl, corner2Ra, c= orner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.6, -1.22, corner1Ra, corner1Decl, corner2Ra, c= orner2Decl, corner3Ra, corner3Decl, corner4Ra, corner4Decl)=3D1);' \=
&n= bsp; = http://lsst-qserv-dax01= .ncsa.illinois.edu:5000/db/v0/tap/sync
Example f= or WISE images:
&n= bsp; = curl -o allsky_2band_p1bm_frmContainTheRegion.json -d 'query=3DSELEC= T+*+FROM+wise_00.allsky_2band_p1bm_frm+WHERE+\
&n= bsp; = (scisql_s2PtInCPoly(9.5, -1.23, ra1, dec1, ra2, dec2, ra3, dec3, ra4= , dec4)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.5, -1.22, ra1, dec1, ra2, dec2, ra3, dec3, ra4= , dec4)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.6, -1.23, ra1, dec1, ra2, dec2, ra3, dec3, ra4= , dec4)=3D1)+AND+\
&n= bsp; = (scisql_s2PtInCPoly(9.6, -1.22, ra1, dec1, ra2, dec2, ra3, dec3, ra4= , dec4)=3D1);' \
&n= bsp; = http://lsst-qserv-dax01.ncsa= .illinois.edu:5000/db/v0/tap/sync
Call the function scisql_s2PtInB= ox four times to search the images which four corners are entirely containe= d by the given search box.
Inputs of each call: corner1Ra, corne= r1Decl (or corner2Ra, corner2Decl, or corner3Ra, corner3Decl, or corner4Ra,= corner4Decl ), box_minRA, box_minDEC, box_maxRA, box_maxDEC
 = ; The search box:
 = ; minRA=3D0, minDEC= =3D-1, maxRA=3D5, maxDEC=3D1
 = ; Example for SDSS images:
 = ; curl -o imagesContainedB= yTheRegionBox.json -d 'query=3DSELECT+*+FROM+sdss_stripe82_01.Science_Ccd_E= xposure+WHERE+\
 = ; (scisql_s2PtInBox(corner= 1Ra, corner1Decl, 0, -1, 5, 1)=3D1)+AND+\
 = ; (scisql_s2PtInBox(corner= 2Ra, corner2Decl,0, -1, 5, 1) =3D1)+AND+\
 = ; (scisql_s2PtInBox(corner= 3Ra, corner3Decl, 0, -1, 5, 1)=3D1)+AND+\
 = ; (scisql_s2PtInBox(corner= 4Ra, corner4Decl, 0, -1, 5, 1)=3D1);' \
 = ; http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/t= ap/sync
Example for WISE images:
 = ; curl -o allwise_p3am_cdd= ContainedByTheRegionBox.json -d 'query=3DSELECT+*+FROM+wise_00.allwise_p3am= _cdd+WHERE+\
 = ; (scisql_s2PtInBox(ra1, d= ec1, 0, -1, 5, 1)=3D1)+AND+\
 = ; (scisql_s2PtInBox(ra2, d= ec2,0, -1, 5, 1) =3D1)+AND+\
 = ; (scisql_s2PtInBox(ra3, d= ec3, 0, -1, 5, 1)=3D1)+AND+\
 = ; (scisql_s2PtInBox(ra4, d= ec4, 0, -1, 5, 1)=3D1);' \
 = ; http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sy= nc
Inputs: RA, DEC, radius (all in degree)=
 = ; URL:
 = ; curl -o <output file&= gt; \
 = ; -d 'query=3DSELECT+<c= olumn names>+FROM+<database name>.<table name>+WHERE+scisql_= s2PtInCircle(<ra column name>,<dec column name>,<RA>,<= DEC>,<radius>)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Example:
 = ; curl -o catalogCone.json= \
 = ; -d 'query=3DSELECT+*+FRO= M+sdss_stripe82_01.RunDeepSource+WHERE+scisql_s2PtInCircle(coord_ra,coord_d= ecl,9.469,-1.152,0.01)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Inputs: RA, DEC, minRA, minDec, maxRA, maxDec (all i= n degree)
 = ; URL:
 = ; curl -o <output file&= gt; \
 = ; -d 'query=3DSELECT+<c= olumn names>+FROM+<database name>.<table name>+WHERE+scisql_= s2PtInBox(<ra column name>,<dec column name>,minRA,minDEC,maxRA= ,maxDec)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Examples:
 = ; curl -o catalogBox.json = \
 = ; -d 'query=3DSELECT+*+FRO= M+sdss_stripe82_01.RunDeepSource+WHERE+scisql_s2PtInBox(coord_ra,coord_decl= ,9.5,-1.23,9.6,-1.22)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
<=
/span>
 = ; Inputs: RA (degree), DEC (degree), semi-majorAxis (a= rcsec), semi-minorAxis(arcsec), positionAngle (degree)
 = ; Note: The semi-majorAxis must be longer than = the semi-minorAxis
 = ; URL:
 = ; curl -o <output file&= gt; \
 = ; -d 'query=3DSELECT+<c= olumn names>+FROM+<database name>.<table name>+WHERE+scisql_= s2PtInEllipse(<ra column name>,<dec column name>,<RA>,<= ;DEC>,<semi-majorAxis,semi-minorAxis,positionAngle)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Examples:
 = ; curl -o catalogEllipse.j= son \
 = ; -d 'query=3DSELECT+*+FRO= M+sdss_stripe82_01.RunDeepSource+WHERE+scisql_s2PtInEllipse(coord_ra,coord_= decl,9.469,-1.152,58,36,0)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Inputs: Polygon vertexes coordinates: v1_RA, v1_DEC;= v2_RA, v2_DEC; v3_RA, v3_DEC; ... (all in degree)
 = ; Note: The order of the vertex coordinates matters, e= ither clockwise or anticlockwise.
 = ; URL:
 = ; curl -o <output file&= gt; \
 = ; -d 'query=3DSELECT+<c= olumn names>+FROM+<database name>.<table name>+WHERE+scisql_= s2PtInCPoly(<ra column name>,<dec column name>, v1_RA, v1_DEC, = v2_RA, v2_DEC, ...)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
 = ; Examples:
 = ; curl -o catalogPolygon.j= son \
 = ; -d 'query=3DSELECT+*+FRO= M+sdss_stripe82_01.RunDeepForcedSource+WHERE+scisql_s2PtInCPoly(coord_ra,co= ord_decl,9.4, -1.2, 9.6, -1.2, 9.4, -1.1)=3D1;' \
 = ; http://lsst-q= serv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
One reference query here is to start with an Object ID and retrieve all = the ForcedSource measurements associated with that object. That is a = direct foreign-key relationship between the two tables and is trivially exp= ressed in SQL. This query must be highly performant&= nbsp;- the goal should be for this to take only a few seconds. (The f= ormal LSST requirement is <10s, but we should aspire to be quite a bit f= aster than that.)
Input: OBJ_ID
URL:
curl -o forcedSource.json \
-d 'query=3DSELECT+<column names>+FROM+sdss_stripe82_01.RunDeepFor= cedSource+WHERE+objectId=3DOBJ_ID;' \
http://lsst-qserv-dax01.ncsa.ill= inois.edu:5000/db/v0/tap/sync
Example:
curl -o forcedSource.json \
-d 'query=3DSELECT+count(*)+FROM+sdss_stripe82_01.RunDeepForcedSource+WH= ERE+objectId=3D3448068867358968;' \
http://lsst-qserv-dax01.ncsa.ill= inois.edu:5000/db/v0/tap/sync
v0: curl http://=
lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/
<=
/li>
v1: curl http://lsst-qserv-dax01.ncsa.illinois.edu:5000/=
image/v1/
#I_6: Retrieve calexp image closest to r= a, dec.
v0: curl -o calexp= RaDecFilter.fits "h= ttp://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/calexp?filter=3Dr&am= p;ra=3D37.644598&dec=3D0.104625"
v1: curl -o calexpRaDecFilter.fits "htt= p://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dc= alexp&ra=3D37.644598&dec=3D0.104625&filter=3Dr"
#I_7:Retrieve calexp image by Butler Dat= aId.
v0: curl -o calexp= BrokenId.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/calexp/ids?= run=3D5646&camcol=3D4&field=3D694&filter=3Dg"=
v1: curl -o calexpBrokenId.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe= 82?ds=3Dcalexp&run=3D5646&camcol=3D4&field=3D694&filter=3Dg= "
#I_8: Retrieve calexp image by But= ler DataId. (use id =3D 5646240694)
v0: curl -o calexp= Id.fits "http://lsst-qserv-dax01.ncsa.illinois.ed= u:5000/image/v0/calexp/id?id=3D5646240694"
v1: curl -o calexpId.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:= 5000/image/v1/DC_W13_Stripe82?ds=3Dcalexp&sid=3D3325410171"
#I_9: Retrieve calexp image cutout by Da= taId (Butler) and dimensions in 'arcsecond'.
v0: curl -o calexp= RaDecFilterW300H450.fits "http://lsst-qserv-dax01.= ncsa.illinois.edu:5000/image/v0/calexp/cutout?ra=3D37.644598&dec=3D0.10= 4625&filter=3Dr&width=3D300.0&height=3D450.0"=
v0: c= url -o calexpRaDecFilterW450H300.fits "http://lsst= -qserv-dax01.ncsa.illinois.edu:5000/image/v0/calexp/cutout?ra=3D37.644598&a= mp;dec=3D0.104625&filter=3Dr&width=3D450.0&height=3D300.0"
v1: curl -o calexpRaDecFilterW450H300.fi=
ts "http://lsst-=
qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dcalexp&=
;ra=3D37.644598&dec=3D0.104625&filter=3Dr&width=3D450.0&hei=
ght=3D300.0&unit=3Darcsec"
#I_10: Retrieve calexp image cutout by B= utler DataId and dimensions in 'pixel'.
v0: curl -o calexp= RaDecFilterPixW300H450.fits "http://lsst-qser= v-dax01.ncsa.illinois.edu:5000/image/v0/calexp/cutoutPixel?ra=3D37.644598&a= mp;dec=3D0.104625&filter=3Dr&width=3D300.0&height=3D450.0"
v0: curl -o calexpRaDecFilterPixW450H300.fits "h= ttp://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/calexp/cutoutPixel?r= a=3D37.644598&dec=3D0.104625&filter=3Dr&width=3D450.0&heigh= t=3D300.0"
v1: curl -o calexpRaDecFilterPixW45= 0H300.fits "htt= p://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dc= alexp&ra=3D37.644598&dec=3D0.104625&filter=3Dr&width=3D450&= amp;height=3D300&unit=3Dpixel"
#I_11: Retrieve calexp image cutout by i= d and dimensions in 'arcsecond' centered on ra, dec.
v0: c= url -o calexpIdW300H450.fits "http://lsst-qserv-= dax01.ncsa.illinois.edu:5000/image/v0/calexp/5646240694/cutout?ra=3D37.6292= &dec=3D0.104625&widthAng=3D300.0&heightAng=3D450.0"<= /span>
v0: c= url -o calexpIdW450H300.fits "http://lsst-qserv-= dax01.ncsa.illinois.edu:5000/image/v0/calexp/5646240694/cutout?ra=3D37.6292= &dec=3D0.104625&widthAng=3D450.0&heightAng=3D300.0"<= /span>
v1: curl -o calexpIdW450H300.fits "= http://lsst-qser= v-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dcalexp&sid= =3D5646240694&ra=3D37.6292&dec=3D0.104625&width=3D300.0&hei= ght=3D450.0&unit=3Darcsec"
#I_12: Retrieve calexp image cutout by i= d and dimensions in 'pixel' centered on ra, dec.
v0: curl -o calexp= IdPixW100H100.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/calexp/564624= 0694/cutout?ra=3D37.6292&dec=3D0.104625&widthPix=3D100&heightPi= x=3D100"
v0: curl -o calexp= IdPixW200H100.fits "= http://lsst-qserv-dax01.ncsa.illin= ois.edu:5000/image/v0/calexp/5646240694/cutout?ra=3D37.6292&dec=3D0.104= 625&widthPix=3D200&heightPix=3D100"
v0: c= url -o calexpIdPixW100H200.fits "http://lsst-qserv-da= x01.ncsa.illinois.edu:5000/image/v0/calexp/5646240694/cutout?ra=3D37.6292&a= mp;dec=3D0.104625&widthPix=3D100&heightPix=3D200"=
v1: curl -o calexpIdPixW100H200.fits "http://lsst-qserv-dax0=
1.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dcalexp&sid=3D564=
6240694&ra=3D37.6292&dec=3D0.104625&width=3D100&height=3D20=
0&unit=3Dpixel"
(note that single-epoch image metadata is available in the Sc=
ience_Ccd_Exposure
table - see above)
Is image missing?
curl -d 'query=3DSELECT scienceCcdExposu= reId FROM Science_Ccd_Exposure_NoFile where scienceCcdExposureId=3D1= 755110401' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync<= /p>
#I_13: Retrieve deepCoadd image by ra an= d dec and filter
v0: curl -o coaddO= ldRaDecFilter.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd?ra=3D19= .36995&dec=3D-0.3146&filter=3Dr"
v0: c= url -o coaddNewRaDecFilter.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deep= Coadd?ra=3D37.6292&dec=3D0.104625&filter=3Dr"
v1: curl -o coaddNewRaDecFilter.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W1=
3_Stripe82?ds=3Ddeepcoadd&ra=3D19.37995&dec=3D-0.3146&filter=3D=
r"
#I_14: Retrieve deepCoadd image by Butle= r DataId.
v0: curl -o coaddB= rokenId.fits "http= ://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd/ids?tract=3D0= &patch=3D225,1&filter=3Di"
v1: curl -o coaddBrokenId.fits "http:/= /lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Ddeep= coadd&tract=3D0&patch=3D225,1&filter=3Di"
#I_15: Retrieve deepCoadd image by id.= span>
v0: curl -o coaddI= d.fits "http://lsst-qserv-dax01.ncsa.illinois.ed= u:5000/image/v0/deepCoadd/id?id=3D23986176"
v1: curl -o coaddId.fits "http://lsst-qserv-dax01.ncsa.illinois.edu:= 5000/image/v1/DC_W13_Stripe82?ds=3Ddeepcoadd&sid=3D23986176"
#I_16: Retrieve deepCoadd cutout image n= earest to ra, dec with dimensions in 'arcsecond'.
v0: curl -o coaddR= aDecFilterOldRaDecW115H235.fits "http://lsst-qserv-da= x01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutout?ra=3D19.36995&dec= =3D-0.3146&filter=3Dr&width=3D115&height=3D235"
v0: c= url -o coaddRaDecFilterOldRaDecW30H45.fits "http://lss= t-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutout?ra=3D19.3699= 5&dec=3D-0.3146&filter=3Dr&width=3D30&height=3D45"
v0: c= url -o coaddRaDecFilterNewRaDecW115H235.fits "http://= lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutout?ra=3D37.6= 292&dec=3D0.104625&filter=3Dr&width=3D115&height=3D235"
v0: c= url -o coaddRaDecFilterNewRaDecW300H450.fits "http://= lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutout?ra=3D37.6= 292&dec=3D0.104625&filter=3Dr&width=3D300&height=3D450"
v1: curl -o coaddRaDecFilterNewRaDe= cW300H450.fits "htt= p://lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Dd= eepcoadd&ra=3D19.36995&dec=3D-0.3147&filter=3Dr&width=3D300= &height=3D400&unit=3Darcsec"
#I_17: Retrieve deepCoadd cutout image n= earest to ra, dec with dimensions in 'Pixel'.
v0: curl -o coaddR= aDecFilterPixW115H235.fits "http://lsst-qserv-da= x01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutoutPixel?ra=3D19.36995&= ;dec=3D-0.3146&filter=3Dr&width=3D115&height=3D235"<= /span>
v0: c= url -o coaddRaDecFilterPixW235H115.fits "http://= lsst-qserv-dax01.ncsa.illinois.edu:5000/image/v0/deepCoadd/cutoutPixel?ra= =3D19.36995&dec=3D-0.3146&filter=3Dr&width=3D235&height=3D1= 15"
v1: curl -o coaddRaDecFilterPixW235H115.=
fits "http://l=
sst-qserv-dax01.ncsa.illinois.edu:5000/image/v1/DC_W13_Stripe82?ds=3Ddeepco=
add&ra=3D19.36995&dec=3D-0.3147&filter=3Dr&width=3D115&=
height=3D235&unit=3Dpixel"
(note that coadded patch image metadata is available in the D=
eepCoadd
table - see above)
Computing a calibrated magnitude requires correcting the observed flux f= or the photometric zero point. This requires a join between the RunDe= epForcedSource table, for the information about the individual observations= , and the Science_Ccd_Exposure table (for a per-visit-image photometric zer= o point).
Input: an objectId
:
Example:
Tested (Gregory Dubois-Felsmann
curl -d 'query=3DSELECT objectId, id, fsrc.exposure_id, fsrc.expos= ure_time_mid, exp.run, scisql_dnToAbMag(fsrc.flux_psf,exp.fluxMag0) AS g, s= cisql_dnToAbMagSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, exp.fl= uxMag0Sigma) AS gErr \
FROM sdss_stripe82_01.RunDeepForcedSource AS fsrc, sdss_strip= e82_01.Science_Ccd_Exposure AS exp WHERE exp.scienceCcdExposureId =3D fsrc.= exposure_id AND fsrc.exposure_filter_id=3D1 AND objectId=3D3448068867358968= \
ORDER BY exposure_time_mid' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync<= /pre>With flag bits not a= s yet corrected to their Summer 2013 / PDAC form:
SELECT
objectId,
id,
fsrc.exposure_id,
fsr= c.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
FROMsdss_stripe82_01.RunDeepForcedSource AS fsrc,sdss_stripe82_01.Science_Ccd_Exposure AS expWHERE
exp.scienceCcdExposureId =3D fsrc.exposure_id
= AND fsrc.exposure_filter_id =3D 1
AND NOT (fsrc.flagPixEdge | fs= rc.flagPixSaturAny |
fsrc.flagPixSaturCen | fsrc.flagBadApF= lux |
fsrc.flagBadPsfFlux)
AND objectId =3D 34480688= 67358968
ORDER BY
exposure_time_mid(See https://dev.lsstcorp.org/trac/wiki/= DC/Winter2013 for more information. I have updated the RunDe= epForcedSource table name, all the column names except for the flag bits, a= dded the exposure ID to the 'SELECT' clause, and updated the objectId to th= e one in the other reference queries on the present page, compared to = the query given on Trac. Note that we'll need the single-epoch exposu= re ID in the results table in order to set up the link to the image cutouts= for the light curve viewer. I've also updated the objectId to the on= e in the other reference queries on the present page.)
Computing a calibrated flux (call functions scisql_dnToFlux= and scisql_dnToFluxSigma) requires correcting the observed flux f= or the photometric zero point. This requires a join between the RunDe= epForcedSource table (for the information about the individual observations= ) and the Science_Ccd_Exposure table (for a per-visit-image photometric zer= o point).
Input: an objectId
:
Example:
Tested (Yi Mei ):
curl -d 'query=3DSELECT objectId, id, fsrc.exposure_id, fsrc.expos= ure_time_mid, exp.run, scisql_dnToFlux(fsrc.flux_psf,exp.fluxMag0) AS tsv_f= lux, scisql_dnToFluxSigma(fsrc.flux_psf, fsrc.flux_psf_err, exp.fluxMag0, e= xp.fluxMag0Sigma) AS tsv_fluxErr \
FROM
sdss_stripe82_01.RunDeepForcedSource AS fsrc,
sdss_stripe82_01.Science_Ccd_Exposure AS exp
WHERE exp.scienceCcdExposureId =3D fsrc.exposure_id AND fsrc.ex= posure_filter_id=3D1 AND objectId=3D3448068867358968 \
ORDER BY exposure_time_mid' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync
With flag bits not a= s yet corrected to their Summer 2013 / PDAC form:
SELECT
objectId,
id,
fsrc.exposure_id,
fsr= c.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_01.RunDeepForcedSource AS fsrc,
sdss_stripe82_01.Science_Ccd_Exposure AS exp
WHERE
exp.scienceCcdExposureId =3D fsrc.exposure_id
= AND fsrc.exposure_filter_id =3D 1
AND NOT (fsrc.flagPixEdge | fs= rc.flagPixSaturAny |
fsrc.flagPixSaturCen | fsrc.flagBadApF= lux |
fsrc.flagBadPsfFlux)
AND objectId =3D 34480688= 67358968
ORDER BY
exposure_time_mid
Step 1. Get the object id (the column cntr) from the object table: targe= t RA =3D 10.68479, Dec =3D 41.26906, radius =3D 0.0277777777= 77777776 deg
curl -o w= iseObjectsCone.json\
-d 'query= =3DSELECT+*+FROM+wise_00.allwise_p3as_psd+WHERE+qserv_areaspec_circle(10.68= 479,41.26906,0.02777777777777777);\
' http://lsst-qserv-dax01.ncsa.illinois.edu:= 5000/db/v0/tap/sync
Step 2. Pick one object id from Step 1 result to query the forced source= s (the column cntr_mf):
curl -o w= iseForcedSourceConeObjId.json\
-d 'quer= y=3DSELECT+*+FROM+wise_00.allwise_p3as_mep+WHERE+qserv_areaspec_circle(10.6= 8479, 41.26906,0.027777777777777776) +AND+ cntr_mf =3D 98140801351043831;\<= /span>
' http://lsst-qserv-dax01.ncsa.illinois.edu:= 5000/db/v0/tap/sync
Note: The qserv_areaspec_circle c= an be removed from the second step (search the forced sources) after Qserv = improves the WISE data table indexing.
(See https://dev.lsstcorp.org/trac/wiki/= DC/Winter2013 for more information. I have updated the RunDe= epForcedSource table name, all the column names except for the flag bits, a= dded the exposure ID to the 'SELECT' clause, and updated the objectId to th= e one in the other reference queries on the present page, compared to = the query given on Trac. Note that we'll need the single-epoch exposu= re ID in the results table in order to set up the link to the image cutouts= for the light curve viewer. I've also updated the objectId to the on= e in the other reference queries on the present page.)