Name: HazMat

Display Field: hm_chem_name

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• relate_id_hm (type: esriFieldTypeGUID, alias: relate_id, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• hm_chem_name (type: esriFieldTypeString, alias: Chemical Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• hm_chem_state (type: esriFieldTypeString, alias: Chemical State, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• hm_ph_explos (type: esriFieldTypeString, alias: Explosive, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_flamm (type: esriFieldTypeString, alias: Flammable (gases, aerosols, liquids, or solids), SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_ox (type: esriFieldTypeString, alias: Oxidizer (liquid, solid or gas), SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_selfrct (type: esriFieldTypeString, alias: Self-Reactive, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_pyroph (type: esriFieldTypeString, alias: Pyrophoric (liquid or solid), SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_pyrogas (type: esriFieldTypeString, alias: Pyrophoric Gas, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_slfheat (type: esriFieldTypeString, alias: Self-heating, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_orgperx (type: esriFieldTypeString, alias: Organic Peroxides, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_corrsiv (type: esriFieldTypeString, alias: Corrosive to metal, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_gaspres (type: esriFieldTypeString, alias: Gas under pressure (compressed gas), SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_emitgas (type: esriFieldTypeString, alias: In contact with water emits flammable gas, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_combdst (type: esriFieldTypeString, alias: Combustible Dust, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_ph_other (type: esriFieldTypeString, alias: Hazard Not Otherwise Classified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_hh_acutox (type: esriFieldTypeString, alias: Acute Toxicity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_skin (type: esriFieldTypeString, alias: Skin Corrosion or Irritation, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_eye (type: esriFieldTypeString, alias: Serious Eye Damage or Irritation, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_respir (type: esriFieldTypeString, alias: Respiratory or Skin Sensitization, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_germcel (type: esriFieldTypeString, alias: Germ cell mutagenicity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_carcin (type: esriFieldTypeString, alias: Combustible Dust, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_reprod (type: esriFieldTypeString, alias: Carcinogenicity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_organ (type: esriFieldTypeString, alias: Reproductive toxicity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_aspria (type: esriFieldTypeString, alias: Specific target organ toxicity(single or repeated exposure), SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_asphix (type: esriFieldTypeString, alias: Aspiration hazard, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_hh_other (type: esriFieldTypeString, alias: Simple Asphyxiant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_inv_max (type: esriFieldTypeInteger, alias: Maximum Amount (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• hm_inv_min (type: esriFieldTypeInteger, alias: Minimum Amount (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• hm_inv_daynum (type: esriFieldTypeInteger, alias: Number of Days on Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hm_stortype (type: esriFieldTypeString, alias: Storage Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_storcond (type: esriFieldTypeString, alias: Storage Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_storconf (type: esriFieldTypeString, alias: Storage Confidential?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [y: Yes], [n: No])
• hm_stor_loc (type: esriFieldTypeString, alias: Storage Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_chem_comm (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hm_tank (type: esriFieldTypeString, alias: Tank Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [tk_drum: Hazmat Drums], [tk_horizontal: Horizontal Tank], [tk_underground: Underground Tank], ... 1 more ...)
• hm_nfpa704_flamm (type: esriFieldTypeString, alias: Flammability, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [NFPA-704-F0: 0 Not combustible], [NFPA-704-F1: 1 Combustible if heated], [NFPA-704-F2: 2 Combustible liquid flash point of 100° to 200° F], ... 2 more ...)
• hm_nfpa704_health (type: esriFieldTypeString, alias: Health Hazards, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [NFPA-704-H0: 0 No unusual hazard.], [NFPA-704-H1: 1 Caution: May be irritating.], [NFPA-704-H2: 2 Warning: May be harmful if inhaled or absorbed.], ... 2 more ...)
• hm_nfpa704_react (type: esriFieldTypeString, alias: Reactivity, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [NFPA-704-R0: 0 Stable Not reactive when mixed with water], [NFPA-704-R1: 1 Caution May react if heated or mixed with water but not violently], [NFPA-704-R2: 2 Warning Unstable or may react violently if mixed with water], ... 2 more ...)
• hm_nfpa704_special (type: esriFieldTypeString, alias: Special Hazards, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [NFPA-704-bio: Biologic], [NFPA-704-corr: Corrosive], [NFPA-704-no_h2o: No Water], ... 4 more ...)
• hm_erg_num (type: esriFieldTypeString, alias: ERG Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• hm_erg_guide_number (type: esriFieldTypeString, alias: ERG Guide Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• hm_cas_num (type: esriFieldTypeString, alias: CAS Number, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• hm_ehs (type: esriFieldTypeString, alias: EHS, SQL Type: sqlTypeOther, length: 25, 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 (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: HazMat
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• preplan_pt (6) -- Related To: Preplan_Location_Point (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/1/2022 5:46:20 AM

Schema Last Edit Date: 4/1/2022 5:46:20 AM

Data Last Edit Date: 4/1/2022 5:46:20 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat