Name: Tier2

Display Field: t_a_chmname

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)
• t_a_chmname (type: esriFieldTypeString, alias: Chemical Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• t_a_chmstat (type: esriFieldTypeString, alias: Chemical State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Gas: Gas], [Liquid: Liquid], [Solid: Solid])
• t_hm_tier2 (type: esriFieldTypeString, alias: Tier 2 Hazmat, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_a_hm_tank (type: esriFieldTypeString, alias: Hazmat Tank or Container, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• t_hm_ph_explos (type: esriFieldTypeString, alias: Explosive, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_flamm (type: esriFieldTypeString, alias: Flammable (gases, aerosols, liquids, or solids), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_ox (type: esriFieldTypeString, alias: Oxidizer (liquid, solid or gas), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_selfrct (type: esriFieldTypeString, alias: Self-Reactive, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_pyroph (type: esriFieldTypeString, alias: Pyrophoric (liquid or solid), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_pyrogas (type: esriFieldTypeString, alias: Pyrophoric Gas, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_corrsiv (type: esriFieldTypeString, alias: Corrosive to metal, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_gaspres (type: esriFieldTypeString, alias: Gas under pressure (compressed gas), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_emitgas (type: esriFieldTypeString, alias: In contact with water emits flammable gas, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_radioctive (type: esriFieldTypeString, alias: Radioactive Material, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_combdst (type: esriFieldTypeString, alias: Combustible Dust, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_ph_other (type: esriFieldTypeString, alias: Hazard Not Otherwise Classified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hm_hh_acutox (type: esriFieldTypeString, alias: Acute Toxicity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_skin (type: esriFieldTypeString, alias: Skin Corrosion or Irritation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_eye (type: esriFieldTypeString, alias: Serious Eye Damage or Irritation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_respir (type: esriFieldTypeString, alias: Respiratory or Skin Sensitization, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_germcel (type: esriFieldTypeString, alias: Germ cell mutagenicity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_carcin (type: esriFieldTypeString, alias: Combustible Dust, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_reprod (type: esriFieldTypeString, alias: Carcinogenicity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_organ (type: esriFieldTypeString, alias: Reproductive toxicity, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_aspria (type: esriFieldTypeString, alias: Specific target organ toxicity(single or repeated exposure), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_asphix (type: esriFieldTypeString, alias: Aspiration hazard, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_hh_other (type: esriFieldTypeString, alias: Other Health Hazards, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hm_inv_max (type: esriFieldTypeInteger, alias: Maximum Amount (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• t_hm_inv_min (type: esriFieldTypeInteger, alias: Minimum Amount (Gallons), SQL Type: sqlTypeOther, nullable: true, editable: true)
• t_hm_inv_num (type: esriFieldTypeInteger, alias: Number of Days on Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• t_hm_stortype (type: esriFieldTypeString, alias: Storage Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hm_storcon (type: esriFieldTypeString, alias: Storage Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hm_storcdn (type: esriFieldTypeString, alias: Storage Confidential?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hm_storloc (type: esriFieldTypeString, alias: Storage Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hm_comm (type: esriFieldTypeString, alias: Hazmat Tier 2 Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_t2 (type: esriFieldTypeString, alias: created_user_t2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date_t2 (type: esriFieldTypeDate, alias: created_date_t2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user_t2 (type: esriFieldTypeString, alias: last_edited_user_t2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date_t2 (type: esriFieldTypeDate, alias: last_edited_date_t2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• t_hm_reaate2hm (type: esriFieldTypeGUID, alias: RElate to Hazmat, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• t_hm_relate2addr (type: esriFieldTypeGUID, alias: Relate to Address, SQL Type: sqlTypeOther, length: 38, 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)

Templates:

Name: Tier2
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• t_hm_tier2: no
• t_hm_ph_explos: no
• t_hm_ph_flamm: no
• t_hm_ph_ox: no
• t_hm_ph_selfrct: no
• t_hm_ph_pyroph: no
• t_hm_ph_pyrogas: no
• t_hm_ph_corrsiv: no
• t_hm_ph_gaspres: no
• t_hm_ph_emitgas: no
• t_hm_ph_radioctive: no
• t_hm_ph_combdst: no
• t_hm_hh_acutox: no
• t_hm_hh_skin: no
• t_hm_hh_eye: no
• t_hm_hh_respir: no
• t_hm_hh_germcel: no
• t_hm_hh_carcin: no
• t_hm_hh_reprod: no
• t_hm_hh_organ: no
• t_hm_hh_aspria: no
• t_hm_hh_asphix: no
• t_hm_storcdn: no

Relationships:

• Hazmat (0) -- Related To: Hazmat (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2023 7:04:17 PM

Schema Last Edit Date: 8/7/2023 3:51:00 AM

Data Last Edit Date: 8/13/2023 7:04:17 PM

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