Name: Energy Water Benchmarking Ordinance - Usage

Display Field:

Type: Table

Description:

Energy and water usage data for City-owned buildings. Each record represents usage over a particular time period with the type of usage indicated including electricity, gas, steam, or water. In the future this dataset will include usage data for all buildings in Detroit that are over 25,000 square feet and thus fall under the Energy and Water Benchmarking Ordinance passed by City Council in 2023. This usage data is sourced from Energy Star Portfolio Manager and is updated on a daily basis.

This usage data is related to buildings represented in the Energy Water Benchmarking Ordinance - Buildings Dataset.

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• meter_entry_id (type: esriFieldTypeDouble, alias: Meter Entry ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• building_id (type: esriFieldTypeString, alias: Building ID, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• usage_start_date (type: esriFieldTypeDateOnly, alias: Start Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• usage_end_date (type: esriFieldTypeDateOnly, alias: End Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• meter_type (type: esriFieldTypeString, alias: Meter Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• units (type: esriFieldTypeString, alias: Units, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• total_usage (type: esriFieldTypeDouble, alias: Usage, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/28/2025 9:18:30 AM

Schema Last Edit Date: 7/28/2025 9:18:30 AM

Data Last Edit Date: 7/28/2025 9:18:30 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat