Geodataset Name:       BTS_BRIDGE_2017
Geodataset Type:       SDE Feature Class
Geodataset Feature:    Point
Feature Count:         12090

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

FEATURE ATTRIBUTE TABLES:

Datafile Name: BTS_BRIDGE_2017.DBF

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item	Item Description
OBJECTID	Internal feature number.
Shape	Feature geometry.
STFIPS	State FIPS Code
REGION	The FHWA region in which the bride exists
ITEM8	Structure Number
ITEM5A	Record Type
ITEM5B	Route Signing Prefix
ITEM5C	Designated Level of Service
ITEM5D	Route Number
ITEM5E	Directional Suffix
ITEM2	Highway Agency District
ITEM3	County (Parish) Code
ITEM4	Place Code
ITEM6A	Features Intersected
ITEM6B	Critical Facility Indicator
ITEM7	Facility Carried By Structure
ITEM9	Location
ITEM10	Inventory Route/Min Vert Clearance
ITEM11	Kilometerpoint
ITEM12	Base Highway Network
ITEM13A	LRS Inventory Route
ITEM13B	Subroute Number
ITEM16	Latitude
ITEM17	Longitude
ITEM19	Bypass/Detour Length
ITEM20	Toll
ITEM21	Maintenance Responsibility
ITEM22	Owner
ITEM26	Functional Class Of Inventory Route
ITEM27	Year Built
ITEM28A	Lanes On Structure
ITEM28B	Lanes Under Structure
ITEM29	Average Daily Traffic
ITEM30	Year Of Average Daily Traffic
ITEM31	Design Load
ITEM32	Approach Roadway Width
ITEM33	Bridge Median
ITEM34	Skew
ITEM35	Structure Flared
ITEM36A	Bridge Railings
ITEM36B	Transitions
ITEM36C	Approach Guardrail
ITEM36D	Approach Guardrail Ends
ITEM37	Historical significance
ITEM38	Navigation Control
ITEM39	Navigation Vertical Clearance
ITEM40	Navigation Horizontal Clearance
ITEM41	Structure Open/Posted/Closed
ITEM42A	Type of Service On Bridge
ITEM42B	Type of Service Under Bridge
ITEM43A	Kind of Material/Design
ITEM43B	Type of Design/Construction
ITEM44A	Kind of Material/Design
ITEM44B	Type of Design/Construction
ITEM45	Number Of Spans In Main Unit
ITEM46	Number Of Approach Spans
ITEM47	Inventory Route Total Horizontal Clearance
ITEM48	Length Of Maximum Span
ITEM49	Structure Length
ITEM50A	Left Curb/Sidewalk Width
ITEM50B	Right Curb/Sidewalk Width
ITEM51	Bridge Roadway Width Curb-To-Curb
ITEM52	Deck Width/Out-To-Out
ITEM53	Minimum Vertical Clearance Over Bridge Roadway
ITEM54A	Reference Feature
ITEM54B	Minimum Vertical Under Clearance
ITEM55A	Reference Feature
ITEM55B	Minimum Lateral Under Clearance
ITEM56	Minimum Lateral Under Clearance On Left
ITEM58	Deck
ITEM59	Superstructure
ITEM60	Substructure
ITEM61	Channel/Channel Protection
ITEM62	Culverts
ITEM63	Method Used To Determine Operating Rating
ITEM64	Operating Rating
ITEM65	Method Used To Determine Inventory Rating
ITEM66	Inventory Rating
ITEM67	Structural Evaluation
ITEM68	Deck Geometry
ITEM69	Underclear/Vertical and Horizontal
ITEM70	Bridge Posting
ITEM71	Waterway Adequacy
ITEM72	Approach Roadway Alignment
ITEM75A	Type of Work Proposed
ITEM75B	Work Done By
ITEM76	Length Of Structure Improvement
ITEM90	Inspection Date
ITEM91	Designated Inspection Frequency
ITEM92A	Fracture Critical Details
ITEM92B	Underwater Inspection
ITEM92C	Other Special Inspection
ITEM93A	Fracture Critical Details Date
ITEM93B	Underwater Inspection Date
ITEM93C	Other Special Inspection Date
ITEM94	Bridge Improvement Cost
ITEM95	Roadway Improvement Cost
ITEM96	Total Project Cost
ITEM97	Year Of Improvement Cost Estimate
ITEM98A	Neighboring State Code
ITEM98B	Percent Responsibility
ITEM99	Border Bridge Structure Number
ITEM100	STRAHNET Highway Designation
ITEM101	Parallel Structure Designation
ITEM102	Direction Of Traffic
ITEM103	Temporary Structure Designation
ITEM104	Highway System Of Inventory Route
ITEM105	Federal Lands Highways
ITEM106	Year Reconstructed
ITEM107	Deck Structure Type
ITEM108A	Type of Wearing Surface
ITEM108B	Type of Membrane
ITEM108C	Deck Protection
ITEM109	Average Daily Truck Traffic
ITEM110	Designated National Network
ITEM111	Pier/Abutment Protection
ITEM112	NBIS Bridge Length
ITEM113	Scour Critical Bridges
ITEM114	Future Average Daily Traffic
ITEM115	Year of Future Average Daily Traffic
ITEM116	Minimum Navigation Vertical
FED_AGENCY	Is Funding Federal
STAT	Stat 1 = Structurally Deficient Bridge 2 = Functionally Obsolete Bridge null = bridge in acceptable condition
SR1	SR1
SR2	SR2
EXTRA	New Status Field being used by the FHWA.0 = Not Applicable
DATE_	No description
STATUS	Status
LONGDD	Longitude Decimal Degrees
LATDD	Latitude Decimal Degrees
BRIDGE_ID	GeoPlan added trimmed Bridge ID from field ITEM8.
DESCRIPT	Based on the concatenation of [ITEM6A], [ITEM7], [ITEM9].
FGDLAQDATE	The date GeoPlan acquired the data from the source.
AUTOID	Unique ID added by GeoPlan

USER NOTES:

RITA/BTS quality checks were to cross reference the NBI dataset with an up-to-date TeleAtlas dataset, to determine that the spatial data and attribute data were accurate. For those bridges that were not matched to the TeleAtlas data, an attempt was made to use the State supplied longitude-latitude data contained in the NBI. If the resulting point fell within the State, then that location was used. If the point fell outside of the State, it is coded to longitude-latitude 0-0. See the STATUS attribute for more information. 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: http://www.fhwa.dot.gov/ http://www.fhwa.dot.gov/bridge/mtguide.pdf

DATA LINEAGE SUMMARY:

Downloaded shapefile from BTS (http://osav-usdot.opendata.arcgis.com/datasets/fe 70a8d685234d6bb1d82e9287dc75c6_0? geometry=-99.064%2C24.96%2C-57.25%2C30.783). Extracted features where "STATEFIPS" = '12' to select features in Florida. Reprojected file into Albers from GCS_WGS_1984 using the WGS_1984_ (ITRF00)_To_NAD_1983 + NAD_1983_To_HARN_Florida transformation. Tick marks at the start and end of fields ITEM6A, ITEM7, and ITEM9 Used the following field strings to remove the ticks and extra space: ITEM6A - Mid( [ITEM6A], 2, 80 ) - RTrim( [ITEM6A] ) - Replace( [ITEM6A], " '", "" ) - LTrim( [ITEM6A] ) ITEM7 - Mid( [ITEM7], 2, 80 ) - RTrim( [ITEM7] ) - Replace( [ITEM7], " '", "" ) - LTrim( [ITEM7] ) ITEM9 - Mid( [ITEM9], 2, 80 ) - RTrim( [ITEM9] ) - Replace( [ITEM9], " '", "" ) - LTrim( [ITEM9] ) Upon comparing the 2015 bridge layer with the latest update, it was discovered that all number fields were converted to text fields. The 2015 update was created using an excel spreadsheet. It is possible that when converting the spreadsheet to a shapefile the fields converted Removed 47 features as they did not have spatial reference. The Bridge_IDs for the points are: 080501000001031, 080501000003105, 080501000003106, 080501000003108, 080501000003109, 080501000003110, 080501000003111, 080501000003112, 080501000003115, 080501000003116, 080501000003117, 080501000003118, 080501000003119, 080501000003121, 080501000003122, 080501000003124, 080501000003125, 080501000003126, 080501000003127, 080501000003128, 080501000003129, 080501000003130, 080501000003131, 080501000011367, 080501000015394, 080504000001063, 080504000003108, 080504000003109, 080504000003131, 080504000003132, 080504000012190, 080504000015386, 080506000003133, 080506000003135, 080506000003136, 080506000003137, 080506000003138, 080506000003139, 080506000003140, 080506000003144, 080506000003145, 080506000003146, 080506000010490, 080506000010673, 080506000011366, 27826.005762, 27827.005762 Added BRIDGE_ID field based on ITEM8 Added DESCRIPT field, populated it based on concatenation of ITEM6A, ITEM7, and ITEM9. Used the following VB Script: [ITEM6A] & " BRIDGE" & " [" & [ITEM7] & " - " & [ITEM9] & "]" Added FGDLAQDATE and populated it based on the date GeoPlan received the data Recalculated geometry of LATDD and LONGDD Restructured table Uppercased all fields Process Date: 20170718 Conflated to TeleAtlas Road Network Process Date: Unknown Dataset copied. Process Date: 20171129

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
RITA/BTS/FHWA
1200 New Jersey Ave, SE
Washington, D.C.
20590
202-366-DATA


http://osav-usdot.opendata.arcgis.com/
answers@bts.gov
Office of Geospatial Information Systems

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