2 OPTICAL AND RADIO CATALOGUES

3 FIRST-SDSS MATCHING

4 NVSS MATCHING

5 SPECTROSCOPIC DATA

6 SURVEY COMPLETENESS

7 SPECTRAL CLASSIFICATION

8 THE SPECTROSCOPIC DATA TABLE

9 LARGESS SAMPLE CHARACTERISTICS

10 THE HOST GALAXIES OF HIGH- AND LOW-EXCITATION RADIO AGN

11 SUMMARY