FCC/OBAE_NM_Best_BSL_BDC_Service_BEAD_Deduplicated

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'>What is the Location Fabric? – BDC Help Center (fcc.gov)</a></li><li>The best-available provider availability data and BDC availability status released <b><u>5/28/2024 as-of 12/31/2023</u></b> (<u><b>version 4</b></u>). BDC datasets can be downloaded at <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></li><li>NTIA BEAD Service Status <b><u>5/28/2024 as-of 12/31/2023</u></b> release. BEAD service availability data cab be downloaded from the NTA Planning Toolkit (login required): <a href='https://nbam.maps.arcgis.com/home/index.html' target='_blank' rel='nofollow ugc noopener noreferrer'>https://nbam.maps.arcgis.com/home/index.html</a></li><li>Grant Funded Enforceable Commitments used in the deduplication process are current to <b><u>5/29/2024</u></b> (for Federal Commitments) and <b><u>6/7/2024</u></b> (for State Commitments). Federal Grant Funded Enforceable Commitments can be downloaded from the NTIA Planning Toolkit (login required): <a href='https://nbam.maps.arcgis.com/home/index.html' target='_blank' rel='nofollow ugc noopener noreferrer'>https://nbam.maps.arcgis.com/home/index.html</a></li></ul><div><font size='4'><b><div><b><br /></b></div><div><b>Details</b><br /></div></b></font></div><div><font size='4'><b><br /></b></font></div><div><font size='3'>Coordinate System – WGS84 (WKID: 4326)</font><br /></div><div><font size='3'><br /></font></div><div><font size='3'>Update Frequency – Data is updated as frequently as new data is made available to the Office of Broadband Access and Expansion. At minimum, the data will be updated as new BSL/NoBSL Fabric and BDC Service Provider information is published.<br /></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”.<br /></font></div><div><font size='3'><br /></font></div><div><font size='3'>Data Custodian: Kevin Hoffman (kevin.hoffman.contractor@doit.nm.gov)<br /></font></div><div><font size='4'><b><br /></b></font></div><div><font size='4'><b>Access Use Constraints</b></font></div><div><font size='4'><b><br /></b></font></div><div><div><font size='3'>Data is not intended for editing; updates to this dataset will be made internally by OBAE staff. </font></div><div><font size='3'><br /></font></div><div><font size='3'>Data is intended for the general public.  </font></div><div><font size='3'><br /></font></div><div><b><font size='4'>Methodology</font></b></div><div><br /></div><div>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.<br /></div></div><div><br /></div><div>BDC Provider Service Availability data is downloaded one technology type at a time in CSV format. 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 /></div><div><ul><li>Copper Wire, rank of 1</li><li>Licensed Terrestrial Fixed Wireless, rank of 2</li><li>Licensed-by-Rule Terrestrial Fixed Wireless, rank of 2</li><li>Coaxial Cable / HFC, rank of 3</li><li>Optical Carrier Fiber to Premises, rank of 4</li></ul><div>BDC technology service availability is also ranked as Served/Underserved/Unserved based on the following criteria (<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>, also available <a href='https://nm-community.maps.arcgis.com/home/item.html?id=5f47e138e8194bb1aa1562f9886315ed' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a>):<br /></div><div><ul><li><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"<br /></li><li><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 /></li><li><b>Served </b>locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)<br /></li></ul><div>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 /></div></div><div><br /></div><div><div><font size='2'>SELECT * </font></div><div><font size='2'>FROM (</font></div><div><font size='2'> SELECT </font></div><div><font size='2'> a.frn, a.provider_id, a.brand_name, a.location_id, a.technology, </font></div><div><font size='2'> a.max_advertised_download_speed, a.max_advertised_upload_speed, </font></div><div><font size='2'> a.low_latency, a.business_residential_code, a.id_for_rank, </font></div><div><font size='2'> a.service_level, </font></div><div><font size='2'> a.tech_level, </font></div><div><font size='2'> rank() OVER (</font></div><div><font size='2'> PARTITION BY a.location_id </font></div><div><font size='2'> ORDER BY </font></div><div><font size='2'> a.service_level DESC, </font></div><div><font size='2'> a.tech_level DESC, </font></div><div><font size='2'> a.max_advertised_download_speed DESC, </font></div><div><font size='2'> a.max_advertised_upload_speed DESC, </font></div><div><font size='2'> a.id_for_rank ASC</font></div><div><font size='2'> ) AS rank </font></div><div><font size='2'> FROM </font></div><div><font size='2'> <BDC_TECH_TABLE_MERGED> a</font></div><div><font size='2'> ) b </font></div><div><font size='2'>WHERE b.rank = 1;</font></div></div><div><br /></div><div>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.</div><div><font size='3'><br /></font></div><div><div><font size='3'>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).</font></div><div><font size='3'><br /></font></div><div><font size='3'>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)”. </font></div><div><font size='3'><br /></font></div><div><font size='3'>BSL data is also joined (via location_id) to BEAD BDC service status data. This is service availability data provided by the NTIA (as opposed to the BDC information published on the FCC Funding Map site). In most cases, the BEAD BDC data will match the FCC Funding Map BDC data.</font></div><div><font size='3'><br /></font></div><div><font size='3'>The best-available technology data in this dataset has been deduplicated using federal and state grant information; availability data has been updated to reflect the best available service level offered by any enforceable commitments that intersect or join with the BSL. If the enforceable commitment does not offer a higher service level than what is currently offered, the "deduplication_status" field (see definition below) will inherit the status that is currently offered.</font></div></div><div><br /></div><div><font size='4'><b>Attributes</b></font></div><div><font size='4'><br /></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></div><div><ul><li><span style='font-size:medium;'>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><br /></li><li><font size='3'>bsl_flag - BSL Fabric Schema - an indication of whether the Fabric Record is a BSL (1 - TRUE or Not 0 - FALSE) <br /></font></li><li><font size='3'>bsl_fabric_version - Indicates the latest version of the BSL Fabric in which the point is represented. Generally, 20221231 V 3.2<br /></font></li><li><font size='3'>bdc_brand_name – Name of the entity or service advertised or offered to consumers<br /></font></li><li><font size='3'>bdc_technology – Text description of technology<br /></font></li><li><font size='3'>bead_service_status - Broadband service availability from NTIA Planning Toolkit</font></li><li><font size='3'>availability_status – Broadband service availability, based on thresholds defined by the FCC<br /></font></li><li><font size='3'>deduplication_status - Broadband service availability, based on thresholds defined by the FCC, accounting for Grant Funded Enforceable Commitments</font></li></ul></div><div><br /></div></div></div>

Map Name: FCC_NM_Best

Legend

All Layers and Tables

Dynamic Legend

Dynamic All Layers

Layers:

OBAE NM Best BSL BDC Service BEAD Deduplicated View (0)

Description:

Service Item Id: b5366fb8a6b9405ab23acd199eca1c47

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

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/OBAE_NM_Best_BSL_BDC_Service_BEAD_Deduplicated_View (MapServer)