Name: Waste Generated Reports

Display Field: wa_num

Type: Table

Geometry Type: N/A

Description: Brevard County SQG Facilities Waste Generated Reports (Read Only View)

Service Item Id: 9b60cf1eaeb34437b4e6aab26f307b84

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• wa_num ( nullable: true, editable: true, defaultValue: null, length: 7, type: esriFieldTypeString, modelName: WA_NUM, alias: Facility ID )
• wa_seq ( nullable: true, editable: true, defaultValue: null, length: 3, type: esriFieldTypeString, modelName: WA_SEQ, alias: Waste ID )
• wa_wcode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_WCODE, alias: Waste Type (old) )
• wa_amt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_AMT, alias: Waste per Year (lbs) )
• wa_max ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_MAX, alias: HW Produced per Month (lbs) )
• ahw_monthly ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: AHW_Monthly, alias: Acute HW Produced per Month (lbs) )
• wa_scode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_SCODE, alias: Storage Method , Coded Values: [C1: C1 - 0-9 Gallon Container] , [C3: C3 - 10-39 Gallon Container] , [C5: C5 - 40 or More Gallon Container] , ...11 more... )
• wa_onoff ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_ONOFF, alias: Disposal Location , Coded Values: [O: On-Site] , [F: Off-Site] )
• wa_dcode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_DCODE, alias: Disposal Method , Coded Values: [AD: AD - Awaiting Disposal (planned)] , [AN: AN - Accumulation (no mangement plan)] , [AO: AO - Mixed w/Used Oil (VSQG)] , ...35 more... )
• wa_update ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: WA_UPDATE, alias: FDEP Last Edit Date )
• wa_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_TOTAL, alias: HW Produced per Year (lbs) )
• wa_qmgt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: WA_QMGT, alias: Questionable Management , Coded Values: [0: No] , [1: Disposal] , [10: Storage] , ...1 more... )
• wa_unit ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_UNIT, alias: Waste Units , Coded Values: [B: Barrel (35 gallon)] , [D: Drum (55 gallon)] , [G: Gallons] , ...6 more... )
• wa_annual ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WA_ANNUAL, alias: Units per Year )
• wa_month ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WA_MONTH, alias: Units per Month )
• hazardstatus ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: HazardStatus, alias: Hazardous Status , Coded Values: [A: Acute Hazardous] , [E: Exempt/Excluded] , [G: Regulated] , ...4 more... )
• wasteunitcode ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: WasteUnitCode, alias: Waste Unit Code )
• weightfactor ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WeightFactor, alias: Weight Factor )
• hauler ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: Hauler, alias: Hauler )
• wa_utype ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: WA_UTYPE, alias: FDEP Update Type )
• wa_comm ( nullable: true, editable: true, defaultValue: null, length: 78, type: esriFieldTypeString, modelName: WA_COMM, alias: Comments )
• wa_nwcode ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_NWCODE, alias: Waste Type , Coded Values: [AMEO: AMEO - Antifreeze (HW except when recycled)] , [AMNO: AMNO - Antifreeze (not HW)] , [BDEB: BDEB - Lead-acid Batteries] , ...72 more... )
• wa_cquest1 ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CQUEST1, alias: County Data 1 )
• wa_cquest2 ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CQUEST2, alias: County Data 2 )
• wa_ccode ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CCODE, alias: Character Code )
• wa_actrec ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_ACTREC, alias: Activity Record )
• wa_epa1 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA1, alias: EPA HW Code 1 )
• wa_epa2 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA2, alias: EPA HW Code 2 )
• wa_epa3 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA3, alias: EPA HW Code 3 )
• wa_epa4 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA4, alias: EPA HW Code 4 )
• wa_epa5 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA5, alias: EPA HW Code 5 )
• inspectionid_waste ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: InspectionID_Waste, alias: Inspection ID )
• inspectionguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: InspectionGUID, alias: Inspection GUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• fdepupdate_wa ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: fdepupdate_wa, alias: fdepupdate_wa )

Templates:

• Name: P2_WasteGenerated
  Description:
  Prototype:
  wa_epa5: null
  wa_epa2: null
  wa_num: null
  wa_epa1: null
  wa_epa4: null
  wa_amt: null
  hazardstatus: null
  wa_epa3: null
  wa_nwcode: null
  wa_update: null
  weightfactor: null
  wa_utype: null
  inspectionguid: null
  wa_actrec: null
  wa_total: null
  wa_comm: null
  inspectionid_waste: null
  wasteunitcode: null
  wa_cquest2: null
  wa_cquest1: null
  wa_unit: null
  wa_qmgt: null
  wa_dcode: null
  ahw_monthly: null
  wa_scode: null
  wa_annual: null
  wa_wcode: null
  wa_onoff: null
  fdepupdate_wa: null
  wa_month: null
  hauler: null
  wa_max: null
  wa_ccode: null
  wa_seq: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Inspections (3) -- Related To: Inspections (3)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata