Name: ElDoradoCounty_HHWAssessment

Display Field: TeamName

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:

• ParentAPN (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SiteAddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DateTime_QA (type: esriFieldTypeDate, alias: Date and Time of Assessment, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateTime_QA_formatted (type: esriFieldTypeString, alias: DateTime_QA_formatted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Branch (type: esriFieldTypeString, alias: Branch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TeamName (type: esriFieldTypeString, alias: Team Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TeamLead (type: esriFieldTypeString, alias: Team Lead, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Organization (type: esriFieldTypeString, alias: Organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Exists (type: esriFieldTypeString, alias: Suspect ACM exists onsite? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Type (type: esriFieldTypeString, alias: Type of ACM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_TakeTooLong_YesNo (type: esriFieldTypeString, alias: Will the Removal of all ACM take more than 30 minutes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Removed_YesNo (type: esriFieldTypeString, alias: ACM Removed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Quantity_SqFt (type: esriFieldTypeInteger, alias: Lump sum of ACM removed (Square Feet) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asbestos_Quantity_LinearFt (type: esriFieldTypeSmallInteger, alias: Lump sum of ACM removed (Linear Feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asbestos_LeftOnsite_YesNo (type: esriFieldTypeString, alias: Suspect ACM left on site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_LeftOnsite_Type (type: esriFieldTypeString, alias: Type of ACM Left On Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Comments (type: esriFieldTypeString, alias: Suspect ACM Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HHW_Exists_YesNo (type: esriFieldTypeString, alias: HHW exists onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_AllTypesFound (type: esriFieldTypeString, alias: HHW Types Found, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_Aerosols_Count (type: esriFieldTypeInteger, alias: Aerosol (cans) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Antifreeze_Count (type: esriFieldTypeInteger, alias: Antifreeze (bottles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_BatteryMixed_Count (type: esriFieldTypeInteger, alias: Mixed batteries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_BatteryArray_YesNo (type: esriFieldTypeString, alias: Battery Array, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_Fuel_Gal (type: esriFieldTypeInteger, alias: Fuel/Diesel/Gasoline (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_FuelTanks_Count (type: esriFieldTypeInteger, alias: Fuel Tanks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_BulkOil_Gal (type: esriFieldTypeInteger, alias: Bulk Oil (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_GasCylinder_Types (type: esriFieldTypeString, alias: Compressed Gas Cylinder Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_AcetyleneHigh_Count (type: esriFieldTypeSmallInteger, alias: Acetylene/High Pressure Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_PropaneTanks_Count (type: esriFieldTypeSmallInteger, alias: Propane Cylinders , SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_PropaneTanks_Devalved (type: esriFieldTypeSmallInteger, alias: Number of Propane Cylinders - Devalved & Left On-Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_OtherCylinders_Count (type: esriFieldTypeSmallInteger, alias: Other Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_OtherCylinders_Devalved (type: esriFieldTypeSmallInteger, alias: Number of Other Cylinders - Devalved & Left On-Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Fertilizers_Count (type: esriFieldTypeInteger, alias: Fertilizers (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_HouseholdCleaners_Count (type: esriFieldTypeInteger, alias: Household Cleaners (Bottles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_LightBallasts_Count (type: esriFieldTypeInteger, alias: Light Ballasts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Paint_Count (type: esriFieldTypeInteger, alias: Paint (Buckets/Cans), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Pesticides_Count (type: esriFieldTypeInteger, alias: Pesticides (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_PoolChemicals_Count (type: esriFieldTypeInteger, alias: Pool Chemicals (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Solvents_Count (type: esriFieldTypeInteger, alias: Solvents (containers), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HHW_Other_Types (type: esriFieldTypeString, alias: Other HHW Type , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HHW_LeftOnsite_YesNo (type: esriFieldTypeString, alias: HHW Left Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_Comments (type: esriFieldTypeString, alias: HHW Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HHW_EWasteOnsite_YesNo (type: esriFieldTypeString, alias: E-waste Collected Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_TransferInPlace_YesNo (type: esriFieldTypeString, alias: Transfer in Place Conducted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HHW_EmptysLeftOnsite_YesNo (type: esriFieldTypeString, alias: Empty containers identified and marked with white paint(x)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeakingTransformer_YesNo (type: esriFieldTypeString, alias: Leaking Transformer identified and marked with orange paint(x)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ammo_LeftOnsite_YesNo (type: esriFieldTypeString, alias: Ammunition Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ammo_Collected_YesNo (type: esriFieldTypeString, alias: Was Ammunition Collected?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ammo_Collected_Count (type: esriFieldTypeString, alias: Amount Collected:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ammo_LeftGreater50Cal (type: esriFieldTypeString, alias: Is there ammunition greater than 50 Cal present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ammonote (type: esriFieldTypeString, alias: If larger than 50 Cal, leave in place! Contact Branch Director AND Check yes on Revisit Question Below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TankGreater100Gal_LeftOnsite (type: esriFieldTypeString, alias: Is there a large propane tank (>100 gallons) onsite? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• largenote (type: esriFieldTypeString, alias: If leaking contact propane supplier., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ChimneyOnsite_YesNo (type: esriFieldTypeString, alias: Chimney onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HealthSafetyIssue_YesNo (type: esriFieldTypeString, alias: Health and safety issue identified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HealthSafetyIssue_Comments (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Revisit_YesNo (type: esriFieldTypeString, alias: Is a revisit required for additional EPA Operations? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RevisitType (type: esriFieldTypeString, alias: Pick reason(s) for a revisit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RevisitReasons (type: esriFieldTypeString, alias: Additional Comments for Revisit, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HazardPreventAssess_YesNo (type: esriFieldTypeString, alias: Did a Physical obstacle prevent full HHW assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HazardPreventAssess_Comment (type: esriFieldTypeString, alias: Physical Obstacle Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Assessment_OtherNotes (type: esriFieldTypeString, alias: Assessment Notes:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• SignPlaced_YesNo (type: esriFieldTypeString, alias: Sign Placed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• DateTime_OnSite (type: esriFieldTypeDate, alias: Date and Time Submission, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Version (type: esriFieldTypeString, alias: Version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: HHWAssessment
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• ElDorado_OperationalStatus_15Min (0) -- Related To: ELDoradoOperationalAssessmentStatus_15MIN (34)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2022 3:28:23 PM

Schema Last Edit Date: 7/19/2022 3:28:23 PM

Data Last Edit Date: 7/19/2022 3:28:23 PM

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