Using SAP HANA and Esri ArcGIS, the City of San Diego could leverage state-of-the-art technologies to put location information into the hands of the Street Sweeping Supervisors. Supervisors can now see a truck's entire route during a day, which street segments were swept according to schedule, and which unplanned street segments were swept.
With more than 1.4 million people, San Diego is the eighth-largest city in the United States and the second-largest in California. San Diego is a top tourist destination, but this Southern California metropolis with a laid-back vibe is also home to cutting-edge businesses in life sciences, genomics, biotechnology, telecommunications, Smart City technology, software, electronics, and other major innovative industries.
GIS forms a major component of the City’s IT services. GIS is utilized extensively throughout the City as the underlying technology for widely varying applications such as 911 dispatch, crime analysis, fire hazard assessment, asset and infrastructure management, and street-related work order processing.
The City of San Diego's Transportation Storm Water and Public Works Departments needed an intuitive tool for viewing and comparing planned versus actual street sweeping routes. They also needed a method for retaining the history of sweeper information. Both tabular and spatial data needed to be viewed together to accurately visualize and understand the actual vehicle movements, relative to the assigned SAP work order routes on any given day. The development of GeoSweep started in August 2017 and was completed in March 2018. The City of San Diego has been using the solution since April 2018.
GeoSweep was one of many components implemented by The City’s Infrastructure Asset Management Project (IAM San Diego). IAM San Diego replaced 32 legacy systems across the Departments of Information Technology, Public Utilities, Public Works and Transportation, and Storm Water. The City was already using an Esri ArcGIS enterprise geodatabase to store asset location data and chose to expand its SAP footprint by implementing the Plant Maintenance module. Taking advantage of SAP HANA and Esri’s ArcGIS functionality was imperative to the project's overall success.
The primary challenge was architecting a scalable solution to unite three separate but associated business systems. The solution, GeoSweep, had to integrate three environments. GeoSweep pulls and pushes data between an SAP HANA EAM system, a CalAmp Automated Vehicle Location (AVL) system, and an Esri ArcGIS Enterprise System.
GeoSweep was built using ArcGIS Runtime for JavaScript API 4.x and Microsoft .NET MVC 6 to interface with the FleetManager AVL database. The SAP/EAM portion of GeoSweep is consumed via JSON/REST. In addition, a mix of GeoJSON and ArcGIS for Server MapServices allows the application to combine multiple technologies into one solution.
While SAP creates the daily recurring street sweeping work orders based on predetermined geographic routes, to comply with legal requirements, staff must also have a mechanism to save the actual routes driven by the trucks. CalAmp gathers information regarding the trucks' activity throughout the day, such as the GPS coordinates, the sweeper up/downs, and the tonnage of trash collected. Then, these data are reviewed, logged, and sent to SAP using GeoSweep.
Another function of GeoSweep is to handle information on non-reoccurring work orders. For example, in the case of a special event in Mission Bay Park, a truck may have swept locations inside the park that are not contained in the normal predetermined route. The map highlights these differences, and the supervisor can then add a special event work order in SAP. Once the work order exists in SAP, the associated GPS locations can be added to the work order using the map. The design handles sweeping data associated with the left and right-hand curb street segments. GeoSweep will receive routine maintenance updates to keep up with Esri’s application lifecycle plan. The next planned upgrade is for fiscal year 2019.
