2012-11-14 conference call on data provider metadata¶
To do¶
remove completely-protected plots from VegBIEN- SALVIAS plots with plotMetadata.AccessCode = 1
map VegBank.plot.confidentialitystatus to location.confidentialitystatusmap SALVIAS.plotMetadata.AccessCode to location.confidentialitystatus- map
VegBank.observationcontributor, projectcontributor- include roles
store whether each provider is primary or aggregator- e.g. SALVIAS is aggregator
index specimens data subprovidersimport bien_web.dataSourceNameCorrected to source tableinclude whether subprovider is a herbarium
- map SALVIAS.projects.project_pi to SALVIAS subprovider data
- obtain project_pi contact info from salvias_users.tbl_users on nimoy
- map VegBank.coverindex, covermethod
obtain herbarium contact info from Index Herbariorum
Schema/mappings¶
exclude method data which does not relate to plot methodTEAM.Method, which = Derived
make taxonoccurrence.verbatimcollectorname an fkey to partyscope referencename by source, because institutionCodes are not globally uniquerename reference -> sourcemake location.confidentialitystatus an enumallow multiple institutionCodes for each specimenreplicate (REMIB has this)move location.confidentialitystatus to locationevent: added it to locationevent instead, to allow multiple places to specify access levelchange coordinates.coordsaccuracy_deg units to mpopulate coordinates.coordsaccuracy_m based on VegBank.confidentialitystatus fuzzing radiusmerge source and party: better to leave them separate, because a source stores a globally-unique name while a party's name is unique only within a source