Name: Survey_1
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
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":"CASPER WEB SURVEY V1.0","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: false
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)
- date1 (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- cluserNo (type: esriFieldTypeString, alias: Cluster Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- teamNo (type: esriFieldTypeString, alias: Survey Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- surveyNo (type: esriFieldTypeString, alias: Interviewed by Survey Team Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- intervewTime (type: esriFieldTypeString, alias: Interview Time of Day, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- initials (type: esriFieldTypeString, alias: Print Initials, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Instructions (type: esriFieldTypeString, alias: INSTRUCTIONS: Read the following questions to the resident. It is important to read the questions verbatim. Pay attention to the red italicized text – it is meant to provide question-level instruction to the surveyor and is not meant to be read to the resident., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q1_TypeOfStructure (type: esriFieldTypeString, alias: 1. What type of structure is the residence?
(Observation only), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10: Single Family Home], [20: Multiple Units (Apartment, Duplex)], [30: Mobile Home/Trailer/ RV/Pre-Fab], ... 1 more ...)
- Q1_Other (type: esriFieldTypeString, alias: Q1. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q2_Language (type: esriFieldTypeString, alias: 2. What language was this survey conducted in
(Observation only):
, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [11: English], [12: Spanish], [13: Cantonese], ... 3 more ...)
- Q2_Other (type: esriFieldTypeString, alias: Q2. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q3_HowManyPeople (type: esriFieldTypeInteger, alias: 3. How many people lived in this household immediately after the hurricane, including you? (List number), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q4_HowManyPeopleLiving (type: esriFieldTypeInteger, alias: 4. How many people are currently living in your household, including you? (List number), SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q51_lt2 (type: esriFieldTypeInteger, alias: Less than 2 years:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q52_2_10 (type: esriFieldTypeInteger, alias: 2-10 years:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q53_11_17 (type: esriFieldTypeInteger, alias: 11-17 years: , SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q54_18_29 (type: esriFieldTypeInteger, alias: 18-29 years: , SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q55_30_49 (type: esriFieldTypeInteger, alias: 30-49 years:, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q56_50_65 (type: esriFieldTypeInteger, alias: 50-65 years: , SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q57_gt65 (type: esriFieldTypeInteger, alias: 66 years or more: , SQL Type: sqlTypeOther, nullable: true, editable: true)
- Q6_DamageToHouse (type: esriFieldTypeString, alias: 6. Was there any damage to your home from Hurricane Harvey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes7: Yes], [no7: No STOP! Go to Question 7], [doesntknow7: Does not know STOP! Go to Question 7], ... 1 more ...)
- Q6a_SafeToLive (type: esriFieldTypeString, alias: 6a. Do you feel your home is CURRENTLY safe to live in?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q6b_SameBefore (type: esriFieldTypeString, alias: 6b. How close is your home to the condition it was in BEFORE the hurricane? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q6b1: Completely repaired], [Q6b2: Somewhat repaired], [Q6b3: Not repaired at all], ... 2 more ...)
- Q6c_DifficultRepair (type: esriFieldTypeString, alias: 6c. Have any of the following made it more difficult to repair your home? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q6c_specify (type: esriFieldTypeString, alias: Q6c. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q7a_Electricity (type: esriFieldTypeString, alias: Electricity?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q7b_Water (type: esriFieldTypeString, alias: Clean running water?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q7c_Cook (type: esriFieldTypeString, alias: The ability to cook food?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q7d_toilet (type: esriFieldTypeString, alias: Working toilets?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q8_Generator (type: esriFieldTypeString, alias: 8. Did your household use a generator after the hurricane (August 2017-now)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes9: Yes], [no9: No STOP! Go to Question 9], [doesntknow9: Does not know STOP! Go to Question 9], ... 1 more ...)
- Q8a_GeneratorWhere (type: esriFieldTypeString, alias: 8a. If your household used a generator, where was it used?(Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q8a1: Outside the house], [Q8a2: Inside the house], [Q8a3: Inside the garage], ... 1 more ...)
- Q8a_GeneratorWhere_Other (type: esriFieldTypeString, alias: Q8a. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q9_Mold (type: esriFieldTypeString, alias: 9. Have you or anyone in your household recently noticed mold or a moldy/musty odor in your home as a result of Hurricane Harvey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes10: Yes], [no10: No STOP! Go to Question 10], [doesntknow10: Does not know STOP! Go to Question 10], ... 1 more ...)
- Q9a_Mold_Action (type: esriFieldTypeString, alias: 9a. What actions are being taken to remove the moldy/musty odor? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q9b_Cleanup (type: esriFieldTypeString, alias: 9b. Are you or members of your household using any of the following protective or disinfectant items during cleanup? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q9b_Other (type: esriFieldTypeString, alias: Q9b. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q10_Choronic (type: esriFieldTypeString, alias: 10. Does anyone in your household have a chronic medical condition? (There is no need to provide specific details), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q11_MedicalCare (type: esriFieldTypeString, alias: 11. Since Hurricane Harvey, has it been more difficult for anyone in your household to get the medical care they need?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes12: Yes], [no12: No STOP! Go to Question 12 ], [doesntknow12: Does not know STOP! Go to Question 12 ], ... 1 more ...)
- Q11a_DifficultMedicalCare (type: esriFieldTypeString, alias: 11a. Have any of the following made it more difficult to CURRENTLY obtain medical care? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q11a_specify (type: esriFieldTypeString, alias: Q11a. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q12_Prescription (type: esriFieldTypeString, alias: 12. Since Hurricane Harvey, has it been more difficult for anyone in your household to get the prescription medication they need?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes13: Yes], [no13: No STOP! Go to Question 13 ], [doesntknow13: Does not know STOP! Go to Question 13 ], ... 1 more ...)
- Q12a_DifficultPrescription (type: esriFieldTypeString, alias: 12a. Have any of the following made it more difficult to CURRENTLY obtain prescription medication? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q12a_specify (type: esriFieldTypeString, alias: Q12a. Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q13_NewWorse (type: esriFieldTypeString, alias: 13. As a result of Hurricane Harvey, have you or members of your household experienced new or worsening: (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q14_Change (type: esriFieldTypeString, alias: 14. As a result of Hurricane Harvey, has anyone in your household experienced changes in behavior or feelings of depression, anxiety, hopelessness, or difficulty sleeping or concentrating? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q15_mental (type: esriFieldTypeString, alias: 15. Do you, or someone in your household, know how to access mental health services, if needed? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q15_1: Yes], [Q15_2: No STOP! Go to Question 17 ], [Q15_3: Does not know STOP! Go to Question 17 ], ... 1 more ...)
- Q16_AccessMental (type: esriFieldTypeString, alias: 16. As a result of Hurricane Harvey, have you or someone in your household accessed mental health services since the hurricane?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [noneed17: Did not need mental health services STOP! Go to Question 17 ], [yes17: Yes STOP! Go to Question 17 ], [no17: No], ... 2 more ...)
- Q16a_DifficultMental (type: esriFieldTypeString, alias: 16a. Have any of the following made it more difficult to obtain mental health care? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q17_mosquito (type: esriFieldTypeString, alias: 17. Do you know how to protect yourself and members of your household against diseases carried by mosquitoes? (if needed, provide examples of Zika, Chikungunya, West Nile Virus), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q18_CurrentlyHave (type: esriFieldTypeString, alias: 18. Does your household CURRENTLY have any of the following? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q19_GreatestNeed (type: esriFieldTypeString, alias: 19. Currently, what is your household's greatest need? (Record response verbatim), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q19a_money4 (type: esriFieldTypeString, alias: Ask question 19a IF their greatest need is financial (e.g. money, cash, or extra income). Write N/A if they don't have any financial needs: 19a. What do you need the money for? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q20_howPrepared (type: esriFieldTypeString, alias: 20. How prepared do you feel your household is now to handle another emergency? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q20_1: Well prepared], [Q20_2: Somewhat prepared], [Q20_3: Not at all prepared], ... 2 more ...)
- Q21_discussed (type: esriFieldTypeString, alias: 21. Have you and/or members of your household discussed what you would do in an emergency? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q22_communicate (type: esriFieldTypeString, alias: 22. In an emergency, which of the following ways would you use to communicate with family and friends? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q22_specify (type: esriFieldTypeString, alias: Q22. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q23_informationSource (type: esriFieldTypeString, alias: 23. In an emergency, which would be your main sources of information for disaster updates and/or evacuation notices? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q23_specify (type: esriFieldTypeString, alias: Q23. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q24_5daySupplyWater (type: esriFieldTypeString, alias: 24. Does your household have an emergency 5-day supply of water? (1 gallon of water per person per day), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q25_5daySupplyFood (type: esriFieldTypeString, alias: 25. Does your household have an emergency 5-day supply of food? (Enough non-perishable food to last the household 5 days), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [doesntknow: Does not know], ... 1 more ...)
- Q26_5daySupplyMedication (type: esriFieldTypeString, alias: 26. Does your household have an emergency 5-day supply of any needed prescription medication(s)? (Enough prescription medication to last 5 days), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q26_1: Does not need prescription medication], [Q26_2: Yes], [Q26_3: No], ... 2 more ...)
- Q26a_no5daySupply (type: esriFieldTypeString, alias: If the respondent chose "Yes" to question 24 and 25 and either "Yes" or "Does not need prescription medication" to question 26, choose the last option in Question 26a "We have a 5 day supply of food, water and medication (if needed)". 26a. If your household does NOT have an emergency 5-day supply of either food, water and/or medication(s), what is the reason? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q26a3: Did not know it was important], [Q26a4: Lack of storage space], [Q26a5: Cost of supplies], ... 4 more ...)
- Q26a_specify (type: esriFieldTypeString, alias: Q26a. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q27_evacuate (type: esriFieldTypeString, alias: 27. If your household were asked to evacuate, would you: (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q27_3: Evacuate STOP! Go to Question 27a ], [Q27_4: Not evacuate STOP! Go to Question 27b ], [Q27_5: Decide whether or not to evacuate based on the specific situation STOP! Go to Question 28 ], ... 2 more ...)
- Q27a_evacuate (type: esriFieldTypeString, alias: 27a. If you chose to evacuate, where would you go until you could return home? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q27a_specify (type: esriFieldTypeString, alias: Q27a. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q27b_evacuate (type: esriFieldTypeString, alias: 27b. If you chose NOT to evacuate, why? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q27b_specify (type: esriFieldTypeString, alias: Q27b. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q28_pet (type: esriFieldTypeString, alias: 28. If your household were asked to evacuate, what would you do with your pets/animals? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Q28_3: Household does not have pets/animals STOP! Go to Question 29 ], [Q28_4: Take it/them with you], [Q28_5: Leave it/them at home with food and water], ... 4 more ...)
- Q28_specify (type: esriFieldTypeString, alias: Q28. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q28a_petNeed (type: esriFieldTypeString, alias: 28a. Are your pets currently in need of any of the following? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q28a_specify (type: esriFieldTypeString, alias: Q28a. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q29_community (type: esriFieldTypeString, alias: 29. Are you or members of your household active in any of the following communities? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q29_specify (type: esriFieldTypeString, alias: Q29. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q30_hcph (type: esriFieldTypeString, alias: 30. Since Hurricane Harvey, has your household received any of the following services from Harris County Public Health? (Read all choices), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Q30_specify (type: esriFieldTypeString, alias: Q30. Please Specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- InterviewerComment (type: esriFieldTypeString, alias: Interviewer Comments , 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:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/24/2020 9:05:19 PM
Schema Last Edit Date: 2/24/2020 9:05:19 PM
Data Last Edit Date: 2/24/2020 9:05:19 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat