Using SAP HANA along with Esri ArcGIS, the City of San Diego was able to leverage state-of-the-art technologies to put location information into the hands of the Street Sweeping Supervisors.
Supervisors can now see the entire route a truck drove during a day, which street segments were swept according to schedule, and which unplanned street segments were swept.
Keeping City Streets Clean
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 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.
Visualizing Sweeping Truck Routes
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. Development of the 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 their SAP footprint by implementing the Plant Maintenance module. Taking advantage of both SAP HANA and Esri’s ArcGIS functionality was imperative to the overall success of the project.
Uniting Three Business Systems
“The primary challenge was architecting a scalable solution that would unite three separate but associated business systems.” said Andrew Tangeman, Quartic Solutions’ GIS Architect. The solution, named GeoSweep, had to be capable of integrating three environments. Geosweep pulls and pushes data between a 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 for interfacing with 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 join multiple technologies into one solution.
While SAP creates the daily reoccurring 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. Information regarding the trucks activity throughout the day, such as the GPS coordinates, the sweeper up/downs, and the tonnage of trash collected is gathered by CalAmp. Then, these data are reviewed, logged, and sent to SAP using GeoSweep.
Another function of GeoSweep is to handle non-reoccurring work order information. 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 into SAP. Once the work order exists in SAP, using the map the associated actual GPS locations can be added to the workorder. The design handles sweeping data associated with both the left and right-hand curb street segments.
GeoSweep will receive routine maintenance updates to keep current with Esri’s application lifecycle plan. Next planned upgrade is scheduled for the fiscal year 2019.
