Community Water Supplies Entities Search
All community water supplies appear in the Community Water, Supplies section under Program Areas.
There are a number of different search fields available to further refine the water supplies list in CWS Entities Search and CWS Entities Advanced Search. CWS data is sourced from SDWIS and select fields are searchable within MiEHDWIS.
There is a SDWIS Noncommunity and Community Water Supply Sync Process under System, Operations, Processes. This process refreshes Noncommunity and Community Water Supply inventory data from SDWIS. Runs once every night (7pm). This process may also be run on-demand manually, so the searches proceed with current data.
CWS Entities Search
Navigate to CWS entity search by clicking Community Water, then Supplies from underneath the Program Areas section of the left navigation menu.
The CWS entity search screen by default shows Active and Proposed Status water supplies.
There is a Text Filter and three, multi-select supported, Quick Filters, which are:
Status - Active, Inactive, and Proposed are Status options, inferred from the entity information in SDWIS.
Subdistrict - All CWS subdistricts as listed in the Local Name field in SDWIS are selectable.
County - Select one or more Michigan county from the list.
Filters can be removed by clicking the X in the filter chips displayed at the top of the results list.
The list can be exported by clicking the Download cloud icon.
The supply list can also be turned into a Saved Search by clicking the three dot menu and then Saved Search.
CWS Advanced Search can be accessed by clicking the magnifying glass icon.
CWS Entities Advanced Search
Upon clicking the magnifying glass icon from the CWS entities search screen, you will be taken to a search screen with a single Search Field for Status defaulted with Is Active and Proposed selected. The Status row can be edited or removed, if desired, by clicking the minus symbol on the row or the x on the individual status pills in the Select a Status field.
To add additional search criteria, click the Add Search Field button, which will create another row for you to select an additional option. Continue adding rows until all desired search fields have been added.
CWS Entities Advanced Search Criteria ScreenClick Search to look for entities that match your selected criteria.
You will be directed to the CWS entities search screen again with updated results listed.
You can refine your search or perform another search by clicking the magnifying glass icon again.
If you want to quickly clear your selected criteria and start a new search, click the Reset button.
CWS Entities Advanced Search Fields
Some fields are free text or numeric fields while other fields are controlled by Lookups which present you with a pick list of known options. CWS entity data is sourced from SDWIS.
Search Field | Operators | Options | Additional Information |
|---|---|---|---|
Name | Is, Is Not, Contains, Begins With, Ends With | Text field |
|
Public Water Supply ID | Is, Is Not, Contains, Begins With, Ends With | Text field |
|
Principal County Served | Is, Is Not, Is Empty, Is Not Empty | List of Michigan Counties and their codes. | Search filter options populated by the County Lookup. |
Status | Is, Is Not | Active, Inactive, Proposed |
|
Subdistrict | Is, Is Not, Is Empty, Is Not Empty | List matches options from Local Name field in SDWIS. | Search filter options populated by the Subdistrict Lookup. |
Operating Category | Is, Is Not, Contains, Begins With, Ends With, Is Empty, Is Not Empty | Text field, formatting varies, depends how entered in SDWIS. Class(es) and class level(s) are listed in this field. | S, D, and F are the classes that represent no treatment, limited treatment, and complete treatment, respectively. You can include the specific class level, if known, like “F1”. |
Total Population Served | Is, Is Not, Is Greater Than, Is Less Than, Is in the Range, Is Empty, Is Not Empty | Numeric text field |
|
State Type | Is, Is Not, Is Empty, Is Not Empty | Community, Non Public, Non-Community Transient, Non-Transient, Non-Community | Search filter options populated by the SDWIS State Type Lookup. |
Primary Source | Is, Is Not, Is Empty, Is Not Empty | GU, GUP, GW, GWP, SW, SWP | Search filter options populated by the SDWIS Primary Source Type Lookup. |
Owner Type | Is, Is Not, Is Empty, Is Not Empty | Local, Native American, Private, State Gov | Search filter options populated by the SDWIS Owner Type Lookup. |
Treatment Type | Is, Is Not, Is Empty, Is Not Empty | Multi-select list of 70 different treatment types. | Search filter options populated by the SDWIS Treatment Types Lookup. |