| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This is a composite layer that joins together the following datasets: </SPAN></P><P><SPAN>All Broadband Serviceable Locations (BSLs) in New Mexico as of the FCC National Broadband Map Fabric released on </SPAN><SPAN STYLE="font-weight:bold;text-decoration:underline;">6/30/2024 (version 5)</SPAN><SPAN>. For more information visit https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-</SPAN></P><P><SPAN>The best-available provider availability data and BDC availability status released </SPAN><SPAN STYLE="font-weight:bold;text-decoration:underline;">1/21/2025 as-of 6/30/2024 (version 5). </SPAN><SPAN>BDC datasets can be downloaded here.</SPAN></P><P><SPAN>Details</SPAN></P><P><SPAN /></P><P><SPAN>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)</SPAN></P><P><SPAN /></P><P><SPAN>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: Michael Felzan (michael.felzan.contractor@doit.nm.gov)</SPAN></P><P><SPAN /></P><P><SPAN>Access Use Constraints</SPAN></P><P><SPAN /></P><P><SPAN>Data is not intended for editing; updates to this dataset will be made internally by OBAE staff.</SPAN></P><P><SPAN /></P><P><SPAN>Data is intended for the general public.</SPAN></P><P><SPAN /></P><P><SPAN>Methodology</SPAN></P><P><SPAN /></P><P><SPAN>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.</SPAN></P><P><SPAN /></P><P><SPAN>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:</SPAN></P><P><SPAN>Copper Wire, rank of 1</SPAN></P><P><SPAN>Licensed Terrestrial Fixed Wireless, rank of 2</SPAN></P><P><SPAN>Licensed-by-Rule Terrestrial Fixed Wireless, rank of 2</SPAN></P><P><SPAN>Coaxial Cable / HFC, rank of 3</SPAN></P><P><SPAN>Optical Carrier Fiber to Premises, rank of 4</SPAN></P><P><SPAN>BDC technology service availability is also ranked as Served/Underserved/Unserved based on the following criteria (BDC technology service availability is also ranked as Served/Underserved/Unserved based on the following criteria (https://broadbandusa.ntia.doc.gov/sites/default/files/2022-09/BEAD-Frequently-Asked-Questions-%28FAQs%29_Version-2.0.pdf, also available here):</SPAN></P><P><SPAN>Unserved 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"</SPAN></P><P><SPAN>Underserved 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</SPAN></P><P><SPAN>Served locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)</SPAN></P><P><SPAN>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:</SPAN></P><P><SPAN /></P><P><SPAN>SELECT * </SPAN></P><P><SPAN>FROM (</SPAN></P><P><SPAN>SELECT a.frn, a.provider_id, a.brand_name, a.location_id, a.technology,</SPAN></P><P><SPAN>a.max_advertised_download_speed, a.max_advertised_upload_speed,</SPAN></P><P><SPAN>a.low_latency, a.business_residential_code, a.id_for_rank, </SPAN></P><P><SPAN>a.service_level,</SPAN></P><P><SPAN>a.tech_level,</SPAN></P><P><SPAN>rank() OVER (</SPAN></P><P><SPAN> PARTITION BY a.location_id </SPAN></P><P><SPAN> ORDER BY</SPAN></P><P><SPAN> a.service_level DESC,</SPAN></P><P><SPAN> a.tech_level DESC,</SPAN></P><P><SPAN> a.max_advertised_download_speed DESC,</SPAN></P><P><SPAN> a.max_advertised_upload_speed DESC,</SPAN></P><P><SPAN> a.id_for_rank ASC</SPAN></P><P><SPAN> ) AS rank</SPAN></P><P><SPAN>FROM </SPAN></P><P><SPAN> <BDC_TECH_TABLE_MERGED> </SPAN></P><P><SPAN>) b </SPAN></P><P><SPAN>WHERE b.rank = 1;</SPAN></P><P><SPAN /></P><P><SPAN>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.</SPAN></P><P><SPAN /></P><P><SPAN>For BSL locations that do not have corresponding BDC Technology information, 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).</SPAN></P><P><SPAN /></P><P><SPAN>For NoBSL locations that do not have corresponding BDC Technology information, 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)”.</SPAN></P><P><SPAN /></P><P><SPAN>Attributes</SPAN></P><P><SPAN /></P><P><SPAN>Attribute fields with a preface of “bsl_” come from the FCC Broadband Serviceable Fabric What is the Location Fabric? – BDC Help Center (fcc.gov). The acronym “BSL” stands for “Broadband Serviceable Location”. The data dictionary for the dataset is accessible here.</SPAN></P><P><SPAN /></P><P><SPAN>Attribute fields with a preface of “bdc_” come from the Broadband Data Collection Provider Availability dataset download available here - https://broadbandmap.fcc.gov/data-download/nationwide-data</SPAN></P><P><SPAN /></P><P><SPAN>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.</SPAN></P><P><SPAN>bsl_flag - BSL Fabric Schema - an indication of whether the Fabric Record is a BSL (1 - TRUE or Not 0 - FALSE)</SPAN></P><P><SPAN>bsl_fabric_version - Indicates the latest version of the BSL Fabric in which the point is represented. Generally, 20221231 V 3.2</SPAN></P><P><SPAN>bdc_brand_name – Name of the entity or service advertised or offered to consumers</SPAN></P><P><SPAN>bdc_technology – Text description of technology</SPAN></P><P><SPAN>availability_status – Broadband service availability, based on thresholds defined by the FCC</SPAN></P></DIV></DIV></DIV> |