Name: DWSD_Rain_Event_Survey_Form

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":"DWSD Rain Event Survey Form","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)
• DWSD_ClaimNo (type: esriFieldTypeString, alias: DWSD Claim Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DWSD_ClaimDate (type: esriFieldTypeDate, alias: DWSD Claim Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ClaimFormNote (type: esriFieldTypeString, alias: An individual who has sustained property damage or has been injured as a result of a sewage disposal system event must provide written notice of the event within 45 days after the date the damage or injury occurred, or in the exercise of reasonable diligence should have been discovered. Failure to provide proper notice may bar your claim., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ClaimDate (type: esriFieldTypeDate, alias: Claim Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address of affected property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zip (type: esriFieldTypeInteger, alias: Zip Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrossStreet1 (type: esriFieldTypeString, alias: Cross Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrossStreet2 (type: esriFieldTypeString, alias: Cross Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Explanation (type: esriFieldTypeString, alias: Explain in detail what happened, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Explanation2 (type: esriFieldTypeString, alias: Explanation (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Explanation3 (type: esriFieldTypeString, alias: Explanation (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Explanation4 (type: esriFieldTypeString, alias: Explanation (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DescrClaim (type: esriFieldTypeString, alias: Itemized Description of Claim, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim2 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim2 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim3 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim3 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim4 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim4 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim5 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim5 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim6 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim6 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim7 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim7 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim8 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim8 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DescrClaim9 (type: esriFieldTypeString, alias: Description of Claim (continued, if needed). If additional space needed, submit as an attachment., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CostClaim9 (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CostAmount (type: esriFieldTypeDouble, alias: Total Amount of Claim, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PropertyType (type: esriFieldTypeString, alias: Does this claim involve flooding of your home or business?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Home: Home], [Business: Business])
• Basement (type: esriFieldTypeString, alias: Do you have a basement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• BasementDepthFeet (type: esriFieldTypeInteger, alias: Feet (1 - 19), SQL Type: sqlTypeOther, nullable: true, editable: true)
• BasementDepthInches (type: esriFieldTypeInteger, alias: Inches (1 - 11), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SewerBackUp (type: esriFieldTypeString, alias: If you had flooding from a sewer backup, did it rain that day?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SewerBackUpExplain (type: esriFieldTypeString, alias: If you had flooding for reason other than a sewer backup, explain:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ContactDWSD (type: esriFieldTypeString, alias: Did you contact DWSD about the incident?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ContactDWSDNote (type: esriFieldTypeString, alias: If Yes, provide date, time, and phone number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ContactDWSDDate (type: esriFieldTypeDate, alias: Date & Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ContactDWSDPhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• RespondDWSD (type: esriFieldTypeString, alias: Did someone from DWSD respond to the call(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• RespondDWSDExplain (type: esriFieldTypeString, alias: If Yes, what did they do?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• repeat_PeopleAffect_count (type: esriFieldTypeString, alias: repeat_PeopleAffect_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Select ownership type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [own: Own], [buying: Buying], [rent: Rent])
• PurchasePrice (type: esriFieldTypeDouble, alias: Purchase Price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PurchaseYear (type: esriFieldTypeInteger, alias: Year of Purchase, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RentLength (type: esriFieldTypeDate, alias: How long have you rented this home?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RentLLname (type: esriFieldTypeString, alias: Landlord's Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RentLLaddress (type: esriFieldTypeString, alias: Landlord's Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RentLLcity (type: esriFieldTypeString, alias: Landlord's City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RentLLstate (type: esriFieldTypeString, alias: Landlord's State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RentLLzip (type: esriFieldTypeInteger, alias: Landlord's Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• repeat_Witness_count (type: esriFieldTypeString, alias: repeat_Witness_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceCov (type: esriFieldTypeString, alias: Do you have flood insurance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• InsuranceName (type: esriFieldTypeString, alias: Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsurancePolicyNo (type: esriFieldTypeString, alias: Policy Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceAddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceCity (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceState (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceZip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsuranceAgent (type: esriFieldTypeString, alias: Name of Agent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsurancePhone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• InsuranceDeductible (type: esriFieldTypeDouble, alias: Amount of Deductible, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsuranceType (type: esriFieldTypeString, alias: Type of Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceDamages (type: esriFieldTypeString, alias: Have you filed a claim with your insurance company for damages?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• InsuranceDamagesNo (type: esriFieldTypeString, alias: If No, give reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceDamagesYesPaid (type: esriFieldTypeString, alias: If Yes, has the insurance company paid any portion of the damage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• InsuranceDamagesYesAmt (type: esriFieldTypeDouble, alias: If Yes, indicated the amount the insurance company paid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InsuranceClaimNo (type: esriFieldTypeString, alias: What is the insurance claim number?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InsuranceDamagesNoPaid (type: esriFieldTypeString, alias: If No, what reason did they give you for turning down your claim?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubSRN (type: esriFieldTypeDouble, alias: Service Request Number as provided by DWSD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ImproveDetroit (type: esriFieldTypeDouble, alias: Improve Detroit Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SubName (type: esriFieldTypeString, alias: Submitter's Name (First, Middle Initial, Last), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubAge (type: esriFieldTypeInteger, alias: Age (1 - 129), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SubSpouseName (type: esriFieldTypeString, alias: Spouse's Name (First, Middle Initial, Last), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubSpouseAge (type: esriFieldTypeInteger, alias: Age (1 - 129), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SubHomePhone (type: esriFieldTypeString, alias: Home Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• SubDaytimePhone (type: esriFieldTypeString, alias: Daytime Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• SubAddress (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubCity (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubState (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubZip (type: esriFieldTypeInteger, alias: Zip, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Certify (type: esriFieldTypeString, alias: I hereby certify that the information provided on this form is true and accurate to the best of my knowledge., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes])
• SubSign (type: esriFieldTypeString, alias: Claimaint's Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubDate (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PropDamChoices (type: esriFieldTypeString, alias: Choose the following to provide attachments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• repeat_PropDamEstimates_count (type: esriFieldTypeString, alias: repeat_PropDamEstimates_count, 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:

Relationships:

• DWSD_Rain_Event_Survey_Form_repeat_PeopleAffect (1) -- Related To: repeat_PeopleAffect (1)
• DWSD_Rain_Event_Survey_Form_repeat_Witness (2) -- Related To: repeat_Witness (2)
• DWSD_Rain_Event_Survey_Form_repeat_PropDamPhotos (3) -- Related To: repeat_PropDamPhotos (3)
• DWSD_Rain_Event_Survey_Form_repeat_PropDamEstimates (4) -- Related To: repeat_PropDamEstimates (4)
• DWSD_Rain_Event_Survey_Form_repeat_PropDamReceipts (5) -- Related To: repeat_PropDamReceipts (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/22/2022 8:06:50 PM

Schema Last Edit Date: 10/22/2022 8:06:50 PM

Data Last Edit Date: 10/22/2022 8:06:50 PM

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