Name: Consumer-BillingCycle

Display Field: Consumer.MapNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: CISLocationData.BILLINGCYCLE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: 1
  Description: N/A
  Symbol:
  
• Value: 2
  Label: 2
  Description: N/A
  Symbol:
  
• Value: 3
  Label: 3
  Description: N/A
  Symbol:
  
• Value: 4
  Label: 4
  Description: N/A
  Symbol:
  
• Value: 6
  Label: 6
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [Consumer.MapNumber]
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: [Consumer.MapNumber]
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: [Consumer.MapNumber]
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: [Consumer.MapNumber]
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: [Consumer.MapNumber]
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: [Consumer.MapNumber]
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.SERVADDR1 ( type: esriFieldTypeString, alias: SERVADDR1, length: 40 )
• Consumer.METERNO ( type: esriFieldTypeString, alias: meterNo, length: 80 )
• 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] )
• CISLocationData.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• CISLocationData.GRIDLOCATION ( type: esriFieldTypeString, alias: gridLocation, length: 16 )
• CISLocationData.LOCNUMBER ( type: esriFieldTypeString, alias: LocNumber, length: 16 )
• CISLocationData.INSERTEDBY ( type: esriFieldTypeString, alias: InsertedBy, length: 15 )
• CISLocationData.SERVADDR1 ( type: esriFieldTypeString, alias: SERVADDR1, length: 40 )
• CISLocationData.SERVADDR2 ( type: esriFieldTypeString, alias: SERVADDR2, length: 40 )
• CISLocationData.SERVZIP ( type: esriFieldTypeString, alias: SERVZIP, length: 10 )
• CISLocationData.SERVTYPE ( type: esriFieldTypeString, alias: SERVTYPE, length: 40 )
• CISLocationData.PHASECD ( type: esriFieldTypeString, alias: PHASECD, length: 10 )
• CISLocationData.COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• CISLocationData.SERVCITY ( type: esriFieldTypeString, alias: SERVCITY, length: 18 )
• CISLocationData.SERVSTATE ( type: esriFieldTypeString, alias: SERVSTATE, length: 5 )
• CISLocationData.CONNECTDATE ( type: esriFieldTypeString, alias: CONNECTDATE, length: 32 )
• CISLocationData.DISCONNECTDATE ( type: esriFieldTypeString, alias: DISCONNECTDATE, length: 32 )
• CISLocationData.CUSTID ( type: esriFieldTypeString, alias: CUSTID, length: 32 )
• CISLocationData.ACCOUNTNUMBER ( type: esriFieldTypeString, alias: ACCOUNTNUMBER, length: 32 )
• CISLocationData.REVENUECLASS ( type: esriFieldTypeString, alias: REVENUECLASS, length: 20 , Coded Values: [COOP+0: REVENUE CLASS 0] , [COGAS+1: RESIDENTIAL METERED] , [COOP+1: RESIDENTIAL SALES] , ...24 more... )
• CISLocationData.SERVSTATUS ( type: esriFieldTypeString, alias: SERVSTATUS, length: 16 , Coded Values: [1: Active] , [2: Active Secondary Service at Location] , [3: Active DVC Only] , ...20 more... )
• CISLocationData.BILLINGCYCLE ( type: esriFieldTypeString, alias: BILLINGCYCLE, length: 16 )
• CISLocationData.ROUTE ( type: esriFieldTypeString, alias: ROUTE, length: 32 , Coded Values: [1: METER READER] , [2: METER READER] , [3: METER READER] , ...115 more... )
• CISLocationData.SPECIALNEEDS ( type: esriFieldTypeString, alias: SPECIALNEEDS, length: 40 )
• CISLocationData.BOARDDIST ( type: esriFieldTypeString, alias: BOARDDIST, length: 40 , Coded Values: [001: KENT KRAMER] , [002: DAVID ERICKSON] , [003: TIM BACHELDER] , ...6 more... )
• CISLocationData.DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 40 , Coded Values: [001: North] , [002: South] , [1N: dist gas] )
• CISLocationData.FEEDER ( type: esriFieldTypeString, alias: FEEDER, length: 40 )
• CISLocationData.FRANCHISEDIST ( type: esriFieldTypeString, alias: FRANCHISEDIST, length: 40 , Coded Values: )
• CISLocationData.TAXDIST ( type: esriFieldTypeString, alias: TAXDIST, length: 40 , Coded Values: [0: 59-0100 Mrw/GileadTwp/MGSD] , [111: This is a test, this is only a] )
• CISLocationData.SCHOOLDIST ( type: esriFieldTypeString, alias: SCHOOLDIST, length: 40 , Coded Values: [002: 5902-HIGHLAND SD] )
• CISLocationData.SUBSTATIONCODE ( type: esriFieldTypeString, alias: SUBSTATIONCODE, length: 40 , Coded Values: [1: SNYDER] , [10: OXFORD] , [11: SCIOTO] , ...14 more... )
• CISLocationData.SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, length: 40 )
• CISLocationData.EALOCNAME ( type: esriFieldTypeString, alias: EALOCNAME, length: 40 )
• CISLocationData.POLENO ( type: esriFieldTypeString, alias: POLENO, length: 40 )
• CISLocationData.TOWNSHIP ( type: esriFieldTypeString, alias: TOWNSHIP, length: 40 )
• CISLocationData.RANGE ( type: esriFieldTypeString, alias: RANGE, length: 40 )
• CISLocationData.LOT ( type: esriFieldTypeString, alias: LOT, length: 40 )
• CISLocationData.CITYCODE ( type: esriFieldTypeString, alias: CITYCODE, length: 40 , Coded Values: [: NONE] , [010: 42-BERLN/59-BENNGTON/21-BERKSH] , [020: BENNINGTON] , ...49 more... )
• CISLocationData.BLOCK ( type: esriFieldTypeString, alias: BLOCK, length: 40 )
• CISLocationData.LINEMANSERVICEAREA ( type: esriFieldTypeString, alias: LINEMANSERVICEAREA, length: 40 , Coded Values: [001: North] , [002: South] )
• CISLocationData.LINKEDTRANSBANKID ( type: esriFieldTypeString, alias: LINKEDTRANSBANKID, length: 40 )
• CISLocationData.MOBILEAC ( type: esriFieldTypeString, alias: mobileAc, length: 3 )
• CISLocationData.MOBILEPHONE ( type: esriFieldTypeString, alias: mobilePhone, length: 7 )
• CISLocationData.BUDGBILL ( type: esriFieldTypeString, alias: budgBill, length: 40 )
• CISLocationData.CONNECTIONTYPE ( type: esriFieldTypeString, alias: ConnectionType, length: 40 )
• CISLocationData.LOADMGMT ( type: esriFieldTypeString, alias: loadMgmt, length: 40 )
• CISLocationData.SITEID ( type: esriFieldTypeString, alias: siteID, length: 40 )
• CISLocationData.SONUMBER ( type: esriFieldTypeString, alias: soNumber, length: 40 )
• CISLocationData.WONUMBER ( type: esriFieldTypeString, alias: woNumber, length: 40 )
• CISLocationData.BILLDATE ( type: esriFieldTypeDate, alias: billDate, length: 8 )
• CISLocationData.ISCOGENERATIONSITE ( type: esriFieldTypeString, alias: isCogenerationSite, length: 32 )
• CISLocationData.ISPREPAY ( type: esriFieldTypeString, alias: isPrePay, length: 32 )
• CISLocationData.LASTBILLAMOUNT ( type: esriFieldTypeDouble, alias: lastBillAmount )
• CISLocationData.LASTPAYMENTAMOUNT ( type: esriFieldTypeDouble, alias: lastPaymentAmount )
• CISLocationData.LASTPAYMENTDATE ( type: esriFieldTypeDate, alias: lastPaymentDate, length: 8 )
• CISLocationData.PAYMENTDUEDATE ( type: esriFieldTypeDate, alias: paymentDueDate, length: 8 )
• CISLocationData.SHUTOFFDATE ( type: esriFieldTypeDate, alias: shutOffDate, length: 8 )
• CISLocationData.UID ( type: esriFieldTypeGUID, alias: UID, length: 38 )
• CISLocationData.MODIFIEDTIME ( type: esriFieldTypeDate, alias: ModifiedTime, length: 8 )
• Consumer.FiberZone ( type: esriFieldTypeString, alias: FiberZone, length: 8 )
• Consumer.Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Consumer.Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• 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 )
• CISLocationData.MUNICIPALITYCODE ( type: esriFieldTypeString, alias: MunicipalityCode, length: 40 )
• CISLocationData.BREAKERNBR ( type: esriFieldTypeString, alias: breakerNbr, length: 40 )
• CISLocationData.EMERGENCYADDRESS ( type: esriFieldTypeString, alias: EmergencyAddress, length: 40 )
• CISLocationData.CTNOTES ( type: esriFieldTypeString, alias: CTNotes, length: 512 )
• CISLocationData.RATECODE ( type: esriFieldTypeString, alias: rateCode, length: 30 )
• CISLocationData.READINGNOTES ( type: esriFieldTypeString, alias: readingNotes, length: 255 )
• CISLocationData.CTSERVLOCNOTE ( type: esriFieldTypeString, alias: CTServLocNote, length: 512 )
• CISLocationData.CTACCOUNTNOTE ( type: esriFieldTypeString, alias: CTAccountNote, length: 512 )
• CISLocationData.CTCUSTOMERNOTE ( type: esriFieldTypeString, alias: CTCustomerNote, length: 512 )
• CISLocationData.BIVOTESW ( type: esriFieldTypeString, alias: biVoteSW, length: 40 )
• CISLocationData.DELIVERYVOLTAGE ( type: esriFieldTypeString, alias: deliveryVoltage, length: 15 )
• CISLocationData.PLACEMENT ( type: esriFieldTypeString, alias: placement, length: 15 )
• CISLocationData.MAINTENANCEDATE ( type: esriFieldTypeString, alias: maintenanceDate, length: 40 )
• CISLocationData.INSTRUMENTTYPE ( type: esriFieldTypeString, alias: instrumentType, length: 40 )
• CISLocationData.SONO ( type: esriFieldTypeString, alias: sono, length: 40 )
• CISLocationData.SOSTATUS ( type: esriFieldTypeString, alias: soStatus, length: 40 )
• CISLocationData.USERNAME ( type: esriFieldTypeString, alias: Username, length: 50 )
• CISLocationData.RATING1 ( type: esriFieldTypeString, alias: Rating1, length: 10 )
• CISLocationData.RATING2 ( type: esriFieldTypeString, alias: Rating2, length: 10 )
• CISLocationData.RATING3 ( type: esriFieldTypeString, alias: Rating3, length: 10 )
• CISLocationData.FIREDISTRICT ( type: esriFieldTypeString, alias: fireDistrict, length: 40 )
• CISLocationData.ACRECEIVABLE30DUEDATE ( type: esriFieldTypeDate, alias: acReceivable30DueDate, length: 8 )
• CISLocationData.ACRECEIVABLE30DUEDATESPECIFIED ( type: esriFieldTypeString, alias: acReceivable30DueDateSpecified, length: 32 )
• CISLocationData.ACRECEIVABLE60DUEDATE ( type: esriFieldTypeDate, alias: acReceivable60DueDate, length: 8 )
• CISLocationData.ACRECEIVABLE60DUEDATESPECIFIED ( type: esriFieldTypeString, alias: acReceivable60DueDateSpecified, length: 32 )
• CISLocationData.ACRECEIVABLE90DUEDATE ( type: esriFieldTypeDate, alias: acReceivable90DueDate, length: 8 )
• CISLocationData.ACRECEIVABLE90DUEDATESPECIFIED ( type: esriFieldTypeString, alias: acReceivable90DueDateSpecified, length: 32 )
• CISLocationData.OUTAGESTATUS ( type: esriFieldTypeInteger, alias: outageStatus )
• CISLocationData.RETIREDDATE ( type: esriFieldTypeDate, alias: RetiredDate, length: 8 )
• 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
• CISLocationData.FEEDER:
  Coded Values: [Snyder_Sub: Snyder_Sub] , [Oxford_Sub: Oxford_Sub] , [Scioto_Sub: Scioto_Sub] , ...59 more...

---

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
• CISLocationData.FEEDER:
  Coded Values: [Snyder_Sub: Snyder_Sub] , [Oxford_Sub: Oxford_Sub] , [Scioto_Sub: Scioto_Sub] , ...59 more...

---

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