Abstract: The present invention is a tool including a spatial database and a data warehouse used to track portfolio sites that are affected by weather events, such as hurricanes, earthquakes, wildfires, hail, tornados, or manmade events. A spatial database provides rich spatial geometry features using earth longitude and latitude as a 2-D reference system in spatial system. A insurer portfolio site, which is defined by longitude and latitude data, includes portions that are represented as a point. A weather event is represented as polygon in the spatial database. Based on user configured threshold values, it may be determined when a point falls inside, or on a boundary, of a polygon to identify a site that is affected by that weather event and corresponding reports may be generated, including maps identifying the affected sites and total insured value calculations for the affected sites, in order to gauge risk.

Abstract: The present invention is a tool including a spatial database and a data warehouse used to track portfolio sites that are affected by weather events, such as hurricanes, earthquakes, wildfires, hail, tornados, or manmade events. A spatial database provides rich spatial geometry features using earth longitude and latitude as a 2-D reference system in spatial system. A insurer portfolio site, which is defined by longitude and latitude data, includes portions that are represented as a point. A weather event is represented as polygon in the spatial database. Based on user configured threshold values, it may be determined when a point falls inside, or on a boundary, of a polygon to identify a site that is affected by that weather event and corresponding reports may be generated, including maps identifying the affected sites and total insured value calculations for the affected sites, in order to gauge risk.

Abstract: The present invention is a tool including a spatial database and a data warehouse used to track portfolio sites that are affected by weather events, such as hurricanes, earthquakes, wildfires, hail, tornados, or manmade events. A spatial database provides rich spatial geometry features using earth longitude and latitude as a 2-D reference system in spatial system. A insurer portfolio site, which is defined by longitude and latitude data, includes portions that are represented as a point. A weather event is represented as polygon in the spatial database. Based on user configured threshold values, it may be determined when a point falls inside, or on a boundary, of a polygon to identify a site that is affected by that weather event and corresponding reports may be generated, including maps identifying the affected sites and total insured value calculations for the affected sites, in order to gauge risk.

Abstract: The present invention is a tool including a spatial database and a data warehouse used to track portfolio sites that are affected by weather events, such as hurricanes, earthquakes, wildfires, hail, tornados, or manmade events. A spatial database provides rich spatial geometry features using earth longitude and latitude as a 2-D reference system in spatial system. A insurer portfolio site, which is defined by longitude and latitude data, includes portions that are represented as a point. A weather event is represented as polygon in the spatial database. Based on user configured threshold values, it may be determined when a point falls inside, or on a boundary, of a polygon to identify a site that is affected by that weather event and corresponding reports may be generated, including maps identifying the affected sites and total insured value calculations for the affected sites, in order to gauge risk.

Abstract: The present invention provides a tool to depict the relative impact to the losses of a insurer's portfolio from catastrophic events, such as a hurricanes or earthquakes, at a specific risk level by geographic area using a grid level database and a spatial database to generate maps. The maps developed using this tool help visualize the potentially dangerous areas for writing new business and/or identify preferential places for growth. The tool also creates a list of zip codes with incremental losses at a particular risk level representing the relative attractiveness of writing new policies (or eliminating existing policies) in one zip code versus another. The spatial database provides rich spatial geometry features in the form of raster images available in the spatial database and the invention provides the corresponding spatial algebra to create relativity maps with gradient features and zip code loss information.