Name: Tasks_Point

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: false

Views

Description: <p><strong>Overview</strong></p><p>This Feature Service provides point features as part of the comprehensive data on work order tasks managed by the City of Santa Barbara's Public Works and Information Technology departments. It integrates geospatial information from the Oracle-based Cartegraph Operations Management System (OMS) to support reporting, analytics, and operational oversight.</p><p><strong>Feature Layer</strong></p><ul><li><strong>Tasks Point Layer</strong>: This layer represents individual task locations as points, describing detailed task attributes such as activity type, status, priority, department, and associated costs for labor, materials, and equipment. It also includes schedule information like actual and estimated start and stop dates, and address-level location details (street, city, state, zip code). These data fields enable detailed task tracking and cost accounting.</li></ul><p><strong>Geographic Coverage</strong></p><p>The Feature Service covers the entire jurisdiction of the City of Santa Barbara, providing a spatial dataset for urban and infrastructure asset management activities.</p><p><strong>Use Cases</strong></p><ul><li>Tracking and managing public works tasks and maintenance activities geographically at point, line, and polygon scales.</li><li>Supporting cost analysis and resource allocation through detailed cost fields per task.</li><li>Facilitating operational reporting and analytics through integration with asset management systems.</li></ul><p><strong>Last Update</strong>: &nbsp;2026</p>

Copyright Text: Cartegraph, Water Resources Department, Public Works, and Information Technology, City of Santa Barbara

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

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

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,83,66,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeString, alias: Task ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StartDateActual (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• StopDateActual (type: esriFieldTypeDate, alias: Actual Stop Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Carte_Geometry_Type (type: esriFieldTypeString, alias: Cartegraph Geometry Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• cgAssetType (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• cgAssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DueDate (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EquipmentCostActual (type: esriFieldTypeDouble, alias: Equipment Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEMA (type: esriFieldTypeString, alias: FEMA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LaborCostActual (type: esriFieldTypeDouble, alias: Labor Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LaborHoursActual (type: esriFieldTypeDouble, alias: Labor Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaterialCostActual (type: esriFieldTypeDouble, alias: Material Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• OtherCostActual (type: esriFieldTypeDouble, alias: Other Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Request (type: esriFieldTypeString, alias: Request, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TotalCostActual (type: esriFieldTypeDouble, alias: Total Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkOrder (type: esriFieldTypeString, alias: Work Order, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddressNumber (type: esriFieldTypeDouble, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IntersectingStreet (type: esriFieldTypeString, alias: Intersecting Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StartDateEstimated (type: esriFieldTypeDateOnly, alias: Estimated Start Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StopDateEstimated (type: esriFieldTypeDateOnly, alias: Estimated Stop Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tonnage (type: esriFieldTypeDouble, alias: Tonnage, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Tasks_Point
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/27/2026 12:55:58 PM

Schema Last Edit Date: 6/4/2026 4:31:43 PM

Data Last Edit Date: 9/27/2026 12:55:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat