Get Monitoring Location Identifier and Assessment Unit Identifier Crosswalk from ATTAINS

Tribes and States who participate in electronic reporting of water quality conditions through EPA ATTAINS may optionally submit a crosswalk of WQP monitoring location identifiers associated with their assessment units to ATTAINS. If an organization has recorded this information in ATTAINS, this function can be used to get the ATTAINS user submitted crosswalk of known monitoring location identifiers and assessment units. As of 2025, all tribal nations record this information in ATTAINS but only a few states.

Usage

TADA_GetATTAINSAUMLCrosswalk(org_id = NULL, batch_upload = FALSE)

Arguments

org_id: The ATTAINS organization identifier must be supplied by the user. A list of organization identifiers can be found by downloading the ATTAINS Domains Excel file: https://www.epa.gov/system/files/other-files/2025-02/domains_2025-02-25.xlsx. Organization identifiers are listed in the "OrgName" tab. The "code" column contains the organization identifiers that should be used for this param.
batch_upload: Boolean argument. When batch_upload = TRUE, the final column names in the output will match those required for batch upload to ATTAINS. When batch_upload = FALSE, the output column names will be consistent with the TADA workflow. Default is batch_upload = FALSE.

Value

When batch_upload = FALSE, A dataframe with six columns: OrganizationIdentifier, ATTAINS.OrganizationIdentifier, ATTAINS.MonitoringLocationIdentifier, ATTAINS.AssessmentUnitIdentifier, ATTAINS.MonitoringDataLinkText, ATTAINS.WaterType is returned. When batch_upload = TRUE, A dataframe with four columns: MS_ORG_ID, MS_LOCATION_ID, ASSESSMENT_UNIT_ID, MS_DATA_LINK is returned. This is the crosswalk between monitoring location identifiers and assessment units that the state or tribal organization submitted to ATTAINS (optional). If an ATTAINS organization has not submitted this information in ATTAINS, the function will not return a dataframe.

Examples

if (FALSE) { # \dontrun{
# Alaska example in
AK_crosswalk <- TADA_GetATTAINSAUMLCrosswalk(
  org_id = "AKDECWQ", batch_upload = TRUE)

# Alaska example with ATTAINS prefix compatible with TADA Analysis workflow
AK_crosswalk2 <- TADA_GetATTAINSAUMLCrosswalk(
  org_id = "AKDECWQ", batch_upload = FALSE)

# Pueblo of Tesuque example
PUEBLOOFTESUQUE_crosswalk <- TADA_GetATTAINSAUMLCrosswalk(
  org_id = "PUEBLOOFTESUQUE"
)

# Arizona example, returns blank dataframe as of 1/21/25
AZ_crosswalk <- TADA_GetATTAINSAUMLCrosswalk(org_id = "21ARIZ")
} # }