I will present my involvement in producing and employing photometric redshift catalogues, covering various sky areas and depths. I will mostly focus on two of them – 2MPZ and WISE x SuperCOSMOS – which are unique in terms of their combination of sky coverage (respectively ~4pi and ~3pi sterad) and depth (z<0.2 and z<0.4). They are continuously finding various astrophysical uses, and I will discuss some of them. These include detailed local cosmography, crucial in the recent discovery of the Vela Supercluster; universal isotropy and homogeneity tests; cross-correlations with other all-sky datasets, such as Planck CMB lensing or Fermi gamma-ray unresolved background; and even searches for electromagnetic counterparts of gravitational wave emitters. Finally, I will briefly describe my current work on deriving machine-learning photo-zs for the Kilo-Degree Survey – one of the major imaging datasets of the current decade.