Searchable Online Database
Each data release has a database context allowing the user to construct sql queries and download parameters and/or FITS files. Available parameters are listed in the glossaries. Parameter names may be slightly modified from the original data tables and papers.
Database Links by Data Release
- ECO DR3 searchable database and glossary for ECO including an expanded HI inventory, new environment metrics, and updates to distances, photometry, and survey membership as documented in Hutchens et al. (2023). If not obsolete or superseded, parameters from previous data releases are included by crossmatch.
- RESOLVE DR4 searchable database and glossary for RESOLVE including a revised HI inventory (with parameters matching ECO DR3), new environment metrics, and updates to distances, photometry, and survey membership as documented in Hutchens et al. (2023). If not obsolete or superseded, parameters from previous data releases are included by crossmatch. For convenience, RESOLVE DR4 includes the ECO names of RESOLVE-A galaxies.
- ECO DR2 searchable database and glossary for ECO including updated photometry and environment metrics from Eckert et al. (2016) and (2017). WARNING: As of this time the recommended deletion of galaxy rs1492 (see below) has not been performed. It should be excluded from all analysis.
- RESOLVE DR3 searchable database and glossary merging DR2 with group catalog data from Eckert et al. (2016) and Eckert et al. (2017) as well as tidal feature, morphology, and nearest neighbor data from Table 2 of Hood et al. (2018) as revised in its erratum. For convenience, DR3 also includes an internal extinction corrected u-r color matching ECO and the ECO names of RESOLVE-A galaxies. WARNING: DR3 was updated on 5/11/2021 to reflect the Hood erratum, but as of this time the recommended deletion of galaxy rs1492 has not been performed. It should be excluded from all analysis.
- RESOLVE DR2 searchable database and glossary merging DR1 with Table 1 and Table 2 from Stark et al. (2016) and its erratum
- RESOLVE DR1 searchable database and glossary based on Table 1 from Eckert et al. (2015) and its erratum
- ECO DR1 searchable database and glossary based on Table 1 from Moffett et al. (2015)
Sample Queries
-
RESOLVE or ECO: galaxies in a range of RA and Dec
select name, RAdeg, DEdeg, cz, logMstar where RAdeg > 0.0 and RAdeg < 45.0 and DEdeg > 0.0 and DEdeg < 1.25 -
RESOLVE: a particular galaxy
select RAdeg, DEdeg, cz, modelu_r, logMstar, b_a where name = 'rs0461' -
RESOLVE: massive blue galaxies
select RAdeg, DEdeg, modelu_r, logMstar where logMstar > 10.0 and modelu_r < 1.5 -
RESOLVE: galaxies in RESOLVE-A volume above luminosity completeness limit (PGF calibration sample from Eckert et al. 2015)
select modelu_r, logMstar where FL_insample and RAdeg > 131.25 and RAdeg < 236.25 and Grpcz > 4500. and Grpcz < 7000. -
ECO: early type galaxies
select name, logMstar, modelu_rcorr, MorphEL where MorphEL= "E" -
ECO: satellites in massive halos
select name, MorphEL, logMstar, modelu_rcorr, R50 where FC = 0 and logMh > 13.0 -
ECO: subsample overlapping public ALFALFA data (ECO+A sample in Moffett et al. 2015)
select name, logMstar, modelu_j, FC, logMh, Den1Mpc where FA = 1