Herding CATs Data modelling and validation with FME James Grant - - PowerPoint PPT Presentation

▶

Oct 26, 2022 139 likes •391 views

Herding CATs Data modelling and validation with FME James Grant Paul Goodhue Contents - The issue - The solution - The outputs - Next steps Pressure Class Stiffness Rating Installation Company Survey Date Pipe Depth Installation

SLIDE 1

Herding CATs

Data modelling and validation with FME

James Grant Paul Goodhue

SLIDE 2

The issue
The solution
The outputs
Next steps

SLIDE 3

SLIDE 4

SLIDE 5

SLIDE 6

SLIDE 7

SLIDE 8

SLIDE 9

SLIDE 10

Pressure Class Stiffness Rating Installation Company Survey Date Pipe Depth Installation Method

SLIDE 11

IDS Governor Framework

SLIDE 12

IDS Governor Database

Multiple asset categories (3 Waters,

Parks, Foreshore).

Mapping of fields between IDS,

GIS and SAP.

Allows multiple revisions to be

stored and validated.

Data validation business rules
CAT configuration.
CAT submission logging.
CAT Validation results .

SLIDE 13

Loading the Governor

SLIDE 14

Data Modelling –Excel Template

SLIDE 15

Data Modelling –Power Designer

SLIDE 16

Creating the CAT Template

SLIDE 17

Creating the CAT Template

SLIDE 18

Validating CATs

SLIDE 19

More Validating CATs…

SLIDE 20

Validation Outputs -Excel

SLIDE 21

Validation Outputs -KML

SLIDE 22

As-Built Data Processing

Workbench moves data

from CAT to stage tables.

Asset features can then be

checked and approved by project manager.

Uses configuration stored

in the Governor database.

SLIDE 23

CAT Submission Portal

SLIDE 24

Next Steps

Configure Governor to model and process additional categories of asset data.
Release regular revisions to ensure the system can validate and process changing as-built

requirements.

Investigate ways to continue streamlining the whole process end-to-end.
Lay the foundations to enable submission of as-built data in other formats and by methods other

than Excel, such as an API.