updated to find Boswellia records and really REALLY simply map them, needs to be updated to show different taxa in different colours, include legend, and preferably be done in a nicer looking map
latest query to remove duplicates, includes Herbarium Specimens from Socotra, with herbarium, and collNum formatted from the collection number and postfix fields, as well as adding DET info (not in databasin8.R) to add determination names (species names) and determiner info (det by whoever), returns 7104 records or so - this does need to be checked though as it may have incorrect joins - go over the logic of each join to be sure
some splinters of the smaller queries which became databasin9.R, set aside as didntWork since they may be useful to keep
updated to include databasin9.R which includes determination information which databasin8.R didn't.  Needs more work on documentation and breakdown of databasin9 query to avoid the headaches which were provoked getting to the point where it worked :D
autojunk as usual