{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":678809235,"defaultBranch":"main","name":"GS009_PostgreSQL_ja_PostGISin_perusteet","ownerLogin":"GispoCoding","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-08-15T12:35:55.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/34342178?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1720078122.0","currentOid":""},"activityList":{"items":[{"before":"4eedd1d7f0982fd042e37cab772d2f4a8f47a835","after":"cd3253322f4a76737586a78a57577110e804a75f","ref":"refs/heads/19-material-revision-2024-07","pushedAt":"2024-07-04T08:36:20.000Z","pushType":"push","commitsCount":4,"pusher":{"login":"eemilhaa","name":"Eemil Haapanen","path":"/eemilhaa","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/70660230?s=80&v=4"},"commit":{"message":"Exercise 2: update port in QGIS / postgis connection image","shortMessageHtmlLink":"Exercise 2: update port in QGIS / postgis connection image"}},{"before":null,"after":"4eedd1d7f0982fd042e37cab772d2f4a8f47a835","ref":"refs/heads/19-material-revision-2024-07","pushedAt":"2024-07-04T07:28:42.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"eemilhaa","name":"Eemil Haapanen","path":"/eemilhaa","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/70660230?s=80&v=4"},"commit":{"message":"Make .env and .env.template identical","shortMessageHtmlLink":"Make .env and .env.template identical"}},{"before":"1fa19880994c0063bfcc79b72c0ff0fe855cde69","after":"4eedd1d7f0982fd042e37cab772d2f4a8f47a835","ref":"refs/heads/main","pushedAt":"2024-05-20T07:24:02.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Make .env and .env.template identical","shortMessageHtmlLink":"Make .env and .env.template identical"}},{"before":"4c68be362f551b6d40efcb23eebb435c89d9b701","after":"b390d1c61f232e3e25fdd4d0b9582ecc17eb4b8a","ref":"refs/heads/12-update-env-settings-to-readme","pushedAt":"2024-05-20T07:22:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Make .env and .env.template identical","shortMessageHtmlLink":"Make .env and .env.template identical"}},{"before":"8d3dcd9f49f0df5c3f20792caff663487d609407","after":"4c68be362f551b6d40efcb23eebb435c89d9b701","ref":"refs/heads/12-update-env-settings-to-readme","pushedAt":"2024-05-15T11:14:12.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Update README.md for env settings","shortMessageHtmlLink":"Update README.md for env settings"}},{"before":"96fb813b22103fa45a5db8465476af3c9c1e72a7","after":"1fa19880994c0063bfcc79b72c0ff0fe855cde69","ref":"refs/heads/main","pushedAt":"2024-05-15T11:09:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Automatic: Update docs","shortMessageHtmlLink":"Automatic: Update docs"}},{"before":"eb677edeeb3f233011e45c4ebc793f9e8abe82b8","after":"96fb813b22103fa45a5db8465476af3c9c1e72a7","ref":"refs/heads/main","pushedAt":"2024-05-15T11:09:00.000Z","pushType":"pr_merge","commitsCount":7,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Add titles to exercises 7 and 8 and remove a title from exercise 5 for consistency","shortMessageHtmlLink":"Add titles to exercises 7 and 8 and remove a title from exercise 5 fo…"}},{"before":"62721f44c0b967fc4db39d3db4be7625fee22704","after":"8d3dcd9f49f0df5c3f20792caff663487d609407","ref":"refs/heads/12-update-env-settings-to-readme","pushedAt":"2024-05-15T11:07:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Fix","shortMessageHtmlLink":"Fix"}},{"before":"eb677edeeb3f233011e45c4ebc793f9e8abe82b8","after":"62721f44c0b967fc4db39d3db4be7625fee22704","ref":"refs/heads/12-update-env-settings-to-readme","pushedAt":"2024-05-15T11:05:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Update README.md for env settings","shortMessageHtmlLink":"Update README.md for env settings"}},{"before":null,"after":"eb677edeeb3f233011e45c4ebc793f9e8abe82b8","ref":"refs/heads/12-update-env-settings-to-readme","pushedAt":"2024-05-15T10:36:50.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Automatic: Update docs","shortMessageHtmlLink":"Automatic: Update docs"}},{"before":"42e55021043e23b54311b06afdb60fcb7abfd1e1","after":"529d0024cb166f8898903bc208c5e3bbcc4dc453","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-15T10:04:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Add titles to exercises 7 and 8 and remove a title from exercise 5 for consistency","shortMessageHtmlLink":"Add titles to exercises 7 and 8 and remove a title from exercise 5 fo…"}},{"before":"4f607ddd9a2e719b0db983da25fe2d2dcbb0c43c","after":"42e55021043e23b54311b06afdb60fcb7abfd1e1","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-15T07:38:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Exercise 2.2: Update image for creating PostGIS connection in QGIS, use host name instead of ip","shortMessageHtmlLink":"Exercise 2.2: Update image for creating PostGIS connection in QGIS, u…"}},{"before":"47beafcaf33f00554e954617fb1a02867ae42ab1","after":"4f607ddd9a2e719b0db983da25fe2d2dcbb0c43c","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-15T07:07:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Exercise 4: Add numbers to all exercises","shortMessageHtmlLink":"Exercise 4: Add numbers to all exercises"}},{"before":"84ea180f59753426b26acea8309aee34ad7407d7","after":"47beafcaf33f00554e954617fb1a02867ae42ab1","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-14T13:40:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Exercise 9: Add numbers to all exercises","shortMessageHtmlLink":"Exercise 9: Add numbers to all exercises"}},{"before":"f74beb92f8498841c51c4040d210958129eb8aef","after":"84ea180f59753426b26acea8309aee34ad7407d7","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-14T13:23:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Exercise 8: Add number to demo","shortMessageHtmlLink":"Exercise 8: Add number to demo"}},{"before":"c13dcd2a1f14e28f374a3fc7e7f2b145b4f52c45","after":"f74beb92f8498841c51c4040d210958129eb8aef","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-14T12:44:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Exercise 7: Add missing numbering and clarify","shortMessageHtmlLink":"Exercise 7: Add missing numbering and clarify"}},{"before":null,"after":"c13dcd2a1f14e28f374a3fc7e7f2b145b4f52c45","ref":"refs/heads/minor-issues-may-2024","pushedAt":"2024-05-07T15:13:20.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Change abbreviation of encrypting protocal from SSL to TLS","shortMessageHtmlLink":"Change abbreviation of encrypting protocal from SSL to TLS"}},{"before":"2787ad07d7a5f1d4eaf70bbc4b2033e8a5d764cd","after":"eb677edeeb3f233011e45c4ebc793f9e8abe82b8","ref":"refs/heads/main","pushedAt":"2024-04-03T08:47:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"Automatic: Update docs","shortMessageHtmlLink":"Automatic: Update docs"}},{"before":"819cc26ddf5c73ab1f328514a064a47a19866b0d","after":"2787ad07d7a5f1d4eaf70bbc4b2033e8a5d764cd","ref":"refs/heads/main","pushedAt":"2024-04-03T08:46:32.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"tmiosmauli","name":"Timo A","path":"/tmiosmauli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5397749?s=80&v=4"},"commit":{"message":"Merge pull request #16 from GispoCoding/15-minor-issues\n\nMerging minor fixes.","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2109863471\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/issues/16\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/16/hovercard\" href=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/16\">#16</a> from GispoCoding/15-minor-issues"}},{"before":"819cc26ddf5c73ab1f328514a064a47a19866b0d","after":"59f83ddaec67c3df41897c29fb6814c1ab98bcce","ref":"refs/heads/15-minor-issues","pushedAt":"2024-01-31T11:11:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"jeeemil","name":"Emil Ehnström","path":"/jeeemil","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/49360102?s=80&v=4"},"commit":{"message":"Minor Issue 15 fix","shortMessageHtmlLink":"Minor Issue 15 fix"}},{"before":null,"after":"819cc26ddf5c73ab1f328514a064a47a19866b0d","ref":"refs/heads/15-minor-issues","pushedAt":"2024-01-29T13:19:19.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"jeeemil","name":"Emil Ehnström","path":"/jeeemil","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/49360102?s=80&v=4"},"commit":{"message":"Merge pull request #14 from GispoCoding/change-repository-dispatch-token\n\nUse github_token instead of access_token","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2083664906\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/issues/14\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/14/hovercard\" href=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/14\">#14</a> from GispoCoding/change-repository-dispatch-token"}},{"before":"feeafce37bb717df6c89e24bf91183149035d04a","after":null,"ref":"refs/heads/change-repository-dispatch-token","pushedAt":"2024-01-16T11:07:11.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"}},{"before":"dcddf4d39ef485d0f519fdd4f78ca1553f635005","after":"819cc26ddf5c73ab1f328514a064a47a19866b0d","ref":"refs/heads/main","pushedAt":"2024-01-16T11:07:05.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Merge pull request #14 from GispoCoding/change-repository-dispatch-token\n\nUse github_token instead of access_token","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2083664906\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/issues/14\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/14/hovercard\" href=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/14\">#14</a> from GispoCoding/change-repository-dispatch-token"}},{"before":"dcddf4d39ef485d0f519fdd4f78ca1553f635005","after":"feeafce37bb717df6c89e24bf91183149035d04a","ref":"refs/heads/change-repository-dispatch-token","pushedAt":"2024-01-16T11:00:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Use github_token instead of access_token","shortMessageHtmlLink":"Use github_token instead of access_token"}},{"before":null,"after":"dcddf4d39ef485d0f519fdd4f78ca1553f635005","ref":"refs/heads/change-repository-dispatch-token","pushedAt":"2024-01-16T10:59:25.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Merge pull request #11 from GispoCoding/remove-answer-tokens\n\nRemove answer tokens","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2076473075\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/issues/11\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/11/hovercard\" href=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/11\">#11</a> from GispoCoding/remove-answer-tokens"}},{"before":"3e5f514ea3dc4ee79a1949cf3aea4fe19dba45a8","after":null,"ref":"refs/heads/remove-answer-tokens","pushedAt":"2024-01-15T15:15:59.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"}},{"before":"1a8a227c7b532904b917d2ebf25d9b4a9f54b9a5","after":"dcddf4d39ef485d0f519fdd4f78ca1553f635005","ref":"refs/heads/main","pushedAt":"2024-01-15T15:15:14.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"ismogis","name":"Ismo Lahtinen","path":"/ismogis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/124151132?s=80&v=4"},"commit":{"message":"Merge pull request #11 from GispoCoding/remove-answer-tokens\n\nRemove answer tokens","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2076473075\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/issues/11\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/11/hovercard\" href=\"https://github.com/GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet/pull/11\">#11</a> from GispoCoding/remove-answer-tokens"}},{"before":null,"after":"3e5f514ea3dc4ee79a1949cf3aea4fe19dba45a8","ref":"refs/heads/remove-answer-tokens","pushedAt":"2024-01-11T12:14:28.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"JuhoErvasti","name":"Juho Ervasti","path":"/JuhoErvasti","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/118284595?s=80&v=4"},"commit":{"message":"Remove exercise tokens","shortMessageHtmlLink":"Remove exercise tokens"}},{"before":"9167c617deea229b5449c78b743dcab585767291","after":null,"ref":"refs/heads/2023-08-29","pushedAt":"2023-12-20T08:30:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"RaineEkman","name":"Raine Ekman","path":"/RaineEkman","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/122015055?s=80&v=4"}},{"before":"6a343ae894a6799617aaca94fa80de55a608623f","after":"8e6f0770c24ae2becc234b294f83f102f402a992","ref":"refs/heads/clarification-patch-1","pushedAt":"2023-12-19T08:52:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tmiosmauli","name":"Timo A","path":"/tmiosmauli","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/5397749?s=80&v=4"},"commit":{"message":"Update 07_harjoitus_7.Rmd\n\nMinor fixes to coordinate value presentations.","shortMessageHtmlLink":"Update 07_harjoitus_7.Rmd"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEdq2NpQA","startCursor":null,"endCursor":null}},"title":"Activity · GispoCoding/GS009_PostgreSQL_ja_PostGISin_perusteet"}