EM Impact CQL searching

This page contains CQL (Crisisworks Query Language) examples for Emergency Management Victoria reporting requirements.

Overview

Searching and Filtering

CQL (Crisisworks Query Language) can be used to perform advanced searches. They allow you to use structured queries to search for content.

This page contains specific CQL examples for EM Impact reporting requirements. These can be copied and pasted into the search to find assessments that align with the EMV reporting parameters.

You MUST be in the correct Recovery module register for these searches to work

Query examples

Persons queries

EMIA-1 Aboriginal/ Torres Strait Islander Impacted

In Recovery > Persons:

is:active atsi:Yes

EMIA-2 Aboriginal/ Torres Strait Islander Req’d Support

In Recovery > Persons:

is:active atsi:Yes AtsiCulturalSupport:[Yes,Potentially]

Commercial queries

EMIA-13 Buildings Damaged Value* (excl. agriculture)

In Recovery > Private Assets:

is:active 
BuildingType:[
    vehicle/boat,
    dwelling/caravan,
    dwelling/flat,
    dwelling/holiday-rental,
    facility/other,
    structure/other,
    structure/shed,
    facility/shop] 
BuildingDamage:[2,3,5,1] 
Value:any 
RelatedCase:(is:active PropertyUseCommercial:Yes)

^{_{*To calculate the total damaged value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-14 Buildings Destroyed Loss (excl. agriculture)

In Recovery > Cases:

is:active 
PropertyUseCommercial:Yes 
PrivateAssets:(is:active BuildingType:[
    vehicle/boat,
    dwelling/caravan,
    dwelling/flat,
    dwelling/holiday-rental,
    facility/other,
    structure/other,
    structure/shed,
    facility/shop] 
BuildingDamage:4) 

EMIA-15 Financial Loss value* (non-building)

In Recovery > Private Assets:

is:active 
Buildingtype:"Business Economic Impact" 
BuildingDamage:[4,1,3,2,5] 
Value:any 
RelatedCase:(is:active PropertyUseCommercial:Yes)

^{_{*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-16 Buildings Damaged (excl. agriculture)

In Recovery > Cases:

is:active 
PropertyUseCommercial:Yes 
PrivateAssets:(is:active 
Buildingtype:[
    vehicle/boat,
    dwelling/caravan,
    dwelling/flat,
    dwelling/holiday-rental,
    facility/other,
    structure/other,
    structure/shed,
    facility/shop]
BuildingDamage:[2,3,5,1])  

EMIA-17 Buildings Destroyed Loss Value* (excl. agriculture)

In Recovery > Private Assets:

is:active 
BuildingType:[
    vehicle/boat,
    dwelling/caravan,
    dwelling/flat,
    dwelling/holiday-rental,
    facility/other,
    structure/other,
    structure/shed,
    facility/shop] 
BuildingDamage:4 
Value:any 
RelatedCase:(is:active PropertyUseCommercial:Yes)

^{_{*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

Infrastructure queries

EMIA-20 Local Community Facilities Damaged

In Recovery> Infrastructure:

is:active 
InfrastructureType:[property,facility] 
DamageLevel:[2,3,5,1]

EMIA-21 Local Community Facilities Damaged (Loss Value*)

In Recovery> Infrastructure:

is:active 
InfrastructureType:[property,facility] 
DamageLevel:[2,3,5,1]
CostEstimate:any

^{_{*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-22 Local Community Facilities Destroyed

In Recovery> Infrastructure:

is:active 
InfrastructureType:[property,facility] 
DamageLevel:4

EMIA-23 Local Community Facilities Destroyed (Loss value*)

In Recovery> Infrastructure:

is:active 
InfrastructureType:[property,facility] 
DamageLevel:4
CostEstimate:any

^{_{*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-34 Municipal Bridges Damaged

In Recovery> Infrastructure:

is:active 
InfrastructureType:bridge 
DamageLevel:[2,3,5,1]

EMIA-35 Municipal Bridges Destroyed

In Recovery> Infrastructure:

is:active 
InfrastructureType:bridge
DamageLevel:4

EMIA-36 Municipal Culverts & Drainage Struct. Damaged

In Recovery> Infrastructure:

is:active 
InfrastructureType:[
    stormwater-pipe,
    stormwater-pit,
    culvert] 
DamageLevel:[1,3,2,5] 

EMIA-37 Municipal Culverts & Drainage Struct. Destroyed

In Recovery> Infrastructure:

is:active 
InfrastructureType:[
    stormwater-pipe,
    stormwater-pit,
    culvert] 
DamageLevel:4

EMIA-38 Municipal Roads Damaged

In Recovery> Infrastructure:

is:active 
InfrastructureType:road
DamageLevel:[1,3,2,5]

EMIA-39 Municipal Roads Destroyed

In Recovery> Infrastructure:

is:active 
InfrastructureType:road
DamageLevel:4

EMIA-40 Municipal Trails/Walkways Damaged

In Recovery> Infrastructure:

is:active 
InfrastructureType:trails-walkway 
DamageLevel:[1,3,2,5]

EMIA-41 Municipal Trails/Walkways Destroyed

In Recovery> Infrastructure:

is:active 
InfrastructureType:trails-walkway 
DamageLevel:4

EMIA-42 Municipal Roads Damaged (distance)

See EMIA-38

EMIA-43 Municipal Roads Destroyed (distance)

See EMIA-39

EMIA-44 Municipal Trails/Walkways Damaged (distance)

See EMIA-40

EMIA-45 Municipal Trails/Walkways Destroyed (distance)

See EMIA-41

Residential queries

EMIA-77 Primary Private Residences (Damaged, habitable)

In Recovery > Private Assets:

is:active 
BuildingDamage:[1,3,5]
PrimaryPlaceOfResidence:Yes 
RelatedCase:(is:active)

EMIA-78 Primary Private Residences (Damaged, uninhabitable)

In Recovery > Private Assets:

is:active 
BuildingDamage:[2,3,5]
PrimaryPlaceOfResidence:Yes 
RelatedCase:(is:active)

EMIA-79 Primary Private Residences (Destroyed)

In Recovery > Private Assets:

is:active 
BuildingDamage:4
PrimaryPlaceOfResidence:Yes 
RelatedCase:(is:active)

EMIA-80 Non-Primary Private Residences (Damaged, habitable)

In Recovery > Private Assets:

is:active
PrimaryPlaceOfResidence:No
BuildingCategory:dwelling
BuildingDamage:[1,3,5]
RelatedCase:(is:active)

EMIA-81 Non-Primary Private Residences (Destroyed)

In Recovery > Private Assets:

is:active
PrimaryPlaceOfResidence:No
BuildingCategory:dwelling
BuildingDamage:4
RelatedCase:(is:active)

EMIA-82 Non-Prim Private Residences (Damaged, uninhabitable)

In Recovery > Private Assets:

is:active
PrimaryPlaceOfResidence:No
BuildingCategory:dwelling
BuildingDamage:[2,3,5]
RelatedCase:(is:active)