An insurance portfolio can cover properties across many regions while much of its insured value is in a few places. For an underwriting or renewal review, you need to know which places have the most insured value and which properties account for it. The location schedule links that view to the assets being insured. The addresses and values in this list decide what the map can tell you about the portfolio. The review starts with the places each record represents.
| Map measure | Input | Meaning | Additional evidence |
|---|---|---|---|
| Location count | One row per insured location | Number of mapped locations | Record identity and placement checks |
| Insured-value sum | Defined value for each location | Regional exposure amount | Currency, valuation basis and snapshot date |
| Supplied hazard class | Validated classification | Hazard assigned by that source | Source method, coverage and date |
| Supplied modeled loss | Separate model output | Loss estimate under that model | Model assumptions and coverage terms |
Prepare a location-level exposure schedule
Use insured asset locations
Map the address of the property or asset being insured. The address used to bill the policyholder may belong to a head office miles away from the covered building. That address can be useful for managing the account, but it puts the exposure in the wrong region.
Keep a location ID alongside the policy ID. A policy covering several buildings needs several location records if you want to map each building. The location ID lets you identify each building without treating repeated policy IDs as accidental duplicates. It also helps you find the source record when an address needs to be fixed.
Decide what one row means before importing. It might represent a building, a site containing several buildings, or another unit used in your list. Use that same unit throughout the review. If one part of the file has a row per building and another has a row per policy, a marker count mixes different things.
Check records that are missing street details or only a postal code. Those addresses may be enough for a broad regional review. Check them more closely when a boundary or hazard class depends on placing a point in the right spot. Keep records you can’t place in a separate exception list with their IDs and exposure amounts.
Define the amount being totaled
Choose the value field that answers the underwriting or renewal question. State whether it represents gross insured value or another defined amount. Include the currency and the date of the list. If the file contains values in different currencies, convert them on a stated basis before adding them up.
Make the chosen field numeric. Keep currency symbols and notes in separate fields so the amount can be totaled in the same way for every row. Find out why an amount is blank. Replacing it with 0 would say that the location has no value, which may be false.
Watch for a policy total repeated on every location row. Summing that column would count the same amount several times. Use the location values from the approved list, or get an agreed allocation before presenting regional totals. A map can calculate the numbers you give it, but the source needs to say what those numbers belong to.
Record the list’s total exposure and location count before you import it. You’ll use both figures to check the finished regional review. Keep policy count separately when policies can contain more than one location.
Import and inspect the schedule
In Maptive, choose Create New Map, give the map a name and optional description, then select Continue. Upload the spreadsheet or paste the data with its header row. Select Map Now when the file is ready.
Use Data, then Categorize Data to check the location-column matches. Review street, city, state and postal information against the fields in your list. Don’t assume a column with a head office address is the insured-location field simply because its header says Address.
Check a few places against the source, including records near region borders and those with unusually large exposures. A high-value site in the wrong place can change the region’s total more than several small records. Check the point’s popup against its ID, amount and address.
If an imported cell needs correction, open Data, edit the cell and press Enter to save it. Correct the source list as well, or record the change for its owner. Otherwise, the next import can bring the old mistake back.
Other spreadsheet columns can appear in marker popups. Remove personal details and fields the exposure discussion doesn’t need before uploading. The analyst may need a location ID and insured value without needing every piece of information attached to the policy.
Once you’ve checked the points, compare the imported row count with the approved source. Check for missing points and repeated records before you add up the values by region. Record the exposure in records you can’t place so it doesn’t disappear from the review.
Aggregate exposure by region
Open Map Tools and choose Boundary Tool. Select the Boundary Set that matches your reporting geography, such as states or counties. Using the same regions as the portfolio report makes it easier to compare the map with the list.
Choose My Numeric Data. Under Select Function, choose Sum, then select the insured-value column under Fill Data. Select Load Boundaries to draw the regional values.
Sum gives you the total of the selected amounts within each boundary. Use Average when the question concerns average value per source row. Max Value and Min Value answer questions about the largest and smallest recorded values. These functions describe different parts of the portfolio, so keep the function with the measure’s name wherever you present it.
When reviewing value by region, check that each region includes the places you intended. Geometry assigns data based on where you placed the markers. This makes the address checks part of the calculation, rather than a cosmetic step before it.
If your list already has an approved region code, Boundary Settings and Sync Data provide a Data matching option. That matches a selected data column to boundary text. Check the identifiers carefully, including spelling, leading zeros and the boundary type. A code for an internal underwriting region won’t necessarily match a county name.
Choose the matching method that serves the question. Geographic placement asks where the insured locations are. Matching a supplied region field asks how the list has grouped those places. If those answers differ, keep the difference in the review instead of changing the method just to make the totals agree.
Compare the sums for each region with the source total for the same set of records. To check that the figures agree, account for points outside the chosen regions, records you can’t place and any filters you applied. Don’t compare a filtered renewal cohort with the total for the entire book.
Read concentration without confusing the measure
Compare counts with values
Use Marker Count / Location Density in the Boundary Tool for a regional row-count view. With one row per insured location, that count means locations. It means policies only when each row represents a distinct policy.
Read the count alongside the insured-value sum. A region’s share of locations and share of value can differ a lot. That difference helps you identify areas where a small number of records deserve close attention, without calling the area hazardous based on value alone.
Keep the list’s date, value definition and record unit with the comparison of regions. If you report each region’s share of exposure, use the same portfolio total that you checked against the source as the denominator. Changing the denominator between regions would make the shares hard to compare.
Keep amounts you haven’t resolved in that comparison too. A low total for a region is less useful when an unplaced record could change it enough to affect the review.
Inspect categories and high-value areas
Open Map Tools and select Grouping Tool / Colored Pins Tool. Choose a supplied category column, such as coverage type or location type, to create the Primary Group. The white icon beside a group lets you change its marker color and style.
This view helps you see which records make up a region’s total. If a boundary contains several coverage types, the colored markers retain those distinctions. A category boundary fill based on the group with the most markers does not show every category present, so don’t treat one boundary color as a complete description of its contents.
Use Filter Tool when you need to review a specific set of records. Select Create Filters on first use, or the gear for an existing setup, then choose the relevant columns. A Group filter can isolate a coverage category, a Number filter can narrow the value range, and a Date filter can select a renewal period. Check which filters are enabled before interpreting the result.
For a weighted concentration view, open Heat Mapping Tool and choose Represents Numerical Data. Select the numeric exposure field and sample, then Add Heat Map. The selected column must contain only numbers. This view helps you inspect where values cluster; use the boundary sums when you need exact regional totals.
Keep hazard and modeled loss evidence separate
If your review includes hazard classes, import the validated classes as their own columns. Keep the source, date and definition with them. Check whether the hazard class applies to the insured asset’s exact location. Also check whether the source covers the whole portfolio area. A missing class should stay blank until it has been resolved.
Insured value alone does not calculate expected loss. Catastrophe models use hazard, vulnerability, exposure and financial terms. Coverage conditions affect insured losses, and two buildings with similar values may respond differently to the same event. Keep any supplied model results distinct from the exposure sum and identify the model assumptions behind them.
Use the completed Maptive view to choose regions with large shares of exposure for a closer review. Before handing it over, check the selected locations and amounts against the dated schedule. List records you haven’t resolved and identify the separate hazard or modeling evidence needed for the decision. The next analyst should be able to trace a large regional total back to the locations that created it.
