{"action":"created","issue":{"url":"https://api.github.com/repos/remulasce/metroapp/issues/229","labels_url":"https://api.github.com/repos/remulasce/metroapp/issues/229/labels{/name}","comments_url":"https://api.github.com/repos/remulasce/metroapp/issues/229/comments","events_url":"https://api.github.com/repos/remulasce/metroapp/issues/229/events","html_url":"https://github.com/remulasce/metroapp/issues/229","id":72574941,"number":229,"title":"NexTrip scraper doesn't check for duplicate stops properly.","user":{"login":"remulasce","id":1064048,"avatar_url":"https://avatars.githubusercontent.com/u/1064048?v=3","gravatar_id":"","url":"https://api.github.com/users/remulasce","html_url":"https://github.com/remulasce","followers_url":"https://api.github.com/users/remulasce/followers","following_url":"https://api.github.com/users/remulasce/following{/other_user}","gists_url":"https://api.github.com/users/remulasce/gists{/gist_id}","starred_url":"https://api.github.com/users/remulasce/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/remulasce/subscriptions","organizations_url":"https://api.github.com/users/remulasce/orgs","repos_url":"https://api.github.com/users/remulasce/repos","events_url":"https://api.github.com/users/remulasce/events{/privacy}","received_events_url":"https://api.github.com/users/remulasce/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/remulasce/metroapp/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"nighelles","id":952451,"avatar_url":"https://avatars.githubusercontent.com/u/952451?v=3","gravatar_id":"","url":"https://api.github.com/users/nighelles","html_url":"https://github.com/nighelles","followers_url":"https://api.github.com/users/nighelles/followers","following_url":"https://api.github.com/users/nighelles/following{/other_user}","gists_url":"https://api.github.com/users/nighelles/gists{/gist_id}","starred_url":"https://api.github.com/users/nighelles/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nighelles/subscriptions","organizations_url":"https://api.github.com/users/nighelles/orgs","repos_url":"https://api.github.com/users/nighelles/repos","events_url":"https://api.github.com/users/nighelles/events{/privacy}","received_events_url":"https://api.github.com/users/nighelles/received_events","type":"User","site_admin":false},"milestone":null,"comments":11,"created_at":"2015-05-02T02:53:32Z","updated_at":"2015-05-02T03:28:09Z","closed_at":null,"body":"Line 60 checks stopid against stoptag, which are different.\r\n\r\nThis results in duplicate entries for LA Metro Rail, which uses multiple stoptags per stopid on rail.\r\n\r\nA stoptag is supposed to denote one single platform, whereas a stopid is like the whole station.\r\n\r\nWe want one entry per station, not platform. So we should compare against el[1] (stopid), I think.\r\nRight?\r\n\r\nEg. check lametro-rail.db, stopid 80301. There's two entries, differing only in the stoptag.\r\nIn the Android app, this would result in two identical stops added to the servicerequest, with the same stopids. I think."},"comment":{"url":"https://api.github.com/repos/remulasce/metroapp/issues/comments/98295684","html_url":"https://github.com/remulasce/metroapp/issues/229#issuecomment-98295684","issue_url":"https://api.github.com/repos/remulasce/metroapp/issues/229","id":98295684,"user":{"login":"remulasce","id":1064048,"avatar_url":"https://avatars.githubusercontent.com/u/1064048?v=3","gravatar_id":"","url":"https://api.github.com/users/remulasce","html_url":"https://github.com/remulasce","followers_url":"https://api.github.com/users/remulasce/followers","following_url":"https://api.github.com/users/remulasce/following{/other_user}","gists_url":"https://api.github.com/users/remulasce/gists{/gist_id}","starred_url":"https://api.github.com/users/remulasce/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/remulasce/subscriptions","organizations_url":"https://api.github.com/users/remulasce/orgs","repos_url":"https://api.github.com/users/remulasce/repos","events_url":"https://api.github.com/users/remulasce/events{/privacy}","received_events_url":"https://api.github.com/users/remulasce/received_events","type":"User","site_admin":false},"created_at":"2015-05-02T03:28:09Z","updated_at":"2015-05-02T03:28:09Z","body":"http://stackoverflow.com/questions/9342249/how-to-insert-a-unique-id-into-each-sqlite-row\r\n\r\nsqlite should be able to do it for you."}}