Baselight

Louisville Metro KY - Animal Services Activity Log

Louisville Metro Government

@usgov.louisville_metro_government_louisville_metro_ky_animal_6c1d3d71

Loading...
Loading...

About this Dataset

Louisville Metro KY - Animal Services Activity Log

Animal Services Provides for the care and control of animals in the Louisville Metro area, including pet licensing and pet adoption.

Data Dictionary:

case number Unique number generated when a call is stored in Chameleon. It always starts with "A" and then the last two digits of the year

case type The type of call received.

ALLEY CAT TRAP A call where an animal control officer and a member of Alley Cat Advocates works together to trap cats for TNR.
ASSIST Any call where assistance is needed from an animal control officer.
ASSIST ACO Any call where an animal control officer requires assistance from another animal control officer.
ASSIST FIRE Any call where fire requires assistance from the animal control officer.
ASSIST OTHER Any call where another emergency responder or government employee requires assistance from the animal control officer.
ASSIST POLICE Any call where police requires assistance from the animal control officer.
ASSIST SHERIFF Any call where an sheriff requires assistance from the animal control officer.
CONVERT A call created when a officer is converting a violation notice to a citation or a civil penalty for noncompliance.
CONVERT CITATION A call created when a officer is converting a violation notice to a citation or a civil penalty for noncompliance.
INVESTIGAT Any complaint where an investigation is needed that does not fit into a category already in use.
INVESTIGAT # POULTRY Any complaint where the caller states the owner has more poultry than allowed by the ordinance.
INVESTIGAT ABAN Any call for an owner leaving an animal for a period in excess of 24 hours, without the animal's owner or the owners’ designated caretaker providing all provisions of necessities.
INVESTIGAT ABUSE A cruelty/abuse/neglect situation where the health and safety of an animal is in jeopardy because of exposure to extreme weather, or other neglect/abuse factors. Examples include reports of beating, hitting, kicking, burning an animal, dog currently suffering from injury or illness and could die if treatment not provided
INVESTIGAT ANI ATACK Any call for an attack on an animal by another animal.
INVESTIGAT BARKLETTER Any barking complaint where the caller wishes to remain anonymous.
INVESTIGAT BITE Any call for a bite from an animal to a person
INVESTIGAT BITEF This is used when an animal control officer is following up on a bite investigation.
INVESTIGAT CHAINING Any complaint of a dog tethered illegally. The dispatcher must verify with the caller that the dog is not in distress and has necessities such as water, shelter etc.
INVESTIGAT CROWLET Any crowing complaint where the caller wishes to remain anonymous.
INVESTIGAT DOGFIGHT Any call where a person or persons in engaged in fighting dogs or have fought dogs in the past.
INVESTIGAT ENCLOSURE Any complaint made due to an animal not being confined securely in an enclosure. Examples being holes in fences, jumping a fence.
INVESTIGAT FECES LET Any complaint concerning a citizen not picking up after their animal where the caller wishes to remain anonymous.
INVESTIGAT FOLLOW UP This call is used when an animal control officer is following up on an investigation.
INVESTIGAT LIC LETTER Any complaint to check license not reported by the Health Dept. or supervisor.
INVESTIGAT NEGLI A cruelty/abuse/neglect situation where the health and safety of an animal is in jeopardy because of exposure to extreme weather, or other neglect/abuse factors. Examples include reports of failure to provide vet care, thin animal, no shelter , no water/food.
INVESTIGAT OTHER Any complaint where an investigation is needed that does not fit into a category already in use.
INVESTIGAT PET IN CAR Any complaint of an animal left in a car
INVESTIGAT TNR Any complaint of stray unowned cats
MAS A run made to meet a caller at Metro Animal Services
MAS TRAP Calls made by animal control officers when they are trapping cats for TNR.
NUISANCE BARK Any complaint on a barking dog where the complainant wants to be contacted and give a statement
NUISANCE CROWING Any crowing complaint where the complainant wants to be contacted and give a statement.
NUISANCE OTHER Any complaint other than barking, crowing, and restraint issues where the complainant wants to be contacted and give a statement.
NUISANCE RESTRAINT Any restraint complaint where the complainant wants to be contacted and give a statement.
OTHER This category is used for a variety of calls including picking up tags, speaking at events, calls that do not have a category already
OWNED Any call for an owned animal that does not fit in one of the other categories.
OWNED AGGRESSIVE Any aggressive loose animal that is owned. Aggressive behavior includes growling, showing teeth, lunging forward or charging at the person or other animal.
PERMIT INS A call for an animal control officer to conduct a permit inspection at a particular location.
RESCUE DOMESTIC A call for an domestic animal in distress, typically dogs and cats. These calls include dogs in lakes, animals in sewers or drains, cats in car engines, etc.
RESCUE LIVESTOCK A call for livestock in distress. This includes cattle stuck in ponds, cattle near a busy roadway, etc.
RESCUE OTHER A call for an domestic animal in distress, typically any other domestic animal or any call that does not fit in the other categories.
RESCUE WILDLIFE This call is typically used for a bat in someone's home or business.
STRAY Any call for an animal that is stray that does not fit a specific category
STRAY AGGRS Any aggressive loose animal that is stray. Aggressive behavior includes growling, showing teeth, lunging forward or charging at the person or other animal.
STRAY CONF Any call for an unowned, non-aggressive animal, excluding a bat, confined by a citizen that is not in a trap.
STRAY INJURED Any call for a sick/injured animal that is life threatening i.e. – vomiting or defecating blood, trouble breathing, unable to move, hit by a car, visible wounds, bleeding profusely, unable to stand. This includes sick or injured community cats.
STRAY POSS OWNED Any animal running loose that has an owner or possible owner. This is used when the caller does not want to give a statement or be contacted.
STRAY ROAM Any animal running loose that has no known owner, excluding cats. Will be closed out after 72 hours if no further calls and no call back number.
STRAY SICK Any call for a sick/injured animal that is life threatening i.e. – vomiting or defecating blood, trouble breathing, unable to move, hit by a car, visible wounds, bleeding profusely, unable to stand. This includes sick or injured community cats.
STRAY TRAP Any call for a dog or cat, excluding a bat, confined in a trap. This includes checking a trap set by LMAS daily.
SURRENDER A call to pick up an owned animal that the owner wants to surrender.
SURRENDER CAT A call to pick up an owned cat that the owner wants to surrender.
SURRENDER DOG A call to pick up an owned dog that the owner wants to surrender.
SURRENDER LITTER PUP A call to pick up an owned litter of puppies that the owner wants to surrender.
TRANSPORT A call for an animal control officer to take an item to a particular location. This includes picking up tags from vets, delivering traps that belong to a citizen, etc.
TRANSPORT ANIMAL A call to take an animal to a location. Examples include taking an animal to a vet, taking an animal to the Kentucky Humane Society, etc.
TRANSPORT DISMAS When an animal control officer returns or picks up a member of Dismas to or from the halfway house.
TRANSPORT HEAD TO LAB Specimens to go to the Health Department for rabies testing.
TRANSPORT JEFFERSON Dropping off or picking up an injured/sick animal from Jefferson Animal Hospital.
TRANSPORT NECROPSY When an animal control officer takes a body of animal to the University of Kentucky for a necropsy.
TRANSPORT OTHER A call for an animal control officer to take an item to a particular location. This includes picking up tags from vets, delivering traps that belong to a citizen, etc.
TRANSPORT SNIP A call to take a cat(s) to the SNIP Clinic for surgery, or pick up cat from the SNIP Clinic from surgery
TRANSPORT SNR A call where an animal control officer returns a cat to the field that has been spayed/neutered, vaccinated and eartipped as per the ordinance LMO 91.130
TRANSPORT TNR A call where an animal control officer returns a cat to the field that has been spayed/neutered, vaccinated and eartipped as per the ordinance LMO 91.130
VET NOTICE A run for an animal control officer to follow up on a violation notice that was issued for vet care where the owner has not shown compliance.
VET NOTICE FOLLOW UP A run for an animal control officer to follow up on a violation notice that was issued for vet care where the owner has not shown compliance.
WILDLIFE Any call for wildlife that does not fit in another category.
WILDLIFE AGGRS Any call for aggressive wildlife (MAS no longer responds to these calls. Callers must now contact the Kentucky Department of Fish and Wildlife)
WILDLIFE CONF Any call for a bat in a residence or a possible exposure to a bat.
WILDLIFE INJURED Any call for injured wildlife (MAS no longer responds to these calls. Callers must now contact the Kentucky Department of Fish and Wildlife)
WILDLIFE SICK Any call for sick wildlife (MAS no longer responds to these calls. Callers must now contact the Kentucky Department of Fish and Wildlife)
WILDLIFE TRAP Any call for a bat in a residence or a possible exposure to a bat.
XTRA SERVE Deliver a notice that an animal is at the shelter.
XTRA SERVE ALLEY CAT Calls to assist Alley Cat Advocates or to educate citizens on Alley Cat Advocates
XTRA SERVE COURT Calls requiring an officer to appear in court to testify or represent MAS. Can also be for an animal control officer to drop of citations, take out criminal complaints or other duties.
XTRA SERVE PDD Any call where an animal control officer delivers potentially dangerous dog paperwork to an owner or verifies that an owner has complied with the potentially dangerous dog requirements.
XTRA SERVE VIOL OTC A call where an animal control officer comes to the shelter to issue a violation notice to a citizen redeeming their pet.
YARD CHECK Any call requiring an officer to inspect a property for a variety of reasons such as court ordered, animal is at MAS

case animal type Type of animal by species associated with the run.

case city, state, zip code The city, state and zip code associated with the run.

owner id Unique identifying number assigned to the owner

animal id Unique identifying number assigned to each specific animal

result1, result2, result3, result4, result5, result6 - Codes that an animal control officer enters when they complete a run to describe what they did on the run.

APPRV Approved yard check
ARRST Arrest of subject
CHAIN Chaining notice left
CIVIL Civil penalty issued
COMP Completed
CVIOL Civil violation notice
DOA Dead on arrival
EACA Emailed Alley Cat Advocates
EDUC Educated the owner or complainant
EMAIL Emailed the owner or complainant
FAIL Failed a yard check
FU Follow up made
GOA Gone on arrival
IMPND Impounded an animal
LETR Letter sent the owner
MC Made contact
NOTIC Notice left
NSA No such address
NVS No violations seen
OPEN Open Inactive
OVER2 Over 2 days old
PA Patrolled the area
PHONE Officer called the owner or complainant
RPRT Report has been or will be taken
RSLVD Resolved
RTO Returned the animal to the owner
TTC Talk to the complainant
TTM Talk to a minor
TTO Talk to the owner
TTR Talk to the resident
UNIFM Uniform citation issued
UTC Unable to catch the animal
UTL Unable to locate the animal
UTMC Unable to make contact
UTR Unable to rescue
VIOL Violation notice issued
VOUCH Voucher issued
WARN Warning given
WARNN Warning notice issued

clerk The name of the employee who entered the call

officer The name of the officer that associated with the run.

call date The date and time the call was received and entered for the first time in Chameleon

new date The date and time the run was updated or a new sequence of the run was created

dispatched The date and time the run or sequence of a run was given to the animal control officer to be worked.

working The date and time the run or sequence of a run was being worked by an animal control officer.

completed The date and time the run or sequence of a run was finished working by an animal control officer.

animal type Type of animal by species that is associated with the run

sex Sex of the animal associated with the run.
F Female
M Male
N Neutered
S Spayed
U Unknown

bites - Does the animal have a bite reported to MAS
Y Yes
N No

color Color of the animal associated with the run.

breed Breed of the animal associated with the run.

Contact:

Adam Hamilton

Adam.Hamilton@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:32:32.960326
Tags: activity-log, animal-services, animals, lmas, log, louisville, louisville-metro, louisville-metro-animal-services, louisville-metro-ky

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_animal_6c1d3d71.table_1
  • 5.8 MB
  • 86094 rows
  • 27 columns
Loading...

CREATE TABLE table_1 (
  "casenumber" VARCHAR,
  "casetype" VARCHAR,
  "caseanimaltype" VARCHAR,
  "casecity" VARCHAR,
  "casestate" VARCHAR,
  "casezipcode" BIGINT,
  "ownerid" VARCHAR,
  "animalid" VARCHAR,
  "result1" VARCHAR,
  "result2" VARCHAR,
  "result3" VARCHAR,
  "result4" VARCHAR,
  "result5" VARCHAR,
  "result6" VARCHAR,
  "clerk" VARCHAR,
  "officer" VARCHAR,
  "calldate" VARCHAR,
  "newdate" VARCHAR,
  "dispatched" TIMESTAMP,
  "working" TIMESTAMP,
  "completed" TIMESTAMP,
  "animaltype" VARCHAR,
  "sex" VARCHAR,
  "bites" VARCHAR,
  "color" VARCHAR,
  "breed" VARCHAR,
  "objectid" BIGINT
);

Share link

Anyone who has the link will be able to view this.