{"action":"closed","issue":{"url":"https://api.github.com/repos/osu-cascades/cs160-zagster-service/issues/9","repository_url":"https://api.github.com/repos/osu-cascades/cs160-zagster-service","labels_url":"https://api.github.com/repos/osu-cascades/cs160-zagster-service/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/osu-cascades/cs160-zagster-service/issues/9/comments","events_url":"https://api.github.com/repos/osu-cascades/cs160-zagster-service/issues/9/events","html_url":"https://github.com/osu-cascades/cs160-zagster-service/issues/9","id":379606517,"node_id":"MDU6SXNzdWUzNzk2MDY1MTc=","number":9,"title":"total count of rides for station- Columbia/Simpson Parking Lot","user":{"login":"FelipeCArreola","id":43622171,"node_id":"MDQ6VXNlcjQzNjIyMTcx","avatar_url":"https://avatars2.githubusercontent.com/u/43622171?v=4","gravatar_id":"","url":"https://api.github.com/users/FelipeCArreola","html_url":"https://github.com/FelipeCArreola","followers_url":"https://api.github.com/users/FelipeCArreola/followers","following_url":"https://api.github.com/users/FelipeCArreola/following{/other_user}","gists_url":"https://api.github.com/users/FelipeCArreola/gists{/gist_id}","starred_url":"https://api.github.com/users/FelipeCArreola/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FelipeCArreola/subscriptions","organizations_url":"https://api.github.com/users/FelipeCArreola/orgs","repos_url":"https://api.github.com/users/FelipeCArreola/repos","events_url":"https://api.github.com/users/FelipeCArreola/events{/privacy}","received_events_url":"https://api.github.com/users/FelipeCArreola/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-12T03:26:22Z","updated_at":"2018-11-12T05:32:43Z","closed_at":"2018-11-12T05:32:43Z","author_association":"NONE","body":"'/rides/columbia_simpson_pl-station/total_count/'\r\n\r\n'I would like a total count of rides by station(Columbia/Simpson Parking Lot), since Zagster Bike Share began in Bend starting in 2016.'\r\n\r\n\tAttempted at clustering data.\r\n\t\tColumbia/Simpson Parking Lot-Station:\r\n\r\n\tSELECT COUNT(*)\r\n\t\tFROM `rides`\r\n    \t\t\tWHERE `start_lon` BETWEEN -121.32598 AND -121.32534 \r\n        \t\t\tIN\r\n\t\t\t\t(SELECT *\r\n\t\t\t\t\tFROM `rides`\r\n\t\t\t\t\t\tWHERE `start_time` IS NOT NULL AND `end_time` IS NOT NULL \r\n\t\t\t\t\t\t\tAND `start_lat` IS NOT NULL AND `start_lon` IS NOT NULL \r\n\t\t\t\t\t\t\tAND `end_lat` IS NOT NULL AND `end_lon` IS NOT NULL \r\n\t\t\t\t\t\t\tAND `start_lat` BETWEEN 44.048745 AND 44.049205);\r\n\r\nRange:\r\nLat:  44.048745 | 44.049205\r\nLon:  -121.32598 | -121.32534\r\n\r\n\r\n{\"station\": \"columbia_simpson_pl\", \"total_count\" : '#OfTotalCount'}"}}
{"actor":{"display_login":"ybakos"}}