nycplanning/db-community-profiles issues and pull requests

#113 - 12369 Updated needs for FY2024

Pull Request - State: closed - Opened by dhochbaum-dcp over 1 year ago - 1 comment

#112 - 2021 update - questions

Issue - State: open - Opened by SPTKL about 3 years ago

#111 - 2021 Update

Issue - State: open - Opened by SPTKL about 3 years ago

#110 - WIP - Refactor pluto

Pull Request - State: open - Opened by SPTKL about 3 years ago

#109 - WIP refactor

Pull Request - State: open - Opened by SPTKL about 3 years ago - 4 comments

#108 - 🧠 Knowledege Transfer

Issue - State: closed - Opened by SPTKL over 3 years ago - 1 comment

#107 - Add pipeline to incorporate PL data

Issue - State: closed - Opened by mgraber over 3 years ago

#106 - Use 2010 or 2020 floodplain and park access

Issue - State: open - Opened by mgraber over 3 years ago

#105 - For ACS variables report data at CDTA level

Issue - State: closed - Opened by AmandaDoyle over 3 years ago - 1 comment

#104 - Patch PR #103

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#103 - correcting issue of pct_served_parks not being multiplied by 100 like the the other percent variables

Pull Request - State: closed - Opened by AmandaDoyle almost 4 years ago

#102 - pct_served_parks needs to be multiplied by 100 to align with other percent values

Issue - State: closed - Opened by AmandaDoyle almost 4 years ago

#101 - Add workflow for publishing to DigitalOcean

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#100 - Add step to upload outputs to DigitalOcean

Issue - State: closed - Opened by mgraber almost 4 years ago

#99 - Remove special characters from cd_son

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#98 - Add floodplain MOEs for ACS vars

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#97 - adding source

Pull Request - State: closed - Opened by SPTKL almost 4 years ago

#96 - With pff-factfinder, we would need to specify source to be either acs (default) or decennial

Issue - State: closed - Opened by SPTKL almost 4 years ago

#95 - All non-FacDB updates

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#94 - Update input datasets for final update for publication

Issue - State: open - Opened by AmandaDoyle almost 4 years ago - 1 comment

#93 - Output cd needs version

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#92 - Remove cd_son_fy2018 from combined

Pull Request - State: closed - Opened by mgraber almost 4 years ago
Labels: bug

#91 - Update SON data and pass version

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#90 - Add _2010 suffix to decennial fp pop fields

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#89 - Change geo source to dcp_cdboundaries_clipped."20d"

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#88 - Switch to add-and-commit action

Pull Request - State: closed - Opened by mgraber almost 4 years ago - 1 comment

#87 - Remove git pull step

Pull Request - State: closed - Opened by mgraber almost 4 years ago - 1 comment

#86 - Remove outdated load of cd_puma

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#85 - Round pct_served_parks to 2 decimals

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#84 - Remove duplicate loading of cd_puma

Issue - State: closed - Opened by mgraber almost 4 years ago

#83 - Floodplain population and demo indicators are inconsistent

Issue - State: open - Opened by mgraber almost 4 years ago - 2 comments
Labels: PC input needed

#82 - Data update for 2020 statement of needs

Issue - State: open - Opened by cfpolack almost 4 years ago - 3 comments

#81 - Fix rounding of pct_served_parks

Issue - State: closed - Opened by mgraber almost 4 years ago

#80 - Questions from PC

Issue - State: closed - Opened by AmandaDoyle almost 4 years ago - 1 comment

#79 - Add PUMA fields

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#78 - moe_over65_rate_nyc

Pull Request - State: closed - Opened by SPTKL almost 4 years ago

#77 - General questions / issues for review

Issue - State: closed - Opened by AmandaDoyle almost 4 years ago
Labels: bug

#76 - out_cd_geo.sql needs to used clipped to shoreline CD boundaries

Issue - State: closed - Opened by AmandaDoyle almost 4 years ago - 2 comments
Labels: bug

#75 - 'city_cd_attributes' has 7 rows when it should have 1. moe_over65 is not the same

Issue - State: closed - Opened by AmandaDoyle almost 4 years ago - 3 comments
Labels: bug

#74 - Round park access to one decimal

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#74 - Round park access to one decimal

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#73 - Round clean streets pct to one decimal

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#72 - Round sanitation fields to one decimal

Issue - State: closed - Opened by mgraber almost 4 years ago

#71 - Round pct_served_parks

Issue - State: closed - Opened by mgraber almost 4 years ago

#70 - Fix typo

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#69 - After 2020 census: switch decennial data source to API

Issue - State: closed - Opened by mgraber almost 4 years ago - 1 comment
Labels: ✨ enhancement, 🚧 road block

#68 - Load decennial population fields from csv

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#67 - Specify versions

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#66 - Remove pff install outside of docker

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#65 - Remove --user flag and install requests

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#64 - run.sh for running specific pipelines

Issue - State: closed - Opened by SPTKL almost 4 years ago

#63 - Add missing pf500 fields

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#62 - Add missing floodplain fields to combine.sql

Issue - State: closed - Opened by mgraber almost 4 years ago

#61 - Remove underscores in cd_built_environment

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#60 - Remove multiple underscores in cd_built_environment PLUTO fields

Issue - State: closed - Opened by mgraber almost 4 years ago

#59 - Retain multiple underscores in PLUTO in sql scripts

Issue - State: closed - Opened by mgraber almost 4 years ago - 1 comment

#58 - Filter sanitation data in opendata API rather than postgres

Issue - State: closed - Opened by mgraber almost 4 years ago - 1 comment
Labels: ✨ enhancement, 🚧 road block

#57 - Switch back to versions.env, rather than dispatch parameters

Issue - State: closed - Opened by mgraber almost 4 years ago

#56 - Patch without 2000 census

Pull Request - State: closed - Opened by SPTKL almost 4 years ago

#55 - Without 2000 census

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#54 - Switch source of pop_2000, pop_2010, and pop_change_00_10

Issue - State: closed - Opened by mgraber almost 4 years ago

#53 - Add decennial pop counts and remove ACS puma join

Pull Request - State: closed - Opened by mgraber almost 4 years ago

#52 - Switch to pip-installable pff-factfinder

Issue - State: closed - Opened by mgraber almost 4 years ago

#51 - Switch to self-hosted runner

Issue - State: closed - Opened by mgraber almost 4 years ago

#50 - Add LEP vars to combined table

Pull Request - State: closed - Opened by mgraber about 4 years ago

#49 - Add LEP variables

Pull Request - State: closed - Opened by mgraber about 4 years ago

#48 - Inventory input versions

Issue - State: closed - Opened by mgraber about 4 years ago - 1 comment

#47 - Fix year parsing

Pull Request - State: closed - Opened by mgraber about 4 years ago

#46 - Add build.yml to run through actions

Pull Request - State: closed - Opened by mgraber about 4 years ago

#45 - Refactor parks, ACS, and floodplain workflows to use factfinder

Pull Request - State: closed - Opened by mgraber about 4 years ago - 1 comment

#44 - Switch parks methodology to block centroids

Issue - State: closed - Opened by mgraber about 4 years ago

#43 - ACS/Decennial Floodplain Fields

Issue - State: closed - Opened by mgraber about 4 years ago - 1 comment

#42 - Add poverty scripts flexible for later opendata source

Pull Request - State: closed - Opened by mgraber about 4 years ago

#41 - Rename unemployment fields to match labs schema

Pull Request - State: closed - Opened by mgraber about 4 years ago

#40 - Rename pluto fields to match labs schema

Pull Request - State: closed - Opened by mgraber about 4 years ago

#39 - Add tooltips

Pull Request - State: closed - Opened by mgraber about 4 years ago

#38 - Create views for download

Pull Request - State: closed - Opened by mgraber about 4 years ago - 2 comments

#37 - Add missing PLUTO-derived floodplain fields

Pull Request - State: closed - Opened by mgraber about 4 years ago

#36 - Update sanitation workflow

Pull Request - State: closed - Opened by mgraber about 4 years ago

#35 - Add statement of needs and neighborhoods

Pull Request - State: closed - Opened by mgraber about 4 years ago

#34 - 7 parks

Pull Request - State: closed - Opened by SPTKL about 4 years ago - 1 comment

#33 - Create different data tables for download

Issue - State: closed - Opened by AmandaDoyle about 4 years ago - 3 comments

#32 - Add sanitation fields

Pull Request - State: closed - Opened by mgraber about 4 years ago

#31 - Add workflows for "other" variables

Pull Request - State: closed - Opened by mgraber about 4 years ago

#30 - Round PLUTO are fields and remove out_pluto_landusearea.sql

Pull Request - State: closed - Opened by mgraber over 4 years ago - 1 comment

#29 - PLUTO: round area fields to integers

Issue - State: closed - Opened by mgraber over 4 years ago

#28 - Convert fp areas to sq-miles and round

Pull Request - State: closed - Opened by mgraber over 4 years ago

#27 - PLUTO: Convert floodplain fields to square miles

Issue - State: closed - Opened by mgraber over 4 years ago

#26 - Create version.csv file

Issue - State: closed - Opened by AmandaDoyle over 4 years ago
Labels: ✨ enhancement

#25 - Cast to geography while calculating lotarea

Issue - State: closed - Opened by SPTKL over 4 years ago

#24 - Landuseareageom

Pull Request - State: closed - Opened by AmandaDoyle over 4 years ago

#23 - Put pop columns in correct order

Pull Request - State: closed - Opened by mgraber over 4 years ago

#22 - fixing crime pipeline and rerun all

Pull Request - State: closed - Opened by SPTKL over 4 years ago

#21 - For PLUTO fields, do we need to recalculate lot area using unclipped MapPLUTO?

Issue - State: closed - Opened by AmandaDoyle over 4 years ago - 1 comment

#20 - Fix out_acs typos

Pull Request - State: closed - Opened by mgraber over 4 years ago - 1 comment

#19 - adding fema-firms-500yr fields

Pull Request - State: closed - Opened by SPTKL over 4 years ago

#18 - 20Q1 - bring in source datasets

Issue - State: closed - Opened by AmandaDoyle over 4 years ago

#17 - Pluto5

Pull Request - State: closed - Opened by AmandaDoyle over 4 years ago - 1 comment

#16 - 20Q1 - Combine fields into one output

Issue - State: closed - Opened by AmandaDoyle over 4 years ago - 1 comment

#15 - ACS: Aggregated CT level indicators to CD level instead of taking PUMA level data

Issue - State: closed - Opened by AmandaDoyle over 4 years ago
Labels: ✨ enhancement

GitHub / nycplanning/db-community-profiles issues and pull requests