Computer readable medium containing a set of computer readable instructions for grid-based insurance rating
A computer readable medium containing a set of computer readable instructions that when loaded into a computer configure that computer to: receive demographic data, fire station data, or other data associated with a location; receive a coordinate pair including a longitude and latitude of a location; determine a coordinate grid block bounded by latitude and longitude lines, which grid block is associated with the coordinate pair; query a database for a plurality of existing data associated with the coordinate grid block; and determine a rate based at least in part on the plurality of existing data and the demographic data, fire station data, or other data associated with a location.
1. A non-transitory computer readable medium containing a set of computer readable instructions for determining a base rate for a requested hazard insurance policy that when loaded into a computer configure that computer to:
receive demographic data, fire station data, or other risk-assessment data associated with a location associated with the requested hazard insurance policy;
receive a coordinate pair including a longitude and latitude of the location;
determine a coordinate grid block bounded by latitude and longitude lines, which grid block is associated with the coordinate pair and has a size determined at least in part by attributes of the location;
query a database for a first plurality of existing data associated with the coordinate grid block;
automatically determine that the quantity of existing data associated with the coordinate grid block is below a threshold level;
in response to determining that the quantity of existing data associated with the coordinate grid block is below the threshold level, define a current ring of coordinate grid blocks surrounding the coordinate grid block;
query the database for a second plurality of existing data associated with the current ring of coordinate grid blocks;
determine a base rate for the requested hazard insurance policy based at least in part on the first and second pluralities of existing data and the demographic data, fire station data, or other data associated with a location; and
transmit the determined base rate to a user.
2. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , that when loaded into a computer further configure that computer to:
determine a number of latitudinal truncation digits and a number of longitudinal truncation digits defining the size of the coordinate grid block based at least in part on attributes of the location;
determine a longitude query value by truncating the longitude of the coordinate pair based on the number of longitudinal truncation digits;
determine a latitude query value by truncating the latitude of the coordinate pair based on the number of latitudinal truncation digits; and
transmit the longitude query value and latitude query value to the database to query the database.
3. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , that when loaded into a computer further configure that computer,
wherein the step to determine a base rate implements a rate making formula associated with a regulated geographical area subject to regulation of hazard insurance policies wherein the sole source of variable input to the rate making formula is a set of data elements, each of which is associated with one specific coordinate grid block.
4. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , that when loaded into a computer further configure that computer to:
determine a grid block size based at least in part on one of:
a peril type,
a quantity of experience data present in the database and associated with the target coordinate grid block,
a population density associated with the coordinate pair, and
a political subdivision associated with the coordinate pair.
5. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , that when loaded into a computer further configure that computer to:
determine an attribute representative of a property at the location indicated by the coordinate pair;
select one data filter associated with the representative attribute from a plurality of data filters; and
apply the selected one data filter to the first and second pluralities of existing data.
6. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , that when loaded into a computer further configure that computer to, prior to receiving the coordinate pair:
receive a data value that is to be associated with more than one coordinate grid block;
store in the database a first record including information relating to the data value and associated with a first grid block; and
store in the database a second record including information relating to the data value and associated with a second grid block.
7. The non-transitory computer readable medium containing a set of computer readable instructions as claimed in claim 1 , wherein the first plurality of existing data associated with the coordinate grid block includes a shared data element that is associated with more than one coordinate grid blocks.