Name: Occupancy_Inspection

Display Field: t_occ_insptype

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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_occ_insptype (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ext_firelane (type: esriFieldTypeString, alias: Fire Lanes marked unobstructed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_address_vis (type: esriFieldTypeString, alias: Address visible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_fire_hydrant (type: esriFieldTypeString, alias: Fire hydrants water supply not accessible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_combustible (type: esriFieldTypeString, alias: Combustible accumulations/storage acceptable, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_keybox (type: esriFieldTypeString, alias: F.D. key box present/maintained, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_fdc (type: esriFieldTypeString, alias: F.D. connections not visible or not maintained, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_gas_meter (type: esriFieldTypeString, alias: Gas meter/piping not protected against impact, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ext_dumpster (type: esriFieldTypeString, alias: Dumpsters are inside or within 5 ft. of the building, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• exp_comment (type: esriFieldTypeString, alias: Exterior Feature Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• egress_number (type: esriFieldTypeString, alias: Poor Number of exits, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_obstructions (type: esriFieldTypeString, alias: Exits, aisles, and corridors not free of obstructions, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_exit_door_open (type: esriFieldTypeString, alias: Exit doors don't open from inside, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_exist_signs (type: esriFieldTypeString, alias: Exit signs don't exist, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_emerg_lighting (type: esriFieldTypeString, alias: No Egress Lighting, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_int_finish (type: esriFieldTypeString, alias: Interior finish not acceptable, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_corridors_rated (type: esriFieldTypeString, alias: Exit corridors not rated, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_exit_swing (type: esriFieldTypeString, alias: Exit doors swing in wrong direction, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_corridors_width (type: esriFieldTypeString, alias: Poor Exit Corridor Width, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_young (type: esriFieldTypeString, alias: Special egress provisions for younger children, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• egress_comments (type: esriFieldTypeString, alias: Egress Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• const_fire_rated (type: esriFieldTypeString, alias: Fire rated construction not maintained, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• const_fire_doors (type: esriFieldTypeString, alias: Rated fire doors not operational, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• const_vertical_opening (type: esriFieldTypeString, alias: Vertical openings not protected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• const_area_sprinklered (type: esriFieldTypeString, alias: Vertical openings protected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• const_decorations (type: esriFieldTypeString, alias: Excessive Combustible Decorations, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• const_comments (type: esriFieldTypeString, alias: Comments on Construction Issues, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• storage_cleanliness (type: esriFieldTypeString, alias: Poor Cleanliness, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_combustible (type: esriFieldTypeString, alias: Combustible in electrical room, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_attoc (type: esriFieldTypeString, alias: Items stored in attict, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_sprinkler (type: esriFieldTypeString, alias: Storage close to sprinkler, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_rubbish (type: esriFieldTypeString, alias: Rubbish or waste subject to spontaneous ignition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_high_pile (type: esriFieldTypeString, alias: Poor High Pile Storage, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• storage_comments (type: esriFieldTypeString, alias: Comments on Storage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• flammable_container (type: esriFieldTypeString, alias: Storage Poor, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_exits (type: esriFieldTypeString, alias: Stored or kept near exits, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_ignition (type: esriFieldTypeString, alias: Sources of ignition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_quanitity (type: esriFieldTypeString, alias: Larger Quanitity in Cabinet, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_basement (type: esriFieldTypeString, alias: Stored in basement without sprinkler, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_ventilation (type: esriFieldTypeString, alias: Poor ventilation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• flammable_comment (type: esriFieldTypeString, alias: Flammable Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hazmat_cylinders (type: esriFieldTypeString, alias: Compressed gas cylinders not secured, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hazmat_room (type: esriFieldTypeString, alias: Rooms or areas properly not labeled, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hazmat_quantity (type: esriFieldTypeString, alias: Excessive Hazmat Quantities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hazmat_seperation (type: esriFieldTypeString, alias: Poor Separation of incompatible materials, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• hazmat_comment (type: esriFieldTypeString, alias: Hazmat Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fireext_access (type: esriFieldTypeString, alias: Not Readily accessible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fireext_distance (type: esriFieldTypeString, alias: Travel distance exceeded, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fireext_inspect (type: esriFieldTypeString, alias: Not Tested and Inspected at least annually, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fireext_comment (type: esriFieldTypeString, alias: Fire Extinguisher Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• utility_shutoff (type: esriFieldTypeString, alias: Shut off valves not present on gas appliances, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• utility_piping (type: esriFieldTypeString, alias: Approved piping, connections and appliances not used, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• utility_clearance (type: esriFieldTypeString, alias: Poor clearance between combustibles and appliances, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• utility_hood (type: esriFieldTypeString, alias: Commercial hood ducts and filters are dirty, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• utility_comment (type: esriFieldTypeString, alias: Utility Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sprinkler_coverage (type: esriFieldTypeString, alias: Coverage is poor, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_controls (type: esriFieldTypeString, alias: Controls are not accessible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_valves (type: esriFieldTypeString, alias: Valves not open, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_supervise (type: esriFieldTypeString, alias: System and valves supervised, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_heads (type: esriFieldTypeString, alias: Heads in poor condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_tools (type: esriFieldTypeString, alias: Wrench or spare sprinklers not present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_tested (type: esriFieldTypeString, alias: Tested or inspected at least annually, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_riser_room (type: esriFieldTypeString, alias: Riser or pump rooms not labeled, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• sprinkler_comment (type: esriFieldTypeString, alias: Sprinkler Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alrm_control (type: esriFieldTypeString, alias: Control panel or annunciator panel in poor condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_detector (type: esriFieldTypeString, alias: Detectors Not Tested and inspected at annually, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_tested (type: esriFieldTypeString, alias: Not Tested or inspected annually, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_install (type: esriFieldTypeString, alias: Fire alarm system not installed where required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_detect_apartmnt (type: esriFieldTypeString, alias: Single station or multiple station smoke detectors present in each unit, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_egress (type: esriFieldTypeString, alias: Smoke detection in intervening egress rooms, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_fire_drill (type: esriFieldTypeString, alias: Fire drills conducted, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• alrm_comment (type: esriFieldTypeString, alias: Sprinkler Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fp_standpipe (type: esriFieldTypeString, alias: Standpipes needed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fp_standpipe_cond (type: esriFieldTypeString, alias: Standpipes or hose in poor condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fp_coverage (type: esriFieldTypeString, alias: No Adequate Coverage, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fp_hood_so (type: esriFieldTypeString, alias: Kitchen Hood system fuel shutoff not present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fp_hood_main (type: esriFieldTypeString, alias: Kitchen hood system not properly maintained, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fp_comment (type: esriFieldTypeString, alias: Fire Alarm and Detector Inspection Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• el_hazards (type: esriFieldTypeString, alias: Electrical Hazards Present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_appliance_con (type: esriFieldTypeString, alias: Appliances or fixtures in poor condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_overcurrent (type: esriFieldTypeString, alias: Overcurrent protection not present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_multiplug (type: esriFieldTypeString, alias: Poor Multi-plug adapters per NFPA 70, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_ext_cord (type: esriFieldTypeString, alias: Extension cords substituted for fixed wiring, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_powerstrip (type: esriFieldTypeString, alias: Power strips not properly used, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_pnl_clr (type: esriFieldTypeString, alias: Poor Access or clearance to electrical panels, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_elct_room (type: esriFieldTypeString, alias: Electrical Rooms Not Labeled, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• el_comment (type: esriFieldTypeString, alias: Other Fire Protection System Inspection 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_inocc (type: esriFieldTypeString, alias: created_user_inocc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date_inocc (type: esriFieldTypeDate, alias: created_date_inocc, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user_inocc (type: esriFieldTypeString, alias: last_edited_user_inocc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date_inocc (type: esriFieldTypeDate, alias: last_edited_date_inocc, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rel_insp2address (type: esriFieldTypeGUID, alias: Inspection to Address Relation, 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: Occupancy_Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• t_occ_insptype: Occupancy Inspection
• ext_firelane: no
• ext_address_vis: no
• ext_fire_hydrant: no
• ext_combustible: no
• ext_keybox: no
• ext_fdc: no
• ext_gas_meter: no
• ext_dumpster: no
• egress_number: no
• egress_obstructions: no
• egress_exit_door_open: no
• egress_exist_signs: no
• egress_emerg_lighting: no
• egress_int_finish: no
• egress_corridors_rated: no
• egress_exit_swing: no
• egress_corridors_width: no
• egress_young: no
• const_fire_rated: no
• const_fire_doors: no
• const_vertical_opening: no
• const_area_sprinklered: no
• const_decorations: no
• storage_cleanliness: no
• storage_combustible: no
• storage_attoc: no
• storage_sprinkler: no
• storage_rubbish: no
• storage_high_pile: no
• flammable_container: no
• flammable_exits: no
• flammable_ignition: no
• flammable_quanitity: no
• flammable_basement: no
• flammable_ventilation: no
• hazmat_cylinders: no
• hazmat_room: no
• hazmat_quantity: no
• hazmat_seperation: no
• fireext_access: no
• fireext_distance: no
• fireext_inspect: no
• utility_shutoff: no
• utility_piping: no
• utility_clearance: no
• utility_hood: no
• sprinkler_coverage: no
• sprinkler_controls: no
• sprinkler_valves: no
• sprinkler_supervise: no
• sprinkler_heads: no
• sprinkler_tools: no
• sprinkler_tested: no
• sprinkler_riser_room: no
• alrm_control: no
• alrm_detector: no
• alrm_tested: no
• alrm_install: no
• alrm_detect_apartmnt: no
• alrm_egress: no
• alrm_fire_drill: no
• fp_standpipe: no
• fp_standpipe_cond: no
• fp_coverage: no
• fp_hood_so: no
• fp_hood_main: no
• el_hazards: no
• el_appliance_con: no
• el_overcurrent: no
• el_multiplug: no
• el_ext_cord: no
• el_powerstrip: no
• el_pnl_clr: no
• el_elct_room: no

Relationships:

• Address (1) -- Related To: Address (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/15/2023 12:47:22 AM

Schema Last Edit Date: 10/15/2023 12:47:22 AM

Data Last Edit Date: 10/15/2023 12:47:22 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