SPATIAL DATABASE SYSTEM FOR GENERATION OF WEATHER EVENT AND RISK REPORTS

• Main Authors: SAMUEL, SHAJU, ANDALOO, KIRAN, MANGANO, JOHN, ADAMS, BRYAN, SOH, ELIZABETH, MATHAI, SHAJY
• Format: Patent
• Language: English; French; German
• Published: 10.12.2008
• Subjects: CALCULATING; COMPUTING; COUNTING; DATA PROCESSING SYSTEMS OR METHODS, SPECIALLY ADAPTED FORADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORYOR FORECASTING PURPOSES; ELECTRIC DIGITAL DATA PROCESSING; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; MEASURING; METEOROLOGY; PHYSICS; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE,COMMERCIAL, FINANCIAL, MANAGERIAL, SUPERVISORY OR FORECASTINGPURPOSES, NOT OTHERWISE PROVIDED FOR; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS; TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE; TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINSTCLIMATE CHANGE; TESTING

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.