Layer: CEDARS_CPUC_2017_NetGWh_Per1000

View In: Map Viewer

Name: CEDARS_CPUC_2017_NetGWh_Per1000_LowIncome

Display Field: PO_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Source:http://eestats.cpuc.ca.gov/Views/EEDataPortal.aspx, NetGWhTableauData_Map_2016vw (Reporting_2016) - 20171107 aaZipcode_ESRI_2016Method:Converted tableau file to csvQueried out Residential SectorSummary Statistics Energy Savings table to sum GWh by ZIP codeJoined NetGWh table to ZIP Code GIS dataZIPs that failed to join were geocoded and added to the nearest ZIP code in the GIS dataGWh values were divided by Population/1000

Copyright Text:

Min. Scale: 10000000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[115,223,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,132,168,255],"width":0.4}},"label":"","description":""},"transparency":50,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ZIP_CODE (type: esriFieldTypeString, alias: ZIP_CODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PO_NAME (type: esriFieldTypeString, alias: PO_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
POPULATION (type: esriFieldTypeInteger, alias: POPULATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
POP_SQMI (type: esriFieldTypeDouble, alias: POP_SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Residential_GWh (type: esriFieldTypeDouble, alias: Residential_GWh, SQL Type: sqlTypeOther, nullable: true, editable: true)
Residential_GWh_Per_1000 (type: esriFieldTypeDouble, alias: Residential_GWh_Per_1000, SQL Type: sqlTypeOther, nullable: true, editable: true)
Intersect_Low_Income (type: esriFieldTypeString, alias: Intersect_Low_Income, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/4/2018 5:13:50 PM

Schema Last Edit Date: 6/4/2018 5:13:50 PM

Data Last Edit Date: 6/4/2018 5:13:50 PM

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

Layer: CEDARS_CPUC_2017_NetGWh_Per1000_LowIncome (ID:0)