Last active
June 21, 2017 01:01
-
-
Save brianv0/3d78ba2b0ee9c234952ef04029926d7e to your computer and use it in GitHub Desktop.
Metaserv V1 Example
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Show tables for S12_sdss (default schema) | |
GET /meta/v1/db/S12_sdss/tables HTTP/1.1 | |
Accept: application/json | |
Host: localhost:5000 | |
HTTP/1.0 200 OK | |
Content-Type: application/json | |
Content-Length: 47362 | |
Server: Werkzeug/0.12.1 Python/3.5.2 | |
Date: Tue, 20 Jun 2017 23:14:09 GMT | |
{ | |
"results": [ | |
{ | |
"columns": [ | |
{ | |
"description": "Pointer to Science_Ccd_Exposure.", | |
"name": "scienceCcdExposureId", | |
"ordinal": 0, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "ID for Level 10 HTM triangle overlapping exposure. For each exposure in Science_Ccd_Exposure, there will be one row for every overlapping triangle.", | |
"name": "htmId10", | |
"ordinal": 1, | |
"ucd": "pos.HTM", | |
"unit": "" | |
} | |
], | |
"description": "Stores a mapping between exposures in Science_Ccd_Exposure and the IDs of spatially overlapping level-10 HTM triangles.", | |
"name": "Science_Ccd_Exposure_To_Htm10" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Pointer to DeepCoadd.", | |
"name": "deepCoaddId", | |
"ordinal": 0, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "ID for Level 10 HTM triangle overlapping exposure. For each exposure in DeepCoadd, there will be one row for every overlapping triangle.", | |
"name": "htmId10", | |
"ordinal": 1, | |
"ucd": "pos.HTM", | |
"unit": "" | |
} | |
], | |
"description": "Not filled. Stores a mapping between exposures in DeepCoadd and the IDs of spatially overlapping level-10 HTM triangles.", | |
"name": "DeepCoadd_To_Htm10" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Primary key (unique identifier).", | |
"name": "deepCoaddId", | |
"ordinal": 0, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "Sky-tract number.", | |
"name": "tract", | |
"ordinal": 1, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Sky-patch.", | |
"name": "patch", | |
"ordinal": 2, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Id of the filter for the band.", | |
"name": "filterId", | |
"ordinal": 3, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "Filter name, pulled in from the Filter table.", | |
"name": "filterName", | |
"ordinal": 4, | |
"ucd": "instr.bandpass", | |
"unit": "" | |
}, | |
{ | |
"description": "ICRS R.A. of image center, corresponding to FITS pixel coordinates ((NAXIS1 + 1)/2, (NAXIS2 + 1)/2).", | |
"name": "ra", | |
"ordinal": 5, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec. of image center, corresponding to FITS pixel coordinates ((NAXIS1 + 1)/2, (NAXIS2 + 1)/2).", | |
"name": "decl", | |
"ordinal": 6, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "Level 20 HTM ID of (ra, decl)", | |
"name": "htmId20", | |
"ordinal": 7, | |
"ucd": "pos.HTM", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "equinox", | |
"ordinal": 8, | |
"ucd": "pos.equinox", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "raDeSys", | |
"ordinal": 9, | |
"ucd": "pos.frame", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "ctype1", | |
"ordinal": 10, | |
"ucd": "pos.wcs.ctype", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "ctype2", | |
"ordinal": 11, | |
"ucd": "pos.wcs.ctype", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "crpix1", | |
"ordinal": 12, | |
"ucd": "pos.wcs.crpix", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "", | |
"name": "crpix2", | |
"ordinal": 13, | |
"ucd": "pos.wcs.crpix", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "", | |
"name": "crval1", | |
"ordinal": 14, | |
"ucd": "pos.wcs.crval", | |
"unit": "deg" | |
}, | |
{ | |
"description": "", | |
"name": "crval2", | |
"ordinal": 15, | |
"ucd": "pos.wcs.crval", | |
"unit": "deg" | |
}, | |
{ | |
"description": "", | |
"name": "cd1_1", | |
"ordinal": 16, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd1_2", | |
"ordinal": 17, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd2_1", | |
"ordinal": 18, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd2_2", | |
"ordinal": 19, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "ICRS RA of image corner 1, corresponding to FITS pixel coordinates (0.5, 0.5)", | |
"name": "corner1Ra", | |
"ordinal": 20, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 1, corresponding to FITS pixel coordinates (0.5, 0.5)", | |
"name": "corner1Decl", | |
"ordinal": 21, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 2, corresponding to FITS pixel coordinates (0.5, NAXIS2 + 0.5)", | |
"name": "corner2Ra", | |
"ordinal": 22, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 2, corresponding to FITS pixel coordinates (0.5, NAXIS2 + 0.5)", | |
"name": "corner2Decl", | |
"ordinal": 23, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 3, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, NAXIS2 + 0.5)", | |
"name": "corner3Ra", | |
"ordinal": 24, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 3, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, NAXIS2 + 0.5)", | |
"name": "corner3Decl", | |
"ordinal": 25, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 4, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, 0.5)", | |
"name": "corner4Ra", | |
"ordinal": 26, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 4, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, 0.5)", | |
"name": "corner4Decl", | |
"ordinal": 27, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "binary representation of the 4-corner polygon for the exposure.", | |
"name": "poly", | |
"ordinal": 28, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "fluxMag0", | |
"ordinal": 29, | |
"ucd": "phot.flux.density", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "fluxMag0Sigma", | |
"ordinal": 30, | |
"ucd": "stat.error;phot.flux.density", | |
"unit": "" | |
}, | |
{ | |
"description": "FWHM computed from PSF that was matched to during coaddition. NULL if coadds were created with PSF-matching turned off.", | |
"name": "matchedFwhm", | |
"ordinal": 31, | |
"ucd": "instr.obsty.seeing", | |
"unit": "arcsec" | |
}, | |
{ | |
"description": "FWHM computed from measured PSF. NULL if coadds were created with PSF-matching turned on and the pipeline was configured to use the matched-to PSF.", | |
"name": "measuredFwhm", | |
"ordinal": 32, | |
"ucd": "instr.obsty.seeing", | |
"unit": "arcsec" | |
}, | |
{ | |
"description": "FITS file path relative to the SFM pipeline output directory.", | |
"name": "path", | |
"ordinal": 33, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Not filled.", | |
"name": "DeepCoadd" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Unique id (primary key).", | |
"name": "filterId", | |
"ordinal": 0, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "Filter name. Valid values: 'u', 'g', 'r', 'i', 'z'", | |
"name": "filterName", | |
"ordinal": 1, | |
"ucd": "instr.bandpass", | |
"unit": "" | |
}, | |
{ | |
"description": "Filter centroid wavelength.", | |
"name": "photClam", | |
"ordinal": 2, | |
"ucd": "em.wl.effective;instr.filter", | |
"unit": "nm" | |
}, | |
{ | |
"description": "System effective bandwidth.", | |
"name": "photBW", | |
"ordinal": 3, | |
"ucd": "instr.bandwidth", | |
"unit": "nm" | |
} | |
], | |
"description": "", | |
"name": "Filter" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "JD of change in TAI-UTC difference (leap second).", | |
"name": "whenJd", | |
"ordinal": 0, | |
"ucd": "time.epoch", | |
"unit": "d" | |
}, | |
{ | |
"description": "New number of leap seconds.", | |
"name": "offset", | |
"ordinal": 1, | |
"ucd": "time.interval", | |
"unit": "s" | |
}, | |
{ | |
"description": "Reference MJD for drift (prior to 1972-Jan-1).", | |
"name": "mjdRef", | |
"ordinal": 2, | |
"ucd": "time.epoch", | |
"unit": "d" | |
}, | |
{ | |
"description": "Drift in seconds per day (prior to 1972-Jan-1).", | |
"name": "drift", | |
"ordinal": 3, | |
"ucd": "arith.rate", | |
"unit": "s/d" | |
}, | |
{ | |
"description": "MJD in UTC system of change (computed).", | |
"name": "whenMjdUtc", | |
"ordinal": 4, | |
"ucd": "time.epoch", | |
"unit": "d" | |
}, | |
{ | |
"description": "Nanoseconds from epoch in UTC system of change (computed).", | |
"name": "whenUtc", | |
"ordinal": 5, | |
"ucd": "time", | |
"unit": "ns" | |
}, | |
{ | |
"description": "Nanoseconds from epoch in TAI system of change (computed).", | |
"name": "whenTai", | |
"ordinal": 6, | |
"ucd": "time", | |
"unit": "ns" | |
} | |
], | |
"description": "Based on <a href='http://maia.usno.navy.mil/ser7/tai-utc.dat'> http://maia.usno.navy.mil/ser7/tai-utc.dat</a>.", | |
"name": "LeapSeconds" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "", | |
"name": "scienceCcdExposureId", | |
"ordinal": 0, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "metadataKey", | |
"ordinal": 1, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Type of exposure <ul> <li>1: Science CCD</li> <li>2: Difference Imaging CCD</li> <li>3: Good-seeing coadd</li> <li>4: Deep coadd</li> <li>5: Chi-squared coadd</li> <li>6: Keith coadd</li> </ul>", | |
"name": "exposureType", | |
"ordinal": 2, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "intValue", | |
"ordinal": 3, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "doubleValue", | |
"ordinal": 4, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "stringValue", | |
"ordinal": 5, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Generic key-value pair metadata for Science_Ccd_Exposure.", | |
"name": "Science_Ccd_Exposure_Metadata" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "The schema file name.", | |
"name": "f", | |
"ordinal": 0, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Captures information from 'git describe'.", | |
"name": "r", | |
"ordinal": 1, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Internal table used for storing database description", | |
"name": "IF" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Primary key (unique identifier)", | |
"name": "deepForcedSourceId", | |
"ordinal": 0, | |
"ucd": "meta.id;src", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of CCD the forced-source was detected and measured on (pointer to Science_Ccd_Exposure).", | |
"name": "scienceCcdExposureId", | |
"ordinal": 1, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of filter used for the exposure the source was detected and measured on.", | |
"name": "filterId", | |
"ordinal": 2, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "Middle of exposure time (MJD, TAI).", | |
"name": "timeMid", | |
"ordinal": 3, | |
"ucd": "time.epoch", | |
"unit": "d" | |
}, | |
{ | |
"description": "Exposure time (TAI) or, in case of measurement on coadded snap exposure pairs, the sum of snap exposure times.", | |
"name": "expTime", | |
"ordinal": 4, | |
"ucd": "time.duration", | |
"unit": "s" | |
}, | |
{ | |
"description": "ID of object that triggered measurement of this forced-source (pointer to DeepSource).", | |
"name": "deepSourceId", | |
"ordinal": 5, | |
"ucd": "meta.id;src", | |
"unit": "" | |
}, | |
{ | |
"description": "ICRS R.A. of object that triggered measurement of this forced-source.", | |
"name": "deepSourceRa", | |
"ordinal": 6, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec. of object that triggered measurement of this forced-source.", | |
"name": "deepSourceDecl", | |
"ordinal": 7, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of forced-source centroid (x, y).", | |
"name": "ra", | |
"ordinal": 8, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of forced-source centroid (x, y).", | |
"name": "decl", | |
"ordinal": 9, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "Variance of ra due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "raVar", | |
"ordinal": 10, | |
"ucd": "stat.variance;pos.eq.ra", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Variance of decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "declVar", | |
"ordinal": 11, | |
"ucd": "stat.variance;pos.eq.dec", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Covariance of ra, decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "radeclCov", | |
"ordinal": 12, | |
"ucd": "stat.covariance;pos.eq", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Level 20 HTM ID of (ra, decl)", | |
"name": "htmId20", | |
"ordinal": 13, | |
"ucd": "pos.HTM", | |
"unit": "" | |
}, | |
{ | |
"description": "Pixel axis 1 coordinate of forced-source centroid, LSST pixel coordinate conventions.", | |
"name": "x", | |
"ordinal": 14, | |
"ucd": "pos.cartesian.x", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Pixel axis 2 coordinate of forced-source centroid, LSST pixel coordinate conventions.", | |
"name": "y", | |
"ordinal": 15, | |
"ucd": "pos.cartesian.y", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of x.", | |
"name": "xVar", | |
"ordinal": 16, | |
"ucd": "stat.variance;pos.cartesian.x", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of y.", | |
"name": "yVar", | |
"ordinal": 17, | |
"ucd": "stat.variance;pos.cartesian.y", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Covariance of x and y", | |
"name": "xyCov", | |
"ordinal": 18, | |
"ucd": "stat.covariance", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Uncalibrated PSF flux of forced-source.", | |
"name": "psfFlux", | |
"ordinal": 19, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of psfFlux.", | |
"name": "psfFluxSigma", | |
"ordinal": 20, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated aperture flux of forced-source.", | |
"name": "apFlux", | |
"ordinal": 21, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of apFlux.", | |
"name": "apFluxSigma", | |
"ordinal": 22, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated model flux of forced-source.", | |
"name": "modelFlux", | |
"ordinal": 23, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of modelFlux", | |
"name": "modelFluxSigma", | |
"ordinal": 24, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated instrumental flux of forced-source.", | |
"name": "instFlux", | |
"ordinal": 25, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of instFlux.", | |
"name": "instFluxSigma", | |
"ordinal": 26, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Aperture correction factor applied to fluxes", | |
"name": "apCorrection", | |
"ordinal": 27, | |
"ucd": "arith.factor", | |
"unit": "" | |
}, | |
{ | |
"description": "Aperture correction uncertainty", | |
"name": "apCorrectionSigma", | |
"ordinal": 28, | |
"ucd": "stat.error", | |
"unit": "" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIx", | |
"ordinal": 29, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIy", | |
"ordinal": 30, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIx.", | |
"name": "shapeIxVar", | |
"ordinal": 31, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIy.", | |
"name": "shapeIyVar", | |
"ordinal": 32, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Covariance of momentIx and momentIy.", | |
"name": "shapeIxIyCov", | |
"ordinal": 33, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxx", | |
"ordinal": 34, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIyy", | |
"ordinal": 35, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxy", | |
"ordinal": 36, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of shapeIxx.", | |
"name": "shapeIxxVar", | |
"ordinal": 37, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIyyVar", | |
"ordinal": 38, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIxyVar", | |
"ordinal": 39, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIyy.", | |
"name": "shapeIxxIyyCov", | |
"ordinal": 40, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIxy.", | |
"name": "shapeIxxIxyCov", | |
"ordinal": 41, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIyy and shapeIxy.", | |
"name": "shapeIyyIxyCov", | |
"ordinal": 42, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Probability of being extended.<descr> <ucd>stat.probability</ucd>", | |
"name": "extendedness", | |
"ordinal": 43, | |
"ucd": "stat.probability", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source was detected as significantly negative. <ucd>meta.code</ucd>", | |
"name": "flagNegative", | |
"ordinal": 44, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid algorithm used to feed centers to other measurement algorithms failed.", | |
"name": "flagBadMeasCentroid", | |
"ordinal": 45, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source is in region labeled EDGE.", | |
"name": "flagPixEdge", | |
"ordinal": 46, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source footprint includes interpolated pixels.", | |
"name": "flagPixInterpAny", | |
"ordinal": 47, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source center is close to interpolated pixels.", | |
"name": "flagPixInterpCen", | |
"ordinal": 48, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source footprint includes saturated pixels.", | |
"name": "flagPixSaturAny", | |
"ordinal": 49, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source center is close to saturated pixels.", | |
"name": "flagPixSaturCen", | |
"ordinal": 50, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the psfFlux measurement failed.", | |
"name": "flagBadPsfFlux", | |
"ordinal": 51, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the apFlux measurement failed.", | |
"name": "flagBadApFlux", | |
"ordinal": 52, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the modelFlux measurement failed.", | |
"name": "flagBadModelFlux", | |
"ordinal": 53, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the instFlux measurement failed.", | |
"name": "flagBadInstFlux", | |
"ordinal": 54, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid measurement failed.", | |
"name": "flagBadCentroid", | |
"ordinal": 55, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the shape measurement did not completely succeed.", | |
"name": "flagBadShape", | |
"ordinal": 56, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "chunkId", | |
"ordinal": 57, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "subChunkId", | |
"ordinal": 58, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Not filled. Table of forced-photometry sources, measured using positions of objects from DeepSource.", | |
"name": "DeepForcedSource" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Primary key (unique identifier)", | |
"name": "deepSourceId", | |
"ordinal": 0, | |
"ucd": "meta.id;src", | |
"unit": "" | |
}, | |
{ | |
"description": "deepSourceId of parent if source is deblended, otherwise NULL.", | |
"name": "parentDeepSourceId", | |
"ordinal": 1, | |
"ucd": "meta.id.parent;src", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of the coadd the source was detected and measured on (pointer to DeepCoadd).", | |
"name": "deepCoaddId", | |
"ordinal": 2, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of filter used for the coadd the source was detected and measured on.", | |
"name": "filterId", | |
"ordinal": 3, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "ICRS RA of source centroid (x, y).", | |
"name": "ra", | |
"ordinal": 4, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of source centroid (x, y).", | |
"name": "decl", | |
"ordinal": 5, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "Variance of ra due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "raVar", | |
"ordinal": 6, | |
"ucd": "stat.variance;pos.eq.ra", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Variance of decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "declVar", | |
"ordinal": 7, | |
"ucd": "stat.variance;pos.eq.dec", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Covariance of ra, decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "radeclCov", | |
"ordinal": 8, | |
"ucd": "stat.covariance;pos.eq", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Level 20 HTM ID of (ra, decl)", | |
"name": "htmId20", | |
"ordinal": 9, | |
"ucd": "pos.HTM", | |
"unit": "" | |
}, | |
{ | |
"description": "Pixel axis 1 coordinate of source centroid, LSST pixel coordinate conventions.", | |
"name": "x", | |
"ordinal": 10, | |
"ucd": "pos.cartesian.x", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Pixel axis 2 coordinate of source centroid, LSST pixel coordinate conventions.", | |
"name": "y", | |
"ordinal": 11, | |
"ucd": "pos.cartesian.y", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of x.", | |
"name": "xVar", | |
"ordinal": 12, | |
"ucd": "stat.variance;pos.cartesian.x", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of y.", | |
"name": "yVar", | |
"ordinal": 13, | |
"ucd": "stat.variance;pos.cartesian.y", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Covariance of x and y", | |
"name": "xyCov", | |
"ordinal": 14, | |
"ucd": "stat.covariance", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Uncalibrated PSF flux of source.", | |
"name": "psfFlux", | |
"ordinal": 15, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of psfFlux.", | |
"name": "psfFluxSigma", | |
"ordinal": 16, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated aperture flux of source.", | |
"name": "apFlux", | |
"ordinal": 17, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of apFlux.", | |
"name": "apFluxSigma", | |
"ordinal": 18, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated model flux of source.", | |
"name": "modelFlux", | |
"ordinal": 19, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of modelFlux", | |
"name": "modelFluxSigma", | |
"ordinal": 20, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated instrumental flux of source.", | |
"name": "instFlux", | |
"ordinal": 21, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of instFlux.", | |
"name": "instFluxSigma", | |
"ordinal": 22, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Aperture correction factor applied to fluxes", | |
"name": "apCorrection", | |
"ordinal": 23, | |
"ucd": "arith.factor", | |
"unit": "" | |
}, | |
{ | |
"description": "Aperture correction uncertainty", | |
"name": "apCorrectionSigma", | |
"ordinal": 24, | |
"ucd": "stat.error", | |
"unit": "" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIx", | |
"ordinal": 25, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIy", | |
"ordinal": 26, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIx.", | |
"name": "shapeIxVar", | |
"ordinal": 27, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIy.", | |
"name": "shapeIyVar", | |
"ordinal": 28, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Covariance of momentIx and momentIy.", | |
"name": "shapeIxIyCov", | |
"ordinal": 29, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxx", | |
"ordinal": 30, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIyy", | |
"ordinal": 31, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxy", | |
"ordinal": 32, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of shapeIxx.", | |
"name": "shapeIxxVar", | |
"ordinal": 33, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIyyVar", | |
"ordinal": 34, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIxyVar", | |
"ordinal": 35, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIyy.", | |
"name": "shapeIxxIyyCov", | |
"ordinal": 36, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIxy.", | |
"name": "shapeIxxIxyCov", | |
"ordinal": 37, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIyy and shapeIxy.", | |
"name": "shapeIyyIxyCov", | |
"ordinal": 38, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Probability of being extended.<descr> <ucd>stat.probability</ucd>", | |
"name": "extendedness", | |
"ordinal": 39, | |
"ucd": "stat.probability", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source was detected as significantly negative. <ucd>meta.code</ucd>", | |
"name": "flagNegative", | |
"ordinal": 40, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid algorithm used to feed centers to other measurement algorithms failed.", | |
"name": "flagBadMeasCentroid", | |
"ordinal": 41, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source is in region labeled EDGE.", | |
"name": "flagPixEdge", | |
"ordinal": 42, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source footprint includes interpolated pixels.", | |
"name": "flagPixInterpAny", | |
"ordinal": 43, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source center is close to interpolated pixels.", | |
"name": "flagPixInterpCen", | |
"ordinal": 44, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source footprint includes saturated pixels.", | |
"name": "flagPixSaturAny", | |
"ordinal": 45, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if source center is close to saturated pixels.", | |
"name": "flagPixSaturCen", | |
"ordinal": 46, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the psfFlux measurement failed.", | |
"name": "flagBadPsfFlux", | |
"ordinal": 47, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the apFlux measurement failed.", | |
"name": "flagBadApFlux", | |
"ordinal": 48, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the modelFlux measurement failed.", | |
"name": "flagBadModelFlux", | |
"ordinal": 49, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the instFlux measurement failed.", | |
"name": "flagBadInstFlux", | |
"ordinal": 50, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid measurement failed.", | |
"name": "flagBadCentroid", | |
"ordinal": 51, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the shape measurement did not completely succeed.", | |
"name": "flagBadShape", | |
"ordinal": 52, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "chunkId", | |
"ordinal": 53, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "subChunkId", | |
"ordinal": 54, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Not filled. Table to store high signal-to-noise "sources" measured on the coadd exposures in DeepCoadd.", | |
"name": "DeepSource" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "", | |
"name": "deepCoaddId", | |
"ordinal": 0, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "metadataKey", | |
"ordinal": 1, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Type of exposure <ul> <li>1: Science CCD</li> <li>2: Difference Imaging CCD</li> <li>3: Good-seeing coadd</li> <li>4: Deep coadd</li> <li>5: Chi-squared coadd</li> <li>6: Keith coadd</li> </ul>", | |
"name": "exposureType", | |
"ordinal": 2, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "intValue", | |
"ordinal": 3, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "doubleValue", | |
"ordinal": 4, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "stringValue", | |
"ordinal": 5, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Not filled. Generic key-value pair metadata for DeepCoadd.", | |
"name": "DeepCoadd_Metadata" | |
}, | |
{ | |
"columns": [ | |
{ | |
"description": "Primary key (unique identifier).", | |
"name": "scienceCcdExposureId", | |
"ordinal": 0, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "Run number.", | |
"name": "run", | |
"ordinal": 1, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Camera column.", | |
"name": "camcol", | |
"ordinal": 2, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Id of the filter for the band.", | |
"name": "filterId", | |
"ordinal": 3, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "Field number.", | |
"name": "field", | |
"ordinal": 4, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Filter name, pulled in from the Filter table.", | |
"name": "filterName", | |
"ordinal": 5, | |
"ucd": "instr.bandpass", | |
"unit": "" | |
}, | |
{ | |
"description": "ICRS R.A. of image center, corresponding to FITS pixel coordinates ((NAXIS1 + 1)/2, (NAXIS2 + 1)/2).", | |
"name": "ra", | |
"ordinal": 6, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec. of image center, corresponding to FITS pixel coordinates ((NAXIS1 + 1)/2, (NAXIS2 + 1)/2).", | |
"name": "decl", | |
"ordinal": 7, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "Level 20 HTM ID of (ra, decl)", | |
"name": "htmId20", | |
"ordinal": 8, | |
"ucd": "pos.HTM", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "equinox", | |
"ordinal": 9, | |
"ucd": "pos.equinox", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "raDeSys", | |
"ordinal": 10, | |
"ucd": "pos.frame", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "ctype1", | |
"ordinal": 11, | |
"ucd": "pos.wcs.ctype", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "ctype2", | |
"ordinal": 12, | |
"ucd": "pos.wcs.ctype", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "crpix1", | |
"ordinal": 13, | |
"ucd": "pos.wcs.crpix", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "", | |
"name": "crpix2", | |
"ordinal": 14, | |
"ucd": "pos.wcs.crpix", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "", | |
"name": "crval1", | |
"ordinal": 15, | |
"ucd": "pos.wcs.crval", | |
"unit": "deg" | |
}, | |
{ | |
"description": "", | |
"name": "crval2", | |
"ordinal": 16, | |
"ucd": "pos.wcs.crval", | |
"unit": "deg" | |
}, | |
{ | |
"description": "", | |
"name": "cd1_1", | |
"ordinal": 17, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd1_2", | |
"ordinal": 18, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd2_1", | |
"ordinal": 19, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "", | |
"name": "cd2_2", | |
"ordinal": 20, | |
"ucd": "pos.wcs.cdmatrix", | |
"unit": "deg/pixel" | |
}, | |
{ | |
"description": "ICRS RA of image corner 1, corresponding to FITS pixel coordinates (0.5, 0.5)", | |
"name": "corner1Ra", | |
"ordinal": 21, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 1, corresponding to FITS pixel coordinates (0.5, 0.5)", | |
"name": "corner1Decl", | |
"ordinal": 22, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 2, corresponding to FITS pixel coordinates (0.5, NAXIS2 + 0.5)", | |
"name": "corner2Ra", | |
"ordinal": 23, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 2, corresponding to FITS pixel coordinates (0.5, NAXIS2 + 0.5)", | |
"name": "corner2Decl", | |
"ordinal": 24, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 3, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, NAXIS2 + 0.5)", | |
"name": "corner3Ra", | |
"ordinal": 25, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 3, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, NAXIS2 + 0.5)", | |
"name": "corner3Decl", | |
"ordinal": 26, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of image corner 4, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, 0.5)", | |
"name": "corner4Ra", | |
"ordinal": 27, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of image corner 4, corresponding to FITS pixel coordinates (NAXIS1 + 0.5, 0.5)", | |
"name": "corner4Decl", | |
"ordinal": 28, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "binary representation of the 4-corner polygon for the exposure.", | |
"name": "poly", | |
"ordinal": 29, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Time (MJD, TAI) at the start of the exposure", | |
"name": "taiMjd", | |
"ordinal": 30, | |
"ucd": "time.start", | |
"unit": "d" | |
}, | |
{ | |
"description": "Time (UTC, 1s precision) at the start of the exposure.", | |
"name": "obsStart", | |
"ordinal": 31, | |
"ucd": "time.start", | |
"unit": "" | |
}, | |
{ | |
"description": "Time (ISO8601 format, UTC) at the mid-point of the combined exposure.", | |
"name": "expMidpt", | |
"ordinal": 32, | |
"ucd": "time.epoch", | |
"unit": "" | |
}, | |
{ | |
"description": "Duration of exposure.", | |
"name": "expTime", | |
"ordinal": 33, | |
"ucd": "time.duration", | |
"unit": "s" | |
}, | |
{ | |
"description": "Number of images co-added to create a deeper image.", | |
"name": "nCombine", | |
"ordinal": 34, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Binning of the CCD in x.", | |
"name": "binX", | |
"ordinal": 35, | |
"ucd": "meta.number", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Binning of the CCD in y.", | |
"name": "binY", | |
"ordinal": 36, | |
"ucd": "meta.number", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "", | |
"name": "fluxMag0", | |
"ordinal": 37, | |
"ucd": "phot.flux.density", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "fluxMag0Sigma", | |
"ordinal": 38, | |
"ucd": "stat.error;phot.flux.density", | |
"unit": "" | |
}, | |
{ | |
"description": "", | |
"name": "fwhm", | |
"ordinal": 39, | |
"ucd": "instr.obsty.seeing", | |
"unit": "arcsec" | |
}, | |
{ | |
"description": "CCD FITS file path relative to the SFM pipeline output directory.", | |
"name": "path", | |
"ordinal": 40, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "", | |
"name": "Science_Ccd_Exposure" | |
} | |
] | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Show information on database S12_sdss | |
GET /meta/v1/db/S12_sdss HTTP/1.1 | |
Accept: application/json | |
Host: localhost:5000 | |
HTTP/1.0 200 OK | |
Content-Type: application/json | |
Content-Length: 237 | |
Server: Werkzeug/0.12.1 Python/3.5.2 | |
Date: Tue, 20 Jun 2017 23:16:14 GMT | |
{ | |
"default_schema": "sdss_stripe82_00", | |
"host": "example.com", | |
"name": "S12_sdss", | |
"port": 4040, | |
"schemas": [ | |
{ | |
"description": null, | |
"is_default_schema": true, | |
"name": "sdss_stripe82_00" | |
} | |
] | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# List Databases | |
GET /meta/v1/db HTTP/1.1 | |
Accept: application/json | |
Host: localhost:5000 | |
HTTP/1.0 200 OK | |
Content-Type: application/json | |
Content-Length: 156 | |
Server: Werkzeug/0.12.1 Python/3.5.2 | |
Date: Tue, 20 Jun 2017 23:16:57 GMT | |
{ | |
"results": [ | |
{ | |
"default_schema": "sdss_stripe82_00", | |
"host": "example.com", | |
"name": "S12_sdss", | |
"port": 4040 | |
} | |
] | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Show information about a specific table (implicit default schema) | |
GET /meta/v1/db/S12_sdss/tables/DeepForcedSource/ HTTP/1.1 | |
Accept: application/json | |
Host: localhost:5000 | |
HTTP/1.0 200 OK | |
Content-Type: application/json | |
Content-Length: 12087 | |
Server: Werkzeug/0.12.1 Python/3.5.2 | |
Date: Wed, 21 Jun 2017 01:00:25 GMT | |
{ | |
"result:": { | |
"columns": [ | |
{ | |
"description": "Primary key (unique identifier)", | |
"name": "deepForcedSourceId", | |
"ordinal": 0, | |
"ucd": "meta.id;src", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of CCD the forced-source was detected and measured on (pointer to Science_Ccd_Exposure).", | |
"name": "scienceCcdExposureId", | |
"ordinal": 1, | |
"ucd": "meta.id;obs.image", | |
"unit": "" | |
}, | |
{ | |
"description": "ID of filter used for the exposure the source was detected and measured on.", | |
"name": "filterId", | |
"ordinal": 2, | |
"ucd": "meta.id;instr.filter", | |
"unit": "" | |
}, | |
{ | |
"description": "Middle of exposure time (MJD, TAI).", | |
"name": "timeMid", | |
"ordinal": 3, | |
"ucd": "time.epoch", | |
"unit": "d" | |
}, | |
{ | |
"description": "Exposure time (TAI) or, in case of measurement on coadded snap exposure pairs, the sum of snap exposure times.", | |
"name": "expTime", | |
"ordinal": 4, | |
"ucd": "time.duration", | |
"unit": "s" | |
}, | |
{ | |
"description": "ID of object that triggered measurement of this forced-source (pointer to DeepSource).", | |
"name": "deepSourceId", | |
"ordinal": 5, | |
"ucd": "meta.id;src", | |
"unit": "" | |
}, | |
{ | |
"description": "ICRS R.A. of object that triggered measurement of this forced-source.", | |
"name": "deepSourceRa", | |
"ordinal": 6, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec. of object that triggered measurement of this forced-source.", | |
"name": "deepSourceDecl", | |
"ordinal": 7, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS RA of forced-source centroid (x, y).", | |
"name": "ra", | |
"ordinal": 8, | |
"ucd": "pos.eq.ra", | |
"unit": "deg" | |
}, | |
{ | |
"description": "ICRS Dec of forced-source centroid (x, y).", | |
"name": "decl", | |
"ordinal": 9, | |
"ucd": "pos.eq.dec", | |
"unit": "deg" | |
}, | |
{ | |
"description": "Variance of ra due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "raVar", | |
"ordinal": 10, | |
"ucd": "stat.variance;pos.eq.ra", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Variance of decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "declVar", | |
"ordinal": 11, | |
"ucd": "stat.variance;pos.eq.dec", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Covariance of ra, decl due to centroid uncertainty (xVar, xyCov, yVar).", | |
"name": "radeclCov", | |
"ordinal": 12, | |
"ucd": "stat.covariance;pos.eq", | |
"unit": "arcsec^2" | |
}, | |
{ | |
"description": "Level 20 HTM ID of (ra, decl)", | |
"name": "htmId20", | |
"ordinal": 13, | |
"ucd": "pos.HTM", | |
"unit": "" | |
}, | |
{ | |
"description": "Pixel axis 1 coordinate of forced-source centroid, LSST pixel coordinate conventions.", | |
"name": "x", | |
"ordinal": 14, | |
"ucd": "pos.cartesian.x", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Pixel axis 2 coordinate of forced-source centroid, LSST pixel coordinate conventions.", | |
"name": "y", | |
"ordinal": 15, | |
"ucd": "pos.cartesian.y", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of x.", | |
"name": "xVar", | |
"ordinal": 16, | |
"ucd": "stat.variance;pos.cartesian.x", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of y.", | |
"name": "yVar", | |
"ordinal": 17, | |
"ucd": "stat.variance;pos.cartesian.y", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Covariance of x and y", | |
"name": "xyCov", | |
"ordinal": 18, | |
"ucd": "stat.covariance", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Uncalibrated PSF flux of forced-source.", | |
"name": "psfFlux", | |
"ordinal": 19, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of psfFlux.", | |
"name": "psfFluxSigma", | |
"ordinal": 20, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated aperture flux of forced-source.", | |
"name": "apFlux", | |
"ordinal": 21, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of apFlux.", | |
"name": "apFluxSigma", | |
"ordinal": 22, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated model flux of forced-source.", | |
"name": "modelFlux", | |
"ordinal": 23, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of modelFlux", | |
"name": "modelFluxSigma", | |
"ordinal": 24, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncalibrated instrumental flux of forced-source.", | |
"name": "instFlux", | |
"ordinal": 25, | |
"ucd": "phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Uncertainty of instFlux.", | |
"name": "instFluxSigma", | |
"ordinal": 26, | |
"ucd": "stat.error;phot.count;stat.uncalib", | |
"unit": "adu" | |
}, | |
{ | |
"description": "Aperture correction factor applied to fluxes", | |
"name": "apCorrection", | |
"ordinal": 27, | |
"ucd": "arith.factor", | |
"unit": "" | |
}, | |
{ | |
"description": "Aperture correction uncertainty", | |
"name": "apCorrectionSigma", | |
"ordinal": 28, | |
"ucd": "stat.error", | |
"unit": "" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIx", | |
"ordinal": 29, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "First moment.", | |
"name": "shapeIy", | |
"ordinal": 30, | |
"ucd": "", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIx.", | |
"name": "shapeIxVar", | |
"ordinal": 31, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Variance of momentIy.", | |
"name": "shapeIyVar", | |
"ordinal": 32, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Covariance of momentIx and momentIy.", | |
"name": "shapeIxIyCov", | |
"ordinal": 33, | |
"ucd": "stat.variance", | |
"unit": "pixel" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxx", | |
"ordinal": 34, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIyy", | |
"ordinal": 35, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Second moment.", | |
"name": "shapeIxy", | |
"ordinal": 36, | |
"ucd": "", | |
"unit": "pixel^2" | |
}, | |
{ | |
"description": "Variance of shapeIxx.", | |
"name": "shapeIxxVar", | |
"ordinal": 37, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIyyVar", | |
"ordinal": 38, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Variance of shapeIyy.", | |
"name": "shapeIxyVar", | |
"ordinal": 39, | |
"ucd": "stat.variance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIyy.", | |
"name": "shapeIxxIyyCov", | |
"ordinal": 40, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIxx and shapeIxy.", | |
"name": "shapeIxxIxyCov", | |
"ordinal": 41, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Covariance of shapeIyy and shapeIxy.", | |
"name": "shapeIyyIxyCov", | |
"ordinal": 42, | |
"ucd": "stat.covariance", | |
"unit": "pixel^4" | |
}, | |
{ | |
"description": "Probability of being extended.<descr> <ucd>stat.probability</ucd>", | |
"name": "extendedness", | |
"ordinal": 43, | |
"ucd": "stat.probability", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source was detected as significantly negative. <ucd>meta.code</ucd>", | |
"name": "flagNegative", | |
"ordinal": 44, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid algorithm used to feed centers to other measurement algorithms failed.", | |
"name": "flagBadMeasCentroid", | |
"ordinal": 45, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source is in region labeled EDGE.", | |
"name": "flagPixEdge", | |
"ordinal": 46, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source footprint includes interpolated pixels.", | |
"name": "flagPixInterpAny", | |
"ordinal": 47, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source center is close to interpolated pixels.", | |
"name": "flagPixInterpCen", | |
"ordinal": 48, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source footprint includes saturated pixels.", | |
"name": "flagPixSaturAny", | |
"ordinal": 49, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if forced-source center is close to saturated pixels.", | |
"name": "flagPixSaturCen", | |
"ordinal": 50, | |
"ucd": "meta.code", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the psfFlux measurement failed.", | |
"name": "flagBadPsfFlux", | |
"ordinal": 51, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the apFlux measurement failed.", | |
"name": "flagBadApFlux", | |
"ordinal": 52, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the modelFlux measurement failed.", | |
"name": "flagBadModelFlux", | |
"ordinal": 53, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the instFlux measurement failed.", | |
"name": "flagBadInstFlux", | |
"ordinal": 54, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the centroid measurement failed.", | |
"name": "flagBadCentroid", | |
"ordinal": 55, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Set if the shape measurement did not completely succeed.", | |
"name": "flagBadShape", | |
"ordinal": 56, | |
"ucd": "meta.code.error", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "chunkId", | |
"ordinal": 57, | |
"ucd": "", | |
"unit": "" | |
}, | |
{ | |
"description": "Internal column used by qserv.", | |
"name": "subChunkId", | |
"ordinal": 58, | |
"ucd": "", | |
"unit": "" | |
} | |
], | |
"description": "Not filled. Table of forced-photometry sources, measured using positions of objects from DeepSource.", | |
"name": "DeepForcedSource" | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment