EMV CQL (Crisisworks Query Language)

1 Suggested CQL
2 Reference Lookup Values

Suggested CQL

The following search queries can be pasted into the search box on the relevant datagrid after you select the magnifying glass. NOTE you MUST be in the correct datagrid for the search to work, see the subheading above each query for the correct data-grid to search from.

EMV-1 Facilities Damaged

Infrastructure Assessment

is:active AND infrastructureType.value:[property,facility] AND damageLevel.value:[1,5]

EMV-3 Facilities Destroyed

Infrastructure Assessment

is:active AND infrastructureType.value:[property,facility] AND damageLevel.value:[2,3,4]

EMV-5 Bridges damaged

Infrastructure Assessment

is:active AND infrastructureType.value:[bridge] AND damageLevel.value:[1,2,3,4,5]

Or

EMV-6 Road Reserves damaged

Infrastructure Assessment

Or

EMV-8 Roads damaged

Infrastructure Assessment

EMV-10 Trails/walkways (damaged)

Infrastructure Assessment

EMV-12 Primary Residences (Damaged)

Infrastructure Assessment

EMV-13 Primary Residences (Destroyed)

Private Assets

EMV-14 Total Residences (Damaged)

Private Assets

EMV-15 Total Residences (Destroyed)

Private Assets

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

Private Assets

EMV-17 Damaged loss value (excl. agriculture)

Private Assets

EMV-18 Destroyed loss count (excl. agriculture)

Private Assets

DHHS Primary Place of residents that are totally damaged

Private Assets

Reference Lookup Values

Category	Label	Value

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	dwellling/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	Damaged - Habitable / Functioning	1
Damage	Inaccessible / Non-Functioning	2
Damage	Partially Destroyed	3
Damage	Totally Destroyed	4
Damage	Unknown - Requires Assessment	5
Damage	Not Damaged	6
Damage	SIA request	SIAreq
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