We aspire to compile and synthesize knowledge of the spatial and temporal distribution of Texas' freshwater fish fauna. Based in the University of Texas' Ichthyology Collection (a division of the College of Natural Sciences' Department of Integrative Biology), the project focused originally on museum-vouchered specimens and associated data housed in our own collection, but grew (version 3) to incorporate additional specimen-based records from other institutions. We chose to use museum specimen records as our primary data source since, unlike other data sources, the accuracy of at least species identifications can always be verified and because museum specimens are essentially permanent and have been regularly collected statewide over a long period of time, they provide a much longer and more comprehensive history of the fauna than do any other source.

Our database includes records from specimen-holding institutions and more recently state and federal agency datasets, records extracted from the literature, citizen science data, angler-sourced data and other sources collected as far back as the mid 1800's. Our efforts have focused on standardizing, merging and subjecting the data to a rigorous error detection and correction process and making it available via the website and GBIF. The resulting fish occurrence records now include the state's approximately 280 species found in freshwaters and many more from its bays and off-shore. This database is available online and allows for data queries, on-the-fly mapping of results, and downloading of records to facilitate its utilization in education, research, and management.

While preserving and always displaying the donor institutions' verbatim data as we received it, we synonymized the thousands of scientific names received from contributing institutions to current taxonomic standards and added standardized common names. This, together with the project's extensive normalization and editing of all fields (dates, localities, place names, collector's names, etc.), georeferencing (applying latitude/longitude) with estimates of error, and addition of many categorical geographic fields (e.g., counties, drainage basins, Hydrologic Unit Codes, Native Fish Conservation Areas, etc.), as well as thorough documentation of the complete data processing methodology, results in a high quality data resource.

Precise manual georeferencing of most of the records with spatial error estimates facilitated discovery of probable identification errors via mapping and flagging of geographic outliers. Outlier specimens were pulled from donor institutions and examined to verify identification and original lables for collecting event information. In some collections up to 70% of flagged records proved to be mis-identified, and many that proved correct extended known ranges. High error rates indicate that un-vouchered identifications should always be interpreted cautiously.

The online database includes occurrence records, as well as collectors' original field notes, specimen photographs, images of ancillary documentation (e.g., original jar labels), a large collection of images of both preserved and live specimens, full color illustrations of many species, and identification keys. Also available are species accounts for most species that summarize current knowledge of biology and ecology as gleaned from the literature. Online documentation for all aspects of the project is available, and the website allows users to upload comments and images linked to any record or locality. We encourage anyone interested in the Texas freshwater fishes to help us improve this resource by commenting and uploading their own materials to the website.

The database continues to improve and grow as we request and receive new data, process it, and incorporate it into the database. We are exploring new ways of serving and improving species accounts and associated bibliographic data, and bringing the text of those independently written accounts into compliance with what our database tells us, which often differs from what is in the literature.