OPEN DATA USA BRIDGES

Golden Gate Bridge Accelerometer Data

Accelerometer Data collected by Android’s Physics Toolbox Suite on 12 May 2018

https://www.kaggle.com/mrcity/golden-gate-accel-20180512

Golden Gate Bridge Accelerometer Data Accelerometer Data collected by Android’s Physics Toolbox Suite on 12 May 2018www.kaggle.com

Context

I got the chance to walk across the Golden Gate Bridge in San Francisco, CA for the first time in 22 years on May 12, 2018. There have been a great many technological advancements since then, as now we are all walking around with powerful computers and sensors in our pockets. I decided it would be fun to measure the bridge and provide others the opportunity to analyze data as to its motion for a brief snippet of time.

Content

This is one minute of data from the “Linear Accelerometer” of the Physics Toolbox Suite v1.8.6 for Android. The data was collected from a Pixel 2 phone on the east side of the Golden Gate Bridge at the midpoint between the two towers of the bridge at approximately 3:20 PM local time on May 12, 2018.

Acknowledgments

This dataset is hereby owned by the community under the terms of a very lenient license in the condition that I have published it shortly after recording it.

Golden Gate Bridge G-Force Data

G-Force Data collected by Android’s Physics Toolbox Suite on 12 May 2018

https://www.kaggle.com/mrcity/golden-gate-gforce-20180512

Golden Gate Bridge G-Force DataG-Force Data collected by Android’s Physics Toolbox Suite on 12 May 2018 http://www.kaggle.com

Context

I got the chance to walk across the Golden Gate Bridge in San Francisco, CA for the first time in 22 years on May 12, 2018. There have been a great many technological advancements since then, as now we are all walking around with powerful computers and sensors in our pockets. I decided it would be fun to measure the bridge and provide others the opportunity to analyze data as to its motion for a brief snippet of time.

Content

This is one minute of data from the “g-force Meter” of the Physics Toolbox Suite v1.8.6 for Android. The data was collected from a Pixel 2 phone on the east side of the Golden Gate Bridge at the midpoint between the two towers of the bridge at approximately 3:15 PM local time on May 12, 2018.

Acknowledgments

This dataset is hereby owned by the community under the terms of a very lenient license in the condition that I have published it shortly after recording it.

Inspiration

Maybe this will inspire people to install sensors on the bridge, and other bridges, to monitor for things such as traffic (such as to find an optimum speed limit), dangerous fatigue, or dangerous wind conditions. At the very least, one could use this in comparison with a baseline stable motion to see how the bridge shakes. One could study effects of vehicles traversing the bridge (not that there’s any visual data for when that happened relative to this dataset, but I do believe at least one big bus drove by my device during this recording). One could study if there are periodic vibrations, and if so, at what frequencies. This would be even more interesting if correlated with wind data and run compared to several different wind speeds.

NY BRIDGES EAST RIVER BICYCLE CROSSINGS

https://www.kaggle.com/new-york-city/nyc-east-river-bicycle-crossings

New York City – East River Bicycle Crossings | Kaggle Context. The New York City Department of Transportation collects daily data about the number of bicycles going over bridges in New York City. This data is used to measure bike utilization as a part of transportation planning.www.kaggle.com

Context

The New York City Department of Transportation collects daily data about the number of bicycles going over bridges in New York City. This data is used to measure bike utilization as a part of transportation planning. This dataset is a daily record of the number of bicycles crossing into or out of Manhattan via one of the East River bridges (that is, excluding Bronx thruways and the non-bikeable Hudson River tunnels) for a stretch of 9 months.

Content

A count of the number of bicycles on each of the bridges in question is provided on a day-by-day basis, along with information on maximum and minimum temperature and precipitation.

Acknowledgements

This data is published in an Excel format by the City of New York (here). It has been processed into a CSV file for use on Kaggle.

Inspiration

  • In this dataset, how many bicycles cross into and out of Manhattan per day?
  • How strongly do weather conditions affect bike volumes?
  • What is the top bridge in terms of bike load?

https://data.cityofnewyork.us/Transportation/Bicycle-Counts-for-East-River-Bridges/gua4-p9wgCSV

OPEN DATA NEW YORK

OPEN DATASETS NEW YORK
https://data.ny.gov/

State of New York | Open Data | State of New York Browse, download, and analyze COVID-19-related data from the New York State Department of Health. The data will be updated on a daily basis.data.ny.gov

Brooklyn Bridge Datasets
https://data.ny.gov/browse?q=brooklyn%20bridge&sortBy=relevance
https://data.ny.gov/Transportation/Hourly-Traffic-on-Metropolitan-Transportation-Auth/qzve-kjga

Hourly Traffic on Metropolitan Transportation Authority (MTA) Bridges and Tunnels: Beginning 2010

Transportation View Data This dataset provides data showing the number of vehicles (including cars, buses, trucks and motorcycles) that pass through each of the bridges and tunnels operated by the MTA each hour of the day. The data is updated weekly.API https://data.ny.gov/resource/qzve-kjga.json

Hourly Traffic on Metropolitan Transportation Authority (MTA) Bridges and Tunnels: Beginning 2010 | State of New York – State of New York | Open Data | State of New York DATA.NY.GOV.

https://data.ny.gov/Transportation/Daily-Traffic-on-Metropolitan-Transportation-Autho/cwhc-n4ek

Daily Traffic on Metropolitan Transportation Authority (MTA) Bridges and Tunnels: Beginning 2010

View based on Hourly Traffic on Metropolitan Transportation Authority (MTA) Bridges and Tunnels: Beginning 2010Transportation View Data This dataset provides data showing the number of vehicles (including cars, buses, trucks and motorcycles) that pass through each of the bridges and tunnels operated by the MTA each hour of the day. The data is updated weekly.API https://data.ny.gov/resource/cwhc-n4ek.json

Brooklyn Bridge Automated Pedestrian Counts Demonstration Project

Transportation View Data DOT is testing automated technology to count pedestrians. The counter is located on the Manhattan approach of the Brooklyn Bridge. https://data.cityofnewyork.us/Transportation/Brooklyn-Bridge-Automated-Pedestrian-Counts-Demons/6fi9-q3ta
Columns in this Dataset

Column NameDescriptionType
hour_beginningDate and time of hourly countDate & Time
locationName of site where count was obtainedPlain Text
PedestriansTotal count (sum of directions)Number
Towards ManhattanPedestrians crossing towards ManhattanNumber
Towards BrooklynPedestrian crossing towards BrooklynNumber
weather_summaryOverall daily weather (cloudy, clear, rain, etc.)Plain Text
temperatureHourly temperature, in Fahrenheit degreesNumber

PITTSBURGH BRIDGE DATA

Pittsburgh Bridges on Kaggle

https://www.kaggle.com/davorbudimir/pittsburg-bridges

SOCRATA OPEN DATA

Socrata Open Data Transparency Information

https://www.tylertech.com/products/socrata
https://www.tylertech.com/resources/case-studies/pittsburghs-commitment-to-transparency

Corporate Headquarters
5101 Tennyson Parkway
Plano, Texas 75024
972-713-3700
info@tylertech.com https://www.tylertech.com/resources/case-studies/pittsburghs-commitment-to-transparency

Pittsburgh’s Commitment to Transparency – tylertech As with most cities, Pittsburgh is swimming in data. And while having this large quantity of details, databases, and stats can be advantageous, it can also overwhelm, especially if the data isn’t readily accessible. Data might be stashed in binders, files, or siloed on an employee’s desktop. However, by implementing a modern approach to its data management and analysis systems …www.tylertech.com

NY Dept of Transport Bridge Conditions

Explore Open Data from New York State

https://www.kaggle.com/new-york-state/nys-dept-of-transportation-bridge-conditions

Content

New York State inspectors assess all of the bridges every two years including a bridge’s individual parts. Bridges are analyzed for their capacity to carry vehicular loads. Inspectors are required to evaluate, assign a condition score, and document the condition of up to 47 structural elements, including rating 25 components of each span of a bridge, in addition to general components common to all bridges. The NYSDOT condition rating scale ranges from 1 to 7, with 7 being in new condition and a rating of 5 or greater considered as good condition. Bridges that cannot safely carry heavy vehicles, such as some tractor trailers, are posted with weight limits. Based upon inspection and load capacity analysis, any bridge deemed unsafe gets closed.

Context

This is a dataset hosted by the State of New York. The state has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York State using Kaggle and all of the data sources available through the State of New York organization page!

  • Update Frequency: This dataset is updated annually.

Acknowledgements

This dataset is maintained using Socrata’s API and Kaggle’s API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Ben Dumond on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Seattle Spokane St Bridge Counter

From City of Seattle Open Data

https://www.kaggle.com/city-of-seattle/seattle-spokane-st-bridge-counter
https://data.seattle.gov/

City of Seattle Open Data portal© 2021 City of Seattle. Powered Bydata.seattle.gov

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s