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
Log in to comment and vote
Comments5
Roopa Reddy
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
May 27
Thanks Roopa, I’ll update the development ticket.
Craig Anderson
Mar 31
Is this “Census tract” or “Census track”?
cedars team
Mar 31
It’s Census tract, here’s some very general background on it.
Jake Richardson (PG&E)
Mar 18
I would suggest Census tract as it aligns with the PA’s Demographic data proposal.