About the Work in Progress Project
This project involved designing and implementing a PostgreSQL database to lookup pesticides (and rodenticides) in diffferent ways. This allows exterminators to find essential details like the EPA Registration Number or Active Ingredients for their peticides and rodenticides.
The database is simplified for performance (I hope!)
This project is currently down as I put together a frontend that I can host.
The data is hosted on Supabase as a PostgresSQL DB after having used Pandas/Python to merge and select relevant data from the New York State's Department of Environmental Conservation: Bureau of Pesticides Management, 2024.
Data was refined down with Pandas to contain only Insecticide and Rodenticde data and adjusted to be variable case for readability.
Screenshots
Here are some screengrabs of the project:
Here we have the simple schema for the database.
And here is the cleaned up data that is easier to read.
GitHub Repository
In the near future, everyone will be able to view the SQL scripts and other moving parts on my GitHub.