![Page 1: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/1.jpg)
Integrating Esri SoftwareWith Third Party Solutions
Tom Resh – City of RedlandsRaj Patil - Cityworks
![Page 2: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/2.jpg)
Third Party Integration at the City of Redlands
• Cityworks – Permitting and Work Orders
• RoadVista Model 922 – Sign Retroreflectivity
• CitySourced – Citizen Engagement
![Page 3: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/3.jpg)
Cityworks – made to work with Esri Products
• A map powered by ArcGIS Server is an integral part of Cityworks.
![Page 4: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/4.jpg)
Information from your GIS can be brought into Cityworks
• Here we have selected a parcel and the address information has been automatically added to our permit.
![Page 5: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/5.jpg)
Work Orders can be attached to assets to keep track of costs.
• A tree trim work order is attached to a tree in the GIS data.
![Page 6: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/6.jpg)
ArcGIS can be used for further analysis.
• A heat map is generated to show where tree maintenance costs are the highest.
![Page 7: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/7.jpg)
Expanding on the out of the box capabilities.
• Adding Encroachment Permits to the Road Closure map.
![Page 8: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/8.jpg)
Old Method – ArcGIS Online Editing
• Staff maintains data adding locations and removing them when the permit is closed.
![Page 9: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/9.jpg)
Wait – All the information we need is in Cityworks
• Results of query that pulls all the data together.
![Page 10: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/10.jpg)
The information we need is in four different tables.
![Page 11: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/11.jpg)
Create a SQL view to extract the needed data.
• Advantage: always up to date.• Disadvantage: slow, 1.7 million records, query takes 20
seconds.
![Page 12: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/12.jpg)
Create a SQL Server Agent Job to copy the records to a table.
• Advantage: Once the table is made accessing the data is fast.
• Disadvantage: Will not always be up to date.
![Page 13: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/13.jpg)
Create the ArcGIS Service
• Create a database connection to the Cityworks database.
![Page 14: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/14.jpg)
Create the ArcGIS Service
• Register the data with your server.
![Page 15: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/15.jpg)
Create the ArcGIS Service
• Add the table created by the SQL Server Agent Job to ArcMap.
![Page 16: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/16.jpg)
Create the ArcGIS Service
• Display the data as an X Y Event Layer.
![Page 17: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/17.jpg)
Create the ArcGIS Service
• Add definition query and symbolize as necessary.
The SQL query that creates the table only selects permits that are not closed so the permit is automatically removed when the permit is closed.
Current QueryStartDate<= getdate() and CompDate >= getdate()
Future QueryStartDate > getdate()
![Page 18: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/18.jpg)
Map with Encroachment Permits Displayed
![Page 19: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/19.jpg)
Code Enforcement Cases
Need to display Code Enforcement Cases so Building Permits will not be issued until case is cleared.
![Page 20: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/20.jpg)
Code Enforcement Cases
Code Enforcement is kept in separate Cityworks database.
Permitting Code Enforcement
![Page 21: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/21.jpg)
Code Enforcement Cases
Create a View to Extract the Data
![Page 22: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/22.jpg)
Code Enforcement Cases
Python script creates a shapefile using MakeXYEventLayer
arcpy.MakeXYEventLayer_management(CodeEnforcement_dbo_aaaDenyPermitCodes, "CX", "CY", TheLayer, "PROJCS['WGS_
![Page 23: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/23.jpg)
Code Enforcement Cases
Use the shapefile in the service that is used by CityWorksPermitting.
![Page 24: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/24.jpg)
RoadVista Model 922 – Sign Retroreflectivity
Using the Collector App for better results
![Page 25: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/25.jpg)
RoadVista results are not always accurate.
![Page 26: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/26.jpg)
Use existing sign data.
Add Barcode attribute to link to RoadVista results.
![Page 27: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/27.jpg)
Field Crew uses the Collector App
Select the signand enter the barcode.
Can also add signs if necessary.
![Page 28: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/28.jpg)
Data is downloaded from the RoadVista
Exported as a shapefile.
![Page 29: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/29.jpg)
Script transfers RoadVista info to sde database.
![Page 30: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/30.jpg)
Another script applies the chart below to determine if the sign passes or fails.
![Page 31: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/31.jpg)
Scripts are scheduled to run every workday.
![Page 32: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/32.jpg)
Results are displayed using ArcGIS online.
![Page 33: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/33.jpg)
CitySourced – Citizen Engagement
![Page 34: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/34.jpg)
CitySourced – Citizen Engagement
![Page 35: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/35.jpg)
CitySourced – Citizen Engagement
Issues are displayed in the CitySourcced Console
![Page 36: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/36.jpg)
CitySourced – Citizen Engagement
Service Requests can be created in Cityworks using the PUSH to option
![Page 37: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/37.jpg)
CitySourced – Citizen Engagement
Data can be downloaded for further analysis.
![Page 38: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/38.jpg)
CitySourced – Citizen Engagement
Heat map showing the distribution of incidents reported.
![Page 39: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/39.jpg)
Future possibilities:
Using the collector app to update the status of work orders.
Using the collector app to capture street light surveys and create a work order to record the results.
![Page 40: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/40.jpg)
Future PossibilitiesUsing the collector app to update the status of work orders.
Using the collector app to capture street light surveys and create a work order to record the results.
![Page 41: Integrating Esri Software with Third Party Solutions...Integrating Esri Software With Third Party Solutions Tom Resh – City of Redlands Raj Patil - Cityworks Third Party Integration](https://reader031.vdocuments.us/reader031/viewer/2022011823/5ed052523a066a18461b5754/html5/thumbnails/41.jpg)
Never let your stomach know you are a poor man.
Mark Caldwell – Bicycle Racer