{"action":"created","issue":{"url":"https://api.github.com/repos/jarondl/pygtfs/issues/14","repository_url":"https://api.github.com/repos/jarondl/pygtfs","labels_url":"https://api.github.com/repos/jarondl/pygtfs/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/jarondl/pygtfs/issues/14/comments","events_url":"https://api.github.com/repos/jarondl/pygtfs/issues/14/events","html_url":"https://github.com/jarondl/pygtfs/issues/14","id":136765213,"number":14,"title":"IntegrityError","user":{"login":"evyatarc","id":10861081,"avatar_url":"https://avatars.githubusercontent.com/u/10861081?v=3","gravatar_id":"","url":"https://api.github.com/users/evyatarc","html_url":"https://github.com/evyatarc","followers_url":"https://api.github.com/users/evyatarc/followers","following_url":"https://api.github.com/users/evyatarc/following{/other_user}","gists_url":"https://api.github.com/users/evyatarc/gists{/gist_id}","starred_url":"https://api.github.com/users/evyatarc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evyatarc/subscriptions","organizations_url":"https://api.github.com/users/evyatarc/orgs","repos_url":"https://api.github.com/users/evyatarc/repos","events_url":"https://api.github.com/users/evyatarc/events{/privacy}","received_events_url":"https://api.github.com/users/evyatarc/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-02-26T17:50:29Z","updated_at":"2016-03-04T10:55:55Z","closed_at":"2016-03-04T10:55:55Z","body":"Would you mind helping me with the error below when I try to look at MTA subway data? The link to the GTFS data is https://datamine-history.s3.amazonaws.com/gtfs-2014-09-17-09-31\r\n\r\nIntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: shapes.feed_id, shapes.shape_id [SQL: 'INSERT INTO shapes (feed_id, shape_id, shape_pt_lat, shape_pt_lon, shape_pt_sequence, shape_dist_traveled) VALUES (?, ?, ?, ?, ?, ?)'] [parameters: ((1, '4..N06R', 40.668897, -73.932942, '0', None), (1, '4..N06R', 40.669399, -73.942161, '1', None), (1, '4..N06R', 40.669847, -73.950466, '2', None), (1, '4..N06R', 40.669922, -73.951706, '3', None), (1, '4..N06R', 40.670083, -73.954713, '4', None), (1, '4..N06R', 40.670096, -73.954983, '5', None), (1, '4..N06R', 40.670118, -73.955258, '6', None), (1, '4..N06R', 40.670157, -73.955542, '7', None)  ... displaying 10 of 5001 total bound parameter sets ...  (1, 'L..S01R', 40.683552, -73.905577, '260', None), (1, 'L..S01R', 40.683429, -73.905534, '261', None))]"},"comment":{"url":"https://api.github.com/repos/jarondl/pygtfs/issues/comments/192231860","html_url":"https://github.com/jarondl/pygtfs/issues/14#issuecomment-192231860","issue_url":"https://api.github.com/repos/jarondl/pygtfs/issues/14","id":192231860,"user":{"login":"jarondl","id":2776956,"avatar_url":"https://avatars.githubusercontent.com/u/2776956?v=3","gravatar_id":"","url":"https://api.github.com/users/jarondl","html_url":"https://github.com/jarondl","followers_url":"https://api.github.com/users/jarondl/followers","following_url":"https://api.github.com/users/jarondl/following{/other_user}","gists_url":"https://api.github.com/users/jarondl/gists{/gist_id}","starred_url":"https://api.github.com/users/jarondl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jarondl/subscriptions","organizations_url":"https://api.github.com/users/jarondl/orgs","repos_url":"https://api.github.com/users/jarondl/repos","events_url":"https://api.github.com/users/jarondl/events{/privacy}","received_events_url":"https://api.github.com/users/jarondl/received_events","type":"User","site_admin":false},"created_at":"2016-03-04T10:55:55Z","updated_at":"2016-03-04T10:55:55Z","body":"Closed by #15 "}}