Intranet website used to query and analyse an excessively large database of GIS data for GHD Engineering.
The client needed to perform advanced queries to look for trends in the data. Data points were captured every second for the last six months. The C# backend would build complex SQL query and send it off to get processed in real time.
The main challenge of the project was to make sure the website and queries were fast, but maintain flexibility in what the user could query. Some of the calculations and table matching could be done in advance, so every 24 hours a normalisation was run to pre-compute as much data as possible to keep the website running fast.
- Solo Developer
- C#.Net, MVC5,
- HTML5, JS (Angular), CSS (Bootstrap)
- Entity Framework, Linq
- MSSQL, Database optimisation and normalisation
- Unit Testing
- Windows Server 2008
- Advanced GIS mathematics