View In:   ArcGIS Online Map Viewer

Name: Tickets

Display Field: submitted_by_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1d175a421ed345c5a806429c18ad4fd1

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 4322286.0688000005
XMax: 762084.5749000004
YMax: 4347828.4405000005
Spatial Reference: 32612  (32612)  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: Open
  Description: N/A
  Symbol:
  
• Value: 2
  Label: In Progress
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Resolved
  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 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 Current User: true

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

Types:

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

---

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

---

ID: 3
Name: Resolved
Domains:
• category:
  Inherited
• priority:
  Inherited
• status:
  Inherited
• assigned_to:
  Inherited
• notification_sent:
  Inherited
• survey_sent:
  Inherited
• source:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  source: null
  photo_count: null
  ticket_id: {00000000-0000-0000-0000-000000000000}
  ticket_number: null
  submitted_by_name: null
  submitted_by_email: null
  submitted_by_phone: null
  category: 12
  subcategory: null
  priority: null
  status: 3
  assigned_to: null
  description: null
  boundary_id: null
  created_date: null
  modified_date: null
  resolved_date: null
  notification_sent: null
  survey_sent: null
  internal_notes: null
  address_submitted: null
  latitude: 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: true

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