View In:   ArcGIS Online Map Viewer

Name: Hansen Work Orders

Display Field: HISTKEY

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: acc362f7f675484a990145c11bc6a0a0

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 419039.6450155787
YMin: 2059846.9698534086
XMax: 565070.3522974104
YMax: 2192133.6334291548
Spatial Reference: 2244  (2965)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [33, 114, 132, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HISTKEY ( type: esriFieldTypeInteger, alias: HISTKEY, editable: true, nullable: false, defaultValue: null, modelName: HISTKEY )
• INITDTTM ( type: esriFieldTypeDate, alias: INITDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITDTTM )
• STARTDTTM ( type: esriFieldTypeDate, alias: STARTDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTDTTM )
• COMPDTTM ( type: esriFieldTypeDate, alias: COMPDTTM, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMPDTTM )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: COMMENTS )
• ACTUALQTY ( type: esriFieldTypeDouble, alias: ACTUALQTY, editable: true, nullable: true, defaultValue: null, modelName: ACTUALQTY )
• SRC ( type: esriFieldTypeString, alias: SRC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SRC )
• REFNO ( type: esriFieldTypeString, alias: REFNO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REFNO )
• RESPONSIBILITY ( type: esriFieldTypeString, alias: RESPONSIBILITY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RESPONSIBILITY )
• PROJ ( type: esriFieldTypeString, alias: PROJ, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PROJ )
• GRPPROJKEY ( type: esriFieldTypeInteger, alias: GRPPROJKEY, editable: true, nullable: true, defaultValue: null, modelName: GRPPROJKEY )
• ADDRKEY ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• CMPLKEY ( type: esriFieldTypeInteger, alias: CMPLKEY, editable: true, nullable: true, defaultValue: null, modelName: CMPLKEY )
• MAINTTYPE ( type: esriFieldTypeString, alias: MAINTTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINTTYPE )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 300, defaultValue: null, modelName: LOCATION )
• COMPBY ( type: esriFieldTypeString, alias: COMPBY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: COMPBY )
• ASSIGNED ( type: esriFieldTypeString, alias: ASSIGNED, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ASSIGNED )
• MAINTSCHED ( type: esriFieldTypeInteger, alias: MAINTSCHED, editable: true, nullable: true, defaultValue: null, modelName: MAINTSCHED )
• ADDRTYPE ( type: esriFieldTypeString, alias: ADDRTYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ADDRTYPE )
• TotalLabor ( type: esriFieldTypeDouble, alias: TotalLabor, editable: true, nullable: true, defaultValue: null, modelName: TotalLabor )
• TotalMaterial ( type: esriFieldTypeDouble, alias: TotalMaterial, editable: true, nullable: true, defaultValue: null, modelName: TotalMaterial )
• TotalEquipment ( type: esriFieldTypeDouble, alias: TotalEquipment, editable: true, nullable: true, defaultValue: null, modelName: TotalEquipment )
• TotalExtra ( type: esriFieldTypeDouble, alias: TotalExtra, editable: true, nullable: true, defaultValue: null, modelName: TotalExtra )
• CurrentStatus ( type: esriFieldTypeString, alias: CurrentStatus, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CurrentStatus )
• offset ( type: esriFieldTypeInteger, alias: offset, editable: true, nullable: true, defaultValue: null, modelName: offset )
• ACTCODE ( type: esriFieldTypeString, alias: ACTCODE, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ACTCODE )
• ACTDESC ( type: esriFieldTypeString, alias: ACTDESC, editable: true, nullable: true, length: 300, defaultValue: null, modelName: ACTDESC )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• COMPTYPE ( type: esriFieldTypeInteger, alias: COMPTYPE, editable: true, nullable: true, defaultValue: null, modelName: COMPTYPE )
• COMPCODE ( type: esriFieldTypeString, alias: COMPCODE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: COMPCODE )
• COMPDESC ( type: esriFieldTypeString, alias: COMPDESC, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPDESC )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNITID )
• UNITID2 ( type: esriFieldTypeString, alias: UNITID2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UNITID2 )
• UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITTYPE )
• PipeID ( type: esriFieldTypeString, alias: PipeID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PipeID )
• INSTDATE ( type: esriFieldTypeDate, alias: INSTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTDATE )
• PIPETYPE ( type: esriFieldTypeString, alias: PIPETYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PIPETYPE )
• DIAM ( type: esriFieldTypeDouble, alias: DIAM, editable: true, nullable: true, defaultValue: null, modelName: DIAM )
• SERVICENUMBER ( type: esriFieldTypeString, alias: SERVICENUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SERVICENUMBER )
• SERVICEON ( type: esriFieldTypeDate, alias: SERVICEON, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEON )
• SERVICEOFF ( type: esriFieldTypeDate, alias: SERVICEOFF, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEOFF )
• SERVICEON2 ( type: esriFieldTypeDate, alias: SERVICEON2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEON2 )
• SERVICEOFF2 ( type: esriFieldTypeDate, alias: SERVICEOFF2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEOFF2 )
• SERVICEON3 ( type: esriFieldTypeDate, alias: SERVICEON3, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEON3 )
• SERVICEOFF3 ( type: esriFieldTypeDate, alias: SERVICEOFF3, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICEOFF3 )
• REPAIRTYPE ( type: esriFieldTypeString, alias: REPAIRTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REPAIRTYPE )
• LEAKTYPE ( type: esriFieldTypeString, alias: LEAKTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKTYPE )
• LEAKLOCATION ( type: esriFieldTypeString, alias: LEAKLOCATION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEAKLOCATION )
• SOILTYPE ( type: esriFieldTypeString, alias: SOILTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SOILTYPE )
• WOCOMPLETED ( type: esriFieldTypeString, alias: WOCOMPLETED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WOCOMPLETED )
• INPARKSTRIP ( type: esriFieldTypeString, alias: INPARKSTRIP, editable: true, nullable: true, length: 1, defaultValue: null, modelName: INPARKSTRIP )
• CAUSEOFDAMAGE ( type: esriFieldTypeString, alias: CAUSEOFDAMAGE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CAUSEOFDAMAGE )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: Hansen Work Orders
  Description:
  Prototype:
  CAUSEOFDAMAGE: null
  INPARKSTRIP: null
  HISTKEY: 0
  INITDTTM: null
  STARTDTTM: null
  COMPDTTM: null
  COMMENTS: null
  ACTUALQTY: null
  SRC: null
  REFNO: null
  RESPONSIBILITY: null
  PROJ: null
  GRPPROJKEY: null
  ADDRKEY: null
  CMPLKEY: null
  MAINTTYPE: null
  LOCATION: null
  COMPBY: null
  ASSIGNED: null
  MAINTSCHED: null
  ADDRTYPE: null
  TotalLabor: null
  TotalMaterial: null
  TotalEquipment: null
  TotalExtra: null
  CurrentStatus: null
  offset: null
  ACTCODE: null
  ACTDESC: null
  COMPKEY: null
  COMPTYPE: null
  COMPCODE: null
  COMPDESC: null
  UNITID: null
  UNITID2: null
  UNITTYPE: null
  PipeID: null
  INSTDATE: null
  PIPETYPE: null
  DIAM: null
  SERVICENUMBER: null
  SERVICEON: null
  SERVICEOFF: null
  SERVICEON2: null
  SERVICEOFF2: null
  SERVICEON3: null
  SERVICEOFF3: null
  REPAIRTYPE: null
  LEAKTYPE: null
  LEAKLOCATION: null
  SOILTYPE: null
  WOCOMPLETED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata