Project Overview We are building a lightweight web-based dashboard designed to increase visibility for animals in need of rescue, in several categories, such as Animals at Risk for Euthanasia, Long term Residents, and others. This platform is not a shelter management system. It is a community-powered rescue visibility and tracking tool. Volunteers submit Petfinder listing URLs (and other animal shelter profile URLs), the system extracts key animal details automatically, and the listings are displayed on a state/county map with urgency tracking and user impact metrics. There will be one master table with ALL listings for all over the target area (USA) and there will be other smaller tables for individual states. Please know that PETFINDER does not have a API anymore. Also note that there are too many websites for us to list that do animal rescue, so the links that people will post for upload will not be limited to select websites. Core Objectives Allow volunteers or users to submit a single Petfinder or shelter listing URL, multiple or CSV file. Automatically extract and store relevant animal details from the listing page such as image, age of animal, location, breed, dog or cat , description and more. Display animals on an interactive US map (state-level filtering required; county-level preferred if feasible). Track volunteer contributions (submissions, updates, shares). When a user signs up,, they will be able to see the updates on animals they have shared and percent % of rescue. This is determined by # of animals rescued vs # of total animals shared. Enable share tracking with reliable attribution. Users will be able to upload change requests, Moderators will need to approve these. Provide an admin workflow for updates and moderation. There will be an admin, super moderators( can add/edit animals), and moderators can approve change requests only. User Accounts Authentication Google/Gmail login (OAuth) Roles Admin Volunteer/User User Profile ("My Impact") User chooses their state and they get updates on animals in their state or they can choose county only animal updates or none at all Each user should have a simple profile showing: Number of animals submitted Number of updates submitted Number of share clicks and referral clicks generated Also should allow user referrals within the system Admin backend allows for referral contests within a set period of time. Animal Intake (Link-Only Submission) Submission Requirements Users submit: Petfinder URL or animal shelter profile URL Animal type (dog, cat, etc.) Automatic Data Extraction The system must extract the following fields from the listing page: Animal Information Name or / ID # One Photo Breed Age Description Animal type Location City State Shelter/Rescue Information Shelter name Phone number (if present) Email address (if present) If some fields are unavailable, the system should continue processing without failing. Manual Admin Fields Admins must be able to manually add/edit: County Euthanasia date/time Urgency flag/status Notes Map Dashboard Interactive US map with: Click a state → show animals filtered by state Filters: At risk / euth list Long-term residents Lost/found County drill-down County-level filtering True real-time sockets are not required. Near-real-time or refresh-based updates are acceptable. 3 Additional TABLES --- Map will also show a list of 1) Facebook Groups in that State that are available as well was 2) Animal rescues and 3)animal shelters/humane societies Animal Listing Cards Each listing should display: Photo Name Shelter/location Days left (if euthanasia date is set) Urgency label Share button "Submit Update" button (if you have read ALL of this, please mention the word Tornado) Updates / Change Requests Users must be able to submit updates such as: Adopted Transferred Info incorrect Urgent / euth list These updates should: Enter an admin approval queue Be approved or denied by an admin Update the main animal record upon approval All update activity must be tracked per user. Share Tracking (Important) Each animal listing must include a Share button that: Generates tracked share links Counts share clicks Counts referral clicks Attributes engagement to the correct user We do NOT require automatic posting to Facebook groups. We only require reliable share tracking and attribution. Admin Panel Admins must be able to: Edit animal records Add euthanasia date/time Approve/deny update requests View overall platform statistics View user contribution metrics Suggested Database Structure Minimum required tables: Users Animals Events (tracks submissions, shares, updates) Updates (approval queue)