CPUC Fixed Broadband Deployment by Address
Written by Mitchell Ivany
Updated at March 7th, 2025
- Our Products & Services
- Getting Started
- Accounts
- Communication
- Billing
- Companies
- Financial
- Integrations
- Inventory
- Jobs
- Mapping
- Misc.
- Monitoring
- Purchase Orders
- Release Notes
- Sonar Billing
- Voice
- Reporting
- Security
- sonarPay
- Ticketing
- Working With the Sonar Team & Additional Resources
- System
- Networking
As of March 15th, 2022 the California Public Utilities Commission (CPUC) released a public communication announcing that state broadband providers no longer are required to report their subscription data as it relates to census block.
This is significant because in 2021, a change in access to a public API lookup resource made it so Sonar no longer had reasonable means of providing CPUC-formatted Subscription Data reports to our clients.
More information on CPUC's broadband data submission guidelines and templates can be found on their website here.
To accommodate for this recent change, Sonar has made a custom report available for all clients who need to report for CPUC - this report has already been loaded into those Sonar instances and will assist with providing the necessary data. This report can be accessed within your Sonar instance by navigating to Reports (from the left-hand panel), and then clicking on the "CA Broadband Data" report tile.
An overview of the data required for CPUC, along with what data is included in Sonar's report, is provided via the table below.
| Field Name (CSV Column Header) | Description | Type | Example | Sonar Field for Reference | Included in the Custom Report? |
| DBA Name (DBA_Name) | Doing Business As (DBA) Name of your company. In other words, the name of the entity customers could contact to purchase service. | Text | AAA Company |
Inferred via |
Yes |
| FRN (FRN) | Provider FCC Registration Number – search here (ONLY numbers no other characters) | Text | 0008402202 | Not currently stored in Sonar. | No |
| Street Address (Address) | Street Address including House Number, Prefix, Street Name, Street Type and Suffix. No P.O. Boxes! | Text | 123 N Main St |
line1 on Serviceable Address associated with Account |
Yes |
| Unit Number (Unit) | Unit number or letter if applicable. (Optional) | Text | Apt. 1 |
line2 on Serviceable Address associated with Account |
Yes |
| City (City) | City Name | Text | San Francisco |
city on Serviceable Address associated with Account |
Yes |
| State (State) | Abbreviated US State Name | Text | CA |
subdivision on Serviceable Address associated with Account |
Yes |
| Zip Code 5 (Zip5) | 5 Digit Zip Code | Integer | 94102 |
zip on Serviceable Address associated with Account |
Yes (include as-stored in Sonar -- it may need formatting/splitting to “Zip4” column if in excess of 5 digits in length) |
| Zip Code 4 (Zip4) | 4 Digit Zip Code (Optional) | Integer | 1234 | No dedicated field for this. | No |
| Latitude (Latitude) | Latitude coordinate of the subscriber location. It must have at least 6 decimal places. Must be in the WGS84 or NAD83 geographic coordinate system. (value must be within 32 to 42) | Float | 37.780479 |
latitude on Serviceable Address associated with Account |
Yes |
| Longitude (Longitude) | Longitude coordinate of the subscriber location. It must have at least 6 decimal places. Must be in the WGS84 or NAD83 geographic coordinate system. (value must be within -114 to -124) | Float | 122.421017 |
longitude on Serviceable Address associated with Account |
Yes |
| Technology of Transmission (TechCode) | Acceptable codes for this section are: 10 = Asymmetric xDSL 20 = Symmetric xDSL* 30 = Other Copper Wireline (all copper-wire based technologies other than xDSL; Ethernet over copper and T-1 are examples) 40 = Cable Modem 50 = Optical Carrier / Fiber to the end user (Fiber to the home or business end user, does not include “fiber to the curb”) 70 = Terrestrial Fixed Wireless 90 = Electric Power Line 0 = All Other | Integer | 10 |
technology_code from Data Service on Account |
Yes |
| Mass market/Consumer Flag (ConsumerF) | Mass market / consumer broadband service is available in this block (1=Yes; 0=No) | Integer | 1 | Not currently stored in Sonar. | No |
| Maximum Advertised Downstream Bandwidth, Consumer (MaxAdDn) | For mass market / consumer broadband services, the maximum advertised downstream bandwidth available in the Census Block in Mbps. You can enter up to 3 places after the decimal (e.g., 768 kbps would be entered as 0.768). If the field “Consumer” equals 1, there should be a non-zero value in this field. | Float | 7 |
download_speed_kilobits_per_second from Data Service on Account |
Yes (Already converted to Mbps) |
| Maximum Advertised Upstream Bandwidth, Consumer (MaxAdUp) | For mass market / consumer broadband services, the maximum advertised upstream bandwidth that is offered with the above maximum advertised downstream bandwidth available in the Census Block in Mbps. You can enter up to 3 places after the decimal (e.g., 768 kbps would be entered as 0.768). If the field “Consumer” equals 1, there should be a non-zero value in this field. | Float | 1.5 |
upload_speed_kilobits_per_second from Data Service on Account |
Yes (Already converted to Mbps) |
| Business/Government Flag (BusinessF) | Business / enterprise / government broadband service is available in this block (1=Yes; 0=No) | Integer | 1 | Not currently stored in Sonar. | No |