40 likes | 112 Views
Dataset Annotation Graphical Notation. Entity <<observation>>. Entity <<observation>>. Entity <<observation>>. Relationship <<context>>. Characteristic ( Standard ) <<measurement>>. Relationship <<context>>. Key for entity. Entity <<observation>>. Entity <<observation>>. Entity
E N D
Dataset Annotation Graphical Notation Entity <<observation>> Entity <<observation>> Entity <<observation>> Relationship<<context>> Characteristic (Standard) <<measurement>> Relationship<<context>> Key for entity Entity <<observation>> Entity <<observation>> Entity <<observation>> Weak entity & identifying relationship Entity <<observation>> Characteristic (Standard) <<measurement>> Characteristic (Standard) <<measurement>> Basic Notation Partial Key for entity Distinct observation
Annotations … • HYD-GCES-0508A • “Annual summaries of daily observations from the USGS Streamflow gauging station on the Althama River near Doctortown, Georgia, for 1932 to 2004” • http://gce-lter.marsci.uga.edu/public/app/dataset_details.asp?Accession=HYD-GCES-0508a • NOTE: this example not fully available via the KNB • WO8802A • “Spartina alterniflora leaf measurements, part A” • http://www.vcrlter.virginia.edu/data/query/text/datasets/WO8802A.html • NOTE: this example not available via the KNB
HYD-GCES-0508a.1.2Annual summaries of daily observations from the USGS Streamflow Gauging Station on the Altamaha River near Doctortown, Georgia, for 1932 to 2004 • Attributes • Agency • StationID • Year • Yearly_Num_Daily_Mean_Discharge • Yearly_Min_Daily_Mean_Discharge • Yearly_Max_Daily_Mean_Discharge • Yearly_Sum_Daily_Mean_Discharge • Yearly_Mean_Daily_Mean_Discharge • Yearly_StdDev_Daily_Mean_Discharge • Yearly_SE_Daily_Mean_Discharge Agency <<observation>> EntityName (Nominal) = “USGS” <<measurement>> OperatedBy<<context>> Year(YearDateTime) <<measurement>> StreamflowGuagingStation <<observation>> AltamahaRiver <<observation>> TemporalDuration <<observation>> EntityName (USGSStationIdentifiers) <<measurement>> MonitoredBy<<context>> PartOf<<context>> Within<<context>> RiverSection <<observation>> MinimumDailyMean-Discharge (m^3/s) <<measurement>> StdErrDailyMean-Discharge (m^3/s) <<measurement>> MaximumDailyMean-Discharge (m^3/s) <<measurement>> StdDevDailyMean-Discharge (m^3/s) <<measurement>> SumDailyMean-Discharge (m^3/s) <<measurement>> MeanDailyMean-Discharge (m^3/s) <<measurement>>
WO8802A Spartina alterniflora leaf measurements, part A • Attributes • Month • Day • Year • Site • Plot • Tag • Height • Leaves SpatialLocation <<observation>> TemporalPoint <<observation>> EntityName (Nominal) <<measurement>> Day(MMDDYYDateTime) <<measurement>> Within<<context>> ReplicatePlot <<observation>> EntityName (Nominal) <<measurement>> Within<<context>> Within<<context>> EntityName(Nominal) <<measurement>> Plant <<observation>> Height (cm) <<measurement>> PartOf<<context>> HasPart<<context>> LeafPopulation <<observation>> Count (Number) <<measurement>>