Name: Consumer

Display Field: Consumer.MapNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1754782.9952219725
YMin: 163744.2929635644
XMax: 1961241.8615028858
YMax: 388496.91629205644
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Consumer.PhaseCode
Field 2: Consumer.ConsumerType
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 131,0
  Label: Primary
  Description: N/A
  Symbol:
  
• Value: 135,0
  Label: Primary
  Description: N/A
  Symbol:
  
• Value: 130,0
  Label: Primary
  Description: N/A
  Symbol:
  
• Value: 129,1
  Label: A, Secondary
  Description: N/A
  Symbol:
  
• Value: 131,1
  Label: AB, Secondary
  Description: N/A
  Symbol:
  
• Value: 130,1
  Label: B, Secondary
  Description: N/A
  Symbol:
  
• Value: 134,1
  Label: BC, Secondary
  Description: N/A
  Symbol:
  
• Value: 132,1
  Label: C, Secondary
  Description: N/A
  Symbol:
  
• Value: 135,1
  Label: ABC, Secondary
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [230, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [76, 230, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [0, 92, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [230, 152, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [0, 169, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: "MN- " CONCAT [Consumer.MapNumber] CONCAT NEWLINE CONCAT "HN- " CONCAT [Consumer.SERVADDR1]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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: false
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ConsumerType

Fields:

• Consumer.MapNumber ( type: esriFieldTypeString, alias: MapNumber, length: 50 )
• Consumer.PhaseCode ( type: esriFieldTypeSmallInteger, alias: PhaseCode , Coded Values: [129: A] , [130: B] , [131: AB] , ...4 more... )
• Consumer.TransformerMapNumber ( type: esriFieldTypeString, alias: TransformerMapNumber, length: 50 )
• Consumer.Feeder ( type: esriFieldTypeString, alias: Feeder, length: 50 , Coded Values: [Snyder_Sub: Snyder_Sub] , [Oxford_Sub: Oxford_Sub] , [Scioto_Sub: Scioto_Sub] , ...59 more... )
• Consumer.MeterType ( type: esriFieldTypeSmallInteger, alias: MeterType )
• Consumer.FuturaGUID ( type: esriFieldTypeString, alias: FuturaGUID, length: 50 )
• Consumer.ConsumerType ( type: esriFieldTypeSmallInteger, alias: ConsumerType , Coded Values: [0: Primary] , [1: Secondary] )
• Consumer.KWH ( type: esriFieldTypeInteger, alias: KWH )
• Consumer.CUSTID ( type: esriFieldTypeString, alias: CUSTID, length: 32 )
• Consumer.SERVADDR1 ( type: esriFieldTypeString, alias: SERVADDR1, length: 40 )
• Consumer.METERNO ( type: esriFieldTypeString, alias: meterNo, length: 80 )
• Consumer.REVENUECLASS ( type: esriFieldTypeString, alias: REVENUECLASS, length: 20 )
• Consumer.SERVSTATUS ( type: esriFieldTypeString, alias: SERVSTATUS, length: 16 )
• Consumer.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Consumer.SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• Consumer.MapNumberPhoto ( type: esriFieldTypeString, alias: MapNumberPhoto, length: 50 )
• Consumer.OldLocation ( type: esriFieldTypeString, alias: OldLocation, length: 16 )
• Consumer.HOMEAC ( type: esriFieldTypeString, alias: homeAc, length: 3 )
• Consumer.DAYAC ( type: esriFieldTypeString, alias: dayAc, length: 3 )
• Consumer.MOBILEAC ( type: esriFieldTypeString, alias: mobileAc, length: 3 )
• Consumer.SolarSite ( type: esriFieldTypeSmallInteger, alias: SolarSite , Coded Values: [0: No] , [1: Yes] )
• Consumer.FiberZone ( type: esriFieldTypeString, alias: FiberZone, length: 8 )
• Consumer.Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Consumer.Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• CISCustomerData.LASTNAME ( type: esriFieldTypeString, alias: lastName, length: 13 )
• CISCustomerData.FIRSTNAME ( type: esriFieldTypeString, alias: firstName, length: 9 )
• CISCustomerData.MNAME ( type: esriFieldTypeString, alias: mName, length: 9 )
• CISCustomerData.BILLADDR1 ( type: esriFieldTypeString, alias: billAddr1, length: 80 )
• CISCustomerData.BILLADDR2 ( type: esriFieldTypeString, alias: billAddr2, length: 80 )
• CISCustomerData.BILLCITY ( type: esriFieldTypeString, alias: billCity, length: 80 )
• CISCustomerData.BILLZIP ( type: esriFieldTypeString, alias: billZip, length: 10 )
• CISCustomerData.HOMEPHONE ( type: esriFieldTypeString, alias: homePhone, length: 16 )
• CISCustomerData.DAYPHONE ( type: esriFieldTypeString, alias: dayPhone, length: 16 )
• CISCustomerData.HOMEAC ( type: esriFieldTypeString, alias: homeAc, length: 3 )
• CISCustomerData.DAYAC ( type: esriFieldTypeString, alias: dayAc, length: 3 )
• CISCustomerData.BILLSTATE ( type: esriFieldTypeString, alias: billState, length: 2 )
• CISCustomerData.CELLPHONE ( type: esriFieldTypeString, alias: CellPhone, length: 16 )
• CISCustomerData.CUSTNAME2 ( type: esriFieldTypeString, alias: CustName2, length: 30 )
• Consumer.FiberZoneSub ( type: esriFieldTypeString, alias: FiberZoneSub, length: 8 )
• Consumer.GlobalID ( type: esriFieldTypeGlobalID, alias: Consumer.GlobalID, length: 38 )
• Consumer.UpdatePhotos ( type: esriFieldTypeString, alias: UpdatePhotos, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Consumer.GlobalIDReference ( type: esriFieldTypeString, alias: GlobalIDReference, length: 100 )
• Consumer.GridID ( type: esriFieldTypeString, alias: GridID, length: 7 )
• Consumer.email ( type: esriFieldTypeString, alias: email, length: 75 )
• Consumer.ac_py_BoardDistrict ( type: esriFieldTypeString, alias: ac_py_BoardDistrict, length: 3 )
• Consumer.ac_py_ElectricFeeder ( type: esriFieldTypeString, alias: ac_py_ElectricFeeder, length: 5 )
• Consumer.ac_py_FiberFeeder ( type: esriFieldTypeString, alias: ac_py_FiberFeeder, length: 8 )
• Consumer.GRIDLOCATION ( type: esriFieldTypeString, alias: gridLocation, length: 50 )
• Consumer.County ( type: esriFieldTypeString, alias: County, length: 3 )
• Consumer.ac_sql_bCity ( type: esriFieldTypeString, alias: ac_sql_bCity, length: 50 )
• Consumer.ac_sql_bState ( type: esriFieldTypeString, alias: ac_sql_bState, length: 2 )
• Consumer.ac_sql_bZip ( type: esriFieldTypeString, alias: ac_sql_bZip, length: 5 )
• Consumer.ac_sql_sCity ( type: esriFieldTypeString, alias: ac_sql_sCity, length: 50 )
• Consumer.ac_sql_sState ( type: esriFieldTypeString, alias: ac_sql_sState, length: 2 )
• Consumer.ac_sql_sZip ( type: esriFieldTypeString, alias: ac_sql_sZip, length: 5 )
• Consumer.ac_py_Township ( type: esriFieldTypeString, alias: ac_py_Township, length: 28 )
• CISCustomerData.MEDICALACCOUNT ( type: esriFieldTypeString, alias: MedicalAccount, length: 3 )
• CISCustomerData.CRITICALLOADS ( type: esriFieldTypeString, alias: CriticalLoads, length: 3 )
• CISCustomerData.KEYACCOUNT ( type: esriFieldTypeString, alias: KeyAccount, length: 3 )
• CISCustomerData.CTCUSTOMERNOTE ( type: esriFieldTypeString, alias: CTCustomerNote, length: 512 )
• Consumer.EVCharger ( type: esriFieldTypeString, alias: EVCharger, length: 3 , Coded Values: [Yes: Yes] , [No: No] )

Types:

ID: 0
Name: Primary
Domains:
• Consumer.PhaseCode:
  Inherited
• Consumer.Feeder:
  Inherited
• Consumer.MeterType:
  Coded Values: [0: Residential] , [1: SmallCommerical] , [2: LargeCommercial] , ...8 more...
• Consumer.Enabled:
  Inherited

---

ID: 1
Name: Secondary
Domains:
• Consumer.PhaseCode:
  Inherited
• Consumer.Feeder:
  Inherited
• Consumer.MeterType:
  Coded Values: [0: Residential] , [1: SmallCommerical] , [2: LargeCommercial] , ...8 more...
• Consumer.Enabled:
  Inherited
• Consumer.DistributedGeneration:
  Inherited

---

Relationships:

• CISLocationData (18) -- Related To: CISLocationData (210)
• ConstructionUnits (4) -- Related To: ConstructionUnits (1)
• Photos (19) -- Related To: Photos (117)
• CISCustomerData (20) -- Related To: CISCustomerData (504)
• Photos (21) -- Related To: Photos (117)
• TransformerBank (2) -- Related To: Transformer Bank (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata