View In:   ArcGIS Online Map Viewer

Parent Layer: February 23

Name: Smart Facilities Energy

Display Field: ALTR_BLDN_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The dataset represents data and information from the SmartFacility application. The metered data is representative of the council facilities that have been metered with electricity Automated Meter Infrastructure (AMI’s) through the municipal operations metering project. The metered data is obtained from the Electricity PnPScada system. The water data is either from the smart water metered facilities or the actual water billing consumption figures within the ERP SAP system.

Copyright Text: Sustainable Energy Markets Department, City of Cape Town

Default Visibility: true

MaxRecordCount: 250000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 2041568.927720248
YMin: -4059691.6403863984
XMax: 2102553.5293789348
YMax: -3963461.8235316705
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ID, editable: false, nullable: false, defaultValue: null, modelName: ID )
• LIS_KEY ( type: esriFieldTypeInteger, alias: LIS Key, editable: true, nullable: true, defaultValue: null, modelName: LIS_KEY )
• ALTR_BLDN_NAME ( type: esriFieldTypeString, alias: Alternative Building Name, editable: true, nullable: false, length: 100, defaultValue: null, modelName: AlternativeBuildingName )
• FCLT_TYPE_DSCR ( type: esriFieldTypeString, alias: Facility Type Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FCLT_TYPE_DSCR )
• DPRT_DSCR ( type: esriFieldTypeString, alias: Department Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DPRT_DSCR )
• FCLT_Y_CRDN ( type: esriFieldTypeDouble, alias: Facility Coordinate Latitude, editable: true, nullable: true, defaultValue: null, modelName: FCLT_Y_CRDN )
• FCLT_X_CRDN ( type: esriFieldTypeDouble, alias: Facility Coordinate Longitude, editable: true, nullable: true, defaultValue: null, modelName: FCLT_X_CRDN )
• PRTY_Y_CRDN ( type: esriFieldTypeDouble, alias: Property Coordinate Latitude, editable: true, nullable: true, defaultValue: null, modelName: PRTY_Y_CRDN )
• PRTY_X_CRDN ( type: esriFieldTypeDouble, alias: Property Coordinate Longitude, editable: true, nullable: true, defaultValue: null, modelName: PRTY_X_CRDN )
• SF_BLDN_USE_SPC ( type: esriFieldTypeDouble, alias: SF Building Use Space Gross floor area (m2), editable: true, nullable: true, defaultValue: null, modelName: SF_BLDN_USE_SPC )
• LAST_RDNG_DATE_TIME ( type: esriFieldTypeDate, alias: Last Reading Date Timestamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_RDNG_DATE_TIME )
• CLND_YEAR ( type: esriFieldTypeSmallInteger, alias: Calendar Year, editable: true, nullable: false, defaultValue: null, modelName: CalendarYear )
• CLND_MNTH_NMBR ( type: esriFieldTypeSmallInteger, alias: Calendar Month Number, editable: true, nullable: false, defaultValue: null, modelName: CalendarMonthNo )
• MNTH_DATE_RCRD ( type: esriFieldTypeString, alias: Monthly Date Recorded, editable: true, nullable: false, length: 9, defaultValue: null, modelName: MonthlyDateRecorded )
• MNTH_ELCT_BSLN ( type: esriFieldTypeDouble, alias: Monthly Electricity Baseline, editable: true, nullable: true, defaultValue: null, modelName: MNTH_ELCT_BSLN )
• MNTH_ELCT_CNSM ( type: esriFieldTypeDouble, alias: Monthly Electricity Consumption, editable: true, nullable: true, defaultValue: null, modelName: MNTH_ELCT_CNSM )
• MNTH_ELCT_SVNG ( type: esriFieldTypeDouble, alias: Monthly Electricity Saving, editable: true, nullable: true, defaultValue: null, modelName: MNTH_ELCT_SVNG )
• MNTH_CRDN_EMTD ( type: esriFieldTypeDouble, alias: Monthly Carbon Emitted, editable: true, nullable: true, defaultValue: null, modelName: MNTH_CRDN_EMTD )
• MNTH_CRBN_SVNG ( type: esriFieldTypeDouble, alias: Monthly Carbon Saving, editable: true, nullable: true, defaultValue: null, modelName: MNTH_CRBN_SVNG )
• ANL_ELCT_BSLN ( type: esriFieldTypeDouble, alias: Annual Electricity Baseline, editable: true, nullable: true, defaultValue: null, modelName: ANL_ELCT_BSLN )
• ANL_ELCT_CNSM ( type: esriFieldTypeDouble, alias: Annual Electricity Consumption, editable: true, nullable: true, defaultValue: null, modelName: ANL_ELCT_CNSM )
• ANL_ELCT_SVNG ( type: esriFieldTypeDouble, alias: Annual Electricity Saving, editable: true, nullable: true, defaultValue: null, modelName: ANL_ELCT_SVNG )
• ANL_CRBN_SVNG ( type: esriFieldTypeDouble, alias: Annual Carbon Saving, editable: true, nullable: true, defaultValue: null, modelName: ANL_CRBN_SVNG )
• ANL_ELCT_BNCH ( type: esriFieldTypeDouble, alias: Annual Electricity Benchmark, editable: true, nullable: true, defaultValue: null, modelName: ANL_ELCT_BNCH )

Templates:

• Name: Smart Facilities Energy
  Description:
  Prototype:
  ANL_CRBN_SVNG: null
  ANL_ELCT_BNCH: null
  LIS_KEY: null
  ALTR_BLDN_NAME:
  FCLT_TYPE_DSCR: null
  DPRT_DSCR: null
  FCLT_Y_CRDN: null
  FCLT_X_CRDN: null
  PRTY_Y_CRDN: null
  PRTY_X_CRDN: null
  SF_BLDN_USE_SPC: null
  LAST_RDNG_DATE_TIME: null
  CLND_YEAR: 0
  CLND_MNTH_NMBR: 0
  MNTH_DATE_RCRD:
  MNTH_ELCT_BSLN: null
  MNTH_ELCT_CNSM: null
  MNTH_ELCT_SVNG: null
  MNTH_CRDN_EMTD: null
  MNTH_CRBN_SVNG: null
  ANL_ELCT_BSLN: null
  ANL_ELCT_CNSM: null
  ANL_ELCT_SVNG: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata