Name: WasteConsolidationSummary

Display Field: InventoryDate

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: 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: sqlTypeOther, length: 38, nullable: false, editable: false)
• Location_Name (type: esriFieldTypeString, alias: Location Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• InventoryDate (type: esriFieldTypeDate, alias: Date/Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InventoryDate_Formatted (type: esriFieldTypeString, alias: InventoryDate_Text, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AerosolNote (type: esriFieldTypeString, alias: AerosolNote, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Aerosol_CuYdBox_Count (type: esriFieldTypeSmallInteger, alias: Count of Cubic Yard Box (1 cubic yard), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aerosol_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (.27 cubic yards), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aerosol_Ttl_CuYds_All (type: esriFieldTypeDouble, alias: Aerosol_Ttl_CuYds_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BatteryNote (type: esriFieldTypeString, alias: BatteryNote, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Battery_Palette_Count (type: esriFieldTypeSmallInteger, alias: Count of Palettes (1.5 tons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Battery_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (.25 tons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Battery_Ttl_Tons_All (type: esriFieldTypeDouble, alias: Battery_Ttl_Tons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CylindersNote (type: esriFieldTypeString, alias: CylindersNote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cylinders_Count (type: esriFieldTypeSmallInteger, alias: Count of Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EWasteNote (type: esriFieldTypeString, alias: E-Waste, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EWaste_Container20_Count (type: esriFieldTypeSmallInteger, alias: Small Sea Container (20 ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• EWaste_Container40_Count (type: esriFieldTypeInteger, alias: Large Sea Container (40 ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• EWaste_Ttl_CuYds_All (type: esriFieldTypeDouble, alias: EWaste_Ttl_CuYds_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlLiquidsNote (type: esriFieldTypeString, alias: Flammable Liquids (gas, solvents, other), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FlLiquids_CuYdBox_Count (type: esriFieldTypeSmallInteger, alias: Count of Cubic Yard Box (200 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlLiquids_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (55 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlLiquids_Totes_Count (type: esriFieldTypeInteger, alias: Count of Totes (270 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlLiquids_Ttl_Gallons_All (type: esriFieldTypeDouble, alias: FlammableLiquids_Ttl_Gallons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PaintWasteNote (type: esriFieldTypeString, alias: Flammable Liquids (paint-related material), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PaintWaste_CuYdBox_Count (type: esriFieldTypeSmallInteger, alias: Count of Cubic Yard Box (200 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PaintWaste_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (55 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PaintWaste_Totes_Count (type: esriFieldTypeInteger, alias: Count of Totes (270 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PaintWaste_Ttl_Gallons_All (type: esriFieldTypeDouble, alias: PaintWaste_Ttl_Gallons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OilNote (type: esriFieldTypeString, alias: Oil, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Oil_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (55 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Totes_Count (type: esriFieldTypeInteger, alias: Count of Totes (270 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Ttl_Gallons_All (type: esriFieldTypeDouble, alias: Oil_Ttl_Gallons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PesticideNote (type: esriFieldTypeString, alias: Pesticides, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pesticide_SteelDrum_Count (type: esriFieldTypeInteger, alias: Count of Steel Drum (55 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pesticide_Totes_Count (type: esriFieldTypeInteger, alias: Count of Totes (270 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pesticide_Ttl_Gallons_All (type: esriFieldTypeDouble, alias: Pesticides_Ttl_Gallons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FlourescNote (type: esriFieldTypeString, alias: FlourescNote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flouresc_CuYdBox_Count (type: esriFieldTypeSmallInteger, alias: Flouresc_CuYdBox_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flouresc_SteelDrum_Count (type: esriFieldTypeInteger, alias: Flouresc_SteelDrum_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Flouresc_Ttl_CuYds_All (type: esriFieldTypeDouble, alias: Flouresc_Ttl_CuYds_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aerosol_Units (type: esriFieldTypeString, alias: Aerosol_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Battery_Units (type: esriFieldTypeString, alias: Battery_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Cylinders_Units (type: esriFieldTypeString, alias: Cylinders_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• EWaste_Units (type: esriFieldTypeString, alias: EWaste_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FlLiquids_Units (type: esriFieldTypeString, alias: FlLiquids_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PaintWaste_Units (type: esriFieldTypeString, alias: PaintWaste_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Oil_Units (type: esriFieldTypeString, alias: Oil_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Pesticide_Units (type: esriFieldTypeString, alias: Pesticide_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Flouresc_Units (type: esriFieldTypeString, alias: Flouresc_Units, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Fluoresc_Ttl_Pounds_Drums (type: esriFieldTypeDouble, alias: Fluoresc_Ttl_Pounds_Drums, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fluoresc_Ttl_Pounds_All (type: esriFieldTypeDouble, alias: Fluoresc_Ttl_Pounds_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fluoresc_Ttl_Pounds_All_Txt (type: esriFieldTypeString, alias: Fluoresc_Ttl_Pounds_All_Txt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OilNote1 (type: esriFieldTypeString, alias: Oil, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Oil_SteelDrum_Count1 (type: esriFieldTypeInteger, alias: Count of Steel Drum (55 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Ttl_Gallons_Drums (type: esriFieldTypeDouble, alias: Oil_Ttl_Gallons_Drums, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Totes_Count1 (type: esriFieldTypeInteger, alias: Count of Totes (270 gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Ttl_Gallons_Totes (type: esriFieldTypeDouble, alias: Oil_Ttl_Gallons_Totes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Ttl_Gallons_All1 (type: esriFieldTypeDouble, alias: Oil_Ttl_Gallons_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Ttl_Gallons_All_Txt (type: esriFieldTypeString, alias: Total Gallons (All), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Oil_Comment (type: esriFieldTypeString, alias: Oil Waste Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OilyDebrisNote (type: esriFieldTypeString, alias: OilyDebrisNote, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OilyDebris_CuYdBox_Count (type: esriFieldTypeSmallInteger, alias: OilyDebris_CuYdBox_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OilyDebris_Ttl_CuYds_Boxes (type: esriFieldTypeDouble, alias: OilyDebris_Ttl_CuYds_Boxes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OilyDebris_Ttl_CuYds_All (type: esriFieldTypeDouble, alias: OilyDebris_Ttl_CuYds_All, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OilyDebris_Ttl_CuYds_All_Txt (type: esriFieldTypeString, alias: OilyDebris_Ttl_CuYds_All_Txt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OilyDebris_Comment (type: esriFieldTypeString, alias: OilyDebris_Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OilyDebris_Units (type: esriFieldTypeString, alias: OilyDebris_Units, SQL Type: sqlTypeOther, length: 255, 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: 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)

Templates:

Name: WasteConsolidationSummary
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/12/2024 7:43:34 PM

Schema Last Edit Date: 1/12/2024 7:43:34 PM

Data Last Edit Date: 1/12/2024 7:43:34 PM

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