FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: NATIONAL BRIDGE INVENTORY IN FLORIDA - JUNE 2018

Geodataset Name:       BTS_BRIDGE_JUN18
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         12429
GENERAL DESCRIPTION:
This dataset is a subset of the National Bridge Inventory for the state of Florida. The NBI is a collection of information (database) describing more than 600,000 of the Nation's bridges located on public roads including Interstate Highways, US highways, State and county roads, as well as publicly-accessible bridges on Federal lands. It presents a summary analysis of the number, location, and general condition of highway bridges within the state. This is an update to the bts_bridge_jun17 layer.
DATA SOURCE(S):                    U.S. Department of Transportation, Bureau of Transportation Statistics, Federal Highway Administration
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20181231 TIME PERIOD OF CONTENT: 20181231 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: BTS_BRIDGE_JUN18.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
STATE_CODE
5 String
STRUCTURE_
15 String
RECORD_TYP
8 Double
ROUTE_PREF
8 Double
SERVICE_LE
8 Double
ROUTE_NUMB
5 String
DIRECTION_
8 Double
HIGHWAY_DI
5 String
COUNTY_COD
5 String
PLACE_CODE
5 String
FEATURES_D
25 String
CRITICAL_F
1 String
FACILITY_C
20 String
LOCATION_0
30 String
MIN_VERT_C
8 Double
KILOPOINT_
8 Double
BASE_HWY_N
8 Double
LRS_INV_RO
15 String
SUBROUTE_N
8 Double
LAT_016
10 String
LONG_017
10 String
DETOUR_KIL
8 Double
TOLL_020
8 Double
MAINTENANC
5 String
OWNER_022
5 String
FUNCTIONAL
5 String
YEAR_BUILT
8 Double
TRAFFIC_LA
8 Double
TRAFFIC__1
8 Double
ADT_029
8 Double
YEAR_ADT_0
8 Double
DESIGN_LOA
8 Double
APPR_WIDTH
8 Double
MEDIAN_COD
8 Double
DEGREES_SK
8 Double
STRUCTURE1
8 Double
RAILINGS_0
5 String
TRANSITION
5 String
APPR_RAIL_
5 String
APPR_RAIL1
5 String
HISTORY_03
8 Double
NAVIGATION
8 Double
NAV_VERT_C
8 Double
NAV_HORR_C
8 Double
OPEN_CLOSE
5 String
SERVICE_ON
8 Double
SERVICE_UN
8 Double
STRUCTUR_1
8 Double
STRUCTUR_2
5 String
APPR_KIND_
8 Double
APPR_TYPE_
5 String
MAIN_UNIT_
8 Double
APPR_SPANS
8 Double
HORR_CLR_M
8 Double
MAX_SPAN_L
8 Double
STRUCTUR_3
8 Double
LEFT_CURB_
8 Double
RIGHT_CURB
8 Double
ROADWAY_WI
8 Double
DECK_WIDTH
8 Double
VERT_CLR_O
8 Double
VERT_CLR_U
5 String
VERT_CLR_1
8 Double
LAT_UND_RE
5 String
LAT_UND_MT
8 Double
LEFT_LAT_U
8 Double
DECK_COND_
5 String
SUPERSTRUC
5 String
SUBSTRUCTU
5 String
CHANNEL_CO
8 Double
CULVERT_CO
254 String
OPR_RATING
8 Double
OPERATING_
8 Double
INV_RATING
8 Double
INVENTORY_
8 Double
STRUCTURAL
8 Double
DECK_GEOME
5 String
UNDCLRENCE
5 String
POSTING_EV
8 Double
WATERWAY_E
8 Double
APPR_ROAD_
8 Double
WORK_PROPO
5 String
WORK_DONE_
5 String
IMP_LEN_MT
8 Double
DATE_OF_IN
8 Double
INSPECT_FR
8 Double
FRACTURE_0
5 String
UNDWATER_L
5 String
SPEC_INSPE
5 String
FRACTURE_L
5 String
UNDWATER_1
8 Double
SPEC_LAST_
5 String
BRIDGE_IMP
8 Double
ROADWAY_IM
8 Double
TOTAL_IMP_
8 Double
YEAR_OF_IM
5 String
OTHER_STAT
5 String
OTHER_ST_1
8 Double
OTHR_STATE
10 String
STRAHNET_H
8 Double
PARALLEL_S
5 String
TRAFFIC_DI
8 Double
TEMP_STRUC
5 String
HIGHWAY_SY
8 Double
FEDERAL_LA
8 Double
YEAR_RECON
8 Double
DECK_STRUC
5 String
SURFACE_TY
5 String
MEMBRANE_T
5 String
DECK_PROTE
5 String
PERCENT_AD
8 Double
NATIONAL_N
8 Double
PIER_PROTE
5 String
BRIDGE_LEN
5 String
SCOUR_CRIT
8 Double
FUTURE_ADT
8 Double
YEAR_OF_FU
8 Double
FED_AGENCY
5 String
DATE_LAST_
36 Date
TYPE_LAST_
5 String
DEDUCT_COD
5 String
REMARKS
5 String
PROGRAM_CO
10 String
PROJ_NO
10 String
PROJ_SUFFI
5 String
NBI_TYPE_O
5 String
DTL_TYPE_O
5 String
SPECIAL_CO
5 String
STEP_CODE
5 String
STATUS_WIT
8 Double
SUFFICIENC
5 String
SUFFICIE_1
8 Double
STATUS_NO_
8 Double
MIN_NAV_CL
8 Double
CAT10
5 String
CAT23
8 Double
CAT29
8 Double
LAT_DD
8 Double
LONG_DD
8 Double
MGRS
15 String
GOOGLEMAP
60 String
DESCRIPT
85 String
FGDLAQDATE
15 String
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

STATE_CODE State Code

STRUCTURE_ Structure Number

RECORD_TYP Record Type

ROUTE_PREF Route Signing Prefix

SERVICE_LE Designated Level of Service

ROUTE_NUMB Route Number

DIRECTION_ Directional Suffix

HIGHWAY_DI Highway Agency District

COUNTY_COD County (Parish) Code

PLACE_CODE Place Code

FEATURES_D Features Intersected

CRITICAL_F Critical Facility Indicator

FACILITY_C Facility Carried By Structure

LOCATION_0 Location

MIN_VERT_C Inventory Route, Min Vertical Clearance

KILOPOINT_ Kilometerpoint

BASE_HWY_N Base Highway Network

LRS_INV_RO LRS Inventory ROute

SUBROUTE_N Subroute Number

LAT_016 Latitude

LONG_017 Longitude

DETOUR_KIL Bypass/Detour Length

TOLL_020 Toll

MAINTENANC Maintenance Responsibility

OWNER_022 Owner

FUNCTIONAL Functional Class of Inventory Route

YEAR_BUILT Year Built

TRAFFIC_LA Lanes on Structure

TRAFFIC__1 Lanes Under Structure

ADT_029 Average Daily Traffic

YEAR_ADT_0 Year of Average Daily Traffic

DESIGN_LOA Design Load

APPR_WIDTH Approach Roadway Width

MEDIAN_COD Bridge Median

DEGREES_SK Skew

STRUCTURE1 Structure Flared

RAILINGS_0 Traffic Safety Features

TRANSITION Transitions

APPR_RAIL_ Approach Guardrail

APPR_RAIL1 Approach Guardrail Ends

HISTORY_03 Historical Significance

NAVIGATION Navigation Control

NAV_VERT_C Navigation Vertical Clearance

NAV_HORR_C Navigation Horizontal Clearance

OPEN_CLOSE Strucutre Open/Posted/Closed

SERVICE_ON Type of Service on Bridge

SERVICE_UN Type of Service Under Bridge

STRUCTUR_1 Kind of Material/Design

STRUCTUR_2 Type of Design/Construction

APPR_KIND_ Approach Spans, Kind of Material/Design

APPR_TYPE_ Approach Spans, Type of Design/Construction

MAIN_UNIT_ Number of Spans in Main Unit

APPR_SPANS Number of Approach Spans

HORR_CLR_M Inventory Rte Total Horizontal Clearance

MAX_SPAN_L Length of Maximum Span

STRUCTUR_3 Structure Length

LEFT_CURB_ Left Curb/Sidewalk Width

RIGHT_CURB Right Curb/Sidewalk Width

ROADWAY_WI Bridge Roadway Width Curb-To-Curb

DECK_WIDTH Deck Width, Out-To-Out

VERT_CLR_O Min Vertical Clearance Over Bridge Roadway

VERT_CLR_U Minimum Vertical Underclearance Reference Feature

VERT_CLR_1 Minimum Vertical Underclearance

LAT_UND_RE Min Lateral Underclear on Right, Reference Feature

LAT_UND_MT Minimum Lateral Underclearance

LEFT_LAT_U Min Lateral Underclear On Left

DECK_COND_ Deck

SUPERSTRUC Superstructure

SUBSTRUCTU Substructure

CHANNEL_CO Channel/Channel Protection

CULVERT_CO Culverts

OPR_RATING Method Used to Determine Operating Rating

OPERATING_ Operating Rating

INV_RATING Method Used to Determine Inventory Rating

INVENTORY_ Inventory Rating

STRUCTURAL Structural Evaluation

DECK_GEOME Deck Geometry

UNDCLRENCE Underclear, Vertical & Horizontal

POSTING_EV Bridge Posting

WATERWAY_E Waterway Adequacy

APPR_ROAD_ Approach Road Alignment

WORK_PROPO Type of Work Proposed

WORK_DONE_ Work Done By

IMP_LEN_MT Length of Structure Improvement

DATE_OF_IN Inspection Date

INSPECT_FR Designated Inspection Frequency

FRACTURE_0 Fracture Critical Details

UNDWATER_L Underwater Inspection

SPEC_INSPE Other Special Inspection

FRACTURE_L Fracture Critical Details Date

UNDWATER_1 Underwater Inspection Date

SPEC_LAST_ Other Special Inspection Date

BRIDGE_IMP Bridge Improvement Cost

ROADWAY_IM Roadway Improvement Cost

TOTAL_IMP_ Total Project Cost

YEAR_OF_IM Year Of Improvement Cost Estimate

OTHER_STAT Neighboring State Code

OTHER_ST_1 Percent Responsibility

OTHR_STATE Border Bridge Structure Number

STRAHNET_H STRAHNET Highway Designation

PARALLEL_S Parallel Structure Designation

TRAFFIC_DI Direction Of Traffic

TEMP_STRUC Temporary Structure Designation

HIGHWAY_SY Highway System Of Inventory Route

FEDERAL_LA Federal Lands Highways

YEAR_RECON Year Reconstructed

DECK_STRUC Deck Structure Type

SURFACE_TY Type of Wearing Surface

MEMBRANE_T Type of Membrane

DECK_PROTE Deck Protection

PERCENT_AD Average daily truck traffic

NATIONAL_N Designated national network

PIER_PROTE Pier/Abutment protection

BRIDGE_LEN NBIS bridge length

SCOUR_CRIT Scour critical bridges

FUTURE_ADT Future average daily traffic

YEAR_OF_FU Year of future average daily traffic

FED_AGENCY No description

DATE_LAST_ No description

TYPE_LAST_ No description

DEDUCT_COD No description

REMARKS No description

PROGRAM_CO No description

PROJ_NO No description

PROJ_SUFFI No description

NBI_TYPE_O No description

DTL_TYPE_O No description

SPECIAL_CO No description

STEP_CODE No description

STATUS_WIT No description

SUFFICIENC No description

SUFFICIE_1 No description

STATUS_NO_ No description

MIN_NAV_CL Minimum navigation vertical clearance vertical lift bridge

CAT10 Bridge Condition

CAT23 Condition code value that dictates the overall Bridge Condition

CAT29 Deck area as defined by the Pavement and Bridge Condition Performance Measures final rule, published in January of 2017

LAT_DD Latitude Decimal Degrees

LONG_DD Longitude 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 [FEATURES_D], [FACILITY_C], and [LOCATION_0]

FGDLAQDATE GeoPlan added field based on date acquired from 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.

To document the nation's bridge inventory.

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

The NBI database, or any portion thereof, can be freely distributed as long
as this metadata entry is included with each distribution. The original
metadata entry cannot be modified or deleted from any data transfer.

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:
Federal Highway Administration Bridge and Structure page:
https://www.fhwa.dot.gov/bridge/

DATA LINEAGE SUMMARY:
The GeoPlan Center took the following steps during the QA/QC process:
- Downloaded the dataset from BTS on 8/23/2018 using this link:
  https://www.fhwa.dot.gov/bridge/nbi/disclaim.cfm?nbiYear=2017/delimited&nbiState=FL17
- This dataset was originally in the form of a text file
- The text file was exported to a .csv file
- The .csv was imported into ArcMap and converted to a file geodatabase table
- Two fields were added to the table, LAT_DD and LONG_DD. These
  fields were then calculated using information from the LAT_016 and LONG_017
  and the following formulas:
  Left( [LAT_016], 2 ) + (Mid( [LAT_016], 3, 2 )/60) + ((Mid( [LAT_016], 5, 2 ) &  "." &  Mid( [LAT_016], 7, 2 ))/3600)
  and
  Left( [LONG_017], 3 ) + (Mid( [LONG_017], 4, 2 )/60) + ((Mid( [LONG_017], 6, 2 ) &  "." &  Mid( [LONG_017], 8, 2 ))/3600)
- XY locations were displayed using the information in the newly calculated
  LAT_DD and LONG_DD fields (the WGS 1984 geographic coordinate
  system was used as the coordinate system when displaying the data)
- The point event layer was exported to shapefile to preserve the spatial
  location of the bridge data points
- Dataset projected into the FGDL Albers HPGN projection using
  WGS_1984_(ITRF00)_To_NAD_1983 + NAD_1983_To_HARN_Florida.
- NOTE: significant changes were found to locations of features. These
  changes were often large, exceeding a couple meters. However, upon
  inspection, it seemed these changes often improved the description of the
  physical location of the bridge.
- 6 features were removed from the dataset because they lacked accurate
  spatial data
- The fields FEATURES_D, FACILITY_C, and LOCATION_0 were edited to 
  remove tick marks from the attributes.
  The following calculations were used:
  Replace( [fieldname], "'", "")
  Trim( [fieldname] )
- DESCRIPT field added based on a combination of the FEATURES_D,
  FACILITY_C, and LOCATION_0 fields. Any records with
  no data in the FACILITY_C field had their DESCRIPT field calculated as
  'NO DESCRIPT AVAILABLE'. The formula used to create the descript field was:
  [FEATURES_D] & " BRIDGE" & " [" & [FACILITY_C] & " - " & [LOCATION_0] & "]"
- FGDLAQDATE field added based on the date the dataset was downloaded
  from source.
- GOOGLEMAP and MGRS fields added
- The longest record for each field was found and field character lengths
  were shortened to the appropriate shortest length possible.
- Uppercased fields and appropriate records in the dataset.
- Layer name changed from FL18.txt to bts_bridge_jun18.shp.
Process Date: 20190530

Dataset copied. Process Date: 20190728
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:
U.S. Department of Transportation, Bureau of Transportation Statistics, Federal Highway Administration
FHWA
1200 New Jersey Ave, SE
Washington, DC
20590
202-366-1575

https://www.fhwa.dot.gov/bridge/nbi/disclaim.cfm?nbiYear=2017/delimited&nbiState=FL17 samantha.lubkin@dot.gov Samantha Lubkin

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