# Commercial Climate Risk Score Comparison: Property-Level Wildfire Risk in California and Flood Risk in New York from Jupiter Intelligence and XDI (CarbonPlan)

## Facts

- Provider: CarbonPlan, with data from Jupiter Intelligence and XDI
- License: CC-BY-4.0 (https://github.com/carbonplan/climate-risk-comparison)
- Format: CSV (in sampled files)
- Stored at: Amazon S3, s3://carbonplan-climate-impacts/climate-risk-comparison/companies (us-west-2)
- Access: public, readable without an account
- Category: Climate & Weather
- Source: https://github.com/carbonplan/climate-risk-comparison
- Page: https://scigantic.com/archive/13c6beda-8914-5637-ad94-18254fdb4c9d
- Keywords: Climate & Weather, CSV, AWS Open Data

## About

Property-level climate risk scores that two commercial climate analytics providers, Jupiter Intelligence and XDI (Cross Dependency Initiative), produced for the same sets of locations at CarbonPlan's written request, released so their fire and flood risk estimates can be compared independently. The data/ folder holds four files: Jupiter's wildfire risk for California locations (CA-Fire-for-CarbonPlan-Input_..._20240502.csv), Jupiter's flood risk for New York locations (NY-Flood-..._20240502.csv), and XDI's results for the same California and New York locations (californiainput_merged.xlsx, NYinput_merged.xlsx). The methods/ folder holds documentation the companies shared, including Jupiter's flood and wildfire technical methodology overview and ClimateScore Global v3.1 schema, and an XDI sample residential mortgage report. Locations cover case studies in California, New York City and New York State. CarbonPlan used the files to show how much risk scores from different vendors disagree for the same buildings, which matters for insurance, mortgage lending, disclosure and climate adaptation decisions. Read the CSVs with pandas and the spreadsheets with pandas.read_excel or openpyxl; the notebooks in the carbonplan/climate-risk-comparison repository reproduce the comparison. License: CC BY 4.0, published by CarbonPlan with the companies' permission. Cite CarbonPlan, Climate risk comparison (carbonplan.org/research/climate-risk-comparison).

## Load the data

```python
import boto3
from botocore import UNSIGNED
from botocore.client import Config
s3 = boto3.client('s3', region_name='us-west-2', config=Config(signature_version=UNSIGNED))
s3.list_objects_v2(Bucket='carbonplan-climate-impacts', Prefix='climate-risk-comparison/companies/', Delimiter='/')
```

Lists the files with anonymous access. Runs on any machine, with no cloud account.

## Data structure

File types in sampled files: CSV

Example file: `climate-risk-comparison/companies/data/`

## Open it

- In a hosted notebook with the data mounted: https://scigantic.com/archive/13c6beda-8914-5637-ad94-18254fdb4c9d
- Full record as JSON (schema card included): https://api.scigantic.com/api/archives/13c6beda-8914-5637-ad94-18254fdb4c9d
- Over MCP: `get_schema_card` with id `13c6beda-8914-5637-ad94-18254fdb4c9d` at https://api.scigantic.com/mcp

## Related topics

- [CSV datasets](https://scigantic.com/topics/csv)
- [Climate & Weather datasets](https://scigantic.com/topics/climate-and-weather)
