One place to find who qualifies, where, and why
The weekly job geocodes new accounts, checks quality, joins them to DAC tracts, fire threat tiers and parcels, and publishes program lists to CPA's ArcGIS Online. This prototype runs the same logic in your browser on 4,000+ synthetic accounts.
Eligible, not yet enrolled, by jurisdiction
Geocode match quality
What happens every Monday (sample schedule)
- IngestNew and changed accounts from CPA's data warehouse
- GeocodeBatch geocode with match score and type
- QA/QCAutomated checks; exceptions to review queue
- Spatial joinsDAC tract, CES percentile, HFTD tier, jurisdiction, parcel
- Program rulesDAC-GT, CSGT, Power Ready, unserved
- PublishHosted layers, dashboard and CSV lists in ArcGIS Online
- NotifyRun summary emailed to program staff
Map explorer
Toggle layers, click a tract or account, and zoom to any community. The eligibility list holds the same records in table form.
Eligibility lists
The lists program staff get every week, with the reason each account qualifies. Export to CSV or publish to ArcGIS Online.
Rules used in this prototype
- DAC-GT: residential, CARE or FERA, inside an SB 535 disadvantaged community census tract, not already enrolled.
- CSGT: residential, CARE or FERA, in a DAC tract and within 5 miles of a community solar project site (sample sites shown).
- Power Ready: residential in CPUC High Fire Threat District Tier 2 or 3; medical baseline and CARE/FERA customers flagged as priority.
- Unserved: accounts in member jurisdictions that are not currently CPA customers.
Address check
Type any address in the region to see the jurisdiction, DAC status, CalEnviroScreen percentile and fire threat tier. This is the DAC verification-by-address tool from the scope.
RFO site screening
Overlap report for proposed project sites: jurisdiction, DAC status, distance to the nearest DAC, fire threat tier and nearby accounts. Click the map to add your own site.
| Site | Jurisdiction | DAC | Fire tier | Accounts within 1 mi | CARE/FERA within 5 mi |
|---|
Data quality
Every run is checked before anything is published. These are the configured checks (ArcGIS Data Reviewer style) and what they found in this run.
| Check | Severity | Records | What we do |
|---|
How BICS delivers this in CPA's ArcGIS Online
This prototype is plain web code so anyone can open it. The production build lives in CPA's own ArcGIS Online organization, with CPA single sign-on and named-user administration.

Experience Builder
The five Web AppBuilder apps are rebuilt in Experience Builder, starting with an inventory in the first 30 days and the most used app first.

Dashboards and Hub
Program dashboards for staff and a Hub site for public-facing maps such as DAC eligibility lookups.

Automation
Python in ArcGIS Notebooks runs the weekly geocoding, QA/QC and list builds on a schedule, with a run log CPA can read.
Scope coverage
| RFP task | Where it shows up here | Cadence |
|---|---|---|
| Weekly DAC-GT and CSGT geocoded eligibility lists | Eligibility lists, Overview | Weekly |
| Monthly unserved accounts | Eligibility lists: Unserved | Monthly |
| Parcel append | APN on every account; missing APN check | Every 2 months |
| Reference layers: political boundaries, CPUC HFTD, FEMA flood, SCE DRPEP, SCE PSPS | Map explorer (jurisdictions and HFTD shown) | Quarterly |
| DAC verification by address | Address check | On demand |
| RFO overlap report | RFO site screening | Within 10 business days |
| QA/QC with preconfigured checks | Data quality | Every run |
| Hosting, administration, monthly status reports | Run summary and monthly report with each invoice | Monthly |

Who builds it
BI Consulting Services is a Microsoft partner and MBE-certified analytics and application firm in Mooresville, North Carolina. Our founder spent three years inside Duke Energy's GIS organization on the data, analytics and modeling side, and our team writes the Python, data pipelines and dashboards this work depends on.