Beach Data Export Help

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:

Beach Details Export

Exports attributes about the beach
Database Table and FieldField Description
BEACH.BEACH_IDThe unique identifier for the beach
BEACH.WATERBODY_NAMEThe waterbody name on which the beach resides
BEACH.BEACH_NAMEThe name of the beach
BEACH.EPA_BEACH_IDThe EPA Beach ID, as assigned by the EPA beach program. Used for reporting notification data
BEACH.STORET_NUMBERThe WQX Monitoring Location ID for the beach.
BEACH.BEACH_DESCRIPTIONA description of the beach
BEACH.WATERBODY_TYPE_TEXTThe text to display for the waterbody type
BEACH.BEACH_ACCESS_TYPE_TEXTThe text to display for the accessibility of a beach, such as public or private
BEACH.OWNERSHIP_TYPE_TEXTThe text to display for the waterbody ownership type, such as private, local, state or federal
BEACH.IS_GREAT_LAKE_CONNECTEDIndicates whether the beach is connected to a great lake
BEACH.LATITUDE_STARTThe latitude coordinate of the starting end of the beach
BEACH.LONGITUDE_STARTThe longitude coordinate of the starting end of the beach
BEACH.LATITUDE_CENTERThe latitude coordinate of the midpoint of the beach
BEACH.LONGITUDE_CENTERThe longitude coordinate of the midpoint of the beach
BEACH.LATITUDE_ENDThe latitude coordinate of the end of the beach
BEACH.LONGITUDE_ENDThe longitude coordinate of the end of the beach
BEACH.REACH_LENGTH_METERSThe length of shoreline that the beach spans in meters
BEACH.HUCThe Hydrologic Unit Code in which the beach resides
BEACH.TOWNSHIP_NAMEThe township in which the beach resides
BEACH.ZIP_CODEThe zip code in which the beach resides
BEACH.COUNTY_NAMEThe county in which the beach resides
BEACH.GREAT_LAKE_TEXTIndicates which great lake the beach is on, if applicable
BEACH.PARK_NAMEThe name of the park in which the beach resides, if applicable
BEACH.PARK_URLA URL where park information can be found.
BEACH.FACILITY_DESCRIPTIONA description of the facilities available at the beach.
BEACH.OTHER_DESCRIPTIONOther descriptive information about at the beach
BEACH.TIER_RANKThe beach tier as required by EPA for notification data reporting

Monitoring Points Export

Exports a list of monitoring points and their coordinates for each beach
Database Table and FieldField Description
BEACH.BEACH_IDThe unique identifier for the beach
BEACH.WATERBODY_NAMEThe waterbody name on which the beach resides
MONITORING_LOCATION.MON_LOC_NUMBERThe user-assigned name for the monitoring location such as ‘South End’ or ‘1111’
MONITORING_LOCATION.MON_LOC_DESCRIPTIONA description of the monitoring location where a sample is taken
MONITORING_LOCATION.LATITUDEThe latitude coordinate of the monitoring location
MONITORING_LOCATION.LONGITUDEThe longitude coordinate of the monitoring location
MONITORING_LOCATION.IS_ACTIVEIndicates that the code is active and available to BeachGuard users

Monitoring Plans Export

Exports a list of the frequency and annual date range in which monitoring is performed, along with the name of the agency that performed the monitoring.
Database Table and FieldField Description
BEACH.BEACH_IDThe unique identifier for the beach
MONITORING.MONITORING_IDThe unique identifier for the MONITORING table
BEACH.WATERBODY_NAMEThe waterbody name on which the beach resides
BEACH.BEACH_NAMEThe name of the beach
BEACH.LATITUDE_CENTERThe latitude coordinate of the midpoint of the beach
BEACH.LONGITUDE_CENTERThe longitude coordinate of the midpoint of the beach
MONITORING.MONITORING_YEARThe four-digit year for which the monitoring data applies
MONITORING.SWIM_START_DATEThe start date of the swimming season
MONITORING.SWIM_END_DATEThe end date of the swimming season
MONITORING.MONITORING_METHOD_TEXTThe type of monitoring performed this year at the beach, such as ‘As Needed’
MONITORING.MONITORING_START_DATEThe start date of the monitoring season
MONITORING.MONITORING_END_DATEThe end date of the monitoring season
MONITORING.MONITORING_FREQUENCY_MEASUREThe numeric monitoring frequency measure
MONITORING.MONITORING_FREQUENCY_UNITSThe unit of measure for the monitoring frequency, such as Days or Weeks

Advisories/Closures Export

Exports advisories and closures for the beach
Database Table and FieldField Description
BEACH.BEACH_IDThe unique identifier for the beach
BEACH.WATERBODY_NAMEThe waterbody name on which the beach resides
BEACH.BEACH_NAMEThe name of the beach
BEACH.LATITUDE_CENTERThe latitude coordinate of the midpoint of the beach
BEACH.LONGITUDE_CENTERThe longitude coordinate of the midpoint of the beach
ADVISORY.START_DATEThe start date of the advisory
ADVISORY.REOPEN_DATEThe end date of the advisory
ADVISORY.ISSUED_BYThe name of the organization that issued the advisory
ADVISORY.POLLUTION_SOURCE_TYPE_TEXTThe type of pollution source that caused the advisory, if known.
ADVISORY.ADVISORY_REASON_TYPE_TEXTThe reason for the advisory
ADVISORY.ADVISORY_COMMENTA textual comment about the advisory. Displayed to public users

Sampling Results Export

Exports sampling results for the beach
Database Table and FieldField Description
BEACH.BEACH_IDThe unique identifier for the beach
BEACH.WATERBODY_NAMEThe waterbody name on which the beach resides
BEACH.BEACH_NAMEThe name of the beach
MONITORING_LOCATION.MON_LOC_NUMBERThe user-assigned name for the monitoring location such as ‘South End’ or ‘1111’
MONITORING_LOCATION.MON_LOC_DESCRIPTIONA description of the monitoring location where a sample is taken
MONITORING_LOCATION.LATITUDEThe latitude coordinate of the monitoring location
MONITORING_LOCATION.LONGITUDEThe longitude coordinate of the monitoring location
RESULT.RESULT_IDThe unique identifier for the RESULT table
RESULT.RESULT_VALUE_QUAL_TYPE_CDThe result qualifier. TNTC = “Too numerous to count”.
RESULT.RESULT_VALUEThe result value
RESULT.SAMPLE_DATEThe date/time when the sample was taken
RESULT.INDICATOR_SPECIES_TYPE_CDThe indicator species for the sample result
RESULT.ANALYSIS_METHOD_TYPE_TEXTThe laboratory analysis method type used to proces the sample
RESULT.STATISTICAL_BASE_TEXTThe statistical base code, such as individual sample or 30-day geometric mean