Database Properties
Database Type: PostgreSQL - 14.17
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| spec1d_r30_g102_v2_wave | 0 | 0 | 2 | -1 | Table | |
| exposure_log | 0 | 2 | 22 | -1 | Table | Exposure files stored on AWS |
| mosaic_tiles_exposures | 0 | 1 | 7 | 9128847 | Table | Matching between exposures and subtiles |
| spec1d_r30_g102_v2 | 0 | 0 | 8 | -1 | Table | |
| nirspec_unique_match | 0 | 1 | 2 | 206453 | Table | |
| nirspec_cutouts | 0 | 0 | 57 | 816161 | Table | |
| spec1d_r30_g800l_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_r30_g800l |
| nirspec_slits | 0 | 0 | 23 | 1933267 | Table | |
| observation | 1 | 0 | 38 | -1 | Table | |
| mast_products | 5 | 1 | 2 | -1 | Table | Data products from the MAST API |
| nirspec_djapipes | 0 | 0 | 153 | 11706 | Table | Bagpipes stellar population fits to PRISM spectra by Rashmi Gottumukkala |
| stellar_fit | 0 | 0 | 15 | -1 | Table | Stellear template fits to likely point sources |
| survey_fields | 1 | 0 | 4 | -1 | Table | |
| spitzer_aors | 0 | 1 | 2 | -1 | Table | Spitzer AOR info |
| nirspec_phot_match | 0 | 0 | 7 | 363135 | Table | |
| mosfire_extractions | 15 | 1 | 65 | -1 | Table | MOSFIRE spectral extractions |
| exposure_files | 2 | 1 | 44 | 310203 | Table | Processed exposure information |
| spec1d_g102_v2_wave | 0 | 0 | 2 | -1 | Table | |
| charge_fields | 6 | 0 | 376 | -1 | Table | Summary of the field associations for the CHArGE database |
| redshift_fit_quasar_v2 | 0 | 0 | 230 | -1 | Table | |
| redshift_fit_quasar | 0 | 1 | 230 | -1 | Table | Redshift fits with limited line + spline continuum templates |
| redshift_fit | 0 | 1 | 230 | -1 | Table | Redshift fits with galaxy templates |
| reprocess_rates | 0 | 0 | 10 | 6937 | Table | |
| wcs_log | 0 | 0 | 11 | 67067 | Table | Astrometryc alignment log |
| mosfire_slit_footprints | 0 | 1 | 4 | -1 | Table | |
| nirspec_integrated | 0 | 0 | 227 | 90426 | Table | Rest and observed-frame bandpasses integrated through observed spectra |
| nirspec_unique | 1 | 0 | 21 | 54344 | Table | |
| spatial_ref_sys | 0 | 0 | 5 | -1 | Table | |
| combined_tiles_filters | 0 | 0 | 7 | 14560 | Table | |
| spec1d_r30_g141_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_r30_g141 |
| spec1d_g141 | 0 | 0 | 10 | -1 | Table | Long 1D extractions of g141 spectra |
| spec1d_g102_v2 | 0 | 0 | 10 | -1 | Table | |
| spec1d_g800l_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_g800l |
| combined_tiles | 0 | 0 | 24 | 70517 | Table | |
| mosfire_datemask | 3 | 0 | 15 | -1 | Table | Master MOSFIRE mask list |
| spec1d_g141_v2_wave | 0 | 0 | 2 | -1 | Table | |
| nirspec_extractions_helper | 0 | 0 | 8 | 63588 | Table | |
| spec1d_g102 | 0 | 0 | 10 | -1 | Table | Long 1D extractions of G102 spectra |
| spec1d_g141_v2 | 0 | 0 | 10 | -1 | Table | |
| assoc_table | 0 | 0 | 42 | 359483 | Table | Association descriptions |
| redshift_fit_dash | 0 | 0 | 230 | -1 | Table | |
| multibeam_v2 | 0 | 0 | 21 | 72738 | Table | |
| mosfire_spectra_j | 0 | 3 | 7 | -1 | Table | 1D spectra in J band |
| spec1d_r30_g102_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_r30_g102 |
| photometry_zeropoints | 0 | 0 | 10 | 2127 | Table | |
| mosfire_spectra_h | 0 | 3 | 7 | -1 | Table | 1D spectra in H band |
| shifts_log | 0 | 1 | 9 | 244653 | Table | Relative shifts log |
| mosfire_spectra_k | 0 | 3 | 7 | -1 | Table | 1D spectra in K band |
| spec1d_g102_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_g102 |
| photometry_apcorr | 0 | 1 | 1556 | -1 | Table | Full dump of multiband matched-aperture photometry |
| mast_query | 1 | 0 | 24 | -1 | Table | Query output from the MAST API |
| grizli_photometry | 0 | 0 | 415 | 2315192 | Table | |
| pure_parallel_exposures | 0 | 0 | 14 | -1 | Table | |
| multibeam | 0 | 0 | 21 | -1 | Table | Properties of the MultiBeam extractions |
| beam_geometry | 0 | 0 | 20 | -1 | Table | Geometry and metadata of 2D extracted beams |
| spec1d_g141_wave | 0 | 0 | 2 | -1 | Table | Wavelengths associated with spec1d_g141 |
| jwst_sources | 0 | 0 | 6 | 14945 | Table | Compilation of sources from arXiv publications, see https://github.com/dawn-cph/jwst-sources |
| mosfire_spectra_y | 0 | 3 | 7 | -1 | Table | 1D spectra in Y band |
| nirspec_unique_update | 0 | 0 | 21 | 403 | Table | |
| redshift_fit_test | 0 | 0 | 230 | -1 | Table | |
| nirspec_redshifts | 0 | 0 | 293 | 159529 | Table | Results of redshift and line fits to NIRSpec spectra |
| spec1d_r30_g141_v2_wave | 0 | 0 | 2 | -1 | Table | |
| exposure_saturated | 0 | 1 | 3 | 189963620 | Table | |
| astrometry_reference | 0 | 0 | 5 | 4410045 | Table | |
| beam_geometry_v2 | 0 | 0 | 20 | 807427 | Table | |
| spec1d_r30_g141_v2 | 0 | 0 | 8 | -1 | Table | |
| mosfire_exposures | 0 | 1 | 23 | -1 | Table | Individual MOSFIRE exposure |
| nirspec_extractions | 0 | 1 | 41 | 203265 | Table | Metadata of extracted combined NIRSpec spectra |
| mosaic_tiles | 0 | 0 | 16 | -1 | Table | Master list of sky tiles |
| field_observation | 0 | 2 | 2 | -1 | Table | |
| redshift_fit_v2 | 0 | 0 | 290 | 77470 | Table | |
| spec1d_r30_g141 | 0 | 0 | 8 | -1 | Table | R=30 1D extractions of g141 spectra |
| nirspec_redshifts_manual | 0 | 0 | 7 | 116447 | Table | Grades and comments from visual inspections |
| spitzer_log | 0 | 1 | 16 | -1 | Table | Spitzer overlaps with HST footprints |
| mosfire_phot_matches | 0 | 3 | 8 | -1 | Table | Matches of MOSFIRE targets to external catalogs |
| spec1d_r30_g102 | 0 | 0 | 8 | -1 | Table | R=30 1D extractions of G102 spectra |
| exposure_region_mask | 0 | 1 | 5 | 1415 | Table | |
| stellar_fit_v2 | 0 | 0 | 15 | -1 | Table |