Geospatial visualisation of Claims data

Guidehouse has requested the ability to develop geospatial visualisations of claims data to better understand where Program Administrators (PAs) are active and the relative impact of programs across regions. Intended use cases include assessing market support and equity outcomes.

These dashboards would be restricted to CPUC internal use only and would not be public-facing.

To enable this capability, a new Claims field would be required.

New Field (Conceptual)

A new location-related field would be added to Claims submissions, such as:

• Latitude and Longitude of the customer or project site

• Census Track or Census Block

This would represent a new data-collection requirement and require explicit agreement and governance approval.

Key Considerations

• PII and Data Governance

• PA Data Availability. PG&E has indicated they can provide customer-level location data. RENs and CCAs have indicated they do not currently have this information.

• Some programs (e.g., PopNMEC, Home Energy Reports, RCTs) submit aggregated claims and cannot be meaningfully associated with customer-level locations.
  
  

Alternative Approach (Conceptual)

Instead of requiring each Program Administrator to determine and submit latitude/longitude coordinates and census tracts with their claims, CEDARS could centrally generate this information from submitted project addresses.

Under this approach:

• CEDARS would take claim addresses to derive latitude and longitude.

• This would be handled consistently across all claims.

• It would remove the need for individual PAs to calculate, validate, and reconcile geospatial data.

• It would reduce evaluation oversight required to confirm alignment between addresses and reported coordinates.

• It would create a standardized dataset for Energy Division to use in summaries and analysis.

This shifts the responsibility from distributed PA-level reporting.