We have compiled the most complete compact and ultracompact HII region catalogue to date via multi-wavelength inspection of survey data. We utilise data from the recently available SASSy 850$\mu$m survey to identify massive star forming clumps in the outer Galaxy ($R_{\rm{GC}}>8.5$ kpc) and cross-match with infrared and radio data of known UC HII regions from the RMS database. For the inner Galaxy sample ($R_{\rm{GC}}<8.5$ kpc), we adopt the compact HII regions from previous works that used similar methods to cross match ATLASGAL with either CORNISH or RMS, depending on the location within the Galactic plane. We present a new UC HII region catalogue that more than doubles the original sample size of previous work, totaling 536 embedded HII regions and 445 host clumps. We examine the distance independent values of N$_{\rm{Ly}}/$M and L$_{\rm{bol}}/$M as proxies for massive star formation efficiency and overall star formation efficiency, respectively. We find a significant trend showing that L$_{\rm{bol}}/$M decreases with increasing $R_{\rm{GC}}$, suggesting that the overall star formation per unit mass is less in the outer Galaxy.

We report the discovery by the Robotic Optical Transient Experiment (ROTSE-IIIb) telescope of SN 2008es, an overluminous supernova (SN) at z=0.205 with a peak visual magnitude of -22.2. We present multiwavelength follow-up observations with the Swift satellite and several ground-based optical telescopes. The ROTSE-IIIb observations constrain the time of explosion to be 23+/-1 rest-frame days before maximum. The linear decay of the optical light curve, and the combination of a symmetric, broad H\alpha emission line profile with broad P Cygni H\beta and Na I \lambda5892 profiles, are properties reminiscent of the bright Type II-L SNe 1979C and 1980K, although SN 2008es is greater than 10 times more luminous. The host galaxy is undetected in pre-supernova Sloan Digital Sky Survey images, and similar to Type II-L SN 2005ap (the most luminous SN ever observed), the host is most likely a dwarf galaxy with M_r > -17. Swift Ultraviolet/Optical Telescope observations in combination with Palomar photometry measure the SED of the SN from 200 to 800 nm to be a blackbody that cools from a temperature of 14,000 K at the time of the optical peak to 6400 K 65 days later. The inferred blackbody radius is in good agreement with the radius expected for the expansion speed measured from the broad lines (10,000 km/s). The bolometric luminosity at the optical peak is 2.8 x 10^44 erg/s, with a total energy radiated over the next 65 days of 5.6 x 10^50 erg. We favor a model in which the exceptional peak luminosity is a consequence of the core-collapse explosion of a progenitor star with a low-mass extended hydrogen envelope and a stellar wind with a density close to the upper limit on the mass-loss rate measured from the lack of an X-ray detection by the Swift X-Ray Telescope. (Abridged).