Name: Maintenance

Display Field: NewAssetID

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• NewAssetID (type: esriFieldTypeString, alias: New Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AW_OLD (type: esriFieldTypeString, alias: AW_OLD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Maintenance_Type (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Prune: Prune], [Removal & Stump: Removal & Stump], [Chemical Application: Chemical Application], ... 6 more ...)
• Date_Performed (type: esriFieldTypeDate, alias: Date Performed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date_Requested (type: esriFieldTypeDate, alias: Date Requested, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Reason_for_Prune (type: esriFieldTypeString, alias: Reason for Prune, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Request: Request], [Block: Block], [Storm : Storm ], ... 3 more ...)
• Type_of_Pruning (type: esriFieldTypeString, alias: Type of Pruning, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Suckers: Suckers], [Full: Full], [Deadwood: Deadwood], ... 3 more ...)
• Pruning_Comments (type: esriFieldTypeString, alias: Pruning Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Marked_Date (type: esriFieldTypeDate, alias: Marked for Removal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Reason (type: esriFieldTypeString, alias: Reason, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [animal damage: animal damage], [Construction: Construction], [D.E.D.: D.E.D.], ... 18 more ...)
• Removed (type: esriFieldTypeString, alias: Removed, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Pulled (type: esriFieldTypeString, alias: Pulled, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Topped (type: esriFieldTypeString, alias: Topped, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Removal_Comments (type: esriFieldTypeString, alias: Removal Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Stumped_Date (type: esriFieldTypeDate, alias: Stumped Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Pickup_Date (type: esriFieldTypeDate, alias: Pickup Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Vac_All_Date (type: esriFieldTypeDate, alias: Vac-All Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Backfill_Date (type: esriFieldTypeDate, alias: Backfill Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Seed_Date (type: esriFieldTypeDate, alias: Seed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Stump_Comments (type: esriFieldTypeString, alias: Stump Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Chemical (type: esriFieldTypeString, alias: Chemical, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Tree-age: Tree-age], [Imidacloprid: Imidacloprid], [Terro (ants): Terro (ants)], ... 10 more ...)
• Amount (type: esriFieldTypeInteger, alias: Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Equipment_Type (type: esriFieldTypeString, alias: Equipment Type, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Hydraulic Soil Injection: Hydraulic Soil Injection], [Tree IV: Tree IV], [Quickjet gun: Quickjet gun], ... 5 more ...)
• F__of_injection_sites (type: esriFieldTypeInteger, alias: # of injection sites, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Port_Size (type: esriFieldTypeInteger, alias: Port Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Chemical_Comments (type: esriFieldTypeString, alias: Chemical Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Crack_Length (type: esriFieldTypeInteger, alias: Crack Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crack_Depth_1 (type: esriFieldTypeInteger, alias: Crack Depth 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crack_Depth_2 (type: esriFieldTypeInteger, alias: Crack Depth 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crack_Depth_3 (type: esriFieldTypeInteger, alias: Crack Depth 3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• w__Decay (type: esriFieldTypeString, alias: w/ Decay, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• w__Crotch (type: esriFieldTypeString, alias: w/ Crotch, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Crack_Check_Comments (type: esriFieldTypeString, alias: Crack Check Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Wound_Comments (type: esriFieldTypeString, alias: Wound Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Stakes (type: esriFieldTypeString, alias: Stakes, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Mulched (type: esriFieldTypeString, alias: Mulched, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Watered (type: esriFieldTypeString, alias: Watered, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Pick_up_Type (type: esriFieldTypeString, alias: Pick up Type, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [BBH: BBH], [BBD: BBD])
• Area_Affected (type: esriFieldTypeString, alias: Area Affected, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true, Coded Values: [Road: Road], [Alley: Alley], [Driveway: Driveway], ... 3 more ...)
• Pick_up_Comments (type: esriFieldTypeString, alias: Pick up Comments, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Width_Inches (type: esriFieldTypeInteger, alias: Width (In.), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height_Inches (type: esriFieldTypeInteger, alias: Height (In.), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Training (type: esriFieldTypeString, alias: Training, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Picked_Up (type: esriFieldTypeString, alias: Picked Up?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Marked_For_Plant (type: esriFieldTypeString, alias: Marked For Planting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Tree_Planted (type: esriFieldTypeString, alias: Tree Planted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Topped_Date (type: esriFieldTypeDate, alias: Date Topped, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Pulled_Date (type: esriFieldTypeDate, alias: Date Pulled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Removed_Date (type: esriFieldTypeDate, alias: Date Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ResidentNotifiedDate (type: esriFieldTypeDate, alias: ResidentNotifiedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HoleDugDate (type: esriFieldTypeDate, alias: HoleDugDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CrewName (type: esriFieldTypeString, alias: CrewName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Crew 1: Crew 1], [Crew 2: Crew 2], [Crew 3: Crew 3])

Templates:

Name: WA_Tree_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• (0) -- Related To: West Allis Tree Locations (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/22/2026 6:15:54 PM

Schema Last Edit Date: 9/22/2026 6:15:54 PM

Data Last Edit Date: 9/22/2026 6:33:13 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat