Layer: Draft_IA_Survey_Template (ID:0)

View In: Map Viewer

Name: Draft_IA_Survey_Template

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Draft IA Survey Template","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
incident_id (type: esriFieldTypeString, alias: incident_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
horaccuracy (type: esriFieldTypeDouble, alias: horaccuracy, SQL Type: sqlTypeOther, nullable: true, editable: true)
lat (type: esriFieldTypeDouble, alias: lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
lon (type: esriFieldTypeDouble, alias: lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
unit_suite (type: esriFieldTypeString, alias: Street Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
unit_number (type: esriFieldTypeString, alias: Unit or Manufacture Home Space Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: City/Town:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
state_territory (type: esriFieldTypeString, alias: State/Territory:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county_label (type: esriFieldTypeString, alias: Select a city:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
zip (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
taxlot (type: esriFieldTypeString, alias: taxlot, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident_datetime (type: esriFieldTypeDate, alias: Incident Begin Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident_type (type: esriFieldTypeString, alias: What event type caused the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
other_incident (type: esriFieldTypeString, alias: Specify Other:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessment_level (type: esriFieldTypeString, alias: Level of damage assessed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [affected: Affected], [minor: Minor], [major: Major], ... 3 more ...)
inaccessible_cause (type: esriFieldTypeString, alias: Cause of inaccessibility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [road: Impassable Road], [private_bridge: Destroyed Private Bridge])
inaccessible_des (type: esriFieldTypeString, alias: Briefly describe the cause of inaccessibility:, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
inaccesible_homes_count (type: esriFieldTypeInteger, alias: Estimated number of inaccessible homes?, SQL Type: sqlTypeOther, nullable: true, editable: true)
dwelling_type (type: esriFieldTypeString, alias: Choose the type of dwelling:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [single_family: Single Family], [multi_family: Multi-Family], [manufactured_home: Manufactured Home])
in_mhp (type: esriFieldTypeString, alias: Is the property in a manufactured home park?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
otherstruct_damaged (type: esriFieldTypeString, alias: Were other structures damaged on the property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
number_otherstruct_damaged (type: esriFieldTypeInteger, alias: How many other structures on the property have been damaged?, SQL Type: sqlTypeOther, nullable: true, editable: true)
otherstruct_type (type: esriFieldTypeString, alias: Estimated types of other structures damaged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
otherstruct_totalsq (type: esriFieldTypeInteger, alias: Estimated total square footage of other structures, SQL Type: sqlTypeOther, nullable: true, editable: true)
sfdestroyed_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the destroyed damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [destroyed_structural: Complete failure of two or more major structural components -e.g. collapse of basement walls, foundation, load-bearing walls, or roof.], [destroyed_foundation: Only foundation remains], [destroyed_collapse: A residence that is in imminent threat of collapse because of disaster-related damage or confirmed imminent danger - e.g. impending landslides, mudslides, or sinkholes.])
sfmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [major_roof: Failure or partial failure to structural elements of the roof to include rafters, ceiling joists, ridge boards, etc.], [major_frame: Failure or partial failure to structural elements of the walls to include framing, sheathing, etc.], [major_foundation: Failure or partial failure to foundation to include crumbling, bulging, collapsing, horizontal cracks of more than two inches, and shifting of the residence on the foundation of more than six inches], ... 1 more ...)
sfminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [minor_roof: Nonstructural damage to roof components over essential living space to include large areas of shingles e.g. roof covering, fascia board, soffit, flashing, and skylight], [minor_interior: Nonstructural damage to the interior wall components to include drywall, insulation; exterior components to include house wrap, missing doors, broken window framings; or substantial loss of exterior covering, such as missing siding, vinyl, stucco, etc.], [minor_foundation: Multiple small vertical cracks in the foundation], ... 4 more ...)
sfaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [affected_roof: Partially missing shingles or siding (non-continuous/sporadic), but roof structure is intact.], [affected_cosmetic: Cosmetic damage such as paint discoloration, loose siding, screens, gutters, etc.], [affected_structure: Damage to an attached structure such as a porch, carport, garage, or outbuilding not for commercial use.], ... 2 more ...)
mfdestroyed_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the destroyed damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [destroyed_structural: Complete failure of two or more major structural components -e.g. collapse of basement walls, foundation, load-bearing walls, or roof.], [destroyed_foundation: Only foundation remains], [destroyed_collapse: A residence that is in imminent threat of collapse because of disaster-related damage or confirmed imminent danger - e.g. impending landslides, mudslides, or sinkholes.])
mfmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [major_roof: Failure or partial failure to structural elements of the roof to include rafters, ceiling joists, ridge boards, etc.], [major_frame: Failure or partial failure to structural elements of the walls to include framing, sheathing, etc.], [major_foundation: Failure or partial failure to foundation to include crumbling, bulging, collapsing, horizontal cracks of more than two inches, and shifting of the residence on the foundation of more than six inches], ... 1 more ...)
mfminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [minor_roof: Nonstructural damage to roof components over essential living space to include large areas of shingles e.g. roof covering, fascia board, soffit, flashing, and skylight], [minor_interior: Nonstructural damage to the interior wall components to include drywall, insulation; exterior components to include house wrap, missing doors, broken window framings; or substantial loss of exterior covering, such as missing siding, vinyl, stucco, etc.], [minor_foundation: Multiple small vertical cracks in the foundation], ... 4 more ...)
mfaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [affected_roof: Partially missing shingles or siding (non-continuous/sporadic), but roof structure is intact.], [affected_cosmetic: Cosmetic damage such as paint discoloration, loose siding, screens, gutters, etc.], [affected_structure: Damage to an attached structure such as a porch, carport, garage, or outbuilding not for commercial use.], ... 2 more ...)
mhdestroyed_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the destroyed damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mhdestroyed_frame: The residence's frame is bent, twisted, or otherwise compromised.], [mhdestroyed_roof: The residence is missing the roof covering and the structural ribbing has collapsed for the majority of the roof system.], [mhdestroyed_total: The residence is a total loss])
mhmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mhmajor_foundation: The residence has been displaced from the foundation, block or piers, and other structural components have been damaged.], [mhmajor_water: Water has come into contact with the floor system to include belly board insulation, ductwork, and subflooring.])
mhminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mhminor_nonstructural: Nonstructural components have sustained damage - e.g. windows, doors, wall coverings, roof, bottom board insulation, ductwork, and/or utility hook up.])
mhaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [mhaffected_cosmetic: No damage affecting habitability; cosmetic damage only. The dwelling's frame is not bent, twisted, or otherwise compromised.])
impacted_units (type: esriFieldTypeInteger, alias: impacted_units, SQL Type: sqlTypeOther, nullable: true, editable: true)
functional_utilities (type: esriFieldTypeString, alias: Are the utilities functional?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
water_depth (type: esriFieldTypeInteger, alias: Water Depth (inches):, SQL Type: sqlTypeOther, nullable: true, editable: true)
water_location (type: esriFieldTypeString, alias: Which part of the home was impacted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
physicalhazards (type: esriFieldTypeString, alias: Do physical hazards exist on the property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
hazardonsite (type: esriFieldTypeString, alias: Select which hazards exist on the property., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
hazardonsiteother (type: esriFieldTypeString, alias: Please describe other hazards on site., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
culturalhist (type: esriFieldTypeString, alias: Is this property a suspected cultural or historic site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
narrative (type: esriFieldTypeString, alias: Additional Narrative:Maximum of 1000 characters(no PII), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
buildinginspector (type: esriFieldTypeString, alias: Is a building inspector available to conduct an ATC assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ATCbuildingName (type: esriFieldTypeString, alias: Building name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCbuildingContactPhone (type: esriFieldTypeString, alias: Building contact/phone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCnumberOfStoriesAboveGround (type: esriFieldTypeSmallInteger, alias: Number of stories above ground, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCnumberOfStoriesBelowGround (type: esriFieldTypeSmallInteger, alias: Number of stories below ground, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCnumberOfResidentialUnits (type: esriFieldTypeSmallInteger, alias: Number of residential units, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCnumberOfUnitsNotHabitable (type: esriFieldTypeSmallInteger, alias: Number of residential units not habitable, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCconstructionType (type: esriFieldTypeString, alias: Type of Construction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [woodFrame: Wood frame], [steelFrame: Steel frame], [tiltUpConcrete: Tilt-up concrete], ... 5 more ...)
ATCprimaryOccupancy (type: esriFieldTypeString, alias: Primary Occupancy, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [housing: Housing], [business: Business], [privateNonprofit: Private Nonprofit], ... 5 more ...)
ATCusedForEmergencyServices (type: esriFieldTypeString, alias: Building is used for emergency services, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ATCcollapse (type: esriFieldTypeString, alias: Collapse, partial collapse, or building off foundation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCleaning (type: esriFieldTypeString, alias: Building or story leaning, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCracking (type: esriFieldTypeString, alias: Racking damage to walls, other structural damage, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCfallingHazard (type: esriFieldTypeString, alias: Chimney, parapet, or other falling hazard, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCgroundMovement (type: esriFieldTypeString, alias: Ground slope movement or cracking, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCotherCondition (type: esriFieldTypeString, alias: Other (specify), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [minorNone: Minor/None], [moderate: Moderate], [severe: Severe])
ATCotherConditionSpecifics (type: esriFieldTypeString, alias: Other condition specifics, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCestimatedDamage (type: esriFieldTypeString, alias: Estimated Building Damage (excluding contents), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [100: 100%], [1: 0% to 1%], [10: 1% to 10%], ... 4 more ...)
ATCposting (type: esriFieldTypeString, alias: Posting, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [inspected: INSPECTED], [restricted: RESTRICTED USE], [unsafe: UNSAFE])
ATCuseAndEntryRestrictions (type: esriFieldTypeString, alias: Record any use and entry restrictions exactly as written on placard:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCfurtherActions (type: esriFieldTypeString, alias: Check the boxes below only if further actions are needed., SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
ATCbarricadesNeeded (type: esriFieldTypeInteger, alias: ATCbarricadesNeeded, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCbarricadesNeededWhere (type: esriFieldTypeString, alias: Barricades in the following areas:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCdetailedEvaluationRecommended (type: esriFieldTypeString, alias: Detailed Evaluation recommended:, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
ATCstructuralEvaluationRecommended (type: esriFieldTypeInteger, alias: ATCstructuralEvaluationRecommended, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCgeotechEvaluationRecommended (type: esriFieldTypeInteger, alias: ATCgeotechEvaluationRecommended, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCotherEvaluationRecommended (type: esriFieldTypeInteger, alias: ATCotherEvaluationRecommended, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCotherEvaluationComments (type: esriFieldTypeString, alias: Other recommendations:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCotherRecommendations (type: esriFieldTypeInteger, alias: ATCotherRecommendations, SQL Type: sqlTypeOther, nullable: true, editable: true)
ATCotherRecommendationsComments (type: esriFieldTypeString, alias: Other recommendations:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ATCfurtherActionsComments (type: esriFieldTypeString, alias: Comments:, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
ATCestimatedValueOfDamage (type: esriFieldTypeInteger, alias: ATCestimatedValueOfDamage, SQL Type: sqlTypeOther, nullable: true, editable: true)
owner_renter_avail (type: esriFieldTypeString, alias: Is a homeowner or renter available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
tribeconfirm (type: esriFieldTypeString, alias: Is any member of the household affiliated with a federally recognized tribe?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
owner_renter (type: esriFieldTypeString, alias: Owner or Renter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [owner: Owner], [renter: Renter], [unknown: Unknown])
tribe (type: esriFieldTypeString, alias: Select Tribal Entity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [burns: Burns Paiute Tribe], [siletz: Confederated Tribes of Siletz Indians], [clusi: Confederated Tribes of the Coos Lower Umpqua and Siuslaw Indians], ... 6 more ...)
insurance_yesno (type: esriFieldTypeString, alias: Is there insurance for this peril?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
renters_homeowners_ins (type: esriFieldTypeString, alias: Do you have renters or homeowners insurance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
insurance_deductible (type: esriFieldTypeInteger, alias: Insurance deductible, SQL Type: sqlTypeOther, nullable: true, editable: true)
primary_residence (type: esriFieldTypeString, alias: Are these primary residences (occupied at least 6 months per year)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
number_in_house (type: esriFieldTypeInteger, alias: Number of people in household, SQL Type: sqlTypeOther, nullable: true, editable: true)
over65 (type: esriFieldTypeInteger, alias: Number of individuals over age 65 in residence, SQL Type: sqlTypeOther, nullable: true, editable: true)
under5 (type: esriFieldTypeInteger, alias: Number of individuals under age 5 in residence, SQL Type: sqlTypeOther, nullable: true, editable: true)
subsidizedhousing (type: esriFieldTypeString, alias: Is this property in subsidized housing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
fmv_home (type: esriFieldTypeInteger, alias: Estimated fair market value of home before event, SQL Type: sqlTypeOther, nullable: true, editable: true)
propertybldg_loss (type: esriFieldTypeInteger, alias: Estimated loss to property/building, SQL Type: sqlTypeOther, nullable: true, editable: true)
personalprop_loss (type: esriFieldTypeInteger, alias: Estimated loss to personal property, SQL Type: sqlTypeOther, nullable: true, editable: true)
repaircost (type: esriFieldTypeInteger, alias: Estimated repair costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
firstconstructiondate (type: esriFieldTypeInteger, alias: Estimated first construction date of site, SQL Type: sqlTypeOther, nullable: true, editable: true)
medianincome (type: esriFieldTypeString, alias: Median Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10000: Less than $10,000], [19999: $10,000 to $19,999], [29999: $20,000 to $29,999], ... 13 more ...)
immediate_needs (type: esriFieldTypeString, alias: Are there any immediate needs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unsure: Unsure])
immediateneeds_desc (type: esriFieldTypeString, alias: Please describe in detail what are the immediate needs:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
survey_version (type: esriFieldTypeString, alias: survey_version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
qaqc (type: esriFieldTypeString, alias: qaqc, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: yes], [no: no])
survey_type (type: esriFieldTypeString, alias: survey_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessment_datetime (type: esriFieldTypeDate, alias: Date & Time of assessment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
uri_deviceid_calculate (type: esriFieldTypeString, alias: uri_deviceid_calculate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
created_user_prior (type: esriFieldTypeString, alias: created_user_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
created_date_prior (type: esriFieldTypeDate, alias: created_date_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_user_prior (type: esriFieldTypeString, alias: last_edited_user_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_date_prior (type: esriFieldTypeDate, alias: last_edited_date_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
level_affected (type: esriFieldTypeInteger, alias: level_affected, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_minor (type: esriFieldTypeInteger, alias: level_minor, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_major (type: esriFieldTypeInteger, alias: level_major, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_destroyed (type: esriFieldTypeInteger, alias: level_destroyed, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_inaccessible (type: esriFieldTypeInteger, alias: level_inaccessible, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_unaffected (type: esriFieldTypeInteger, alias: level_unaffected, SQL Type: sqlTypeOther, nullable: true, editable: true)
area_description (type: esriFieldTypeString, alias: area_description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessment_id (type: esriFieldTypeString, alias: assessment_id, SQL Type: sqlTypeOther, length: 40, 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)
const_quality (type: esriFieldTypeString, alias: Choose the option that best describes the quality of construction., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fair: Fair], [average: Average], [good: Good], ... 2 more ...)
const_type (type: esriFieldTypeString, alias: Choose the option that best describes the type of construction., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1story: 1-Story], [1.5story: 1 1/2 Story], [2story: 2 Story], ... 2 more ...)
found_type (type: esriFieldTypeString, alias: Choose the option that best describes the foundation type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [slab: Slab on Grade], [crawlspace: Crawlspace], [basement: Basement], ... 2 more ...)
roof_type (type: esriFieldTypeString, alias: Choose the option that best describes the roof type., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [comp: Composition], [wood: Wood], [metal: Metal], ... 2 more ...)
heating_type (type: esriFieldTypeString, alias: Choose the option that best describes the heating system., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [forced: Forced Air], [baseboard: Baseboard], [wood: Wood], ... 2 more ...)
floodplainmanager (type: esriFieldTypeString, alias: Is a floodplain manager or designee available to perform a significant damage assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
infloodplain (type: esriFieldTypeString, alias: Is the property in a mapped special flood hazard area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
marketvalue (type: esriFieldTypeInteger, alias: Enter in the estimated market value of the structure., SQL Type: sqlTypeOther, nullable: true, editable: true)
interiorinspected (type: esriFieldTypeString, alias: Are you able to inspect the interior of the property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
foundationdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the foundation., SQL Type: sqlTypeOther, nullable: true, editable: true)
foundationdwellingfactor (type: esriFieldTypeInteger, alias: foundationdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
foundationrepairvalue (type: esriFieldTypeInteger, alias: foundationrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
framingdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the framing and exterior masonry., SQL Type: sqlTypeOther, nullable: true, editable: true)
framingdwellingfactor (type: esriFieldTypeInteger, alias: framingdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
framingrepairvalue (type: esriFieldTypeInteger, alias: framingrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
roofingdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the roofing., SQL Type: sqlTypeOther, nullable: true, editable: true)
roofingdwellingfactor (type: esriFieldTypeInteger, alias: roofingdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
roofingrepairvalue (type: esriFieldTypeInteger, alias: roofingrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
insulationdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the insulation., SQL Type: sqlTypeOther, nullable: true, editable: true)
insulationdwellingfactor (type: esriFieldTypeInteger, alias: insulationdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
insulationrepairvalue (type: esriFieldTypeInteger, alias: insulationrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
exteriordamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the exterior finishes., SQL Type: sqlTypeOther, nullable: true, editable: true)
exteriordwellingfactor (type: esriFieldTypeInteger, alias: exteriordwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
exteriorrepairvalue (type: esriFieldTypeInteger, alias: exteriorrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
interiordamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the interior finishes., SQL Type: sqlTypeOther, nullable: true, editable: true)
interiordwellingfactor (type: esriFieldTypeInteger, alias: interiordwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
interiorrepairvalue (type: esriFieldTypeInteger, alias: interiorrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
doorsdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the doors and windows., SQL Type: sqlTypeOther, nullable: true, editable: true)
doorsdwellingfactor (type: esriFieldTypeInteger, alias: doorsdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
doorsrepairvalue (type: esriFieldTypeInteger, alias: doorsrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
trimdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the finished trim., SQL Type: sqlTypeOther, nullable: true, editable: true)
trimdwellingfactor (type: esriFieldTypeInteger, alias: trimdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
trimrepairvalue (type: esriFieldTypeInteger, alias: trimrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
hardwaredamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the finished hardware., SQL Type: sqlTypeOther, nullable: true, editable: true)
hardwaredwellingfactor (type: esriFieldTypeInteger, alias: hardwaredwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
hardwarerepairvalue (type: esriFieldTypeInteger, alias: hardwarerepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
cabinetdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the cabinets and countertops., SQL Type: sqlTypeOther, nullable: true, editable: true)
cabinetdwellingfactor (type: esriFieldTypeInteger, alias: cabinetdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
cabinetrepairvalue (type: esriFieldTypeInteger, alias: cabinetrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
floordamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the floorcoverings., SQL Type: sqlTypeOther, nullable: true, editable: true)
floordwellingfactor (type: esriFieldTypeInteger, alias: floordwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
floorrepairvalue (type: esriFieldTypeInteger, alias: floorrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
plumbingdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the plumbing., SQL Type: sqlTypeOther, nullable: true, editable: true)
plumbingdwellingfactor (type: esriFieldTypeInteger, alias: plumbingdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
plumbingrepairvalue (type: esriFieldTypeInteger, alias: plumbingrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
electricaldamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the electrical (panel and outlets)., SQL Type: sqlTypeOther, nullable: true, editable: true)
electricaldwellingfactor (type: esriFieldTypeInteger, alias: electricaldwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
electricalrepairvalue (type: esriFieldTypeInteger, alias: electricalrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
appliancedamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the built-in appliances., SQL Type: sqlTypeOther, nullable: true, editable: true)
appliancedwellingfactor (type: esriFieldTypeInteger, alias: appliancedwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
appliancerepairvalue (type: esriFieldTypeInteger, alias: appliancerepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
heatingcoolingdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the heating/cooling and/or HVAC system., SQL Type: sqlTypeOther, nullable: true, editable: true)
heatingcoolingdwellingfactor (type: esriFieldTypeInteger, alias: heatingcoolingdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
heatingcoolingrepairvalue (type: esriFieldTypeInteger, alias: heatingcoolingrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
paintingdamage (type: esriFieldTypeInteger, alias: Enter in the estimated percentage of damage to the painting., SQL Type: sqlTypeOther, nullable: true, editable: true)
paintingdwellingfactor (type: esriFieldTypeInteger, alias: paintingdwellingfactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
paintingrepairvalue (type: esriFieldTypeInteger, alias: paintingrepairvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
totalrepairs (type: esriFieldTypeInteger, alias: Total estimated repairs, SQL Type: sqlTypeOther, nullable: true, editable: true)
damagepercentMV (type: esriFieldTypeInteger, alias: Damage percentage of market value, SQL Type: sqlTypeOther, nullable: true, editable: true)
fpReview (type: esriFieldTypeString, alias: fpReview, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
propertytype (type: esriFieldTypeString, alias: Specify the Property Type: , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [home: Home], [business: Business], [both: Both], ... 1 more ...)
busassessment_level (type: esriFieldTypeString, alias: Level of damage assessed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
businaccessible_cause (type: esriFieldTypeString, alias: Cause of inaccessibility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [road: Impassable Road], [private_bridge: Destroyed Private Bridge])
businaccessible_des (type: esriFieldTypeString, alias: Briefly describe the cause of inaccessibility:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bus_owner_renter_avail (type: esriFieldTypeString, alias: Is a business owner or renter available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
busowner_renter (type: esriFieldTypeString, alias: Owner or Renter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [owner: Owner], [renter: Renter], [unknown: Unknown])
bustribeconfirm (type: esriFieldTypeString, alias: Is any member of the business affiliated with a federally recognized tribe?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
bustribe (type: esriFieldTypeString, alias: Select Tribal Entity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [burns: Burns Paiute Tribe], [siletz: Confederated Tribes of Siletz Indians], [clusi: Confederated Tribes of the Coos Lower Umpqua and Siuslaw Indians], ... 6 more ...)
businessname (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
businesstype (type: esriFieldTypeString, alias: Please select the business type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
closedforevent (type: esriFieldTypeString, alias: Was this business closed due to the event?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
abletoopen (type: esriFieldTypeString, alias: Is this business able to open?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
reopenbarriers (type: esriFieldTypeString, alias: Potential barriers to reopening, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
numberemp (type: esriFieldTypeInteger, alias: Number of employees for this business location, SQL Type: sqlTypeOther, nullable: true, editable: true)
numberempaffected (type: esriFieldTypeInteger, alias: Number of employees affected by this event, SQL Type: sqlTypeOther, nullable: true, editable: true)
bus_insurance_yesno (type: esriFieldTypeString, alias: Is there insurance for this peril?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
renters_busowners_ins (type: esriFieldTypeString, alias: Do you have renters or business owners insurance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
bus_insurance_deductible (type: esriFieldTypeInteger, alias: Insurance deductible, SQL Type: sqlTypeOther, nullable: true, editable: true)
primary_business (type: esriFieldTypeString, alias: Is this the primary location of this business?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
fmv_business (type: esriFieldTypeInteger, alias: Estimated fair market value of business before event, SQL Type: sqlTypeOther, nullable: true, editable: true)
incomelostdaily (type: esriFieldTypeInteger, alias: Income lost per day, SQL Type: sqlTypeOther, nullable: true, editable: true)
incomelostquarter (type: esriFieldTypeInteger, alias: Projected loss for next quarter, SQL Type: sqlTypeOther, nullable: true, editable: true)
inventory_loss (type: esriFieldTypeInteger, alias: Estimated loss to inventory, SQL Type: sqlTypeOther, nullable: true, editable: true)
contents_loss (type: esriFieldTypeInteger, alias: Estimated loss to contents (office furniture, equipment), SQL Type: sqlTypeOther, nullable: true, editable: true)
prop_loss (type: esriFieldTypeInteger, alias: Estimated loss to the property/building, SQL Type: sqlTypeOther, nullable: true, editable: true)
businessrecordtype (type: esriFieldTypeString, alias: Select the business record type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
paymenttype (type: esriFieldTypeString, alias: Select the payment transaction type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bus_immediate_needs (type: esriFieldTypeString, alias: Are there any immediate needs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unsure: Unsure])
bus_immediateneeds_desc (type: esriFieldTypeString, alias: Please describe in detail what are the immediate needs:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerlastname (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerfirstname (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerworkphone (type: esriFieldTypeString, alias: Work Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busowneremail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerhomephone (type: esriFieldTypeString, alias: Home Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busowneradd (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownercity (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerstate (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerzip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownercounty (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busownerpropertyowner (type: esriFieldTypeString, alias: Property Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
busassessmenttype (type: esriFieldTypeString, alias: Please select the type of of damages you are reporting., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [physical: Physical Damages], [economic: Economic Injury], [both: Both])
busassessment_uninsuredyesno (type: esriFieldTypeString, alias: Are at least 40% of the damage costs going to be out of pocket?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
insurance_recovery (type: esriFieldTypeInteger, alias: Insurance recovery expected or received for property damages, SQL Type: sqlTypeOther, nullable: true, editable: true)
impactstartdate (type: esriFieldTypeDate, alias: When did the impact start?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
impactenddate (type: esriFieldTypeDate, alias: When is the estimated end date of the impact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
revenueduringdamageperiod (type: esriFieldTypeInteger, alias: What were your businesses' revenues during the affected damage period?, SQL Type: sqlTypeOther, nullable: true, editable: true)
revenuesameperiodlastyear (type: esriFieldTypeInteger, alias: What were your businesses' revenues during the SAME period of the prior year?, SQL Type: sqlTypeOther, nullable: true, editable: true)
businessinterruptioninsurancereceived (type: esriFieldTypeInteger, alias: What is the amount of business interruption insurance you received or anticipate, if any?, SQL Type: sqlTypeOther, nullable: true, editable: true)
adverseeconomicimpactnarrative (type: esriFieldTypeString, alias: Please provide a brief explanation of what adverse economic effects the disaster had on your business.Maximum of 10000 characters, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
employeesprior (type: esriFieldTypeInteger, alias: How many people did you employ prior to the disaster?, SQL Type: sqlTypeOther, nullable: true, editable: true)
employeesafter (type: esriFieldTypeInteger, alias: How many people did you employ after the disaster?, SQL Type: sqlTypeOther, nullable: true, editable: true)
formcompletedby (type: esriFieldTypeString, alias: Form Completed by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
formcompletedbytitle (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/26/2025 10:04:12 PM

Schema Last Edit Date: 6/14/2025 12:35:53 AM

Data Last Edit Date: 6/26/2025 10:04:12 PM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat