ceumicrodata / bridgehunter

bridgehunter


Forked from ScraperWiki

Contributors korenmiklos

Last run failed with status code 1.

Console output of last run

Traceback (most recent call last): File "/repo/scraper.py", line 81, in <module> for row in bridges_on_river(river): File "/repo/scraper.py", line 41, in bridges_on_river return [dict(river=river, state=bridge.split('/')[0], county=bridge.split('/')[1], bridge=bridge.split('/')[2]) for bridge in BRIDGE_REGEX.findall(urlopen(url).read())] File "/usr/lib/python2.7/urllib2.py", line 126, in urlopen return _opener.open(url, data, timeout) File "/usr/lib/python2.7/urllib2.py", line 406, in open response = meth(req, response) File "/usr/lib/python2.7/urllib2.py", line 519, in http_response 'http', request, response, code, msg, hdrs) File "/usr/lib/python2.7/urllib2.py", line 444, in error return self._call_chain(*args) File "/usr/lib/python2.7/urllib2.py", line 378, in _call_chain result = func(*args) File "/usr/lib/python2.7/urllib2.py", line 527, in http_error_default raise HTTPError(req.get_full_url(), code, msg, hdrs, fp) urllib2.HTTPError: HTTP Error 500: Internal Server Error

Data

Downloaded 1 time by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (1.26 MB) Use the API

rows 10 / 1306

Status bridge name Overview Inventory number county state Design Location Dimensions History usgs_topographic_map inventory_number inspection_as_of_05_2010_ also_called approximate_latitude_longitude average_daily_traffic_as_of_2008_ approximate_utm_coordinates recognition inspection_as_of_07_2011_ average_daily_traffic_as_of_2010_ inspection_as_of_04_2011_ average_daily_traffic_as_of_2009_ inspection_as_of_04_2010_ inspection_as_of_04_2006_ average_daily_traffic_as_of_2004_ inspection_as_of_03_2011_ average_daily_traffic_as_of_1998_ inspection_as_of_02_2010_ inspection_as_of_06_2010_ skew_angle future_prospects inspection_as_of_03_2010_ inspection_as_of_01_2011_ inspection_as_of_05_2011_ inspection_as_of_08_2011_ inspection_as_of_10_1990_ average_daily_traffic_as_of_1988_ inspection_as_of_09_2011_ inspection_as_of_10_2011_ inspection_as_of_11_2010_ inventory_numbers inspection_as_of_09_1999_ builder average_daily_traffic_as_of_1997_ average_daily_traffic_as_of_2011_ inspection_as_of_12_2011_ inspection_as_of_05_2007_ average_daily_traffic_as_of_2007_ inspection_as_of_03_1999_ average_daily_traffic_as_of_1999_ average_daily_traffic_as_of_2006_ builders inspection_as_of_10_1993_ average_daily_traffic_as_of_1993_ inspection_as_of_06_2011_ inspection_as_of_08_2007_ inspection_as_of_12_2001_ average_daily_traffic_as_of_2001_ inspection_as_of_07_1999_ inspection_as_of_04_1997_ inspection_as_of_12_2009_ inspection_as_of_11_2007_ average_daily_traffic_as_of_2005_ inspection_as_of_10_2010_ inspection_as_of_02_2012_ average_daily_traffic_as_of_2012_ inspection_as_of_03_2006_ inspection_as_of_05_2006_ inspection_as_of_05_2008_ inspection_as_of_07_2010_ inspection_as_of_03_2004_ inspection_as_of_10_1999_ average_daily_traffic_as_of_1995_ inspection_as_of_01_2006_ inspection_as_of_08_2010_ inspection_as_of_12_2010_ inspection_as_of_06_1994_ inspection_as_of_07_2005_ inspection_as_of_11_2011_ inspection_as_of_07_2007_ inspection_as_of_01_2007_ inspection_as_of_06_2007_ inspection_as_of_09_2010_ inspection_as_of_02_2011_ average_daily_traffic_as_of_1987_ inspection_as_of_08_1986_ inspection_as_of_11_1998_ inspection_as_of_07_2009_ inspection_as_of_06_2009_ inspection_as_of_10_2007_ inspection_as_of_03_2005_ inspection_as_of_04_2007_ inspection_as_of_10_2009_ inspection_as_of_07_1993_ inspection_as_of_11_2003_ inspection_as_of_08_2006_ inspection_as_of_12_2007_ inspection_as_of_06_2006_ inspection_as_of_07_2006_ average_daily_traffic_as_of_1999_34023_ inspection_as_of_04_1999_ inspection_as_of_04_2009_ inspection_as_of_09_2006_ inspection_as_of_11_1989_ average_daily_traffic_as_of_1980_ inspection_as_of_04_1981_ average_daily_traffic_as_of_1979_ inspection_as_of_11_1980_ inspection_as_of_03_1993_ inspection_as_of_01_2008_ inspection_as_of_01_2012_ inspection_as_of_11_2006_ inspection_as_of_10_2004_ inspection_as_of_12_2003_ inspection_as_of_10_2005_ inspection_as_of_12_2008_ inspection_as_of_03_2007_ inspection_as_of_10_2006_ inspection_as_of_01_2004_ inspection_as_of_02_2013_ river inspection_as_of_03_1998_ average_daily_traffic_as_of_1996_ average_daily_traffic_as_of_1991_ inspection_as_of_09_2007_ inspection_as_of_12_2006_ inspection_as_of_08_2009_ inspection_as_of_03_2009_ inspection_as_of_07_2008_ inspection_as_of_11_2009_ inspection_as_of_11_1991_ average_daily_traffic_as_of_1992_ inspection_as_of_11_2008_ inspection_as_of_07_1991_ inspection_as_of_05_2009_ inspection_as_of_03_2008_ inspection_as_of_00_2000_ inspection_as_of_10_2008_ inspection_as_of_09_2012_ elevation inspection_as_of_01_2013_ land_survey inspection_as_of_11_2004_ inspection_as_of_06_2012_ inspection_as_of_03_2012_ inspection_as_of_05_2012_ inspection_as_of_10_2012_ dec_10_1899 _1898 _1871 dec_27_2001 _1980 _1904 mar_21_1899 jan_11_1853 inspection_as_of_09_2004_ average_daily_traffic_as_of_2002_ inspection_as_of_05_1992_ inspection_as_of_04_2012_ inspection_as_of_08_2012_ inspection_as_of_03_2013_ inspection_as_of_06_1999_ average_daily_traffic_as_of_2000_ inspection_as_of_07_2012_ average_daily_traffic_as_of_1978_ inspection_as_of_09_1991_ average_daily_traffic_as_of_1971_ inspection_as_of_12_2012_ average_daily_traffic_as_of_1990_ inspection_as_of_06_2008_ inspection_as_of_1999_ inspection_as_of_04_1990_ average_daily_traffic_as_of_1989_ inspection_as_of_01_1991_ average_daily_traffic_as_of_1986_ inspection_as_of_05_1991_ average_daily_traffic_as_of_1985_ inspection_as_of_12_1989_ average_daily_traffic_as_of_2003_ inspection_as_of_09_1990_ average_daily_traffic_as_of_1970_ inspection_as_of_10_1991_ inspection_as_of_11_2012_ inspection_as_of_04_1991_ inspection_as_of_10_1998_ average_daily_traffic_as_of_2013_ inspection_as_of_01_2005_ inspection_as_of_02_2006_ inspection_as_of_01_1990_ inspection_as_of_2001_ inspection_as_of_02_2008_ inspection_as_of_01_1999_ inspection_as_of_08_1991_ inspection_as_of_05_1999_ inspection_as_of_05_1998_ inspection_as_of_05_2004_ inspection_as_of_08_1998_
ashland-covered
Ashland Covered Bridge
new-castle
de
Kennett Square
BH 37182 (Bridgehunter.com ID)
Deck condition rating: Good (7 out of 9)Superstructure condition rating: Good (7 out of 9)Substructure condition rating: Good (7 out of 9)Sufficiency rating: 75.4 (out of 100)
BR 118
+39.79806, -75.65778   (decimal degrees)39°47'53" N, 75°39'28" W   (degrees°minutes'seconds")
1,496
18/443686/4405550 (zone/easting/northing)
Posted to the National Register of Historic Places
1216329
Chambers Rock Road Bridge
new-castle
de
Newark West
BH 12286 (Bridgehunter.com ID)
+39.73280, -75.76002   (decimal degrees)39°43'58" N, 75°45'36" W   (degrees°minutes'seconds")
18/434872/4398377 (zone/easting/northing)
Eligible for the National Register of Historic Places
Deck condition rating: Good (7 out of 9)Superstructure condition rating: Satisfactory (6 out of 9)Substructure condition rating: Good (7 out of 9)Appraisal: Functionally obsolete Sufficiency rating: 44.1 (out of 100)
2,667
bh48884
Delaware River Memorial Bridge
new-castle
de
Wilmington South
BH 48884 (Bridgehunter.com ID)
+39.69222, -75.53000   (decimal degrees)39°41'32" N, 75°31'48" W   (degrees°minutes'seconds")
46,135
18/454556/4393732 (zone/easting/northing)
Deck condition rating: Satisfactory (6 out of 9)Superstructure condition rating: Good (7 out of 9)Substructure condition rating: Satisfactory (6 out of 9)Appraisal: Functionally obsolete Sufficiency rating: 68.0 (out of 100)
1515N034
Dupont Highway Bridge
new-castle
de
Saint Georges
BH 12287 (Bridgehunter.com ID)
+39.56917, -75.65472   (decimal degrees)39°34'09" N, 75°39'17" W   (degrees°minutes'seconds")
18/443763/4380145 (zone/easting/northing)
Superstructure condition rating: Satisfactory (6 out of 9)Substructure condition rating: Fair (5 out of 9)Sufficiency rating: 85.5 (out of 100)
8,303
1515S034
Dupont Highway Bridge
new-castle
de
Saint Georges
BH 12288 (Bridgehunter.com ID)
+39.56917, -75.65500   (decimal degrees)39°34'09" N, 75°39'18" W   (degrees°minutes'seconds")
18/443739/4380145 (zone/easting/northing)
Superstructure condition rating: Satisfactory (6 out of 9)Substructure condition rating: Fair (5 out of 9)Sufficiency rating: 85.8 (out of 100)
4,102
1023A231
Guyencourt Road Bridge
new-castle
de
Wilmington North
BH 12289 (Bridgehunter.com ID)
+39.81639, -75.58528   (decimal degrees)39°48'59" N, 75°35'07" W   (degrees°minutes'seconds")
18/449907/4407542 (zone/easting/northing)
105
Deck condition rating: Fair (5 out of 9)Superstructure condition rating: Good (7 out of 9)Substructure condition rating: Fair (5 out of 9)Appraisal: Functionally obsolete Sufficiency rating: 56.1 (out of 100)
1159327
James Street Bridge
new-castle
de
Wilmington South
BH 12290 (Bridgehunter.com ID)
+39.71056, -75.60889   (decimal degrees)39°42'38" N, 75°36'32" W   (degrees°minutes'seconds")
18/447806/4395809 (zone/easting/northing)
3,727
Deck condition rating: Fair (5 out of 9)Superstructure condition rating: Serious (3 out of 9)Substructure condition rating: Fair (5 out of 9)Appraisal: Structurally deficient Sufficiency rating: 36.0 (out of 100)
1608009
Kennett Pike Bridge
new-castle
de
Wilmington North
BH 12291 (Bridgehunter.com ID)
Appraisal: Functionally obsolete Sufficiency rating: 77.8 (out of 100)
+39.78167, -75.60028   (decimal degrees)39°46'54" N, 75°36'01" W   (degrees°minutes'seconds")
17,461
18/448597/4403697 (zone/easting/northing)
1229A011
Kirkwood Highway Bridge
new-castle
de
Newark East
BH 12292 (Bridgehunter.com ID)
Deck condition rating: Good (7 out of 9)Superstructure condition rating: Fair (5 out of 9)Substructure condition rating: Satisfactory (6 out of 9)Appraisal: Functionally obsolete Sufficiency rating: 65.8 (out of 100)
+39.69417, -75.72028   (decimal degrees)39°41'39" N, 75°43'13" W   (degrees°minutes'seconds")
30,907
18/438243/4394061 (zone/easting/northing)
1698B000
Lovering Avenue Bridge
new-castle
de
Wilmington North
BH 12293 (Bridgehunter.com ID)
+39.75917, -75.55833   (decimal degrees)39°45'33" N, 75°33'30" W   (degrees°minutes'seconds")
18/452173/4401176 (zone/easting/northing)
9,663
Superstructure condition rating: Satisfactory (6 out of 9)Substructure condition rating: Satisfactory (6 out of 9)Appraisal: Functionally obsolete Sufficiency rating: 78.0 (out of 100)

Statistics

Total run time: 2 minutes

Total cpu time used: less than 20 seconds

Total disk space used: 1.28 MB

History

  • Manually ran revision 052beabb and failed .
    550 records added, 5 records removed, 756 records updated in the database
  • Manually ran revision c6d92138 and failed .
    nothing changed in the database
  • Forked from ScraperWiki

Scraper code

Python

bridgehunter / scraper.py