Name: Treatments

Display Field:

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

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

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• TreatmentAreaDescription (type: esriFieldTypeString, alias: Treatment area description:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TargetPestCategories (type: esriFieldTypeString, alias: Target pest category:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Habitat_Restoration: Habitat Restoration], [Indoor_Pest: Indoor Pest (Non-Rodent)], [Landscape_Insect: Landscape Insect], ... 4 more ...)
• TargetPestOther (type: esriFieldTypeString, alias: Specify other target pest category:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TargetPestNotes (type: esriFieldTypeString, alias: Target pest notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ApplicationMethod (type: esriFieldTypeString, alias: Application method:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Spot: Spot], [Broadcast: Broadcast], [Circle_Spray: Circle Spray], ... 8 more ...)
• ApplicationMethodOther (type: esriFieldTypeString, alias: Specify other application method:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ApplicationEquipment (type: esriFieldTypeString, alias: Application equipment:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ApplicationEquipmentOther (type: esriFieldTypeString, alias: Specify other application equipment:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• areaTreated (type: esriFieldTypeDouble, alias: Area treated:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AreaTreatedUOM (type: esriFieldTypeString, alias: Area treated units:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Acres: Acres], [Hectares: Hectares], [Linear_Feet: Linear Feet], ... 1 more ...)
• HasAquaticArea (type: esriFieldTypeString, alias: Was any part of treatment area aquatic?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• PercentAquaticArea (type: esriFieldTypeDouble, alias: What % of total area was aquatic?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProductTotalMixUsed (type: esriFieldTypeDouble, alias: Total mix used:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProductTotalMixUsedUOM (type: esriFieldTypeString, alias: Tank \ bottle units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons])
• Adjuvant1Name (type: esriFieldTypeString, alias: Adjuvant 1 name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Agri-Dex: Agri-Dex], [BroncMax: BroncMax], [Class_Act_NG: Class Act NG], ... 12 more ...)
• Adjuvant1NameOther (type: esriFieldTypeString, alias: Specify other adjuvant 1 name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Adjuvant1Amount (type: esriFieldTypeDouble, alias: Adjuvant 1 amount used:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adjuvant1AmountUOM (type: esriFieldTypeString, alias: Adjuvant 1 units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 1 more ...)
• Adjuvant2Name (type: esriFieldTypeString, alias: Adjuvant 2 name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Agri-Dex: Agri-Dex], [BroncMax: BroncMax], [Class_Act_NG: Class Act NG], ... 12 more ...)
• Adjuvant2NameOther (type: esriFieldTypeString, alias: Specify other adjuvant 2 name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Adjuvant2Amount (type: esriFieldTypeDouble, alias: Adjuvant 2 amount used:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Adjuvant2AmountUOM (type: esriFieldTypeString, alias: Adjuvant 2 units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 1 more ...)
• IndicatorDyeName (type: esriFieldTypeString, alias: Indicator dye / foam name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Dynamark_Blue_Dye: Dynamark Blue Dye], [Hi-Light: Hi-Light], [Mark-it_Blue_Dye: Mark-it Blue Dye], ... 3 more ...)
• IndicatorDyeNameOther (type: esriFieldTypeString, alias: Specify other indicator dye name:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IndicatorDyeAmount (type: esriFieldTypeDouble, alias: Indicator dye / foam amount used:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IndicatorDyeAmountUOM (type: esriFieldTypeString, alias: Indicator dye / foam units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 1 more ...)
• Product1NameEpaNumber (type: esriFieldTypeString, alias: Product 1 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [26/36_Fungicide_228-630: 26/36 Fungicide 228-630], [3336_F_1001-69: 3336 F 1001-69], [70%_Neem_Oil_70051-2-54705: 70% Neem Oil 70051-2-54705], ... 119 more ...)
• Product1NameEpaNumberOther (type: esriFieldTypeString, alias: Specify other Product 1 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Product1AmountApplied (type: esriFieldTypeDouble, alias: Product 1 amount applied:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product1AmountAppliedUOM (type: esriFieldTypeString, alias: Product 1 units:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 4 more ...)
• Product1CalcMethod (type: esriFieldTypeString, alias: Product 1 calculation method:, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true, Coded Values: [Concentration: Concentration], [Rate: Rate])
• Product1Concentration (type: esriFieldTypeDouble, alias: Product 1 concentration (%):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product1Rate (type: esriFieldTypeDouble, alias: Product 1 rate:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product1RateUnits (type: esriFieldTypeString, alias: Product 1 rate units:, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true, Coded Values: [fl_oz_per_acre: Fl. Oz. / Acre], [fl_oz_per_gallon: Fl. Oz. / Gallon], [fl_oz_per_1000_sq_ft: Fl. Oz. / 1000 sq ft], ... 7 more ...)
• Product1Supplier (type: esriFieldTypeString, alias: Select Product 1 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Cardinal_Products_Anaheim_CA: Cardinal Products, Anaheim CA], [Coastal_Farm_Ranch_Woodburn_OR: Coastal Farm and Ranch, Woodburn OR], [Coastal_Farm_Supply_Gresham_OR: Coastal Farm and Supply, Gresham OR], ... 20 more ...)
• Product1SupplierOther (type: esriFieldTypeString, alias: Specify other Product 1 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Product2NameEpaNumber (type: esriFieldTypeString, alias: Product 2 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [26/36_Fungicide_228-630: 26/36 Fungicide 228-630], [3336_F_1001-69: 3336 F 1001-69], [70%_Neem_Oil_70051-2-54705: 70% Neem Oil 70051-2-54705], ... 119 more ...)
• Product2NameEpaNumberOther (type: esriFieldTypeString, alias: Specify other Product 2 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Product2AmountApplied (type: esriFieldTypeDouble, alias: Product 2 amount applied:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product2AmountAppliedUOM (type: esriFieldTypeString, alias: Product 2 units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 4 more ...)
• Product2CalcMethod (type: esriFieldTypeString, alias: Product 2 calculation method:, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true, Coded Values: [Concentration: Concentration], [Rate: Rate])
• Product2Concentration (type: esriFieldTypeDouble, alias: Product 2 concentration (%):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product2Rate (type: esriFieldTypeDouble, alias: Product 2 rate:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product2RateUnits (type: esriFieldTypeString, alias: Product 2 rate units:, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true, Coded Values: [fl_oz_per_acre: Fl. Oz. / Acre], [fl_oz_per_gallon: Fl. Oz. / Gallon], [fl_oz_per_1000_sq_ft: Fl. Oz. / 1000 sq ft], ... 7 more ...)
• Product2Supplier (type: esriFieldTypeString, alias: Product 2 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Cardinal_Products_Anaheim_CA: Cardinal Products, Anaheim CA], [Coastal_Farm_Ranch_Woodburn_OR: Coastal Farm and Ranch, Woodburn OR], [Coastal_Farm_Supply_Gresham_OR: Coastal Farm and Supply, Gresham OR], ... 20 more ...)
• Product2SupplierOther (type: esriFieldTypeString, alias: Specify other Product 2 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Product3NameEpaNumber (type: esriFieldTypeString, alias: Product 3 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [26/36_Fungicide_228-630: 26/36 Fungicide 228-630], [3336_F_1001-69: 3336 F 1001-69], [70%_Neem_Oil_70051-2-54705: 70% Neem Oil 70051-2-54705], ... 119 more ...)
• Product3NameEpaNumberOther (type: esriFieldTypeString, alias: Specify other Product 3 name & EPA number:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Product3AmountApplied (type: esriFieldTypeDouble, alias: Product 3 amount applied:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product3AmountAppliedUOM (type: esriFieldTypeString, alias: Product 3 units:, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Fluid_Ounces: Fluid Ounces], [Gallons: Gallons], [Grams: Grams], ... 4 more ...)
• Product3CalcMethod (type: esriFieldTypeString, alias: Product 3 calculation method:, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true, Coded Values: [Concentration: Concentration], [Rate: Rate])
• Product3Concentration (type: esriFieldTypeDouble, alias: Product 3 concentration (%):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product3Rate (type: esriFieldTypeDouble, alias: Product 3 rate:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Product3RateUnits (type: esriFieldTypeString, alias: Product 3 rate units:, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true, Coded Values: [fl_oz_per_acre: Fl. Oz. / Acre], [fl_oz_per_gallon: Fl. Oz. / Gallon], [fl_oz_per_1000_sq_ft: Fl. Oz. / 1000 sq ft], ... 7 more ...)
• Product3Supplier (type: esriFieldTypeString, alias: Product 3 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Cardinal_Products_Anaheim_CA: Cardinal Products, Anaheim CA], [Coastal_Farm_Ranch_Woodburn_OR: Coastal Farm and Ranch, Woodburn OR], [Coastal_Farm_Supply_Gresham_OR: Coastal Farm and Supply, Gresham OR], ... 20 more ...)
• Product3SupplierOther (type: esriFieldTypeString, alias: Specify other Product 3 supplier:, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, 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: 50, nullable: true, editable: false)
• TargetPestSubCategory (type: esriFieldTypeString, alias: Target pest subcategory:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TreatmentNotes (type: esriFieldTypeString, alias: General treatment notes:, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• TreesInjectedCount (type: esriFieldTypeInteger, alias: Number of trees injected:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AvgTreeDiameterDBHInches (type: esriFieldTypeDouble, alias: Average tree diameter (DBH) (inches):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AvgNumberInjectionSitesPerTree (type: esriFieldTypeDouble, alias: Average number of injection sites:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BurrowsInjectedCount (type: esriFieldTypeInteger, alias: Number of burrows injected:, SQL Type: sqlTypeOther, nullable: true, editable: true)

Relationships:

• Relationship_Treatments (1) -- Related To: Metro_IPM_PAR (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/11/2025 10:54:07 PM

Schema Last Edit Date: 4/11/2025 10:54:07 PM

Data Last Edit Date: 4/11/2025 10:54:07 PM

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