FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: FLORIDA DEPARTMENT OF TRANSPORTATION - OUTDOOR ADVERTISING - MAY 2009

Geodataset Name:       FL_BILLBOARDS_MAY09
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         19625
GENERAL DESCRIPTION:
This dataset contains an inventory of outdoor advertising structures, permits and other related information maintained by the Florida Department of Transportation.
DATA SOURCE(S):                    Florida Department of Transportation
SCALE OF ORIGINAL SOURCE MAPS:     VARIES
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20090501 TIME PERIOD OF CONTENT: 20090501 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: FL_BILLBOARDS_MAY09.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
COUNTY
20 String
A_NAME
50 String
ADDRESS
50 String
ADDRESS2
50 String
CITY
30 String
STATE
7 String
ZIP
10 String
PHONE
15 String
C_NAME
50 String
LICENSE_RQ
12 String
PERMIT
4 Integer
TAG
10 String
TAG_ISSUED
15 String
EXP_DATE
36 Date
S_AREA
4 Integer
FCNG_BUILT
36 Date
HAGL
4 Integer
LIGHTING
10 String
SIGNREADS
12 String
PROP_TAXID
45 String
STRUCTURE
8 Double
S_STATUS
15 String
S_CONFIG
15 String
DIS_INTERS
8 Double
DIR_INTERS
12 String
DIS_ROW
4 Integer
HEIGHT
4 Integer
IN_CITY
10 String
LANDUSE
15 String
LATITUDE
8 Double
LONGITUDE
8 Double
MILEPOST
8 Double
N_SUPPORTS
8 Double
RCI_INTERS
50 String
RCI_SECT
10 String
SIDEOFSECT
15 String
MATERIAL
10 String
DIST_EOP
4 Integer
S_BUILT
36 Date
L_NAME
40 String
SR_ID
10 String
US_ID
10 String
CLASS
10 String
S_MILEPOST
8 Double
E_MILEPOST
8 Double
LENGTH
8 Double
S_DESCRIPT
60 String
E_DESCRIPT
60 String
INT_MP
2 SmallInteger
CL_ID_MP
8 Double
CL_RDWAY
8 String
CL_MP
2 SmallInteger
CLMP_RDWY
26 String
CL_DISTNC
8 Double
ID_MP
8 Double
ROADWAY
8 String
MP
2 SmallInteger
MP_RDWY
26 String
RCI_DISTNC
8 Double
GROUP_
50 String
MP_DIFF
2 SmallInteger
NOTES
250 String
RANK
2 SmallInteger
DESCRIPT
50 String
FGDLAQDATE
36 Date
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

COUNTY COUNTY

A_NAME ACCOUNT NAME

ADDRESS ADDRESS

ADDRESS2 ADDRESS2

CITY CITY

STATE STATE

ZIP ZIP CODE

PHONE PHONE

C_NAME CONTACT NAME

LICENSE_RQ LICENSE REQUIRED

PERMIT PERMIT#

TAG TAG

TAG_ISSUED TAG ISSUED

EXP_DATE EXPIRY DATE

S_AREA AREA

FCNG_BUILT FACING BUILT

HAGL HAGL

LIGHTING LIGHTING

SIGNREADS SIGN READS

PROP_TAXID PROPERTY TAX ID

STRUCTURE STRUCTURE#

S_STATUS STRUCTURE STATUS

S_CONFIG STRUCTURE CONFIG

DIS_INTERS DISTANCE INTERSECTION

DIR_INTERS DIRECTION INTERSECTION

DIS_ROW DISTANCE ROW

HEIGHT HEIGHT

IN_CITY IN CITY

LANDUSE LAND USE

LATITUDE LATITUDE in Decimal Degrees.

LONGITUDE LONGITUDE in Decimal Degrees.

MILEPOST MILEPOST

N_SUPPORTS NUMBER SUPPORTS

RCI_INTERS RCI INTERSECTION

RCI_SECT RCI SECTION

SIDEOFSECT SIDE OF SECTION

MATERIAL MATERIAL

DIST_EOP DISTANCE EOP

S_BUILT STRUCTURE BUILT

L_NAME LOCAL NAME

SR_ID SR#

US_ID US#

CLASS CLASS

S_MILEPOST START MILEPOST

E_MILEPOST END MILEPOST

LENGTH LENGTH

S_DESCRIPT START DESCRIPTION

E_DESCRIPT END DESCRIPTION

INT_MP This is the derived integer billboards milepost number. This number is derived from the following function: Round(MILEPOST).

CL_ID_MP This represents the closest RCI Milepost_apr09 feature's milepost id number.

CL_RDWAY This represents the closest RCI Milepost_apr09 feature's roadway number.

CL_MP This represents the closest RCI Milepost_apr09 feature's milepost number.

CLMP_RDWY This represents the closest RCI Milepost_apr09 feature's roadway/milepost combination number.

CL_DISTNC This represents the distance (in meters) to the closest RCI Milepost layer feature.

ID_MP This represents the milepost id number of the closest RCI Milepost_apr09 feature with the same RCI ROADWAY number as listed in the Billboards layer.

ROADWAY This represents the roadway number of the closest RCI Milepost_apr09 feature with the same RCI ROADWAY number as listed in the Billboards layer.

MP This represents the milepost number of the closest RCI Milepost_apr09 feature with the same RCI ROADWAY number as listed in the Billboards layer.

MP_RDWY This represents the roadway/milepost combination number of the closest RCI Milepost_apr09 feature with the same RCI ROADWAY number as listed in the Billboards layer.

RCI_DISTNC This represents the distance (in meters) from the Billboard feature to the closest RCI Milepost_apr09 feature with the same RCI ROADWAY number as listed in the Billboards layer.

GROUP_ No description

MP_DIFF This represents ths difference between the INT_MP number from the billboards and the MP from the milepost layer.

NOTES Billboards have been broken out in to 4 main groups - A, B, C, and D. The groups are arranged as a scale in that Group-A represents the most accurate and Group-D represents the least accurate.
GROUP - A1, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) MATCHED CLOSEST MILEPOST LAYER POINT INFO = Milepost connected thought spatial join matched the Milepost listed in the Billboards Layer table.

GROUP - A2, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) MATCHED CLOSEST MILEPOST LAYER POINT INFO +/- 1 MILEPOST = Milepost connected thought spatial join was within 1-Milepost of the listed Milepost in the Billboards Layer table.

GROUP - A3, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) MATCHED CLOSEST MILEPOST LAYER POINT INFO +/- MORE THAN 1 MILEPOST = Milepost connected thought spatial join was within a few Mileposts of the listed Milepost in the Billboards Layer table.

GROUP - B1, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) DIDN'T MATCH CLOSEST MILEPOST LAYER POINT INFO BUT WAS WITHIN 906M OF IT = For this group each Billboard feature was within 906m of the correct milepost.

GROUP - B2, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) DIDN'T MATCH CLOSEST MILEPOST LAYER POINT INFO BUT WAS WITHIN 906M OF +/- 1 MILEPOST = For this group each Billboard feature was within 906m of a milepost that was within 1-mile of the correct milepost.

GROUP - B3, BILLBOARDS LAYER (MILEPOST AND RCI_SECT) DIDN'T MATCH CLOSEST MILEPOST LAYER POINT INFO BUT WAS WITHIN 906M OF +/- MORE THAN 1 MILEPOST = For this group each Billboard feature was within 906m of a milepost that was within a few miles of the correct milepost.

GROUP -C1, BILLBOARDS LAYER WITHIN 1-MILE OF A MILEPOST FEATURE ON THE SAME RCI ROADWAY = For this group each Billboard feature was within 1-mile of a milepost of the correct RCI roadway.

GROUP -C2, BILLBOARDS LAYER WITHIN 5-MILES OF A MILEPOST FEATURE ON THE SAME RCI ROADWAY = For this group each Billboard feature was within 5-miles of a milepost of the correct RCI roadway.

GROUP -C3, BILLBOARDS LAYER OVER 5-MILES FROM A 			MILEPOST FEATURE ON THE SAME RCI ROADWAY = For this group each Billboard feature was over 5-miles from a milepost of the correct RCI roadway.

GROUP -D1, BILLBOARDS LAYER - MILEPOST LISTED DOES NOT EXIST IN MILEPOST LAYER = For this group each Billboard feature milepost was not listed in the RCI Milepost Layer.

GROUP -D2, BILLBOARDS LAYER - MILEPOST LISTED LINKS TO FEATURE IN MILEPOST LAYER THAT HAS BAD GEOMETRY = For this group each Billboard feature milepost links to features in the RCI Milepost Layer that have bad geometry.

GROUP -D3, BILLBOARDS LAYER - FEATURE NOT YET MAPPED - OUT IN GULF = For this group each Billboard feature has not been finalized and therefore has not been mapped.  These features exist as points out in the Gulf of Mexico and this info is documented in the Billboard Layer's metadata.


RANK This represents the accuracy of the spatial location of the point as derived from a comparision made between the billboards layer and the RCI Milepost (apr 09) layer.
1 = Rank 1 (most accurate)= 19111 records, this includes groups*: A1, A2, B1, B2.

2 = Rank 2= 241 records, this includes groups: A3, B3, C1.

3 = Rank 3 (least accurate)= 273 records, this includes groups: C2, C3, D1, D2, D3.


DESCRIPT Based on field L_NAME.

FGDLAQDATE The date FGDL acquired 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.
The Florida Department of Transportation (Department) is responsible for 
controlling ODA signs on the National and State highway systems. The 
Department must control the location, size, height, spacing and lighting of ODA 
signs but has no authority to regulate the content of advertising messages on the 
signs. The Outdoor Advertising regulatory program is based on federal law and 
regulations as well as state statute and rule. Federal law is set forth in the Highway
Beautification Act while federal regulations can be found at 23 C.F.R., Section 
750. State laws are found in Chapter 479, Florida Statutes. In addition to the state 
statutes, the Department writes administrative rules to interpret the intent of the 
statute for the general public. Chapter 14-10, Florida Administrative Code, is the 
Department's rule chapter which governs outdoor advertising. Local governments 
often have their own ordinances which regulate outdoor advertising in their 
community. The Department cannot issue a permit for an outdoor advertising sign 
which is not allowed by local ordinances.

While there are many aspects of the outdoor advertising regulatory program, this 
web page deals with pertinent information to help you determine if you need to 
obtain a license or permit for outdoor advertising signs and the requirements for 
obtaining and maintaining a license or permit.

Information on ODA licenses, permits and tags is available below. The ODA 
database, featuring a search option, can be accessed below for current permits, 
sign locations and other information. If you have questions or need information on
this program, please contact Lynn Holschuh (lynn.holschuh@dot.state.fl.us).

All renewal payments and forms relating to the Outdoor Advertising regulatory 
program are to be sent to:
   Outdoor Advertising Office
   Florida Department of Transportation
   605 Suwannee Street, Mail Station 22
   Tallahassee, Florida 32399-0450
   Phone: (850) 414-4545 Fax: (850) 488-485

Please note that the conformity status of a sign may change.  Although the 
Department endeavors to update this section of its records as often as possible, 
there may be reasons why a sign has become nonconforming that are unknown to 
the Department.  Before taking any action on the assumption your sign is 
conforming, you should check with Department personnel.

The data was created to serve as base information for use in GIS systems 
for a variety of planning and analytical purposes.

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

Billboards have been broken out in to 4 main groups - A, B, C, and D.
The groups are arranged as a scale in that Group-A represents the most accurate 
and Group-D represents the least accurate.

Group-A
For features falling within this category it was determined, through the spatial join 
function of the Billboards layer to the RCI Milepost layer that the join produced a 
milepost on the same RCI Roadway Section as was listed in the Billboards layer 
table.  For this group each Billboard feature was within 906m (805m = 0.5 mile, an 
extra 100m added for displacement of object off roadway) of the correct mile post. 
 There are variations of this, listed as A1, A2, and A3.  (A1 represents the most accurate)
A1 - Milepost connected thought spatial join matched the Milepost listed in the 
Billboards Layer table.
A2 - Milepost connected thought spatial join was within 1-Milepost of the listed 
Milepost in the Billboards Layer table.
A3 - Milepost connected thought spatial join was within a few Mileposts of the 
listed Milepost in the Billboards Layer table.

Group-B
For features falling within this category it was determined, through the spatial join 
function of the Billboards layer to the RCI Milepost layer that the initial join did not 
produced a milepost on the same RCI Roadway Section as was listed in the 
Billboards layer table.  
 There are variations of this, listed as B1, B2, and B3.  (B1 represents the most accurate)
B1 - For this group each Billboard feature was within 906m of the correct milepost .
B2 - For this group each Billboard feature was within 906m of a milepost that was 
within 1-mile of the correct milepost.
B3 - For this group each Billboard feature was within 906m of a milepost that was 
within a few miles of the correct milepost.

Group-C
For features falling within this category it was determined, through the spatial join 
function of the Billboards layer to the RCI Milepost layer that the initial join did not 
produced a milepost on the same RCI Roadway Section as was listed in the 
Billboards layer table.
 There are variations of this, listed as C1, C2, and C3.  (C1 represents the most accurate)
C1- For this group each Billboard feature was within 1-mile of a milepost of the 
correct RCI roadway.
C2- For this group each Billboard feature was within 5-miles of a milepost of the 
correct RCI roadway.
C3- For this group each Billboard feature was over 5-miles from a milepost of the 
correct RCI roadway.

Group-D
For features falling within this category it was determined, through the spatial join 
function of the Billboards layer to the RCI Milepost layer that the initial join did not 
produced a milepost on the same RCI Roadway Section as was listed in the 
Billboards layer table.
 There are variations of this, listed as D1, D2, and D3.  (D1 represents the most accurate)
D1- For this group each Billboard feature milepost was not listed in the RCI 
Milepost Layer.
D2- For this group each Billboard feature milepost links to features in the RCI 
Milepost Layer that have bad geometry.
D3- For this group each Billboard feature has not been finalized and therefore has 
not been mapped.  These features exist as points out in the Gulf of Mexico and 
this info is documented in the Billboard Layer's metadata.

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



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:
Outdoor Advertising Database:
http://www2.dot.state.fl.us/rightofway/Default.aspx

Outdoor Advertising Data Download 
http://www2.dot.state.fl.us/rightofway/DownloadData.aspx

Notes:
Latitude and longitude are included which allows GIS plotting of the structures 
statewide or by county. The file is in Excel format and is updated each month.

A single structure may be listed on more than one row in the file. 
This occurs when a single structure contains more than active permit. 
In these cases you can determine the distinct structures by the structure# column. 
The structure# will be the same regardless of how many active permits are attached to the structure.

DATA LINEAGE SUMMARY:
GeoPlan Center Downloaded the data from the following 
Florida Department of Transportations (FDOT) website:
http://www2.dot.state.fl.us/rightofway/DownloadData.aspx

The Excel spread sheet was downloaded on May 21st 2009.

The original excel document file name was: floutdooradvertising.xls

The floutdooradvertising.xls field names were first shortened to fit database standards.

Next the floutdooradvertising.xls was converted to a database table.

Next this table was mapped in ArcMap via the Add XY Data tool.

The XY locations were added via the LATITUDE and LONGITUDE fields.

The dataset's projection was defined as WGS84.

Next the dataset was reprojected to the FGDL NAD83 HARN Albers projection.

Next the DESCRIPT field was added based on L_NAME (Location Name).
Process Date: 20090522

Data imported to ArcSDE and exported as a shapefile. Process Date: 20090525
Dataset copied. Process Date: 20090526
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:
Florida Department of Transportation Office of Right of Way
FDOT
605 Suwannee Street, MS22
Tallahassee, FL
32399-0450
850-414-4545

http://www2.dot.state.fl.us/rightofway/DownloadData.aspx juanice.hagan@dot.state.fl.us

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