The data export is in comma separated variable (CSV) format. CSV format is platform-agnostic and is ideal for importing data
into spreadsheet applications such as Microsoft Excel for further data manipulation such as sorting, filtering, grouping,
and calculating totals, averages, etc. The beaches included in the data export are those which were returned by the user’s search.
The following sections detail the specific fields included in the export depending on the chosen Export Type:
Database Table and Field | Field Description |
BEACH.BEACH_ID | The unique identifier for the beach |
BEACH.WATERBODY_NAME | The waterbody name on which the beach resides |
BEACH.BEACH_NAME | The name of the beach |
BEACH.EPA_BEACH_ID | The EPA Beach ID, as assigned by the EPA beach program. Used for reporting notification data |
BEACH.STORET_NUMBER | The WQX Monitoring Location ID for the beach. |
BEACH.BEACH_DESCRIPTION | A description of the beach |
BEACH.WATERBODY_TYPE_TEXT | The text to display for the waterbody type |
BEACH.BEACH_ACCESS_TYPE_TEXT | The text to display for the accessibility of a beach, such as public or private |
BEACH.OWNERSHIP_TYPE_TEXT | The text to display for the waterbody ownership type, such as private, local, state or federal |
BEACH.IS_GREAT_LAKE_CONNECTED | Indicates whether the beach is connected to a great lake |
BEACH.LATITUDE_START | The latitude coordinate of the starting end of the beach |
BEACH.LONGITUDE_START | The longitude coordinate of the starting end of the beach |
BEACH.LATITUDE_CENTER | The latitude coordinate of the midpoint of the beach |
BEACH.LONGITUDE_CENTER | The longitude coordinate of the midpoint of the beach |
BEACH.LATITUDE_END | The latitude coordinate of the end of the beach |
BEACH.LONGITUDE_END | The longitude coordinate of the end of the beach |
BEACH.REACH_LENGTH_METERS | The length of shoreline that the beach spans in meters |
BEACH.HUC | The Hydrologic Unit Code in which the beach resides |
BEACH.TOWNSHIP_NAME | The township in which the beach resides |
BEACH.ZIP_CODE | The zip code in which the beach resides |
BEACH.COUNTY_NAME | The county in which the beach resides |
BEACH.GREAT_LAKE_TEXT | Indicates which great lake the beach is on, if applicable |
BEACH.PARK_NAME | The name of the park in which the beach resides, if applicable |
BEACH.PARK_URL | A URL where park information can be found. |
BEACH.FACILITY_DESCRIPTION | A description of the facilities available at the beach. |
BEACH.OTHER_DESCRIPTION | Other descriptive information about at the beach |
BEACH.TIER_RANK | The beach tier as required by EPA for notification data reporting |
Database Table and Field | Field Description |
BEACH.BEACH_ID | The unique identifier for the beach |
BEACH.WATERBODY_NAME | The waterbody name on which the beach resides |
MONITORING_LOCATION.MON_LOC_NUMBER | The user-assigned name for the monitoring location such as ‘South End’ or ‘1111’ |
MONITORING_LOCATION.MON_LOC_DESCRIPTION | A description of the monitoring location where a sample is taken |
MONITORING_LOCATION.LATITUDE | The latitude coordinate of the monitoring location |
MONITORING_LOCATION.LONGITUDE | The longitude coordinate of the monitoring location |
MONITORING_LOCATION.IS_ACTIVE | Indicates that the code is active and available to BeachGuard users
|
Database Table and Field | Field Description |
BEACH.BEACH_ID | The unique identifier for the beach |
MONITORING.MONITORING_ID | The unique identifier for the MONITORING table |
BEACH.WATERBODY_NAME | The waterbody name on which the beach resides |
BEACH.BEACH_NAME | The name of the beach |
BEACH.LATITUDE_CENTER | The latitude coordinate of the midpoint of the beach |
BEACH.LONGITUDE_CENTER | The longitude coordinate of the midpoint of the beach |
MONITORING.MONITORING_YEAR | The four-digit year for which the monitoring data applies |
MONITORING.SWIM_START_DATE | The start date of the swimming season |
MONITORING.SWIM_END_DATE | The end date of the swimming season |
MONITORING.MONITORING_METHOD_TEXT | The type of monitoring performed this year at the beach, such as ‘As Needed’ |
MONITORING.MONITORING_START_DATE | The start date of the monitoring season |
MONITORING.MONITORING_END_DATE | The end date of the monitoring season |
MONITORING.MONITORING_FREQUENCY_MEASURE | The numeric monitoring frequency measure |
MONITORING.MONITORING_FREQUENCY_UNITS | The unit of measure for the monitoring frequency, such as Days or Weeks |
Database Table and Field | Field Description |
BEACH.BEACH_ID | The unique identifier for the beach |
BEACH.WATERBODY_NAME | The waterbody name on which the beach resides |
BEACH.BEACH_NAME | The name of the beach |
BEACH.LATITUDE_CENTER | The latitude coordinate of the midpoint of the beach |
BEACH.LONGITUDE_CENTER | The longitude coordinate of the midpoint of the beach |
ADVISORY.START_DATE | The start date of the advisory |
ADVISORY.REOPEN_DATE | The end date of the advisory |
ADVISORY.ISSUED_BY | The name of the organization that issued the advisory |
ADVISORY.POLLUTION_SOURCE_TYPE_TEXT | The type of pollution source that caused the advisory, if known. |
ADVISORY.ADVISORY_REASON_TYPE_TEXT | The reason for the advisory |
ADVISORY.ADVISORY_COMMENT | A textual comment about the advisory. Displayed to public users |
Database Table and Field | Field Description |
BEACH.BEACH_ID | The unique identifier for the beach |
BEACH.WATERBODY_NAME | The waterbody name on which the beach resides |
BEACH.BEACH_NAME | The name of the beach |
MONITORING_LOCATION.MON_LOC_NUMBER | The user-assigned name for the monitoring location such as ‘South End’ or ‘1111’ |
MONITORING_LOCATION.MON_LOC_DESCRIPTION | A description of the monitoring location where a sample is taken |
MONITORING_LOCATION.LATITUDE | The latitude coordinate of the monitoring location |
MONITORING_LOCATION.LONGITUDE | The longitude coordinate of the monitoring location |
RESULT.RESULT_ID | The unique identifier for the RESULT table |
RESULT.RESULT_VALUE_QUAL_TYPE_CD | The result qualifier. TNTC = “Too numerous to count”. |
RESULT.RESULT_VALUE | The result value |
RESULT.SAMPLE_DATE | The date/time when the sample was taken |
RESULT.INDICATOR_SPECIES_TYPE_CD | The indicator species for the sample result |
RESULT.ANALYSIS_METHOD_TYPE_TEXT | The laboratory analysis method type used to proces the sample |
RESULT.STATISTICAL_BASE_TEXT | The statistical base code, such as individual sample or 30-day geometric mean |