Rushworth plant survey 1984

PHP page connecting to mysql database at macfishy.com

The database has two tables (as at June 2018)
Table specrecords - contains data for specimen, collection event and identification.(19 fields)
Table locations - contains data for location - lat, long etc.(12 fields)
Link to data definition page

Sample data from plants table using query "SELECT * plants WHERE plantname LIKE 'Acacia%' ORDER BY plantname;"

Sample data from plants table using query SELECT DISTINCT plantname FROM plants ORDER BY plantname;

Species count 94

Next an INNER JOIN is used to get the latitude and longitude from the locations table to join to the specrecords table
sql for the following table
"SELECT specrecords.collNum, specrecords.genus, specrecords.species, locations.latitude, locations.longitude, specrecords.collDate FROM specrecords LEFT JOIN locations ON specrecords.locationID=locations.locationID";