FCC/FCC_Official_BSL_BDC_Service_Status

View In: ArcGIS JavaScript ArcGIS Online Map Viewer ArcGIS Earth ArcGIS Pro

Service Description: This is a composite layer that joins together the following datasets: <div><ul><li>All Broadband Serviceable Locations (BSLs) in New Mexico as of the FCC National Broadband Map Fabric released on <b><u>12/31/2023</u></b> (<u><b>version 4</b></u>). For more information visit <a href='https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-' target='_blank' rel='nofollow ugc noopener noreferrer'>https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-</a></li><li>The best-available provider availability data and BDC availability status released<u><b> 5/28/2024 as-of 12/31/2023</b></u> (<u><b>version 4</b>)</u>. BDC datasets can be downloaded <a href='https://broadbandmap.fcc.gov/data-download/nationwide-data' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a>.</li></ul><div><font size='4'><b>Details</b></font></div></div><div><br /></div><div><div><font size='3'>Update Frequency – Data is updated approximately every 6 months, as new versions of the FCC BSL/NoBSL fabric and Broadband Data Collection (BDC) Provider information are released (usually at the end-of-year and mid-year)</font></div><div><font size='3'><br /></font></div><div><font size='3'>This dataset is hosted in an OBAE-hosted SQL Server, published via a local ArcGIS Enterprise Instance, that is shared with ArcGIS Online via an ArcGIS Enterprise “Collaboration” Data Custodian: Kevin Hoffman (kevin.hoffman.contractor@doit.nm.gov)</font></div><div><font size='3'><br /></font></div><div><font size='4'><b>Access Use Constraints</b></font></div><div><font size='4'><b><br /></b></font></div><div><font size='3'>Data is not intended for editing; updates to this dataset will be made internally by OBAE staff.</font><br /></div><div><font size='3'><br /></font></div><div><font size='3'>Data is intended for the general public.<br /></font></div><div><font size='3'><br /></font></div><div><font size='4'><b>Methodology</b></font></div><div><font size='4'><br /></font></div><div><font size='3'>FCC BSL/NoBSL data is downloaded in CSV format. The CSVs are merged into a single table and converted to spatial data using the latitude/longitude values within. Each row in this merged table represents a single BSL/NoBSL location.</font><br /></div><div><font size='3'><br /></font></div><div><font size='3'>BDC Provider Service Availability data is downloaded one technology type at a time in CSV format. Each entry in the BDC Provider Service Availability dataset corresponds to a single BSL or NoBSL location (joined using the location_id attribute). These individual tables are then merged into a single table. To determine the best-available technology at a given location (as there may be multiple technology types available at a single location), each BDC entry was ranked based on the technology type:<br /></font></div><div><ul><li><font size='3'>Copper Wire, rank of 1</font></li><li><font size='3'>Licensed Terrestrial Fixed Wireless, rank of 2</font></li><li><font size='3'>Licensed-by-Rule Terrestrial Fixed Wireless, rank of 2</font></li><li><font size='3'>Coaxial Cable / HFC, rank of 3</font></li><li><font size='3'>Optical Carrier Fiber to Premises, rank of 4</font></li></ul><div><font size='3'>BDC technology service availability is also ranked as Served/Underserved/Unserved based on the following criteria (</font><span style='color:black;'><font size='3'>BDC technology service availability is also ranked as Served/Underserved/Unserved based on the following criteria</font></span><span style='color:black; font-size:13.5pt;'> (</span><a href='https://broadbandusa.ntia.doc.gov/sites/default/files/2022-09/BEAD-Frequently-Asked-Questions-%28FAQs%29_Version-2.0.pdf' target='_blank' rel='nofollow ugc noopener noreferrer'>https://broadbandusa.ntia.doc.gov/sites/default/files/2022-09/BEAD-Frequently-Asked-Questions-%28FAQs%29_Version-2.0.pdf</a><span style='color:black; font-size:13.5pt;'>, </span><span style='color:black;'><font size='3'>also available </font></span><a href='https://nm-community.maps.arcgis.com/home/item.html?id=5f47e138e8194bb1aa1562f9886315ed' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a><span style='color:black; font-size:13.5pt;'>):</span></div></div></div><div><ul><li><font color='#000000' size='3'><b>Unserved </b>locations either have no access to broadband service or lack access to "(i) a speed of not less than 25 Mbps for downloads; and (ii) a speed of not less than 3 Mbps for uploads"</font><br /></li><li><font color='#000000' size='3'><b>Underserved </b>locations lack access to "(i) a speed of not less than 100 Mbps for downloads; and (ii) a speed of not less than 20 Mbps for uploads<br /></font></li><li><font color='#000000' size='3'><b>Served </b>locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)<br /></font></li></ul><div><font color='#000000' size='3'>Once these rankings are tagged to rows in the merged BDC Technology table, the records are loaded into a database and a database-view is created to discern the best-available technology at a given location based [first] on the service availability (Served, Underserved, Unserved). This is the composition of that database-view:<br /></font></div></div><div><font color='#000000' size='3'><br /></font></div><div><font color='#000000'><div style='font-size:small;'>SELECT * </div><div style='font-size:small;'>FROM (</div><div style='font-size:small;'>SELECT a.frn, a.provider_id, a.brand_name, a.location_id, a.technology,</div><div style='font-size:small;'>a.max_advertised_download_speed, a.max_advertised_upload_speed,</div><div style='font-size:small;'>a.low_latency, a.business_residential_code, a.id_for_rank, </div><div style='font-size:small;'>a.service_level,</div><div style='font-size:small;'>a.tech_level,</div><div style='font-size:small;'>rank() OVER (</div><div style='font-size:small;'> PARTITION BY a.location_id </div><div style='font-size:small;'> ORDER BY</div><div style='font-size:small;'> a.service_level DESC,</div><div style='font-size:small;'> a.tech_level DESC,</div><div style='font-size:small;'> a.max_advertised_download_speed DESC,</div><div style='font-size:small;'> a.max_advertised_upload_speed DESC,</div><div style='font-size:small;'> a.id_for_rank ASC</div><div style='font-size:small;'> ) AS rank</div><div style='font-size:small;'>FROM </div><div style='font-size:small;'> <BDC_TECH_TABLE_MERGED> </div><div style='font-size:small;'>) b </div><div style='font-size:small;'>WHERE b.rank = 1;</div><div style='font-size:small;'><br /></div><div><font size='3'>Using this database-view, the best-available technology data for a given location is joined to the BSL/NoBSL fabric based on a shared location_id.</font><br /></div><div><br /></div><div><b>For BSL locations that do not have corresponding BDC Technology information</b>, these points are set to "Unserved", as no provider has claimed service for this location (given the corresponding BDC dataset is released 6 months after the BSL/NoBSL fabric release, it is assumed provider's have had sufficient time to claim service for these locations).<br /></div><div><br /></div><div><b>For NoBSL locations that do not have corresponding BDC Technology information</b>, it is assumed that many bsl_flag=false (aka NoBSL) locations will not subscribe to Mass Market internet, and therefore are labeled with an availability_status of “Enterprise (Non-BSL)”.<br /></div><div><br /></div><div><font size='4'><b>Attributes</b></font></div><div><font size='4'><b><br /></b></font></div><div><font size='3'>Attribute fields with a preface of “<b>bsl_</b>” come from the FCC Broadband Serviceable Fabric </font><a href='https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-' target='_blank' rel='nofollow ugc noopener noreferrer'>What is the Location Fabric? – BDC Help Center (fcc.gov)</a><font size='3'>. The acronym “BSL” stands for “Broadband Serviceable Location”. The data dictionary for the dataset is accessible </font><a href='https://nm-community.maps.arcgis.com/home/item.html?id=ba906272c5ba4c66a53e57439d48e6cc' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a><font size='3'>.</font><br /></div><div><font size='3'><br /></font></div><div><font size='3'>Attribute fields with a preface of “<b>bdc_</b>” come from the Broadband Data Collection Provider Availability dataset download available here - </font><a href='https://broadbandmap.fcc.gov/data-download/nationwide-data' target='_blank' rel='nofollow ugc noopener noreferrer'>https://broadbandmap.fcc.gov/data-download/nationwide-data</a><font size='3'><br /></font></div></font><font color='#000000'><div><br /></div><div><ul><li>bsl_unit_count - BSL Fabric Schema - An estimate of the number of residential, nonresidential units within the location. In the case of Community Anchor Institutions and Group Quarters, there is an indication of the presence of CAI or Group Quarters structure.<br /></li><li>bsl_flag - BSL Fabric Schema - an indication of whether the Fabric Record is a BSL (1 - TRUE or Not 0 - FALSE)<br /></li><li>bsl_fabric_version - Indicates the latest version of the BSL Fabric in which the point is represented. Generally, 20221231 V 3.2<br /></li><li>bdc_brand_name – Name of the entity or service advertised or offered to consumers<br /></li><li>bdc_technology – Text description of technology<br /></li><li>availability_status – Broadband service availability, based on thresholds defined by the FCC<br /></li></ul></div></font></div>

Map Name: Map1

Legend

All Layers and Tables

Dynamic Legend

Dynamic All Layers

Layers:

FCC Official BSL BDC Service Status View (0)

Description:

Service Item Id: d9a6caeb3f024575b08fd7c3205a55a6

Copyright Text:

Spatial Reference: 4326 (4326) LatestVCSWkid(0)

Single Fused Map Cache: false

Initial Extent:

Full Extent:

Units: esriDecimalDegrees

Supported Image Format Types: PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP

Document Info:

Supports Dynamic Layers: true

Resampling: false

MaxRecordCount: 2000

MaxImageHeight: 4096

MaxImageWidth: 4096

Supported Query Formats: JSON, geoJSON, PBF

Supports Query Data Elements: true

Min Scale: 0

Max Scale: 0

Supports Datum Transformation: true

Child Resources: Info Dynamic Layer

Supported Operations: Export Map Identify QueryLegends QueryDomains Find Return Updates

FCC/FCC_Official_BSL_BDC_Service_Status_View (MapServer)