1 / 4

SITES (SI_ID)

Notes. EXIT. Structure of the AQS Database for “Core” Data. SITES (SI_ID). SI_SI_ID. SI_SI_ID. SI_SI_ID. OPEN_PATHS (OP_ID). TANGENT_ROADS (TR_ID). AGENCY_ROLES. MO_MO_ID. MONITOR_TANGENT_ ROADS. MO_MO_ID. OP_OP_ID. SI_SI_ID. MONITORS (MO_ID). MO_MO_ID. REGULATION_ COMPLIANCES.

rodney
Download Presentation

SITES (SI_ID)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Notes EXIT Structure of the AQS Database for “Core” Data SITES (SI_ID) SI_SI_ID SI_SI_ID SI_SI_ID OPEN_PATHS (OP_ID) TANGENT_ROADS (TR_ID) AGENCY_ROLES MO_MO_ID MONITOR_TANGENT_ ROADS MO_MO_ID OP_OP_ID SI_SI_ID MONITORS (MO_ID) MO_MO_ID REGULATION_ COMPLIANCES MO_MO_ID SAMPLE_PERIODS MO_MO_ID MO_MO_ID MONITOR_TYPE_ ASSIGNMENTS PROBE_OBSTRUCTIONS MO_MO_ID MO_MO_ID MONITOR_OBJECTIVES COLLOCATION_PERIODS REQ_COLL_ FREQUENCIES (RCF_ID) MO_MO_ID MONITOR_PROTOCOLS(MO_MO_ID & MP_ID) RCF_RCF_ID SAMPLE_SCHEDULES MP_MO_MO_ID & MP_MP_ID MO_MO_ID ANNUAL_SUMMARIES (ANS_ID) ACCURACY_DATA (AC_ID) MP_MO_MO_ID & MP_MP_ID ANS_ANS_ID SUMMARY_MAXIMUMS AC_AC_ID PRECISION_DATA (PD_ID) ACCURACY_AUDITS (ACA_ID) ANS_ANS_ID SUMMARY_PERCENTILES SUMMARY_ PROTOCOLS ANS_ANS_ID MP_MO_MO_ID & MP_MP_ID ACA_ACA_ID MP_MO_MO_ID & MP_MP_ID PD_PD_ID MO_MO_ID QA_DETAILS QUARTERLY_SUMMARIES • CURRENT_DATA (RD_ID) • Hourly • Daily • Composite • Blanks Data MO_MO_ID DAILY_SUMMARIES RD_RD_ID QUALIFIER_DETAILS MO_MO_ID NAAQS_AVERAGES

  2. Structure of the AQS Database for “Site” Data HOME TIME_ZONES STATE_TIME_ ZONES CONGRESSIONAL_DISTRICTS STATE_ URBANIZED_ AREAS LOCAL_REGIONS STATES COUNTIES CITIES URBANIZED_ AREAS CENSUS_ TRACTS COUNTY_CITIES MSAS AQCR_ COUNTIES COUNTY_ ZIP_CODES CMSAS AQCRS LOCATION_SETTINGS ZIP_CODES MET_SITE_TYPES TRIBAL_AREAS CLASS_ONE_AREAS BLOCK_ GROUPS BLOCKS SITES LAND_USE_TYPES LDP_COLLECTION_METHODS COMPASS_ SECTORS LDP_HORIZONTAL_DATA TANGENT_ROADS OPEN_PATHS LDP_VERTICAL_DATA LDP_VERTICAL_METHODS MONITOR_TANGENT_ROADS AGENCY_ROLES STATE_AGENCIES AGENCIES MONITORS RETURN

  3. Structure of the AQS Database for “Protocol” Data SAMPLING_ METHODOLOGIES PARAMETERS HOME SAMPLE_DURATIONS PARAMETER_ CLASSIFICATIONS COMPOSITE_TYPES COLLECTION_ FREQUENCIES CLASSIFICATIONS UNITS MONITORS PROTOCOLS ANNUAL_ SUMMARIES MONITOR_PROTOCOLS SUMMARY_ PROTOCOLS CURRENT_DATA PRECISION_DATA ACCURACY_DATA

  4. Notes about the Diagram HOME • The Head of the Arrow Points to the “Child” Table. • The Label on the Arrow Indicates the Name of the Column that Establishes the Foreign Key to the “Parent” Table. • Column Names for Foreign Keys are Formed by Taking the Table Short Name from the Parent Table and Adding the Joining Column Name from the Parent Table • Example: The MONITORS table uses the SI_SI_ID column to Join to the SITES table • “SI” is the Table Short Name for the SITES table • “SI_ID” is the name of the column on the SITES table used to Perform the Join • The Microscope Icon is used to Show Additional Links to Reference Tables. • Not All Tables Available in AQS are Displayed in this Diagram. Only Those Considered Widely Used are Displayed.

More Related