Name: Building_Information
Display Field: floor_up
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- floor_up (type: esriFieldTypeInteger, alias: Number of Floors Above Ground, SQL Type: sqlTypeOther, nullable: true, editable: true)
- floor_down (type: esriFieldTypeInteger, alias: Number of Floors Below Ground, SQL Type: sqlTypeOther, nullable: true, editable: true)
- occload (type: esriFieldTypeInteger, alias: Typical Number of Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ds_probabl (type: esriFieldTypeString, alias: Event Probability, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [No_history: No history of event], [Rare_history: Rare history of event], [Routine_History: Routine History of event], ... 1 more ...)
- ds_commun (type: esriFieldTypeString, alias: Community Impact, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Minor: Minor Impact (minor casualty - family loss)], [Moderate: Moderate Impact (high casualty - job losses - tax losses)], [Severe: Severe Impact (irreplaceable - historical - hospital)])
- oc_lifehaz (type: esriFieldTypeString, alias: Life Hazards, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [High_100: High Life Hazard (100 or more occupants)], [Medium_25-99: Medium Life Hazard (25-99 occupants)], [Low_lt_25: Low Life Hazard (Less than 25 occupants)])
- wa_source (type: esriFieldTypeString, alias: Water Source at Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [WS-1-2-hydrant: 1 to 2 hydrants over 1000 GPM], [WS-2hydrant: 2 or more Hydrants at 1000 GPM or over], [WS-draft_site: Drafting Site (Pond, Creek, or Lake)], ... 7 more ...)
- hz_no_supp (type: esriFieldTypeString, alias: No Water Supply, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- st_wallcon (type: esriFieldTypeString, alias: Wall Construction, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1_brick: Brick], [1_concrete: Concrete], [1OthrNonCombust: Other Non Combustible], ... 10 more ...)
- st_exp_sep (type: esriFieldTypeString, alias: Exposure seperation to other structure?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [0_not_determine: Not Determined], [1_101_plus: 101+], [2_61-100: 61-100], ... 3 more ...)
- st_roofcov (type: esriFieldTypeString, alias: Roof Covering, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [2_asphalt: Asphalt], [1_concrete: Concrete], [3_membrane: Membrane], ... 7 more ...)
- st_roofcon (type: esriFieldTypeString, alias: Roof Construction, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Lamella: Lamella], [Panelized: Panelized], [RibbedArch: Ribbed Arch], ... 8 more ...)
- bf_fpsqft (type: esriFieldTypeDouble, alias: Square Footage of Footprint, SQL Type: sqlTypeOther, nullable: true, editable: true)
- bf_bldgotr (type: esriFieldTypeString, alias: Other Type of Building, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ac_ladder (type: esriFieldTypeString, alias: Ladder Access, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [Access_Aerial: Access with Aerial Ladder], [Access_Ground: Access with Ground Ladder], [No_Ladder_Acc: Areas with No Ladder Access])
- ac_bld_sid (type: esriFieldTypeString, alias: Side Access, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [1_all_sides: All sides], [2_3_sides: 3 Sides], [3_2_sides: 2 Sides], ... 3 more ...)
- ac_rdsetbk (type: esriFieldTypeString, alias: Road Setback, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [50: 0-50 feet], [100: 51-100 feet], [150: 101-150 feet], ... 2 more ...)
- c1_acc_bg (type: esriFieldTypeString, alias: Type of Below Grade Access, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [walk_down_NB1: WALK DOWN basement access at location], [walk_out_NB1: WALK OUT basement access at location], [look_out_NB1: LOOK OUT basement at location])
- c2_sy_spkr (type: esriFieldTypeString, alias: Sprinkler System, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [NoSprinkSys_NB2: No Sprinkler System (NS).], [SprFullCov_NB2: Sprinkler with Full Coverage (AS).], [SprFullPCov_NB2: Sprinkler with Partial Coverage (AS).])
- c3_ct_roof (type: esriFieldTypeString, alias: Roof Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Arched_NB3: Arched Roof.], [Complex_NB3: Complex Roof.], [Flat_NB3: Flat (0-5%) Roof.], ... 4 more ...)
- c4_ct_strc (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [bt-fire-resist: Fire Resistive (Type I)], [bt-non-combust: Non-Combustible (Type II )], [bt-concrte_tilt: Concrete Tiltup (Type III)], ... 5 more ...)
- c1_acc_bg1 (type: esriFieldTypeString, alias: Type of Below Grade Access, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [walk_down_NB1: WALK DOWN basement access at location], [walk_out_NB1: WALK OUT basement access at location], [look_out_NB1: LOOK OUT basement at location])
- ac_in_out (type: esriFieldTypeString, alias: Community Ingress and Egress, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Two_in_out: Two or more roads in and out], [OneRDInOut: One road in and out])
- ac_dw_wid (type: esriFieldTypeString, alias: Width of Driveway, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1_dw_gt_15ft: Driveway Width- Greater than 15 Feet], [2_DWLT15ft: Driveway Width- Less than 15 Feet])
- ac_dw_len (type: esriFieldTypeString, alias: Length of Driveway, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1_dl_50feet: Driveway Length- Less than 50 Feet], [2_DWLen50-150ft: Driveway Length- 50 - 150 Feet], [3_DWLn150-500ft: Driveway Length- 150-500 Feet], ... 1 more ...)
- ac_roadcon (type: esriFieldTypeString, alias: All-Season Road Condition, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1_aw_2wd_lt_10: All-weather (2WD), grade < 10%], [2_aw_2wd_gt_10: All-weather (2WD), grade > 10%], [3_DW_4wd_lt10: Dry-weather (4WD), grade < 10%], ... 1 more ...)
- ac_uturn (type: esriFieldTypeString, alias: Adequate Turnaround, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- h2_hz_str (type: esriFieldTypeString, alias: Structure Hazards, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [High_Pile_HZ2: HIGH PILE STORAGE at or on the way to location.], [Permit_CS_HZ2: PERMITTED CONFINED SPACE at or on the way to location.], [CollapseHaz_HZ2: RISK of COLLAPSE at or on the way to location.], ... 2 more ...)
- h2_hz_ruf (type: esriFieldTypeString, alias: Roof Hazards, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Bowstring_HZ2: BOWSTRING TRUSS at location.], [Commn_Attic_HZ2: COMMON ATTIC at or on the way to location.], [LW_Truss_HZ2: LIGHT WEIGHT TRUSS at location.], ... 2 more ...)
- h2_hz_elec (type: esriFieldTypeString, alias: Electrical Hazards, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Elect_Haz_HZ2: UNUSUAL ELECTRICAL HAZARDS at or on the way to location.], [Mag_Field_HZ2: STRONG MAGNETIC FIELD at or on the way to location.])
- h2_hz_rado (type: esriFieldTypeString, alias: Poor Radio Signal, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Poor_RadSig_HZ2: POOR RADIO SIGNAL at or on the way to location.])
- hz2_secure (type: esriFieldTypeString, alias: Secured Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [SecureEntry_NB1: SECURED ENTRY at or on the way to location])
- h3_vacant (type: esriFieldTypeString, alias: Vacant or High Occupancy Level, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Vacant_HZ3: ABANDONED or VACANT at or near location.], [Hi_Occ_Load_HZ3: HIGH OCCUPANT LOAD at or near location.])
- h3_xtrmlod (type: esriFieldTypeString, alias: Hoarder or Extreme Fire Load, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [HiFireLoad_HZ3: EXTREME FIRE LOAD at or near location.])
- h3_entrap (type: esriFieldTypeString, alias: Person Trap or High Entrapment Risk, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [ManTrap_HZ3: HIGH ENTRAPMENT RISK at or near location.])
- h3_machine (type: esriFieldTypeString, alias: Machine Hazards at location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Machine_Haz_HZ3: MACHINE HAZARDS at or near location.], [Multiple_HM_HZ3: MULTIPLE HAZARDOUS MATERIALS at location])
- h4_animal (type: esriFieldTypeString, alias: Animal Hazards, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Animal_Haz_HZ4: ANIMAL HAZARDS at or near location.])
- h4_druguse (type: esriFieldTypeString, alias: Drug Use at Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Drug_Use_HZ4: DRUG USE at or near location.])
- h4_evac (type: esriFieldTypeString, alias: Evacuation Challenge at Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Evac_Haz_HZ4: EVACUATION CHALLENGE at or near location.], [Handicapped_HZ4: HANDICAPPED or INVALID at or near location.])
- h4_viol (type: esriFieldTypeString, alias: Violence or Weapons at Location, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Violence_HZ4: HISTORY of VIOLENCE at or near location.], [Weapons_HZ4: WEAPONS at or near location.])
- h4_biologc (type: esriFieldTypeString, alias: Biologic or Quarentine, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [BiologicHaz_HZ4: BIOLOGIC HAZARD at or near location.])
- relate_id (type: esriFieldTypeGUID, alias: Relate to Assessment Grid, 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)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Building_Information
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- ps_loc_point (4) -- Related To: Point (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/19/2022 8:03:07 PM
Schema Last Edit Date: 2/19/2022 8:03:07 PM
Data Last Edit Date: 2/19/2022 8:03:07 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