Geodataset Name:       BTS_BRIDGE_JUN17
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         12352

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:                  20170627
TIME PERIOD OF CONTENT:            20170627
DOWNLOAD LINK:                     http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: BTS_BRIDGE_JUN17.DBF

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. The most dramatic shift noted from prior data upon general inspection was 7071 meters - Three 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. - 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 FL17.txt to bts_bridge_jun017.shp. - After contacting the office of bridges and structures for missing field definitions a number of fields were removed as they were deemed obsolete. These fields are listed below: FED_AGENCY DATE_LAST_UPDATE TYPE_LAST_UPDATE DEDUCT_CODE REMARKS PROGRAM_CODE PROJ_NO PROJ_SUFFIX NBI_TYPE_OF_IMP DTL_TYPE_OF_IMP SPECIAL_CODE STEP_CODE STATUS_WITH_10YR_RULE SUFFICIENCY_ASTERC SUFFICIENCY_RATING STATUS_NO_10YR_RULE Process Date: 20180823 Dataset copied. Process Date: 20180906

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

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