Readme
Updated 7 months ago
‧ Indexed 1 hour ago
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 |
|---|---|---|---|---|
| Officer_ID | officer_id | officer_id | Text | Unique number assigned to every Animal Service Officer in Database. |
| Cancel_Reason | cancel_reason | cancel_reason | Text | Reason an activity was cancelled. |
| User_ID | user_id | user_id | Text | Unique ID number assigned to the staff person who entered the record. |
| Activity_Quantity_4 | activity_quantity_4 | activity_quantity_4 | Number | Count of the respective result field (Activity Result 4) |
| Street_Address | street_address | street_address | Text | Full address of the location in which the activity or service request occurred. |
| Animal_Intake_ID | animal_intake_id | animal_intake_id | Text | Unique number assigned to each animal when their record is created in the database. |
| Activity_Quantity_2 | activity_quantity_2 | activity_quantity_2 | Number | Count of the respective result field (Activity Result 2) |
| Created_Date_Time | created_date_time | created_date_time | Calendar date | Date and time a record was created. |
| city | city | city | Text | The city in which an activity or service request occurred. |
| Activity_Result_3 | activity_result_3 | activity_result_3 | Text | Notes for work completed |
| Mapsco | mapsco | mapsco | Text | Unique code used in GIS mapping to more accurately identify a location. |
| Activity_Result_1 | activity_result_1 | activity_result_1 | Text | Notes for work completed |
| 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_Quantity_3 | activity_quantity_3 | activity_quantity_3 | Number | Count of the respective result field (Activity Result 3) |
| Activity_subtype | activity_subtype | activity_subtype | Text | Sub-category that further narrows the purpose of the activity or service request. |
| Census_Tract | census_tract | census_tract | Number | Unique area mapped out by the federal government for purposes of the census. |
| Activity_Result_5 | activity_result_5 | activity_result_5 | Text | Notes for work completed |
| State | state | state | Text | The state in which an activity or service request occurred. |
| Final_Activity_Quantity | final_activity_quantity | final_activity_quantity | Number | Count of the respective result field (Final Activity Result) |
| Street_Direction | street_direction | street_direction | Text | Direction of the street on which the activity or service request occurred. |
| Call_Date_Time | call_date_time | call_date_time | Calendar date | Date and time a call was received. |
| 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_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. |
| Apartment | apartment | apartment | Text | The unit number at the address where a service request or activity occurred. |
| Activity_Sequence | activity_sequence | activity_sequence | Number | Sequence starts with 1 usually then a follow up sequence is created until activity is completed. |
| 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_Result_2 | activity_result_2 | activity_result_2 | Text | Notes for work completed |
| Working_Date | working_date | working_date | Text | Date and time officer started working on the assigned activity |
| Street_Number | street_number | street_number | Number | House, apartment, or building number at which the activity or service request occurred. |
| Street_Name | street_name | street_name | Text | Street on which the activity or service request occurred. |
| Month | month | month | Text | Month the record was created. |
| Activity_Status | activity_status | activity_status | Text | Status used to track progress of activity. |
| Final_Citation_Quantity | final_citation_quantity | final_citation_quantity | Number | Count of the citations for Activity or SR Number |
| 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. |
| 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. |
| Zip_Code | zip_code | zip_code | Number | The five digit zip code in which an activity or service request occurred. |
| 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. |
| 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. |
| Animal_Type | animal_type | animal_type | Text | Animal category: dog, cat, wildlife, other, etc. |
| 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. |
| Activity_Result_4 | activity_result_4 | activity_result_4 | Text | Notes for work completed |
| Activity_Quantity_5 | activity_quantity_5 | activity_quantity_5 | Number | Count of the respective result field (Activity Result 5) |
| Activity_Comment | activity_comment | activity_comment | Text | Additional staff notes. |
Upstream Metadata