Name: DixieFire2021.R9GISSDE.Dixie_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:

• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ParentAPN (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIte_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• datetime_QC (type: esriFieldTypeDate, alias: Date and Time of Assessment, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• datetime_QC_formatted (type: esriFieldTypeString, alias: datetime_QC_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, Coded Values: [A-1: A-1], [A-2: A-2], [A-3: A-3], ... 9 more ...)
• Team_Lead (type: esriFieldTypeString, alias: Team Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Organization (type: esriFieldTypeString, alias: Organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [EPAEmployee: EPA Employee], [START: START], [DTSC: DTSC], ... 2 more ...)
• asbestos_exists (type: esriFieldTypeString, alias: Suspect ACM exists onsite? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Asbestos_Type (type: esriFieldTypeString, alias: Type of Asbestos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• asbestos_removed (type: esriFieldTypeString, alias: ACM Removed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• asbestos_unit (type: esriFieldTypeString, alias: Quantity of ACM removed (Square Feet), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• asbestos_left_onsite (type: esriFieldTypeString, alias: Suspect ACM left on site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• asbestos_Rem_Activit (type: esriFieldTypeString, alias: Will the Removal of ACM onsite take more than two hours?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• asbestoscomments (type: esriFieldTypeString, alias: Suspect ACM Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• HHW_exists (type: esriFieldTypeString, alias: HHW exists onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SelectHHW (type: esriFieldTypeString, alias: HHW Types Found, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Aerosols_c (type: esriFieldTypeInteger, alias: Aerosol (cans) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• Antifreeze_c (type: esriFieldTypeInteger, alias: Antifreeze (bottles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MixedBattery_c (type: esriFieldTypeInteger, alias: Batteries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fuel_c (type: esriFieldTypeInteger, alias: Fuel/Diesel/Gasoline (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FuelTanks_c (type: esriFieldTypeInteger, alias: Fuel Tanks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oil_Water_c (type: esriFieldTypeInteger, alias: Bulk Oil (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• fueltanktypes (type: esriFieldTypeString, alias: Compressed Gas Cylinder Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acetylenetanks_c (type: esriFieldTypeSmallInteger, alias: Acetylene/High Pressure Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propanetanks_c (type: esriFieldTypeSmallInteger, alias: Propane Cylinders , SQL Type: sqlTypeOther, nullable: true, editable: true)
• propanetanks_devalved (type: esriFieldTypeSmallInteger, alias: Number of Propane Cylinders - Devalved & Left On-Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• othertanks_c (type: esriFieldTypeSmallInteger, alias: Other Cylinders, SQL Type: sqlTypeOther, nullable: true, editable: true)
• othertanks_devalved (type: esriFieldTypeSmallInteger, alias: Number of Other Cylinders - Devalved & Left On-Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fertilizers_c (type: esriFieldTypeInteger, alias: Fertilizers (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HouseholdCleaners_c (type: esriFieldTypeInteger, alias: Household Cleaners (Bottles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LightBallasts_c (type: esriFieldTypeInteger, alias: Light Ballasts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Paint_c (type: esriFieldTypeInteger, alias: Paint (Buckets/Cans), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pesticides_c (type: esriFieldTypeInteger, alias: Pesticides (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PoolChemicals_c (type: esriFieldTypeInteger, alias: Pool Chemicals (Containers/Bags), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Solvents_c (type: esriFieldTypeInteger, alias: Solvents (containers), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Other_c (type: esriFieldTypeString, alias: Other HHW Type , SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• hhw_onsite (type: esriFieldTypeString, alias: HHW Left Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hhwcomments (type: esriFieldTypeString, alias: HHW Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ewaste_onsite (type: esriFieldTypeString, alias: E-waste Collected Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• TransferinPlace (type: esriFieldTypeString, alias: Transfer in Place Conducted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• emptycontainers_left_onsite (type: esriFieldTypeString, alias: Empty containers identified and marked with white paint(x)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• leaking_transformer (type: esriFieldTypeString, alias: Leaking Transformer identified and marked with orange paint(x)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ammo_left_onsite (type: esriFieldTypeString, alias: Ammunition Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ammo_left_greater50 (type: esriFieldTypeString, alias: Is greater than 50 Cal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ammonote (type: esriFieldTypeString, alias: If larger than 50 Cal, leave in place AND contact Authorities, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LARGE_TANK_left_onsite (type: esriFieldTypeString, alias: Is there a large propane> (100 gallons) onsite? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Chimney_left_onsite (type: esriFieldTypeString, alias: Chimney onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Remnant_left_onsite (type: esriFieldTypeString, alias: Did a Physical obstacle prevent full HHW assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Remnant_desc (type: esriFieldTypeString, alias: Physical Obstacle Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HealthSafetyIssue (type: esriFieldTypeString, alias: Health and safety issue identified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• HealthSafetyIssue_desc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Revist_YesNo (type: esriFieldTypeString, alias: Is revisit required for additional Operations? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• RevisitType (type: esriFieldTypeString, alias: Pick a reason 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)
• othernotes (type: esriFieldTypeString, alias: Assessment Notes:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• datetimeonsite (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)
• 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)
• SpatialQC (type: esriFieldTypeString, alias: SpatialQC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Sign (type: esriFieldTypeString, alias: Sign Placed?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ammodetails (type: esriFieldTypeString, alias: ammodetails, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ammocollect (type: esriFieldTypeString, alias: Was Ammunition Collected?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ammo_c (type: esriFieldTypeString, alias: Amount Collected:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• largeonote (type: esriFieldTypeString, alias: If leaking contact propane supplier., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• asbestos_quantity_linear (type: esriFieldTypeSmallInteger, alias: asbestos_quantity_linear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asbestos_Type_Left (type: esriFieldTypeString, alias: Asbestos_Type_Left, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: DixieFire2021.R9GISSDE.Dixie_HHWAssessment
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• DixieFire2021.R9GISSDE.Plumas_OperationalAssessmentStatus_15Min (0) -- Related To: Plumas_OperationalAssessmentStatus_15MIN (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2022 6:58:55 PM

Schema Last Edit Date: 7/19/2022 6:58:55 PM

Data Last Edit Date: 7/19/2022 6:58:55 PM

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