Name: _2017_Final_Master_Dataset
Display Field: Property_Name
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Denver_Building_ID (type: esriFieldTypeInteger, alias: Denver Building ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Compliance_Status (type: esriFieldTypeString, alias: Compliance Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Xcel_Update (type: esriFieldTypeString, alias: Xcel Update, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Property_Name (type: esriFieldTypeString, alias: Property Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Zipcode (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Year_Built (type: esriFieldTypeInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Property_Notes (type: esriFieldTypeString, alias: Property Notes, SQL Type: sqlTypeOther, length: 920, nullable: true, editable: true)
- Master_Property_Type (type: esriFieldTypeString, alias: Master Property Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Assessor_Sector (type: esriFieldTypeString, alias: Assessor Sector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Primary_Property_Type___EPA_Cal (type: esriFieldTypeString, alias: Primary Property Type - EPA Calculated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Master_Square_Footage (type: esriFieldTypeDouble, alias: Master Square Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ENERGY_STAR_Score (type: esriFieldTypeString, alias: ENERGY STAR Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Site_Energy_Use__kBtu_ (type: esriFieldTypeDouble, alias: Site Energy Use (kBtu), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Site_EUI__kBtu_sq_ft_ (type: esriFieldTypeDouble, alias: Site EUI (kBtu/sq ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Weather_Normalized_Site_Energy_ (type: esriFieldTypeString, alias: Weather Normalized Site Energy Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Weather_Normalized_Site_EUI__kB (type: esriFieldTypeString, alias: Weather Normalized Site EUI (kBtu/sq ft), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Electricity_use_Grid_Purchase_a (type: esriFieldTypeDouble, alias: Electricity use Grid Purchase and Onsite, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Electricity_Use___Grid_Purchase (type: esriFieldTypeDouble, alias: Electricity Use - Grid Purchase (kWh), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Electricity_Use_Onsite_Renewabl (type: esriFieldTypeString, alias: Electricity Use Onsite Renewable (kWh), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Green_Power___Offsite__kWh_ (type: esriFieldTypeInteger, alias: Green Power - Offsite (kWh), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Green_Power___Onsite__kWh_ (type: esriFieldTypeString, alias: Green Power - Onsite (kWh), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Natural_Gas_Use__kBtu_ (type: esriFieldTypeString, alias: Natural Gas Use (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- District_Steam_Use__kBtu_ (type: esriFieldTypeString, alias: District Steam Use (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- District_Chilled_Water_use__kBt (type: esriFieldTypeString, alias: District Chilled Water use (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Total_GHG_Emissions__Metric_Ton (type: esriFieldTypeDouble, alias: Total GHG Emissions (Metric Tons C02e), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ENERGY_STAR_Certification_Year_ (type: esriFieldTypeInteger, alias: ENERGY STAR Certification Year(s) Cert, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Recent_Energy_Star_Certificatio (type: esriFieldTypeInteger, alias: Recent Energy Star Certification, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: _2017_Final_Master_Dataset
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/8/2024 3:51:12 PM
Schema Last Edit Date: 7/8/2024 3:51:12 PM
Data Last Edit Date: 5/8/2024 6:07:10 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat