Inspection & Reporting Tools Tim Paisley August 29th, 2019
Who am I? @TimPaisley
What do I do? I use technology at Wellington City Council to either… a. help our teams work more effectively, or b. help the council and communities make better decisions about their city @TimPaisley
@TimPaisley
Resulting Interest Public Health at Wellington City Council: “That’s cool, can we have that?” @TimPaisley
Use Cases As an Inspector, I want to be able to show the impact of the proposed new application during DLC hearings so that I can better communicate my evidence. @TimPaisley
Use Cases As an Inspector, I want to easily check when inspections in my area need to be completed so that I can meet my LTP requirements. @TimPaisley
Use Cases As an Inspector, I want to automatically fill in my inspection form with information about the licence so that I can focus on recording information we don’t already know. @TimPaisley
Use Cases As a Team Leader, I want to know how many inspections are still due this quarter so that I can ensure we’re on track to fulfill our obligations. @TimPaisley
Journey Map 🤰 😢 😫 @TimPaisley
Solutions…? ● Google Drive Forms and Spreadsheets ● Bespoke Ruby on Rails App ● ArcGIS Workforce + Survey123 ● .NET Mobile App ● Drones @TimPaisley
Solution ● Google Drive Forms and Spreadsheets ● Bespoke Ruby on Rails App ● ArcGIS Workforce + Survey123 ● .NET Mobile App ● Drones @TimPaisley
Solution Operations Workforce Survey123 Dashboard @TimPaisley
Solution Council Database Operations Workforce Survey123 Dashboard Email Server @TimPaisley
FME Transformation A E xtract, T ransform, L oad B @TimPaisley
FME Convert to Microsoft Excel Microsoft Exchange Shared Drive (Email) @TimPaisley
FME Geocode Address ArcGIS Online Database Assign to Inspector (Teamwork) Add Timestamp @TimPaisley
Solution Council Database Survey123 Operations Workforce (with webhooks) Dashboard Email Server @TimPaisley
Journey Map 😅 🥴 🧑 @TimPaisley
Thanks! @TimPaisley
Recommend
More recommend
