Name: CISLocationData

Display Field: EALOCNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 20000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Relationships:

• Consumer (18) -- Related To: Consumer (5)

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

  Iteminfo   Thumbnail   Metadata