Name: PDA123_2023
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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":"PDA123 (Preliminary Damage Assessment)","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)
- training (type: esriFieldTypeString, alias: Training or Disaster/Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Training: Training], [Disaster/Event: Disaster/Event])
- address (type: esriFieldTypeString, alias: Address of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- region (type: esriFieldTypeString, alias: Choose Your Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [North: North], [Central: Central], [South: South], ... 1 more ...)
- agency (type: esriFieldTypeString, alias: Choose Your County/Tribe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- municipality (type: esriFieldTypeString, alias: Choose Your City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- incidentid (type: esriFieldTypeString, alias: incidentid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- label (type: esriFieldTypeString, alias: Incident/Disaster Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Severe Weather - Flooding: Severe Weather - Flooding], [Severe Weather - Tornado: Severe Weather - Tornado], [Severe Weather - Winter Storm: Severe Weather - Winter Storm], ... 5 more ...)
- incident_contact_first (type: esriFieldTypeString, alias: Contact First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- incident_contact_last (type: esriFieldTypeString, alias: Contact Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- incident_contact_phone (type: esriFieldTypeString, alias: Contact Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- incident_contact_email (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- program_assessment_type (type: esriFieldTypeString, alias: Which Program Assessment Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Individual Assistance: Individual Assistance], [Public Assistance: Public Assistance], [SBA - Residential: SBA - Residential], ... 1 more ...)
- level_of_damage_assessed (type: esriFieldTypeString, alias: Level of Damage Assessed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Affected: Affected], [Minor: Minor], [Major: Major], ... 2 more ...)
- ia_owner_or_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_coverage (type: esriFieldTypeString, alias: Insurance Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Homeowner: Homeowner], [Renters: Renters], [Flood (Structure): Flood (Structure)], ... 3 more ...)
- type_of_dwelling (type: esriFieldTypeString, alias: Property Information (Type of Property), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Single Family: Single Family], [Multi-Family: Multi-Family], [Mobile: Mobile], ... 2 more ...)
- type_of_construction (type: esriFieldTypeString, alias: Property Information (Type of Construction), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Masonry: Masonry], [Wood Frame: Wood Frame], [Mobile: Mobile], ... 2 more ...)
- primary_residence (type: esriFieldTypeString, alias: Primary Residence?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- low_income (type: esriFieldTypeString, alias: Low Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- veteran (type: esriFieldTypeString, alias: United States Veteran, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- habitability (type: esriFieldTypeString, alias: Habitability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- AFN (type: esriFieldTypeString, alias: Disabilities, Access or Functional Need Residents, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilities_non_function (type: esriFieldTypeString, alias: utilities_non_function, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- Source_of_Damage (type: esriFieldTypeString, alias: Source of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fire: Fire], [Flood: Flood], [Debris: Debris], ... 4 more ...)
- ia_damage_cost (type: esriFieldTypeDouble, alias: Estimated Damage Cost $, SQL Type: sqlTypeOther, nullable: true, editable: true)
- house_income (type: esriFieldTypeDouble, alias: Approximate Household Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
- house_members (type: esriFieldTypeInteger, alias: Number of Household Members, SQL Type: sqlTypeOther, nullable: true, editable: true)
- comments (type: esriFieldTypeString, alias: Other/Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pa_applicant_name (type: esriFieldTypeString, alias: Agency or Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pa_type_of_assessment (type: esriFieldTypeString, alias: Which type of assessment would you like to submit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Debris Removal (A): Debris Removal (A)], [Emergency Protective Measures (B): Emergency Protective Measures (B)], [Roads and Bridges (C): Roads and Bridges (C)], ... 4 more ...)
- pa_facility_common_name (type: esriFieldTypeString, alias: Common Place Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pa_facility_damage_description (type: esriFieldTypeString, alias: Briefly describe the damage to the area of facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- pa_cost_of_repair (type: esriFieldTypeDouble, alias: Site Repair Estimate $, SQL Type: sqlTypeOther, nullable: true, editable: true)
- percent_complete (type: esriFieldTypeInteger, alias: Repair Percent Complete %, SQL Type: sqlTypeOther, nullable: true, editable: true)
- out_of_service (type: esriFieldTypeString, alias: Out of Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Damaged, but in Service: Damaged, but in Service], [Limited Service Available: Limited Service Available], [Emergency Service Only: Emergency Service Only], ... 1 more ...)
- facility_insured (type: esriFieldTypeString, alias: Is the Facility Insured?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- pa_comments (type: esriFieldTypeString, alias: Other/Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sbares_owner_or_renter (type: esriFieldTypeString, alias: Owner or Renter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Owner: Owner], [Renter: Renter], [Unknown: Unknown])
- level_of_damage_assessed_SBA (type: esriFieldTypeString, alias: Level of Damage Assessed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Affected: Affected], [Minor: Minor], [Major: Major], ... 2 more ...)
- type_of_dwelling_SBA (type: esriFieldTypeString, alias: Type of Dwelling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Single Family: Single Family], [MH: MH], [Multi-Family: Multi-Family])
- Units (type: esriFieldTypeInteger, alias: Multi-Family: # of units, SQL Type: sqlTypeOther, nullable: true, editable: true)
- insurance_coverage_SBA (type: esriFieldTypeString, alias: Homeowners Insurance to cover this loss, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- insurance_coverage_SBA_Flood (type: esriFieldTypeString, alias: Flood Insurance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- property_in_flood_zone (type: esriFieldTypeString, alias: Property is in a Flood Zone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- water_height_first_floor (type: esriFieldTypeInteger, alias: Water Height above 1st Finished Floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- basement_finished_unfinished (type: esriFieldTypeString, alias: Basement Finished or Unfinished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Finished: Finished], [Unfinished: Unfinished])
- water_height_basement (type: esriFieldTypeInteger, alias: Water Height in Basement, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_dwelling (type: esriFieldTypeInteger, alias: FMV Dwelling, SQL Type: sqlTypeOther, nullable: true, editable: true)
- estimated_real_estate_loss (type: esriFieldTypeInteger, alias: Estimated Real Estate (R/E) Loss to Home ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- insurance_received_expected (type: esriFieldTypeInteger, alias: Amount of Insurance Received/Expected for Home ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_personal_property (type: esriFieldTypeInteger, alias: FMV of Personal Property (PP) to Home ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- personal_property_loss (type: esriFieldTypeInteger, alias: Estimated Personal Property (PP) Loss to Home ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- insurance_received_expected_pp (type: esriFieldTypeInteger, alias: Amount of Insurance Received/Expected for Personal Property (PP) ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_land (type: esriFieldTypeInteger, alias: FMV Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
- estimated_loss_land_well_septic (type: esriFieldTypeInteger, alias: Estimated Loss for Land, Well, Septic System, Fencing, Pool ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- amount_recieved_expected_land (type: esriFieldTypeInteger, alias: Amount of Received/Expected for Land ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- notes_res (type: esriFieldTypeString, alias: Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Name (type: esriFieldTypeString, alias: Name of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TypeofBusiness (type: esriFieldTypeString, alias: Type of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sbabus_owner_or_renter (type: esriFieldTypeString, alias: Owner or Renter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Owner: Owner], [Renter: Renter], [Unknown: Unknown])
- type_of_property_SBA (type: esriFieldTypeString, alias: Type of Property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Commercial: Commercial], [SFR Rental: SFR Rental], [Multi-Family: Multi-Family])
- Units_bus (type: esriFieldTypeInteger, alias: Multi-Family: # of units, SQL Type: sqlTypeOther, nullable: true, editable: true)
- level_of_damage_assessed_SBA_Bu (type: esriFieldTypeString, alias: Level of Damage Assessed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Affected: Affected], [Minor: Minor], [Major: Major], ... 2 more ...)
- insurance_coverage_SBA_Bus (type: esriFieldTypeString, alias: Standard Business Insurance Policy (BOP), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- insurance_coverage_SBA_Bus_Floo (type: esriFieldTypeString, alias: Flood Insurance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- property_in_flood_zone_bus (type: esriFieldTypeString, alias: Property is in a Flood Zone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- water_height_first_floor_bus (type: esriFieldTypeInteger, alias: Water Height above 1st Finished Floor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- basement_finished_unfinished_bu (type: esriFieldTypeString, alias: Basement Finished or Unfinished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Finished: Finished], [Unfinished: Unfinished])
- water_height_basement_bus (type: esriFieldTypeInteger, alias: Water Height in Basement, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_land_bus (type: esriFieldTypeInteger, alias: FMV Land, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_commercial_building (type: esriFieldTypeInteger, alias: FMV of Commercial Building ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- estimated_real_estate_loss_bus (type: esriFieldTypeInteger, alias: Estimated Real Estate (R/E) loss to Commercial Building ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- insurance_received (type: esriFieldTypeInteger, alias: Amount of Insurance Received for Real Estate (R/E)($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- fmv_business (type: esriFieldTypeInteger, alias: FMV of Business Contents ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- estimated_business_content_loss (type: esriFieldTypeInteger, alias: Estimated Business Contents Loss ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- amount_recieved_businesscontent (type: esriFieldTypeInteger, alias: Amount of Insurance Received for Business Contents, SQL Type: sqlTypeOther, nullable: true, editable: true)
- amount_insurancecoverage_busc (type: esriFieldTypeInteger, alias: Amount of Insurance Coverage for Business Contents ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- notes_bus (type: esriFieldTypeString, alias: Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_1_name (type: esriFieldTypeString, alias: photo_attachment_1_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_2_name (type: esriFieldTypeString, alias: photo_attachment_2_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_3_name (type: esriFieldTypeString, alias: photo_attachment_3_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_4_name (type: esriFieldTypeString, alias: photo_attachment_4_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_5_name (type: esriFieldTypeString, alias: photo_attachment_5_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_6_name (type: esriFieldTypeString, alias: photo_attachment_6_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_7_name (type: esriFieldTypeString, alias: photo_attachment_7_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- photo_attachment_8_name (type: esriFieldTypeString, alias: photo_attachment_8_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- da_status (type: esriFieldTypeString, alias: da_status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- pda_datetime (type: esriFieldTypeDate, alias: Assessment Date and Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- subscribername (type: esriFieldTypeString, alias: subscribername, 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)
- submitted_by_first_name (type: esriFieldTypeString, alias: Submitted By First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- submitted_by_last_name (type: esriFieldTypeString, alias: Submitted By Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- submitted_by_phone_number (type: esriFieldTypeString, alias: Submitted By Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- submitted_by_email (type: esriFieldTypeString, alias: Submitted By Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county_rep_first_name (type: esriFieldTypeString, alias: County Representative First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county_rep_last_name (type: esriFieldTypeString, alias: County Representative Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county_rep_phone_number (type: esriFieldTypeString, alias: County Representative Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county_rep_email (type: esriFieldTypeString, alias: County Representative Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_rep_first_name (type: esriFieldTypeString, alias: State Representative First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_rep_phone_number (type: esriFieldTypeString, alias: State Representative Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- state_rep_email (type: esriFieldTypeString, alias: State Representative Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/6/2025 8:15:04 PM
Schema Last Edit Date: 5/6/2025 8:15:04 PM
Data Last Edit Date: 5/6/2025 8:13:54 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat