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
is:active AND infrastructureType.value:[bridge] NOT damageLevel.value:6
EMV-6 Road Reserves damaged
Infrastructure Assessment
is:active AND infrastructureType.value:[road-reserve] AND damageLevel.value:[1,2,3,4,5]
Or
is:active AND infrastructureType.value:[road-reserve] NOT damageLevel.value:6
EMV-8 Roads damaged
Infrastructure Assessment
is:active AND infrastructureType.value:[road] NOT damageLevel.value:6
EMV-10 Trails/walkways (damaged)
Infrastructure Assessment
is:active AND infrastructureType.value:[road] NOT damageLevel.value:6
EMV-12 Primary Residences (Damaged)
Infrastructure Assessment
is:active AND recoveryCase.status.id:>0 AND buildingType.value:house AND buildingDamage.value:[1,5]
EMV-13 Primary Residences (Destroyed)
Private Assets
is:active AND recoveryCase.status.id:>0 AND buildingType.value:house AND buildingDamage.value:[2,3,4]
EMV-14 Total Residences (Damaged)
Private Assets
is:active AND recoveryCase.status.id:>0 AND buildingType.value:[house,flat,caravan,dwelling-other,holiday-house,holiday-rental] AND buildingDamage.value:[1,5]
EMV-15 Total Residences (Destroyed)
Private Assets
is:active AND recoveryCase.status.id:>0 AND buildingType.value:[house,flat,caravan,dwelling-other,holiday-house,holiday-rental] AND buildingDamage.value:[2,3,4]
EMV-16 Loss value (non-building) - Financial loss
Private Assets
is:active AND recoveryCase.status.id:>0 AND recoveryCase.propertyUseCommercial:true AND buildingType.value:business-economic-impact NOT buildingDamage.value:6
EMV-17 Damaged loss value (excl. agriculture)
Private Assets
is:active AND recoveryCase.status.id:>0 AND recoveryCase.propertyUseCommercial:true AND buildingType.value:[boat,caravan,flat,holiday-rental,facility-other,structure-other,shed,shop] NOT buildingDamage.value:[1,5]
EMV-18 Destroyed loss count (excl. agriculture)
Private Assets
is:active AND recoveryCase.status.id:>0 AND recoveryCase.propertyUseCommercial:true AND buildingType.value:[boat,caravan,flat,holiday-rental,facility-other,structure-other,shed,shop] NOT buildingDamage.value:[2,3,4]
DHHS Primary Place of residents that are totally damaged
Private Assets
status:>0 recoveryCase.status.id:>0 AND buildingType.label:"A Primary Place of Residence" AND (buildingDamage.label:"Totally destroyed" OR buildingDamage.label:"Inaccessible / Non-Functioning") recoveryCase.tags:sia-inspection-completed
Reference Lookup Values
Category | Label | Value |
---|---|---|
Building Type | Bikes | bike |
Building Type | Boats | boat |
Building Type | Business Economic Impact | business-economic-impact |
Building Type | Cars | car |
Building Type | Caravans | caravan |
Building Type | Caravan | caravan |
Building Type | Community Centre(s) | community |
Building Type | Dairy | dairy |
Building Type | Other Dwelling | dwelling-other |
Building Type | Other Equipment | equipment-other |
Building Type | Other Facility | facility-other |
Building Type | Fencing | fencing |
Building Type | Flats/Units | flat |
Building Type | Government | gov |
Building Type | Holiday House | holiday-house |
Building Type | Holiday Rental | holiday-rental |
Building Type | A Primary Place of Residence | house |
Building Type | Irrigation Pumps | irrigation |
Building Type | Machinery | machinery |
Building Type | Other | other |
Building Type | Shed/s | shed |
Building Type | Shops/Factories | shop |
Building Type | Other Structure | structure-other |
Building Type | Tank | tank |
Building Type | Trailers | 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 |