Systems and methods for grid-based insurance rating

• US 8,504,393 B2
• Filed: 09/07/2011
• Issued: 08/06/2013
• Est. Priority Date: 09/10/2010
• Status: Active Grant

• Current Assignee: State Farm Mutual Automobile Insurance Company (State Farm)
• Original Assignee: State Farm Mutual Automobile Insurance Company (State Farm)
• Inventors: Stewart, Curt A., Frank, Matthew T., McCormick, Neale E., Baughman, Matthew W., Duvvuri, Ramakrishna
• Primary Examiner(s): Subramanian, Narayanswamy
• Application Number:
  US13/226,785
• Publication Number:
  US 20120066005A1
• Time in Patent Office: 699 Days
• Field of Search: 705/4, 705/35
• US Class Current: 705/4
• CPC Class Codes: G06Q 30/0282 Rating or review of business operators or products
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

A method for rating insurance products using a programmed computer system comprising receiving a coordinate pair including a longitude and a latitude of a location; determining a target coordinate grid block bounded by latitude and longitude lines, wherein the target coordinate grid block encompasses the coordinate pair, querying a database for a target set of existing data associated with the target coordinate grid block, wherein the existing data was associated with the target coordinate grid block prior to receiving the coordinate pair, and calculating a pure premium based at least in part on analyzing the data in the target set.

Claims

1. A method for providing a requested insurance rate using a programmed computer system including a processor and a non-transitory, tangible computer readable medium communicatively coupled to the processor and storing instructions executable by the processor to perform the method comprising:

storing in a database existing data associated with a plurality of coordinate grid blocks, each coordinate grid block comprising a four-sided area defined by truncated latitude and longitude values of a coordinate grid system, wherein the number of digits in the truncated latitude and longitude values that define each coordinate grid block defines the geographic size of that coordinate grid block;

the processor receiving an insurance rate query from a user via a user interface regarding a particular location having a coordinate pair comprising a non-truncated longitude value and a non-truncated latitude value of the particular location;

the processor determining a target coordinate grid that encompasses the coordinate pair by identifying a coordinate grid block having truncated latitude and longitude values that correspond to the non-truncated longitude and latitude values of the coordinate pair of the particular location;

the processor querying a database for a target set of existing data associated with the determined target coordinate grid block, wherein the existing data was associated with the target coordinate grid block prior to receiving the coordinate pair;

the processor querying the database for supplemental existing data associated with coordinate grid blocks proximate the determined target coordinate grid block, including;

setting an index value to an initial value, the index value associated with a first ring of coordinate grid blocks, wherein the current ring of coordinate grid blocks surrounds the target coordinate grid block associated with the coordinate pair;

performing a first query of the database for supplemental existing data associated with the first ring of coordinate grid blocks;

automatically determining that the quantity of the retrieved target set of data and the retrieved supplemental existing data is below a threshold level is below a threshold level, and in response to such determination, incrementing the index value; and

performing a second query of the database to retrieve supplemental existing data associated with a second ring of coordinate grid blocks associated with the incremented index value, the second ring of coordinate grid blocks being larger than the first ring of coordinate grid blocks;

the processor calculating an insurance rate based at least in part on the retrieved target set of existing data and the retrieved supplemental existing data; and

the processor communicating the calculated insurance rate to the user.

2. The method of claim 1 wherein the truncated latitude and longitude values of different coordinate grid blocks of the plurality of coordinate grid blocks are truncated to different numbers of digits, such that different coordinate grid blocks define areas of different geographic sizes.

3. The method of claim 1 wherein the step of calculating the insurance rate implements a rate making formula associated with a geographical area wherein the sole source of variable input to the rate making formula is a plurality of data elements, each data element being associated with one of plurality of coordinate grid blocks including the target coordinate grid block.

4. The method of claim 1 further comprising determining a grid block size based at least in part on one of:

a peril type,

a quantity of experience data associated with the target coordinate grid block, the experience data comprising data regarding previous insurance-related events in the target coordinate grid block,

a population density associated with the coordinate pair, and

a political subdivision associated with the coordinate pair.

5. The method of claim 1 further comprising:

determining an attribute representative of a property at the location indicated by the coordinate pair;

determining a data filter associated with the representative attribute; and

applying the data filter to the target set.

6. The method of claim 1 further comprising, each occurring prior to receiving the coordinate pair:

receiving a data value corresponding to both a first one of the plurality of coordinate grid blocks and a second one of the plurality of coordinate grid blocks;

storing in the database a first record including information relating to the data value and associated with the first grid block; and

storing in the database a second record including information relating to the data value and associated with the second grid block.

7. The method of claim 1 wherein the target set of existing data includes a shared data element that is associated with the target coordinate grid block and at least one other coordinate grid block of the plurality of coordinate grid blocks.

8. A computer system for providing a requested insurance rate comprising:

a processor communicatively coupled to a user interface;

a database communicatively coupled to the processor, the database storing existing data associated with a plurality of coordinate grid blocks, each coordinate grid block comprising a four-sided area defined by truncated latitude and longitude values of a coordinate grid system, wherein the number of digits in the truncated latitude and longitude values that define each coordinate grid block defines the geographic size of that coordinate grid block;

a non-transitory, tangible computer readable memory communicatively coupled to the processor; and

a set of computer readable instructions stored in the non-transitory computer readable memory and when executed by the processor configured to;

receive from a user via the user interface an insurance rate query regarding a particular location a coordinate pair including non-truncated longitude value and a non-truncated latitude value of the particular location;

determine from the plurality of coordinate grid blocks a particular coordinate grid block that is associated with the coordinate pair by identifying a coordinate grid block having truncated latitude and longitude values that correspond to the non-truncated longitude and latitude values of the coordinate pair of the particular location;

query the memory to retrieve particular existing data associated with the particular coordinate grid block;

query the memory for supplemental existing data associated with coordinate grid blocks proximate the particular coordinate grid block, including;

setting an index value to an initial value, the index value associated with a first ring of coordinate grid blocks, wherein the current ring of coordinate grid blocks surrounds the target coordinate grid block associated with the coordinate pair;

performing a first query of the database for supplemental existing data associated with the first ring of coordinate grid blocks;

automatically determining that the quantity of the retrieved particular existing data and the retrieved supplemental existing data is below a threshold level is below a threshold level, and in response to such determination, incrementing the index value; and

performing a second query of the database to retrieve supplemental existing data associated with a second ring of coordinate grid blocks associated with the incremented index value, the second ring of coordinate grid blocks being larger than the first ring of coordinate grid blocks;

calculate an insurance rate based at least in part on the retrieved particular existing data and the retrieved supplemental existing data; and

communicate the calculated insurance rate to the user.