Name: UniversalWasteHandlersOfElectronicDevicesInspectionDetailsView

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Universal Waste Handlers of Electronic Devices, CRTs & CRT Glass Checklist","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Time Info:

Start Time Field: inspector_sig_date
End Time Field: null
Track ID Field: null
Time Extent
[4/28/2022 6:39:00 PM UTC, 7/18/2024 7:09:00 PM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• uwed_fac_id (type: esriFieldTypeString, alias: UWED Facility ID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_name (type: esriFieldTypeString, alias: Universal Waste Handler Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unlisted_iwed_id (type: esriFieldTypeString, alias: Enter Unlisted UWED ID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• identification_number (type: esriFieldTypeString, alias: EPA Identification Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_type (type: esriFieldTypeString, alias: Universal Waste Handler Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: Handler/Collector], [R: Treatment/Recycler])
• notification_date (type: esriFieldTypeString, alias: Notification Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_annual_submittal (type: esriFieldTypeString, alias: Last Annual Submittal Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_address (type: esriFieldTypeString, alias: Universal Waste Handler Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_zip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mailingaddressdifferent (type: esriFieldTypeString, alias: Is there an alternate mailing address?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alt_uw_handler_address (type: esriFieldTypeString, alias: Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alt_uw_handler_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alt_uw_handler_zip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hwemployees (type: esriFieldTypeInteger, alias: Number of Employees Handling Hazardous Waste, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Employees (type: esriFieldTypeInteger, alias: Number of Employees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lat (type: esriFieldTypeString, alias: lat, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lon (type: esriFieldTypeString, alias: lon, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CESPercentile (type: esriFieldTypeDouble, alias: CalEnviroScreen Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inspectiontype (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Compliance Evaluation Inspection: Compliance Evaluation Inspection], [Complaint: Complaint], [Facility Self Disclosure: Facility Self Disclosure], ... 4 more ...)
• complaint_casenumber (type: esriFieldTypeString, alias: Complaint Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owneroperator_name (type: esriFieldTypeString, alias: Owner/Operator Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owneroperator_title (type: esriFieldTypeString, alias: Owner/Operator Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owneroperator_email (type: esriFieldTypeString, alias: Owner/Operator Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owneroperator_identitytype (type: esriFieldTypeString, alias: Owner/Operator Identification Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Passport: Passport], [Drivers License: Drivers License], [Business Card: Business Card], ... 2 more ...)
• telephone_number (type: esriFieldTypeString, alias: Telephone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• insp_hist_yn (type: esriFieldTypeString, alias: Has this facility has been inspected before?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• inspector_name1 (type: esriFieldTypeString, alias: Lead Inspector's Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector1_title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector1_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector_name2 (type: esriFieldTypeString, alias: Backup Inspector's Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector2_title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector2_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dtsc_office (type: esriFieldTypeString, alias: Primary DTSC Office, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Headquarters: Headquarters], [Berkeley: Berkeley], [Clovis: Clovis], ... 6 more ...)
• office_address (type: esriFieldTypeString, alias: Office Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_city (type: esriFieldTypeString, alias: Office City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• office_zip (type: esriFieldTypeString, alias: Office Zipcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• otherreps (type: esriFieldTypeString, alias: Other Inspectors Participating in the Inspection (List Name, Title, and date(s) attended), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comments_observations (type: esriFieldTypeString, alias: Comments & Observations, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• disc_op (type: esriFieldTypeString, alias: Discussion with Operator, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• concern_yesno (type: esriFieldTypeInteger, alias: concern_yesno, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notcorrected_count (type: esriFieldTypeInteger, alias: notcorrected_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• corrected_count (type: esriFieldTypeInteger, alias: corrected_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• minor_count (type: esriFieldTypeInteger, alias: minor_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nonminor_count (type: esriFieldTypeInteger, alias: nonminor_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• uw_handler_rep_name (type: esriFieldTypeString, alias: Universal Waste Handler Representative Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_rep_title (type: esriFieldTypeString, alias: Universal Waste Handler Representative Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_rep_email (type: esriFieldTypeString, alias: Universal Waste Handler Representative Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_sig_date (type: esriFieldTypeDate, alias: Universal Waste Handler Signature Date/Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• uw_handler_sig_adjdate (type: esriFieldTypeString, alias: uw_handler_sig_adjdate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector_sig_date (type: esriFieldTypeDate, alias: DTSC Lead Inspector Signature Date/Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector_sig_adjdate (type: esriFieldTypeString, alias: inspector_sig_adjdate, 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)
• globalid_1701893958256 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• consentlang (type: esriFieldTypeString, alias: Pursuant to Health and Safety Code 25185, consent to perform an inspection includes, but is not limited to: conducting a walkthrough of the facility, inspecting hazardous waste handling areas and vehicles, interviewing personnel, taking photographs, sampling, document review, and retaining copies of documents., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• consent_name (type: esriFieldTypeString, alias: Consent to Inspect Granted by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• consent_title (type: esriFieldTypeString, alias: Title:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• consent_email (type: esriFieldTypeString, alias: Email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspection_timein (type: esriFieldTypeDate, alias: Date and Time In:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adj_timein (type: esriFieldTypeString, alias: adj_timein, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• datein (type: esriFieldTypeString, alias: datein, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspection_timeout (type: esriFieldTypeDate, alias: Date and Time Out:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adj_timeout (type: esriFieldTypeString, alias: adj_timeout, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateout (type: esriFieldTypeString, alias: dateout, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1701893958256 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1701893958256 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1701893958256 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1701893958256 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/26/2025 1:45:19 AM

Schema Last Edit Date: 12/1/2023 8:08:32 PM

Data Last Edit Date: 12/1/2023 8:08:32 PM

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