Database of Implemented Stormwater Controls (DISC)


Authors:
Owners:
Resource type: Composite Resource
Storage: The size of this resource is 1.4 GB
Created: Feb 01, 2021 at 9:36 p.m.
Last updated: Jul 07, 2021 at 9:40 p.m.
Citation: See how to cite this resource
Sharing Status: Public
Views: 281
Downloads: 42
+1 Votes: Be the first one to 
 this.
Comments: No comments (yet)

Abstract

The data available here in the Database of Implemented Stormwater Controls (DISC) is a product of two manuscripts. 1. Synthesizing Stormwater Infrastructure in United States Cities: Are we speaking the same language? and 2. A cross-city comparison to understand selection of stormwater controls in United States cities. Not all cities included in the analyses presented in those papers allowed data to be shared, so spatial data of stormwater control measures (SCMs) is available via this resource for 17 of the 23 cities. Another city allowed spatial data to be shared directly with other researchers but not publicly, and two additional cities allowed for lists of their SCMs to be shared publicly, but not their spatial data.

The data as we received it from various sources is available and may include data other than SCM data (e.g., pipe network data). There is also a geodatabase available that contains SCMs clipped to city boundaries. This is the data we used in the manuscripts mentioned above. We did not standardize the datasets to contain the same data nor format of data.

We hope that this database of implemented stormwater controls (DISC) will be expanded upon by contributions from other individuals.

This material is based upon work supported by the National Science Foundation under Grant No. 1828902.
Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Subject Keywords

Deleting all keywords will set the resource sharing status to private.

Resource Level Coverage

Temporal

Start Date:
End Date:

Content

ReadMe.txt

**Note: We do not claim nor expect that the data presented here is a complete representation of the stormwater controls in the represented cities.

The data available here in the Database of Implemented Stormwater Controls (DISC) is a product of two manuscripts. 
1. Synthesizing Stormwater Infrastructure in United States Cities: Are we speaking the same language? and 
2. A cross-city comparison to understand selection of stormwater controls in United States cities. 
Not all cities included in the analyses presented in those papers allowed data to be shared, 
so spatial data of stormwater control measures (SCMs) is available via this resource for 17 of the 23 cities. 
Another city allowed spatial data to be shared directly with other researchers but not publicly, and two additional 
cities allowed for lists of their SCMs to be shared publicly, but not their spatial data.

The data as we received it from various sources is available and may include data other than SCM data (e.g., pipe network data). 
There is also a geodatabase available that contains SCMs clipped to city boundaries. This is the data we used in the manuscripts mentioned above.  
We did not standardize the datasets to contain the same data nor format of data. 

We hope that this database of implemented stormwater controls (DISC) will be expanded upon by contributions from other individuals. 

Beyond spatial datasets we have provided a Microsoft Excel '.xlsx' file that contains lists of SCMs, how we re-categorized those SCMs 
in the two manuscripts mentioned above, and what data is available for the different cities. We hope that seeing the inconsistencies 
in data will encourage better and more standardized record keeping of SCM inventories and data.

We also provide a ".csv" file that includes all explanatory variables used in the manuscripts mentioned above and ".csv" 
files with SCM counts for each of the SCM grouping conventions used in the mentioned manuscripts.  

Cities with SCM spatial data available via HydroShare include:
Austin, TX; Baltimore, MD; Bozeman, MT; Cary, NC; Denver, CO; Fayetteveille, AR; Grand Rapids, MI; Los Angeles, CA; New York City, 
NY; Philadelphia, PA; Pittsburgh, PA; Sacramento, CA; San Francisco, CA; Seattle, WA; Springfield, MO; Tucson, AZ; and Washington, D.C.

Cities for which spatial data can be attained by emailing Ben Choat (bchoat@colostate.edu or bchoat@rams.colostate.edu) include:
Portland, OR

Cities for which only lists of SCMs are available include:
Fort Collins, CO; Phoenix, AZ, and Pocatello, ID

Cities that do not allow any sharing of data include:
Lincoln, NE; and Phoenix, AZ

File descriptions:
In folder 'CSVs':
SCMComparison_ExplanatoryVars.csv: explanatory variables used in analyses from papers mentioned above.
SCMComparison_MOPall.multsep.csv: SCM counts for each city with SCM types based on "all" unit processes (see table of unit processes WEF and ASCE (2012))
SCMComparison_MOPbio.multsep.csv: SCM counts for each city with SCM types based on "biological" unit processes (see table 4.2 of unit processes WEF and ASCE (2012))
SCMComparison_MOPother.multsep.csv: SCM counts for each city with SCM types based on "other" unit processes (see table 4.2 of unit processes WEF and ASCE (2012))
SCMComparison_MOPpollutant.multsep.csv: SCM counts for each city with SCM types based on "pollutant" unit processes (see table 4.2 of unit processes WEF and ASCE (2012))
SCMComparison_MOPquant.multsep.csv: SCM counts for each city with SCM types based on "quantity" unit processes (see table 4.2 of unit processes WEF and ASCE (2012))
SCMComparison_MOPHR.multsep.csv: SCM counts for each city with SCM types based on fine resolution SCM names (see table 4.2 of unit processes WEF and ASCE (2012))
SCMComparison_MOPLR.mulstsep.csv: SCM counts for each city with SCM types based on coarse resolution SCM names (see table 4.2 of unit processes WEF and ASCE (2012))
SCM_Classifications_MOP.csv: Processes provided by different SCM types based on ASCE and WEF (2012) Table 4.2. 
			    This.csv was used for K-Means clustering. 
			    We recomend using the functions listed in this .CSV file as a basis when recording an inventory of SCMs and the functions they provide.

In folder 'ExcelFiles':
SCMComparison_CitySCMs_Hydroshare.xlsx: Microsoft Excel file holding lists of SCMs in each city and how they were reclassified, and other data that was available. 
Also contains lists of different SCM groups based on different unit processes.
SCMComparison_ListsForReclassification.xlsx: Just a table containing the SCM terms reported by all cities and how we reclassified them based on WEF and ASCE (2012)

Folder 'R_SCMs':
Contains relevant R code used for processing data for the analysis prensented in the two mentioned manuscripts.
There is a ReadMe.txt file in the folder describing for what each file.R was used.

SCMs_Raw_Shareable: Folder containing SCM spatial data as we received it.

SCMsClippedShare.gdb: A geodatabase of the SCM data clipped to city boundaries.

Press, W. E. F. "Design of urban stormwater controls." ASCE, 2012.

Credits

Funding Agencies

This resource was created using funding from the following sources:
Agency Name Award Title Award Number
National Science Foundation InTERFEWS 1828902

How to Cite

Choat, B., A. Pulido, A. S. Bhaskar, R. Hale, H. Zhang, T. Meixner, L. McPhillips, K. Hopkins, J. Cherrier, C. Cheng (2021). Database of Implemented Stormwater Controls (DISC), HydroShare, http://www.hydroshare.org/resource/9b2572b9ee58484483d539051adc019a

This resource is shared under the Creative Commons Attribution CC BY.

 http://creativecommons.org/licenses/by/4.0/
CC-BY

Comments

There are currently no comments

New Comment

required