Layers:

Layer: TSDInspectionDateDetailsView (0)


Name: TSDInspectionDateDetailsView

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

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":"TSD Inspection 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
[3/29/2022 10:10:00 PM UTC, 7/12/2024 1:23:00 AM 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)
• identification_number (type: esriFieldTypeString, alias: EPA Identification Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cal_env (type: esriFieldTypeString, alias: cal_env, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unlisted_epaid (type: esriFieldTypeString, alias: Enter Unlisted EPAID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDname (type: esriFieldTypeString, alias: Facility Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• permit (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• permitstatus (type: esriFieldTypeString, alias: Permit Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• expire (type: esriFieldTypeString, alias: Permit Expration Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDaddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDcity (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDzip (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)
• TSDBusiness_Type (type: esriFieldTypeString, alias: Business Type, SQL Type: sqlTypeOther, length: 255, 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 4.0 Score, SQL Type: sqlTypeOther, 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])
• altTSDaddress (type: esriFieldTypeString, alias: Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• altTSDcity (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• altTSDzip (type: esriFieldTypeString, alias: Zip Code, 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)
• 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 ...)
• workplantype (type: esriFieldTypeString, alias: Workplan Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Treatment, Storage, and Disposal: Treatment, Storage, and Disposal], [Treatment, Storage, and Disposal - Used Oil Recycler: Treatment, Storage, and Disposal - Used Oil Recycler], [Standardized Permit: Standardized Permit], ... 4 more ...)
• complaint_casenumber (type: esriFieldTypeString, alias: Complaint Case 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 Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• otherinspector (type: esriFieldTypeString, alias: Other Inspectors Participating in the Inspection (List their name(s), title(s), and date(s) attended), SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• sample_coll (type: esriFieldTypeString, alias: Were Samples Collected during the Inspection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• no_samples (type: esriFieldTypeString, alias: Number of Samples Taken, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• additional_info (type: esriFieldTypeString, alias: Additional Information, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• disc_op (type: esriFieldTypeString, alias: Discussion with Facility Representative, 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)
• TSDrep_name (type: esriFieldTypeString, alias: TSD Representative Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDrep_title (type: esriFieldTypeString, alias: TSD Representative Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSDrep_email (type: esriFieldTypeString, alias: TSD Representative Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSD_sig_date (type: esriFieldTypeDate, alias: Transporter Signature Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector_sig_date (type: esriFieldTypeDate, alias: Inspector Signature Date, 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)
• TSD_sig_adjdate (type: esriFieldTypeString, alias: TSD_sig_adjdate, 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)
• globalid_1701894719296 (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)
• 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)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1701894719296 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1701894719296 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1701894719296 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1701894719296 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• datein (type: esriFieldTypeString, alias: datein, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dateout (type: esriFieldTypeString, alias: dateout, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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: 12/18/2024 8:37:26 PM

Schema Last Edit Date: 12/5/2023 8:55:36 PM

Data Last Edit Date: 12/5/2023 8:55:36 PM