Skip to content

Instantly share code, notes, and snippets.

@jonahadkins

jonahadkins/nbi_sample.csv

Created March 18, 2016 21:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jonahadkins/046a922d5b0e9ab0d40c to your computer and use it in GitHub Desktop.
Save jonahadkins/046a922d5b0e9ab0d40c to your computer and use it in GitHub Desktop.
Download ZIP
nbi sample data
Raw
nbi_sample.csv
STATE_CODE_001 STRUCTURE_NUMBER_008 COUNTY_CODE_003 FEATURES_DESC_006A latitude longitude OWNER_022 FUNCTIONAL_CLASS_026 YEAR_BUILT_027 ADT_029 YEAR_ADT_030 OPEN_CLOSED_POSTED_041 STRUCTURE_TYPE_043B OPR_RATING_METH_063 OPERATING_RATING_064 INV_RATING_METH_065 INVENTORY_RATING_066 YEAR_RECONSTRUCTED_106 PERCENT_ADT_TRUCK_109 FUTURE_ADT_114 YEAR_OF_FUTURE_ADT_115 SUFFICIENCY_RATING
22 AFLAAWUB06103 15 Macks Bayou 32313200 934032238 72 14 1998 2000 2008 P 1 0 32.4 0 32.4 0 5 6500 2030 92.5
55 P48005000000000 95 APPLE RIVER 45272460 921849800 3 9 1978 440 1998 P 1 1 34 1 22.7 0 0 440 2031 84.2
26 13699 3 WERNERS CREEK 46095980 870402900 21 9 1922 5 2013 A 2 8 55.7 8 43.1 1980 0 6 2033 48
18 1IN3365 101 Turkey Creek 38510620 867475990 73 9 2003 600 2008 A 19 1 54.4 1 32.6 0 10 650 2029 98.6
24 200000F-0701010 21 BENNETT CREEK 39175100 772433000 2 8 1965 1031 2007 A 2 1 55.3 1 32.7 5 1532 2027 90.2
24 200000F-2604010 21 MONOCACY RIVER 39284800 772317000 2 8 1970 3977 2009 A 2 1 51.7 1 30.8 15 10152 2032 90.7
24 200000F-0511010 21 TOMS CREEK ' 39380000 771700000 2 9 2006 45 2007 A 10 1 58 1 34.5 2 67 2032 83.5
11 2 1 C&O CANAL 38541800 770380000 1 17 1831 7400 2006 A 11 1 67.1 1 39.9 2006 1 8500 2026 92.3
11 10 1 VIRGINIA AVENUE N.W. 38534154 770300570 1 14 1942 20500 2007 A 2 1 86.8 1 52.3 2002 2 20500 2026 92
11 1205 1 INNER LOOP 38534200 770300000 1 11 1964 17500 1992 A 2 1 50.8 1 30.8 0 1 17500 2015 84.5
11 1113(TUNNEL) 1 12TH STREET 38525400 770170000 1 11 1959 150600 2007 A 18 1 62.6 1 37.2 0 4 165000 2027 61
11 1019(NB) 1 NAVAL RESEARCH LAB ROAD 38492400 770100000 1 11 1960 61500 2007 A 2 1 68 1 40.8 2004 5 62500 2027 90.1
11 1019(SB) 1 NAVAL RESEARCH LAB ROAD 38492400 770100000 1 11 1960 61500 2007 A 2 1 72.6 1 43.5 2004 5 62500 2027 91.2
11 1104(RAMP D) 1 SOUTH CAPITOL STREET 38524800 770060000 1 11 1963 25000 1996 A 2 1 64.4 1 39 1991 5 20000 2015 95.7
11 1014(SB) 1 Malcom X. Avenue 38504200 770040000 1 11 1963 42400 2007 A 2 1 87.1 1 52.6 2007 5 45000 2027 90.9
11 0053(RAMP B) 1 APPROACHES- S CAP ST BRI 38551800 770030000 1 12 1950 3900 2007 A 2 1 53.5 1 32.7 1977 4 4500 2027 81
24 200000P-0487010 33 PISCATAWAY CREEK 28421200 765828130 2 17 1932 5850 2007 P 4 5 39 5 26.3 1989 10 8700 2027 59.6
11 233 1 ANACOSTIA RIVER & PARK R 38532400 765790000 1 12 1955 42100 2007 A 3 1 51.7 1 30.8 1980 3 45000 2027 73.4
11 0019-1(HIGH) 1 WATTS BRANCH 38540600 765670000 1 12 1956 102600 2007 A 2 1 89.8 1 67.1 2009 3 105000 2027 100
24 200000P-0482010 33 MATAPONI CREEK 38441409 764311730 2 8 2011 72 2007 A 2 1 56.2 1 33.6 1 120 2027 100
24 200000P-0498010 33 MATAPONI CREEK 38441409 764311730 2 8 2011 72 2007 A 2 1 55.3 1 32.7 5 120 2027 100
24 200000B-0511020 5 GOODWIN RUN 39272000 763840000 2 19 1997 15000 2009 A 19 2 83 2 49 0 10 18000 2029 83.3
24 200000SM0002020 37 MCINTOSH RUN 38201237 763755998 2 9 1984 2500 2004 A 19 5 73.5 5 43.5 0 5 4500 2030 97.3
24 200000B-0500010 5 UNNAMED STREAM 39225000 762850000 2 19 2005 2500 2005 A 11 2 99 2 69 0 5 5000 2025 85.7
24 200000K-0003010 29 WEST FORK LANGFORD CREEK 39116390 761041400 2 9 1991 250 2008 A 1 5 67.1 5 47.2 0 10 350 2028 99.9
24 1.00E+14 33 I-95 3905560 760534586 1 14 2013 9800 2009 A 2 8 44.1 8 35.3 0 11 40400 2030 96.2
24 200000K-0013010 29 CYPRESS BRANCH 39171866 754727720 2 9 1968 250 2008 P 2 5 40.8 5 24.5 0 10 350 2028 91.6
33 AFNHRNGF00243 11 Gardner-Joe English Strm 42561858 713827113 72 9 1957 10 2011 A 19 2 9.1 2 9.1 0 0 2028 41
33 AFNHRNGF00241 11 Joe English Pond 42561306 713813228 72 9 1965 10 2011 A 2 2 40.8 2 40.8 2008 0 0 2028 53
33 AFNHRNGF00240 11 Joe English Brook 42554382 713746624 72 9 1965 10 2011 A 2 2 40.8 2 40.8 2008 0 0 2028 53
24 200000WO0601010 47 NASSAWANGO CREEK 38154578 705274592 2 9 2001 155 2010 A 1 2 84.4 2 62.1 0 5 170 2030 88.8
23 201 5 E BRANCH ROYAL RIVER 43532700 700090100 1 9 1999 314 2012 A 19 1 57.1 1 40.8 0 5 471 2032 99.9
23 902 19 MILLINOCKET STREAM 46391110 684235500 1 17 1937 1790 2012 A 2 2 32.7 2 10 0 5 2685 2032 42
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment