A state government agency performs approximately 33,000 inspections every year. Historically, these have been conducted via paper forms. The process involves an inspector walking a site and taking notes and recording the required inspection data regarding their various observations. Then the inspector must return to the office to compile and summarize the notes and inspection results. They will re-enter much of the data, officially recording the inspection information into an application that updates the enterprise database.

The Agency desired to provide the inspectors with a mobile inspection application that has the capabilities of collecting and documenting information at an inspection site, automatically updating/synchronizing the data to the enterprise database, and the ability to produce the inspection results in a paper form to the site owner. The inspector would

use the mobile application during the inspection, eliminating the need to return to the office to compile and summarize the notes and input the inspection results into the inspection application. Previously when conducting an inspection, inspectors could not take pictures and store the pictures with the inspection report. Having this capability within the mobile application would allow the inspector to store pictures along with the notes or observations found during the inspection.

LingaTech, in conjunction with Agency technical staff, created the eInspection application for the iOS platform. LingaTech developed the connectivity, data validation, and data formatting enabling the mobile data to be stored in the enterprise database. The link between the eInspection application and enterprise database utilized a Service Oriented Architecture (SOA).

The inspectors are now using the eInspection application available on the iPad, to record the mobile inspection results. Using the eInspection application, the inspectors record their observations of the various categories and sub-categories of statutory/regulatory requirements directly into the iPad. After the data is entered on the iPad, the inspection results are validated, formatted, and stored in the enterprise database. The application also provides the inspector with the ability to create a PDF document that lists the results of the inspection report for each category/sub-category. The application includes the ability for the inspector to use the iPad to capture and store photos along with the inspection information and supports an electronic signature process. The new mobile application has improved inspectors efficiency by 20% and saved the Agency over $17M across 5 years.

LingaTech worked closely with the client to develop a data analysis tool to improve pedestrian and bicyclist’s safety at intersections across the Commonwealth of Pennsylvania. LingaTech gathered information from various data sources to develop a visual analytical tool that would help in identifying high-risk intersections by analyzing traffic, crash, pedestrian, and bicyclist data at those intersections. This data will then be analyzed to determine the best safety features that should be used at these types of intersections to reduce or eliminate future accidents.

LingaTech’s efforts included the following tasks:

• Gathered all relevant data and its specification
• Conducted thorough data analysis
• Data engineering
• Data visualization

To accurately map the intersections, we required latitude and longitude coordinates for every record in the dataset. We determined an ESRI ArcGIS solution would not only meet the project team’s objectives but was also a standard tool used by our client. Once the data analysis was complete, the data was imported as a .csv into the ArcGIS Online Poral where a feature class was created using the average aggregate (x,y) coordinates of the crashes attributed to a particular intersection.

The data was then mashed with existing public open data (traffic data, bicycle routes, and census data) to create individual web-based interactive maps highlighting each of the different modes of transportation involved in crashes (vehicle, bicycle, pedestrian, etc.).

An additional area of interest, crashes involving non-motor modes of transportation, was explored by adding crash counts for pedestrian and bicycle together. This non-motor mode of transportation was then mapped as well.

Each map was then incorporated into an ESRI Operations Dashboard solution (seven total dashboards were created) which features a list of intersections with the top 50 crashes (within that mode of transportation), which when selected will zoom to the location in the map and update numerous crash statistics. The seven dashboards were then combined to into a single ESRI Web Application to create a single point of access and the final product: PA's Most Dangerous Intersections (2017-2019)

This data exchange application was developed to alleviate many issues the Agency was experiencing. Challenges such as data integration and data exchange were plaguing the Agency with technical and architectural issues, and they needed a solid solution to continue forward with their modernization efforts.

LingaTech architected a platform using a SOA (Service Oriented Architecture), a loosely coupled design with cloud-enabled infrastructure. The SOA initially facilitated three different types of registrations, has OAuth2 authentication and authorization policies built-in. The platform accommodates other security policies based on the provider’s requirements. This platform exchanges data with multiple internal and external entities including state and federal government and private non-profits.

• Establishes consistent procedures for agency-wide data exchange processes
• Increases reusability and agility of application development efforts
• Provides the common framework for the development of all future applications
• Minimizes redundant infrastructure and the associated costs
• Enables interoperability and integration between applications on various platforms such as EDI, SAP, et al.
• Provides a common method for customers to consume data services via web applications
• Provides electronic confirmation of data exchange such as information received, information disposition, information error handling, etc.

• Assists in achieving compliance with customer data/security/reporting requirements
• Increased data quality
• Provides the management of information with customers at separate time intervals by using publish-subscribe messaging between applications
• Allows the movement of data that is no longer actively used by a specific agency to a separate data storage device for long-term retention and archiving
• Tracks data accessed by customers providing a measurement of system performance
• LingaTech played integral leadership roles within the development and architecture teams and the end-user community with proven experience as partners to guide

both parties through the entire life cycle of the project so that the product effectiveness is maximized.