Energy and Water Use - Municipal Buildings

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.lacity.org
Id 8m62-bye6
Name Energy and Water Use - Municipal Buildings
Category A Livable and Sustainable City
Tags energy, water
Created 2016-12-16T23:26:51Z
Publication Date 2016-12-16T23:29:17Z

Description

In the spirit of leading by example, the City released benchmarking information for municipal buildings. The data includes property name, location, property size (ft?), Energy STAR scores where available, energy intensity (kBTU/ft?), water use (kilo-gallons), total GHG emissions (Metric Tons CO?e), and several more metrics.

Columns

| Included | Schema Type    | Field Name                              | Name                                    | Data Type     | Render Type   |
| ======== | ============== | ======================================= | ======================================= | ============= | ============= |
| Yes      | series tag     | cartodb_id                              | cartodb_id                              | text          | number        |
| No       |                | the_geom                                | the_geom                                | text          | text          |
| Yes      | numeric metric | indoor_water_use_all_water_sources_kgal | indoor_water_use_all_water_sources_kgal | number        | number        |
| Yes      | numeric metric | energy_star_score                       | energy_star_score                       | number        | number        |
| Yes      | numeric metric | property_gfa___self_reported_ft         | property_gfa___self_reported_ft         | number        | number        |
| Yes      | series tag     | property_id                             | property_id                             | text          | number        |
| Yes      | time           | year_ending                             | year_ending                             | calendar_date | calendar_date |
| Yes      | series tag     | department                              | department                              | text          | text          |
| Yes      | series tag     | property_name                           | property_name                           | text          | text          |
| Yes      | numeric metric | indirect_ghg_emissions_metric_tons_co2e | indirect_ghg_emissions_metric_tons_co2e | number        | number        |
| Yes      | numeric metric | direct_ghg_emissions_metric_tons_co2e   | direct_ghg_emissions_metric_tons_co2e   | number        | number        |
| Yes      | numeric metric | total_ghg_emissions_intensity_kgco2e_ft | total_ghg_emissions_intensity_kgco2e_ft | number        | number        |
| Yes      | numeric metric | total_ghg_emissions_metric_tons_co2e    | total_ghg_emissions_metric_tons_co2e    | number        | number        |
| Yes      | numeric metric | water_use_all_water_sources_kgal        | water_use_all_water_sources_kgal        | number        | number        |
| Yes      | numeric metric | weather_normalized_source_eui_kbtu_ft   | weather_normalized_source_eui_kbtu_ft   | number        | number        |
| Yes      | numeric metric | weather_normalized_site_eui_kbtu_ft     | weather_normalized_site_eui_kbtu_ft     | number        | number        |
| Yes      | numeric metric | source_eui_kbtu_ft                      | source_eui_kbtu_ft                      | number        | number        |
| Yes      | numeric metric | site_eui_kbtu_ft                        | site_eui_kbtu_ft                        | number        | number        |

Time Field

Value = year_ending
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = the_geom

Data Commands

series e:8m62-bye6 d:2014-12-31T00:00:00.000Z t:property_id=3935383 t:cartodb_id=127 t:property_name="Libraries: 51/018 Malabar Library" t:department=Libraries: m:total_ghg_emissions_metric_tons_co2e=24.7 m:water_use_all_water_sources_kgal=287.8 m:indoor_water_use_all_water_sources_kgal=0 m:weather_normalized_source_eui_kbtu_ft=146 m:total_ghg_emissions_intensity_kgco2e_ft=4.1 m:direct_ghg_emissions_metric_tons_co2e=0.2 m:energy_star_score=0 m:site_eui_kbtu_ft=47.7 m:property_gfa___self_reported_ft=6401 m:weather_normalized_site_eui_kbtu_ft=47 m:source_eui_kbtu_ft=148.3 m:indirect_ghg_emissions_metric_tons_co2e=24.5

series e:8m62-bye6 d:2014-12-31T00:00:00.000Z t:property_id=3935250 t:cartodb_id=1 t:property_name="Police Department: 9/63   Police Administration Building  PAB" t:department=Police m:total_ghg_emissions_metric_tons_co2e=3287.3 m:water_use_all_water_sources_kgal=6808.8 m:indoor_water_use_all_water_sources_kgal=0 m:weather_normalized_source_eui_kbtu_ft=211.6 m:total_ghg_emissions_intensity_kgco2e_ft=6.7 m:direct_ghg_emissions_metric_tons_co2e=863.9 m:energy_star_score=0 m:site_eui_kbtu_ft=90 m:property_gfa___self_reported_ft=491023 m:weather_normalized_site_eui_kbtu_ft=89.7 m:source_eui_kbtu_ft=213.4 m:indirect_ghg_emissions_metric_tons_co2e=2423.4

series e:8m62-bye6 d:2014-12-31T00:00:00.000Z t:property_id=3935253 t:cartodb_id=4 t:property_name="Public Works: Transamerica Public works 1/88" t:department=Public m:total_ghg_emissions_metric_tons_co2e=1625.3 m:water_use_all_water_sources_kgal=0 m:indoor_water_use_all_water_sources_kgal=0 m:weather_normalized_source_eui_kbtu_ft=0 m:total_ghg_emissions_intensity_kgco2e_ft=3.9 m:direct_ghg_emissions_metric_tons_co2e=0 m:energy_star_score=85 m:site_eui_kbtu_ft=44.9 m:property_gfa___self_reported_ft=417170 m:weather_normalized_site_eui_kbtu_ft=0 m:source_eui_kbtu_ft=141 m:indirect_ghg_emissions_metric_tons_co2e=1625.3

Meta Commands

metric m:indoor_water_use_all_water_sources_kgal p:integer l:indoor_water_use_all_water_sources_kgal t:dataTypeName=number

metric m:energy_star_score p:integer l:energy_star_score t:dataTypeName=number

metric m:property_gfa___self_reported_ft p:integer l:property_gfa___self_reported_ft t:dataTypeName=number

metric m:indirect_ghg_emissions_metric_tons_co2e p:float l:indirect_ghg_emissions_metric_tons_co2e t:dataTypeName=number

metric m:direct_ghg_emissions_metric_tons_co2e p:float l:direct_ghg_emissions_metric_tons_co2e t:dataTypeName=number

metric m:total_ghg_emissions_intensity_kgco2e_ft p:float l:total_ghg_emissions_intensity_kgco2e_ft t:dataTypeName=number

metric m:total_ghg_emissions_metric_tons_co2e p:float l:total_ghg_emissions_metric_tons_co2e t:dataTypeName=number

metric m:water_use_all_water_sources_kgal p:float l:water_use_all_water_sources_kgal t:dataTypeName=number

metric m:weather_normalized_source_eui_kbtu_ft p:float l:weather_normalized_source_eui_kbtu_ft t:dataTypeName=number

metric m:weather_normalized_site_eui_kbtu_ft p:double l:weather_normalized_site_eui_kbtu_ft t:dataTypeName=number

metric m:source_eui_kbtu_ft p:float l:source_eui_kbtu_ft t:dataTypeName=number

metric m:site_eui_kbtu_ft p:float l:site_eui_kbtu_ft t:dataTypeName=number

entity e:8m62-bye6 l:"Energy and Water Use - Municipal Buildings" t:url=https://data.lacity.org/api/views/8m62-bye6

property e:8m62-bye6 t:meta.view v:id=8m62-bye6 v:category="A Livable and Sustainable City" v:averageRating=0 v:name="Energy and Water Use - Municipal Buildings"

property e:8m62-bye6 t:meta.view.owner v:id=32qq-7d8m v:screenName=jmolayem v:displayName=jmolayem

property e:8m62-bye6 t:meta.view.tableauthor v:id=32qq-7d8m v:screenName=jmolayem v:roleName=administrator v:displayName=jmolayem

Top Records

| cartodb_id | the_geom                                           | indoor_water_use_all_water_sources_kgal | energy_star_score | property_gfa___self_reported_ft | property_id | year_ending         | department | property_name                                                    | indirect_ghg_emissions_metric_tons_co2e | direct_ghg_emissions_metric_tons_co2e | total_ghg_emissions_intensity_kgco2e_ft | total_ghg_emissions_metric_tons_co2e | water_use_all_water_sources_kgal | weather_normalized_source_eui_kbtu_ft | weather_normalized_site_eui_kbtu_ft | source_eui_kbtu_ft | site_eui_kbtu_ft | 
| ========== | ================================================== | ======================================= | ================= | =============================== | =========== | =================== | ========== | ================================================================ | ======================================= | ===================================== | ======================================= | ==================================== | ================================ | ===================================== | =================================== | ================== | ================ | 
| 127        | 0101000020E6100000F622DA8EA98C5DC0C8444AB379064140 | 0                                       | 0                 | 6401                            | 3935383     | 2014-12-31T00:00:00 | Libraries: | Libraries: 51/018 Malabar Library                                | 24.5                                    | 0.2                                   | 4.1                                     | 24.7                                 | 287.8                            | 146                                   | 47                                  | 148.3              | 47.7             | 
| 1          | 0101000020E61000008B4F01309E8F5DC0B69E211CB3064140 | 0                                       | 0                 | 491023                          | 3935250     | 2014-12-31T00:00:00 | Police     | Police Department: 9/63 Police Administration Building PAB       | 2423.4                                  | 863.9                                 | 6.7                                     | 3287.3                               | 6808.8                           | 211.6                                 | 89.7                                | 213.4              | 90               | 
| 4          | 0101000020E610000009A87004A9905DC0143E5B0707054140 | 0                                       | 85                | 417170                          | 3935253     | 2014-12-31T00:00:00 | Public     | Public Works: Transamerica Public works 1/88                     | 1625.3                                  | 0                                     | 3.9                                     | 1625.3                               | 0                                | 0                                     | 0                                   | 141                | 44.9             | 
| 8          | 0101000020E610000078F2E9B12DA85DC0A69D9ACB0D1C4140 | 0                                       | 0                 | 57723                           | 3935259     | 2014-12-31T00:00:00 | Police     | Police Department: 9/83 911 Valley Communication Dispatch        | 791.6                                   | 6.5                                   | 14.5                                    | 798.2                                | 486.3                            | 514.3                                 | 165.3                               | 523.2              | 168.1            | 
| 9          | 0101000020E6100000C3F2E7DB828E5DC0C1A8A44E40034140 | 0                                       | 0                 | 4597                            | 3935260     | 2014-12-31T00:00:00 | Street     | Street Maintenance (BSS): 08/025 Street Services Asphalt Plant#1 | 379.5                                   | 1559.7                                | 421.9                                   | 1939.2                               | 133.9                            | 0                                     | 0                                   | 9695               | 7339.3           | 
| 10         | 0101000020E61000009A44BDE0D38F5DC045D7851F9C054140 | 0                                       | 0                 | 50635                           | 3935261     | 2014-12-31T00:00:00 | Police     | Police Department: 9/20 Central Facilities Building              | 997.3                                   | 131.4                                 | 22.3                                    | 1128.7                               | 2185.3                           | 770                                   | 281.5                               | 764.1              | 275.9            | 
| 11         | 0101000020E61000003CC093162E945DC03C4B901150114140 | 0                                       | 0                 | 5597                            | 3935262     | 2014-12-31T00:00:00 | ITA:       | ITA: 1/9 Mount Lee                                               | 345.7                                   | 0                                     | 61.8                                    | 345.7                                | 112.2                            | 2234.9                                | 711.7                               | 2234.9             | 711.7            | 
| 12         | 0101000020E610000001BA2F67B68F5DC083F755B950074140 | 0                                       | 0                 | 166221                          | 3935263     | 2014-12-31T00:00:00 | Police     | Police Department: 9/5 EOC Emergency Operations Center           | 1317.2                                  | 63                                    | 11                                      | 1380.2                               | 457.5                            | 384.7                                 | 129                                 | 390.8              | 130.8            | 
| 13         | 0101000020E610000000193A7650905DC0569DD5027B064140 | 0                                       | 0                 | 538802                          | 3935264     | 2014-12-31T00:00:00 | Libraries: | Libraries: 51/100 Central Library                                | 1866.3                                  | 443.8                                 | 4.6                                     | 2310.2                               | 9067.7                           | 149.2                                 | 58.6                                | 151.2              | 59.2             | 
| 14         | 0101000020E61000001AD99596919C5DC0DDB6EF517F174140 | 0                                       | 0                 | 69146                           | 3935265     | 2014-12-31T00:00:00 | Police     | Police Department: 9/1 Van Nuys Police                           | 932.9                                   | 400.3                                 | 19.3                                    | 1333.2                               | 3714.5                           | 0                                     | 0                                   | 602.7              | 264.5            |