{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":246400637,"defaultBranch":"main","name":"db-cpdb","ownerLogin":"NYCPlanning","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2020-03-10T20:24:17.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/18286928?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1684528237.847852","currentOid":""},"activityList":{"items":[{"before":"b735d5e144d0d87eea03c122e4c1d84a0ce44614","after":"25709236c54a116339a1e1be423d92dcbd42ade3","ref":"refs/heads/main","pushedAt":"2023-05-24T02:49:34.871Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"23_Q2_build (#139)\n\n* move datasets not from geosupport update to other section\r\n\r\n* readme\r\n\r\n* clean up\r\n\r\n* use functions to run sql and raise errors\r\n\r\n* exit on bash errors\r\n\r\n* create source data table in spending script\r\n\r\n* don't make dataset if it exists\r\n\r\n* missed the first one\r\n\r\n* try better private curl call\r\n\r\n* let data loading error\r\n\r\n* drop footprint records with non-numeric bins\r\n\r\n* cast column to string\r\n\r\n* force table creation\r\n\r\n---------\r\n\r\nCo-authored-by: Damon McCullough <damonmcc1391@gmail.com>","shortMessageHtmlLink":"23_Q2_build (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1717787837\" data-permission-text=\"Title is private\" data-url=\"https://github.com/NYCPlanning/db-cpdb/issues/139\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/NYCPlanning/db-cpdb/pull/139/hovercard\" href=\"https://github.com/NYCPlanning/db-cpdb/pull/139\">#139</a>)"}},{"before":"c510df0b61a9cdb63bf4f42084c5f9e7197d457e","after":"56dfe54a90a3c010451e9e890275271eb2f525bf","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T21:23:08.960Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"force table creation","shortMessageHtmlLink":"force table creation"}},{"before":"333d4b22a872471b78f36a304203563376800839","after":"c510df0b61a9cdb63bf4f42084c5f9e7197d457e","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T20:37:19.430Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"cast column to string","shortMessageHtmlLink":"cast column to string"}},{"before":"6e107895d3991a94bcb40f3cf166a299a55dc4a5","after":"333d4b22a872471b78f36a304203563376800839","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T20:11:47.136Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"drop footprint records with non-numeric bins","shortMessageHtmlLink":"drop footprint records with non-numeric bins"}},{"before":"82de1c265c9821bdb59b7a2c890b6bdfff0aa19e","after":"6e107895d3991a94bcb40f3cf166a299a55dc4a5","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T19:49:02.672Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"let data loading error","shortMessageHtmlLink":"let data loading error"}},{"before":"1bebfd4eec8c143c138b03e23eedfdce8f7893e8","after":"82de1c265c9821bdb59b7a2c890b6bdfff0aa19e","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T19:29:30.030Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"try better private curl call","shortMessageHtmlLink":"try better private curl call"}},{"before":"876a7f07bf8dd0d40807072468e0c2532cb9c898","after":"1bebfd4eec8c143c138b03e23eedfdce8f7893e8","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T19:12:13.048Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"missed the first one","shortMessageHtmlLink":"missed the first one"}},{"before":"4385d546e89805aad490a2990d728b3eb3a0048f","after":"876a7f07bf8dd0d40807072468e0c2532cb9c898","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T19:06:49.192Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"don't make dataset if it exists","shortMessageHtmlLink":"don't make dataset if it exists"}},{"before":"52d93c40b1197bbb3d5f602d50cb385b24b78525","after":"4385d546e89805aad490a2990d728b3eb3a0048f","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T19:02:25.023Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"create source data table in spending script","shortMessageHtmlLink":"create source data table in spending script"}},{"before":"30d2bd27e20bc9e60d34c6120e48177a0c337fe6","after":"52d93c40b1197bbb3d5f602d50cb385b24b78525","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T18:51:45.439Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"exit on bash errors","shortMessageHtmlLink":"exit on bash errors"}},{"before":"d5b0c4be40bdd4d2c2c940815e3b185996152161","after":"30d2bd27e20bc9e60d34c6120e48177a0c337fe6","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T18:22:15.768Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"use functions to run sql and raise errors","shortMessageHtmlLink":"use functions to run sql and raise errors"}},{"before":"bd128418c835605a7d2c87d5bee1a7e5094f9d13","after":"d5b0c4be40bdd4d2c2c940815e3b185996152161","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T18:11:00.096Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"clean up","shortMessageHtmlLink":"clean up"}},{"before":"836705f8c9c071ebeb8f2292649418045c872b7a","after":"bd128418c835605a7d2c87d5bee1a7e5094f9d13","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-22T18:10:44.206Z","pushType":"push","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"readme","shortMessageHtmlLink":"readme"}},{"before":"b735d5e144d0d87eea03c122e4c1d84a0ce44614","after":"836705f8c9c071ebeb8f2292649418045c872b7a","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-19T20:31:07.103Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"move datasets not from geosupport update to other section","shortMessageHtmlLink":"move datasets not from geosupport update to other section"}},{"before":null,"after":"f0f0fc6394047a7f61e16abe6e8bec958b6e5f3d","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-05-19T20:30:37.847Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"move datasets not from geosupport update to other section","shortMessageHtmlLink":"move datasets not from geosupport update to other section"}},{"before":null,"after":"b735d5e144d0d87eea03c122e4c1d84a0ce44614","ref":"refs/heads/23_Q2_build","pushedAt":"2023-05-18T14:00:52.328Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Update workflows with `ubuntu 22.04`, `checkout v3`, `setup-python v4` and `postgres 15` (#137)\n\n* update workflows\r\n\r\n* update gcloud action version\r\n\r\n* revert back to gcloud v0\r\n\r\n* rename workflows","shortMessageHtmlLink":"Update workflows with <code>ubuntu 22.04</code>, <code>checkout v3</code>, `setup-python v4…"}},{"before":"8c6c792f530a4e9b089f368b5530259f0a79f499","after":null,"ref":"refs/heads/mbh-136-update-workflows-to-latest-greatest","pushedAt":"2023-04-27T15:08:29.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"}},{"before":"a894067fa15f63f89e26c023d96c810b840b9183","after":"b735d5e144d0d87eea03c122e4c1d84a0ce44614","ref":"refs/heads/main","pushedAt":"2023-04-27T15:05:41.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"},"commit":{"message":"Update workflows with `ubuntu 22.04`, `checkout v3`, `setup-python v4` and `postgres 15` (#137)\n\n* update workflows\r\n\r\n* update gcloud action version\r\n\r\n* revert back to gcloud v0\r\n\r\n* rename workflows","shortMessageHtmlLink":"Update workflows with <code>ubuntu 22.04</code>, <code>checkout v3</code>, `setup-python v4…"}},{"before":"eb25ce4650ade240b23e5da7447ab90ce435f6ac","after":"8c6c792f530a4e9b089f368b5530259f0a79f499","ref":"refs/heads/mbh-136-update-workflows-to-latest-greatest","pushedAt":"2023-04-21T18:22:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mbh329","name":"Max B-H","path":"/mbh329","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/41444592?s=80&v=4"},"commit":{"message":"rename workflows","shortMessageHtmlLink":"rename workflows"}},{"before":"9d2d221cde378de5438731bd4342ba3275a7f286","after":"eb25ce4650ade240b23e5da7447ab90ce435f6ac","ref":"refs/heads/mbh-136-update-workflows-to-latest-greatest","pushedAt":"2023-04-21T18:10:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mbh329","name":"Max B-H","path":"/mbh329","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/41444592?s=80&v=4"},"commit":{"message":"revert back to gcloud v0","shortMessageHtmlLink":"revert back to gcloud v0"}},{"before":"e2a954934337fe7fc5fe9e8ed5376212aaac0438","after":"9d2d221cde378de5438731bd4342ba3275a7f286","ref":"refs/heads/mbh-136-update-workflows-to-latest-greatest","pushedAt":"2023-04-21T17:48:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"mbh329","name":"Max B-H","path":"/mbh329","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/41444592?s=80&v=4"},"commit":{"message":"update gcloud action version","shortMessageHtmlLink":"update gcloud action version"}},{"before":null,"after":"e2a954934337fe7fc5fe9e8ed5376212aaac0438","ref":"refs/heads/mbh-136-update-workflows-to-latest-greatest","pushedAt":"2023-04-21T17:32:11.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"mbh329","name":"Max B-H","path":"/mbh329","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/41444592?s=80&v=4"},"commit":{"message":"update workflows","shortMessageHtmlLink":"update workflows"}},{"before":"354fcc2e37728884e792e95db5c1e281f9fc42e0","after":null,"ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-23T18:03:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"damonmcc","name":"Damon McCullough","path":"/damonmcc","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/7444289?s=80&v=4"}},{"before":"d716f51f153caf3da4b51da25549d85edcd0a5b6","after":"a894067fa15f63f89e26c023d96c810b840b9183","ref":"refs/heads/main","pushedAt":"2023-03-23T13:50:01.000Z","pushType":"pr_merge","commitsCount":6,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Merge pull request #135 from NYCPlanning/131-source_data_versions\n\nExport source data versions","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1628211410\" data-permission-text=\"Title is private\" data-url=\"https://github.com/NYCPlanning/db-cpdb/issues/135\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/NYCPlanning/db-cpdb/pull/135/hovercard\" href=\"https://github.com/NYCPlanning/db-cpdb/pull/135\">#135</a> from NYCPlanning/131-source_data_versions"}},{"before":"38bca881f1fd8e8640a14ed345c574c022cb0335","after":"354fcc2e37728884e792e95db5c1e281f9fc42e0","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-17T20:44:01.909Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Tweak create statement to be consistent with others","shortMessageHtmlLink":"Tweak create statement to be consistent with others"}},{"before":"7e49955afb0d4bf63f0c38cf29e925e456667cc1","after":"38bca881f1fd8e8640a14ed345c574c022cb0335","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-17T20:33:11.614Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Create source_data_versions table as well as add version column to each table","shortMessageHtmlLink":"Create source_data_versions table as well as add version column to ea…"}},{"before":"986b90e5eecdfcc429032deab8b1758d0ca35b1e","after":"7e49955afb0d4bf63f0c38cf29e925e456667cc1","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-17T13:09:36.859Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"minor bash inconsistency","shortMessageHtmlLink":"minor bash inconsistency"}},{"before":"b098ed0409a8e24f594b7cbe0ac8b6ac79100d28","after":null,"ref":"refs/heads/fvk-maintenance","pushedAt":"2023-03-16T20:36:55.505Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"}},{"before":"97b92714a842bf3a213daf2c90068725cc4f7dcc","after":"986b90e5eecdfcc429032deab8b1758d0ca35b1e","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-16T20:22:04.556Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Forgot to save file before adding in previous commit","shortMessageHtmlLink":"Forgot to save file before adding in previous commit"}},{"before":"d716f51f153caf3da4b51da25549d85edcd0a5b6","after":"97b92714a842bf3a213daf2c90068725cc4f7dcc","ref":"refs/heads/131-source_data_versions","pushedAt":"2023-03-16T20:16:11.255Z","pushType":"push","commitsCount":1,"pusher":{"login":"fvankrieken","name":null,"path":"/fvankrieken","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9454672?s=80&v=4"},"commit":{"message":"Write versions of source data to output csv at time of import","shortMessageHtmlLink":"Write versions of source data to output csv at time of import"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADMuovTAA","startCursor":null,"endCursor":null}},"title":"Activity · NYCPlanning/db-cpdb"}