ANLY482 AY2017-18T2 Group02 Findings & Insights

From Analytics Practicum
Revision as of 14:41, 1 March 2018 by Zk.ang.2014 (talk | contribs)
Jump to navigation Jump to search
Home   Project Overview   Findings & Insights   Documentation   Project Management   Back to project list


Thesis

Thesis — Algorithm-driven architectural design and procedural generation of 3D digital environments were the inspiration for the lofty initial goal of this project: to perform, aid, or serve to validate structural engineering design for underground train stations. On the premise that geological features were likely to be primary considerations, we hoped to build a predictive model to accomplish this. However, through further dialogue with the engineers, and examination of the geological data, it’s become clear that much of the structural design is not related to geological features; rather, there are other more significant hidden variables influencing design.

Limiting factors — Soil stratum data from borehole excavation serves as an informing factor to engineers designing retaining and load-bearing walls for stations, but the relationship between strata and design parameters remains obscure as a form of domain knowledge. Further insight into what considerations are made by engineers when looking over geological data is necessary, and additional data on the relationship between boreholes and station design features, i.e. walls, would be necessary to move toward predictive capability.

Reframing goals and the pathways to them — Given the limited predictive capacity of just borehole data, we will instead seek to build better understanding of the geological information through visualization, for the sake of future predictive efforts.

Data Preparation and Exploration

JFI draftdrawing.png
Data sources — We have two key data sets from the sponsor: A Microsoft Access file containing information on the geological properties of boreholes, as well as their locations; and a set of engineering drawings comprising 5 stations of Downtown Line 3, including reference tables to boreholes and the corresponding engineering design features.

JFI pivot.png
Pivot table — The first thing we needed to do was to pivot the borehole data such that stratum data is grouped by borehole, instead of stratum. Each borehole had different depths and number of strata, presumably dug and measured based on the surveyor’s insights on what is necessary for the project and possible on the site.

JFI strata distr.png
What’s immediately observable is that there are a few outlier (n=8) boreholes with unusually many strata identified, especially one with 64 strata. This drastically increases the number of features after pivoting, especially after including not only the baseline of each strata, but also the soil type. The feature space of the pivoted table is also consequentially considerably more sparse than the original ungrouped table. When attempting to build a predictive model in the future, the sparse matrix must be taken into consideration when selecting both the model and the implementation of the model.



CRS conversion — The other transformation that needed to be performed was to convert the borehole coordinates from the SVY21 projection to the WGS84 projection for easier visualization, and standardization of the coordinate reference system.

JFI boreholemap.png
This transformation was performed with the aid of SLA’s OneMap Coordinate Convertor web API, and overlaid onto a base map of Singapore for reference. The first noticeable feature is that some boreholes are referenced to be in unusual locations far from the main body of boreholes close to the Downtown Line tunnels and stations. Having confirmed that the coordinate systems used to project the data set are correct, we must raise the concern of whether other boreholes that we wish to use for analysis have b een correctly labeled, and how to verify this.



JFI station boreholes.png
Secondly, comparing the full dataset of boreholes to the boreholes referenced in the design draft drawings, it’s clear that only a subset (marked in blue in the example figure below) are referenced when the engineers perform their design, or at least it seems so based on the design documents. This compounds the importance of clarifying the significance of borehole data with the engineers performing design, i.e. how they are selected, how they influence design.




Data Engineering & Subsequent Steps

JFI borehole depth.png
Goals — Given the unfeasibility of the previous objective of predicting design from borehole data, we must now pivot to obtaining a better understanding of the borehole and design data independently, to lay a foundation for prediction in the future, with supplementary data sets and better understanding of the engineering design process and relationships between features.

JFI borehole eg.png
Boreholes — Intuitively, there is a temptation to analyze the distribution of the depth, thickness, and soil type of each stratum belonging to each borehole, but such a representation is unlikely to shed meaningful light on the properties of the geological conditions toward the goal of engineering underground infrastructure. This is because the boreholes have a geospatial relationship to one another, and a general population analysis would ignore this crucial aspect. Instead, moving forward, we will seek to visualize the boreholes relative to one another, and possibly seek a way to identify which boreholes are significant toward engineering designed, based on the boreholes that were selected in the design drawings out of the general population.

JFI borehole loc.png
Design Documents — The design documents specify various structural parameters of the walls, such as their thickness, material, load capacity etc. But there is additional information available in the drawings that is not captured in the tables: a) more detailed information about the orientation and distance of walls to the associated boreholes, and b) the geometrical network of walls in relation to one another, i.e. adjacent walls and their orientation. If the drawings could be engineered into a data matrix describing their dimensions and orientation, it would become easier to perform analysis on them in relation to other data.




Insights and Next Milestones

New Deliverables — Instead of trying to build a predictive model, from here out we will instead be building out understanding of the borehole and station data independently, engineering features that can help engineers more clearly understand the factors at play, and seeking a way to visualize the data, especially the three-dimensional geological borehole data, in a clear and concise manner.

Laying the foundation for prediction — The feature engineering and visualization of both the independent variable(geology) and dependent variables from past design (station design drawings and tables) should be undertaken in an open-ended framework that will permit the inclusion of additional data, e.g. engineers’ logbooks, data on other factors that determine location, depth, orientation etc. of station boxes and tunnels. In this way, they can serve as the first phase toward a future where procedurally generated infrastructure engineering design may be possible, and engineers can spend their time more productively designing the rules by which design happens, instead of calculating the parameters individually.