Created
August 20, 2011 21:52
-
-
Save jmoody/1159711 to your computer and use it in GitHub Desktop.
LACBC count data schemas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| count | survey_interval | north_peds | north_bikes | south_peds | south_bikes | east_peds | east_bikes | west_peds | west_bikes | bikes_wrong_way | bikes_no_helmet | bikes_sidewalk_ride | wheelchairs | bikes_female | bikes_child | bikes_ped | occurrence_date | latitude | longitude | heading | survey_start_date | survey_end_date | surveyor_name | weather | location | north_south_street | east_west_street | surveyor_id | uuid | session_uuid | soft_session_uuid | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:23.582 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | C7EBC91D-B2C0-462E-98D4-BCF9B6CA04AC | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 2 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:24.691 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | DD4E1D74-BE25-464E-941C-00DEA4E3916F | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 3 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:24.986 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 8F829B4D-1932-4510-B774-1583F04F1C8B | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 4 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:25.170 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | F23228E5-EABE-43ED-8017-8DBFCE196FA6 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 5 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:25.341 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | E036F1D1-F25B-4DE0-8D2B-1BD3BA84ECDC | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 6 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:25.507 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 1045E59D-3E09-45B4-83BF-93235E8382F6 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 7 | 00-15 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:25.895 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 25FCBBCF-1F16-48F7-B37A-BA9EF981EFB0 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 8 | 00-15 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:26.419 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 0F34AD7F-BC27-4CA6-B2E1-85410E845726 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 9 | 00-15 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:26.828 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 5125BA7A-53DB-44AE-B8DE-DD4F50FA9DD1 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 10 | 00-15 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:27.472 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | B8A8A928-D000-4087-A31A-07BB89E06D90 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 11 | 00-15 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:27.990 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 9C9245B2-2158-4F1F-8CB9-61C0FD976281 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 12 | 00-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2011-08-20 23:37:28.559 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | 153D7377-FA9F-413C-8A74-50D7F6A94916 | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 | |
| 13 | 00-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2011-08-20 23:37:28.884 | 0 | 0 | 0 | 2011-08-20 23:37:22.908 | 2011-08-20 23:37:30.850 | Fake Name | Fake Weather with some False Clouds. Temp in the 36 C | Paris | Rue Michel Compte | Rue Beaubourg | lacbc.bikecount@gmail.com | B310652B-B30F-486A-A702-0D4AC95A125B | 590171BE-7E65-492F-8FEB-4991DEBB56F1 | lacbcbikecount--iPhoneSimulator--2011_08_20_23_37 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"name":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","rows":[{"data_point":{"location":"Paris","east_bikes":0,"uuid":"C7EBC91D-B2C0-462E-98D4-BCF9B6CA04AC","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":1,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:23.582","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"DD4E1D74-BE25-464E-941C-00DEA4E3916F","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":2,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:24.691","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"8F829B4D-1932-4510-B774-1583F04F1C8B","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":3,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:24.986","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"F23228E5-EABE-43ED-8017-8DBFCE196FA6","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":4,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:25.170","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"E036F1D1-F25B-4DE0-8D2B-1BD3BA84ECDC","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":5,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:25.341","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"1045E59D-3E09-45B4-83BF-93235E8382F6","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":6,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:25.507","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"25FCBBCF-1F16-48F7-B37A-BA9EF981EFB0","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":7,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:25.895","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":1,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"0F34AD7F-BC27-4CA6-B2E1-85410E845726","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":1,"north_bikes":0,"count":8,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:26.419","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"5125BA7A-53DB-44AE-B8DE-DD4F50FA9DD1","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":1,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":9,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:26.828","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":1,"uuid":"B8A8A928-D000-4087-A31A-07BB89E06D90","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":10,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:27.472","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"9C9245B2-2158-4F1F-8CB9-61C0FD976281","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":11,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":1,"occurrence_date":"2011-08-20 23:37:27.990","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"153D7377-FA9F-413C-8A74-50D7F6A94916","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":12,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":1,"west_peds":0,"occurrence_date":"2011-08-20 23:37:28.559","latitude":0,"bikes_sidewalk_ride":0,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}},{"data_point":{"location":"Paris","east_bikes":0,"uuid":"B310652B-B30F-486A-A702-0D4AC95A125B","survey_start_date":"2011-08-20 23:37:22.908","wheelchairs":0,"bikes_ped":0,"east_peds":0,"heading":0,"soft_session_uuid":"lacbcbikecount--iPhoneSimulator--2011_08_20_23_37","south_bikes":0,"north_bikes":0,"count":13,"north_peds":0,"west_bikes":0,"bikes_wrong_way":0,"survey_interval":"00-15","bikes_female":0,"bikes_child":0,"west_peds":0,"occurrence_date":"2011-08-20 23:37:28.884","latitude":0,"bikes_sidewalk_ride":1,"longitude":0,"bikes_no_helmet":0,"survey_end_date":"2011-08-20 23:37:30.850","surveyor_name":"Fake Name","north_south_street":"Rue Michel Compte","weather":"Fake Weather with some False Clouds. Temp in the 36 C","surveyor_id":"lacbc.bikecount@gmail.com","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}}]} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "rows": [ | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "C7EBC91D-B2C0-462E-98D4-BCF9B6CA04AC", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 1, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:23.582", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "DD4E1D74-BE25-464E-941C-00DEA4E3916F", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 2, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:24.691", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "8F829B4D-1932-4510-B774-1583F04F1C8B", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 3, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:24.986", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "F23228E5-EABE-43ED-8017-8DBFCE196FA6", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 4, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:25.170", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "E036F1D1-F25B-4DE0-8D2B-1BD3BA84ECDC", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 5, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:25.341", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "1045E59D-3E09-45B4-83BF-93235E8382F6", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 6, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:25.507", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "25FCBBCF-1F16-48F7-B37A-BA9EF981EFB0", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 7, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:25.895", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 1, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "0F34AD7F-BC27-4CA6-B2E1-85410E845726", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 1, | |
| "north_bikes": 0, | |
| "count": 8, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:26.419", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "5125BA7A-53DB-44AE-B8DE-DD4F50FA9DD1", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 1, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 9, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:26.828", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 1, | |
| "uuid": "B8A8A928-D000-4087-A31A-07BB89E06D90", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 10, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:27.472", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "9C9245B2-2158-4F1F-8CB9-61C0FD976281", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 11, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 1, | |
| "occurrence_date": "2011-08-20 23:37:27.990", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "153D7377-FA9F-413C-8A74-50D7F6A94916", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 12, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 1, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:28.559", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 0, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| }, | |
| { | |
| "data_point": { | |
| "location": "Paris", | |
| "east_bikes": 0, | |
| "uuid": "B310652B-B30F-486A-A702-0D4AC95A125B", | |
| "survey_start_date": "2011-08-20 23:37:22.908", | |
| "wheelchairs": 0, | |
| "bikes_ped": 0, | |
| "east_peds": 0, | |
| "heading": 0, | |
| "soft_session_uuid": "lacbcbikecount--iPhoneSimulator--2011_08_20_23_37", | |
| "south_bikes": 0, | |
| "north_bikes": 0, | |
| "count": 13, | |
| "north_peds": 0, | |
| "west_bikes": 0, | |
| "bikes_wrong_way": 0, | |
| "survey_interval": "00-15", | |
| "bikes_female": 0, | |
| "bikes_child": 0, | |
| "west_peds": 0, | |
| "occurrence_date": "2011-08-20 23:37:28.884", | |
| "latitude": 0, | |
| "bikes_sidewalk_ride": 1, | |
| "longitude": 0, | |
| "bikes_no_helmet": 0, | |
| "survey_end_date": "2011-08-20 23:37:30.850", | |
| "surveyor_name": "Fake Name", | |
| "north_south_street": "Rue Michel Compte", | |
| "weather": "Fake Weather with some False Clouds. Temp in the 36 C", | |
| "surveyor_id": "lacbc.bikecount@gmail.com", | |
| "session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1", | |
| "south_peds": 0, | |
| "east_west_street": "Rue Beaubourg" | |
| } | |
| } | |
| ] | |
| } |
what is the "count" field?
Are any of the fields optional?
count is position of the event: first, second, third...
re optional: no
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
count uint // (1, N)
occurrence_date datetime //
latitude decimal // (-90.0, 90.0)
longitude decimal // (0.0, 360.0)
heading decimal // (0.0, 360.0)
survey_start_date datetime //
survey_end_date datetime //
surveyor_id string // email
uuid string // uuid of the event
session_uuid string // uuid of the session
soft_session_uuid string // survey id + device name + date
survey_interval string // 00-15, 15-30, 30-45, etc