Victorian Emergency Management

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

Overview

Searching, Filtering and Querying Registers

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 Emergency Management Victoria (EMV) 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

EMV-1 Facilities Damaged

Infrastructure Assessment

is:active AND (infrastructureType:property OR infrastructureType:facility) AND (damageLevel:1 OR damageLevel:5)

EMV-3 Facilities Destroyed

Infrastructure Assessment

is:active AND (infrastructureType:property OR infrastructureType:facility) AND (damageLevel:2 OR damageLevel:3 OR damageLevel:4)

EMV-5 Bridges damaged

Infrastructure Assessment

is:active AND infrastructureType:bridge AND (damageLevel:1 OR damageLevel:2 OR damageLevel:3 OR damageLevel:4 OR damageLevel:5)

Or

is:active AND infrastructureType:bridge NOT damageLevel:6

EMV-6 Road Reserves damaged

Infrastructure Assessment

is:active AND infrastructureType:road-reserve AND (damageLevel:1 OR damageLevel:2 OR damageLevel:3 OR damageLevel:4 OR damageLevel:5)

Or

is:active AND infrastructureType:road-reserve NOT damageLevel:6

EMV-8 Roads damaged

Infrastructure Assessment

is:active AND infrastructureType:road NOT damageLevel:6

EMV-10 Trails/walkways (damaged)

Infrastructure Assessment

is:active AND infrastructureType:road NOT damageLevel:6

EMV-12 Primary Residences (Damaged)

Private Assets

is:active AND primaryPlaceOfResidence:true AND (buildingDamage:1 OR buildingDamage:5)

EMV-13 Primary Residences (Destroyed)

Private Assets

is:active AND primaryPlaceOfResidence:true AND (buildingDamage:2 OR buildingDamage:3 OR buildingDamage:4)

EMV-14 Total Residences (Damaged)

Private Assets

is:active AND buildingCategory:dwelling AND (buildingDamage:1 OR buildingDamage:5)

EMV-15 Total Residences (Destroyed)

Private Assets

is:active AND buildingCategory:dwelling AND (buildingDamage:2 OR buildingDamage:3 OR buildingDamage:4)

EMV-16 Loss value (non-building) - Financial loss

Private Assets

is:active AND (recoveryCase:is:active) AND (recoveryCase:propertyUseCommercial:true) AND buildingType:other/business-economic-impact NOT buildingDamage:6

EMV-17 Damaged loss value (excl. agriculture)

Private Assets

is:active AND (recoveryCase:is:active) AND (recoveryCase:propertyUseCommercial:true) AND (buildingType:boat OR buildingType:caravan OR buildingType:flat OR buildingType:holiday-rental OR buildingType:facility-other OR buildingType:structure-other OR buildingType:shed OR buildingType:shop) NOT (buildingDamage:1 OR buildingDamage:5)

EMV-18 Destroyed loss count (excl. agriculture)

Private Assets

is:active AND (recoveryCase:is:active) AND (recoveryCase:propertyUseCommercial:true) AND (buildingType:boat OR buildingType:caravan OR buildingType:flat OR buildingType:holiday-rental OR buildingType:facility-other OR buildingType:structure-other OR buildingType:shed OR buildingType:shop) NOT (buildingDamage:2 OR buildingDamage:3 OR buildingDamage:4)

DHHS Primary Place of residents that are totally damaged

Private Assets

status:>0 recoveryCase.status.id:>0 AND primaryPlaceOfResidence:true AND (buildingDamage.label:"Totally destroyed" OR buildingDamage.label:"Inaccessible / Non-Functioning") recoveryCase.tags:sia-inspection-completed

Reference Lookup Values

Category	Label	Value
Building Category	Dwelling	dwelling
Building Category	Facility	facility
Building Category	Structure	structure
Building Category	Equipment	equipment
Building Category	Vehicle	vehicle
Building Category	Other	other
Building Type	Bikes	vehicle/bike
Building Type	Boats	vehicle/boat
Building Type	Business Economic Impact	other/business-economic-impact
Building Type	Cars	vehicle/car
Building Type	Caravans	dwelling/caravan
Building Type	Community Centre(s)	facility/community
Building Type	Dairy	equipment/dairy
Building Type	Other Dwelling	dwelling/other
Building Type	Other Equipment	equipment/other
Building Type	Other Facility	facility/other
Building Type	Fencing	structure/fencing
Building Type	Flats/Units	dwelling/flat
Building Type	Government	facility/gov
Building Type	Holiday House	dwelling/holiday-house
Building Type	Holiday Rental	dwelling/holiday-rental
Building Type	A Primary Place of Residence	dwelling/house
Building Type	Irrigation Pumps	equipment/irrigation
Building Type	Machinery	equipment/machinery
Building Type	Other	other/other
Building Type	Shed/s	structure/shed
Building Type	Shops/Factories	facility/shop
Building Type	Other Structure	structure/other
Building Type	Tank	structure/tank
Building Type	Trailers	vehicle/trailers
Building Type	Other Vehicle	vehicle/other
Damage Level	Damaged - Habitable / Functioning	1
Damage Level	Inaccessible / Non-Functioning	2
Damage Level	Partially Destroyed	3
Damage Level	Totally Destroyed	4
Damage Level	Unknown - Requires Assessment	5
Damage Level	Not Damaged	6
Infrastructure Type	Bridge	bridge
Infrastructure Type	Culvert	culvert
Infrastructure Type	Council Facility	facility
Infrastructure Type	Footpath	footpath
Infrastructure Type	Other	other
Infrastructure Type	Parcel	parcel
Infrastructure Type	Point of Interest	pointofinterest
Infrastructure Type	Council Property	property
Infrastructure Type	Reserve	reserve
Infrastructure Type	Road	road
Infrastructure Type	Road Reserve	road-reserve
Infrastructure Type	Stormwater Pipe	stormwater-pipe
Infrastructure Type	Stormwater Pit	stormwater-pit
Infrastructure Type	Trails/Walkway	trails-walkway