Animal Field Data Fiscal Year 2020 - 2021
Animal Field Data Fiscal Year 2020 - 2021
This dataset is pulled directly from Dallas Animal Services' Chameleon Database, which is used to track shelter and field operations, animal inventory and movement, animal intake and outcome, animal medical records, animal behavior observations, and animal microchip information. This dataset reflects data from October 1, 2020 to current-date and will close September 30, 2021. Data is subject to correction after the fact if data entry errors are detected or changes are made to fields within the database and therefore, data can have slight variances over time. Dallas Animal Services (DAS) will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this dataset. DAS publishes official monthly data fact sheets with verified data on its website at www.bedallas90.org.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Month | month | month | Text | Month the record was created. |
| Call_Date_Time | call_date_time | call_date_time | Calendar date | Date and time a call was received. |
| Cancel_Reason | cancel_reason | cancel_reason | Text | Reason an activity was cancelled. |
| Activity_Result_2 | activity_result_2 | activity_result_2 | Text | Notes for work completed |
| Activity_Sequence | activity_sequence | activity_sequence | Number | Sequence starts with 1 usually then a follow up sequence is created until activity is completed. |
| Apartment | apartment | apartment | Text | The unit number at the address where a service request or activity occurred. |
| Street_Number | street_number | street_number | Number | House, apartment, or building number at which the activity or service request occurred. |
| Service_Request_Number | service_request_number | service_request_number | Text | Unique number assigned to a service request by Salesforce when it is submitted by a resident through 3-1-1. |
| Activity_subtype | activity_subtype | activity_subtype | Text | Sub-category that further narrows the purpose of the activity or service request. |
| Final_Citation_Quantity | final_citation_quantity | final_citation_quantity | Number | Count of the citations for Activity or SR Number |
| Activity_Quantity_1 | activity_quantity_1 | activity_quantity_1 | Number | Count of the respective result field (Activity Result 1) |
| Animal_Count | animal_count | animal_count | Number | Number of animals involved in a specific activity or service request. |
| User_ID | user_id | user_id | Text | Unique ID number assigned to the staff person who entered the record. |
| Officer_ID | officer_id | officer_id | Text | Unique number assigned to every Animal Service Officer in Database. |
| Activity_Comment | activity_comment | activity_comment | Text | Additional staff notes. |
| Activity_Result_5 | activity_result_5 | activity_result_5 | Text | Notes for work completed |
| Animal_Description | animal_description | animal_description | Text | Field in which DAS Staff can enter notes related to the appearance of the animal involved in a service request or activity. |
| Animal_Type | animal_type | animal_type | Text | Animal category: dog, cat, wildlife, other, etc. |
| Activity_Quantity_5 | activity_quantity_5 | activity_quantity_5 | Number | Count of the respective result field (Activity Result 5) |
| Activity_Result_4 | activity_result_4 | activity_result_4 | Text | Notes for work completed |
| Zip_Code | zip_code | zip_code | Number | The five digit zip code in which an activity or service request occurred. |
| Street_Name | street_name | street_name | Text | Street on which the activity or service request occurred. |
| State | state | state | Text | The state in which an activity or service request occurred. |
| Working_Date | working_date | working_date | Text | Date and time officer started working on the assigned activity |
| Final_Activity_Result | final_activity_result | final_activity_result | Text | Notes for work completed |
| Activity_Number | activity_number | activity_number | Text | Unique number assigned to an activity related to a service request. |
| Complete_Date | complete_date | complete_date | Calendar date | Date the activity was completed. |
| Street_Type | street_type | street_type | Text | Identifies the kind of street on which the activity or service request occurred (ex. Drive or avenue). |
| Activity_Priority | activity_priority | activity_priority | Number | Priority assigned to the activity or service request based on pre-determined guidelines reflecting the urgency of the matter. |
| Tag_Number | tag_number | tag_number | Text | Unique number assigned to a microchip implanted in an animal for identification. |
| Activity_Type | activity_type | activity_type | Text | Category that identifies the purpose of the activity or service request. |
| Final_Activity_Quantity | final_activity_quantity | final_activity_quantity | Number | Count of the respective result field (Final Activity Result) |
| Activity_Status | activity_status | activity_status | Text | Status used to track progress of activity. |
| Year | year | year | Text | City of Dallas Fiscal Year the record was created. |
| Dispatch_Date | dispatch_date | dispatch_date | Text | Date and time activity was dispatched. |
| Activity_Quantity_4 | activity_quantity_4 | activity_quantity_4 | Number | Count of the respective result field (Activity Result 4) |
| Activity_Result_3 | activity_result_3 | activity_result_3 | Text | Notes for work completed |
| Census_Tract | census_tract | census_tract | Number | Unique area mapped out by the federal government for purposes of the census. |
| city | city | city | Text | The city in which an activity or service request occurred. |
| Street_Direction | street_direction | street_direction | Text | Direction of the street on which the activity or service request occurred. |
| Created_Date_Time | created_date_time | created_date_time | Calendar date | Date and time a record was created. |
| Activity_Quantity_2 | activity_quantity_2 | activity_quantity_2 | Number | Count of the respective result field (Activity Result 2) |
| Animal_Intake_ID | animal_intake_id | animal_intake_id | Text | Unique number assigned to each animal when their record is created in the database. |
| Street_Address | street_address | street_address | Text | Full address of the location in which the activity or service request occurred. |
| Activity_Quantity_3 | activity_quantity_3 | activity_quantity_3 | Number | Count of the respective result field (Activity Result 3) |
| Council_District | council_district | council_district | Number | Unique area mapped out by the City of Dallas that is represented by a specific City Council Office and Member. |
| Activity_Result_1 | activity_result_1 | activity_result_1 | Text | Notes for work completed |
| Mapsco | mapsco | mapsco | Text | Unique code used in GIS mapping to more accurately identify a location. |