{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":66725061,"defaultBranch":"main","name":"nycdb","ownerLogin":"nycdb","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2016-08-27T16:47:43.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/52430087?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1716327754.0","currentOid":""},"activityList":{"items":[{"before":"bd67b5bdad02bcee75d39b47c7599ae3e8f53feb","after":"274e2601d6bf16c27f42676db9c7849a90048e0b","ref":"refs/heads/spatial-additions","pushedAt":"2024-05-23T21:19:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"typo","shortMessageHtmlLink":"typo"}},{"before":"3b735839f8cb6ee806475c28c553fc898212b6e6","after":"bd67b5bdad02bcee75d39b47c7599ae3e8f53feb","ref":"refs/heads/spatial-additions","pushedAt":"2024-05-23T21:14:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"reorganize boundaries tests to limit loads","shortMessageHtmlLink":"reorganize boundaries tests to limit loads"}},{"before":"27271e73585909f1a9db74b3e24ecf3b1734708e","after":"3b735839f8cb6ee806475c28c553fc898212b6e6","ref":"refs/heads/spatial-additions","pushedAt":"2024-05-23T21:02:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"load all boundaries on tests so that sql doesn't fail","shortMessageHtmlLink":"load all boundaries on tests so that sql doesn't fail"}},{"before":null,"after":"27271e73585909f1a9db74b3e24ecf3b1734708e","ref":"refs/heads/spatial-additions","pushedAt":"2024-05-21T21:42:34.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"add indexes on boundaries, construct geom on pluto_latest","shortMessageHtmlLink":"add indexes on boundaries, construct geom on pluto_latest"}},{"before":"252e34e7d7d403e1193bfc015d02df808a943400","after":"534bcf1675d81a2caf96b883c56d7818a6d17aa8","ref":"refs/heads/main","pushedAt":"2024-05-16T13:55:30.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"Fix dob safety violations url (#322)\n\nThere was an extra url param in the yaml for the dataset dob_safety_violations and this meant we weren't getting all the records\r\n\r\nWhile I was at it I thought I'd add a couple extra indexes to the sql for some columns that seemed useful","shortMessageHtmlLink":"Fix dob safety violations url (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2208236480\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/322\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/322/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/322\">#322</a>)"}},{"before":"5b182fc4cb5c68c652a54889c9ac04cf8b56d4ed","after":"252e34e7d7d403e1193bfc015d02df808a943400","ref":"refs/heads/main","pushedAt":"2024-05-06T18:44:48.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"Add support for COPY for more efficient data loading  (#328)\n\nUse postgres COPY method to speed up the uploading of data to the db. replace the insert_many function that used INSERT","shortMessageHtmlLink":"Add support for COPY for more efficient data loading (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2279101615\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/328\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/328/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/328\">#328</a>)"}},{"before":null,"after":"58c9caedeee3583987b5ba767fb34a44a4f9b5b0","ref":"refs/heads/test-copy","pushedAt":"2024-05-03T21:34:54.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"copy over some of will's changes to use copy","shortMessageHtmlLink":"copy over some of will's changes to use copy"}},{"before":null,"after":"313a2a3fd35ed23f184818361a082738e48e8905","ref":"refs/heads/fix-dob-safety-url","pushedAt":"2024-03-26T13:19:54.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"add some extra indexes in sql","shortMessageHtmlLink":"add some extra indexes in sql"}},{"before":"b4fa6a1d5a5b6feed8d42f61138db434dd632ff1","after":"5b182fc4cb5c68c652a54889c9ac04cf8b56d4ed","ref":"refs/heads/main","pushedAt":"2024-03-18T21:11:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"v0.3.4","shortMessageHtmlLink":"v0.3.4"}},{"before":"f9581894520b4ea96db6780f8f5f5f1937b0b244","after":null,"ref":"refs/heads/add-srid-boundaries-data","pushedAt":"2024-03-18T21:09:05.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"}},{"before":"c511c2b973061f48e5138687cecc8118eaba2743","after":"b4fa6a1d5a5b6feed8d42f61138db434dd632ff1","ref":"refs/heads/main","pushedAt":"2024-03-18T21:08:41.000Z","pushType":"pr_merge","commitsCount":5,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #321 from nycdb/add-srid-boundaries-data\n\nAdd srid and db_schema for shapefiles (plus all boundaries test data)","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2185226645\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/321\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/321/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/321\">#321</a> from nycdb/add-srid-boundaries-data"}},{"before":"8d1ff23204c2d63c9755f486c72cb56ea3abf5a4","after":"f9581894520b4ea96db6780f8f5f5f1937b0b244","ref":"refs/heads/add-srid-boundaries-data","pushedAt":"2024-03-14T04:23:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"add comment for context","shortMessageHtmlLink":"add comment for context"}},{"before":"893890716b765ad5cddc467008c2f9382adf8f31","after":"8d1ff23204c2d63c9755f486c72cb56ea3abf5a4","ref":"refs/heads/add-srid-boundaries-data","pushedAt":"2024-03-14T04:04:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"add ability to specify db schema for shapefile import","shortMessageHtmlLink":"add ability to specify db schema for shapefile import"}},{"before":null,"after":"893890716b765ad5cddc467008c2f9382adf8f31","ref":"refs/heads/add-srid-boundaries-data","pushedAt":"2024-03-14T01:47:04.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"add SRID transform for shapefiles","shortMessageHtmlLink":"add SRID transform for shapefiles"}},{"before":"3bf5ac1da0ce6aafb5f38cfca834176c47abe269","after":"c511c2b973061f48e5138687cecc8118eaba2743","ref":"refs/heads/main","pushedAt":"2024-03-13T23:19:34.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #314 from nycdb/add-dhs-daily-shelter-count\n\nadded dhs daily census dataset","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2092230947\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/314\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/314/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/314\">#314</a> from nycdb/add-dhs-daily-shelter-count"}},{"before":"213a02bbeac3b01a1b8dd9ca8f4a471b888b4ad9","after":"3bf5ac1da0ce6aafb5f38cfca834176c47abe269","ref":"refs/heads/main","pushedAt":"2024-03-13T23:18:03.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #320 from nycdb/drop-old-hpd-complaints-table\n\nremove deprecated hpd complaint tables","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2184632750\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/320\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/320/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/320\">#320</a> from nycdb/drop-old-hpd-complaints-table"}},{"before":"8bd691fa88d8d32a307bd3cb87abe9dbbc2cfeba","after":"827659e143bd9aa891604f7f3c45077ae55396a8","ref":"refs/heads/add-dhs-daily-shelter-count","pushedAt":"2024-03-13T23:17:17.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"added dhs daily census dataset\n\nalso added optional argument to to_csv to change the column names when reading in a csv","shortMessageHtmlLink":"added dhs daily census dataset"}},{"before":null,"after":"4028eb313dbebd2a8efd9f57704d3f45651d2bb2","ref":"refs/heads/drop-old-hpd-complaints-table","pushedAt":"2024-03-13T16:14:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"remove deprecated hpd complaint tables","shortMessageHtmlLink":"remove deprecated hpd complaint tables"}},{"before":"850a52a9738d7f1c1e067102a450e318703e3af7","after":"213a02bbeac3b01a1b8dd9ca8f4a471b888b4ad9","ref":"refs/heads/main","pushedAt":"2024-01-30T01:21:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"update postgis docs","shortMessageHtmlLink":"update postgis docs"}},{"before":"07a27f8d5e87f5eccffb53ac4be6bfba5f64df96","after":"850a52a9738d7f1c1e067102a450e318703e3af7","ref":"refs/heads/main","pushedAt":"2024-01-30T01:06:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"v0.3.2","shortMessageHtmlLink":"v0.3.2"}},{"before":"64ae364070f6dbe65c4d41499c11a91348debdf0","after":"07a27f8d5e87f5eccffb53ac4be6bfba5f64df96","ref":"refs/heads/main","pushedAt":"2024-01-30T01:01:27.000Z","pushType":"pr_merge","commitsCount":6,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #308 from nycdb/gis\n\nadd gis boundaries using shp2pgsql","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2091843615\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/308\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/308/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/308\">#308</a> from nycdb/gis"}},{"before":"50b9c8dc0d98ffd5235a746d78ac0bb749634444","after":"08ade0bf6b7a5f32fd3de5c55ae5d6cb02a9e7ec","ref":"refs/heads/gis","pushedAt":"2024-01-30T00:58:16.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"add verification data for boundaries dataset","shortMessageHtmlLink":"add verification data for boundaries dataset"}},{"before":"3fa9d819cef13f3ec6bc08ebbe8c74571374f834","after":"50b9c8dc0d98ffd5235a746d78ac0bb749634444","ref":"refs/heads/gis","pushedAt":"2024-01-24T15:42:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"add verification data for boundaries dataset","shortMessageHtmlLink":"add verification data for boundaries dataset"}},{"before":"846cdc663307bf0553baf40b5fa5241d590caf3a","after":"64ae364070f6dbe65c4d41499c11a91348debdf0","ref":"refs/heads/main","pushedAt":"2024-01-22T21:22:57.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"austensen","name":"Maxwell Austensen","path":"/austensen","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16906516?s=80&v=4"},"commit":{"message":"fix regex to get 'kings ' but not 'kingston' when mapping borough from court for case_summary table (#317)","shortMessageHtmlLink":"fix regex to get 'kings ' but not 'kingston' when mapping borough fro…"}},{"before":null,"after":"8bd691fa88d8d32a307bd3cb87abe9dbbc2cfeba","ref":"refs/heads/add-dhs-daily-shelter-count","pushedAt":"2024-01-20T20:31:18.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"pspauster","name":"Patrick Spauster","path":"/pspauster","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/43891111?s=80&v=4"},"commit":{"message":"added dhs daily census dataset\n\nalso added optional argument to to_csv to change the column names when reading in a csv","shortMessageHtmlLink":"added dhs daily census dataset"}},{"before":"2438b20c80cc459e484a9b5ca1dd4360eb63c6de","after":"846cdc663307bf0553baf40b5fa5241d590caf3a","ref":"refs/heads/main","pushedAt":"2024-01-20T19:54:51.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #311 from nycdb/kfinn/main/cli-drop-command\n\nCLI --drop command","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2092209492\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/311\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/311/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/311\">#311</a> from nycdb/kfinn/main/cli-drop-command"}},{"before":"b5142dc34d163cba7c49a96bbc9db775b8253a00","after":"2438b20c80cc459e484a9b5ca1dd4360eb63c6de","ref":"refs/heads/main","pushedAt":"2024-01-20T19:53:12.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #310 from nycdb/295-new-dataset-dob-safety-violations\n\nAdded dob_safety_violations dataset","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2092207731\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/310\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/310/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/310\">#310</a> from nycdb/295-new-dataset-dob-safety-violations"}},{"before":"959b158ccb12319783eeaa656740a2250d1b021c","after":"3fa9d819cef13f3ec6bc08ebbe8c74571374f834","ref":"refs/heads/gis","pushedAt":"2024-01-20T19:50:15.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"aepyornis","name":"ziggy","path":"/aepyornis","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8505044?s=80&v=4"},"commit":{"message":"Merge pull request #313 from nycdb/feature/gis-documentation\n\nSome process improvements and documentation for the GIS branch","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2092216876\" data-permission-text=\"Title is private\" data-url=\"https://github.com/nycdb/nycdb/issues/313\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/nycdb/nycdb/pull/313/hovercard\" href=\"https://github.com/nycdb/nycdb/pull/313\">#313</a> from nycdb/feature/gis-documentation"}},{"before":"04d0a8040a5bb459b0c5642d2a571d8ac9c0b186","after":"469c4a691b436bc8b1efcefee58b6c8eed3e2cd2","ref":"refs/heads/mbekker/nycdb/added-dataset/dob-safety-violations","pushedAt":"2024-01-20T19:49:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarksGit98","name":"Mark","path":"/MarksGit98","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/69128198?s=80&v=4"},"commit":{"message":"Added new Dataset: DOB Safety Violations (wiki documentation pending)","shortMessageHtmlLink":"Added new Dataset: DOB Safety Violations (wiki documentation pending)"}},{"before":null,"after":"d1915c4bac8dbd8109f7193635b208c8387afbb6","ref":"refs/heads/feature/gis-documentation","pushedAt":"2024-01-20T19:39:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"puckybreg","name":"Jonah Bregstone","path":"/puckybreg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8662143?s=80&v=4"},"commit":{"message":"adding src/scripts/createExtensionPostGIS.sql","shortMessageHtmlLink":"adding src/scripts/createExtensionPostGIS.sql"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEUnVMOQA","startCursor":null,"endCursor":null}},"title":"Activity · nycdb/nycdb"}