{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":185426100,"defaultBranch":"main","name":"fwapg","ownerLogin":"smnorris","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2019-05-07T15:07:42.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/1323293?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1709872095.0","currentOid":""},"activityList":{"items":[{"before":"46082dbd0aa4ba9621019fb8659035f0ae7ce071","after":"5d0d3cbeb1f2825332c33566561bc3e7ed23ee64","ref":"refs/heads/main","pushedAt":"2024-04-29T21:34:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"drop upstreamtrace when cleaning db","shortMessageHtmlLink":"drop upstreamtrace when cleaning db"}},{"before":"52184bf53efa6dd5a61f170101afec135b0ddf32","after":"46082dbd0aa4ba9621019fb8659035f0ae7ce071","ref":"refs/heads/main","pushedAt":"2024-03-18T16:57:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix #158","shortMessageHtmlLink":"<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #158.\">fix</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2192726234\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/158\" data-hovercard-type=\"issue\" data-hovercard-url=\"/smnorris/fwapg/issues/158/hovercard\" href=\"https://github.com/smnorris/fwapg/issues/158\">#158</a>"}},{"before":"dac6c060eedf820c2befce0b5e0846d1d221e4b9","after":"52184bf53efa6dd5a61f170101afec135b0ddf32","ref":"refs/heads/main","pushedAt":"2024-03-08T04:25:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"remove wget for compatability with bcfishpass package","shortMessageHtmlLink":"remove wget for compatability with bcfishpass package"}},{"before":"f7a57fcf03f9ad9921702f2acf81c556db4c1e2f","after":"dac6c060eedf820c2befce0b5e0846d1d221e4b9","ref":"refs/heads/main","pushedAt":"2024-03-02T03:48:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"do not remove downloaded file","shortMessageHtmlLink":"do not remove downloaded file"}},{"before":"0b26665dff17cdf9b94d76eed4543a6fbd4f19e3","after":"f7a57fcf03f9ad9921702f2acf81c556db4c1e2f","ref":"refs/heads/main","pushedAt":"2024-03-02T00:59:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"try removing file to fit in gha size limits","shortMessageHtmlLink":"try removing file to fit in gha size limits"}},{"before":"ec918d327a7e9efb18a89f59ccb8a61e50e85623","after":"0b26665dff17cdf9b94d76eed4543a6fbd4f19e3","ref":"refs/heads/main","pushedAt":"2024-03-01T23:48:01.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"do same for wsd and linear features","shortMessageHtmlLink":"do same for wsd and linear features"}},{"before":"82e6bddb5a46931523e2b06fc19c173b5740e1bd","after":"ec918d327a7e9efb18a89f59ccb8a61e50e85623","ref":"refs/heads/main","pushedAt":"2024-03-01T22:50:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"set search path before loading functions","shortMessageHtmlLink":"set search path before loading functions"}},{"before":"99a4520d0eac76c61818f4e7ea22ce81bd8ac69d","after":"82e6bddb5a46931523e2b06fc19c173b5740e1bd","ref":"refs/heads/main","pushedAt":"2024-03-01T22:46:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"require db setup before downloading to /data","shortMessageHtmlLink":"require db setup before downloading to /data"}},{"before":"729f82197131f4e8f4125d3045a12a8bbe7f4915","after":"99a4520d0eac76c61818f4e7ea22ce81bd8ac69d","ref":"refs/heads/main","pushedAt":"2024-03-01T22:12:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"load all functions on db setup","shortMessageHtmlLink":"load all functions on db setup"}},{"before":"d72d23f7e87aa589ae8b16ee8678776542ac8676","after":"729f82197131f4e8f4125d3045a12a8bbe7f4915","ref":"refs/heads/main","pushedAt":"2024-02-28T19:45:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"pg_use_copy is not default when loading to existing table","shortMessageHtmlLink":"pg_use_copy is not default when loading to existing table"}},{"before":"c7e9dacdfe25566004ca38417fff13103fbcb320","after":"d72d23f7e87aa589ae8b16ee8678776542ac8676","ref":"refs/heads/main","pushedAt":"2024-02-23T22:04:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"only build docs on tags when there are changes to doc files","shortMessageHtmlLink":"only build docs on tags when there are changes to doc files"}},{"before":"20073a6d85b6583028c8b2b7cb1347d284d63458","after":null,"ref":"refs/heads/issue156","pushedAt":"2024-02-23T22:00:43.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"}},{"before":"69d1c4ee5abacac83cb757a388f8498b009f9eeb","after":"c7e9dacdfe25566004ca38417fff13103fbcb320","ref":"refs/heads/main","pushedAt":"2024-02-23T22:00:39.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix #156 (#157)","shortMessageHtmlLink":"<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #156.\">fix</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2151513671\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/156\" data-hovercard-type=\"issue\" data-hovercard-url=\"/smnorris/fwapg/issues/156/hovercard\" href=\"https://github.com/smnorris/fwapg/issues/156\">#156</a> (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2151871031\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/157\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/smnorris/fwapg/pull/157/hovercard\" href=\"https://github.com/smnorris/fwapg/pull/157\">#157</a>)"}},{"before":null,"after":"20073a6d85b6583028c8b2b7cb1347d284d63458","ref":"refs/heads/issue156","pushedAt":"2024-02-23T21:59:34.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix #156","shortMessageHtmlLink":"<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #156.\">fix</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2151513671\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/156\" data-hovercard-type=\"issue\" data-hovercard-url=\"/smnorris/fwapg/issues/156/hovercard\" href=\"https://github.com/smnorris/fwapg/issues/156\">#156</a>"}},{"before":"c7f1802d78d1d5802e46661c2c13b91501a5bbc3","after":null,"ref":"refs/heads/streams_view","pushedAt":"2024-02-18T20:23:35.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"}},{"before":"428ea889751e97180a42a01be80b46fa225aa8c9","after":"52a0614f4248333f899c90e425e230c4189066c1","ref":"refs/heads/gh-pages","pushedAt":"2024-02-18T20:21:23.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":"Update documentation","shortMessageHtmlLink":"Update documentation"}},{"before":"61d10b63cfaa8ef5fec71626a983c17a1eab70b7","after":null,"ref":"refs/heads/schemaupfront","pushedAt":"2024-02-18T20:21:00.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"}},{"before":"5ff4b2cbac00a8639059c840e5fdf3e49a71d540","after":"69d1c4ee5abacac83cb757a388f8498b009f9eeb","ref":"refs/heads/main","pushedAt":"2024-02-18T20:20:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"Schemaupfront (#154)\n\n* add test streams view for BRAT\r\n\r\n* must cascade drop of lookup when reloading to drop dependent view\r\n\r\n* add discharge scripts\r\n\r\n* move lookups\r\n\r\n* add precip scripts\r\n\r\n* add channel width scripts\r\n\r\n* download full bcfishpass file for now\r\n\r\n* clean up extras scripts\r\n\r\n* fix paths, minor errors\r\n\r\n* use st_intersect instead of buffer/coveredby for much better speed\r\n\r\n* fix psql call\r\n\r\n* zip lookups\r\n\r\n* load discharge\r\n\r\n* fix #150\r\n\r\n* by removing wsg, streams are no longer missed\r\n\r\n* note rasterstats requirement, fix temp table names\r\n\r\n* update cw measured calculation\r\n\r\n* complete cw move\r\n\r\n* update streams view\r\n\r\n* create extras tables in setup ddl (truncate on load), dump extras csvs\r\n\r\n* reorganize to separate table creation from load\r\n\r\n* more cleanup\r\n\r\n* remove table creation\r\n\r\n* fix #151\r\n\r\n* document streams vw, simpify setup doc to reduce redundancy\r\n\r\n* remove docker info from primary readme\r\n\r\n* add missing function to build, update quickstart examples\r\n\r\n* tables now holds views as well, bump version\r\n\r\n* remove pgfs grants\r\n\r\n* add downstream trace, pull trace data from source tables not view, add upstr trace test, make column order in traces match column order in streams_vw\r\n\r\n* fix dnstr trace test\r\n\r\n* fix dockerfile","shortMessageHtmlLink":"Schemaupfront (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2141166634\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/154\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/smnorris/fwapg/pull/154/hovercard\" href=\"https://github.com/smnorris/fwapg/pull/154\">#154</a>)"}},{"before":"9fcb56d29424d1f7bb187ff6413331cf83d8db1f","after":"61d10b63cfaa8ef5fec71626a983c17a1eab70b7","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-18T20:18:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix dockerfile","shortMessageHtmlLink":"fix dockerfile"}},{"before":"6171e3e38931f1daa8f3bc5567da93852e50d6a7","after":"9fcb56d29424d1f7bb187ff6413331cf83d8db1f","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-13T19:01:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix dnstr trace test","shortMessageHtmlLink":"fix dnstr trace test"}},{"before":"00e1a305dd58a50aa6c9de615d872158e2bea643","after":"6171e3e38931f1daa8f3bc5567da93852e50d6a7","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-13T05:01:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"add downstream trace, pull trace data from source tables not view, add upstr trace test, make column order in traces match column order in streams_vw","shortMessageHtmlLink":"add downstream trace, pull trace data from source tables not view, ad…"}},{"before":"8108f55320dee4900e352a9097be79430f31c8a1","after":"00e1a305dd58a50aa6c9de615d872158e2bea643","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-08T18:10:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"remove pgfs grants","shortMessageHtmlLink":"remove pgfs grants"}},{"before":"7a0ab9c20241a32e63d6cd147acac750037b86d6","after":"8108f55320dee4900e352a9097be79430f31c8a1","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-08T01:25:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"tables now holds views as well, bump version","shortMessageHtmlLink":"tables now holds views as well, bump version"}},{"before":"43b1027eaad37e06addb463c03e3fb5911a88217","after":"7a0ab9c20241a32e63d6cd147acac750037b86d6","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-08T01:22:28.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"add missing function to build, update quickstart examples","shortMessageHtmlLink":"add missing function to build, update quickstart examples"}},{"before":"0aa47c73a8f7db8ea146dc4f4625b8bab91995c6","after":"43b1027eaad37e06addb463c03e3fb5911a88217","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-08T00:45:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"document streams vw, simpify setup doc to reduce redundancy","shortMessageHtmlLink":"document streams vw, simpify setup doc to reduce redundancy"}},{"before":"e46b7e4b931b40a49b5025bfc9ba3b886354b4ec","after":"0aa47c73a8f7db8ea146dc4f4625b8bab91995c6","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-08T00:02:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"fix #151","shortMessageHtmlLink":"<span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #151.\">fix</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2123952456\" data-permission-text=\"Title is private\" data-url=\"https://github.com/smnorris/fwapg/issues/151\" data-hovercard-type=\"issue\" data-hovercard-url=\"/smnorris/fwapg/issues/151/hovercard\" href=\"https://github.com/smnorris/fwapg/issues/151\">#151</a>"}},{"before":"e9b6b4bf5f8e6a629684816c76d715b57bedf42f","after":"e46b7e4b931b40a49b5025bfc9ba3b886354b4ec","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-05T09:47:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"remove table creation","shortMessageHtmlLink":"remove table creation"}},{"before":"345096fa159afe53fe369ff95cebad0106fc8cce","after":"e9b6b4bf5f8e6a629684816c76d715b57bedf42f","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-04T10:31:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"more cleanup","shortMessageHtmlLink":"more cleanup"}},{"before":null,"after":"345096fa159afe53fe369ff95cebad0106fc8cce","ref":"refs/heads/schemaupfront","pushedAt":"2024-02-04T07:39:56.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"reorganize to separate table creation from load","shortMessageHtmlLink":"reorganize to separate table creation from load"}},{"before":"075e6074d390592d968f3d48d5af28074b5e0175","after":"c7f1802d78d1d5802e46661c2c13b91501a5bbc3","ref":"refs/heads/streams_view","pushedAt":"2024-02-04T05:04:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"smnorris","name":"Simon Norris","path":"/smnorris","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1323293?s=80&v=4"},"commit":{"message":"create extras tables in setup ddl (truncate on load), dump extras csvs","shortMessageHtmlLink":"create extras tables in setup ddl (truncate on load), dump extras csvs"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEPWjSqgA","startCursor":null,"endCursor":null}},"title":"Activity · smnorris/fwapg"}