Table of Contents

CPUC Fixed Broadband Deployment by Address

Read Time: 4 mins

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

Companies > name

Inferred via company_id on Account

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

How did we do?

Account Groups: Overview & Example Use Cases

Anchor & Linked Serviceable Addresses: Overview and Best Practices

Contact