The overall objective of this proposed study was to provide a set of web-based tools that will enable producers and other users to characterize, treat, beneficially use, and manage produced water and frac flowback water from unconventional gas production. The goal is to sustain gas production while minimizing potential impacts on natural water resources, public health, and environment. Built upon the integrated decision making framework developed for CBM produced water management, the proposed study focuses on shale gas and tight sand production, the most difficult and least developed. The proposed research was designed for 36 months and organized into four phases. The overall objective of the proposal was to develop GIS-based tools that can be used to optimize water management decisions during unconventional oil and gas development and production to minimize the environmental impact. The environmental impacts that will be directly assessed with the tool include the handling, treatment and disposal of produced water, air toxics and greenhouse gases associated with fluids handling, water footprint, and the optimal siting of wells and treatment facilities with respect to community impacts.