This master thesis describes the development of a database and a Website to support the newest version of Low-Impact-Development Rapid Assessment Model (LIDRA) LIDRA 2.0, a planning level model for assessing the cost-effectiveness of low impact development (LID) for reducing combined sewer overflows (CSOs) and runoff-related problems in urban watersheds. LIDRA 2.0 is a web-based application that generates stochastic precipitation data from local historical data sets using a Markov Chain and bootstrapping method. Precipitation is applied to urban watersheds with parcel and street areas. LID scenarios and associated adoption and repaving rates are then used to perform multiple 30-year simulations, during which the difference in runoff (compared with the original, no-LID scenario) is calculated using a water balance that invokes the Thornthwaite Mather approach. These processes generate a large amount of data that require an extensive database to store them. In addition, the system needs to store parcel and street specifications and also offer a management interface both of which must be accessible through the internet (browser). The LIDRA database is developed using SQL Server which is connected to the online tool that has been developed using Visual C#. NET, Visual Basic. NET and ASP. NET. The result of this are: an efficient tool to support LIDRA in terms of storage, retrieval and analysis of data and an integrated web application which allows users an easier way to input data and greatly reduce the time it takes to manage of them, access and management of simulation modules and use of the graphical interfaces provided to show the results produced by the model. The technical underpinnings of this tool are highlighted using a small example.
Metrics
31 File views/ downloads
27 Record Views
Details
Title
Development of a database and website for low impact development rapid assessment (LIDRA) tool version 2.0
Creators
Miguel Aguayo - DU
Contributors
Michael Piasecki (Advisor) - Drexel University (1970-)
Awarding Institution
Drexel University
Degree Awarded
Master of Science (M.S.)
Publisher
Drexel University; Philadelphia, Pennsylvania
Resource Type
Thesis
Language
English
Academic Unit
Civil (and Architectural) Engineering [Historical]; College of Engineering (1970-2026); Drexel University