Name: Completed Street Sweeping Routes

Display Field: DPWUnit

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• StartTime (type: esriFieldTypeDate, alias: Start Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FinishTime (type: esriFieldTypeDate, alias: Finish Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DPWUnit (type: esriFieldTypeString, alias: Collection Personel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VehicleType (type: esriFieldTypeString, alias: Vehicle Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CollectType (type: esriFieldTypeString, alias: Collection Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AbateComplete (type: esriFieldTypeString, alias: Abatement Complete, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• created_user (type: esriFieldTypeString, alias: Entered by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Entered On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)

Templates:

Name: Street Sweeping Route Collection Totals
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AbateComplete: NO
• GUID: {00000000-0000-0000-0000-000000000000}
• DPWUnit: SWMS - Street Sweeping
• VehicleType: Street Sweeper
• Method: Street Sweeping
• CollectType: Street Sweeping

Relationships:

• Collab_StreetSweepRoutes (0) -- Related To: Street Sweeping Routes (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/28/2025 12:16:24 PM

Schema Last Edit Date: 5/28/2025 12:16:24 PM

Data Last Edit Date: 5/28/2025 12:16:24 PM

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