DCAS Managed Building Fuel Usage (Historical)
City of New York
@usgov.city_of_new_york_dcas_managed_building_fuel_usage
City of New York
@usgov.city_of_new_york_dcas_managed_building_fuel_usage
The fuel usage of each DCAS managed building.
Organization: City of New York
Last updated: 2020-11-10T17:00:45.648920
Tags: building, dcas, department-of-citywide-administrative-services, energy, facilities-management, fm, fuel, mmo, oil-usage
CREATE TABLE table_1 (
"borough_number" BIGINT,
"building_name" VARCHAR,
"building_address" VARCHAR,
"borough" VARCHAR,
"state" VARCHAR,
"postcode" BIGINT,
"block" BIGINT,
"lot" BIGINT,
"fuel_oil_usage_mmbtu" DOUBLE -- Fuel Oil Usage (MMBTU),
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_board" DOUBLE,
"council_district" DOUBLE,
"census_tract" DOUBLE,
"bin" DOUBLE,
"bbl" DOUBLE,
"nta" VARCHAR
);Anyone who has the link will be able to view this.