Please enable JavaScript.
Coggle requires JavaScript to display documents.
Retrofit sales lead generation project using public utility data - Coggle…
Retrofit sales lead generation project
using public utility data
Public (LL84)
2019 LL84 data
data cleaning
(remove duplicates and remove the rows with multiple bin number)
23,729
buildings (w/ single bin number)
(> 25,000 SF)
Bright Power
SELECT sa.site_id, sa.address1, s.city, s.state, s.site_type, s.zip_code
FROM esc_prod_db.site s LEFT JOIN esc_prod_db.site_address sa ON s.id = sa.site_id
WHERE s.state LIKE "NY" AND s.zip_code IN (10001, 10002,…
data cleaning
(remove duplicates and remove rows w/ na values in address) :
4,695
buildings
Target Building
(BP uncovered)
20,850
builings
Dataset
columns
ETC
address 1 (self-reported)
street number
street name
number of buildings
weather normalized source eui
site EUI
weather normalized site eui
Weather Normalized Site Electricity Intensity (kWh/ft²)
weather normalized natural gas intensity
Natural Gas Use (kBtu)
Weather Normalized Site Natural Gas Use (therms)
Electricity Use - Grid Purchase (kBtu)
Electricity Use - Grid Purchase (kWh)
Weather Normalized Site Electricity (kWh)
Direct GHG Emissions (Metric Tons CO2e)
Indirect GHG Emissions (Metric Tons CO2e)
Water Use (All Water Sources) (kgal)
borough
property id
CORE
Largest property use type
Year built
ENERGY STAR Score
Source EUI (kBtu/ft²)
Total GHG Emissions (Metric Tons CO2e)
Water Use Intensity (All Water Sources) (gal/ft²)
DOF gross Floor area
Things to do
Data Visualization
Heat map
Research Contact Point
Building owner or Property management company
Property Browser
Outreach