From a 500-row sample across 20 columns.
addressbinagency+1zip_codebinbbladdressbinagency+1addressbinagency+2Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| fiscal_year_of_submission | facility_name | address | city | zip_code | agency | bin | bbl | gross_square_footage | bdbid | unique_identifier | measure |
|---|---|---|---|---|---|---|---|---|---|---|---|
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 ECM 4 | ECM 4 |
| FY24 | 33rd Precinct |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
fiscal_year_of_submission | text | Fiscal year the energy efficiency report was submitted to the Department of Buildings | — | — |
facility_name | text | Name of the building | — | — |
address | text | Street Address | — | — |
city | text | City / Borough | — | — |
zip_code | text | Postal Code | — | — |
agency | text | Agency Acronym | — | — |
GET /api/datasets/9cgq-8a58 GET /api/datasets/9cgq-8a58/quality GET /api/datasets/9cgq-8a58/related GET /api/columns?dataset=9cgq-8a58
| 2207 Amsterdam Ave |
| New York |
| 10032 |
| NYPD |
| 1086200 |
| 1021120010 |
| 52207 |
| 4448 |
| 4448 OMM 1 |
| OMM 1 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 OMM 2 | OMM 2 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 1 | RCM 1 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 10 | RCM 10 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 2 | RCM 2 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 3 | RCM 3 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 4 | RCM 4 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 5 | RCM 5 |
| FY24 | 33rd Precinct | 2207 Amsterdam Ave | New York | 10032 | NYPD | 1086200 | 1021120010 | 52207 | 4448 | 4448 RCM 6 | RCM 6 |
Showing 12 of 20 columns. All of them are listed below.
bin | numeric | Building Identification Number | — | — |
bbl | numeric | Borough, Block, and Lot | — | — |
gross_square_footage | numeric | Square Footage | — | — |
bdbid | numeric | Unique property identification number established by DEM to represent each City-owned and operated property. | — | — |
unique_identifier | text | Unique property identification number + unique measure identification number | — | — |
measure | text | Unique energy efficiency measure identification number. | — | — |
measure_name | text | Name of the measure | — | — |
measure_status | text | Status per measure relative to completion of work as defined in the scope for that measure | — | — |
measure_category | text | A high-level classification that groups measures based on their implementation type | — | — |
estimated_installation_cost | numeric | The expected cost of the installation | — | — |
actual_cost_incurred_by_dcas11 | numeric | The actual cost of the installation | — | — |
mtco2e_reduction | numeric | Greenhouse gas emissions reduction | — | — |
reason_not_implemented | text | Explaination of why the installation was not completed | — | — |
simple_payback | numeric | Number of years to recover the cost of investment. (Total cost of installation / Energy Savings) | — | — |