View In:   ArcGIS Online Map Viewer

Name: gis_request_form_unabridged

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 831b7fc9b4ca4bf0a8b38b0329c19d81

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: taskstatus
Field 2: N/A
Field 3: N/A
Field Delimiter: N/A
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [76, 230, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: Dormant (Recurring)
  Label: Dormant (Recurring)
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [169, 0, 230, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: Waiting on Someone Else
  Label: Waiting on Someone Else
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 112, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
• Value: Not Started
  Label: Not Started
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [237, 81, 81, 255]
  Outline:
  Style: esriSLSSolid
  Color: [153, 153, 153, 64]
  Width: 0
Transparency: 0
Labeling Info:

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: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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: taskstatus

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• submission_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Submission Date, type: esriFieldTypeDate )
• deadline ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Deadline, type: esriFieldTypeDate )
• processing_time ( nullable: true, editable: true, defaultValue: null, alias: Processing Time (Days), type: esriFieldTypeInteger )
• deadline_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Deadline Type, type: esriFieldTypeString , Coded Values: [Hard Deadline: Hard Deadline] , [Soft Deadline: Soft Deadline] )
• urgency ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Urgency, type: esriFieldTypeString , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...2 more... )
• submitter ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request Submitter Name, type: esriFieldTypeString )
• email ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request Submitter Email Address, type: esriFieldTypeString )
• position ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request Submitter Position, type: esriFieldTypeString )
• team ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Team, type: esriFieldTypeString )
• department ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requester Department, type: esriFieldTypeString , Coded Values: [Capital Projects: Capital Projects] , [Public Works: Public Works] , [City Managers Office: City Manager's Office] , ...8 more... )
• department_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requester Department (Other), type: esriFieldTypeString )
• project_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• task_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Task Name, type: esriFieldTypeString )
• funding_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Funding Status, type: esriFieldTypeString , Coded Values: [Funded: Funded] , [Not Funded: Not Funded] , [Soon to be Funded: Soon to be Funded] )
• project_chargecode ( nullable: true, editable: true, defaultValue: null, alias: Project charge code/work order number, type: esriFieldTypeInteger )
• project_nfs_code ( nullable: true, editable: true, defaultValue: null, length: 255, alias: NFS Code, type: esriFieldTypeString , Coded Values: [NA: NA - No NFS] , [5200: 5200 PW - Flood/Floodplain Mgmt NFS] , [5300: 5300 PW - Police NFS] , ...19 more... )
• nochargejustification ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Justification, type: esriFieldTypeString )
• projectbillingnote ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Project Budget Notes, type: esriFieldTypeString )
• requesttype ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Request Type, type: esriFieldTypeString , Coded Values: [Map Production: Map Production: Creation of custom maps to visualize geographic data for analysis or presentation purposes.] , [Data Processing and Spatial Analysis: Data Processing and Spatial Analysis: Manipulation and examination of geographic data to identify patterns, relationships, and trends within a spatial context.] , [Asset Management: Asset Management: Organization and tracking of physical assets, such as infrastructure or equipment, within a geographic information system.] , ...6 more... )
• context ( nullable: true, editable: true, defaultValue: null, length: 1500, alias: Task Context, type: esriFieldTypeString )
• description ( nullable: true, editable: true, defaultValue: null, length: 1500, alias: Task Description, type: esriFieldTypeString )
• instance_calc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Instance name, type: esriFieldTypeString )
• server_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: File Submittal Server Location, type: esriFieldTypeString )
• folder_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: File Submittal Folder Name, type: esriFieldTypeString )
• filesubmittal_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: File Submittal Pathway, type: esriFieldTypeString )
• filedescriptionaddressing ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Submitted File Description, type: esriFieldTypeString )
• task_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Task Type, type: esriFieldTypeString , Coded Values: [Isolated: Isolated] , [Recurring: Recurring] )
• taskstatus ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Task Status, type: esriFieldTypeString , Coded Values: [Not Started: Not Started] , [In Progress: In Progress] , [Waiting on Someone Else: Waiting on Someone Else] , ...2 more... )
• status_notes ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Task Status Notes, type: esriFieldTypeString )
• taskprogress ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Current Task Progress, type: esriFieldTypeString , Coded Values: [0: 0%] , [20: 20%] , [40: 40%] , ...3 more... )
• task_completiondate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Task Completion, type: esriFieldTypeDate )
• resource_location ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Location(s) of project data, type: esriFieldTypeString )
• assignedto ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Task Manager, type: esriFieldTypeString , Coded Values: [Unassigned: Unassigned] , [Cierra Scriven: Cierra Scriven] , [Brian Coward: Brian Coward] , ...3 more... )
• assignedto_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: "Other" team member assigned, type: esriFieldTypeString )
• aprx_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project APRX file pathway, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Types:

ID: Complete
Name: Complete
Domains:
Templates:
• Name: Complete
  Description:
  Prototype:
  task_name: null
  processing_time: null
  submitter: null
  server_location: null
  description: null
  filesubmittal_location: null
  task_completiondate: null
  project_name: null
  nochargejustification: null
  status_notes: null
  deadline_type: null
  resource_location: null
  submission_date: null
  taskstatus: Complete
  requesttype: null
  urgency: null
  context: null
  deadline: null
  department: null
  email: null
  department_other: null
  project_nfs_code: null
  project_chargecode: null
  filedescriptionaddressing: null
  taskprogress: null
  aprx_location: null
  assignedto_other: null
  team: null
  folder_name: null
  instance_calc: null
  assignedto: null
  position: null
  projectbillingnote: null
  task_type: null
  funding_status: null
  
  Drawing Tool: N/A

---

ID: Dormant (Recurring)
Name: Dormant (Recurring)
Domains:
Templates:
• Name: Dormant (Recurring)
  Description:
  Prototype:
  task_name: null
  processing_time: null
  submitter: null
  server_location: null
  description: null
  filesubmittal_location: null
  task_completiondate: null
  project_name: null
  nochargejustification: null
  status_notes: null
  deadline_type: null
  resource_location: null
  submission_date: null
  taskstatus: Dormant (Recurring)
  requesttype: null
  urgency: null
  context: null
  deadline: null
  department: null
  email: null
  department_other: null
  project_nfs_code: null
  project_chargecode: null
  filedescriptionaddressing: null
  taskprogress: null
  aprx_location: null
  assignedto_other: null
  team: null
  folder_name: null
  instance_calc: null
  assignedto: null
  position: null
  projectbillingnote: null
  task_type: null
  funding_status: null
  
  Drawing Tool: N/A

---

ID: Waiting on Someone Else
Name: Waiting on Someone Else
Domains:
Templates:
• Name: Waiting on Someone Else
  Description:
  Prototype:
  task_name: null
  processing_time: null
  submitter: null
  server_location: null
  description: null
  filesubmittal_location: null
  task_completiondate: null
  project_name: null
  nochargejustification: null
  status_notes: null
  deadline_type: null
  resource_location: null
  submission_date: null
  taskstatus: Waiting on Someone Else
  requesttype: null
  urgency: null
  context: null
  deadline: null
  department: null
  email: null
  department_other: null
  project_nfs_code: null
  project_chargecode: null
  filedescriptionaddressing: null
  taskprogress: null
  aprx_location: null
  assignedto_other: null
  team: null
  folder_name: null
  instance_calc: null
  assignedto: null
  position: null
  projectbillingnote: null
  task_type: null
  funding_status: null
  
  Drawing Tool: N/A

---

ID: In Progress
Name: In Progress
Domains:
Templates:
• Name: In Progress
  Description:
  Prototype:
  task_name: null
  processing_time: null
  submitter: null
  server_location: null
  description: null
  filesubmittal_location: null
  task_completiondate: null
  project_name: null
  nochargejustification: null
  status_notes: null
  deadline_type: null
  resource_location: null
  submission_date: null
  taskstatus: In Progress
  requesttype: null
  urgency: null
  context: null
  deadline: null
  department: null
  email: null
  department_other: null
  project_nfs_code: null
  project_chargecode: null
  filedescriptionaddressing: null
  taskprogress: null
  aprx_location: null
  assignedto_other: null
  team: null
  folder_name: null
  instance_calc: null
  assignedto: null
  position: null
  projectbillingnote: null
  task_type: null
  funding_status: null
  
  Drawing Tool: N/A

---

ID: Not Started
Name: Not Started
Domains:
Templates:
• Name: Not Started
  Description:
  Prototype:
  task_name: null
  processing_time: null
  submitter: null
  server_location: null
  description: null
  filesubmittal_location: null
  task_completiondate: null
  project_name: null
  nochargejustification: null
  status_notes: null
  deadline_type: null
  resource_location: null
  submission_date: null
  taskstatus: Not Started
  requesttype: null
  urgency: null
  context: null
  deadline: null
  department: null
  email: null
  department_other: null
  project_nfs_code: null
  project_chargecode: null
  filedescriptionaddressing: null
  taskprogress: null
  aprx_location: null
  assignedto_other: null
  team: null
  folder_name: null
  instance_calc: null
  assignedto: null
  position: null
  projectbillingnote: null
  task_type: null
  funding_status: null
  
  Drawing Tool: N/A

---

Relationships:

• gis_request_form_unabridged_subtask (0) -- Related To: subtask (1)

Capabilities: Create,Editing,Uploads,Query,Update,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata