20200224 09485900 1.0 ISO 19139 Metadata Implementation Specification FALSE PFAS_LATEST_SAMPLE_TBL_2019_2021 002 20241030 13301800 20241030 13301800 150000000 5000 ISO19139 Esri ArcGIS 13.2.0.49743 PFAS_LATEST_SAMPLE_TBL_2019_2021 Table is based on an selection on the latest sampling event for each water treatment plant. The results of the most recent sampling event for each parameter are selected from the PFAS_RESULTS_TBL. The view PFAS_LATEST_SAMPLE_VW selects the most recent sampling event for each water treatment unit. This table is used in public map visualizations of the results to show most recent sampling and is related to water treatment plant feature class PFAS_WTP_SAMP_FC <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Table is based on an selection on the latest sampling event for each water treatment plant. The results of the most recent sampling event for each parameter are selected from the PFAS_RESULTS_TBL. The view PFAS_LATEST_SAMPLE_VW selects the most recent sampling event for each water treatment unit. </SPAN></P><P><SPAN>The table is updated by script weekday evenings or manually after a results have been entered in Safe Drinking Water Information System tables. </SPAN></P></DIV></DIV></DIV> Division of Drinking and Ground Waters, Ohio EPA PFAS Drinking Water File Geodatabase Table dataset PFAS_LATEST_SAMPLE_TBL_2019_2021 Table 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. DISTRICT DISTRICT String 40 0 0 COUNTY COUNTY String 40 0 0 PWSID PWSID String 12 0 0 SYSNAME SYSNAME String 40 0 0 SYS_STATUS SYS_STATUS String 1 0 0 FAC_ID FAC_ID String 12 0 0 WTP_ID WTP_ID Integer 4 0 0 WTPNAME WTPNAME String 40 0 0 SAMP_PT_ID SAMP_PT_ID String 12 0 0 SAMP_TYPE SAMP_TYPE String 2 0 0 COMPL_SAMP COMPL_SAMP String 1 0 0 SAMP_LAB_ID SAMP_LAB_ID String 20 0 0 SAMP_DATE SAMP_DATE String 10 0 0 SAMP_TS SAMP_TS Date 8 0 0 ANALYTE_CD ANALYTE_CD String 4 0 0 ANALYTE ANALYTE String 40 0 0 RESULTNUM RESULTNUM Double 8 0 0 LESSTHANDETECT LESSTHANDETECT String 1 0 0 SAMPLE_RESULT SAMPLE_RESULT String 43 0 0 UNIT UNIT String 9 0 0 RESULT_PPT RESULT_PPT Double 8 0 0 ACTIONLEVEL ACTIONLEVEL String 11 0 0 PRCNTACTLVL PRCNTACTLVL Double 8 0 0 LATITUDE LATITUDE Double 8 0 0 LONGITUDE LONGITUDE Double 8 0 0 20241030