Lovable Prompt Creator - AI Prompt Generator

## APPLICATION OVERVIEW
This project is a web application that provides a simplified geolocation API platform, allowing users to query zip codes and receive geolocation data including latitude, longitude, city, state, and country. The application features a simple dashboard UI for users to interact with the API, visualize data, and manage zip code information.

## CORE FEATURES
1. **Geocode by Zipcode**: Users can enter a zip code to receive geolocation data including city, state, and coordinates through the API.
2. **Reverse Geocode**: Users can input latitude and longitude to retrieve the nearest zip code and its corresponding location details.
3. **Health Endpoint**: A dedicated endpoint to check the status of the API, ensuring it is operational.
4. **Simple Dashboard UI**: An interface where users can input zip codes, call the API, and view JSON responses clearly formatted for easy understanding.
5. **Map Visualization**: Coordinates displayed on an embedded map for better geographical context.
6. **CSV Upload Functionality**: Ability to import a dataset of zip codes via CSV for easier management and updates.

## DESIGN SPECIFICATIONS
- **Visual Style**: Minimalist - Clean, simple design with plenty of white space, minimal color palette, and focus on typography.
- **Color Mode**: Light theme with dark text on light backgrounds.
- **Layout**: A clean header with a title and input field for the zip code at the center, followed by a results section for displaying the JSON response and an embedded map below it.
- **Typography**: Use a sans-serif font like Roboto for body text and a slightly bolder font for headings to ensure clarity and readability.

## TECHNICAL REQUIREMENTS
- **Framework**: React with TypeScript
- **Styling**: Tailwind CSS for utility-first styling.
- **UI Components**: Utilize shadcn/ui for pre-built UI elements to maintain design consistency.
- **State Management**: Implement React Query for API data fetching and state management.

## IMPLEMENTATION STEPS
1. **Set Up Project**: Initialize a new React application with TypeScript and configure Tailwind CSS.
2. **Create API Endpoints**: Develop the backend service in Node.js, implementing the specified API endpoints for geocoding, reverse geocoding, and health checking.
3. **Database Configuration**: Set up PostgreSQL with the defined schema for storing zip code data and implement indexing for performance.
4. **Build Dashboard UI**:
   - Create input fields for users to enter zip codes.
   - Develop components to display the JSON response neatly.
   - Integrate a map component to visualize coordinates using a library like Leaflet or Google Maps.
5. **Implement CSV Upload Functionality**: Allow users to upload a CSV file to populate the database with zip code data.
6. **Test and Optimize**: Ensure the application is responsive and performs well under various conditions.

## USER EXPERIENCE
Users will land on a minimalistic dashboard where they can easily input a zip code. Upon submission, the application will call the geocode API and display the results in a clear format. Users can switch to reverse geocoding by entering coordinates, and they will be able to visualize the locations on a map. The health status can be checked with a single button click, and users will have the ability to manage zip code data through CSV uploads, making the application intuitive and user-friendly.