We present the methodology and data behind the photometric redshift database of the Sloan Digital Sky Survey Data Release 12 (SDSS DR12). We adopt a hybrid technique, empirically estimating the redshift via local regression on a spectroscopic training set, then fitting a spectrum template to obtain K-corrections and absolute magnitudes. The SDSS spectroscopic catalog was augmented with data from other, publicly available spectroscopic surveys to mitigate target selection effects. The training set is comprised of 1, 976, 978 galaxies, and extends up to redshift z ≈ 0.8, with a useful coverage of up to z ≈ 0.6. We provide photometric redshifts and realistic error estimates for the 208, 474, 076 galaxies of the SDSS primary photometric catalog. We achieve an average bias of ∆z norm = 5.84 × 10 −5 , a standard deviation of σ (∆z norm ) = 0.0205, and a 3σ outlier rate of P o = 4.11% when cross-validating on our training set. The published redshift error estimates and photometric error classes enable the selection of galaxies with high quality photometric redshifts. We also provide a supplementary error map that allows additional, sophisticated filtering of the data.

We introduce a value-added full-sky catalogue of galaxies, named as Galaxy List for the Advanced Detector Era, or GLADE. The purpose of this catalogue is to (i) help identifications of host candidates for gravitational-wave events, (ii) support target selections for electromagnetic follow-up observations of gravitational-wave candidates, (iii) provide input data on the matter distribution of the local universe for astrophysical or cosmological simulations, and (iv) help identifications of host candidates for poorly localised electromagnetic transients, such as gamma-ray bursts observed with the InterPlanetary Network. Both being potential hosts of astrophysical sources of gravitational waves, GLADE includes inactive and active galaxies as well. GLADE was constructed by cross-matching and combining data from five separate (but not independent) astronomical catalogues: GWGC, 2MPZ, 2MASS XSC, HyperLEDA and SDSS-DR12Q. GLADE is complete up to d L = 37 +3 −4 Mpc in terms of the cumulative B-band luminosity of galaxies within luminosity distance d L , and contains all of the brightest galaxies giving half of the total B-band luminosity up to d L = 91 Mpc. As B-band luminosity is expected to be a tracer of binary neutron star mergers (currently the prime targets of joint GW+EM detections), our completeness measures can be used as estimations of completeness for containing all binary neutron star merger hosts in the local universe.

In this work we present an atlas of composite spectra of galaxies based on the data of the Sloan Digital Sky Survey Data Release 7 (SDSS DR7). Galaxies are classified by colour, nuclear activity and star formation activity to calculate average spectra of high signal‐to‐noise ratio (S/N) and resolution ( at Δλ= 1 Å), using an algorithm that is robust against outliers. Besides composite spectra, we also compute the first five principal components of the distributions in each galaxy class to characterize the nature of variations of individual spectra around the averages. The continua of the composite spectra are fitted with BC03 stellar population synthesis models to extend the wavelength coverage beyond the coverage of the SDSS spectrographs. Common derived parameters of the composites are also calculated: integrated colours in the most popular filter systems, line‐strength measurements and continuum absorption indices (including Lick indices). These derived parameters are compared with the distributions of parameters of individual galaxies, and it is shown on many examples that the composites of the atlas cover much of the parameter space spanned by SDSS galaxies. By co‐adding thousands of spectra, a total integration time of several months can be reached, which results in extremely low noise composites. The variations in redshift not only allow for extending the spectral coverage bluewards to the original wavelength limit of the SDSS spectrographs, but also make higher spectral resolution achievable. The composite spectrum atlas is available online at http://www.vo.elte.hu/compositeatlas.

The last decade has seen a dramatic change in the way astronomy is carried out. The dawn of the the new microelectronic devices, like CCDs has dramatically extended the amount of observed data. Large, in some cases all sky surveys emerged in almost all the wavelength ranges of the observable spectrum of electromagnetic waves. This large amount of data has to be organized, published electronically and a new style of data retrieval is essential to exploit all the hidden information in the multiwavelength data. Many statistical algorithms required for these tasks run reasonably fast when using small sets of in-memory data, but take noticeable performance hits when operating on large databases that do not fit into memory. We utilize new software technologies to develop and evaluate fast multidimensional indexing schemes that inherently follow the underlying, highly non-uniform distribution of the data: they are layered uniform indices, hierarchical binary space partitioning, and sampled flat Voronoi tessellation of the data. These techniques can dramatically speed up operations such as finding similar objects by example, classifying objects or comparing extensive simulation sets with observations.

According to the separate universe conjecture, spherically symmetric sub-regions in an isotropic universe behave like mini-universes with their own cosmological parameters. This is an excellent approximation in both Newtonian and general relativistic theories. We estimate local expansion rates for a large number of such regions, and use a scale parameter calculated from the volume-averaged increments of local scale parameters at each time step in an otherwise standard cosmological N -body simulation. The particle mass, corresponding to a coarse graining scale, is an adjustable parameter. This mean field approximation neglects tidal forces and boundary effects, but it is the first step towards a non-perturbative statistical estimation of the effect of non-linear evolution of structure on the expansion rate. Using our algorithm, a simulation with an initial Ω m = 1 Einstein-de Sitter setting closely tracks the expansion and structure growth history of the ΛCDM cosmology. Due to small but characteristic differences, our model can be distinguished from the ΛCDM model by future precision observations. Moreover, our model can resolve the emerging tension between local Hubble constant measurements and the Planck best-fitting cosmology. Further improvements to the simulation are necessary to investigate light propagation and confirm full consistency with cosmic microwave background observations.