{"action":"created","issue":{"url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/67","repository_url":"https://api.github.com/repos/MAPC/myschoolcommute2","labels_url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/67/labels{/name}","comments_url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/67/comments","events_url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/67/events","html_url":"https://github.com/MAPC/myschoolcommute2/issues/67","id":235691665,"number":67,"title":"Setup R environment to generate report","user":{"login":"allthesignals","id":5004319,"avatar_url":"https://avatars2.githubusercontent.com/u/5004319?v=4","gravatar_id":"","url":"https://api.github.com/users/allthesignals","html_url":"https://github.com/allthesignals","followers_url":"https://api.github.com/users/allthesignals/followers","following_url":"https://api.github.com/users/allthesignals/following{/other_user}","gists_url":"https://api.github.com/users/allthesignals/gists{/gist_id}","starred_url":"https://api.github.com/users/allthesignals/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/allthesignals/subscriptions","organizations_url":"https://api.github.com/users/allthesignals/orgs","repos_url":"https://api.github.com/users/allthesignals/repos","events_url":"https://api.github.com/users/allthesignals/events{/privacy}","received_events_url":"https://api.github.com/users/allthesignals/received_events","type":"User","site_admin":false},"labels":[{"id":525463244,"url":"https://api.github.com/repos/MAPC/myschoolcommute2/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":{"login":"mzagaja","id":565647,"avatar_url":"https://avatars1.githubusercontent.com/u/565647?v=4","gravatar_id":"","url":"https://api.github.com/users/mzagaja","html_url":"https://github.com/mzagaja","followers_url":"https://api.github.com/users/mzagaja/followers","following_url":"https://api.github.com/users/mzagaja/following{/other_user}","gists_url":"https://api.github.com/users/mzagaja/gists{/gist_id}","starred_url":"https://api.github.com/users/mzagaja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzagaja/subscriptions","organizations_url":"https://api.github.com/users/mzagaja/orgs","repos_url":"https://api.github.com/users/mzagaja/repos","events_url":"https://api.github.com/users/mzagaja/events{/privacy}","received_events_url":"https://api.github.com/users/mzagaja/received_events","type":"User","site_admin":false},"assignees":[{"login":"mzagaja","id":565647,"avatar_url":"https://avatars1.githubusercontent.com/u/565647?v=4","gravatar_id":"","url":"https://api.github.com/users/mzagaja","html_url":"https://github.com/mzagaja","followers_url":"https://api.github.com/users/mzagaja/followers","following_url":"https://api.github.com/users/mzagaja/following{/other_user}","gists_url":"https://api.github.com/users/mzagaja/gists{/gist_id}","starred_url":"https://api.github.com/users/mzagaja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzagaja/subscriptions","organizations_url":"https://api.github.com/users/mzagaja/orgs","repos_url":"https://api.github.com/users/mzagaja/repos","events_url":"https://api.github.com/users/mzagaja/events{/privacy}","received_events_url":"https://api.github.com/users/mzagaja/received_events","type":"User","site_admin":false},{"login":"allthesignals","id":5004319,"avatar_url":"https://avatars2.githubusercontent.com/u/5004319?v=4","gravatar_id":"","url":"https://api.github.com/users/allthesignals","html_url":"https://github.com/allthesignals","followers_url":"https://api.github.com/users/allthesignals/followers","following_url":"https://api.github.com/users/allthesignals/following{/other_user}","gists_url":"https://api.github.com/users/allthesignals/gists{/gist_id}","starred_url":"https://api.github.com/users/allthesignals/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/allthesignals/subscriptions","organizations_url":"https://api.github.com/users/allthesignals/orgs","repos_url":"https://api.github.com/users/allthesignals/repos","events_url":"https://api.github.com/users/allthesignals/events{/privacy}","received_events_url":"https://api.github.com/users/allthesignals/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/MAPC/myschoolcommute2/milestones/1","html_url":"https://github.com/MAPC/myschoolcommute2/milestone/1","labels_url":"https://api.github.com/repos/MAPC/myschoolcommute2/milestones/1/labels","id":2646048,"number":1,"title":"1.0.0 (Release)","description":"","creator":{"login":"mzagaja","id":565647,"avatar_url":"https://avatars1.githubusercontent.com/u/565647?v=4","gravatar_id":"","url":"https://api.github.com/users/mzagaja","html_url":"https://github.com/mzagaja","followers_url":"https://api.github.com/users/mzagaja/followers","following_url":"https://api.github.com/users/mzagaja/following{/other_user}","gists_url":"https://api.github.com/users/mzagaja/gists{/gist_id}","starred_url":"https://api.github.com/users/mzagaja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzagaja/subscriptions","organizations_url":"https://api.github.com/users/mzagaja/orgs","repos_url":"https://api.github.com/users/mzagaja/repos","events_url":"https://api.github.com/users/mzagaja/events{/privacy}","received_events_url":"https://api.github.com/users/mzagaja/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":20,"state":"open","created_at":"2017-07-17T21:01:40Z","updated_at":"2017-08-18T15:22:39Z","due_on":null,"closed_at":null},"comments":20,"created_at":"2017-06-13T21:02:02Z","updated_at":"2017-08-22T14:45:58Z","closed_at":null,"body":"the report generates manually all the way up to the LateX dependency, which is installing now."},"comment":{"url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/comments/324049301","html_url":"https://github.com/MAPC/myschoolcommute2/issues/67#issuecomment-324049301","issue_url":"https://api.github.com/repos/MAPC/myschoolcommute2/issues/67","id":324049301,"user":{"login":"mzagaja","id":565647,"avatar_url":"https://avatars1.githubusercontent.com/u/565647?v=4","gravatar_id":"","url":"https://api.github.com/users/mzagaja","html_url":"https://github.com/mzagaja","followers_url":"https://api.github.com/users/mzagaja/followers","following_url":"https://api.github.com/users/mzagaja/following{/other_user}","gists_url":"https://api.github.com/users/mzagaja/gists{/gist_id}","starred_url":"https://api.github.com/users/mzagaja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mzagaja/subscriptions","organizations_url":"https://api.github.com/users/mzagaja/orgs","repos_url":"https://api.github.com/users/mzagaja/repos","events_url":"https://api.github.com/users/mzagaja/events{/privacy}","received_events_url":"https://api.github.com/users/mzagaja/received_events","type":"User","site_admin":false},"created_at":"2017-08-22T14:45:58Z","updated_at":"2017-08-22T14:45:58Z","body":"Ok so I think I found the issue. If I attempt to list all the tables for the app in postgres using `\\dt` the way I normally do I get:\r\n```\r\nmysc=# \\dt\r\n                   List of relations\r\n Schema |            Name            | Type  |  Owner\r\n--------+----------------------------+-------+----------\r\n public | accounts_profile           | table | mysc\r\n public | auth_group                 | table | mysc\r\n public | auth_group_permissions     | table | mysc\r\n public | auth_message               | table | mysc\r\n public | auth_permission            | table | mysc\r\n public | auth_user                  | table | mysc\r\n public | auth_user_groups           | table | mysc\r\n public | auth_user_user_permissions | table | mysc\r\n public | districts                  | table | ubuntu\r\n public | django_admin_log           | table | mysc\r\n public | django_content_type        | table | mysc\r\n public | django_session             | table | mysc\r\n public | django_site                | table | mysc\r\n public | mysc_admin_log             | table | mysc\r\n public | mysc_content_type          | table | mysc\r\n public | mysc_session               | table | mysc\r\n public | mysc_site                  | table | mysc\r\n public | school_muni                | table | mysc\r\n public | schools                    | table | ubuntu\r\n public | south_migrationhistory     | table | mysc\r\n public | spatial_ref_sys            | table | postgres\r\n public | survey_child               | table | mysc\r\n public | survey_district            | table | mysc\r\n public | survey_intersection        | table | mysc\r\n public | survey_network_bike        | table | mysc\r\n public | survey_network_walk        | table | mysc\r\n public | survey_school              | table | mysc\r\n public | survey_street              | table | mysc\r\n public | survey_survey              | table | mysc\r\n public | survey_surveyset           | table | mysc\r\n public | weird_ma                   | table | postgres\r\n```\r\nNo survey_child_survey. I now just learned if I simply do `\\d` I get a list of things that are not app tables, like views.\r\n```\r\n                        List of relations\r\n Schema |               Name                |   Type   |  Owner\r\n--------+-----------------------------------+----------+----------\r\n public | accounts_profile                  | table    | mysc\r\n public | accounts_profile_id_seq           | sequence | mysc\r\n public | auth_group                        | table    | mysc\r\n public | auth_group_id_seq                 | sequence | mysc\r\n public | auth_group_permissions            | table    | mysc\r\n public | auth_group_permissions_id_seq     | sequence | mysc\r\n public | auth_message                      | table    | mysc\r\n public | auth_message_id_seq               | sequence | mysc\r\n public | auth_permission                   | table    | mysc\r\n public | auth_permission_id_seq            | sequence | mysc\r\n public | auth_user                         | table    | mysc\r\n public | auth_user_groups                  | table    | mysc\r\n public | auth_user_groups_id_seq           | sequence | mysc\r\n public | auth_user_id_seq                  | sequence | mysc\r\n public | auth_user_user_permissions        | table    | mysc\r\n public | auth_user_user_permissions_id_seq | sequence | mysc\r\n public | districts                         | table    | ubuntu\r\n public | django_admin_log                  | table    | mysc\r\n public | django_admin_log_id_seq           | sequence | mysc\r\n public | django_content_type               | table    | mysc\r\n public | django_content_type_id_seq        | sequence | mysc\r\n public | django_session                    | table    | mysc\r\n public | django_site                       | table    | mysc\r\n public | django_site_id_seq                | sequence | mysc\r\n public | geography_columns                 | view     | mysc\r\n public | geometry_columns                  | view     | mysc\r\n public | mysc_admin_log                    | table    | mysc\r\n public | mysc_admin_log_id_seq             | sequence | mysc\r\n public | mysc_content_type                 | table    | mysc\r\n public | mysc_content_type_id_seq          | sequence | mysc\r\n public | mysc_session                      | table    | mysc\r\n public | mysc_site                         | table    | mysc\r\n public | mysc_site_id_seq                  | sequence | mysc\r\n public | raster_columns                    | view     | mysc\r\n public | raster_overviews                  | view     | mysc\r\n public | school_muni                       | table    | mysc\r\n public | school_muni_ogc_fid_seq           | sequence | mysc\r\n public | schools                           | table    | ubuntu\r\n public | south_migrationhistory            | table    | mysc\r\n public | south_migrationhistory_id_seq     | sequence | mysc\r\n public | spatial_ref_sys                   | table    | postgres\r\n public | survey_child                      | table    | mysc\r\n public | survey_child_export               | view     | ubuntu\r\n public | survey_child_id_seq               | sequence | mysc\r\n public | survey_child_survey               | view     | mysc\r\n public | survey_district                   | table    | mysc\r\n public | survey_intersection               | table    | mysc\r\n public | survey_intersection_ogc_fid_seq   | sequence | mysc\r\n public | survey_network_bike               | table    | mysc\r\n public | survey_network_bike_ogc_fid_seq   | sequence | mysc\r\n public | survey_network_walk               | table    | mysc\r\n public | survey_network_walk_ogc_fid_seq   | sequence | mysc\r\n public | survey_school                     | table    | mysc\r\n public | survey_school_id_seq              | sequence | mysc\r\n public | survey_street                     | table    | mysc\r\n public | survey_street_id_seq              | sequence | mysc\r\n public | survey_survey                     | table    | mysc\r\n public | survey_survey_id_seq              | sequence | mysc\r\n public | survey_surveyset                  | table    | mysc\r\n public | survey_surveyset_id_seq           | sequence | mysc\r\n public | weird_ma                          | table    | postgres\r\n```\r\nSo this is why it was so challenging for me to rebuild this import in the first place. So now I know. Will try to see if I can get it working now."}}
{"actor":{"display_login":"mzagaja"}}