View In:   ArcGIS Online Map Viewer

Name: GIS_Request_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e74c8c5422214001b9e33c32f8ea1eb9

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: esriSMSCircle
  Color: [170, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: In Progress
  Label: In Progress
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: Waiting on Someone Else
  Label: Waiting on Someone Else
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: Not Started
  Label: Not Started
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [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: false
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, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• 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 )
• hard_deadline ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hard deadline?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• submitter ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request submitter name, type: esriFieldTypeString )
• submitter_position ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Request submitter position, type: esriFieldTypeString )
• submission_department ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requester Department, type: esriFieldTypeString , Coded Values: [finance: Finance] , [it: IT] , [capital projects: Capital Projects] , ...8 more... )
• subdepartment_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Requester Department (Other), type: esriFieldTypeString )
• submission_team ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Team, type: esriFieldTypeString )
• project_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• project_funded ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Funded?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] )
• 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: Unfunded request justification, type: esriFieldTypeString )
• projectbillingnote ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Project budget note, type: esriFieldTypeString )
• requesttype ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Request Type, type: esriFieldTypeString , Coded Values: [transmittal: Transmittal] , [surveying: Surveying] , [improvement: Improvement] , ...4 more... )
• instance_calc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Instance name, type: esriFieldTypeString )
• transmittalrecipient ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Recipient, type: esriFieldTypeString )
• transmittalrecipientcontact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Recipient Contact Information, type: esriFieldTypeString )
• transmittalsender ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Sender, type: esriFieldTypeString )
• transmittalsendercontact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Sender Contact Information, type: esriFieldTypeString )
• drawingformat ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Drawing Format, type: esriFieldTypeString )
• drawingformat_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Drawing Format (Other), type: esriFieldTypeString )
• staffrequest ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Staff Request, type: esriFieldTypeString )
• staffrequest_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Staff Request (Other), type: esriFieldTypeString )
• transmittaldescription ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Transmittal Description, type: esriFieldTypeString )
• designdrafting ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Design Drafting, type: esriFieldTypeString )
• designdrafting_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Design Drafting (Other), type: esriFieldTypeString )
• recordedmapsubmittal ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Recorded Map Submittal, type: esriFieldTypeString )
• recmapsubmittal_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Recorded Map Submittal (Other), type: esriFieldTypeString )
• draftingrecordmgmt ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Drafting Records Management, type: esriFieldTypeString )
• draftingrecordmgmt_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Drafting Records Management (Other), type: esriFieldTypeString )
• workrequest ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Request, type: esriFieldTypeString )
• workrequest_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work Request (Other), type: esriFieldTypeString )
• gis_mapping ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Geospatial (GIS) Mapping, type: esriFieldTypeString )
• gis_mapping_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GIS Mapping (Other), type: esriFieldTypeString )
• comments_draftingtransmittal ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Work Request/GIS Mapping Comments, type: esriFieldTypeString )
• apn ( nullable: true, editable: true, defaultValue: null, alias: APN, type: esriFieldTypeInteger )
• addressmap ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Address Map, type: esriFieldTypeString )
• applicantname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Name, type: esriFieldTypeString )
• applicantemail ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Email Address, type: esriFieldTypeString )
• applicantphone ( nullable: true, editable: true, defaultValue: null, alias: Applicant Phone Number, type: esriFieldTypeInteger )
• survey_cip ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Surveying for Capital Projects (design drafting), type: esriFieldTypeString )
• survey_cip_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Surveying for Capital Projects (Other), type: esriFieldTypeString )
• engsurvey_datacollection ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Engineering Surveying & Data Collection, type: esriFieldTypeString )
• engsurvey_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Engineering Surveying & Data Collection (Other), type: esriFieldTypeString )
• privdevproject ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Private Development Project, type: esriFieldTypeString )
• privdevproject_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Private Development Project (Other), type: esriFieldTypeString )
• refdrawing ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reference Drawing, type: esriFieldTypeString )
• refdrawing_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reference Drawing (Other), type: esriFieldTypeString )
• refdraw_pathway ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reference Drawing Submittal Server Location, type: esriFieldTypeString )
• refdraw_folder ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reference Drawing Submittal Folder Name, type: esriFieldTypeString )
• refdraw_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Reference Drawing Submittal Pathway, type: esriFieldTypeString )
• refdraw_description ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Reference Drawing Description, type: esriFieldTypeString )
• workdescription ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Survey Work Description and Special Instructions, type: esriFieldTypeString )
• addressing_redirect ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Addressing Notification, type: esriFieldTypeString )
• gisdatarequestdescription ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: GIS & Data Request Description, type: esriFieldTypeString )
• otherrequestdescription ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: "Other" Request Description, type: esriFieldTypeString )
• othersubmittal_step1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: "Other" Submittal Server Location, type: esriFieldTypeString )
• othersubmittal_step2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: "Other" Submittal Folder Name, type: esriFieldTypeString )
• othersubmittal_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: "Other" Submittal Pathway, type: esriFieldTypeString )
• otherfile_description ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: "Other" File Submittal description, type: esriFieldTypeString )
• 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] , ...1 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: GIS team member assigned, type: esriFieldTypeString , Coded Values: [Unassigned: Unassigned] , [Cierra Scriven: Cierra Scriven] , [Brian Coward: Brian Coward] , ...4 more... )
• tasknotes1 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Task Notes 1, type: esriFieldTypeString )
• tasknotes2 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Task Notes 2, type: esriFieldTypeString )
• tasknotes3 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Task Notes 3, type: esriFieldTypeString )
• tasknotes4 ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Task Notes 4, type: esriFieldTypeString )
• 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:
None
Templates:
• Name: Complete
  Description:
  Prototype:
  transmittalsender: null
  designdrafting_other: null
  addressmap: null
  task_completiondate: null
  transmittaldescription: null
  project_name: null
  nochargejustification: null
  othersubmittal_step1: null
  workrequest_other: null
  othersubmittal_step2: null
  applicantname: null
  comments_draftingtransmittal: null
  apn: null
  project_nfs_code: null
  applicantphone: null
  project_chargecode: null
  refdrawing_other: null
  taskprogress: null
  staffrequest: null
  engsurvey_datacollection: null
  instance_calc: null
  otherrequestdescription: null
  recordedmapsubmittal: null
  draftingrecordmgmt: null
  refdraw_location: null
  addressing_redirect: null
  submitter_position: null
  gis_mapping: null
  survey_cip: null
  workdescription: null
  project_funded: null
  applicantemail: null
  submitter: null
  gis_mapping_other: null
  tasknotes4: null
  privdevproject_other: null
  tasknotes2: null
  tasknotes3: null
  refdraw_description: null
  tasknotes1: null
  transmittalrecipient: null
  draftingrecordmgmt_other: null
  status_notes: null
  transmittalrecipientcontact: null
  resource_location: null
  hard_deadline: null
  submission_date: null
  taskstatus: Complete
  requesttype: null
  transmittalsendercontact: null
  workrequest: null
  recmapsubmittal_other: null
  survey_cip_other: null
  subdepartment_other: null
  refdrawing: null
  otherfile_description: null
  deadline: null
  privdevproject: null
  submission_team: null
  designdrafting: null
  drawingformat_other: null
  staffrequest_other: null
  assignedto: null
  refdraw_pathway: null
  gisdatarequestdescription: null
  othersubmittal_location: null
  submission_department: null
  engsurvey_other: null
  refdraw_folder: null
  projectbillingnote: null
  drawingformat: null
  
  Drawing Tool: N/A

---

ID: In Progress
Name: In Progress
Domains:
None
Templates:
• Name: In Progress
  Description:
  Prototype:
  transmittalsender: null
  designdrafting_other: null
  addressmap: null
  task_completiondate: null
  transmittaldescription: null
  project_name: null
  nochargejustification: null
  othersubmittal_step1: null
  workrequest_other: null
  othersubmittal_step2: null
  applicantname: null
  comments_draftingtransmittal: null
  apn: null
  project_nfs_code: null
  applicantphone: null
  project_chargecode: null
  refdrawing_other: null
  taskprogress: null
  staffrequest: null
  engsurvey_datacollection: null
  instance_calc: null
  otherrequestdescription: null
  recordedmapsubmittal: null
  draftingrecordmgmt: null
  refdraw_location: null
  addressing_redirect: null
  submitter_position: null
  gis_mapping: null
  survey_cip: null
  workdescription: null
  project_funded: null
  applicantemail: null
  submitter: null
  gis_mapping_other: null
  tasknotes4: null
  privdevproject_other: null
  tasknotes2: null
  tasknotes3: null
  refdraw_description: null
  tasknotes1: null
  transmittalrecipient: null
  draftingrecordmgmt_other: null
  status_notes: null
  transmittalrecipientcontact: null
  resource_location: null
  hard_deadline: null
  submission_date: null
  taskstatus: In Progress
  requesttype: null
  transmittalsendercontact: null
  workrequest: null
  recmapsubmittal_other: null
  survey_cip_other: null
  subdepartment_other: null
  refdrawing: null
  otherfile_description: null
  deadline: null
  privdevproject: null
  submission_team: null
  designdrafting: null
  drawingformat_other: null
  staffrequest_other: null
  assignedto: null
  refdraw_pathway: null
  gisdatarequestdescription: null
  othersubmittal_location: null
  submission_department: null
  engsurvey_other: null
  refdraw_folder: null
  projectbillingnote: null
  drawingformat: null
  
  Drawing Tool: N/A

---

ID: Waiting on Someone Else
Name: Waiting on Someone Else
Domains:
None
Templates:
• Name: Waiting on Someone Else
  Description:
  Prototype:
  transmittalsender: null
  designdrafting_other: null
  addressmap: null
  task_completiondate: null
  transmittaldescription: null
  project_name: null
  nochargejustification: null
  othersubmittal_step1: null
  workrequest_other: null
  othersubmittal_step2: null
  applicantname: null
  comments_draftingtransmittal: null
  apn: null
  project_nfs_code: null
  applicantphone: null
  project_chargecode: null
  refdrawing_other: null
  taskprogress: null
  staffrequest: null
  engsurvey_datacollection: null
  instance_calc: null
  otherrequestdescription: null
  recordedmapsubmittal: null
  draftingrecordmgmt: null
  refdraw_location: null
  addressing_redirect: null
  submitter_position: null
  gis_mapping: null
  survey_cip: null
  workdescription: null
  project_funded: null
  applicantemail: null
  submitter: null
  gis_mapping_other: null
  tasknotes4: null
  privdevproject_other: null
  tasknotes2: null
  tasknotes3: null
  refdraw_description: null
  tasknotes1: null
  transmittalrecipient: null
  draftingrecordmgmt_other: null
  status_notes: null
  transmittalrecipientcontact: null
  resource_location: null
  hard_deadline: null
  submission_date: null
  taskstatus: Waiting on Someone Else
  requesttype: null
  transmittalsendercontact: null
  workrequest: null
  recmapsubmittal_other: null
  survey_cip_other: null
  subdepartment_other: null
  refdrawing: null
  otherfile_description: null
  deadline: null
  privdevproject: null
  submission_team: null
  designdrafting: null
  drawingformat_other: null
  staffrequest_other: null
  assignedto: null
  refdraw_pathway: null
  gisdatarequestdescription: null
  othersubmittal_location: null
  submission_department: null
  engsurvey_other: null
  refdraw_folder: null
  projectbillingnote: null
  drawingformat: null
  
  Drawing Tool: N/A

---

ID: Not Started
Name: Not Started
Domains:
None
Templates:
• Name: Not Started
  Description:
  Prototype:
  transmittalsender: null
  designdrafting_other: null
  addressmap: null
  task_completiondate: null
  transmittaldescription: null
  project_name: null
  nochargejustification: null
  othersubmittal_step1: null
  workrequest_other: null
  othersubmittal_step2: null
  applicantname: null
  comments_draftingtransmittal: null
  apn: null
  project_nfs_code: null
  applicantphone: null
  project_chargecode: null
  refdrawing_other: null
  taskprogress: null
  staffrequest: null
  engsurvey_datacollection: null
  instance_calc: null
  otherrequestdescription: null
  recordedmapsubmittal: null
  draftingrecordmgmt: null
  refdraw_location: null
  addressing_redirect: null
  submitter_position: null
  gis_mapping: null
  survey_cip: null
  workdescription: null
  project_funded: null
  applicantemail: null
  submitter: null
  gis_mapping_other: null
  tasknotes4: null
  privdevproject_other: null
  tasknotes2: null
  tasknotes3: null
  refdraw_description: null
  tasknotes1: null
  transmittalrecipient: null
  draftingrecordmgmt_other: null
  status_notes: null
  transmittalrecipientcontact: null
  resource_location: null
  hard_deadline: null
  submission_date: null
  taskstatus: Not Started
  requesttype: null
  transmittalsendercontact: null
  workrequest: null
  recmapsubmittal_other: null
  survey_cip_other: null
  subdepartment_other: null
  refdrawing: null
  otherfile_description: null
  deadline: null
  privdevproject: null
  submission_team: null
  designdrafting: null
  drawingformat_other: null
  staffrequest_other: null
  assignedto: null
  refdraw_pathway: null
  gisdatarequestdescription: null
  othersubmittal_location: null
  submission_department: null
  engsurvey_other: null
  refdraw_folder: null
  projectbillingnote: null
  drawingformat: null
  
  Drawing Tool: N/A

---

Relationships:

• GIS_Request_Form_group_improvementsubmittal (0) -- Related To: group_improvementsubmittal (1)
• GIS_Request_Form_group_mapsubmittal (1) -- Related To: group_mapsubmittal (2)

Capabilities: Query

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: false
• Allow Others to Delete: false
• 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   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata