| Overview of report sheets for: | ||
| Note that all SDWIS data are generated from Quarter 4 results for the discrepancy report year. | ||
| SDWIS Federal Reports Advanced Search (epa.gov) | ||
| Sheet Name | Category | Description |
| Active Systems | Active/Inactive | Comparison of Active systems in the SDWIS And WFRS databases |
| CWS Population | Population | Comparing populations for each systems between SDWIS and WFRS databases |
| CWS County | County | Comparing Counties Served by CWS in SDWIS and WFRS |
| County Population | County | Checking the total CWS Population for each County versus the US Census population for that County |
| Fluoridation Status | Fluoridation Status | Summary overview of the different Fluoridation Statuses |
| Natural 1 | Fluoridation Status | List of all Natural CWS sorted by the last time the Natural Fluoride Concentration was updated in WFRS |
| Natural 2 | Fluoridation Status | List of Natural CWS that have a Natural Fluoride Concentration that is too high or too low for that Fluoridation Status designation |
| Adjusting 1 | Fluoridation Status | Comparion of Adjusting systems in SDWIS And WFRS |
| Adjusting 2 | Fluoridation Status | List of all Adjusting systems in WFRS sorted by the last time Operational Data was entered for the system |
| Adjusting 3 | Fluoridation Status | List of all Adjusting systems number of months that have entered Operational data for the year of the DR (so 2020 for this time), sorted ascending |
| MultiSource and Variable | Fluoridation Status | List of all Multisource and Variable systems in WFRS for this state |
| Contact Info | Contact Info | Contact information fore each CWS as it appears in WFRS and SDWIS |
| My Waters Fluoride | Contact Info | State information about My Waters Fluoride, including if they have opted in, and if so the point of contact |
| System Comparison between WFRS and SDWIS databases for: | |||
| Comparison of active/inactive CWS in the SDWIS vs. WFRS databases. | |||
| PWS ID | PWS Name | WFRS Status | SDWIS Status |
| Population differences between WFRS and SDWIS databases for: | |||
| This sheet shows systems that have different state reported populations in WFRS and SDWIS. | |||
| PWS ID | PWS Name | WFRS Population | SDWIS Population |
| County differences between WFRS and SDWIS databases for: | |||
| This sheet compares that primary county listed in WFRS vs. SDWIS | |||
| PWS ID | PWS Name | WFRS Counties | SDWIS Counties |
| Preview of the county statistics for: | |||
| This tab is a comparison of the total CWS county populations (controlled) vs. the reported US census county population for the state. *Note that populations are often overattributed to one county for water systems that have more that serve primary and secondary counties. Therefore, percentages may exceed 100%. In these cases, please review populations counts for water systems with multiple counties for accuracy. |
|||
| County_Name | CWS county population | US Census county population | WFRS/Census % |
| Fluoridation status summary table: | |||||
| This table is a snapshot of the fluoridation status summary table as of the end of the discrepancy report year. Please review for accuracy. | |||||
| Fluoridation Status | Numbers of systems | Population Served | Fluoridated population | Non Fluoridated population | Fluoridated Percentage |
| Adjusted | |||||
| Consecutive | |||||
| Defluoridated | |||||
| Multi-Source | |||||
| Natural | |||||
| Non-Adjusted | |||||
| Variable | |||||
| Totals |
| List of all the natural fluoride levels listed in WFRS and the year that each of them were most recently updated for: | |||
| This list includes all CWS that have a fluoridated status of natural. List includes the natural level and last date it was updated in WFRS. | |||
| PWS ID | PWS Name | Nature Level | Last updated |
| Systems with Natural Fluoridation Level outside of range 0.6 - 2.0 for: | ||
| This list includes CWS that have a fluoridated status of natural, but have fluoride concentrations listed in WFRS either below 0.6 mg/L or above 2.0 mg/L. For systems below 0.6 mg/L (depending on state operational targets), water systems should be listed as non-adjusting. For those above 2.0 mg/L, this list serves as a check for the states to confirm these are still correct as these values are above EPA's SMCL of 2.0 mg/L. |
||
| PWS ID | PWS Name | Natural Fluoride Level |
| Adjusting system differences between WFRS and SDWIS databases for: | |||
| SDWIS lists whether a water system has "fluoridation" listed as a treatment process. This list compares systems that are shown in WFRS as adjusting vs. those systems that have a fluoridation process listed in SDWIS. This table should only be used as a check for WFRS status as SDWIS data may not be 100% accurate. |
|||
| PWS ID | PWS Name | Adjusting in WFRS | Adjusting in SDWIS |
| All adjusting systems and the date that operational information was last entered for: | |||
| This reports lists all adjusting systems in WFRS sorted by the last time operational data (fluoride data) was entered into WFRS. | |||
| PWS ID | PWS NAME | Point Name | Last time receiving operational data |
| Quick glance of their reporting for previous year for : | |||
| This report lists all adjusting systems and the number of months that have entered operational data for the year of the discrepancy report, sorted ascending. | |||
| PWS ID | PWS Name | Point_Name | Number of months of data for previous year |
| All systems that have variable or multisource for: | |||||
| Systems with a % Population Fluoridated field <50% are considered Not Fluoridated | |||||
| PWS ID | PWS Name | FluoridationStatus | Population | Fuoridated | % Pop Fluoridated in WFRS |
| Missing (or inconsistent) contact Info in WFRS for : | ||||||
| These are the systems for which WFRS and SDWIS have different contact information. If SDWIS contact information is up to date and accurate, please contact CDC Division of Oral Health ([email protected]) for a batch upload into WFRS. | ||||||
| PWS_ID | SDWIS PWS_Name | WFRS PWS_Name | SDWIS Contact | WFRS Contact | SDWIS Address | WFRS Address |
| Public access to state data for: | |
| This sheet shows if the state is participating in My Waters Fluoride (MWF). If they are, the contact information shown in MWF is given. Please check that the contact information is correct. | |
| Info | Answer |
| Participates in Oral Health Maps & My Waters Fluoride: | |
| Listed Public Access Information: |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |