FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: REGISTERED TELEVISION BROADCAST STRUCTURE LOCATIONS IN FLORIDA - FEBRUARY 2017

Geodataset Name:       TVBCST_FEB17
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         463
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_jun12 layer.
DATA SOURCE(S):                    Federal Communications Commission
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20170208 TIME PERIOD OF CONTENT: 20170208 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: TVBCST_FEB17.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
CALLSIGN
10 String
SERVICE
2 String
CHANNEL
8 Double
STATUS
5 String
CITY
20 String
STATE
2 String
COUNTRY
2 String
FILENUM
20 String
ERP
10 String
HAAT
8 Double
FACID
8 Double
LAT
15 String
LON
15 String
LICENSEE
60 String
LATDD
8 Double
LONDD
8 Double
TYPE
10 String
DESCRIPT
60 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.

CHANNEL Channel.

STATUS Tower licensing status.

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.

LATDD Latitude in decimal degrees.

LONDD Longitude in decimal degrees.

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

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 its data as spatial data.  Downloaded TV 
Broadcast Stations using the TV Query Broadcast Station Search.  Selected only 
Florida stations with an output of Text file (no delimiters / no links).  Downloaded 
from (https://www.fcc.gov/media/television/tv-query) in February 2017. Copied all
records and pasted them into a text file. Saved as tvbroadcasts.txt. 

- Opened and formatted tvbroadcasts.txt in Excel.  Added field names using 
  tvbcst_jun12 and Data arrangement for Text file outputs 
  (https://www.fcc.gov/media/radio/am-fm-tv-textlist-key).  In 2009, all TV signals 
  transferred over from analog to digital. Populated the TYPE field with DIGITAL.  
  Saved coordinate fields as LATD, LATM, LATS, LATDIR, LOND, LONM, LONS, 
  and LONDIR
- Saved as .csv file
- Opened .csv in ArcMap and exported to a dbase table
- Added LATDD and LONDD fields using type = double. These fields will be used to 
  house the coordinates in decimal degrees. These field names were chosen
  to mimic the coordinate fields in tvbcst_jun12.
- Used field calculator to convert coordinate fields from DMS to DD. The equation 
  for latitude (LATDD) was:
	( [LATS] /3600) + ( [LATM] /60) + [LATD]
The equation for longitude (LONDD) was:
	( [LONS] /3600) + ( [LONM] /60) + [LOND]
- Generated XY data using the LATDD and LONDD fields.  The projection
  was defined as WGS 1984.

TVBCST shapefile
- Projected the event layer to Albers_Harn using project tool and exported out
  as shapefile
- Deleted fields not present in tvbcst_jun12
- Deleted one feature that fell outside of Florida. FACID 188832
- Added descript field based on CALLSIGN
- Added FGDLAQDATE based on the date GeoPlan acquired the data
- Added a LAT and LON field based on combination of LATD, LATM, LATS, 
  LATDIR, LOND, LONM, LONS, and LONDIR then deleted those field because
  they are not present in the previous TVBCST shapefile
- 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: 20170209

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