_id field description example_1 example_2 Additional Comments 1 project_name Project name 3 Rivers Wet Weather Rain Garden ALCOSAN Customer Services and Training Building Bioswale 2 project_type Select from dropdown list Rain Garden / Bioretention Bioswale 3 project_size Text; can include volume capacity and/or area of project for overview. Other fields later cover these items, specifically 1800 sq. ft. 120 sq.ft., 1,300 gal 4 date_built Month and year that construction was completed May-16 Aug-14 5 sewershed Sewershed in which the green infrastructure feature was built Nine Mile Run Two Mile Run 6 municipality Municipality in which the green infrastructure feature was built Baldwin Boro City of Pittsburgh 7 bmp_status Choose from: planned, under construction, or active. Planned Active 8 street_address Street address closest to location of green infrastructure feature. In some cases, the street name without a number is used 7400 block, Frankstown Road 3901 Penn Ave. 9 city Name of city in which green infrastructure feature was built City of Pittsburgh Bellevue 10 zip_code ZIP code in which green infrastructure feature was built 15212 15224 11 reduction_percent Estimated percent of flow reduced by having the project constructed Rain < 0.1 inches, 100% reduction. Rain 0.1 to 0.6 inch, 45% reduction. 60-70% 12 reduction_volume Estimated volume of flow reduced by project 200,000 gallons estimated per year total project bioswale + pavers 350,000 gallons/year 13 acreage_managed Total area that drains to green infrastructure feature, including both impervious and pervious land 4200 sq ft 0.318 (acres) 14 impervious_acres_managed Impervious area that drains to green infrastructure feature 4200 sq ft 200 sf 15 photos does this project have a photo link Y N 16 design_drawing Does this project have a drawing link Y N 17 vendors List names of vendors, including contractors, suppliers, designers, etc Unilock - permeable pavers Strada - design 18 maintenance Name of entity responsible for maintaining the property Friends of the Riverfront Municipal DPW 19 flickr_photo_link Photos are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://www.flickr.com/photos/129279167@N06/18956135155/ https://www.flickr.com/photos/129279167@N06/15547977770/ 20 size_vol Floating value; enter number only (gal unit) 5000 120000 21 size_area Floating value; enter number only (sq. ft. unit) 1000 11400 22 cost_total Floating value; enter number only ($ unit) 34000 77300 23 image_url_1 Photos are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm9.staticflickr.com/8864/18455960069_d185351af0_o_d.jpg https://farm9.staticflickr.com/8837/18456012339_734c4307a6_o_d.jpg 24 image_url_2 Photos are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm9.staticflickr.com/8864/18455960069_d185351af0_o_d.jpg https://farm9.staticflickr.com/8837/18456012339_734c4307a6_o_d.jpg 25 image_url_3 Photos are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm9.staticflickr.com/8864/18455960069_d185351af0_o_d.jpg https://farm9.staticflickr.com/8837/18456012339_734c4307a6_o_d.jpg 26 image_url_4 Photos are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm9.staticflickr.com/8864/18455960069_d185351af0_o_d.jpg https://farm9.staticflickr.com/8837/18456012339_734c4307a6_o_d.jpg 27 drawing_url_1 Drawings are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm1.staticflickr.com/386/18019455374_73c3606df1_o_d.jpg https://farm1.staticflickr.com/504/18644380001_6ec8dcab48_o_d.jpg 28 drawing_url_2 Drawings are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm1.staticflickr.com/386/18019455374_73c3606df1_o_d.jpg https://farm1.staticflickr.com/504/18644380001_6ec8dcab48_o_d.jpg 29 drawing_url_3 Drawings are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm1.staticflickr.com/386/18019455374_73c3606df1_o_d.jpg https://farm1.staticflickr.com/504/18644380001_6ec8dcab48_o_d.jpg 30 drawing_url_4 Drawings are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm1.staticflickr.com/386/18019455374_73c3606df1_o_d.jpg https://farm1.staticflickr.com/504/18644380001_6ec8dcab48_o_d.jpg 31 drawing_url_5 Drawings are now uploaded directly to ArcGIS Online. In some cases, links to outside websites were provided instead. https://farm1.staticflickr.com/386/18019455374_73c3606df1_o_d.jpg https://farm1.staticflickr.com/504/18644380001_6ec8dcab48_o_d.jpg 32 latitude Latitude of project site; populated by choosing site on map 40.472676 40.455413 33 longitude Longitude of project site; populated by choosing site on map -80.04052 -79.916734