Transcript Keeping Fido on a Short Leash

Going Paperless at Rabies Clinics
Chris Crawford, Ph.D.
Water Resources Specialist
Cattaraugus County Health Department
Eric’s Brain – 8/2010
I sense an
opportunity. Let’s
Investigate
Driving Factors
8/2010
• Program Efficiencies
-
Manual forms /
certificates
Data retrieval / search
• Changes in Ag. & Mkts. Law (January, 1, 2011)
-Chapter 59
-Animal Population Control Program
•
Surcharge sent to state, unless county plan
-Dog Licensing Law Changes
•
100% of revenue to municipality
-Elimination of NYS Dog Licensing System
What’s being done?
• Madison County Health Department
Microsoft Access based vaccination database
• Municipalities
NYS Dog Licensing System going dark
Proprietary software
CCHD survey
CCHD
Municipal
Survey
•
•
•
•
•
•
95% Wireless Access
State DLS Entry
50% use private software
50% Dog census
65% unprepared
60% want database
Database Basics (Access)
 Tables to store your data.
 Queries to find and retrieve just the data that you want.
 Forms to view, add, and update data in tables.
 Reports to analyze or print data in a specific layout.
 Macro is a tool that allows you to automate tasks and add
functionality to your forms, reports, and controls.
Database
Model -MCHD
‘Old Data’
Clinic Table –
Meat
Look up Tables
Unit = Vaccination Shot!
Same Dog – Two shots
Same owner – multiple animals /
multiple shots
“Many-toone”
relationship
Lookup
Tables
Functionality
Searches
- by Owner Name
- by Owner Address
- by Tag. No.
Reports
- Clinic Detail / Summary
- Animal Count
- Certificates
Maintenance
- Reference Information
- Owner Information
Identified Issues
 Current Address Only
 Dog History (change owner / names)
 Limited audience (Rabies – Health Department)
-
Single stakeholder group
 Dog History (change owner / names)
NYS A&M End of Dog Licensing
 New York State Dog Licensing System - Database
-
Went dark Jan. 1st, 2011
No/little training
Very comprehensive
Web based database application
Mixed reviews
Not fully utilized
DLS Development - Stakeholders
Raw Data
Processed Information
CCHD Sanitarians
CCHD Rabies
Vaccination
MunicipalDog Control
Officers
Veterinarians
SPCAs,
Other
animal
groups
Municipal Clerks
Basic Unit - License
Transaction
Module
Fee / Payment
Module
County
Module
Municipality
Module
License Module
Vaccination
Module
Owner / Address
Module
Dog Module
Dog
Control
Module
Modular
Access
CCHD Sanitarians
CCHD Rabies
Vaccination
Veterinarian
MunicipalDog Control
Officers
Municipal Clerks
SPCAs,
Other
animal
groups
 Different Users
-
Permissions
Functions
Entry
Results
Web - Based
 Multi-user access
 phpMyAdmin
Open source My SQL
database administrator
Database (Tables,
Queries)
 Drupal
- Open source Content
Management System
- Interface (Forms, Reports,
Macros)
http://www.phpmyadmin.net/home_page/index.php
http://www.drupal.org
Functionality
 Create
-
New License
New Vaccination
Functionality
 Edit
-
Dog info
License info
Vaccination
Address
Functionality
 Search / Find
-
Dog name
License #
Owner
Vaccination / Tag
Functionality
 Queries / Reports
-
Renewals
Custom (Planned) -
Delinquent
Summary (Planned)
Functionality
 Printable Reports
-
Renewals
Rabies Certs.
Functionality
 Automated forms / labels (Planned)
 User driven
 Web GIS integration
(Planned)
 Maintenance (Planned)
-
Look-up tables
-
Permissions
-
Import utilities
Database Comparison
 MCHD – Vaccination DB
-
Microsoft Access
Network / stand-alone
Limited users
(Health Dept.)
Simple data model
Easy maintenance
Easy administration
Little training
 CCHD – DLS
-
myPhp
web based
multiple users
(permissions)
Complex data model
Ongoing maintenance
Ongoing administration
More training
Thanks to
Madison County Health Department
Geoff Snyder & IT Staff
Jeremy Knab
Catt. Co.
Webmaster
Paul Frey
Catt. Co.
GIS Coordinator
Questions?
Chris Crawford
Catt. Co.
Water Resource Specialist
716-701-3388
[email protected]
NYS DATA
MODEL OMG!
 Modular
 Many potential users /
data providers
 Lots of LUTs
Vaccination_tag_id