search

NYCPlanning / db-cpdb

Capital Projects Database
https://nycplanning.github.io/db-cpdb
0 stars 0 forks source link

Create Open Data Tables in Export #117

Open mbh329 opened 2 years ago

caseysmithpgh commented 2 years ago

Proposed Schema

Commitments: maprojid magency projectid description budgetline projecttype plancommdate commitmentdescription commitmentcode typc typcname ccnonexempt ccexempt totalcityplannedcommit nccstate nccfederal nccother totalnoncityplannedcommit totalplannedcommit sagencyacro sagencyname magencyacro magencyname ccpversion

Projects: maprojid magency projectid description ccnonexempt ccexempt totalcityplannedcommit nccstate nccfederal nccother totalnoncityplannedcommit totalplannedcommit totalspend maxdate mindate magencyacro magencyname typecategory ccpversion geometry (Not included in tabular data)