EMV CQL (Crisisworks Query Language)
- 1 Suggested CQL
- 1.1 EMV-1 Facilities Damaged
- 1.2 EMV-3 Facilities Destroyed
- 1.3 EMV-5 Bridges damaged
- 1.4 EMV-6 Road Reserves damaged
- 1.5 EMV-8 Roads damaged
- 1.6 EMV-10 Trails/walkways (damaged)
- 1.7 EMV-12 Primary Residences (Damaged)
- 1.8 EMV-13 Primary Residences (Destroyed)
- 1.9 EMV-14 Total Residences (Damaged)
- 1.10 EMV-15 Total Residences (Destroyed)
- 1.11 EMV-16 Loss value (non-building) - Financial loss
- 1.12 EMV-17 Damaged loss value (excl. agriculture)
- 1.13 EMV-18 Destroyed loss count (excl. agriculture)
- 1.14 DHHS Primary Place of residents that are totally damaged
- 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 |
|---|---|---|
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 |