FCC/FCC_Official_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 7/31/2023 (version 3.2). 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 11/14/2023 as-of 6/30/2023 (version 3). 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 from 2/07/2024. 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 2/07/2024 (for Federal Commitments) and 2/27/2024 (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>Details</div><div>Coordinate System – WGS84 (WKID: 4326)</div></div><div> </div><div>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). </div><div> </div><div>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”. </div><div> </div><div>Data Custodian: Kevin Hoffman (kevin.hoffman.contractor@doit.nm.gov) </div><div> </div><div>Access Use Constraints</div><div>Data is not intended for editing; updates to this dataset will be made internally by OBAE staff. </div><div> </div><div>Data is intended for the general public. </div><div> </div><div>Methodology</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. </div><div> </div><div>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: </div><div><ul><li>Copper Wire, rank of 1</li><li>License 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> or <a href='https://nm-community.maps.arcgis.com/home/item.html?id=5f47e138e8194bb1aa1562f9886315ed' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a>): </div></div><div><ul><li>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"</li><li>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</li><li>Served locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)</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: </div></div><div> </div><div><div>SELECT * </div><div>FROM (</div><div>SELECT a.frn, a.provider_id, a.brand_name, a.location_id, a.technology,</div><div>a.max_advertised_download_speed, a.max_advertised_upload_speed,</div><div>a.low_latency, a.business_residential_code, a.id_for_rank, </div><div>a.service_level,</div><div>a.tech_level,</div><div>rank() OVER (</div><div> PARTITION BY a.location_id </div><div> ORDER BY</div><div> a.service_level DESC,</div><div> a.tech_level DESC,</div><div> a.max_advertised_download_speed DESC,</div><div> a.max_advertised_upload_speed DESC,</div><div> a.id_for_rank ASC</div><div> ) AS rank</div><div>FROM </div><div> <BDC_TECH_TABLE_MERGED> </div><div>) b </div><div>WHERE b.rank = 1;</div></div><div> </div><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> </div><div>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).</div><div> </div><div>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)”. </div><div> </div><div>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.</div><div> </div><div>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.</div></div><div> </div><div>Attributes</div><div>Attribute fields with a preface of bsl_ come from the <a href='https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-' target='_blank' rel='nofollow ugc noopener noreferrer'>FCC Broadband Serviceable Fabric</a>. The acronym “BSL” stands for “Broadband Serviceable Location”. The data dictionary for the dataset is accessible <a href='https://nm-community.maps.arcgis.com/home/item.html?id=ba906272c5ba4c66a53e57439d48e6cc' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a>. </div><div> </div><div>Attribute fields with a preface of bdc_ come from the Broadband Data Collection Provider Availability Dataset. The dataset is available <a href='https://broadbandmap.fcc.gov/data-download/nationwide-data' target='_blank' rel='nofollow ugc noopener noreferrer'>here</a>.</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. </li><li>bsl_flag - BSL Fabric Schema - an indication of whether the Fabric Record is a BSL (1 - TRUE or Not 0 - FALSE) </li><li>bsl_fabric_version - Indicates the latest version of the BSL Fabric in which the point is represented. Generally, 20221231 V 3.2 </li><li>bdc_brand_name - Name of the entity or service advertised or offered to consumers </li><li>bdc_technology - Text description of technology </li><li>availability_status - 1 = Unserved, 2 = Underserved, 3 = Served, from FCC </li><li>deduplication_status - Broadband service availability, based on thresholds defined by the FCC, accounting for Grant Funded Enforceable Commitments. The highest-level service offered by a Grant Funded Enforceable Commitment; if the Federal and State Grants deduplicate to the same service level, the Federal Grant Funded Enforceable Commitment source is noted in the "deduplication_status_source" field. </li></ul></div>

Map Name: Map

Legend

All Layers and Tables

Dynamic Legend

Dynamic All Layers

Layers:

FCC Official BSL BDC Service BEAD Deduplicated View (0)

Description: <DIV STYLE="text-align:Left;"><DIV><DIV>Details:Coordinate System – WGS84 (WKID: 4326)Update Frequency – Data is updated as frequently as new data is made available to the New Mexico 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.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 (<A href="mailto:kevin.hoffman.contractor@doit.nm.gov" STYLE="text-decoration:underline;">kevin.hoffman.contractor@doit.nm.gov</A>)Access Use Constraints: Data is not intended for editing; updates to this dataset will be made internally by OBAE staff.Data is intended for specific users and not the general public. OBAE staff will grant permissions to users/groups as needed. Methodology: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.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:<UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><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>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" STYLE="text-decoration:underline;">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" STYLE="text-decoration:underline;">here</A>):<UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>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"</LI><LI>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"</LI><LI>Served locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)</LI></UL>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:SELECT * FROM ( SELECT a.frn, a.provider_id, a.brand_name, a.location_id, a.technology, a.max_advertised_download_speed, a.max_advertised_upload_speed, a.low_latency, a.business_residential_code, a.id_for_rank, a.service_level, a.tech_level, rank() OVER ( PARTITION BY a.location_id ORDER BY a.service_level DESC, a.tech_level DESC, a.max_advertised_download_speed DESC, a.max_advertised_upload_speed DESC, a.id_for_rank ASC ) AS rank FROM <BDC_TECH_TABLE_MERGED> a ) b WHERE b.rank = 1;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.NTIA/FCC location challenge adjudications correspond to the BSL/NoBSL FCC Fabrics of 6/30/20222 and 12/31/2022. Challenges were submitted to FCC/NTIA on 12/23/2022 and 3/16/2023, respectively. If there were multiple responses that corresponded to a single Location ID, the most relevant response was included in this dataset. The most relevant response was then joined to the BSL/NoBSL and BDC Technology information.For BSL locations that do not have corresponding BDC Technology information:<UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>If the BSL was in the previous fabric release, and there is still no BDC match (under normal circumstances, providers will have 6 months to provide this data in time for the next BSL/NoBSL fabric release), it is assumed the provider has had a chance to claim service for this point, but did not. Therefore, we deem these points “Unserved”.</LI><LI>If the BSL was not in the previous fabric release, we consider the location new (meaning providers have not had a chance to claim service), we do a spatial inference using FCC Hex shapes. Anything outside those hexes would be deemed “Unserved”.</LI></UL>For NoBSL locations that do not have corresponding BDC Technology information:<UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>No spatial-inferences or assumptions are made of the data. Because many bsl_flag=false (aka NoBSL) locations will not subscribe to Mass Market internet, locations without matching BDC Technology data are labeled with an availability_status of “Enterprise (Non-BSL)”</LI></UL>Spatial Inference process Description:Service availability status was set via a modified Nearest Neighbor type analysis. A summary analysis of service availability per H3 hexagon (iterated at the hex 9 - hex 6 levels) was used to impute estimated service levels to locations without a BDC Technology match.For those BSLs with a BDC Technology match, Each hexagon in the state was assigned a number of Served/Underserved/Unserved BSLs within it by service type using the ArcGIS Pro “Summarize Within” tool.Once the mean service level was determined for a given hex polygon, that value could be spatially joined to the challenge points as estimated service levels. For example, if a hexagon had 100 BSLs in it, and 80 of these were Served, 12 were Underserved, and 8 were unserved, the mean service level (as an integer value) would be 2.72, the majority would be 3, and the challenge BSL point would be assigned an availability status of "Served". Means were rounded to the nearest integer. Because many 'New BSLs' did not intersect with smaller hexagons containing valid BSLs, hexagon levels were iterated through until the hex6 level to capture wider areas of interest. Where challenge points did not intersect such hexagons, they were assigned an availability_status of "Unserved" because they are estimated to be too far from any existing service claims.Attributes:Attribute fields with a preface of “bsl_” come from the FCC Broadband Serviceable Fabric <A href="https://help.bdc.fcc.gov/hc/en-us/articles/5375384069659-What-is-the-Location-Fabric-" STYLE="text-decoration:underline;">What is the Location Fabric? – BDC Help Center (fcc.gov)</A>. The acronym “BSL” stands for “Broadband Serviceable Location”. The data dictionary for the dataset is accessible <A href="https://nm-community.maps.arcgis.com/home/item.html?id=ba906272c5ba4c66a53e57439d48e6cc" STYLE="text-decoration:underline;">here</A>.Attribute fields with a preface of “bdc_” come from the Broadband Data Collection Provider Availability dataset download available here - <A href="https://broadbandmap.fcc.gov/data-download/nationwide-data" STYLE="text-decoration:underline;">https://broadbandmap.fcc.gov/data-download/nationwide-data</A>Attribute fields with a preface of “fccresponse_” come from the FCC/NTIA Location Challenge adjudications that correspond to the BSL/NoBSL FCC Fabrics of 6/30/20222 and 12/31/2022. location_id - BSL Fabric Schema - Unique ID for the Fabric location. bsl_address_primary - BSL Fabric Schema - Postal addressbsl_city - BSL Fabric Schema - Postal address city namebsl_state - BSL Fabric Schema - 2 digit state abbreviationbsl_zip - BSL Fabric Schema - 5 digit zip codebsl_zip_suffix - BSL Fabric Schema - 4 digit zip+4 suffixbsl_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.bsl_flag - BSL Fabric Schema - an indication of whether the Fabric Record is a BSL (1 - TRUE or Not 0 - FALSE)bsl_building_type_code - BSL Fabric Schema - Indicates if the record is considered residential (R), nonresidential (B) mixed (X), Group Quarters (G), Community Anchor Institution (C), Enterprise (E) or Other (O)bsl_land_use_code - BSL Fabric Schema - A modeled land use designation estimated from assembled county assessor information (see domain)bsl_address_confidence_code - BSL Fabric Schema - A code indicating the confidence in the association of the textual address with the BSL.bsl_county_geoid - BSL Fabric Schema - 5 digit TIGER 2020 identifier for countybsl_block_geoid - BSL Fabric Schema - 15 digit 2020 Census FIPS code for census blockbsl_latitude - BSL Fabric Schema - Latitude of locationbsl_longitude - BSL Fabric Schema - Longitude of locationbsl_h3index_hex9 - BSL Fabric Schema - A reference to the H3 hex cell I.D., level 9bsl_h3index_hex8 - BSL Fabric Schema - A reference to the H3 hex cell I.D., level 8bsl_h3index_hex7 - BSL Fabric Schema - A reference to the H3 hex cell I.D., level 7bsl_h3index_hex6 - BSL Fabric Schema - A reference to the H3 hex cell I.D., level 6bsl_fabric_version - Indicates the latest version of the BSL Fabric in which the point is represented. Generally, 12312022_ver1bsl_in_previous_fabric- date release of FCC Fabricbdc_frn – 10-digit FCC Registration Number (FRN) of the entity that submitted the databdc_provider_id – Unique identifier for the fixed service providerbdc_brand_name – Name of the entity or service advertised or offered to consumersbdc_technology_code – Code for the technology used for the deployed servicebdc_technology – Text description of technologybdc_max_advertised_down_speed – Maximum advertised download speed offered at the location in MBPSbdc_max_advertised_upload_speed – Maximum advertised upload speed associated with the maximum advertised download speed offered at the location in MBPSbdc_low_latency – Boolean integer flag indicating whether or not the offered service is low latency, defined as having round-trip latency of less than or equal to 100 MS based on the 95th percentile of measurements (0 – False, 1 – True)bdc_business_residential_code – Enumerated character identifying whether the service at the location is offered only to business customers, or to both business and residential customers. Value is one of the following codes (B – business-only location, R – residential-only location, X – business and residential locationfccresponse_ref_id - Unique identifier for the bulk Fabric challenge data submission for pointfccresponse_file_status – Indicator of whether the submitted challenge file was accepted by the FCC/NTIAfccresponse_file_record_status – Indicator of the record file status with FCC/NTIAfccresponse_date_received - Date the location challenge submission was receivedfccresponse_fabric_vintage - As-of date associated with the Fabric that has been challenged. This information is part of the filed challengefccresponse_category_code - The challenge type included as part of the challenge submissionfccresponse_response_code – The NTIA/FCC Response Codefccresponse_status_desc – Text description of fccresponse_response_codefccresponse_location_id - Unique identifier for the challenged locationfccresponse_description_code - A code indicating the reason for the adjudication of each individual challengefccresponse_desc_code_desc - A description of the response_description_code valuefccresponse_description - Free text field for conveying additional information, if applicableavailability_code – number value that corresponds to availability_status. 1 = Unserved, 2 = Underserved, 3 = Servedavailability_status_source - Indicator of the source for availability status. availability_status – Broadband service availability, based on thresholds defined by the FCC<UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>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"</LI><LI>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"</LI><LI>Served locations have access to speeds exceeding these thresholds (100Mbps Download/20Mbps Upload)</LI></UL></DIV></DIV></DIV>

Service Item Id: c87cd5f03bfc4c70acf27ade2456631d

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_BEAD_Deduplicated_View (MapServer)