Name: GSI_ASSET_MAINTENANCE_WORK_Checklist

Display Field: seed_mix_name_date_note

Type: Table

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)
• uniqueID (type: esriFieldTypeString, alias: uniqueID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• GISOBJID (type: esriFieldTypeInteger, alias: GISOBJID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPDATE_COUNT (type: esriFieldTypeDouble, alias: UPDATE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• COMMISSIONDATE (type: esriFieldTypeDate, alias: Commission Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Active: Active], [Establishment: Establishment], ... 5 more ...)
• OPSTATUS (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Active: Active], [Establishment: Establishment], ... 5 more ...)
• OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [COMMS: COMMUNICATIONS MAINTENANCE], [COT: CITY OF TUCSON], [ES: ENVIRONMENTAL SERVICES], ... 14 more ...)
• INSTALLYEAR (type: esriFieldTypeDate, alias: INSTALLYEAR, SQL Type: sqlTypeOther, length: 8, 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)
• GUIDID (type: esriFieldTypeGUID, alias: GUIDID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• mini_grant_gsi (type: esriFieldTypeString, alias: mini_grant_gsi, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• street_intersection_mx (type: esriFieldTypeString, alias: street_intersection_mx, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• snl_mx_type (type: esriFieldTypeString, alias: snl_mx_type, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true, Coded Values: [Spring/Pre-Monsoon(Mar1-May31): Spring/Pre-Monsoon(Mar1-May31)], [Summer/Monsoon(Jun1-Aug31): Summer/Monsoon(Jun1-Aug31)], [Fall/Post-Monsoon(Sep1-Nov30): Fall/Post-Monsoon(Sep1-Nov30)], ... 2 more ...)
• mx_date (type: esriFieldTypeDate, alias: inventory_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• mx_start_time (type: esriFieldTypeDate, alias: inventory_start_time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• mx_end_time (type: esriFieldTypeDate, alias: inventory_end_time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• mx_time_total (type: esriFieldTypeDouble, alias: inventory_time_total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unauthorized_GSI_work (type: esriFieldTypeString, alias: unauthorized_GSI_work, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• curb_type (type: esriFieldTypeString, alias: curb_type, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• inlet_type (type: esriFieldTypeString, alias: inlet_type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Scupper: Scupper], [Culvert: Culvert], [CurbCut: Curb cut], ... 3 more ...)
• inlet_rec (type: esriFieldTypeString, alias: inlet_rec, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• inlet_note (type: esriFieldTypeString, alias: inlet_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• sed_trap (type: esriFieldTypeString, alias: sediment_trap, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• sed_trap_mx (type: esriFieldTypeString, alias: sed_trap_mx, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Performed: Performed], [Not Needed: Not Needed], [Not Applicable: Not Applicable])
• sed_removal (type: esriFieldTypeString, alias: sed_removal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• inlet_sed_note (type: esriFieldTypeString, alias: inlet_sed_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• basin_mx (type: esriFieldTypeString, alias: basin_mx, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Performed: Performed], [Not Needed: Not Needed], [Not Applicable: Not Applicable])
• basin_sed_rvl (type: esriFieldTypeString, alias: basin_sed_rvl, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• basin_rec (type: esriFieldTypeString, alias: basin_rec, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• basin_rec_note (type: esriFieldTypeString, alias: basin_rec_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• basin_loc_note (type: esriFieldTypeString, alias: basin_loc_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• erosion_repair (type: esriFieldTypeString, alias: erosion_repair, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Performed: Performed], [Required: Required], [NotNeeded: Not Needed], ... 1 more ...)
• erosion_repair_note (type: esriFieldTypeString, alias: erosion_repair_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• outlet_ovfl (type: esriFieldTypeString, alias: outlet_ovfl, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• outlet_ovfl_mx (type: esriFieldTypeString, alias: outlet_ovfl_mx, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Performed: Performed], [NotNeeded: Not needed], [ReconstructionRequired: Reconstruction required], ... 2 more ...)
• inlet_outlet_repair_note (type: esriFieldTypeString, alias: inlet_outlet_repair_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• trash_rvl (type: esriFieldTypeString, alias: trash_rvl, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable])
• dumping_violation_report (type: esriFieldTypeString, alias: dumping_violation_report, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• trash_rvl_note (type: esriFieldTypeString, alias: trash_rvl_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• num_trees_2incOrGreater (type: esriFieldTypeSmallInteger, alias: num_trees_2incOrGreater, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pruning_pfmd (type: esriFieldTypeString, alias: pruning_pfmd, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Trees: Trees], [Grass: Grass], [Shrubs: Shrubs], ... 2 more ...)
• pruning_purpose (type: esriFieldTypeString, alias: pruning_purpose, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• veg_rvl (type: esriFieldTypeString, alias: veg_rvl, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NotApplicable: NotApplicable], [Trees: Trees], [Grass: Grass], ... 3 more ...)
• veg_rvl_purpose (type: esriFieldTypeString, alias: veg_rvl_purpose, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Visibility: Visibility], [VehicleClearance: Vehicle clearance], [PedestrianClearance: Pedestrian clearance], ... 5 more ...)
• veg_rvl_note (type: esriFieldTypeString, alias: veg_rvl_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• veg_added (type: esriFieldTypeString, alias: veg_added, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• seed_mix_name_date_note (type: esriFieldTypeString, alias: seed_mix_name_date_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• plant_tree_type_note (type: esriFieldTypeString, alias: plant_tree_type_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• veg_added_note (type: esriFieldTypeString, alias: veg_added_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• veg_repmt (type: esriFieldTypeString, alias: veg_repmt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable])
• veg_to_replace (type: esriFieldTypeString, alias: veg_to_replace, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Trees: Trees], [Grass: Grass], [Shrubs: Shrubs], ... 2 more ...)
• veg_to_replace_note (type: esriFieldTypeString, alias: veg_to_replace_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• arborist_conslt (type: esriFieldTypeString, alias: arborist_conslt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• tree_type_conslt (type: esriFieldTypeString, alias: veg_tree_type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CatclawAcacia: Catclaw Acacia], [WhitethornAcacia: Whitethorn Acacia], [CanyonHackberry: Canyon Hackberry], ... 13 more ...)
• arborist_conslt_note (type: esriFieldTypeString, alias: arborist_conslt_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• leave_volunteer_tree (type: esriFieldTypeString, alias: leave_volunteer_tree, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• tree_type (type: esriFieldTypeString, alias: veg_non_tree_type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CatclawAcacia: Catclaw Acacia], [WhitethornAcacia: Whitethorn Acacia], [CanyonHackberry: Canyon Hackberry], ... 13 more ...)
• volunteer_tree_obs (type: esriFieldTypeString, alias: volunteer_tree_obs, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true, Coded Values: [NotBlockingInlet/Outlet: Not blocking inlet/outlet], [WillNotBlockSightLineOrTrafficSignageVisibilityOnceMature: Will not block sight line or traffic signage visibility once mature], [NoObservableUtilityConflicts: No observable utility conflicts], ... 1 more ...)
• gcover_repmt (type: esriFieldTypeString, alias: veg_gcover, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Dirt: Dirt], [Rock: Rock], [Gravel: Gravel], ... 4 more ...)
• gcover_repmt_note (type: esriFieldTypeString, alias: gcover_repmt_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• invasive_species (type: esriFieldTypeString, alias: invasive_species, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cheeseweed: Cheeseweed], [Stinknet: Stinknet], [BermudaGrass: Bermuda Grass], ... 5 more ...)
• invasive_species_oth (type: esriFieldTypeString, alias: invasive_species_oth, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• invasive_species_rvl (type: esriFieldTypeString, alias: invasive_species_rvl, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes-All], [Partially: Yes-Partially], [No: No])
• invasive_species_rvl_note (type: esriFieldTypeString, alias: invasive_species_rvl_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• weed_violation_report (type: esriFieldTypeString, alias: weed_violation_report, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• herbicide_app_recom (type: esriFieldTypeString, alias: herbicide_app_recom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• herbicide_app_recom_note (type: esriFieldTypeString, alias: herbicide_app_recom_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• veg_water_stressed (type: esriFieldTypeString, alias: veg_water_stressed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NotSure: Not Sure])
• veg_water_stressed_note (type: esriFieldTypeString, alias: veg_water_stressed_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• inspected_ir_sys (type: esriFieldTypeString, alias: inspected_ir_sys, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable])
• other_veg_notes (type: esriFieldTypeString, alias: other_veg_notes, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ir_method (type: esriFieldTypeString, alias: ir_method , SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [None: None], [Unsure: Unsure], [TreeDiaper: Tree diaper], ... 2 more ...)
• tree_diaper_replm (type: esriFieldTypeString, alias: tree_diaper_replm, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not Applicable: Not Applicable])
• tree_diaper_replm_note (type: esriFieldTypeString, alias: tree_diaper_replm_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ir_sys (type: esriFieldTypeString, alias: ir_sys, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unsure: Unsure], ... 1 more ...)
• ir_contl_box_note (type: esriFieldTypeString, alias: ir_contl_box_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ir_mx_needed (type: esriFieldTypeString, alias: ir_mx_needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Controller: Controller], [Wiring: Wiring], [BackflowPreventer: Backflow preventer], ... 5 more ...)
• ir_sys_repair (type: esriFieldTypeString, alias: ir_sys_repair, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Controller: Controller], [Wiring: Wiring], [BackflowPreventer: Backflow preventer], ... 5 more ...)
• ir_sys_timing_adj (type: esriFieldTypeString, alias: ir_sys_timing_adj, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Perfomed: Perfomed], [Needed: Needed], [NotRequired: Not Required])
• ir_sys_timing_adj_note (type: esriFieldTypeString, alias: ir_sys_timing_adj_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• cistern_harvesting_tnk (type: esriFieldTypeString, alias: cistern_harvesting_tnk , SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NotSure: Not Sure])
• cistern_repair_needed (type: esriFieldTypeString, alias: cistern_repair_needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CisternBody: Cistern body], [Lid: Lid], [Gutter: Gutter], ... 7 more ...)
• water_harvesting_note (type: esriFieldTypeString, alias: water_harvesting_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• gsi_signage (type: esriFieldTypeString, alias: gsi_signage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• deter_unauth_work (type: esriFieldTypeString, alias: deter_unauth_work, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• signage_replm (type: esriFieldTypeString, alias: signage_replm, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Performed: Performed], [Needed: Needed], [NotNeeded: Not Needed])
• signage_note (type: esriFieldTypeString, alias: signage_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• non_signage_replm (type: esriFieldTypeString, alias: non_signage_replm, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• non_signage_replm_note (type: esriFieldTypeString, alias: non_signage_replm_note, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_copy (type: esriFieldTypeString, alias: created_user_copy, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• created_date_copy (type: esriFieldTypeDate, alias: created_date_copy, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user_copy (type: esriFieldTypeString, alias: last_edited_user_copy, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• last_edited_date_copy (type: esriFieldTypeDate, alias: last_edited_date_copy, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Temp_UniqueID (type: esriFieldTypeString, alias: Temp_UniqueID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)

Templates:

Name: GSI_ASSET_MAINTENANCE_WORK_Checklist
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (0) -- Related To: GSI_ASSET_INVENTORY (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/18/2023 7:59:42 PM

Schema Last Edit Date: 8/1/2023 5:09:05 PM

Data Last Edit Date: 8/18/2023 7:59:42 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