Introduction
HazardHub is a third-generation provider of property-level hazard risk databases. Their team translates voluminous geospatial digital data into easy-to-understand answers, providing risk assessments that can be used to make real-world decisions.
HazardHub data is obtained during the quoting process and can be used to calculate the rate. It can be shown to agents, underwriters or both.
Prerequisites
- Obtain the API key, base URL, and endpoint from Hazard Hub: api.hazardhub.com
- Review the data dictionary of all available data points: Hazard Hub Data Dictionary
- Determine which data points (if any) you want configured as supplemental questions.
- Determine which data points (if any) you want configured as rating categories.
- Determine if you want any underwriting rules related to the new supplemental questions/rating categories.
Configuration Steps
To configure the HazardHub integration, navigate to Settings > Vendors and check the box next to HazardHub. Click the pencil icon to configure the setup. The HazardHub connection requires certain details to establish the connection. Within the dialog pop-up box enter the following details:
- Input the API key, the base URL and details on the endpoint to connect to, as provided by the vendor. Usually, the base URL is https://api.hazardhub.com/v1 and the endpoint is risks_and_enhanced_property2 or risks_and_enhanced_property2_and_replacement_cost_data.
- Configure the four settings as desired:
-
- Enable API caching. If enabled, BriteCore will verify that HazardHub data was not acquired within the last 14 days before calling the vendor to save on extraneous vendor costs. If the property address changes in any way, BriteCore will assume that the property is different and will not use the cached data.
- Trigger on rate and save. If enabled, HazardHub data will be acquired when an agent clicks Rate and Save. It is recommended that caching be enabled if this option is set to minimize costs of multiple data pulls when agents test different coverage scenarios.
- Disable property interface. If enabled, hides the HazardHub Data from the Risk (Property) tab for all users (agents and underwriters).
- Disable property interface only for agents. If enabled, hides the HazardHub Data section from the Risk (Property) tab for agents.
-
- Configure the Mapping Settings by clicking the Mapping Settings link. This section contains the Rating Mappings and Supplemental Mappings tables. Rating Mappings is where you should map data to rating categories (map from each HazardHub Mapping/HazardHub Value pair to BriteCore Mapping/BriteCore Value pair) and Supplemental Mappings is where you should map data points to supplemental questions (map from each HazardHub Mapping item to BriteCore Label). Mappings are required only if the data should be passed to categories or supplemental questions. If using the HazardHub data in rating evaluations only, use of the mappings is not required.
-
- Rating Mappings. The Rating Mappings table is configured as follows:
-
- HazardHub Mapping. Maps from the JSON path of the returned result from the HazardHub API. Note: it is very likely that this path will be repeated for multiple values as demonstrated in the example below.
- HazardHub Value. Possible values for each of the JSON items. This field can also contain certain keywords to trigger format translation in the mapping process. Refer to the Translators section, below.
- BriteCore Mapping. Maps to the BriteCore category of the HazardHub line item. As with the HazardHub Mapping, it is very likely that the category will be repeated for multiple values.
- BriteCore Value. The category values that each HazardHub value should map to in BriteCore. Use an asterisk (‘*’) when a Translator is used in the HazardHub Value.
-
- Supplemental Mappings.
-
- HazardHub Mapping. Maps from the JSON path of the returned result from the HazardHub API.
- BriteCore Label. Maps the HazardHub Mapping data to the BriteCore supplemental questions. The value entered in the BriteCore Mapping will be the supplemental question name.
-
- Rating Mappings. The Rating Mappings table is configured as follows:
-
- Click Save to close the mapping settings, then Done to save the HazardHub configuration pop-up screen.
Translators
BriteCore supports format translators for the values provided by HazardHub. Translator keywords are case sensitive.
- ‘capitalize’ - Capitalizes the first letter of the string
- ‘upper’ - Makes returned value uppercase
- ‘lower’ - Makes returned value lowercase
- ‘ucfirst’ - Capitalizes the first letter of each word
- ‘string’ - Converts response to a string value
- ‘integer’ Used for integer response
- ‘numeric’ - Used for decimal responses
- ‘anything’ - Performs no transformation
Note: ’integer’ and ‘numeric’ translators do not enforce a value type. If used on a string, the output will remain a string. Instead, these translators are useful to create simple pass-throughs for numeric values such as year numbers.
Here is an example of a mapping assuming the risks_and_enhanced_property2 endpoint:
HazardHub Mapping | HazardHub Value | BriteCore Mapping | BriteCore Value |
risks.aais_fire_protection_class_params.class | P1 | Protection Class | 1 |
risks.aais_fire_protection_class_params.class | P2 | Protection Class | 2 |
risks.aais_fire_protection_class_params.class | P3 | Protection Class | 3 |
risks.aais_fire_protection_class_params.class | P4 | Protection Class | 4 |
risks.aais_fire_protection_class_params.class | P5 | Protection Class | 5 |
risks.aais_fire_protection_class_params.class | P6 | Protection Class | 6 |
risks.aais_fire_protection_class_params.class | P7 | Protection Class | 7 |
risks.aais_fire_protection_class_params.class | P8 | Protection Class | 8 |
risks.aais_fire_protection_class_params.class | P9 | Protection Class | 9 |
risks.aais_fire_protection_class_params.class | P10 | Protection Class | 10 |
enhanced_property.assessment.No_of_Stories | 2 story with basement | Number of Floors | 2 |
enhanced_property.assessment.Year_Built | integer | Year Built | * |
enhanced_property.assessment.No_of_Stories | 1 story with basement | Number of Floors | 1/unknown |
enhanced_property.replacement_cost_data.construction_type | Framing, Wood | Construction Type | Wood Frame |
enhanced_property.replacement_cost_data.construction_type | Framing,Wood | Construction Type | Wood Frame |
enhanced_property.assessment.Type_Construction | Frame | Construction Type | Wood Frame |
enhanced_property.assessment.No_of_Stories | 3 | Number of Floors | 3+ |
enhanced_property.assessment.No_of_Stories | 4 | Number of Floors | 3+ |
risks.enhanced_wildfire.score | upper | Wildfire Category | * |
enhanced_property.mls_listing_record_details.ex_roof_features | Asphalt | Roof Type | Asphalt |
enhanced_property.mls_listing_record_details.ex_roof_features | Event Rated | Roof Type | Asphalt Event Rated |
enhanced_property.mls_listing_record_details.ex_roof_features | Copper | Roof Type | Copper |
enhanced_property.mls_listing_record_details.ex_roof_features | Fiberglass | Roof Type | Fiberglass Shingle |
enhanced_property.mls_listing_record_details.ex_roof_features | Shingle | Roof Type | Fiberglass Shingle |
enhanced_property.mls_listing_record_details.ex_roof_features | Metal | Roof Type | Metal Decking |
enhanced_property.mls_listing_record_details.ex_roof_features | Steel | Roof Type | Metal Decking |
enhanced_property.mls_listing_record_details.ex_roof_features | Tin | Roof Type | Metal Decking |
enhanced_property.mls_listing_record_details.ex_roof_features | Built | Roof Type | Other |
enhanced_property.mls_listing_record_details.ex_roof_features | Concrete | Roof Type | Other |
enhanced_property.mls_listing_record_details.ex_roof_features | Flat | Roof Type | Other |
enhanced_property.mls_listing_record_details.ex_roof_features | Rubber | Roof Type | Other |
enhanced_property.mls_listing_record_details.ex_roof_features | Modified | Roof Type | Other |
enhanced_property.mls_listing_record_details.ex_roof_features | Tar | Roof Type | Tar and Gravel |
enhanced_property.mls_listing_record_details.ex_roof_features | Gravel | Roof Type | Tar and Gravel |
enhanced_property.mls_listing_record_details.ex_roof_features | Slate | Roof Type | Tile |
enhanced_property.mls_listing_record_details.ex_roof_features | Stone | Roof Type | Tile |
enhanced_property.mls_listing_record_details.ex_roof_features | Clay | Roof Type | Tile |
enhanced_property.mls_listing_record_details.ex_roof_features | Tile | Roof Type | Tile |
enhanced_property.mls_listing_record_details.ex_roof_features | Green | Roof Type | Vegetative Roof |
enhanced_property.mls_listing_record_details.ex_roof_features | Garden | Roof Type | Vegetative Roof |
enhanced_property.mls_listing_record_details.ex_roof_features | Vege | Roof Type | Vegetative Roof |
enhanced_property.mls_listing_record_details.ex_roof_features | Shakes | Roof Type | Wood Shakes |
enhanced_property.mls_listing_record_details.ex_roof_features | Wood | Roof Type | Wood Shakes |
enhanced_property.mls_listing_record_details.if_cooling_yn | yes | HH If Cooling Yn | Yes |
enhanced_property.mls_listing_record_details.if_cooling_yn | no | HH If Cooling Yn | No |
enhanced_property.mls_listing_record_details.if_fireplace_yn | yes | Solid Fuel Burning Appliance in Residence | Yes |
enhanced_property.mls_listing_record_details.if_fireplace_yn | no | Solid Fuel Burning Appliance in Residence | No |
Here is a brief example of Supplemental Mappings assuming the risks_and_enhanced_property2 endpoint:
HazardHub Mapping |
BriteCore Label |
risks.address |
risks.address |
risks.wildfire.score |
risks.wildfire.score |
risks.wildfire.text |
risks.wildfire.text |
risks.wildfire_description.value |
risks.wildfire_description.value |
risks.wildfire_risk_score.value |
risks.wildfire_risk_score.value |
risks.wildfire_risk_score.composite |
risks.wildfire_risk_score.composite |
risks.wildfire_risk.value |
risks.wildfire_risk.value |
risks.wildfire_distance_to_high_area |
risks.wildfire_distance_to_high_area |
risks.wildfire_housing_density.value |
risks.wildfire_housing_density.value |