On this page

Overview

Private Assets are records in Crisisworks that track damage to private property. They are part of the Recovery module, and are normally accessed from a Recovery Case.

Private assets form the basis of the EMV Recovery Integration which provides both aggregate and detailed damage information for EMV, and the Private Assets report that can share details.

This practice note describes how to prepare private asset data for reporting, and then export it to share with other agencies.

About Private Assets

Private assets can include sheds, dwelling, cars, boats etc they are linked to cases. Each case can have zero or many linked private assets. Private assets can only be added and unlinked from cases.

To see the Private assets on their own, Select “Private Assets” from the recovery menu or select the counter from the dashboard

Preparation

Before sharing private asset records, the private assets register should be reviewed for accuracy, completeness and data quality.

Before exporting data you should go though some data cleansing first to ensure that you are sharing clean data.

General tips

Accuracy tips:

• Have all records been inspected? Some records may have been created from imports from other sources, and these may be less accurate than those inspected by your SIA team.

• Check the records to confirm the Dwelling and Primary Place of Residence settings are correct. This has been a common source of misclassification from prior experience.

Completeness tips:

• If all properties in the damage area have not yet been inspected, there may be additional records to be added. Consider letting the readers of this report know if this is a point-in-time report rather than a complete report.

Data quality:

• Are any records active that should be closed? Specifically consider private asset records that are linked to closed cases. The data cleansing counters can help with these.

Data cleansing counters

Some data cleansing counters have been built into Crisisworks to help identify common problems, and these should be reviewed.

Open

These edge cases in data can occur as the result of other data cleansing operations on the Recovery Case register such as merges, bulk imports or bulk edits.

You should review each of these private assets using the following guide.

Additional sanity checks

You can run a series of reports and ad-hoc searches to increase your comfort with the dataset.

Consult the CQL Search Cookbook for some common, useful CQL queries to help organise and understand your data.

Exporting

You can export data from Crisisworks in two main ways

• Method A: Run a report from the reports area (from the overview menu)

• Method B: Apply a filter from a datagrid then export the filtered list of records

To export all private asset data, the simplest approach is Method A, after you have cleaned your data.

Method A: Exporting from the Private Assets report

1. Select reports from the overview menu.

2. Select “Recovery Reports” section on the LHS

3. Select the "Recovery Private Assets” report (see image below)

4. Choose the correct event (it defaults to the current event)

5. Expand "Select Columns to Show”

6. Pick all the fields you need, note Asset Geo may help for Geospatial data

7. Press" Run Report” (green) button at the bottom of the screen

8. Wait for the report to run

9. Press, "Export CSV"

Open

Method B: Exporting from the datagrid

1. Select “Private Assets” from the recovery menu

2. Select a counter a counter from the LHS eg “Active” OR Press the Magnifying glass to enter a search/filter mode, then press apply

3. Press the gold tick at the top of the list to select all the found records

4. Press export to report

5. Pick all the fields you need, note Asset Geo may help for Geospatial data

6. Press "Run Report” (green) button at the bottom of the screen

7. Wait for the report to run

8. Press, "Export CSV"