On-Demand Climate Risk and Resilience Analytics with Automatic Geocoding

AlphaGeo’s On-Demand Climate Risk and Resilience Analytics is a Snowflake-native application delivering predictive climate insights for your investment portfolio. Our platform analyzes any location worldwide—whether at the address, census tract, postal code, county, metropolitan area, or province level—to provide a comprehensive climate risk assessment with resilience-adjusted insights.

Our tool is built for both defensive ESG assessment and proactive investing in resilient geographies, empowering users to evaluate risk, guide adaptation strategies, and optimize asset performance in the face of climate change.

Key Features:

- Instant Geospatial Analysis – Accepts any location or table of real assets from your Snowflake database
- Comprehensive Climate Risk Scores – Assesses overall risk and specific hazard risks (heat, inland flooding, coastal flooding, wind, drought, and fire) across four future time periods (2025, 2035, 2050, and 2100) under three climate scenarios (SSP2-4.5, SSP3-7.0, SSP5-8.5).
- Resilience-Adjusted Risk Metrics – Evaluates local adaptation measures and mitigation factors, offering a more realistic, ground-truth perspective on climate impact.
- Automated Geocoding – Uses Mapbox Geocoding API to add missing latitude and longitude coordinates for any location.
- Enhanced Snowflake Integration – Outputs enriched climate and resilience data directly to your Snowflake database for seamless integration into internal models.

Free Trial & Expanded Access

- Analyze up to 5 locations for free to explore the app’s capabilities.
- Need more? Contact us for bulk analysis and private Snowflake listing access.

Pricing

Please see https://docs.alphageo.ai/pricing for pricing.

The price on this listing is for bulk queries of 10,000 assets per year.

📧 Email: [[e-mail]]<br/>🌍 Visit Us: [https://alphageo.ai](https://alphageo.ai)

<p><br/></p>

Input Table Requirements

The input table in your Snowflake database must include the following columns:

- identifier (STRING, optional): Internal identifier of the asset. Example: US-001.
- address (STRING, required): Street address of the asset. Example: 4510 Main St.
- address_second_line (STRING, optional): Additional address details. Example: Suite 500.
- latitude (FLOAT, optional): Latitude of the asset. Example: 27.9922679.
- longitude (FLOAT, optional): Longitude of the asset. Example: -82.6190901.
- zip_code (STRING, required): ZIP or postal code of the asset. Example: 42911.
- city (STRING, required): City where the asset is located. Example: Tampa.
- state (STRING, required): State or province of the asset. Example: FL.
- country (STRING, required): Country where the asset is located. Example: USA.

<p><br/></p>

Output Table Description

The app generates an output table in your Snowflake database with the following structure:

- identifier: Original identifier of the asset
- address: Address of the asset
- address_second_line: Address Line 2
- city: City of the asset
- zip_code: ZIP or postal code of the asset
- state: State or province of the asset
- country: Country of the asset
- longitude: Longitude of the asset
- latitude: Latitude of the asset
- scenario: Identifier for CMIP6 Emission Scenarios (SSP245, SSP370, and SSP585)
- period: Identifier for time periods (2025, 2035, 2050, and 2100)
- overall_risk_score: Overall climate risk score of the location, on a scale of 0 – 100, calculated from the percentile rank of the sum of all risk indicators (higher score indicates greater risk)
- overall_raj_score: Overall resilience-adjusted risk score of the location, on a scale of 0 – 100, calculated from the percentile rank of the sum of all resilience-adjusted risk indicators (higher score indicates greater risk)
- mean_risk_score: Mean climate risk score of the location, calculated as the average of all risk indicators (higher score indicates greater risk)
- mean_raj_score: Mean resilience-adjusted risk score of the location, calculated as the average of all resilience-adjusted risk scores (higher score indicates greater risk)
- heat_score: Heat risk score, on a scale of 0 – 100, calculated from the increase in the number of local hot days and maximum temperature (higher score indicates greater risk)
- heat_raj_score: Resilience-adjusted heat risk score, on a scale of 0 – 100. This score incorporates the Urban Heat Island effect, as measured by building density and green coverage in a location, into the HEAT_SCORE (higher score indicates greater risk)
- inland_score: Inland flooding risk score, on a scale of 0 – 100, calculated from the increase in storm frequency and volume (higher score indicates greater risk)
- inland_raj_score: Resilience-adjusted inland flooding risk score, on a scale of 0 – 100, calculated by factoring elements of surface porosity, flood control measures and defense infrastructures to the INLAND_SCORE (higher score indicates greater risk)
- coastal_score: Coastal flooding risk score, on a scale of 0 – 100, calculated from mean sea level rise and coastal inundation levels (higher score indicates greater risk)
- coastal_raj_score: Resilience-adjusted coastal flooding risk score, on a scale of 0 – 100. This score incorporates elements of coastal flood control measures and defense infrastructures into the COASTAL_SCORE (higher score indicates greater risk)
- wind_score: Hurricane wind risk score, on a scale of 0 – 100, calculated from the annual frequency and intensity of hurricanes (higher score indicates greater risk)
- wind_raj_score: Resilience-adjusted hurricane wind risk score, on a scale of 0 – 100. This score incorporates the strength of buildings and water control measures in a location into the WIND_SCORE (higher score indicates greater risk)
- drought_score: Drought risk score, on a scale of 0 – 100, calculated from the increase in the number of dry days, hot days, and water demand (higher score indicates greater risk)
- drought_raj_score: Resilience-adjusted drought risk score, on a scale of 0 – 100. This score incorporates the availability and capacity of water works and emergency water supplies into the DROUGHT_SCORE (higher score indicates greater risk)
- fire_score: Wildfire risk score, on a scale of 0 – 100, calculated from the increase in hot days and dry days in vegetated areas (higher score indicates greater risk)
- fire_raj_score: Resilience-adjusted wildfire risk score, on a scale of 0 – 100. This score incorporates the effectiveness of fire monitoring and fire defense infrastructure into the FIRE_SCORE (higher score indicates greater risk)
- result_precision: Precision of results based on the geocoding accuracy
- feedback: Explanation of the result precision
- data_validation: Indicates any validation errors in the provided data
- data_version: AlphaGeo data version
- created_at: Timestamp when the record was created

<p><br/></p>

Workflow

1. Set up the required input table: Ensure your database contains the input table with the required columns mentioned above.
2. Grant permissions: Provide necessary permissions for the app during the installation process to access the input table and create the output table.
3. Configure external access: Allow access to the external_access_reference for geocoding services.
4. Start the analysis: Run the stored procedure to process your data and generate results.<br/>Note: Refer to the "Sample SQL Queries" section for example queries.