create LIFT data product

We're adding columns to DCAS's LIFT table:

• DRI Tier
• Capital Projects Total Project count
• Capital Projects Total Spent
• 2020 Census Tract
• NTA

This data is related to the Land Inventory Fast Track (LIFT) task force (storymap). it's a list of the "invetory" of city-controlled land that is suitable for housingm development

DCAS's LIFT table has 106 columns and ~15K rows. each row seems to be a lot

we'd love to build the pipeline to produce the entire LIFT table, but for now we're just adding fields to the latest manually created table

data model

inputs

• DCAS LIFT
• MapPLUTO
• EDDE DRI
• 2020 Census Tracts to 2020 NTAs and CDTAs Equivalency
• CPDB

outputs

• DCP LIFT

notes

LIFT_DCAS_Data Fields_20260807 is the last excel file we got from DCAS and is called the "updated DCAS LIFT table". it has 106 columns

LIFT Master Fields Other Data Sources 20260622 is a list of fields suggested by LIFT agencies earlier this year

since CPDB is a snapshot of the budget, should be clear that any capital project data is related to projects in the latest budget not all-time data

EDDE DRI data is NTA-level and PLUTO doesn't have an NTA column. we need to relate DRIs to tracts to lots