View In:   ArcGIS Online Map Viewer

Name: Work Requests by Status

Display Field: ProjName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b7da0502012b44018f4487ddd9cf35c6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -108.56555914199998
YMin: 25.904784886000073
XMax: -81.20976037199995
YMax: 39.45125596100007
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Submitted
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Pending
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Started
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Complete
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Blocked
  Description: N/A
  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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status , Coded Values: [1: Submitted] , [2: Pending] , [3: Started] , ...2 more... )
• Office ( type: esriFieldTypeString, alias: Office, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Office , Coded Values: [001: Austin] , [002: Austin-South] , [003: Baton Rouge] , ...30 more... )
• Dept ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Dept )
• AVOnum ( type: esriFieldTypeString, alias: AVO Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AVOnum )
• Phase ( type: esriFieldTypeString, alias: Phase, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Phase )
• Task ( type: esriFieldTypeString, alias: Task, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Task )
• ActCode ( type: esriFieldTypeString, alias: Activity Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ActCode )
• ClientOrg ( type: esriFieldTypeString, alias: Client Organization, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ClientOrg )
• ProjName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjName )
• SiteAddress ( type: esriFieldTypeString, alias: Work Site Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SiteAddress )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: State , Coded Values: [AK: Alaska] , [AL: Alabama] , [AR: Arkansas] , ...47 more... )
• WorkType ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkType )
• Phone ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Phone )
• Scope ( type: esriFieldTypeString, alias: Scope Of Work, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Scope )
• Comments ( type: esriFieldTypeString, alias: Party Chief Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• Zipcode ( type: esriFieldTypeString, alias: Zipcode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Zipcode )
• DaysEst ( type: esriFieldTypeString, alias: Estimated Days, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DaysEst )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 50, defaultValue: null, modelName: County , Coded Values: [1: Anderson] , [2: Andrews] , [3: Angelina] , ...251 more... )
• StartDate ( type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• JobPM ( type: esriFieldTypeString, alias: Job PM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JobPM )
• Tech ( type: esriFieldTypeString, alias: Tech, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Tech )
• Email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Email )
• CoordSys ( type: esriFieldTypeString, alias: Coordinate System, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CoordSys , Coded Values: [1: TX-N 4201_NAD 83] , [2: TX-NC 4202_NAD 83] , [3: TX-C 4203_NAD 83] , ...2 more... )
• NumCrew ( type: esriFieldTypeString, alias: Number of Crews, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NumCrew , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• GEOID ( type: esriFieldTypeString, alias: GEOID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEOID , Coded Values: [1: 18] , [2: 12A] , [3: 12B] , ...1 more... )
• Code ( type: esriFieldTypeString, alias: Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Code , Coded Values: [1: HALFF] , [2: HALFF-SUE] , [3: TXDOT] , ...1 more... )
• Network ( type: esriFieldTypeString, alias: Network, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Network , Coded Values: [1: WDS/SMARTNET] , [2: BASE/SMARTNET] , [3: TXDOT] , ...1 more... )
• SpecialEquip1 ( type: esriFieldTypeString, alias: Special Equipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpecialEquip1 , Coded Values: [1: BASE/ROVER] , [2: GPS RECEIVER] , [3: DIGITAL LEVEL] , ...8 more... )
• SpecialEquip2 ( type: esriFieldTypeString, alias: SpecialEquip2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpecialEquip2 , Coded Values: [1: BASE/ROVER] , [2: GPS RECEIVER] , [3: DIGITAL LEVEL] , ...8 more... )
• SpecialEqup3 ( type: esriFieldTypeString, alias: SpecialEqup3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpecialEqup3 , Coded Values: [1: BASE/ROVER] , [2: GPS RECEIVER] , [3: DIGITAL LEVEL] , ...8 more... )
• SpecialEquip4 ( type: esriFieldTypeString, alias: SpecialEquip4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpecialEquip4 , Coded Values: [1: BASE/ROVER] , [2: GPS RECEIVER] , [3: DIGITAL LEVEL] , ...8 more... )
• SpecialEquip5 ( type: esriFieldTypeString, alias: SpecialEquip5, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpecialEquip5 , Coded Values: [1: BASE/ROVER] , [2: GPS RECEIVER] , [3: DIGITAL LEVEL] , ...8 more... )
• FileLoc ( type: esriFieldTypeString, alias: File Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FileLoc )
• FileFolder ( type: esriFieldTypeString, alias: Files In MS Teams Folder?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FileFolder , Coded Values: [y: Yes] , [n: No] )
• FileEmail ( type: esriFieldTypeString, alias: Files Sent in Email?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FileEmail , Coded Values: [y: Yes] , [n: No] )
• FileTrimble ( type: esriFieldTypeString, alias: Files Sent in Trimble Sync?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FileTrimble , Coded Values: [y: Yes] , [n: No] )
• CPnum ( type: esriFieldTypeString, alias: CP#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CPnum )
• WPnum ( type: esriFieldTypeString, alias: WP#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WPnum )
• ATnum ( type: esriFieldTypeString, alias: AT#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ATnum )
• PCnum ( type: esriFieldTypeString, alias: PC#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PCnum )
• Topo1 ( type: esriFieldTypeString, alias: Topo#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Topo1 )
• Topo2 ( type: esriFieldTypeString, alias: Topo#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Topo2 )
• ROE ( type: esriFieldTypeString, alias: Right of Entry Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROE , Coded Values: [1: RIGHT OF ENTRY IS REQUIRED] , [2: NO RIGHT OF ENTRY IS REQUIRED] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )

Types:

ID: 1
Name: Submitted
Domains:
• Status:
  Inherited
• Office:
  Inherited
• State:
  Inherited
• County:
  Inherited
• CoordSys:
  Inherited
• NumCrew:
  Inherited
• GEOID:
  Inherited
• Code:
  Inherited
• Network:
  Inherited
• SpecialEquip1:
  Inherited
• SpecialEquip2:
  Inherited
• SpecialEqup3:
  Inherited
• SpecialEquip4:
  Inherited
• SpecialEquip5:
  Inherited
• FileFolder:
  Inherited
• FileEmail:
  Inherited
• FileTrimble:
  Inherited
• ROE:
  Inherited
Templates:
• Name: Submitted
  Description:
  Prototype:
  ROE: null
  Status: 1
  Office: null
  Dept: null
  AVOnum: null
  Phase: null
  Task: null
  ActCode: null
  ClientOrg: null
  ProjName: null
  SiteAddress: null
  City: null
  State: null
  WorkType: null
  Phone: null
  Scope: null
  Comments: null
  Zipcode: null
  DaysEst: null
  County: null
  StartDate: null
  JobPM: null
  Tech: null
  Email: null
  CoordSys: null
  NumCrew: null
  GEOID: null
  Code: null
  Network: null
  SpecialEquip1: null
  SpecialEquip2: null
  SpecialEqup3: null
  SpecialEquip4: null
  SpecialEquip5: null
  FileLoc: null
  FileFolder: null
  FileEmail: null
  FileTrimble: null
  CPnum: null
  WPnum: null
  ATnum: null
  PCnum: null
  Topo1: null
  Topo2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Pending
Domains:
• Status:
  Inherited
• Office:
  Inherited
• State:
  Inherited
• County:
  Inherited
• CoordSys:
  Inherited
• NumCrew:
  Inherited
• GEOID:
  Inherited
• Code:
  Inherited
• Network:
  Inherited
• SpecialEquip1:
  Inherited
• SpecialEquip2:
  Inherited
• SpecialEqup3:
  Inherited
• SpecialEquip4:
  Inherited
• SpecialEquip5:
  Inherited
• FileFolder:
  Inherited
• FileEmail:
  Inherited
• FileTrimble:
  Inherited
• ROE:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  ROE: null
  Status: 2
  Office: null
  Dept: null
  AVOnum: null
  Phase: null
  Task: null
  ActCode: null
  ClientOrg: null
  ProjName: null
  SiteAddress: null
  City: null
  State: null
  WorkType: null
  Phone: null
  Scope: null
  Comments: null
  Zipcode: null
  DaysEst: null
  County: null
  StartDate: null
  JobPM: null
  Tech: null
  Email: null
  CoordSys: null
  NumCrew: null
  GEOID: null
  Code: null
  Network: null
  SpecialEquip1: null
  SpecialEquip2: null
  SpecialEqup3: null
  SpecialEquip4: null
  SpecialEquip5: null
  FileLoc: null
  FileFolder: null
  FileEmail: null
  FileTrimble: null
  CPnum: null
  WPnum: null
  ATnum: null
  PCnum: null
  Topo1: null
  Topo2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Started
Domains:
• Status:
  Inherited
• Office:
  Inherited
• State:
  Inherited
• County:
  Inherited
• CoordSys:
  Inherited
• NumCrew:
  Inherited
• GEOID:
  Inherited
• Code:
  Inherited
• Network:
  Inherited
• SpecialEquip1:
  Inherited
• SpecialEquip2:
  Inherited
• SpecialEqup3:
  Inherited
• SpecialEquip4:
  Inherited
• SpecialEquip5:
  Inherited
• FileFolder:
  Inherited
• FileEmail:
  Inherited
• FileTrimble:
  Inherited
• ROE:
  Inherited
Templates:
• Name: Started
  Description:
  Prototype:
  ROE: null
  Status: 3
  Office: null
  Dept: null
  AVOnum: null
  Phase: null
  Task: null
  ActCode: null
  ClientOrg: null
  ProjName: null
  SiteAddress: null
  City: null
  State: null
  WorkType: null
  Phone: null
  Scope: null
  Comments: null
  Zipcode: null
  DaysEst: null
  County: null
  StartDate: null
  JobPM: null
  Tech: null
  Email: null
  CoordSys: null
  NumCrew: null
  GEOID: null
  Code: null
  Network: null
  SpecialEquip1: null
  SpecialEquip2: null
  SpecialEqup3: null
  SpecialEquip4: null
  SpecialEquip5: null
  FileLoc: null
  FileFolder: null
  FileEmail: null
  FileTrimble: null
  CPnum: null
  WPnum: null
  ATnum: null
  PCnum: null
  Topo1: null
  Topo2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Complete
Domains:
• Status:
  Inherited
• Office:
  Inherited
• State:
  Inherited
• County:
  Inherited
• CoordSys:
  Inherited
• NumCrew:
  Inherited
• GEOID:
  Inherited
• Code:
  Inherited
• Network:
  Inherited
• SpecialEquip1:
  Inherited
• SpecialEquip2:
  Inherited
• SpecialEqup3:
  Inherited
• SpecialEquip4:
  Inherited
• SpecialEquip5:
  Inherited
• FileFolder:
  Inherited
• FileEmail:
  Inherited
• FileTrimble:
  Inherited
• ROE:
  Inherited
Templates:
• Name: Complete
  Description:
  Prototype:
  ROE: null
  Status: 4
  Office: null
  Dept: null
  AVOnum: null
  Phase: null
  Task: null
  ActCode: null
  ClientOrg: null
  ProjName: null
  SiteAddress: null
  City: null
  State: null
  WorkType: null
  Phone: null
  Scope: null
  Comments: null
  Zipcode: null
  DaysEst: null
  County: null
  StartDate: null
  JobPM: null
  Tech: null
  Email: null
  CoordSys: null
  NumCrew: null
  GEOID: null
  Code: null
  Network: null
  SpecialEquip1: null
  SpecialEquip2: null
  SpecialEqup3: null
  SpecialEquip4: null
  SpecialEquip5: null
  FileLoc: null
  FileFolder: null
  FileEmail: null
  FileTrimble: null
  CPnum: null
  WPnum: null
  ATnum: null
  PCnum: null
  Topo1: null
  Topo2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Blocked
Domains:
• Status:
  Inherited
• Office:
  Inherited
• State:
  Inherited
• County:
  Inherited
• CoordSys:
  Inherited
• NumCrew:
  Inherited
• GEOID:
  Inherited
• Code:
  Inherited
• Network:
  Inherited
• SpecialEquip1:
  Inherited
• SpecialEquip2:
  Inherited
• SpecialEqup3:
  Inherited
• SpecialEquip4:
  Inherited
• SpecialEquip5:
  Inherited
• FileFolder:
  Inherited
• FileEmail:
  Inherited
• FileTrimble:
  Inherited
• ROE:
  Inherited
Templates:
• Name: Blocked
  Description:
  Prototype:
  ROE: null
  Status: 5
  Office: null
  Dept: null
  AVOnum: null
  Phase: null
  Task: null
  ActCode: null
  ClientOrg: null
  ProjName: null
  SiteAddress: null
  City: null
  State: null
  WorkType: null
  Phone: null
  Scope: null
  Comments: null
  Zipcode: null
  DaysEst: null
  County: null
  StartDate: null
  JobPM: null
  Tech: null
  Email: null
  CoordSys: null
  NumCrew: null
  GEOID: null
  Code: null
  Network: null
  SpecialEquip1: null
  SpecialEquip2: null
  SpecialEqup3: null
  SpecialEquip4: null
  SpecialEquip5: null
  FileLoc: null
  FileFolder: null
  FileEmail: null
  FileTrimble: null
  CPnum: null
  WPnum: null
  ATnum: null
  PCnum: null
  Topo1: null
  Topo2: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata