Nancy Rader Minnesota Geospatial Information Office (MnGeo) GIS Data Specialist 651-201-2489 658 Cedar Street, Room 300 St. Paul MN 55155 gisinfo.mngeo@state.mn.us 20210115 https://gisdata.mn.gov/dataset/util-fcc Antenna Structure Registrations, Federal Communications Commission (FCC), Minnesota, 2018 2018-07-26 Federal Communications Commission (FCC) Media Bureau and Wireless Telecommunications Bureau Federal Communications Commission (FCC) This data set contains all ASRs (Antenna Structure Registrations) filed with the FCC. An antenna structure must be registered if the antenna structure is taller than 200 feet above ground level or may interfere with the flight path of a nearby airport. As a pilot project, MnGeo created this dataset in order to provide the data in a GIS-ready format, and to demonstrate the steps required to convert data on the FCC download site. With these datasets, users are able to determine the locations and limited technical details of existing towers the FCC licenses (i.e. Cellular, Paging, Microwave, AM, FM, etc.). This information can be extremely helpful in conducting analysis such as: current service deployment, need/feasibility determinations of new services, co-location of antenna structures, inventorying of structures, network planning, etc. Melvin C. Del Rosario Federal Communications Commission 202-418-0615 445 12th Street SW Washington DC 20554 mdelrosa@fcc.gov https://resources.gisdata.mn.gov/pub/gdrs/data/pub/us_mn_state_mngeo/util_fcc/metadata/antenna_structure_registration_mn_preview.jpg Antenna Structure Registration screenshot Minnesota, MN utilitiesCommunication, FCC, Federal Communications Commission, Transmission, Towers, Licensing, Infrastructure, Utilities, Communication, AM Towers, AM Radio, Antennas, Antenna Structure Registration, ASR, BRS, Cellular, Cellular Service Area Boundaries, Cellular Towers, EBS, FM Towers, FM Radio, Land Mobile, Land Mobile Stations, Land Mobile Communications, Microwave, Microwave Towers, Pager, Paging, Pager Towers, TV Towers, TV Transmission, Television ISO 19115 Topic Category Minnesota, MN utilitiesCommunication, FCC, Federal Communications Commission, Transmission, Towers, Licensing, Infrastructure, Utilities, Communication, AM Towers, AM Radio, Antennas, Antenna Structure Registration, ASR, BRS, Cellular, Cellular Service Area Boundaries, Cellular Towers, EBS, FM Towers, FM Radio, Land Mobile, Land Mobile Stations, Land Mobile Communications, Microwave, Microwave Towers, Pager, Paging, Pager Towers, TV Towers, TV Transmission, Television Data provided is to serve as base information for use in GIS systems for general planning, analytical, and research purposes. It is not intended for engineering work or to legally define reservation boundaries, FCC licensee data or FCC market boundaries. 1. Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government or the Federal Communications Commission (FCC). No warranty expressed or implied is made by the FCC as to the accuracy of the data and related materials. The act of distribution shall not constitute any such warranty, and no responsibility is assumed by the FCC in the use of this data, or related materials. 2. MnGeo's data disclaimer: https://www.mngeo.state.mn.us/chouse/disclaimer.html FCC Universal Licensing System homepage: https://www.fcc.gov/wireless/support/universal-licensing-system-uls-resources/new-users-guide-getting-started-universal true -97.23 -89.53 49.37 43.5 Date that MnGeo downloaded the data from the FCC website. 2018-07-13 Minnesota Not available Not available Not available Not available Not available Federal Communications Commission: FCC staff extract these datasets periodically from their Licensing Database. Processing Steps - Minnesota Geospatial Information Office: The Antenna Structure Registration file for registrations within the state of Minnesota was acquired from the Federal Communications Commisson's Antenna Structure Registration Search and downloaded in .txt format. The ASR Search can be found here: https://wireless2.fcc.gov/UlsApp/AsrSearch/asrRegistrationSearch.jsp In Microsoft Excel, this text file was opened and formatted. The "CO" (coordinate) table was extracted and converted to .csv format. The reference for the field names was acquired from the FCC's Database Field Definitions file: https://wireless.fcc.gov/uls/documentation/patower-2.xls Using ArcMap, this file was then converted into a .dbf table. Two new fields (LatStr and LonStr) were created by aggregating the LatDeg, LatMin, LatSec, LatDir, LonDeg, LonMin, LonSec, and LonDir fields. The Convert Coordinate Notation tool was then used to convert the Degree Minute Seconds coordinates into Decimal Degrees, project the data into UTM Zone 15 coordinates, and create a feature class of the data points. The resulting feature class was joined with the "RA" table included in the original download file and any duplicate fields were removed. Fields were renamed as necessary after the feature class was created. https://www.mngeo.state.mn.us/committee/standards/mgmg/metadata.htm antenna_structure_registration_mn FCC OBJECTID Internal feature number ESRI Sequential unique whole numbers that are automatically generated. Shape Feature geometry ESRI Coordinates defining the features RecType Record Type FCC CO coordinate ContInd Content Indicator FCC REG Registration FileNum File Number. A unique 8-digit number (the letter 'A' followed by 7 numeric digits) assigned by the FCC to an application when it is received. FCC RegNum Registration Number. A unique 7-digit number issued by the FCC during the registration process that uniquely identifies an antenna structure. FCC UnqSysId Unique System Identifier FCC CoorType Coordinate Type FCC T Tower A Array LatDeg Latitude Degrees FCC LatMin Latitude Minutes FCC LatSec Latitude Seconds FCC LatDir Latitude Direction FCC LatTot Latitude Total Seconds FCC LonDeg Longitude Degrees FCC LonMin Longitude Minutes FCC LonSec Longitude Seconds FCC LonDir Longitude Direction FCC LonTot Longitude Total Seconds FCC LatStr Latitude String (derived from LatDeg, LatMin, LatSec, and LatDir) LonStr Latitude String (derived from LonDeg, LonMin, LonSec, and LonDir) DDLat Latitude in Decimal Degrees DDLon Longitude in Decimal Degrees OID_1 Object ID RecType_1 Unknown. FCC RA Unknown AppPurp Application Purpose FCC AM Amendment of a previously filed, currently pending application AU Administrative Update CA Cancellation of a registered, unconstructed structure DI Notification of antenna structure dismantlement DU Request a duplicate Registration document MD Modification of a registered antenna structure NE Application to register an antenna structure that has not been registered NT Notification that an antenna structure has been constructed OC Ownership change RE Registration of a replacement antenna structure WD Withdrawal of a pending application PrePurp Unknown. Similar domain to AppPurp FCC InSrcCode Input Source Code FCC D diskette I interactive M manual StatCode Status Code FCC A Canceled C Constructed D Dismissed G Granted I Dismantled N Inactive O Owner removed P Pending R Returned T Terminated W Withdrawn DateEnt Date Entered FCC DateRec Date Received FCC DateIss Date Issued FCC DateCon Date Constructed FCC DateDis Date Dismantled FCC DateAct Date Action FCC ArcFlag Archive Flag Code FCC C Current Version A Archive Version Version FCC SigFirst Signature Name First FCC SigMid Signature Middle Initial FCC SigLast Signature Last Name FCC SigSuff Signature Suffix FCC SigTitle Signature Title FCC InvSig Invalid Signature Code FCC N Invalid Signature Y Valid Signature Street Structure Street Address FCC City Structure City FCC State Structure State Code FCC County County Name FCC Zip ZIP Code FCC Height Height of Structure, in meters FCC GrndElv Ground Elevation in meters FCC AbvGrndHgh Overall Height Above Ground (AGL), in meters, of the entire antenna structure to the highest point, including any appurtenances. FCC HeightAMSL Overall Structure Height above mean sea level (AMSL), in meters. It is the sum of the GrndElv and the AbvGrndHgh attributes. FCC StructType Structure Type FCC DateFAA Date FAA Determination Issued FCC FAAStudNum FAA Study Number FCC FAACircNum FAA Circular Number FCC SpecOpt Specification Option FCC 1 FAA Chapters 2 FAA Chapters 3 FAA Chapters 4 FCC Paragraphs PaintLight Painting and Lighting. The painting and/or illumination of antenna towers that may otherwise constitute a menace to air navigation. FCC PropMarkLi Proposed Marking and Lighting FCC ArrTowPos Unknown FCC ArrTotTow Unknown FCC 1.0 20260323 15390800 TRUE