Conclusion

The project addressed the lack of subsurface infrastructure location data to analyze and solve the issue of aging underground infrastructure in New York City, which poses significant risks of disruptions to the residents and the environment. The traditional hazard analysis method does not take into account the risks associated with aging infrastructure, and the direct burial method is not sustainable, disruptive, and costly. The project aimed to create a fully-loaded methodology and analytical tool that would provide a working substitute for the lack of location data.

In conclusion, the project's high-level deliverables were to create a methodology and analytical tool that fills out the aging infrastructure vulnerability, disruptions, and economic/social impact issues and that can be used to tie the knowledge derived from the tool back to capital planning processes. The team developed a fully-loaded methodology and analytical tool, obtained data from various sources, and performed exploratory data analysis using the OSEMN process, created visualizations in Tableau and ArcGIS. The team designed and documented the fully-loaded methodology and outline of the tool, developed a minimum viable product with analytical features, and created a repository/website for all the data and visualizations, published dashboards and made it available for the sponsors for further analysis. 

The exploratory data analysis and data visualization presented in the report are just the initial steps towards identifying the subsurface infrastructure vulnerabilities, resulting disruptions, and economic/social impact of failures in New York City. Some further analysis that could be done includes:

Statistical Analysis: The report mainly focuses on visualizations to identify trends and patterns in the data. However, statistical analysis can provide deeper insights and help in identifying significant factors that contribute to infrastructure failures.

Predictive Modeling: By using machine learning algorithms, it may be possible to predict infrastructure failures in advance, based on factors such as age of infrastructure, location, and other variables.

Risk Assessment: A risk assessment can be done to identify the most critical areas of infrastructure that need urgent attention and prioritization.

Overall, the project has the potential for more in-depth analysis to provide insights into the vulnerabilities and risks of aging infrastructure in New York City, and to suggest policy options for creating sustainable and safe infrastructure for the future.