Geography Lookup Table by US Government | Technology and IT

About this Dataset

Geography Lookup Table

Summary data of fixed broadband coverage by geographic area. License and Attribution: Broadband data from FCC Form 477, and data from the U.S. Census Bureau that are presented on this site are offered free and not subject to copyright restriction. Data and content created by government employees within the scope of their employment are not subject to domestic copyright protection under 17 U.S.C. § 105. See, e.g., U.S. Government Works.

While not required, when using content, data, documentation, code and related materials from fcc.gov or broadbandmap.fcc.gov in your own work, we ask that proper credit be given. Examples include:
• Source data: FCC Form 477
• Map layer based on FCC Form 477
• Code data based on broadbandmap.fcc.gov

The geography look ups are created from the US census shapefiles, which are in Global Coordinate System North American Datum of 1983 (GCS NAD83). The coordinates do not get reprojected during processing. The "centroid_lng", "centroid_lat" columns in the lookup table are the exact values from the US census shapefile (INTPTLON, INTPTLAT). The "bbox_arr" column is calculated from the bounding box/extent of the original geometry in the shapefile; no reprojection or transformations are done to the geometry.
Organization: Federal Communications Commission
Last updated: 2020-11-12T13:20:29.009838
Tags: broadband, fixed, form-477, map

Tables

Table 1

@usgov.fcc_gov_geography_lookup_table.table_1

12.27 MB
254335 rows
7 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "geoid" VARCHAR,
  "type" VARCHAR,
  "name" VARCHAR,
  "centroid_lng" DOUBLE,
  "centroid_lat" DOUBLE,
  "bbox_arr" VARCHAR
);