-
Notifications
You must be signed in to change notification settings - Fork 52
Dataset: HPD Registrations
The hpd_registrations dataset can be added to NYCDB by running:
> nycdb --download my_funky_dataset
> nycdb --load my_funky_dataset
The dataset includes two tables from the NYC Open Data portal:
Includes every registration record for all the buildings required to register.
Includes every individual or entity associated with registrations (multiple rows for each row in registrations)
Description of the department that publishes the data, how often it is updated, and other details of note about the dataset. Also include background on the relevant program, policy, etc.
You can download the data dictionary PDF for each table.
To create the table here the best way is to use Google Sheets (or similar) to fill out all the information, then export to a CSV file, and use this tool to convert a CSV to an HTML table. Then you can paste that HTML code into this template replacing everything between the <summary> ... </summary> tags.
Click to Expand the my_funky_dataset Data Dictionary
| column_name | data_type | description |
|---|---|---|
| boroughid | integer | Borough code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) |
| borough | text | Borough name |
| block | integer | Number assigned by DoF identifying the Tax block the lot is on |
| lot | integer | Unique number assigned by DoF within a Block identifying a lot |
| bbl | char(10) | A combination of three numeric codes--a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits)--designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. |
This dataset has the following tables:
-
my_funky_datasetis the only table in this dataset and contains all the Funky things.
Following are some useful SQL queries related to the dataset.
The my_funky_dataset table has information on funky type classes such as 'a', 'b', and 'c'.
SELECT * FROM my_funky_dataset WHERE funky_type_class = 'c';- Missing fields
- Needs to be sanitized