Skip to content

Instantly share code, notes, and snippets.

@jmoody

jmoody/example.csv - lacbcbikecount--iPhoneSimulator--2011_08_20_23_37.csv

Created August 20, 2011 21:52
Show Gist options
  • Save jmoody/1159711 to your computer and use it in GitHub Desktop.
Save jmoody/1159711 to your computer and use it in GitHub Desktop.
Download ZIP
LACBC count data schemas
Raw
example.csv - lacbcbikecount--iPhoneSimulator--2011_08_20_23_37.csv
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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] B310652B-B30F-486A-A702-0D4AC95A125B 590171BE-7E65-492F-8FEB-4991DEBB56F1 lacbcbikecount--iPhoneSimulator--2011_08_20_23_37
Raw
example.json
{"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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","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":"[email protected]","session_uuid":"590171BE-7E65-492F-8FEB-4991DEBB56F1","south_peds":0,"east_west_street":"Rue Beaubourg"}}]}
Raw
pretty-example.json
{
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"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": "[email protected]",
"session_uuid": "590171BE-7E65-492F-8FEB-4991DEBB56F1",
"south_peds": 0,
"east_west_street": "Rue Beaubourg"
}
}
]
}
@jmoody
Copy link
Author

jmoody commented Aug 21, 2011

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

@michaelkirk
Copy link

what is the "count" field?

Are any of the fields optional?

@jmoody
Copy link
Author

jmoody commented Aug 21, 2011

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