Gauge Risk Maps allows users the ability to manually upload a set of locations to view them on the map and export the locations with the corresponding peril risk scores. This feature can be used by both users that have their exposure data stored in the Gauge Database or those users that do not have their exposure data stored in the Gauge Database.
In this section, we'll discuss how to manually upload a set of locations and export the available peril risk scores.
You first must prepare a .csv file of the locations you would like to upload. Your file must contain a column for Latitude, Longitude, and a unique identifier for each location.
Note: Users can currently manually upload a maximum of 25,000 rows at one time
An example of the file format is provided below:
The above is just an example. If you need any assistance with preparing this file, please contact your assigned Athenium Analytics Account Manager.
Uploading Location Data
When you log in to Gauge, Underwriting is the default page that displays when the product is launched.
To access Risk Maps, select the down arrow next the word Underwriting in the header. This will provide a list of the other sub-products available. In this case, you will select Risk Maps.
Once the Risk Maps screen loads, select the blue EXPOSURES box at the bottom left of the page.
Select the Manual Location Upload menu option.
If your company has their exposure data stored in the Gauge Database, the default menu option will be My Insured Locations.
Select SELECT FILE and navigate to the location of where you have saved your prepared .csv file and double click on the file to select it.
When the file is selected, you will be prompted to choose which fields from your file will represent the following values:
- Header
- Subheader
- Body
- Latitude
- Longitude
- Unique Identifier
Once you have selected all fields, select DONE.
Using the example format provided above, the following selections were made:
Once you upload your locations and select DONE, your exposures will be uploaded and viewable as blue dots across the Risk Maps
The locations that you upload are not currently stored in the Gauge Database, so you will need to re-upload these locations in the future if you wish to view them on the map and/or export the peril risk score report. Also, if you do have exposures stored in the Gauge Database, they will not appear along side of the exposures that were uploaded. At this time, the two data sets are separate.
If you would like to learn about how you can store your exposures within the Gauge Database, please contact your Athenium Analytics Account Manager.
When you hover your mouse over the blue dots, the exposure details of your upload will display.
Using your mouse, click on one of the blue dots to view the exposure detail.
Export Exposures and Risk Scores
To export exposures along with the peril risk scores, select the Export Exposures icon after your exposures have been plotted on the map.
Once selecting the Export Exposures icon, the Export Exposures menu box will display.
All the available perils that your company has been set up to access will be available to select from.
You can choose to export all available perils, or select individual perils.
Click on the Un-Select All option and select the perils you would like to include in your export.
If you have access to the Gauge Earthquake Peril, earthquake risk scores are currently only available in the following states:
- AR - Arkansas
- IL - Illinois
- IN - Indiana
- IA - Iowa
- KY - Kentucky
- MO - Missouri
- OH - Ohio
- OK - Oklahoma
- TN - Tennessee
Once you have selected the perils you want to include in the export, click on EXPORT SPREADSHEET in the lower right hand corner of the EXPORT EXPOSURES menu box.
After selecting EXPORT SPREADSHEET, the menu box will disappear.
After a few moments, you should receive a confirmation message that your file will be emailed to you when it is ready.
Select OK to close this message.
The timing of receipt of your report will depend on the amount of exposure data contained in the report.
When your report is ready, you will receive an email from Athenium Analytics with a link to click on to download your Gauge Risk export request.
Click on the link to download your report. Once opened, you can save to your desired location.
The report will contain all exposures identified in the area selected, along with the peril risk scores.
0 Comments
Add your comment