View In:   ArcGIS Online Map Viewer

Name: Tickets

Display Field: submitted_by_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 908b018b2aab44438668e3344b92a295

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 0

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: 701195.7076000003
YMin: 4322190.6028
XMax: 762084.5749000004
YMax: 4347828.4405000005
Spatial Reference: 32612  (32612)

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: Open
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Received
  Description: N/A
  Symbol:
  
• Value: 3
  Label: In Progress
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Resolved
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Closed
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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: 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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: status

Fields:

• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• ticket_id ( modelName: ticket_id, nullable: false, editable: true, defaultValue: {00000000-0000-0000-0000-000000000000}, length: 38, alias: Ticket ID, type: esriFieldTypeGUID )
• ticket_number ( modelName: ticket_number, nullable: true, editable: true, defaultValue: N/A, alias: Ticket Number, type: esriFieldTypeInteger )
• submitted_by_name ( modelName: submitted_by_name, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Submitter Name, type: esriFieldTypeString )
• submitted_by_email ( modelName: submitted_by_email, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Submitter Email, type: esriFieldTypeString )
• submitted_by_phone ( modelName: submitted_by_phone, nullable: true, editable: true, defaultValue: N/A, length: 25, alias: Submitter Phone, type: esriFieldTypeString )
• category ( modelName: category, nullable: false, editable: true, defaultValue: 12, alias: Category, type: esriFieldTypeSmallInteger , Coded Values: [1: Water] , [2: Sewer] , [3: Roads & Pavement] , ...10 more... )
• subcategory ( modelName: subcategory, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Subcategory, type: esriFieldTypeString )
• priority ( modelName: priority, nullable: true, editable: true, defaultValue: N/A, alias: Priority, type: esriFieldTypeSmallInteger , Coded Values: [1: Low] , [2: Medium] , [3: High] , ...1 more... )
• status ( modelName: status, nullable: true, editable: true, defaultValue: N/A, alias: Status, type: esriFieldTypeSmallInteger , Coded Values: [1: Open] , [2: Received] , [3: In Progress] , ...2 more... )
• assigned_to ( modelName: assigned_to, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Assigned To, type: esriFieldTypeString , Coded Values: [City Manager/City Council/City Attorney: City Manager/City Council/City Attorney] , [Code Enforcement: Code Enforcement] , [Drainage: Drainage] , ...12 more... )
• description ( modelName: description, nullable: true, editable: true, defaultValue: N/A, length: 500, alias: Description, type: esriFieldTypeString )
• boundary_id ( modelName: boundary_id, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Boundary ID, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Created Date, type: esriFieldTypeDate )
• modified_date ( modelName: modified_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Modified Date, type: esriFieldTypeDate )
• resolved_date ( modelName: resolved_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Resolved Date, type: esriFieldTypeDate )
• notification_sent ( modelName: notification_sent, nullable: true, editable: true, defaultValue: N/A, alias: Notification Sent, type: esriFieldTypeSmallInteger , Coded Values: [0: Pending] , [1: Sent] )
• survey_sent ( modelName: survey_sent, nullable: true, editable: true, defaultValue: N/A, alias: Survey Sent, type: esriFieldTypeSmallInteger , Coded Values: [0: Not Sent] , [1: Sent] )
• internal_notes ( modelName: internal_notes, nullable: true, editable: true, defaultValue: N/A, length: 500, alias: Internal Notes, type: esriFieldTypeString )
• address_submitted ( modelName: address_submitted, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Address Submitted, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: N/A, alias: Latitude (DD), type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: N/A, alias: Longitude (DD), type: esriFieldTypeDouble )
• photo_count ( modelName: photo_count, nullable: true, editable: true, defaultValue: N/A, alias: Photo Count, type: esriFieldTypeSmallInteger )
• source ( modelName: source, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Submission Source, type: esriFieldTypeString , Coded Values: [WEB: Web Form] , [MOBILE: Mobile] , [STAFF: Staff Entry] , ...1 more... )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• created_by ( modelName: created_by, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_by, type: esriFieldTypeString )
• creation_date ( modelName: creation_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: creation_date, type: esriFieldTypeDate )
• last_edited_by ( modelName: last_edited_by, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_by, type: esriFieldTypeString )
• last_edit_date ( modelName: last_edit_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edit_date, type: esriFieldTypeDate )
• last_notified_assignee ( modelName: last_notified_assignee, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Last Notified Assignee, type: esriFieldTypeString )

Types:

ID: 1
Name: Open
Domains:
• notification_sent:
  Inherited
• source:
  Inherited
• category:
  Inherited
• priority:
  Inherited
• survey_sent:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  notification_sent: null
  resolved_date: null
  address_submitted: null
  latitude: null
  description: null
  source: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  priority: null
  modified_date: null
  survey_sent: null
  last_notified_assignee: null
  submitted_by_email: null
  boundary_id: null
  photo_count: null
  internal_notes: null
  submitted_by_phone: null
  submitted_by_name: null
  created_date: null
  category: 12
  subcategory: null
  status: 1
  assigned_to: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Received
Domains:
• notification_sent:
  Inherited
• source:
  Inherited
• category:
  Inherited
• priority:
  Inherited
• survey_sent:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  notification_sent: null
  resolved_date: null
  address_submitted: null
  latitude: null
  description: null
  source: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  priority: null
  modified_date: null
  survey_sent: null
  last_notified_assignee: null
  submitted_by_email: null
  boundary_id: null
  photo_count: null
  internal_notes: null
  submitted_by_phone: null
  submitted_by_name: null
  created_date: null
  category: 12
  subcategory: null
  status: 2
  assigned_to: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: In Progress
Domains:
• notification_sent:
  Inherited
• source:
  Inherited
• category:
  Inherited
• priority:
  Inherited
• survey_sent:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  notification_sent: null
  resolved_date: null
  address_submitted: null
  latitude: null
  description: null
  source: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  priority: null
  modified_date: null
  survey_sent: null
  last_notified_assignee: null
  submitted_by_email: null
  boundary_id: null
  photo_count: null
  internal_notes: null
  submitted_by_phone: null
  submitted_by_name: null
  created_date: null
  category: 12
  subcategory: null
  status: 3
  assigned_to: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Resolved
Domains:
• notification_sent:
  Inherited
• source:
  Inherited
• category:
  Inherited
• priority:
  Inherited
• survey_sent:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  notification_sent: null
  resolved_date: null
  address_submitted: null
  latitude: null
  description: null
  source: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  priority: null
  modified_date: null
  survey_sent: null
  last_notified_assignee: null
  submitted_by_email: null
  boundary_id: null
  photo_count: null
  internal_notes: null
  submitted_by_phone: null
  submitted_by_name: null
  created_date: null
  category: 12
  subcategory: null
  status: 4
  assigned_to: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Closed
Domains:
• notification_sent:
  Inherited
• source:
  Inherited
• category:
  Inherited
• priority:
  Inherited
• survey_sent:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
Templates:
• Name: 5
  Description:
  Prototype:
  notification_sent: null
  resolved_date: null
  address_submitted: null
  latitude: null
  description: null
  source: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  priority: null
  modified_date: null
  survey_sent: null
  last_notified_assignee: null
  submitted_by_email: null
  boundary_id: null
  photo_count: null
  internal_notes: null
  submitted_by_phone: null
  submitted_by_name: null
  created_date: null
  category: 12
  subcategory: null
  status: 5
  assigned_to: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creation_date
• Creator Field: created_by
• Edit Date Field: last_edit_date
• Editor Field: last_edited_by

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata