Skip to main content

Add Census Tract to PII Site table

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 PII Site table field would be required.

A new location-related field would be added to Claims submissions, such as Census Tract. This would represent a new data-collection requirement and require explicit agreement and governance approval.

New Field

Table: Site PII table

Field name: Census Tract
Required: Y
Data type: 11 characters
Description: The census-defined geographic area of the site. Used by CPUC internally to support geospatial analysis of claims data. (Draft)

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.

Select the module in CEDARS
Status: Completed5 comments

Log in to comment and vote

Comments5

  • Roopa Reddy

    Team•

    May 27

    @cedars team @Amy.reardon@cpuc.ca.gov @Jake Richardson (PG&E) I noticed that the datatype is currently 10 characters long. However, census tract field requires 11 characters - State code (2 chars) + County code (3 chars) + Tract code (6 chars). Thank you.

    • cedars team

      Team•

      May 27

      Thanks Roopa, I’ll update the development ticket.

  • Craig Anderson

    •

    Mar 31

    Is this “Census tract” or “Census track”?

    • cedars team

      Team•

      Mar 31

      It’s Census tract, here’s some very general background on it.

  • Jake Richardson (PG&E)

    Team•

    Mar 18

    I would suggest Census tract as it aligns with the PA’s Demographic data proposal.