gem / oq-engine

OpenQuake's Engine for Seismic Hazard and Risk Analysis
https://github.com/gem/oq-engine/#openquake-engine
GNU Affero General Public License v3.0
373 stars 272 forks source link

Added a demo with post loss amplification and reinsurance #9787

Closed micheles closed 2 weeks ago

micheles commented 2 weeks ago

Seems to be working out of the box! Part of https://github.com/gem/oq-engine/issues/9633. The aggregate curves look like this:

| rlz_id | return_period | retention      | pla_retention  | claim          | pla_claim      | QuotaShare | pla_QuotaShare | Surplus_1  | pla_Surplus_1 | Surplus_2  | pla_Surplus_2 | Facultative | pla_Facultative | Surplus_West | pla_Surplus_West | WXL_East   | pla_WXL_East | WXL_West    | pla_WXL_West | CatCentral | pla_CatCentral | CatEast    | pla_CatEast | CatWest    | pla_CatWest | CatCountry  | pla_CatCountry | overspill_QuotaShare | pla_over_A    | overspill_Surplus_1 | pla_over_B    | overspill_Surplus_2 | pla_over_C    | overspill_Facultative | pla_over_D    | overspill_Surplus_West | pla_over_E    | overspill_CatCentral | pla_over_H     | overspill_CatEast | pla_over_I     | overspill_CatWest | pla_over_J     | overspill_CatCountry | pla_over_K     |
|--------+---------------+----------------+----------------+----------------+----------------+------------+----------------+------------+---------------+------------+---------------+-------------+-----------------+--------------+------------------+------------+--------------+-------------+--------------+------------+----------------+------------+-------------+------------+-------------+-------------+----------------+----------------------+---------------+---------------------+---------------+---------------------+---------------+-----------------------+---------------+------------------------+---------------+----------------------+----------------+-------------------+----------------+-------------------+----------------+----------------------+----------------|
| 0      | 2.0000        | 0.0            | 0.0            | 0.0            | 0.0            | 0.0        | 0.0            | 0.0        | 0.0           | 0.0        | 0.0           | 0.0         | 0.0             | 0.0          | 0.0              | 0.0        | 0.0          | 0.0         | 0.0          | 0.0        | 0.0            | 0.0        | 0.0         | 0.0        | 0.0         | 0.0         | 0.0            | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 0.0                    | 0.0           | 0.0                  | 0.0            | 0.0               | 0.0            | 0.0               | 0.0            | 0.0                  | 0.0            |
| 0      | 5.0000        | 35_279_000     | 35_279_000     | 235_881_000    | 235_881_000    | 0.0        | 0.0            | 0.0        | 0.0           | 0.0        | 0.0           | 0.0         | 0.0             | 15_495_300   | 15_495_300       | 0.0        | 0.0          | 21_833_300  | 21_833_300   | 0.0        | 0.0            | 0.0        | 0.0         | 0.0        | 0.0         | 0.0         | 0.0            | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 0.0                    | 0.0           | 0.0                  | 0.0            | 0.0               | 0.0            | 0.0               | 0.0            | 0.0                  | 0.0            |
| 0      | 10.0000       | 50_000_000     | 55_000_000     | 697_838_000    | 767_622_000    | 9_339_630  | 10_273_600     | 6_113_370  | 6_724_700     | 2_469_320  | 2_716_260     | 0.0         | 0.0             | 70_000_000   | 77_000_000       | 0.0        | 0.0          | 53_039_000  | 58_342_900   | 4_518_620  | 4_970_480      | 401_990    | 442_188     | 70_000_000 | 77_000_000  | 416_886_000 | 458_575_000    | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 57_555_800             | 63_311_400    | 0.0                  | 0.0            | 0.0               | 0.0            | 107_260_000       | 117_986_000    | 0.0                  | 0.0            |
| 0      | 20.0000       | 476_091_000    | 523_701_000    | 1_188_830_000  | 1_307_710_000  | 50_000_000 | 55_000_000     | 50_000_000 | 55_000_000    | 20_000_000 | 22_000_000    | 5_000_000   | 5_500_000       | 70_000_000   | 77_000_000       | 80_000_000 | 88_000_000   | 90_588_000  | 99_646_800   | 90_000_000 | 99_000_000     | 23_715_800 | 26_087_300  | 70_000_000 | 77_000_000  | 450_000_000 | 495_000_000    | 72_434_700           | 79_678_100    | 40_087_900          | 44_096_700    | 20_604_200          | 22_664_600    | 8_152_440             | 8_967_690     | 203_580_000            | 223_938_000   | 209_391_000          | 230_330_000    | 0.0               | 0.0            | 460_240_000       | 506_265_000    | 426_091_000          | 468_701_000    |
| 0      | 50.0000       | 1_236_890_000  | 1_484_260_000  | 1_983_570_000  | 2_380_290_000  | 50_000_000 | 60_000_000     | 50_000_000 | 60_000_000    | 20_000_000 | 24_000_000    | 5_000_000   | 6_000_000       | 70_000_000   | 84_000_000       | 80_000_000 | 96_000_000   | 98_000_000  | 117_600_000  | 90_000_000 | 108_000_000    | 48_000_000 | 57_600_000  | 70_000_000 | 84_000_000  | 450_000_000 | 540_000_000    | 287_341_000          | 344_809_000   | 195_213_000         | 234_256_000   | 114_638_000         | 137_565_000   | 70_132_700            | 84_159_200    | 394_396_000            | 473_275_000   | 930_042_000          | 1_116_050_000  | 389_900_000       | 467_880_000    | 922_088_000       | 1_106_510_000  | 1_186_890_000        | 1_424_260_000  |
| 0      | 100.0000      | 2_049_310_000  | 2_664_110_000  | 2_809_160_000  | 3_651_900_000  | 50_000_000 | 65_000_000     | 50_000_000 | 65_000_000    | 20_000_000 | 26_000_000    | 5_000_000   | 6_500_000       | 70_000_000   | 91_000_000       | 80_000_000 | 104_000_000  | 98_000_000  | 127_400_000  | 90_000_000 | 117_000_000    | 48_000_000 | 62_400_000  | 70_000_000 | 91_000_000  | 450_000_000 | 585_000_000    | 484_790_000          | 630_227_000   | 319_647_000         | 415_541_000   | 187_102_000         | 243_233_000   | 124_795_000           | 162_233_000   | 604_287_000            | 785_573_000   | 1_610_790_000        | 2_094_030_000  | 818_827_000       | 1_064_480_000  | 1_442_720_000     | 1_875_530_000  | 1_999_310_000        | 2_599_110_000  |
| 0      | 200.0         | 3_082_250_000  | 4_083_980_000  | 3_953_270_000  | 5_238_080_000  | 50_000_000 | 66_250_000     | 50_000_000 | 66_250_000    | 20_000_000 | 26_500_000    | 5_000_000   | 6_625_000       | 70_000_000   | 92_750_000       | 80_000_000 | 106_000_000  | 113_202_000 | 149_993_000  | 90_000_000 | 119_250_000    | 48_000_000 | 63_600_000  | 70_000_000 | 92_750_000  | 450_000_000 | 596_250_000    | 765_836_000          | 1_014_730_000 | 537_983_000         | 712_827_000   | 300_981_000         | 398_800_000   | 207_850_000           | 275_401_000   | 818_194_000            | 1_084_110_000 | 2_529_780_000        | 3_351_960_000  | 1_153_330_000     | 1_528_160_000  | 1_951_550_000     | 2_585_800_000  | 3_032_250_000        | 4_017_730_000  |
| 0      | 500.0         | 4_410_480_000  | 6_174_670_000  | 5_253_280_000  | 7_354_590_000  | 50_000_000 | 70_000_000     | 50_000_000 | 70_000_000    | 20_000_000 | 28_000_000    | 5_000_000   | 7_000_000       | 70_000_000   | 98_000_000       | 80_000_000 | 112_000_000  | 138_944_000 | 194_522_000  | 90_000_000 | 126_000_000    | 48_000_000 | 67_200_000  | 70_000_000 | 98_000_000  | 450_000_000 | 630_000_000    | 1_175_760_000        | 1_646_070_000 | 860_821_000         | 1_205_150_000 | 444_545_000         | 622_363_000   | 466_234_000           | 652_728_000   | 1_188_700_000          | 1_664_180_000 | 3_981_410_000        | 5_573_970_000  | 1_826_350_000     | 2_556_890_000  | 2_877_110_000     | 4_027_960_000  | 4_360_480_000        | 6_104_670_000  |
| 0      | 1000.0        | 6_208_680_000  | 9_313_020_000  | 7_118_700_000  | 10_678_100_000 | 50_000_000 | 75_000_000     | 50_000_000 | 75_000_000    | 20_000_000 | 30_000_000    | 5_000_000   | 7_500_000       | 70_000_000   | 105_000_000      | 80_000_000 | 120_000_000  | 147_000_000 | 220_500_000  | 90_000_000 | 135_000_000    | 48_000_000 | 72_000_000  | 70_000_000 | 105_000_000 | 450_000_000 | 675_000_000    | 1_699_970_000        | 2_549_960_000 | 1_106_240_000       | 1_659_370_000 | 579_746_000         | 869_619_000   | 622_297_000           | 933_446_000   | 1_526_080_000          | 2_289_120_000 | 5_876_210_000        | 8_814_320_000  | 2_815_940_000     | 4_223_920_000  | 3_698_190_000     | 5_547_290_000  | 6_158_680_000        | 9_238_020_000  |
| 0      | 2_000         | 7_843_860_000  | 15_687_700_000 | 8_750_280_000  | 17_500_600_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 2_148_100_000        | 4_296_190_000 | 1_565_580_000       | 3_131_160_000 | 853_859_000         | 1_707_720_000 | 666_762_000           | 1_333_520_000 | 1_780_240_000          | 3_560_480_000 | 7_393_210_000        | 14_786_400_000 | 3_423_040_000     | 6_846_080_000  | 4_366_730_000     | 8_733_450_000  | 7_793_860_000        | 15_587_700_000 |
| 0      | 5_000         | 10_864_000_000 | 21_728_000_000 | 11_866_800_000 | 23_733_700_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 2_623_010_000        | 5_246_010_000 | 1_845_930_000       | 3_691_870_000 | 1_042_310_000       | 2_084_630_000 | 830_488_000           | 1_660_980_000 | 2_151_800_000          | 4_303_590_000 | 8_588_400_000        | 17_176_800_000 | 5_428_560_000     | 10_857_100_000 | 5_262_490_000     | 10_525_000_000 | 10_814_000_000       | 21_628_000_000 |
| 0      | 10_000        | 11_527_900_000 | 23_055_800_000 | 12_515_900_000 | 25_031_700_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 2_705_440_000        | 5_410_880_000 | 1_967_670_000       | 3_935_330_000 | 1_250_600_000       | 2_501_190_000 | 852_076_000           | 1_704_150_000 | 2_583_110_000          | 5_166_220_000 | 9_063_000_000        | 18_126_000_000 | 5_631_950_000     | 11_263_900_000 | 6_340_780_000     | 12_681_600_000 | 11_477_900_000       | 22_955_800_000 |
| 1      | 2.0000        | 0.0            | 0.0            | 0.0            | 0.0            | 0.0        | 0.0            | 0.0        | 0.0           | 0.0        | 0.0           | 0.0         | 0.0             | 0.0          | 0.0              | 0.0        | 0.0          | 0.0         | 0.0          | 0.0        | 0.0            | 0.0        | 0.0         | 0.0        | 0.0         | 0.0         | 0.0            | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 0.0                    | 0.0           | 0.0                  | 0.0            | 0.0               | 0.0            | 0.0               | 0.0            | 0.0                  | 0.0            |
| 1      | 5.0000        | 16_426_000     | 16_426_000     | 212_180_000    | 212_180_000    | 0.0        | 0.0            | 0.0        | 0.0           | 0.0        | 0.0           | 0.0         | 0.0             | 15_991_800   | 15_991_800       | 0.0        | 0.0          | 22_584_100  | 22_584_100   | 0.0        | 0.0            | 0.0        | 0.0         | 0.0        | 0.0         | 0.0         | 0.0            | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 0.0                    | 0.0           | 0.0                  | 0.0            | 0.0               | 0.0            | 0.0               | 0.0            | 0.0                  | 0.0            |
| 1      | 10.0000       | 50_000_000     | 55_000_000     | 648_012_000    | 712_814_000    | 12_772_700 | 14_050_000     | 8_640_180  | 9_504_200     | 3_428_530  | 3_771_380     | 0.0         | 0.0             | 70_000_000   | 77_000_000       | 0.0        | 0.0          | 55_497_300  | 61_047_100   | 8_790_950  | 9_670_050      | 10_737_600 | 11_811_300  | 70_000_000 | 77_000_000  | 357_749_000 | 393_524_000    | 0.0                  | 0.0           | 0.0                 | 0.0           | 0.0                 | 0.0           | 0.0                   | 0.0           | 44_030_100             | 48_433_200    | 0.0                  | 0.0            | 0.0               | 0.0            | 70_403_700        | 77_444_000     | 0.0                  | 0.0            |
| 1      | 20.0000       | 520_580_000    | 572_638_000    | 1_243_310_000  | 1_367_640_000  | 50_000_000 | 55_000_000     | 50_000_000 | 55_000_000    | 20_000_000 | 22_000_000    | 5_000_000   | 5_500_000       | 70_000_000   | 77_000_000       | 80_000_000 | 88_000_000   | 96_974_700  | 106_672_000  | 90_000_000 | 99_000_000     | 48_000_000 | 52_800_000  | 70_000_000 | 77_000_000  | 450_000_000 | 495_000_000    | 79_461_300           | 87_407_400    | 50_252_700          | 55_278_000    | 25_810_500          | 28_391_500    | 12_229_300            | 13_452_300    | 177_889_000            | 195_678_000   | 225_913_000          | 248_505_000    | 17_450_100        | 19_195_200     | 402_301_000       | 442_532_000    | 470_580_000          | 517_638_000    |
| 1      | 50.0000       | 1_611_220_000  | 1_933_460_000  | 2_371_850_000  | 2_846_220_000  | 50_000_000 | 60_000_000     | 50_000_000 | 60_000_000    | 20_000_000 | 24_000_000    | 5_000_000   | 6_000_000       | 70_000_000   | 84_000_000       | 80_000_000 | 96_000_000   | 98_628_000  | 118_354_000  | 90_000_000 | 108_000_000    | 48_000_000 | 57_600_000  | 70_000_000 | 84_000_000  | 450_000_000 | 540_000_000    | 306_884_000          | 368_261_000   | 205_674_000         | 246_809_000   | 120_447_000         | 144_536_000   | 69_038_300            | 82_846_000    | 414_423_000            | 497_308_000   | 1_001_960_000        | 1_202_350_000  | 438_934_000       | 526_721_000    | 964_856_000       | 1_157_830_000  | 1_561_220_000        | 1_873_460_000  |
| 1      | 100.0000      | 2_705_910_000  | 3_517_690_000  | 3_513_250_000  | 4_567_220_000  | 50_000_000 | 65_000_000     | 50_000_000 | 65_000_000    | 20_000_000 | 26_000_000    | 5_000_000   | 6_500_000       | 70_000_000   | 91_000_000       | 80_000_000 | 104_000_000  | 110_224_000 | 143_291_000  | 90_000_000 | 117_000_000    | 48_000_000 | 62_400_000  | 70_000_000 | 91_000_000  | 450_000_000 | 585_000_000    | 614_759_000          | 799_187_000   | 402_699_000         | 523_508_000   | 233_053_000         | 302_969_000   | 127_212_000           | 165_375_000   | 649_849_000            | 844_804_000   | 1_952_670_000        | 2_538_470_000  | 872_288_000       | 1_133_970_000  | 1_556_620_000     | 2_023_610_000  | 2_655_910_000        | 3_452_690_000  |
| 1      | 200.0         | 3_921_360_000  | 5_195_800_000  | 4_817_900_000  | 6_383_710_000  | 50_000_000 | 66_250_000     | 50_000_000 | 66_250_000    | 20_000_000 | 26_500_000    | 5_000_000   | 6_625_000       | 70_000_000   | 92_750_000       | 80_000_000 | 106_000_000  | 147_000_000 | 194_775_000  | 90_000_000 | 119_250_000    | 48_000_000 | 63_600_000  | 70_000_000 | 92_750_000  | 450_000_000 | 596_250_000    | 850_914_000          | 1_127_460_000 | 609_025_000         | 806_958_000   | 363_707_000         | 481_912_000   | 216_154_000           | 286_403_000   | 924_477_000            | 1_224_930_000 | 2_933_970_000        | 3_887_500_000  | 1_377_350_000     | 1_824_980_000  | 2_243_190_000     | 2_972_230_000  | 3_871_360_000        | 5_129_550_000  |
| 1      | 500.0         | 5_704_030_000  | 7_985_640_000  | 6_606_420_000  | 9_248_980_000  | 50_000_000 | 70_000_000     | 50_000_000 | 70_000_000    | 20_000_000 | 28_000_000    | 5_000_000   | 7_000_000       | 70_000_000   | 98_000_000       | 80_000_000 | 112_000_000  | 147_000_000 | 205_800_000  | 90_000_000 | 126_000_000    | 48_000_000 | 67_200_000  | 70_000_000 | 98_000_000  | 450_000_000 | 630_000_000    | 1_314_350_000        | 1_840_080_000 | 961_853_000         | 1_346_590_000 | 524_014_000         | 733_620_000   | 358_136_000           | 501_391_000   | 1_349_750_000          | 1_889_640_000 | 4_426_630_000        | 6_197_280_000  | 2_380_690_000     | 3_332_970_000  | 3_306_360_000     | 4_628_910_000  | 5_654_030_000        | 7_915_640_000  |
| 1      | 1000.0        | 7_111_580_000  | 10_667_400_000 | 8_112_230_000  | 12_168_300_000 | 50_000_000 | 75_000_000     | 50_000_000 | 75_000_000    | 20_000_000 | 30_000_000    | 5_000_000   | 7_500_000       | 70_000_000   | 105_000_000      | 80_000_000 | 120_000_000  | 147_000_000 | 220_500_000  | 90_000_000 | 135_000_000    | 48_000_000 | 72_000_000  | 70_000_000 | 105_000_000 | 450_000_000 | 675_000_000    | 1_658_970_000        | 2_488_460_000 | 1_208_400_000       | 1_812_600_000 | 678_945_000         | 1_018_420_000 | 479_764_000           | 719_647_000   | 1_632_060_000          | 2_448_100_000 | 5_610_440_000        | 8_415_650_000  | 2_781_720_000     | 4_172_580_000  | 3_970_710_000     | 5_956_070_000  | 7_061_580_000        | 10_592_400_000 |
| 1      | 2_000         | 9_722_560_000  | 19_445_100_000 | 10_753_600_000 | 21_507_100_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 2_247_800_000        | 4_495_600_000 | 1_520_680_000       | 3_041_360_000 | 810_134_000         | 1_620_270_000 | 583_082_000           | 1_166_160_000 | 1_870_290_000          | 3_740_590_000 | 7_073_620_000        | 14_147_200_000 | 3_758_130_000     | 7_516_260_000  | 4_561_000_000     | 9_122_000_000  | 9_672_560_000        | 19_345_100_000 |
| 1      | 5_000         | 10_262_300_000 | 20_524_700_000 | 11_244_300_000 | 22_488_700_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 2_960_520_000        | 5_921_050_000 | 1_922_770_000       | 3_845_550_000 | 1_133_520_000       | 2_267_030_000 | 801_519_000           | 1_603_040_000 | 2_272_130_000          | 4_544_260_000 | 9_425_160_000        | 18_850_300_000 | 4_314_300_000     | 8_628_590_000  | 5_563_330_000     | 11_126_700_000 | 10_212_300_000       | 20_424_700_000 |
| 1      | 10_000        | 10_332_200_000 | 20_664_300_000 | 11_363_200_000 | 22_726_300_000 | 50_000_000 | 100_000_000    | 50_000_000 | 100_000_000   | 20_000_000 | 40_000_000    | 5_000_000   | 10_000_000      | 70_000_000   | 140_000_000      | 80_000_000 | 160_000_000  | 147_000_000 | 294_000_000  | 90_000_000 | 180_000_000    | 48_000_000 | 96_000_000  | 70_000_000 | 140_000_000 | 450_000_000 | 900_000_000    | 3_085_540_000        | 6_171_080_000 | 1_955_980_000       | 3_911_950_000 | 1_257_780_000       | 2_515_550_000 | 896_935_000           | 1_793_870_000 | 2_951_990_000          | 5_903_990_000 | 9_426_280_000        | 18_852_600_000 | 4_741_460_000     | 9_482_910_000  | 7_262_980_000     | 14_526_000_000 | 10_282_200_000       | 20_564_300_000 |