Name: SBA_Damage_Assessment___Elsa

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"SBA Damage Assessment - Elsa","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:

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_datetime (type: esriFieldTypeDate, alias: Date of Assessment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_user (type: esriFieldTypeString, alias: Assessment Completed by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• event_name (type: esriFieldTypeString, alias: Event Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alachua: Alachua], [Baker: Baker], [Bay: Bay], ... 64 more ...)
• incident_datetime (type: esriFieldTypeDate, alias: Incident Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_suite (type: esriFieldTypeString, alias: Street Address:, 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 (type: esriFieldTypeString, alias: State:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• incident_type (type: esriFieldTypeString, alias: What event type caused the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• occupied (type: esriFieldTypeString, alias: Is the home occupied at least 6 months per year?, 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])
• insurance_yesno (type: esriFieldTypeString, alias: Is there insurance (homeowners or renters)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
• dwelling_type (type: esriFieldTypeString, alias: 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])
• multifamily_units (type: esriFieldTypeInteger, alias: If mulit-family, how many units were impacted?:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_type (type: esriFieldTypeString, alias: Choose the Property Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [home: Home], [business: Business])
• fair_replacement_value (type: esriFieldTypeDouble, alias: Estimated fair replacement value (pre-disaster fair market value) ($):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contents_loss (type: esriFieldTypeDouble, alias: Estimated amount of loss to real estate, personal property, and/or business contents ($):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• insurance_amount (type: esriFieldTypeDouble, alias: Dollar amount of insurance for type of damage suffered ($):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• damage_notes (type: esriFieldTypeString, alias: Minor Damage: • 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 exterior covering, such as missing siding, vinyl, stucco, etc. • Multiple small vertical cracks in the foundation • Damage to chimney to include tilting, fallen, cracks, or separated from residence • Damage to or submersion of mechanical components, e.g. furnace, boiler, water heater, HVAC, electrical panel, pressure tanks or well pressure switch, etc. • Water line less than 18 inches in an essential living space • Failure of partial failure to structural elements of the roof to include rafters, ceiling joists, ridge boards, etc. • Damage or disaster related contamination to a private well or septic system • 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 • Cost of damage is less than 40% of FMV Major Damage: • Failure or partial failure to structural elements of the walls to include framing, sheathing, etc. • 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 • Residences with a water line 18 inches above the floor in an essential living space, above the electrical outlets, or on the first floor or when basement is completely full. • Complete failure of two or more major structural components e.g. collapse of basement walls foundation, load-bearing walls, or roof. • Only foundation remains • 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 • Cost of damage is equal to or greater than 40% of FMV, 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: [minor: Minor], [major: Major])
• notes (type: esriFieldTypeString, alias: Notes:, SQL Type: sqlTypeOther, length: 500, 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)
• 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)
• 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: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/5/2021 10:32:10 PM

Schema Last Edit Date: 7/5/2021 10:32:10 PM

Data Last Edit Date: 7/5/2021 10:32:10 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat