I am undertaking a flora species inventory at each of approximately 40 plots. The location of each plot will be recorded with GPS and mapped in a GIS layer. I would like to include the full species inventory (expected to be ~30-40 species per plot) in the attribute data for each plot. Ideally, I'd like to be able to query the plots for an individual species (not all species are expected to occur in all plots).
What is the best way to organise my data? Does each individual species require its own cell (in which case, how should I structure/name the column headings?), or is there an effective way of incorporating the entire list in a single cell (i.e. single column with title 'species list', or something similar)?
Or perhaps I should organise the species data as presence/absence, including species names (or codes) as column headings for all species recorded across all plots?
Help much appreciated.