Name: JoinTreesToMaintenance1MKeepRecent-Prune

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2485322.03036797
YMin: 363555.720674306
XMax: 2509406.12557238
YMax: 381703.694876984
Spatial Reference: 2930 (2930)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,129,189,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[54,93,141,255],"width":1}}}}

HasZ: false

HasM: false

Has Attachments: false

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: sqlTypeInteger, length: 0, nullable: false, editable: false)
• NewAssetID (type: esriFieldTypeString, alias: AssetWorks_ID, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• AW_OLD (type: esriFieldTypeString, alias: AW_OLD, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Asset_Category (type: esriFieldTypeString, alias: Asset Category, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Known_As (type: esriFieldTypeString, alias: Known As, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Common_Name (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Botanical_Name (type: esriFieldTypeString, alias: Botanical Name, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Site (type: esriFieldTypeInteger, alias: Site, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• DBH (type: esriFieldTypeDouble, alias: DBH, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• WU (type: esriFieldTypeInteger, alias: WU, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• On_Street (type: esriFieldTypeString, alias: On Street?, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Marked_for_Planting (type: esriFieldTypeString, alias: Marked for Planting, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Season (type: esriFieldTypeString, alias: Season, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• HL_Ticket (type: esriFieldTypeString, alias: HL Ticket, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• HL_Status (type: esriFieldTypeString, alias: HL Status, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• HL_Cleared_Date (type: esriFieldTypeDate, alias: HL Cleared Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Plant_Date (type: esriFieldTypeDate, alias: Plant Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Staked (type: esriFieldTypeString, alias: Staked, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Re_Staked (type: esriFieldTypeDate, alias: Re Staked Date?, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Water_Bag (type: esriFieldTypeString, alias: Water Bag, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Fund_Code (type: esriFieldTypeString, alias: Fund Code, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Fund__ (type: esriFieldTypeString, alias: Fund #, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Cycle (type: esriFieldTypeString, alias: Cycle, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Location_Comments (type: esriFieldTypeString, alias: Location Comments, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Grow_Size_Inches (type: esriFieldTypeInteger, alias: Grow Size Inches, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GST_Desc (type: esriFieldTypeString, alias: GST Desc, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Wires_OH (type: esriFieldTypeString, alias: Wires OH, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Wires_Adj (type: esriFieldTypeString, alias: Wires Adj, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Preferred_Species (type: esriFieldTypeString, alias: Preferred Species, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Tree_Format (type: esriFieldTypeString, alias: Tree Format, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Vendor (type: esriFieldTypeString, alias: Vendor, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Value (type: esriFieldTypeInteger, alias: Value, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitute, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Northing (type: esriFieldTypeString, alias: Northing, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Easting (type: esriFieldTypeString, alias: Easting, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 16, nullable: false, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• AW_OLD_1 (type: esriFieldTypeString, alias: AW_OLD 1, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Maintenance_Type (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Date_Performed (type: esriFieldTypeDate, alias: Date Performed, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Date_Requested (type: esriFieldTypeDate, alias: Date Requested, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Reason_for_Prune (type: esriFieldTypeString, alias: Reason for Prune, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Type_of_Pruning (type: esriFieldTypeString, alias: Type of Pruning, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Pruning_Comments (type: esriFieldTypeString, alias: Pruning Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Marked_Date (type: esriFieldTypeDate, alias: Marked for Removal Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Reason (type: esriFieldTypeString, alias: Reason, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Removed (type: esriFieldTypeString, alias: Removed, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Pulled (type: esriFieldTypeString, alias: Pulled, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Topped (type: esriFieldTypeString, alias: Topped, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Removal_Comments (type: esriFieldTypeString, alias: Removal Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Stumped_Date (type: esriFieldTypeDate, alias: Stumped Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Pickup_Date (type: esriFieldTypeDate, alias: Pickup Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Vac_All_Date (type: esriFieldTypeDate, alias: Vac-All Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Backfill_Date (type: esriFieldTypeDate, alias: Backfill Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Seed_Date (type: esriFieldTypeDate, alias: Seed Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Stump_Comments (type: esriFieldTypeString, alias: Stump Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Chemical (type: esriFieldTypeString, alias: Chemical, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Amount (type: esriFieldTypeInteger, alias: Amount, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Equipment_Type (type: esriFieldTypeString, alias: Equipment Type, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• F__of_injection_sites (type: esriFieldTypeInteger, alias: # of injection sites, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Port_Size (type: esriFieldTypeInteger, alias: Port Size, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Chemical_Comments (type: esriFieldTypeString, alias: Chemical Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Crack_Length (type: esriFieldTypeInteger, alias: Crack Length, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Crack_Depth_1 (type: esriFieldTypeInteger, alias: Crack Depth 1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Crack_Depth_2 (type: esriFieldTypeInteger, alias: Crack Depth 2, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Crack_Depth_3 (type: esriFieldTypeInteger, alias: Crack Depth 3, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• w__Decay (type: esriFieldTypeString, alias: w/ Decay, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• w__Crotch (type: esriFieldTypeString, alias: w/ Crotch, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Crack_Check_Comments (type: esriFieldTypeString, alias: Crack Check Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Wound_Comments (type: esriFieldTypeString, alias: Wound Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Stakes (type: esriFieldTypeString, alias: Stakes, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Mulched (type: esriFieldTypeString, alias: Mulched, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Watered (type: esriFieldTypeString, alias: Watered, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Pick_up_Type (type: esriFieldTypeString, alias: Pick up Type, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Area_Affected (type: esriFieldTypeString, alias: Area Affected, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Pick_up_Comments (type: esriFieldTypeString, alias: Pick up Comments, SQL Type: sqlTypeNVarchar, length: 225, nullable: true, editable: true)
• Width_Inches (type: esriFieldTypeInteger, alias: Width (In.), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Height_Inches (type: esriFieldTypeInteger, alias: Height (In.), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Training (type: esriFieldTypeString, alias: Training, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Picked_Up (type: esriFieldTypeString, alias: Picked Up?, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Marked_For_Plant (type: esriFieldTypeString, alias: Marked For Planting?, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Tree_Planted (type: esriFieldTypeString, alias: Tree Planted?, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• GlobalID_1 (type: esriFieldTypeGUID, alias: GlobalID 1, SQL Type: sqlTypeGUID, length: 16, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate 1, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Creator_1 (type: esriFieldTypeString, alias: Creator 1, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate 1, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Editor_1 (type: esriFieldTypeString, alias: Editor 1, SQL Type: sqlTypeNVarchar, length: 128, nullable: true, editable: true)
• Topped_Date (type: esriFieldTypeDate, alias: Date Topped, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Pulled_Date (type: esriFieldTypeDate, alias: Date Pulled, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Removed_Date (type: esriFieldTypeDate, alias: Date Removed, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• ResidentNotifiedDate (type: esriFieldTypeDate, alias: ResidentNotifiedDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• HoleDugDate (type: esriFieldTypeDate, alias: HoleDugDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• CrewName (type: esriFieldTypeString, alias: CrewName, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• GlobalID: {{00000000-0000-0000-0000-000000000000}}

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/27/2024 7:35:02 PM

Schema Last Edit Date: 11/2/2023 3:25:07 PM

Data Last Edit Date: 6/27/2024 7:35:02 PM

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