View In:   ArcGIS Online Map Viewer

Name: ETCOG Work Orders

Display Field: NAME

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 175085.38069999963
YMin: 3478121.9977
XMax: 410089.801
YMax: 3660664.5623000003
Spatial Reference: 26915  (26915)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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

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 )
• QA_DATE ( type: esriFieldTypeDate, alias: QA DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: QA_DATE )
• QA_COMMENT_1 ( type: esriFieldTypeString, alias: QA COMMENT 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QA_COMMENT_1 )
• QA_COMMENT_2 ( type: esriFieldTypeString, alias: QA COMMENT 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QA_COMMENT_2 )
• QA_CORRECTIONS ( type: esriFieldTypeString, alias: QA CORRECTIONS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QA_CORRECTIONS )
• QA_COMMENT_3 ( type: esriFieldTypeString, alias: QA COMMENT 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QA_COMMENT_3 )
• NOTIFICATION_TYPE_1 ( type: esriFieldTypeString, alias: NOTIFICATION TYPE 1, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NOTIFICATION_TYPE_1 , Coded Values: [EMAILED: EMAILED] , [VERBAL: VERBAL] , [MAILED: MAILED] , ...2 more... )
• NOTIFICATION_DATE_1 ( type: esriFieldTypeString, alias: NOTIFICATION DATE 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTIFICATION_DATE_1 )
• NOTIFICATION_TYPE_2 ( type: esriFieldTypeString, alias: NOTIFICATION TYPE 2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NOTIFICATION_TYPE_2 , Coded Values: [EMAILED: EMAILED] , [VERBAL: VERBAL] , [MAILED: MAILED] , ...2 more... )
• NOTIFICATION_DATE_2 ( type: esriFieldTypeDate, alias: NOTIFICATION DATE 2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NOTIFICATION_DATE_2 )
• LETTER_SENT ( type: esriFieldTypeString, alias: LETTER SENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LETTER_SENT , Coded Values: [Y: YES] , [N: NO] , [0: 0] , ...1 more... )
• WO_DATE ( type: esriFieldTypeDate, alias: WO DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WO_DATE )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUNTY , Coded Values: [ANDERSON: ANDERSON COUNTY] , [CAMP: CAMP COUNTY] , [CHEROKEE: CHEROKEE COUNTY] , ...12 more... )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY , Coded Values: [ALBA: ALBA] , [ALTO: ALTO] , [ARP: ARP] , ...88 more... )
• WORK_ORDER_NUMBER ( type: esriFieldTypeString, alias: WORK ORDER NUMBER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WO_NUM )
• WORK_ORDER_TYPE ( type: esriFieldTypeString, alias: WORK ORDER TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE , Coded Values: [CHANGE: CHANGE] , [NEW: NEW] , [VERIFY: VERIFY] , ...1 more... )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NAME )
• PHONE ( type: esriFieldTypeString, alias: PHONE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PHONE )
• INFO_PROVIDED_1 ( type: esriFieldTypeString, alias: INFO PROVIDED 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INFO_PROVIDED_1 )
• INFO_PROVIDED_2 ( type: esriFieldTypeString, alias: INFO PROVIDED 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INFO_PROVIDED_2 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATUS , Coded Values: [ACTIVE: ACTIVE] , [CANCELED: CANCELED] , [COMPLETED: COMPLETED] , ...2 more... )
• ASSIGNED_ADDRESS ( type: esriFieldTypeString, alias: ASSIGNED ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ASSIGNED_ADDRESS )
• COMMENTS_1 ( type: esriFieldTypeString, alias: COMMENTS 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_1 )
• COMMENTS_2 ( type: esriFieldTypeString, alias: COMMENTS 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_2 )
• COMMENTS_3 ( type: esriFieldTypeString, alias: COMMENTS 3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_3 )
• COMMENTS_4 ( type: esriFieldTypeString, alias: COMMENTS 4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_4 )
• COMMENTS_5 ( type: esriFieldTypeString, alias: COMMENTS 5, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_5 )
• COMMENTS_6 ( type: esriFieldTypeString, alias: COMMENTS 6, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_6 )
• COMMENTS_7 ( type: esriFieldTypeString, alias: COMMENTS 7, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_7 )
• COMMENTS_8 ( type: esriFieldTypeString, alias: COMMENTS 8, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_8 )
• COMMENTS_9 ( type: esriFieldTypeString, alias: COMMENTS 9, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_9 )
• COMMENTS_10 ( type: esriFieldTypeString, alias: COMMENTS 10, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_10 )
• COMMENTS_11 ( type: esriFieldTypeString, alias: COMMENTS 11, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS_11 )
• STAFF ( type: esriFieldTypeString, alias: STAFF INITIALS, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STAFF )
• TIME_MIN ( type: esriFieldTypeInteger, alias: TIME IN MINUTES, editable: true, nullable: true, defaultValue: null, modelName: TIME_MIN )
• MAP_EDITS ( type: esriFieldTypeString, alias: MAP EDITS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAP_EDITS , Coded Values: [Y: YES] , [N: NO] , [0: 0] , ...1 more... )
• MAIL_NAME ( type: esriFieldTypeString, alias: MAIL NAME, editable: true, nullable: true, length: 150, defaultValue: null, modelName: MAIL_NAME )
• MAIL_ADDRESS ( type: esriFieldTypeString, alias: MAIL ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: MAIL_ADDRESS )
• MAIL_CITY ( type: esriFieldTypeString, alias: MAIL CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAIL_CITY )
• MAIL_STATE ( type: esriFieldTypeString, alias: MAIL STATE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATE )
• MAIL_ZIP ( type: esriFieldTypeInteger, alias: MAIL ZIP, editable: true, nullable: true, defaultValue: null, modelName: ZIP )
• USPS_NOTIFIED ( type: esriFieldTypeString, alias: USPS NOTIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: USPS_NOTIFIED , Coded Values: [Y: YES] , [N: NO] , [0: 0] , ...1 more... )
• NET_VERIFIED ( type: esriFieldTypeString, alias: NET VERIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NET_VERIFIED , Coded Values: [Y: YES] , [N: NO] , [0: 0] , ...1 more... )
• NET_UPDATED ( type: esriFieldTypeString, alias: NET UPDATED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NET_UPDATED )
• TOTAL_TIME_MIN ( type: esriFieldTypeInteger, alias: TOTAL TIME IN MINUTES, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_TIME_MIN )
• COMPLETION_DATE ( type: esriFieldTypeDate, alias: COMPLETION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMPLETION_DATE )
• 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 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETID )

Templates:

• Name: ETCOG Work Orders
  Description:
  Prototype:
  COMPLETION_DATE: null
  ASSETID: null
  QA_DATE: null
  QA_COMMENT_1: null
  QA_COMMENT_2: null
  QA_CORRECTIONS: null
  QA_COMMENT_3: null
  NOTIFICATION_TYPE_1: null
  NOTIFICATION_DATE_1: null
  NOTIFICATION_TYPE_2: null
  NOTIFICATION_DATE_2: null
  LETTER_SENT: null
  WO_DATE: null
  COUNTY: null
  CITY: null
  WORK_ORDER_NUMBER: null
  WORK_ORDER_TYPE: null
  NAME: null
  PHONE: null
  INFO_PROVIDED_1: null
  INFO_PROVIDED_2: null
  STATUS: null
  ASSIGNED_ADDRESS: null
  COMMENTS_1: null
  COMMENTS_2: null
  COMMENTS_3: null
  COMMENTS_4: null
  COMMENTS_5: null
  COMMENTS_6: null
  COMMENTS_7: null
  COMMENTS_8: null
  COMMENTS_9: null
  COMMENTS_10: null
  COMMENTS_11: null
  STAFF: null
  TIME_MIN: null
  MAP_EDITS: null
  MAIL_NAME: null
  MAIL_ADDRESS: null
  MAIL_CITY: null
  MAIL_STATE: null
  MAIL_ZIP: null
  USPS_NOTIFIED: null
  NET_VERIFIED: null
  NET_UPDATED: null
  TOTAL_TIME_MIN: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

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

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata