FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: REGISTERED TELEVISION BROADCAST STRUCTURE LOCATIONS IN FLORIDA - AUGUST 2019

Geodataset Name:       TVBCST_AUG19
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         433
GENERAL DESCRIPTION:
This dataset contains FCC registered television broadcast structure locations. Previously both digital and analog structures were included. Television broadcast has since transitioned to all digital transmission. This is an update to the tvbcst_aug18 layer.
DATA SOURCE(S):                    Federal Communications Commission
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20190805 TIME PERIOD OF CONTENT: 20190805 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: TVBCST_AUG19.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
CALLSIGN
12 String
SERVICE
3 String
CHANNEL
4 String
STATUS
7 String
CITY
25 String
STATE
3 String
COUNTRY
3 String
FILENUM
23 String
ERP
10 String
HAAT
8 String
FACID
11 String
LAT
15 String
LON
15 String
LICENSEE
76 String
TYPE
10 String
LATDD
8 Double
LONDD
8 Double
MGRS
15 String
GOOGLEMAP
100 String
DESCRIPT
25 String
FGDLAQDATE
36 Date
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

CALLSIGN A combination of letters and numbers that identify an FCC license.

SERVICE Service provided by structure.
CA = Class A TV

DM = DTV Channel Change

DN = New DTV Allotment

DR = DTV Channel Substitution

DT = Digital TV

LM = Land Mobile

NM = NTSC Channel Change

NN = New NTSC Allotment

TA = TV Allotment

TB = TV Booster station

TR = Proposed rulemaking to amend the Table of assignments

TS = TV Auxiliary Transmitting Antenna

TV = Television

TX = TV Translator or LPTV station


CHANNEL Channel.

STATUS Tower status.
ADD = Proposal to add a channel

APP = Application

APPDID = TX Application denied by initial Decision in hearing

APPGID = TX Application granted by initial Decision in hearing

CP = Construction Permit

CP MOD = Modification of a construction permit

DEL = Proposal to delete a channel

LIC = License


CITY City location of "LICENSEE".

STATE State location of "LICENSEE".

COUNTRY Country location of "LICENSEE".

FILENUM The FCC-assigned file number of the application.

ERP Effective radiated power. ERP is not equivalent to the power that is radiated, but is a quantity that takes into consideration transmitter power and antenna directivity.

HAAT Height above Average Terrain (meters).

FACID Facility ID.

LAT Latitude.

LON Longitude.

LICENSEE Company or organization that holds the legal license from the Federal Communications Commission.

TYPE Type of signal (all digital as of 2009).

LATDD Latitude in decimal degrees.

LONDD Longitude in decimal degrees.

MGRS Military Grid Reference System (MGRS) Coordinate of the Facility. The MGRS is the geocoordinate standard used by NATO militaries for locating points on the earth. The MGRS provides a means to represent any location on the surface of the Earth using an alphanumeric string. Hierarchical references are based on the Universal Transverse Mercator (UTM) coordinate system. The MGRS is used for the entire earth. http://mgrs-data.org/

GOOGLEMAP Webpage hyperlink to location in Google Maps.

DESCRIPT GeoPlan added field based on CALLSIGN.

FGDLAQDATE The date GeoPlan aquired the data from the source.

AUTOID Unique ID added by GeoPlan


USER NOTES:
This data is provided 'as is'. GeoPlan relied on the integrity
of the original data layer's topology
This data is provided 'as is' by GeoPlan and is complete to our
knowledge.
GeoPlan relied on the integrity of the attribute information within
the original data.

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.

This data is provided 'as is' and its horizontal positional accuracy
has not been verified by GeoPlan

This data is provided 'as is' and its vertical positional accuracy
has not been verified by GeoPlan

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.

The Florida Geographic Data Library is a collection of Geospatial Data
compiled by the University of Florida GeoPlan Center with support from
the Florida Department of Transportation. GIS data available in FGDL is
collected from various state, federal, and other agencies (data sources)
who are data stewards, producers, or publishers. The data available in
FGDL may not be the most current version of the data offered by the
data source. University of Florida GeoPlan Center makes no guarantees
about the currentness of the data and suggests that data users check
with the data source to see if more recent versions of the data exist.

Furthermore, the GIS data available in the FGDL are provided 'as is'.
The University of Florida GeoPlan Center makes no warranties, guaranties
or representations as to the truth, accuracy or completeness of the data
provided by the data sources. The University of Florida GeoPlan Center
makes no representations or warranties about the quality or suitability
of the materials, either expressly or implied, including but not limited
to any implied warranties of merchantability, fitness for a particular
purpose, or non-infringement. The University of Florida GeoPlan Center
shall not be liable for any damages suffered as a result of using,
modifying, contributing or distributing the materials.

A note about data scale: 

Scale is an important factor in data usage.  Certain scale datasets
are not suitable for some project, analysis, or modeling purposes.
Please be sure you are using the best available data. 

1:24000 scale datasets are recommended for projects that are at the
county level.
1:24000 data should NOT be used for high accuracy base mapping such
as property parcel boundaries.
1:100000 scale datasets are recommended for projects that are at the
multi-county or regional level.
1:125000 scale datasets are recommended for projects that are at the
regional or state level or larger.

Vector datasets with no defined scale or accuracy should be
considered suspect. Make sure you are familiar with your data
before using it for projects or analysis. Every effort has been
made to supply the user with data documentation. For additional
information, see the References section and the Data Source Contact
section of this documentation. For more information regarding
scale and accuracy, see our webpage at:
http://geoplan.ufl.edu/education.html

REFERENCES:
Digital Television:
https://www.fcc.gov/general/digital-television

FCC Media Bureau:
http://transition.fcc.gov/mb/

DTV Receptions Maps:
https://www.fcc.gov/media/engineering/dtvmaps

DATA LINEAGE SUMMARY:
In 2012 the FCC stopped releasing tower and antenna locations as spatial 
data. Data layers are available as databases with associated .dat files. 

GeoPlan downloaded TV Broadcast Stations using the TV Query Broadcast 
Station Search. Selected only Florida stations with an output of Text file (pipe delimiters / no links).  
Downloaded from (https://www.fcc.gov/media/television/tv-query) in August 
2019. Copied all records and pasted them into a text file. Saved as tvbcst.txt. 
During the QA/QC process GeoPlan performed the following steps:

- Opened and formatted the tvbroadcasts.txt in Open Office Calc.  Added field 
  names using previous fgdl versions and the Data arrangement for Text file outputs file from
  (https://www.fcc.gov/media/radio/am-fm-tv-textlist-key)..  
  Saved coordinate fields as LATD, LATM, LATS, LAT_DIR, LOND, LONM, 
  LONS, and LON_DIR
- Exported to .dbf
- Added LAT and LONG fields using type = double
- Used field calculator to convert coordinate fields from DMS to DD. The 
  equation for latitude was:
	( [LATS] /3600) + ( [LATM] /60) + [LATD]
  The equation for longitude was:
	( [LONS] /3600) + ( [LONM] /60) + [LOND]
- Generated XY data using the LATDD and LONDD fields.  The projection
  was defined as WGS 1984.
- Exported XY events to shapefile.
- Fields  LATD, LATM, LATS, LAT_DIR, LOND, LONM, LONS, and LON_DIR
  were deleted.
- A number of records fell outside the boundaries of Florida. These records were left as is.
- Projected the new shapefile to NAD83 HARN using the
  WGS_1984_(ITRF00)_To_NAD_1983 + NAD_1983_To_HARN_Florida transformation

- Edited the feature class attribute table to match previous fgdl versions.
- Added field MGRS by using the Convert Coordinate Notation tool and choosing
  output coordinate format as MGRS.
- Added field GOOGLEMAP by concatenating:
  https://www.google.com/maps/place/ and the MGRS ID
- Added descript field based on CALLSIGN.
- Added FGDLAQDATE based on the date GeoPlan acquired the data
- Restructured table and uppercased all fields

Notes:
When the FCC generated this data set spatially in the past they limited the 
lat/long fields to 4 decimals. Now that we are generating the spatial locations 
the decimals have been left to the default value of the field type of double. 
The result is a visible shift of 30-36 meters.
Process Date: 20190809

Dataset copied. Process Date: 20190928
MAP PROJECTION PARAMETERS:

Projection                          ALBERS
Datum                               HPGN
Units                               METERS
Spheroid                            GRS1980
1st Standard Parallel               24  0  0.000
2nd Standard Parallel               31 30  0.000
Central Meridian                   -84 00  0.000
Latitude of Projection's Origin     24  0  0.000
False Easting (meters)              400000.00000
False Northing (meters)             0.00000

DATA SOURCE CONTACT (S):

Name:
Abbr. Name:
Address:


Phone:

Web site:
E-mail:
Contact Person:
         Phone:
        E-mail:
Federal Communications Commission
FCC
445 12th St. SW
Washington, D.C.
20554
888-225-5322

https://www.fcc.gov/media/television/tv-query fccinfo@fcc.gov

FGDL CONTACT:
Name:                   FLORIDA GEOGRAPHIC DATA LIBRARY
Abbr. Name:             FGDL
Address:                Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Web site:               http://www.fgdl.org

Contact FGDL: 

      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html