Incident Display and Reporting
Severn Trent Water
Nov 2014 – May 2015
GIS4BUSINESS were involved in the design and development of Severn Trent Water’s updated web and mobile customer incident display and reporting pages, known as ‘In My Area’.
Acting as technical lead for the overall solution, GIS4BUSINESS provided extensive guidance and best practice to the third-party web developers and were also involved extensively in the usability and performance enhancements that helped ensure the success of the project.
GIS4BUSINESS involvement in the project included:
- Producing the detailed technical design relating to the GIS components of the solution and how they integrate with non-GIS components.
- Design of the underlying Esri geodatabase schema to support storage and display of work order and work notification information sourced from SAP, including geometry.
- Development of supporting processes, including the SQL Server C# CLR triggers that transform work notification and work order information from SAP and create spatial features in the GIS database.
- Support during development and testing of the overall solution, including the integration with SAP.
Based on business logic defined by STW, a subset of work orders that are related to ongoing incidents are synchronised to a secure ArcGIS Online feature service, which is then consumed by several web maps that are embedded in the ‘In My Area’ pages on the main STW website.
In addition to being consumed by public facing web maps, the work order and notification information held in the GIS database is also available to several internal GIS solutions within STW.
“STW have employed a variety of services from GIS4BUSINESS that have involved a range of technologies and complexity with significant collaboration across our business. The quality of outputs and professionalism are excellent and we would not hesitate to engage GIS4BUSINESS for future projects.”
Related Projects
Mapping & Crime Analysis
GIS4BUSINESS provided consultancy and development expertise to Thames Valley Police during implementation of mapping and address data updates to internal systems and assisted with improvements to crime analysis, geo-coding and mapping.
Retail Delivery Area Management
GIS4BUSINESS worked closely with eflorist to design and develop a web-based mapping application to enable franchised retail outlets to map their delivery areas, postcodes and rates and to gain greater insight into their network.
Utility GIS Improvements
A detailed review was undertaken by GIS4BUSINESS of the state of Portsmouth Water's GIS and asset data. GIS improvements were implemented and have enabled Portsmouth Water to exploit GIS data and integrate GIS with other systems.