160 likes | 182 Views
Explore the structure of the Avian Knowledge Network's data architecture, encompassing user and partner contributions, taxonomies, observations, access controls, data visualization, and more.
E N D
AKN and Node Data Architecture Draft 7 June 8, 2009
USER PARTNER Covariates Taxonomies Observations Geography Metadata Events PROVIDER AKN Node Architecture Data Services (DiGIR) Node Node Data Warehouses Data Access Data Analysis Data Publishing Access Control Data Visualization Data Entry Data Processing Node Data Store (NodeDb) = data store = process or application = data flow
NodeDb USER USER PARTNER PARTNER PROVIDER Node Architecture and NodeDb Node Lists, counts, surveys banding records, nest data, etc… Bulk Data Process Data Analysis Data Entry Data Retrieval Avian Ecology Observations segregated by source (A, B, C..) Banding Nests Counts Lists Nests Behavior Counts Banding Habitat Ecology Specific Project Specific A Ecology Specific Project Specific Ecology Specific Project Specific B C Sampling Units Protocols Taxonomy Project Metadata Dictionaries Data components Users Rights Roles / Groups Logs Other Plumbing NodeDb Infrasstructure Data Publishing . . . warehouse1 warehouse2 warehouse3 warehouse4 Node Data Warehouses Published Interfaces, Filters & Transformations Node Node Web Site Node Applications
How NodeDb Codifies Observations Why? Project /Protocol/Researcher defined in How? Who? has many Sampling Units Where? has many Sampling Events When? has many Sampling Observations What recorded?
NodeDb Major Data Components Protocols defines methodology for Projects Sampling Units Sampling Events is located at contains participates in consisting of Researchers Sampling Event Observations collects uses Taxonomy
NodeDb: Projects Focus Projects
NodeDb: Researchers Focus Researchers
NodeDb: Sampling Units Focus Sampling Units
NodeDb: Sampling Unit Type Hierarchy Study Area A Bird Counts Banding/Tagging Nest Monitoring Other Bird Observation Point Nest Plot Trap Collection Point Count Transect Banding Net Collection A A A P Nest Subplot A Point Count Point Trap PA Net P Area Search Plot PL Nest Box Other Nest A P Other Banding Location P AP Burrow Index / Census Plot P Sea Watch Observation Point P Crevice P P Seabird Observation Blind Sample Collection Territory Seabird Diet Collection A P Shark Watch Observation Point P Specimens P P Nest Blood Collection At-sea Transect P P LA Egg Collection Legend P Predatory Fish Diet Collection Point Remote Sensing P Hydroacoustic Data L Biologging TDR Zooplankton Trawl PL L Satellite Water Sample PL P = point P GLS = optionally part of Weather Station L = required to be part of PL P = line A = area
NodeDb: Protocols Focus Protocols
NodeDb: Sampling Events Focus Sampling Events SamplingEventTypeCd
NodeDb: Sampling Observation Focus – Point Counts Sampling Events Sampling Event Observations
NodeDb: Taxonomy Focus Taxonomy
NodeDb: Data Dictionary Example DictionaryColumn ColumnId TableName CodeSetId 221 SamplingEventDataStatusCd 23 DictionaryCode CodeSetID CodeSetName 23 SamplingEventDataStatus DictionaryCodeValue