Name: Draft_IA_Business_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:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Draft IA Business 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:
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)
- 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 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: [minor: Minor (less than 40% uninsured loss due to physical damage)], [major: Major (40% to 100% uninsured loss due to physical damage)], [inaccessible: Inaccessible], ... 1 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)
- 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: Esimated 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)
- 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 business 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 business owner or renter available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- 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])
- tribeconfirm (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])
- 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 ...)
- 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])
- 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)
- 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])
- 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: Esimtated 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)
- firstconstructiondate (type: esriFieldTypeInteger, alias: Estimated first construction date of site, SQL Type: sqlTypeOther, nullable: true, editable: true)
- 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)
- 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)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/1/2025 11:24:22 PM
Schema Last Edit Date: 4/1/2025 11:24:22 PM
Data Last Edit Date: 4/1/2025 11:24:22 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat