Layers:

Layer: Asset Points (0)

Name: Asset Points

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2161201.363148883
YMin: 1.3773631153038979E7
XMax: 2288002.293601632
YMax: 1.3849221177055478E7
Spatial Reference: 102740  (2278)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: assettype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 0
  Label: 0
  Description: N/A
  Symbol:
  
• Value: 1
  Label: 1
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [85, 255, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: AssetID, length: 25 )
• notes ( type: esriFieldTypeString, alias: General Notes, length: 2000 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Z ( type: esriFieldTypeDouble, alias: Z )
• updatedgis ( type: esriFieldTypeString, alias: Updated in GIS, length: 5 )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status )
• installdate ( type: esriFieldTypeDate, alias: Date Installed, length: 8 )
• retireddate ( type: esriFieldTypeDate, alias: Date Retired, length: 8 )
• abandoneddate ( type: esriFieldTypeDate, alias: Abandoned Date, length: 8 )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset Type )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• trans_CO1 ( type: esriFieldTypeInteger, alias: asset_id_field )
• serial_num1 ( type: esriFieldTypeString, alias: SerialNum, length: 255 )
• order_type ( type: esriFieldTypeString, alias: order_type, length: 255 , Coded Values: [S: Set] , [R: Remove] , [C: Change] )
• address ( type: esriFieldTypeString, alias: address, length: 255 )
• work_order ( type: esriFieldTypeInteger, alias: work_order )
• pole_tag ( type: esriFieldTypeInteger, alias: pole_tag )
• phases ( type: esriFieldTypeSmallInteger, alias: phases , Coded Values: [1: 1] , [3: 3] )
• phasing_code1 ( type: esriFieldTypeString, alias: phasing_code1, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• KVA1 ( type: esriFieldTypeString, alias: KVA1, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• secondary_voltage1 ( type: esriFieldTypeString, alias: secondary_voltage1, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• trans_CO2 ( type: esriFieldTypeInteger, alias: trans_CO2 )
• KVA2 ( type: esriFieldTypeString, alias: KVA2, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• secondary_voltage2 ( type: esriFieldTypeString, alias: secondary_voltage2, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• serial_num2 ( type: esriFieldTypeString, alias: serial_num2, length: 255 )
• transCO3 ( type: esriFieldTypeInteger, alias: transCO3 )
• phasing_code2 ( type: esriFieldTypeString, alias: phasing_code2, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• phasing_code3 ( type: esriFieldTypeString, alias: phasing_code3, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• KVA3 ( type: esriFieldTypeString, alias: KVA3, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• secondary_voltage3 ( type: esriFieldTypeString, alias: secondary_voltage3, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• trx_type ( type: esriFieldTypeInteger, alias: trx_type , Coded Values: [5: Conventional] , [6: Pad Mount] , [9: Recloser] , ...4 more... )
• serial_num3 ( type: esriFieldTypeString, alias: serial_num3, length: 255 )
• Unit_Valid1 ( type: esriFieldTypeString, alias: Unit_Valid, length: 255 )
• Unit_Valid2 ( type: esriFieldTypeInteger, alias: Unit_Valid2 )
• Unit_Valid3 ( type: esriFieldTypeInteger, alias: Unit_Valid3 )
• trans_CO1_R ( type: esriFieldTypeInteger, alias: trans_CO1_R )
• trans_CO2_R ( type: esriFieldTypeInteger, alias: trans_CO2_R )
• trans_CO3_R ( type: esriFieldTypeInteger, alias: trans_CO3_R )
• phasing_code1_R ( type: esriFieldTypeString, alias: phasing_code1_R, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• phasing_code2_R ( type: esriFieldTypeString, alias: phasing_code2_R, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• phasing_code3_R ( type: esriFieldTypeString, alias: phasing_code3_R, length: 255 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• KVA1_R ( type: esriFieldTypeString, alias: KVA1_R, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• KVA2_R ( type: esriFieldTypeString, alias: KVA2_R, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• KVA3_R ( type: esriFieldTypeString, alias: KVA3_R, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• serial_num1_R ( type: esriFieldTypeString, alias: serial_num1_R, length: 255 )
• serial_num2_R ( type: esriFieldTypeString, alias: serial_num2_R, length: 255 )
• serial_num3_R ( type: esriFieldTypeString, alias: serial_num3_R, length: 255 )
• secondary_voltage1_R ( type: esriFieldTypeString, alias: secondary_voltage1_R, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• secondary_voltage2_R ( type: esriFieldTypeString, alias: secondary_voltage2_R, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• secondary_voltage3_R ( type: esriFieldTypeString, alias: secondary_voltage3_R, length: 255 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• trx_type_R ( type: esriFieldTypeInteger, alias: trx_type_R , Coded Values: [5: Conventional] , [6: Pad Mount] , [9: Recloser] , ...4 more... )
• pole_tag_R ( type: esriFieldTypeInteger, alias: pole_tag_R )
• manufacturer2 ( type: esriFieldTypeString, alias: manufacturer2, length: 255 )
• manufacturer3 ( type: esriFieldTypeString, alias: manufacturer3, length: 255 )
• manufacturer1_R ( type: esriFieldTypeString, alias: manufacturer1_R, length: 255 )
• manufacturer2_R ( type: esriFieldTypeString, alias: manufacturer2_R, length: 255 )
• manufacturer3_R ( type: esriFieldTypeString, alias: manufacturer3_R, length: 255 )
• manufacturer1 ( type: esriFieldTypeString, alias: manufacturer1, length: 255 )
• phases_R ( type: esriFieldTypeSmallInteger, alias: phases_R , Coded Values: [1: 1] , [3: 3] )
Relationships:
• NBUAssets.DBO.Transformer_Unit (0) -- Related To: Transformer Units (2)

Tables:

Table: Transformer Units (2)

Name: Transformer Units

Display Field: assetid

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: AssetID, length: 25 )
• UnitID ( type: esriFieldTypeInteger, alias: UnitID )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• KVA ( type: esriFieldTypeString, alias: KVA, length: 255 , Coded Values: [1: 1] , [15: 15] , [25: 25] , ...17 more... )
• Manufacturer ( type: esriFieldTypeInteger, alias: Manufacturer , Coded Values: [7: ABB] , [8: KUHLMAN] , [9: HOWARD] , ...55 more... )
• Serial_Num ( type: esriFieldTypeString, alias: Serial_Num, length: 50 )
• Secondary_Volt ( type: esriFieldTypeString, alias: Secondary_Volt, length: 30 , Coded Values: [1: 120/240] , [2: 120/208] , [3: 277/480] , ...7 more... )
• trx_type ( type: esriFieldTypeInteger, alias: trx_type , Coded Values: [5: Conventional] , [6: Pad Mount] , [9: Recloser] , ...4 more... )
Relationships:
• NBUAssets.DBO.AssetPoints (0) -- Related To: Asset Points (0)