Name: Consumer

Display Field: LASTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Source: consumer Display Field: name Workspace: c:\futuradata\hawkeye93.mdb

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 25000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 50000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5172428.607299805
YMin: 3846091.0598754883
XMax: 5511169.742126465
YMax: 4254822.176330566
Spatial Reference: 102675  (3417)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CriticalSvcType
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Medical Monitoring
  Label: Medical Monitoring
  Description:
  Symbol:
  
• Value: Oxygen
  Label: Oxygen
  Description:
  Symbol:
  
• Value: Standard
  Label: Standard
  Description:
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: ConsumerType

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• MapNumber ( type: esriFieldTypeString , alias: MapNumber , length: 50 )
• PhaseCode ( type: esriFieldTypeSmallInteger , alias: PhaseCode , Coded Values: [129: A] , [130: B] , [131: AB] , ...4 more... )
• TransformerMapNumber ( type: esriFieldTypeString , alias: TransformerMapNumber , length: 50 )
• ConstructionUnit ( type: esriFieldTypeString , alias: ConstructionUnit , length: 50 )
• Feeder ( type: esriFieldTypeString , alias: Feeder , length: 50 )
• MeterType ( type: esriFieldTypeSmallInteger , alias: MeterType )
• Enabled ( type: esriFieldTypeSmallInteger , alias: Enabled , Coded Values: [0: False] , [1: True] )
• FuturaGUID ( type: esriFieldTypeString , alias: FuturaGUID , length: 50 )
• DateCreated ( type: esriFieldTypeDate , alias: DateCreated , length: 8 )
• DateModified ( type: esriFieldTypeDate , alias: DateModified , length: 8 )
• LastModifiedBy ( type: esriFieldTypeString , alias: LastModifiedBy , length: 30 )
• NetworkID ( type: esriFieldTypeString , alias: NetworkID , length: 20 )
• Rotation ( type: esriFieldTypeDouble , alias: Rotation )
• WorkOrderNumber ( type: esriFieldTypeString , alias: WorkOrderNumber , length: 50 )
• Comments ( type: esriFieldTypeString , alias: Comments , length: 255 )
• County ( type: esriFieldTypeString , alias: County , length: 50 , Coded Values: [ALLAMAKEE: ALLAMAKEE] , [CHICKASAW: CHICKASAW] , [FAYETTE: FAYETTE] , ...8 more... )
• ProtectionDevice ( type: esriFieldTypeString , alias: Protection Device , length: 50 )
• SurveySection ( type: esriFieldTypeInteger , alias: SurveySection )
• SurveyTownship ( type: esriFieldTypeString , alias: SurveyTownship , length: 50 )
• HomePhone ( type: esriFieldTypeString , alias: HomePhone , length: 7 )
• Substation ( type: esriFieldTypeString , alias: Substation , length: 50 )
• CUSTNUMBER ( type: esriFieldTypeString , alias: CustNumber , length: 80 )
• LASTNAME ( type: esriFieldTypeString , alias: lastName , length: 13 )
• FIRSTNAME ( type: esriFieldTypeString , alias: firstName , length: 9 )
• MNAME ( type: esriFieldTypeString , alias: mName , length: 9 )
• DBANAME ( type: esriFieldTypeString , alias: dBAName , length: 30 )
• BILLADDR1 ( type: esriFieldTypeString , alias: billAddr1 , length: 80 )
• BILLADDR2 ( type: esriFieldTypeString , alias: billAddr2 , length: 80 )
• LOCNUMBER ( type: esriFieldTypeString , alias: LocNumber , length: 16 )
• CUSTID ( type: esriFieldTypeString , alias: CUSTID , length: 32 )
• ACCOUNTNUMBER ( type: esriFieldTypeString , alias: ACCOUNTNUMBER , length: 32 )
• SERVADDR1 ( type: esriFieldTypeString , alias: SERVADDR1 , length: 40 )
• SERVCITY ( type: esriFieldTypeString , alias: SERVCITY , length: 18 )
• SERVSTATE ( type: esriFieldTypeString , alias: SERVSTATE , length: 5 )
• SERVZIP ( type: esriFieldTypeString , alias: SERVZIP , length: 10 )
• REVENUECLASS ( type: esriFieldTypeString , alias: REVENUECLASS , length: 20 )
• SERVSTATUS ( type: esriFieldTypeString , alias: SERVSTATUS , length: 16 )
• SPECIALNEEDS ( type: esriFieldTypeString , alias: SPECIALNEEDS , length: 40 )
• CONNECTDATE ( type: esriFieldTypeString , alias: CONNECTDATE , length: 32 )
• DISCONNECTDATE ( type: esriFieldTypeString , alias: DISCONNECTDATE , length: 32 )
• METERNO ( type: esriFieldTypeString , alias: meterNo , length: 80 )
• METER_TYPE ( type: esriFieldTypeString , alias: meter_Type , length: 30 )
• HOMEAC ( type: esriFieldTypeString , alias: homeAc , length: 3 )
• CriticalSvcType ( type: esriFieldTypeString , alias: CriticalSvcType , length: 50 )
• ConsumerType ( type: esriFieldTypeSmallInteger , alias: ConsumerType )
• KVA ( type: esriFieldTypeDouble , alias: KVA )
• KW ( type: esriFieldTypeDouble , alias: KW )
• KWH ( type: esriFieldTypeInteger , alias: KWH )
• Prikey ( type: esriFieldTypeInteger , alias: Prikey )
• X_Coord ( type: esriFieldTypeDouble , alias: X_Coord )
• Y_Coord ( type: esriFieldTypeDouble , alias: Y_Coord )
• ALLIANT_OID ( type: esriFieldTypeInteger , alias: ALLIANT_OID )
• customerID ( type: esriFieldTypeGUID , alias: Customer ID , length: 38 )
• DateModifiedSource ( type: esriFieldTypeDate , alias: DateModifiedSource , length: 8 )
• Description ( type: esriFieldTypeString , alias: Description , length: 50 )
• Detail ( type: esriFieldTypeString , alias: Detail , length: 15 )
• District ( type: esriFieldTypeString , alias: District , length: 50 )
• Emergency_Address ( type: esriFieldTypeString , alias: Emergency_Address , length: 50 )
• facilityID ( type: esriFieldTypeString , alias: Facility ID , length: 255 )
• Formatted_AcctNo_Alliant ( type: esriFieldTypeString , alias: Formatted_AcctNo_Alliant , length: 50 )
• GPSCorrected ( type: esriFieldTypeString , alias: GPSCorrected , length: 50 , Coded Values: [True: True] , [False: False] )
• GPSDate ( type: esriFieldTypeDate , alias: GPSDate , length: 8 )
• INSTALLATIONDATE ( type: esriFieldTypeDate , alias: INSTALLATIONDATE , length: 8 )
• Latitude ( type: esriFieldTypeDouble , alias: Latitude )
• LineSection ( type: esriFieldTypeString , alias: Line Section , length: 25 )
• LocationID ( type: esriFieldTypeString , alias: LocationID , length: 20 )
• Longitude ( type: esriFieldTypeDouble , alias: Longitude )
• Meter_Route_Alliant ( type: esriFieldTypeString , alias: Meter_Route_Alliant , length: 50 )
• NonFormatted_AcctNo_Alliant ( type: esriFieldTypeString , alias: NonFormatted_AcctNo_Alliant , length: 50 )
• OldServiceMapLocation ( type: esriFieldTypeString , alias: OldServiceMapLocation , length: 50 )
• OutagePriority ( type: esriFieldTypeString , alias: Outage Priority , length: 5 )
• outageStatus ( type: esriFieldTypeString , alias: Outage Status , length: 255 )
• SchoolDistrict ( type: esriFieldTypeString , alias: SchoolDistrict , length: 50 )
• servAddr2 ( type: esriFieldTypeString , alias: Service Address Line 2 , length: 255 )
• ServiceNumber ( type: esriFieldTypeString , alias: ServiceNumber , length: 50 )
• ServLoc_Premise_Alliant ( type: esriFieldTypeString , alias: ServLoc_Premise_Alliant , length: 50 )
• servType ( type: esriFieldTypeString , alias: Service Type , length: 255 )
• Special_Customer_Alliant ( type: esriFieldTypeString , alias: Special_Customer_Alliant , length: 50 )
• State ( type: esriFieldTypeString , alias: State , length: 50 )
• StationGuid ( type: esriFieldTypeString , alias: StationGuid , length: 50 )
• SupportStructureID ( type: esriFieldTypeString , alias: SupportStructureID , length: 255 )
• Transformer_Premise_Alliant ( type: esriFieldTypeString , alias: Transformer_Premise_Alliant , length: 50 )
• verb ( type: esriFieldTypeString , alias: Verb , length: 255 )
• DAYAC ( type: esriFieldTypeString , alias: dayAc , length: 3 )
• DAYPHONE ( type: esriFieldTypeString , alias: dayPhone , length: 16 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• North_South_Symbology ( type: esriFieldTypeString , alias: North_South_Symbology , length: 50 )
• Circuit ( type: esriFieldTypeString , alias: Circuit , length: 50 , Coded Values: [85-03: ALTA VISTA-03] , [85-02: ALTA VISTA-02] , [85-04: ALTA VISTA-04] , ...211 more... )

Types:

ID: 0
Name: Primary
Domains:
• PhaseCode:
  Inherited
• Enabled:
  Inherited
• County:
  Inherited

---

ID: 1
Name: Secondary
Domains:
• PhaseCode:
  Inherited
• Enabled:
  Inherited
• County:
  Inherited
• REVENUECLASS:
  Coded Values: [HAWK+1: Residentail Sales] , [TLCOM+1: First Call Income] , [HAWK+2: Residential Sales Seasonal] , ...38 more...
• SERVSTATUS:
  Coded Values: [1: Active] , [3: Active DVC Only] , [5: Meter Rdg Card / Held Account] , ...19 more...
• METER_TYPE:
  Coded Values: [0: KWH] , [1: KWH/Demand] , [2: KVAR] , ...7 more...
• CriticalSvcType:
  Coded Values: [Standard: Standard] , [Oxygen: Oxygen] , [Medical Monitoring: Medical Monitoring] , ...5 more...

---

Relationships:

• TransformerBank (0) -- Related To: TransformerBank (18)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata