******************************************************** NOTICE ******************************************************** This document was converted from WordPerfect or Word to ASCII Text format. Content from the original version of the document such as headers, footers, footnotes, endnotes, graphics, and page numbers will not show up in this text version. All text attributes such as bold, italic, underlining, etc. from the original document will not show up in this text version. Features of the original document layout such as columns, tables, line and letter spacing, pagination, and margins will not be preserved in the text version. If you need the complete document, download the WordPerfect version or Adobe Acrobat version, if available. ***************************************************************** DA 00-46 Released: January 12, 2000 WIRELESS TELECOMMUNICATIONS BUREAU ANNOUNCES THE AVAILABILITY OF ANTENNA STRUCTURE REGISTRATION DATA VIA THE INTERNET The Antenna Structure Registration (ASR) public access files are now available for downloading via the Internet. These files contain complete application and registration data, along with daily updates, that can be used for private programming and research efforts. Additionally, we are, for the first time, making FAA determination records for antenna structures available to the public. Anyone can download these files directly to a personal computer free of charge. The Query feature which provides free, interactive on-line searches of the ASR database will continue to be available via the Antenna Homepage (www.fcc.gov/wtb/antenna). Location of Files The ASR data files are located on the ULS home page (www.fcc.gov/wtb/uls). To access the files, scroll to the hypertext links labeled "Download Complete ULS Databases" and "Download ULS Daily Transaction Files." The complete files are created at 5:00 am Eastern Time Sunday morning and the daily files are created at 5:00 am Eastern Time Tuesday through Saturday mornings. The file created on Tuesday contains Monday data, Wednesday contains Tuesday data, etc. The data files can also be accessed from the FCC's ftp site (ftp://ftp.fcc.gov/pub/Bureaus/Wireless/Databases/uls). NOTE: A zipped file size of 110 bytes indicates that there were no new or modified applications or registrations for that radio service for that day. The files are named as follows ("xxx" denotes the day of the week): Complete Application Data . . . . .a_tower.zip Complete Registration Data. . . . .r_tower.zip Complete FAA Determination Records.d_tower.zip Daily Application Data. . . . . . .a_tow_xxx.zip Daily Registration Data . . . . . .r_tow_xxx.zip Daily FAA Determination Records . .d_tow_xxx.zip Data Files. The data files produced by unzipping a downloaded file will vary depending on whether you are downloading applications, registrations or determinations. Each data file contains a specific type of data (e.g., names and addresses, location data) and the data is pipe-delimited. Each record type starts with the same unique 2-character record type code that identifies the table from which the data was extracted. A pipe ("|") does not follow the last data field. Each data file has a name of the form xx.dat, where xx indicates the content. Note: Although the data files contained in the ASR zip files have the same name as those contained in the application and license zip files, the data structure is not the same. Definition Files. Three files containing definitions are available for downloading: · patower.xls (Attachment A to this Public Notice) is an Excel file containing definitions of the data fields in the database tables. · towerddl.sql (Attachment B to this Public Notice) contains the SQL for the table definitions. · towcodes.doc (Attachment C to this Public Notice) contains meanings of codes for the code data elements in the tables. Data Files The data files for applications are: RA . . . . . . .application data RS . . . . . . .reason for returning or dismissing applications EN . . . . . . .names and addresses applicable to each application CO . . . . . . .antenna structure coordinates RE . . . . . . .FCC remarks SC . . . . . . .FCC special conditions HS . . . . . . .history for each application AT . . . . . . .indicates if application has attachments (Note: attachments are not included in the zip files) The data files for registrations are: RA . . . . . . .registration data EN . . . . . . .names and addresses applicable to each registration CO . . . . . . .antenna structure coordinates RE . . . . . . .FCC remarks SC . . . . . . .FCC special conditions HS . . . . . . .history for each registration he data files for determinations are: DE . . . . . . .determination information DP . . . . . . .determination painting and lighting data DR . . . . . . .FAA determination remarks Joining Data Application data can be joined using the column named "File Number" or "Unique System Identifier". Registration data can be joined using "Registration Number" or Unique System Identifier". Determinations can be joined using "FAA Study Number". For Further Information or Assistance For general information about ULS, including answers to frequently asked questions regarding submitting applications, finding the status of pending applications, and searching the ULS database, the Commission recommends first consulting the ULS webpage at http://www.fcc.gov/wtb/uls. Individuals having specific questions not addressed on the webpage may contact Commission staff via phone or e-mail as described below. FCC Technical Support Hotline: (202) 414-1250 (TTY (202) 414-1255), or via e-mail at ulscomm@fcc.gov. Contact the Technical Support Hotline about questions concerning computer access to ULS, TIN registration, uploading files, or submitting attachments in ULS. The hotline is available Monday through Friday, from 8 a.m. to 6 p.m., local Eastern Time. In order to provide better service to ULS users and ensure the security of the electronic filing system, all calls to the hotline are recorded. ULS Licensing Support: 1-888-CALL-FCC (225-5322) (select Auction/ULS Forms prompt), or via e-mail at ulshelp@fcc.gov. Contact Licensing Support with questions about which application purpose(s) are appropriate for a particular filing, what information is being requested on a ULS Form or Schedule, or any other ULS-related licensing matter. ULS Licensing Support is available Monday through Friday, from 8 a.m. to 5:30 p.m. local eastern time. Comments on ULS should be sent via email to: ulscomm@fcc.gov. Attachment A: Definitions Of The Data Fields In The Database Tables File "patower.xls" REGISTRATION/APPLICATION Position Data Element Definition Content 1 Record Type char(2) "RA" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Application Purpose char(2) 7 Previous Purpose char(2) 8 Input Source Code char(1) 9 Status Code char(1) 10 Date Entered mm/dd/yyyy 11 Date Received mm/dd/yyyy 12 Date Issued mm/dd/yyyy 13 Date Constructed mm/dd/yyyy 14 Date Dismantled mm/dd/yyyy 15 Date Action mm/dd/yyyy 16 Archive Flag Code char(1) 17 Version integer 18 Signature First Name varchar(20) 19 Signature Middle Initial char(1) 20 Signature Last Name varchar(20) 21 Signature Suffix varchar(3) 22 Signature Title varchar(40) 23 Invalid Signature char(1) 24 Structure_Street Address varchar(80) 25 Structure_City varchar(20) 26 Structure_State Code char(2) 27 Height of Structure numeric(5,1) 28 Ground Elevation numeric(6,1) 29 Overall Height Above Ground numeric(6,1) 30 Overall Height AMSL numeric(6,1) 31 Structure Type char(6) 32 Date FAA Determination Issued mm/dd/yyyy 33 FAA Study Number varchar(20) 34 FAA Circular Number varchar(10) 35 Specification Option Integer 36 Painting and Lighting varchar(100) 37 FAA EMI Flag char(1) 38 NEPA Flag char(1) REASONS Position Data Element Definition Content 1 Record Type char(2) "RS" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Reason Type char(1) 7 Reason Description varchar(50) 8 Reason Comment varchar(255) 9 Reason Date mm/dd/yyyy ENTITY Position Data Element Definition Content 1 Record Type char(2) "EN" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9,0) 6 Entity Type char(1) 7 Licensee ID char(9) 8 Entity Name varchar(200) 9 First Name varchar(20) 10 MI char(1) 11 Last Name varchar(20) 12 Suffix char(3) 13 Phone char(10) 14 Internet Address varchar(50) 15 Street Address varchar(35) 16 PO Box varchar(20) 17 City varchar(20) 18 State char(2) 19 Zip Code char(9) 20 Attention varchar(35) COORDINATES Position Data Element Definition Content 1 Record Type char(2) "CO" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Coordinate Type char(1) 7 Latitude Degrees integer 8 Latitude Minutes integer 9 Latitude Seconds numeric(4,1) 10 Latitude Direction char(1) 11 Latitude_Total_Seconds numeric(8,1) 12 Longitude Degrees integer 13 Longitude Minutes integer 14 Longitude Seconds numeric(4,1) 15 Longitude Direction char(1) 16 Longitude_Total_Seconds numeric(8,1) REMARKS Position Data Element Definition Content 1 Record Type char(2) "RE" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Remark Type char(3) 7 Date Keyed mm/dd/yyyy 8 Sequence Number integer 9 Remark Text varchar(255) SPECIAL CONDITION Position Data Element Definition Content 1 Record Type char(2) "SC" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Date Keyed mm/dd/yyyy 7 Sequence Number integer 8 Remark Text varchar(255) HISTORY Position Data Element Definition Content 1 Record Type char(2) "HS" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Date mm/dd/yyyy 7 Description varchar(50) ATTACHMENT Position Data Element Definition Content 1 Record Type char(2) "AT" 2 Content Indicator char(3) 3 File Number char(8) 4 Registration Number char(7) 5 Unique System Identifier numeric(9) 6 Attachment Code char(1) 7 Description varchar(60) 8 Date mm/dd/yyyy FAA Determination Information Position Data Element Definition Content 1 Record Type char(2) "DE" 2 FAA Study Number varchar(20) 3 Circular Number varchar(10) 4 Latitude Degrees integer 5 Latitude Minutes integer 6 Latitude Seconds numeric(4,2) 7 Latitude Direction char(1) 8 Latitude Total Seconds numeric(8,2) 9 Longitude Degrees integer 10 Longitude Minutes integer 11 Longitude Seconds numeric(4,2) 12 Longitude Direction char(1) 13 Longitude Total Seconds numeric(8,2) 14 Height Ground Elevation numeric(5,1) 15 Height Overall Structure numeric(6,1) 16 Height Overall AMSL numeric(6,1) 17 FAA Date Issued mm/dd/yyyy 18 FAA Date Keyed mm/dd/yyyy 19 FAA Date Expiration mm/dd/yyyy 20 Date Action mm/dd/yyyy 21 Date FAA Final mm/dd/yyyy 22 City varchar(20) 23 State Code char(2) 24 Business Name varchar(200) 25 First Name varchar(20) 26 Middle Initial char(1) 27 Last Name varchar(20) 28 Suffix char(3) 29 FAA EMI Flag char(1) 30 Version integer FAA Determinations Painting and Lighting Position Data Element Definition Content 1 Record Type char(2) "DP" 2 FAA Study Number varchar(20) 3 FAA Chapter Code varchar(14) 4 Specification Option integer DETERMINATION REMARKS Position Data Element Definition Content 1 Record Type char(2) "DR" 2 FAA Study Number varchar(20) 3 Date Keyed mm/dd/yyyy 4 Sequence Number integer 5 Remark Text varchar(255) Attachment B: SQL For The Table Definitions File "towerddl.sql" create table dbo.TOWER_PUBACC_AT ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, attachment_code char(1) null, description varchar(60) null, date char(10) null ) go create table dbo.TOWER_PUBACC_CO ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, coordinate_type char(1) not null, latitude_degrees int null, latitude_minutes int null, latitude_seconds numeric(4,1) null, latitude_direction char(1) null, latitude_total_seconds numeric(8,1) null, longitude_degrees int null, longitude_minutes int null, longitude_seconds numeric(4,1) null, longitude_direction char(1) null, longitude_total_seconds numeric(8,1) null ) go create table dbo.TOWER_PUBACC_DE ( record_type char(2) null, faa_study_number varchar(20) not null, circular_number varchar(10) null, latitude_degrees int null, latitude_minutes int null, latitude_seconds numeric(4,2) null, latitude_direction char(1) null, latitude_total_seconds numeric(8,2) null, longitude_degrees int null, longitude_minutes int null, longitude_seconds numeric(4,2) null, longitude_direction char(1) null, longitude_total_seconds numeric(8,2) null, height_ground_elevation numeric(5,1) null, height_overall_structure numeric(6,1) null, height_overall_amsl numeric(6,1) null, faa_date_issued char(10) null, faa_date_keyed char(10) null, faa_date_expiration char(10) null, date_action char(10) null, date_faa_final char(10) null, city varchar(20) null, state_code char(2) null, business_name varchar(200) null, first_name varchar(20) null, middle_initial char(1) null, last_name varchar(20) null, suffix char(3) null, faa_emi_flag char(1) null, version int null ) go create table dbo.TOWER_PUBACC_DP ( record_type char(2) null, faa_study_number varchar(20) not null, faa_chapter_code varchar(14) null, specification_option int null ) go create table dbo.TOWER_PUBACC_DR ( record_type char(2) null, faa_study_number varchar(20) not null, date_keyed char(10) null, sequence_number int null, remark_text varchar(255) null ) go create table dbo.TOWER_PUBACC_EN ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, entity_type char(1) not null, licensee_id char(9) null, entity_name varchar(200) null, first_name varchar(20) null, mi char(1) null, last_name varchar(20) null, suffix char(3) null, phone varchar(10) null, internet_address varchar(50) null, street_address varchar(35) null, po_box varchar(20) null, city varchar(20) null, state char(2) null, zip_code char(9) null, attention varchar(35) null ) go create table dbo.TOWER_PUBACC_HS ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, date char(10) null, description varchar(50) null ) go create table dbo.TOWER_PUBACC_RA ( RECORD_TYPE char(2) null, CONTENT_INDICATOR char(3) null, FILE_NUMBER char(8) null, REGISTRATION_NUMBER char(7) null, UNIQUE_SYSTEM_IDENTIFIER numeric(9,0) not null, APPLICATION_PURPOSE char(2) null, PREVIOUS_PURPOSE char(2) null, INPUT_SOURCE_CODE char(1) null, STATUS_CODE char(1) null, DATE_ENTERED char(10) null, DATE_RECEIVED char(10) null, DATE_ISSUED char(10) null, DATE_CONSTRUCTED char(10) null, DATE_DISMANTLED char(10) null, DATE_ACTION char(10) null, ARCHIVE_FLAG_CODE char(1) null, VERSION int null, SIGNATURE_FIRST_NAME varchar(20) null, SIGNATURE_MIDDLE_INITIAL char(1) null, SIGNATURE_LAST_NAME varchar(20) null, SIGNATURE_SUFFIX varchar(3) null, SIGNATURE_TITLE varchar(40) null, INVALID_SIGNATURE char(1) null, STRUCTURE_STREET_ADDRESS varchar(80) null, STRUCTURE_CITY varchar(20) null, STRUCTURE_STATE_CODE char(2) null, HEIGHT_OF_STRUCTURE numeric(5,1) null, GROUND_ELEVATION numeric(6,1) null, OVERALL_HEIGHT_ABOVE_GROUND numeric(6,1) null, OVERALL_HEIGHT_AMSL numeric(6,1) null, STRUCTURE_TYPE char(6) null, DATE_FAA_DETERMINATION_ISSUED char(10) null, FAA_STUDY_NUMBER varchar(20) null, FAA_CIRCULAR_NUMBER varchar(10) null, SPECIFICATION_OPTION int null, PAINTING_AND_LIGHTING varchar(100) null, FAA_EMI_FLAG char(1) null, NEPA_FLAG char(1) null ) go create table dbo.TOWER_PUBACC_RE ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, remark_type char(3) not null, date_keyed char(10) null, sequence_number int null, remark_text varchar(255) null ) go create table dbo.TOWER_PUBACC_RS ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, reason_type char(1) null, reason_description varchar(50) null, reason_comment varchar(255) null, reason_date char(10) null ) go create table dbo.TOWER_PUBACC_SC ( record_type char(2) null, content_indicator char(3) null, file_number char(8) null, registration_number char(7) null, unique_system_identifier numeric(9,0) not null, date_keyed char(10) null, sequence_number int null, remark_text varchar(255) null ) go Attachment C: Meanings Of Codes For The Code Data Elements In The Tables File "towcodes.doc" Explanation of Codes Used in Tower Public Access Files Table Column/Code Description RA Content Indicator APP Application REG Registration RA Application Purpose 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 D 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 WD Withdrawal of a pending application RA Input Source Code D diskette I interactive M manual RA Status Code A Canceled C Constructed D Dismissed G Granted I Dismantled O Owner removed P Pending R Returned T Terminated W Withdrawn RA Archive Flag Code C current version A Archive Table Column/Code Description RA Specification Option 1, 2, 3 FAA Chapters 4 FCC Paragraphs RA Invalid Signature Code N Invalid Signature Y Valid Signature RS Content Indicator APP Application REG Registration RS Reason Type D Dismissal R Return EN Content Indicator APP Application REG Registration EN Entity Type O Owner R Representative A Assignor CO Content Indicator APP Application REG Registration CO Coordinate Type T Tower A Array RE Content Indicator APP Application REG Registration RE Remark Type FAA FAA remark FCC FCC (external) remark SC Content Indicator APP Application REG Registration Table Column/Code Description HS Content Indicator APP Application REG Registration AT Content Indicator APP Application AT Attachment Code N NEPA O other W waiver DP Specification Option 1, 2, 3 FAA Chapters 4 FCC Paragraphs