2021 Energy Benchmarking All Sites

CREATE TABLE table_1 (
  "montgomery_county_building_id" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "postal_code" VARCHAR,
  "building_sq_ft" BIGINT,
  "parcel_sq_ft" BIGINT,
  "jurisdiction" VARCHAR,
  "benchmarking_group" VARCHAR,
  "exemption_reason" VARCHAR,
  "lu_category" VARCHAR,
  "tax_lu_majdesc" VARCHAR,
  "building_name" VARCHAR,
  "submissions_weather_normalized_site_energy_use" DOUBLE  -- Submissions - Weather Normalized Site Energy Use,
  "submissions_proprty_floor_area_buildings" DOUBLE  -- Submissions - Proprty Floor Area Buildings,
  "status" VARCHAR,
  "submissions_total_ghg_emissions" DOUBLE  -- Submissions - Total Ghg Emissions,
  "reported_gfa" DOUBLE,
  "submissions_year_built" DOUBLE  -- Submissions - Year Built,
  "submissions_diesel_2_use" DOUBLE  -- Submissions - Diesel 2 Use,
  "submissions_fuel_oil_1_use" DOUBLE  -- Submissions - Fuel Oil 1 Use,
  "submissions_fuel_oil_2_use" DOUBLE  -- Submissions - Fuel Oil 2 Use,
  "submissions_site_energy_use" DOUBLE  -- Submissions - Site Energy Use,
  "submissions_energy_star_score" DOUBLE  -- Submissions - Energy Star Score,
  "submissions_district_steam_use" VARCHAR  -- Submissions - District Steam Use,
  "submissions_green_power_onsite" DOUBLE  -- Submissions - Green Power Onsite,
  "submissions_natural_gas_use_kbtu" DOUBLE  -- Submissions - Natural Gas Use Kbtu,
  "submissions_district_hot_water_use" VARCHAR  -- Submissions - District Hot Water Use,
  "submissions_electricity_use_grid_purchase_kwh" DOUBLE  -- Submissions - Electricity Use Grid Purchase Kwh,
  "submissions_electricity_use_grid_purchase_kbtu" DOUBLE  -- Submissions - Electricity Use Grid Purchase Kbtu,
  "submissions_primary_property_type_epa_calculated" VARCHAR  -- Submissions - Primary Property Type Epa Calculated,
  "submissions_largest_property_use_type" VARCHAR  -- Submissions - Largest Property Use Type,
  "submissions_second_largest_property_use_type" VARCHAR  -- Submissions - Second Largest Property Use Type,
  "geo" VARCHAR,
  "weather_normalized_site_eui" DOUBLE
);