Layer: DamageReports_ExportFeatures (ID:0)

View In: Map Viewer

Name: DamageReports_ExportFeatures

Display Field: landlord_name_first

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

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)
narrative (type: esriFieldTypeString, alias: Additional Narrative:Maximum of 1000 characters(no PII), SQL Type: sqlTypeOther, length: 1000, 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])
functional_utilities (type: esriFieldTypeString, alias: Are utilities functional?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
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)
assessor_first (type: esriFieldTypeString, alias: Assessor: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessor_last (type: esriFieldTypeString, alias: Assessor: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessor_phone (type: esriFieldTypeString, alias: Assessor: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
duration (type: esriFieldTypeString, alias: Basement: Duration (Days), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
basement_water_depth_inches (type: esriFieldTypeString, alias: Basement: Water Depth (inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [_1-3 (ankle): 1-3 (ankle)], [3-8 (calf): 3-8 (calf)], [18+ above the knee: 18+ above the knee], ... 2 more ...)
outlets (type: esriFieldTypeString, alias: Basement: Were electrical outlets submerged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
inaccessible_des (type: esriFieldTypeString, alias: Briefly describe the cause of inaccessibility:, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
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])
immediate_needs2 (type: esriFieldTypeString, alias: Check all that apply, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sfaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mfaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mhaffected_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the affected damage:, SQL Type: sqlTypeOther, length: 255, 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)
mfdestroyed_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the destroyed damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mhdestroyed_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the destroyed damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sfmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mfmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mhmajor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the major damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sfminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mfminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mhminor_qualifier (type: esriFieldTypeString, alias: Choose the option that best describes the minor damage:, SQL Type: sqlTypeOther, length: 255, 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], ... 1 more ...)
city (type: esriFieldTypeString, alias: City/Town:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aurora: Aurora], [Beecher: Beecher], [Bolingbrook: Bolingbrook], ... 34 more ...)
county (type: esriFieldTypeString, alias: County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cs_wd (type: esriFieldTypeString, alias: Crawl Space: Water Depth (inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
duration_cs (type: esriFieldTypeString, alias: Crawlspace: Duration (Days), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
outlets_cs (type: esriFieldTypeString, alias: Crawlspace: Were electrical outlets submerged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
created_date_prior (type: esriFieldTypeDate, alias: created_date_prior, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
created_user_prior (type: esriFieldTypeString, alias: created_user_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assessment_datetime (type: esriFieldTypeDate, alias: Date & Time of assessment:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
af_needs (type: esriFieldTypeString, alias: Do you, or anyone in your household, identify as a person with a disability?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
do_you_agree_to_share_the_infor (type: esriFieldTypeString, alias: do_you_agree_to_share_the_infor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
insurance_yesno (type: esriFieldTypeString, alias: Does the resident have insurance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
duration_ls (type: esriFieldTypeString, alias: duration_ls, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email_collector (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
inaccesible_homes_count (type: esriFieldTypeInteger, alias: Estimated number of inaccessible homes?, SQL Type: sqlTypeOther, nullable: true, editable: true)
dis_equip (type: esriFieldTypeString, alias: Has any of your disability equipment been lost or damaged as a result of this disaster?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
horaccuracy (type: esriFieldTypeDouble, alias: horaccuracy, SQL Type: sqlTypeOther, nullable: true, editable: true)
own_ins_desc (type: esriFieldTypeString, alias: If other, please describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
rent_ins_desc (type: esriFieldTypeString, alias: If other, please describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
disability_desc (type: esriFieldTypeString, alias: If other, please describe the disability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
disequip_desc (type: esriFieldTypeString, alias: If so, please list the lost or damaged disabilty item(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
disability_type (type: esriFieldTypeString, alias: If so, what is the nature of your disability?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
wd_unk (type: esriFieldTypeString, alias: If unknow please describe:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
utilities_desc (type: esriFieldTypeString, alias: If unknown please describe:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
essential_desc (type: esriFieldTypeString, alias: If Yes, check all that apply:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
geo_narrative (type: esriFieldTypeString, alias: If you are at the residence for which you're reporting damage, click the cross-hair icon.Alternatively, enter your address in the search bar, or click on the map, to place the pin where . Accurately reporting the location of the damaged structure will allow emergency management to direct resources appropriately. Please ensure your selected location matches the exact location of damaged property., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
impacted_units (type: esriFieldTypeInteger, alias: impacted_units, SQL Type: sqlTypeOther, nullable: true, editable: true)
incident_datetime (type: esriFieldTypeDate, alias: Incident Begin Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
incident_id (type: esriFieldTypeString, alias: incident_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primary_residence (type: esriFieldTypeString, alias: Is a primary residence (occupied at least 6 months per year)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
finished_basement (type: esriFieldTypeString, alias: Is Basement Finished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
mortgage (type: esriFieldTypeString, alias: Is there a mortgage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
essential_living (type: esriFieldTypeString, alias: Is this Basement an essential living space?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
json (type: esriFieldTypeString, alias: json, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
landlord_email_collector (type: esriFieldTypeString, alias: Landlord Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
landlord_name_first (type: esriFieldTypeString, alias: Landlord First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
landlord_name_last (type: esriFieldTypeString, alias: Landlord Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
landlord_phone (type: esriFieldTypeString, alias: Landlord Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
last_edited_date_prior (type: esriFieldTypeDate, alias: last_edited_date_prior, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
last_edited_user_prior (type: esriFieldTypeString, alias: last_edited_user_prior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
lastreporttype (type: esriFieldTypeString, alias: lastreporttype, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
lat (type: esriFieldTypeDouble, alias: lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
assessment_level (type: esriFieldTypeString, alias: Level of damage assessed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unaffected: Unaffected], [affected: Affected], [minor: Minor], ... 3 more ...)
damage_definitions (type: esriFieldTypeString, alias: Level of Damage Definitions:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
level_affected (type: esriFieldTypeInteger, alias: level_affected, 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_major (type: esriFieldTypeInteger, alias: level_major, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_minor (type: esriFieldTypeInteger, alias: level_minor, SQL Type: sqlTypeOther, nullable: true, editable: true)
level_unaffected (type: esriFieldTypeInteger, alias: level_unaffected, SQL Type: sqlTypeOther, nullable: true, editable: true)
ls_wd (type: esriFieldTypeString, alias: Living Space: Water Depth (inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
outlets_ls (type: esriFieldTypeString, alias: Living Space: Were electrical outlets submerged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
water_loc (type: esriFieldTypeString, alias: Location of water damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
lon (type: esriFieldTypeDouble, alias: lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
outsideground_wd (type: esriFieldTypeString, alias: Outside: Water Depth from Ground Up (inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [one: 1-3" (ankle)], [three: 3-18" (lower calf)], [eighteen: 18"+ above the knee])
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])
parcelid (type: esriFieldTypeString, alias: parcelid, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
immediateneeds_desc (type: esriFieldTypeString, alias: Please list any additional needs that are not listed above:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
repeat_count (type: esriFieldTypeInteger, alias: repeat_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
reportstatus (type: esriFieldTypeString, alias: reportstatus, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
name_first (type: esriFieldTypeString, alias: Resident First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name_last (type: esriFieldTypeString, alias: Resident Last Name, 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)
other_incident (type: esriFieldTypeString, alias: Specify Other:, 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, Coded Values: [IL: Illinois])
status (type: esriFieldTypeString, alias: Status of Assessment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [open: Open], [closed: Closed])
status_survey (type: esriFieldTypeString, alias: status_survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
res_add (type: esriFieldTypeString, alias: Street Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sec_add (type: esriFieldTypeString, alias: Suite/Apartment Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
survey_type (type: esriFieldTypeString, alias: survey_type, 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)
owner_insurance_type (type: esriFieldTypeString, alias: Type of Insurance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
renter_insurance_type (type: esriFieldTypeString, alias: Type of Insurance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
unit_suite (type: esriFieldTypeString, alias: unit_suite, 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)
user_type (type: esriFieldTypeString, alias: user_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
wd (type: esriFieldTypeString, alias: Water damage in the home:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
outside_wd (type: esriFieldTypeString, alias: Water damage outside the home:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
incident_type (type: esriFieldTypeString, alias: What event type caused the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
year_built (type: esriFieldTypeInteger, alias: What year was this residence constructed?, SQL Type: sqlTypeOther, nullable: true, editable: true)
utilities_type (type: esriFieldTypeString, alias: Which utilities are affected?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
zip (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/31/2024 4:16:58 PM

Schema Last Edit Date: 1/31/2024 4:16:58 PM

Data Last Edit Date: 1/31/2024 4:16:58 PM

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