- (OasisLMF/ODS_OpenExposureData#40) - Add ‘locPopulation’ file to the current OED loc file from the current separate input file.
- (OasisLMF/ODS_OpenExposureData#68) (re-opened from v2.3.0)
After the updates to the occupancy codes for common house type such as ‘detached’, ‘semi-detached’, ‘end-terrace’ and ‘bungalow’ (OED occ codes 1070-1073) were released in ODS v2.3.0, an update to the current occupancy code for ‘terraced-housing’ was required to make it more specific to ‘mid-terraced ‘housing.
- (OasisLMF/ODS_OpenExposureData#70) - Removal of building types (linked to OasisLMF/ODS_OpenExposureData#68).
- (OasisLMF/ODS_OpenExposureData#74)- OED to support public infrastructure (transport, utilities and other).
- (OasisLMF/ODS_OpenExposureData#76) - support agriculture in OED.
- (OasisLMF/ODS_OpenExposureData#77) - Extended length of loc user def fields (to 200 characters).
- (OasisLMF/ODS_OpenExposureData#78) - Add OED peril code for off-floodplain.
- (OasisLMF/ODS_OpenExposureData#79) - New OED fields related to vulnerability.
- (OasisLMF/ODS_OpenExposureData#81) - Additions to OED to support off-shore renewable energy.
- (OasisLMF/ODS_OpenExposureData#85) - Additional OED currency and rate of exchange fields.
- (https://github.com/OasisLMF/OpenDataStandards/issues/90) - Additional ORD Exposure summary report
- ( OasisLMF/ODS_OpenExposureData#100) - Small changes to default values and data ranges in OED
- (OasisLMF/ODS_OpenExposureData#109) - Additional account participation field in OED
- (OasisLMF/ODS_OpenExposureData#80) - Add currency conversion capability to ods_tool
- (OasisLMF/ODS_OpenExposureData#82) - Simplify the currency conversion interface
Added missing SoilValue field to OED spec from (OasisLMF/ODS_OpenExposureData#67)
- (OasisLMF/ODS_OpenExposureData#66) - additing data tytpes to the ORD outputs, found here: https://github.com/OasisLMF/OpenDataStandards/blob/develop/OpenResultsData/Docs/ORD_Data_Spec.xlsx
- (OasisLMF/ODS_OpenExposureData#67) - inclusion of soil types for earthquake perils in OED
- (OasisLMF/ODS_OpenExposureData#68) - additonal geogschemes, roofcover types and OED occupancy codes
- (OasisLMF/ODS_OpenExposureData#73) - set unknown columns to dtype categorical
- (OasisLMF/ODS_OpenExposureData#65) - update the wording in the 'OED data spec' to limit the use of geogscheme/geogname to '30'
- Inclusion of OED Liability data schema and docs (https://github.com/OasisLMF/OpenDataStandards/tree/master/OpenExposureData/Liability)
Fixed package issue
missing spec csv in published package
Fix package installation issue OasisLMF/ODS_OpenExposureData#61 - Patched to 2.1.1 to fix but spec remains the same as 2.1.0
- (OasisLMF/ODS_OpenExposureData#53) - new payout type for step policies.
- (OasisLMF/ODS_OpenExposureData#54) - Addition peril codes for volcanic perils.
- (OasisLMF/ODS_OpenExposureData#58) - Additional occupancy and construction codes with descriptions.
- (OasisLMF/ODS_OpenExposureData#56) - Added testing to ods_tools package and generate csv spec from excel file.
- Above issues updated in the data spec .xlsx, associated .rst files and the OED pdf doc.
- Includes the hotfix to the Pypi conversion tool for .csv <> Parquet data formats below:
https://github.com/OasisLMF/OpenDataStandards/tree/develop/src
OED Version 2.0.0
- Updated documentation (rst files, csv, excel and pdf)
- Updated piwind OED (example) files
- Added a separate 'LocPopulation' file to OED - (OasisLMF/ODS_OpenExposureData#40)
- Added 'w3w' as a geogscheme to data spec .xslx to support 'What3Words' - (OasisLMF/ODS_OpenExposureData#39)
- Added 'CondTag' varchar(20) field to loc and acc files (OasisLMF/ODS_OpenExposureData#30)
- Removed 'CondNumber' int field from loc file
- Added 'OEDVersion' varchar(10) field to all four input files - (OasisLMF/ODS_OpenExposureData#33)
- Change 'NumberOfEmployees' int field to 'NumberOfOccupants' int field ion loc file (OasisLMF/ODS_OpenExposureData#40)
- Added 'OccupantPeriod' tiny int field to loc file - (OasisLMF/ODS_OpenExposureData#40)
- Added 'IsAggregate' field - OasisLMF/ODS_OpenExposureData#45
- Increased the amount of 'GeogScheme'/'GeogName' pairs supported in OED - (OasisLMF/ODS_OpenExposureData#51)
- Expanding the supported perils to include subsidence, pandemic, agriculture related perils and cyber - OasisLMF/ODS_OpenExposureData#46
- Changed data type of 'CondNumber' from int to varchar(20) in acc file
- Moved 'RiskLevel' char(3) field to ReinsInfo file (removed from ReinsScope file) - (OasisLMF/ODS_OpenExposureData#21)
- Created a CSV to Parquet conversion tool in Python https://github.com/OasisLMF/OpenDataStandards/tree/develop/src
ORD Version 2.0.0
- Report name changed from Period Average Loss Table (PALT) to Average Loss Table (ALT) - (OasisLMF/ODS_OpenExposureData#36)
- Removed standalone financial perspectives - https://github.com/OasisLMF/OpenDataStandards/issues/37
- Reindexing of EPCalc and EPType as follows;
EPCalc:
1 = Mean Damage Ratio
2 = Full Uncertainty
3 = Per Sample Mean
4 = Sample Mean
EPType:
1 = OEP
2 = OEP TVaR
3 = AEP
4 = AEP TVaR
- Dropped version from ORD spec filename
OED
- Version 2.0.0
- Updated documentation (rst files, csv, excel and pdf)
- Updated piwind oed files
- Added 'w3w' as a geogscheme to data spec .xslx to support 'What3Words' -
(OasisLMF/ODS_OpenExposureData#39)
Location file
- Added CondTag varchar(20) field
- Removed CondNumber int field
- Added OEDVersion varchar(10) field - (OasisLMF/ODS_OpenExposureData#33)
Account file
- Added CondTag varchar(20) field - (OasisLMF/ODS_OpenExposureData#30)
- Changed data type of CondNumber from int to varchar(20)
- Added OEDVersion varchar(10) field
ReinsInfo file
- Added RiskLevel char(3) field (from ReinsScope file) - (OasisLMF/ODS_OpenExposureData#21)
- Added OEDVersion varchar(10) field
ReinsScope file
- Removed RiskLevel char(3) field (moved to ReinsInfo file)
- Added OEDVersion varchar(10) field
ORD
- Version 2.0.0
- Report name changed from Period Average Loss Table (PALT) to Average Loss Table (ALT) - (OasisLMF/ODS_OpenExposureData#36)
- Reindexing of EPCalc and EPType as follows;
EPCalc:
1 = Mean Damage Ratio
2 = Full Uncertainty
3 = Per Sample Mean
4 = Sample Mean
EPType:
1 = OEP
2 = OEP TVaR
3 = AEP
4 = AEP TVaR
- Dropped version from ORD spec filename
- (OasisLMF/ODS_OpenExposureData#23) - Added IFM occupancy codes for specific oil, gas, electric and nuclear risks
- (OasisLMF/ODS_OpenExposureData#27) - Added a occupamcy code for commercial railway buildings
- Updated OpenExposureData_Spec to include new IFM occ codes
- Updated Occupancy Values.csv in schema folder with new IFM occ codes
- (OasisLMF/ODS_OpenExposureData#22) - Updated ranges for FirstFloorHeight and FirstFloorHeightUnit fields
- Made updates to the ODS ReadMe - added Munich Re and QOMPLX logos and mission statement
- Added the 'ODS_2021_Planning_&_Strategy_v1.pdf Doc
- Updated the ORD data spec for v1.1.3 and associated .csv files from latest one supplied by NASDAQ following the Lloyd's Lab project
- Added the ORD_Questions_&_Feedback.rst doc
- Added ODS diagram to the ReadMe file.
- (OasisLMF/ODS_OpenExposureData#2) - Updated area code for Canada from 2 digit codes to two letter codes
- (OasisLMF/ODS_OpenExposureData#4) - Added a field in the loc file for 'StaticMotorVehicle'
- (OasisLMF/ODS_OpenExposureData#18) - Made multiple updates to data ranges in the OED data spec spreadsheet ('OED Input Field' tab)
- (OasisLMF/ODS_OpenExposureData#19) - Update to 'ContentsFloodVuln' to include option 5 for no susceptibility
- (OasisLMF/ODS_OpenExposureData#20) - Added 'CondClass' to the loc file in the OED data spec