Name: BenchmarkingDSMEnergyReport
Display Field: propertyname
Type: Table
Geometry Type: N/A
Description:
Service Item Id: b9fc8808e5394d29b0b0c218ca22dece
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
objectid
(
nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID
)
-
buildingid
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Des Moines Building ID, type: esriFieldTypeString
)
-
reportyear
(
nullable: true, editable: true, defaultValue: null, length: 128, alias: Report Year, type: esriFieldTypeString
)
-
yearbuilt
(
nullable: true, editable: true, defaultValue: null, alias: Year Built, type: esriFieldTypeSmallInteger
)
-
propertyaddress
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Property Address, type: esriFieldTypeString
)
-
occupancy
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Occupancy, type: esriFieldTypeString
)
-
primarypropertytype
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Primary Property Type, type: esriFieldTypeString
)
-
numberofbuildings
(
nullable: true, editable: true, defaultValue: null, alias: Number of Buildings, type: esriFieldTypeSmallInteger
)
-
propertydataadministrator
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Property Data Administrator, type: esriFieldTypeString
)
-
property_data_administrator_ema
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Property Data Administrator Email, type: esriFieldTypeString
)
-
energystarcertified
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Energy Star Certified, type: esriFieldTypeString
)
-
propertyname
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Property Name, type: esriFieldTypeString
)
-
parentpropertyname
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Parent Property Name, type: esriFieldTypeString
)
-
propertygfa_selfreported
(
nullable: true, editable: true, defaultValue: null, alias: Property GFA - Self Reported SqFt, type: esriFieldTypeDouble
)
-
propertygfa_epacalculated_build
(
nullable: true, editable: true, defaultValue: null, alias: Property GFA - EPA Calculated (Buildings) SqFt, type: esriFieldTypeDouble
)
-
propertygfa_epacalculated_parki
(
nullable: true, editable: true, defaultValue: null, alias: Property GFA - EPA Calculated (Parking) SqFt, type: esriFieldTypeDouble
)
-
largestpropertyusetype
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Largest Property Use Type, type: esriFieldTypeString
)
-
largestpropertyusetype_grossflo
(
nullable: true, editable: true, defaultValue: null, alias: Largest Property Use Type - Gross Floor Area SqFt, type: esriFieldTypeDouble
)
-
secondlargestpropertyusetype
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: 2nd Largest Property Use Type, type: esriFieldTypeString
)
-
secondlargestpropertyusetype_gr
(
nullable: true, editable: true, defaultValue: null, alias: 2nd Largest Property Use Type - Gross Floor Area SqFt, type: esriFieldTypeDouble
)
-
thirdlargestpropertyusetype
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: 3rd Largest Property Use Type, type: esriFieldTypeString
)
-
thirdlargestpropertyusetype_gro
(
nullable: true, editable: true, defaultValue: null, alias: 3rd Largest Property Use Type - Gross Floor Area SqFt, type: esriFieldTypeDouble
)
-
energystarscore
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Energy Star Score, type: esriFieldTypeString
)
-
electricityuse
(
nullable: true, editable: true, defaultValue: null, alias: Electricity Use (kWh), type: esriFieldTypeDouble
)
-
naturalgasuse
(
nullable: true, editable: true, defaultValue: null, alias: Natural Gas Use (therms), type: esriFieldTypeDouble
)
-
wateruse
(
nullable: true, editable: true, defaultValue: null, alias: Water Use (All Sources - Kgal), type: esriFieldTypeDouble
)
-
siteenergy
(
nullable: true, editable: true, defaultValue: null, alias: Site Energy Use (kBtu), type: esriFieldTypeDouble
)
-
siteeui
(
nullable: true, editable: true, defaultValue: null, alias: Site EUI (kBtu/ft2), type: esriFieldTypeDouble
)
-
totalghgemissions
(
nullable: true, editable: true, defaultValue: null, alias: Total GHG Emissions (Metric Tons CO2e), type: esriFieldTypeDouble
)
-
propertynotes
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Property Notes, type: esriFieldTypeString
)
-
weathernormalizedsiteenergyuse
(
nullable: true, editable: true, defaultValue: null, alias: Weather Normalized Site Energy Use (kBtu), type: esriFieldTypeDouble
)
-
weathernormalizedsiteeui
(
nullable: true, editable: true, defaultValue: null, alias: Weather Normalized Site EUI (kBtu/ft2), type: esriFieldTypeDouble
)
-
weathernormalizedsitenaturalgas
(
nullable: true, editable: true, defaultValue: null, alias: Weather Normalized Site Natural Gas Intensity (therms/ft2), type: esriFieldTypeDouble
)
-
waterscore
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Water Score (Multi-Family only), type: esriFieldTypeString
)
-
wateruseintensity
(
nullable: true, editable: true, defaultValue: null, alias: Water Use Intensity (gal/ft2), type: esriFieldTypeDouble
)
-
energystarcertlength
(
nullable: true, editable: true, defaultValue: null, alias: Energy Star Certification - Year(s) Certified, type: esriFieldTypeSmallInteger
)
-
remark
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Remark, type: esriFieldTypeString
)
-
pkid
(
nullable: true, editable: true, defaultValue: null, alias: PKId, type: esriFieldTypeInteger
)
-
dataowner
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: DataOwner, type: esriFieldTypeString
)
-
extlid
(
nullable: true, editable: true, defaultValue: null, alias: ExtlID, type: esriFieldTypeDouble
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID
)
-
created_user
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString
)
-
created_date
(
nullable: true, editable: true, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate
)
-
last_edited_user
(
nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString
)
-
last_edited_date
(
nullable: true, editable: true, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate
)
Templates:
-
Name: BenchmarkingDSMEnergyReport
Description:
Prototype:
weathernormalizedsitenaturalgas: null
propertynotes: null
occupancy: null
wateruseintensity: null
remark: null
energystarscore: null
siteenergy: null
electricityuse: null
thirdlargestpropertyusetype_gro: null
buildingid: null
wateruse: null
propertygfa_selfreported: null
propertygfa_epacalculated_build: null
thirdlargestpropertyusetype: null
last_edited_date: null
weathernormalizedsiteeui: null
reportyear: null
totalghgemissions: null
waterscore: null
propertygfa_epacalculated_parki: null
numberofbuildings: null
pkid: null
propertyname: null
created_user: null
property_data_administrator_ema: null
secondlargestpropertyusetype: null
secondlargestpropertyusetype_gr: null
largestpropertyusetype: null
weathernormalizedsiteenergyuse: null
extlid: null
yearbuilt: null
parentpropertyname: null
last_edited_user: null
propertydataadministrator: null
dataowner: null
primarypropertytype: null
siteeui: null
energystarcertlength: null
created_date: null
energystarcertified: null
naturalgasuse: null
propertyaddress: null
largestpropertyusetype_grossflo: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Create,Editing,Query,Update,Uploads,Delete
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Query Related Records
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Metadata