{"action":"created","issue":{"url":"https://api.github.com/repos/minus34/gnaf-loader/issues/10","repository_url":"https://api.github.com/repos/minus34/gnaf-loader","labels_url":"https://api.github.com/repos/minus34/gnaf-loader/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/minus34/gnaf-loader/issues/10/comments","events_url":"https://api.github.com/repos/minus34/gnaf-loader/issues/10/events","html_url":"https://github.com/minus34/gnaf-loader/issues/10","id":159076820,"number":10,"title":"Missing table","user":{"login":"migurski","id":58730,"avatar_url":"https://avatars.githubusercontent.com/u/58730?v=3","gravatar_id":"","url":"https://api.github.com/users/migurski","html_url":"https://github.com/migurski","followers_url":"https://api.github.com/users/migurski/followers","following_url":"https://api.github.com/users/migurski/following{/other_user}","gists_url":"https://api.github.com/users/migurski/gists{/gist_id}","starred_url":"https://api.github.com/users/migurski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/migurski/subscriptions","organizations_url":"https://api.github.com/users/migurski/orgs","repos_url":"https://api.github.com/users/migurski/repos","events_url":"https://api.github.com/users/migurski/events{/privacy}","received_events_url":"https://api.github.com/users/migurski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":16,"created_at":"2016-06-08T04:32:30Z","updated_at":"2016-06-11T08:03:00Z","closed_at":null,"body":"I just attempted to run the current version of this loader against the Feb 2016 GNAF files, and I’m seeing a lot of instances of this error late in the process:\r\n\r\n```\r\nSQL FAILED! : INSERT INTO gnaf.temp_state_upper_house_electorates_tags (gnaf_pid, gnaf_state, alias_principal, bdy_pid, bdy_name, bdy_state)\r\nSELECT pnts.gnaf_pid,\r\n       pnts.state,   \r\n       'P',\r\n       bdys.se_upper_pid,\r\n       bdys.name,\r\n       bdys.state\r\n  FROM gnaf.address_principals AS pnts\r\n  INNER JOIN admin_bdys.state_upper_house_electorates_analysis AS bdys\r\n  ON ST_Within(pnts.geom, bdys.geom) WHERE bdys.gid > 1440 AND bdys.gid <= 2293;\r\n\r\n…\r\n\r\n: relation \"admin_bdys.state_upper_house_electorates_analysis\" does not exist\r\nLINE 9:   INNER JOIN admin_bdys.state_upper_house_electorates_analys...\r\n```\r\n\r\nI’m curious if this is something you’ve encountered, or if it’s a bug? The script completes shortly after."},"comment":{"url":"https://api.github.com/repos/minus34/gnaf-loader/issues/comments/225343455","html_url":"https://github.com/minus34/gnaf-loader/issues/10#issuecomment-225343455","issue_url":"https://api.github.com/repos/minus34/gnaf-loader/issues/10","id":225343455,"user":{"login":"migurski","id":58730,"avatar_url":"https://avatars.githubusercontent.com/u/58730?v=3","gravatar_id":"","url":"https://api.github.com/users/migurski","html_url":"https://github.com/migurski","followers_url":"https://api.github.com/users/migurski/followers","following_url":"https://api.github.com/users/migurski/following{/other_user}","gists_url":"https://api.github.com/users/migurski/gists{/gist_id}","starred_url":"https://api.github.com/users/migurski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/migurski/subscriptions","organizations_url":"https://api.github.com/users/migurski/orgs","repos_url":"https://api.github.com/users/migurski/repos","events_url":"https://api.github.com/users/migurski/events{/privacy}","received_events_url":"https://api.github.com/users/migurski/received_events","type":"User","site_admin":false},"created_at":"2016-06-11T08:03:00Z","updated_at":"2016-06-11T08:03:00Z","body":"I am re-running it on Trusty with 2.1 now, will re-run on Xenial with 2.2 later."}}
{"actor":{"display_login":"migurski"}}