Laserfiche WebLink
November 10, 2017 <br />Page 2 <br />• Maximum Day Volume <br />• Maximum Day Date <br />• Reported Water Use (total volume) <br />• Total Gallons Delivered <br />• Residential Gallons Delivered <br />• Residential Connections: <br />o Residential Metered Connections <br />o Resource Type (groundwater, lake, stream/river) <br />o Use Type (municipal/public water supply, private water supply, <br />commercial/institutional water supply) <br />2. MPARS_Monthly_20170607.xlsx - This file contains 130,690 records in which each record <br />represents an annual report for a water withdrawal point. The data fields include: <br />• Permit Number <br />• Year <br />• January Gallons through December Gallons <br />• Installation Total (annual total in million gallons) <br />• Major Use Category (industrial, irrigation power generation, water supply) <br />• Resource Type (groundwater, lake, stream/river) <br />• County <br />• Latitude & Longitude of withdrawal point <br />3. Thrive-MSP-2040-Forecasts-(January-2017).xlsx - This file contains population, housing and <br />employment projections for municipalities and counties within the Metropolitan Region. The <br />data are for the years 2010, 2020, 2030 and 2040. <br />4. MDH Well database - This database consists of multiple Excel files downloaded from the <br />MDH database. The two files, and the related data, used for this analysis are: <br />• PWS.xls - contains Name of Community and PWS ID number <br />• FACILITY.xls - contains the PWS ID number, Facility Code (WL for well), Availability Code <br />(PRIM for primary, EMER for emergency) for each well. <br />