Inspection & Reporting Tools Tim Paisley August 29th, 2019 Who - - PowerPoint PPT Presentation

▶

Feb 28, 2024 412 likes •635 views

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

SLIDE 1

Inspection & Reporting Tools

Tim Paisley

August 29th, 2019

SLIDE 2

Who am I?

@TimPaisley

SLIDE 3

What do I do?

@TimPaisley 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

SLIDE 4

@TimPaisley

SLIDE 5

Resulting Interest

@TimPaisley Public Health at Wellington City Council: “That’s cool, can we have that?”

SLIDE 6

Use Cases

@TimPaisley 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.

SLIDE 7

Use Cases

@TimPaisley 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.

SLIDE 8

Use Cases

@TimPaisley 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.

SLIDE 9

Use Cases

@TimPaisley 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.

SLIDE 10

Journey Map

@TimPaisley

🤰 😢 😫

SLIDE 11

Solutions…?

@TimPaisley

Google Drive Forms and Spreadsheets
Bespoke Ruby on Rails App
ArcGIS Workforce + Survey123
.NET Mobile App
Drones

SLIDE 12

Solution

@TimPaisley

Google Drive Forms and Spreadsheets
Bespoke Ruby on Rails App
ArcGIS Workforce + Survey123
.NET Mobile App
Drones

SLIDE 13

Solution

@TimPaisley Survey123 Workforce Operations Dashboard

SLIDE 14

Solution

@TimPaisley Survey123 Workforce Operations Dashboard Council Database Email Server

SLIDE 15

FME

@TimPaisley A B Transformation Extract, Transform, Load

SLIDE 16

FME

@TimPaisley Microsoft Exchange (Email) Shared Drive Convert to Microsoft Excel

SLIDE 17

FME

@TimPaisley Database ArcGIS Online (Teamwork) Geocode Address Assign to Inspector Add Timestamp

SLIDE 18

SLIDE 19

Solution

@TimPaisley Survey123 (with webhooks) Workforce Operations Dashboard Council Database Email Server

SLIDE 20

Journey Map

@TimPaisley

😅 🥴 🧑

SLIDE 21

Thanks!

@TimPaisley