Source Data for Crowdsourcing Bridge Dynamic Monitoring with Smartphone Vehicle Trips
Data files
Nov 02, 2022 version files 1.08 GB
-
Fig2a.xls
47.81 MB
-
Fig2b-c.xls
3.35 MB
-
FigureSourceData.xlsx
223.96 KB
-
iPhone_RawData_FileList.xlsx
13.90 KB
-
mlt_20170619_083708_300.csv
7.27 MB
-
mlt_20170619_083710_295.csv
6.96 MB
-
mlt_20170619_084733_231.csv
5.60 MB
-
mlt_20170619_084739_227.csv
5.35 MB
-
mlt_20170619_085416_239.csv
5.72 MB
-
mlt_20170619_085420_240.csv
5.67 MB
-
mlt_20170619_090008_232.csv
5.62 MB
-
mlt_20170619_090010_232.csv
5.50 MB
-
mlt_20170619_090703_239.csv
5.78 MB
-
mlt_20170619_090706_238.csv
5.63 MB
-
mlt_20170619_091303_247.csv
5.99 MB
-
mlt_20170619_091305_249.csv
5.88 MB
-
mlt_20170619_092023_260.csv
6.29 MB
-
mlt_20170619_092032_254.csv
6.05 MB
-
mlt_20170619_092645_222.csv
5.39 MB
-
mlt_20170619_092649_224.csv
5.30 MB
-
mlt_20170619_093327_271.csv
6.54 MB
-
mlt_20170619_093329_271.csv
6.41 MB
-
mlt_20170619_093948_258.csv
6.26 MB
-
mlt_20170619_093950_258.csv
6.11 MB
-
mlt_20170619_161642_272.csv
6.58 MB
-
mlt_20170619_161652_263.csv
6.24 MB
-
mlt_20170619_162333_268.csv
6.50 MB
-
mlt_20170619_162337_267.csv
6.32 MB
-
mlt_20170619_163145_253.csv
6.15 MB
-
mlt_20170619_163147_254.csv
6.05 MB
-
mlt_20170619_163759_251.csv
6.09 MB
-
mlt_20170619_163801_252.csv
5.97 MB
-
mlt_20170619_164557_248.csv
6.02 MB
-
mlt_20170619_164559_249.csv
5.88 MB
-
mlt_20170619_165223_253.csv
6.14 MB
-
mlt_20170619_165225_254.csv
6.02 MB
-
mlt_20170619_170012_217.csv
5.25 MB
-
mlt_20170619_170013_218.csv
5.20 MB
-
mlt_20170619_170558_226.csv
5.48 MB
-
mlt_20170619_170601_226.csv
5.33 MB
-
mlt_20170619_171309_218.csv
5.30 MB
-
mlt_20170619_171313_216.csv
5.14 MB
-
mlt_20170619_173437_225.csv
5.45 MB
-
mlt_20170619_173439_225.csv
5.33 MB
-
mlt_20170620_082723_221.csv
5.35 MB
-
mlt_20170620_082726_220.csv
5.23 MB
-
mlt_20170620_083312_186.csv
4.52 MB
-
mlt_20170620_083314_185.csv
4.38 MB
-
mlt_20170620_083919_199.csv
4.81 MB
-
mlt_20170620_083921_199.csv
4.73 MB
-
mlt_20170620_084441_216.csv
5.26 MB
-
mlt_20170620_084443_216.csv
5.11 MB
-
mlt_20170620_085125_201.csv
4.87 MB
-
mlt_20170620_085127_200.csv
4.77 MB
-
mlt_20170620_085643_164.csv
3.99 MB
-
mlt_20170620_085645_164.csv
3.90 MB
-
mlt_20170620_090211_158.csv
3.85 MB
-
mlt_20170620_090214_157.csv
3.74 MB
-
mlt_20170620_090650_154.csv
3.76 MB
-
mlt_20170620_090652_155.csv
3.69 MB
-
mlt_20170620_091127_164.csv
3.98 MB
-
mlt_20170620_091131_162.csv
3.87 MB
-
mlt_20170620_091612_161.csv
3.91 MB
-
mlt_20170620_091614_161.csv
3.83 MB
-
mlt_20170620_163643_256.csv
6.20 MB
-
mlt_20170620_163649_253.csv
6.01 MB
-
mlt_20170620_164554_284.csv
6.91 MB
-
mlt_20170620_164556_267.csv
6.31 MB
-
mlt_20170620_165753_182.csv
4.31 MB
-
mlt_20170620_165756_174.csv
4.22 MB
-
mlt_20170620_170307_205.csv
4.97 MB
-
mlt_20170620_170310_206.csv
4.89 MB
-
mlt_20170620_171758_165.csv
4.01 MB
-
mlt_20170620_171804_162.csv
3.85 MB
-
mlt_20170620_172232_157.csv
3.80 MB
-
mlt_20170620_172233_156.csv
3.70 MB
-
mlt_20170620_173042_155.csv
3.76 MB
-
mlt_20170620_173044_155.csv
3.66 MB
-
mlt_20170620_173516_156.csv
3.79 MB
-
mlt_20170620_173517_156.csv
3.69 MB
-
mlt_20170620_174448_145.csv
3.51 MB
-
mlt_20170620_174451_143.csv
3.40 MB
-
mlt_20170620_175944_163.csv
3.94 MB
-
mlt_20170620_175945_163.csv
3.85 MB
-
mlt_20170621_084738_209.csv
5.04 MB
-
mlt_20170621_084740_210.csv
4.93 MB
-
mlt_20170621_085256_219.csv
5.30 MB
-
mlt_20170621_085258_222.csv
5.22 MB
-
mlt_20170621_085855_175.csv
4.21 MB
-
mlt_20170621_085856_175.csv
4.12 MB
-
mlt_20170621_090352_174.csv
4.22 MB
-
mlt_20170621_090354_174.csv
4.10 MB
-
mlt_20170621_090931_142.csv
3.44 MB
-
mlt_20170621_090933_143.csv
3.38 MB
-
mlt_20170621_091347_142.csv
3.45 MB
-
mlt_20170621_091350_143.csv
3.33 MB
-
mlt_20170621_091803_157.csv
3.76 MB
-
mlt_20170621_091807_154.csv
3.66 MB
-
mlt_20170621_092212_162.csv
3.95 MB
-
mlt_20170621_092214_161.csv
3.82 MB
-
mlt_20170621_092636_175.csv
4.24 MB
-
mlt_20170621_092637_176.csv
4.17 MB
-
mlt_20170621_093123_411.csv
9.92 MB
-
mlt_20170621_093126_405.csv
9.56 MB
-
mlt_20170621_161933_196.csv
4.64 MB
-
mlt_20170621_161936_197.csv
4.78 MB
-
mlt_20170621_162657_180.csv
4.26 MB
-
mlt_20170621_162704_177.csv
4.29 MB
-
mlt_20170621_163206_212.csv
5.01 MB
-
mlt_20170621_163210_212.csv
5.15 MB
-
mlt_20170621_163903_300.csv
7.11 MB
-
mlt_20170621_163906_302.csv
7.31 MB
-
mlt_20170621_164656_206.csv
4.88 MB
-
mlt_20170621_164701_206.csv
5 MB
-
mlt_20170621_165333_177.csv
4.19 MB
-
mlt_20170621_165335_177.csv
4.30 MB
-
mlt_20170621_165859_207.csv
4.90 MB
-
mlt_20170621_165902_208.csv
5.05 MB
-
mlt_20170621_170622_246.csv
5.82 MB
-
mlt_20170621_170627_245.csv
5.93 MB
-
mlt_20170621_171328_209.csv
4.94 MB
-
mlt_20170621_171332_209.csv
5.07 MB
-
mlt_20170621_172104_255.csv
6.02 MB
-
mlt_20170621_172107_256.csv
6.20 MB
-
mlt_20170622_083339_204.csv
4.81 MB
-
mlt_20170622_083341_205.csv
4.97 MB
-
mlt_20170622_083916_205.csv
4.84 MB
-
mlt_20170622_083919_205.csv
4.96 MB
-
mlt_20170622_084443_161.csv
3.80 MB
-
mlt_20170622_084446_161.csv
3.91 MB
-
mlt_20170622_084919_178.csv
4.20 MB
-
mlt_20170622_084923_178.csv
4.32 MB
-
mlt_20170622_085503_209.csv
4.94 MB
-
mlt_20170622_085507_209.csv
5.09 MB
-
mlt_20170622_090033_195.csv
4.61 MB
-
mlt_20170622_090039_195.csv
4.73 MB
-
mlt_20170622_090600_205.csv
4.87 MB
-
mlt_20170622_090604_206.csv
4.99 MB
-
mlt_20170622_091143_165.csv
3.92 MB
-
mlt_20170622_091148_164.csv
3.98 MB
-
mlt_20170622_091659_165.csv
3.92 MB
-
mlt_20170622_091702_165.csv
4.01 MB
-
mlt_20170622_092155_247.csv
5.82 MB
-
mlt_20170622_092159_247.csv
5.99 MB
-
mlt_20170622_170547_256.csv
6.05 MB
-
mlt_20170622_170551_257.csv
6.24 MB
-
mlt_20170622_171534_268.csv
6.32 MB
-
mlt_20170622_171537_268.csv
6.51 MB
-
mlt_20170622_172224_256.csv
6.06 MB
-
mlt_20170622_172227_258.csv
6.25 MB
-
mlt_20170622_173043_278.csv
6.56 MB
-
mlt_20170622_173047_278.csv
6.73 MB
-
mlt_20170622_173828_258.csv
6.10 MB
-
mlt_20170622_173832_259.csv
6.28 MB
-
mlt_20170622_174535_264.csv
6.25 MB
-
mlt_20170622_174540_263.csv
6.39 MB
-
mlt_20170622_180026_262.csv
6.19 MB
-
mlt_20170622_180027_269.csv
6.51 MB
-
mlt_20170622_180703_209.csv
4.94 MB
-
mlt_20170622_180706_210.csv
5.09 MB
-
mlt_20170622_181334_219.csv
5.18 MB
-
mlt_20170622_181338_218.csv
5.30 MB
-
mlt_20170622_181928_890.csv
20.78 MB
-
mlt_20170622_181934_232.csv
5.62 MB
-
mlt_20170623_091848_215.csv
5.11 MB
-
mlt_20170623_091859_207.csv
5.03 MB
-
mlt_20170623_092432_213.csv
5.04 MB
-
mlt_20170623_092435_213.csv
5.18 MB
-
mlt_20170623_093042_183.csv
4.35 MB
-
mlt_20170623_093045_183.csv
4.45 MB
-
mlt_20170623_093532_164.csv
3.90 MB
-
mlt_20170623_093536_165.csv
4.01 MB
-
mlt_20170623_094100_162.csv
3.84 MB
-
mlt_20170623_094105_160.csv
3.85 MB
-
mlt_20170623_094537_162.csv
3.84 MB
-
mlt_20170623_094540_162.csv
3.93 MB
-
mlt_20170623_095029_157.csv
3.74 MB
-
mlt_20170623_095032_157.csv
3.82 MB
-
mlt_20170623_095503_144.csv
3.42 MB
-
mlt_20170623_095506_145.csv
3.51 MB
-
mlt_20170623_095935_139.csv
3.33 MB
-
mlt_20170623_095938_140.csv
3.41 MB
-
mlt_20170623_100353_210.csv
4.98 MB
-
mlt_20170623_100358_209.csv
5.07 MB
-
mlt_20170623_172359_251.csv
5.96 MB
-
mlt_20170623_172403_252.csv
6.12 MB
-
mlt_20170623_173130_206.csv
4.88 MB
-
mlt_20170623_173135_205.csv
4.98 MB
-
mlt_20170623_173903_164.csv
3.90 MB
-
mlt_20170623_173907_163.csv
3.97 MB
-
mlt_20170623_174418_251.csv
5.93 MB
-
mlt_20170623_174421_251.csv
6.08 MB
-
mlt_20170623_175054_150.csv
3.56 MB
-
mlt_20170623_175057_150.csv
3.65 MB
-
mlt_20170623_175607_183.csv
4.32 MB
-
mlt_20170623_175610_183.csv
4.45 MB
-
mlt_20170623_180106_137.csv
3.26 MB
-
mlt_20170623_180109_137.csv
3.34 MB
-
mlt_20170623_180546_179.csv
4.23 MB
-
mlt_20170623_180549_179.csv
4.35 MB
-
mlt_20170623_181044_152.csv
3.60 MB
-
mlt_20170623_181047_154.csv
3.74 MB
-
mlt_20170623_181456_145.csv
3.42 MB
-
mlt_20170623_181459_145.csv
3.52 MB
-
mlt_20170623_182022_180.csv
4.28 MB
-
mlt_20170623_182025_181.csv
4.41 MB
-
mlt_20170623_182528_148.csv
3.51 MB
-
mlt_20170623_182531_149.csv
3.61 MB
-
README.txt
1.99 KB
Abstract
This data accompanies the study "Crowdsourcing Bridge Dynamic Monitoring with Smartphone Vehicle Trips" published in (Nature) Communications Engineering. This paper focuses on using large and inexpsensive datasets for obtaining information on the dynamics of bridges. In this study, data is collected by smartphones in moving vehicles as the cross over a bridge, in three distinct applications. Smartphone data was collected in controlled field experiments and uncontrolled Uber rides on a long-span suspension bridge in the USA (The Golden Gate Bridge) and an analytical method was developed to accurately recover modal properties. The method was also successfully applied to partially-controlled crowdsourced data collected on a short-span highway bridge in Italy. The results suggest that larve and inexpensive datasets collected by smartphones could play a role in monitoring the health of existing transportation infrastructure.
The data provided includes the source data for the figures in the publication as well as the "controlled data" referenced in the study.
Methods
All data were recorded by an iPhone 5 and iPhone 6 using the Sensor Play App. Two-hundred and four datasets (102 per phone) were collected during vehicle trips over the Golden Gate Bridge in morning and afternoon rush-hour periods over five days (June 18 - 22, 2017). The positions and orientations of the phones were fixed during data collection. The operator manually hit "record" on each phones at the approach of the bridge and hit "stop" at the end of the bridge -- the data is not syncrhonized.
Two sedan-style vehicles were used and five target speeds were defined: 32, 40, 48, 56, and 64 km/hr (note the speed limit on the bridge is 72 km/hr). Datasets 1-50 were collected by a Nissan sedan, and datasets 51-102 were collected by a Ford sedan.
Each dataset is provided as a CSV file with twenty-four channels of raw data including timestamps, the default output for the Sensor Play App:
- Accelerometer: X, Y, Z
- Gyroscope: X, Y, Z
- Attitude: Roll, Pitch, Yaw
- Location: Longitude, Latitude, Speed, TrueHeading, Altitude
- Motion Activity: Type & Confidence
- Barometer: Pressure, Relative Altitude
- Magnetometer: µT X, Y, Z, calibrated x,y,z,
The referenced study "Crowdsourcing Bridge Dynamic Monitoring with Smartphone Vehicle Trips" only analyzed vertical acceleration (acceleration in the Z-direction) and GPS lat-long channels, which were sampled at 100 Hz and 1 Hz, respectively.
Further details of the data and analysis are available in the Methods section of "Crowdsourcing Bridge Dynamic Monitoring with Smartphone Vehicle Trips".
Source data is provided for figures 2, 3, 4, 5, and 7 in the Main Text of "Crowdsourcing Bridge Dynamic Monitoring with Smartphone Vehicle Trips" and figures S1, S2, and S3 of the Supplementary Material
Usage notes
XLS, XLSX, and CSV files