This repository contains a Streamlit application for analyzing 311 service requests in New York City. This project was created as a
This experimental application provides an interactive way to explore the 311 service requests in New York City. Users can select a complaint type of interest and the application will generate various summary statistics and visualizations, including a interactive map of the incident locations. The application is built using Python, Streamlit, PostgreSQL, and Plotly.
This project was created as an experiment using "prompt engineering" for creating useful data discovery applications through conversational AI as a person who do not write code as their primary profession.
The data used in this application comes from two main sources:
-
311 Service Requests from 2010 to Present: This dataset provides information about the service requests made to 311 in New York City from 2010 to the present. It is made available under the NYC Open Data Policy and Terms of Use. It can be downloaded from NYC Open Data.
-
NYC Neighborhoods: This dataset provides geographical information about the neighborhoods in New York City. It is licensed under the Open Data Commons Attribution License and can be downloaded from Beta NYC.
- Clone this repository.
- Install the required Python packages using pip:
pip install -r requirements.txt
- You will also need to have PostgreSQL installed and running on your machine / remote server / hosted DB.
- Set up your PostgreSQL database and import the necessary data.
- Set your Mapbox access token in
secrets.toml. - Run the Streamlit app:
streamlit run app.py
- Open your web browser and visit
http://localhost:8501.