NYCPlanning/db-buildings-composite ? reverse-engineered prompt

Build me the workflow for creating the NYC Buildings Composite database.

I want a set of scripts that take the source data from building footprints, PLUTO, the existing Buildings Composite data for classifying building type, PAD addresses, and USPS address data, then run the full process in the right order to produce the final composite database. It should be easy to run step by step, like loading the data, padding and cleaning addresses, matching addresses with Melissa or a similar address service if needed, and then building the final composite output.

Please make it practical for someone who just wants to run the pipeline from start to finish, with clear script names, basic setup instructions, and any environment variables or local config they’d need. Since the final data stays on an EDM server and is not meant to be exported through GitHub, keep that in mind and don’t treat it like a public download. If you need to look up current docs or best practices for any address matching tools, go ahead and do that.