(PM) Harry : Middleware (Python and Flask)
Andrew : Front End (Map API)
Ivan : Middleware (Python and Flask)
Shinji : Database / API (read data into sqlite)

App that displays a map of NYC populated with data on crime in the city over layed with additional info on the city like socioeconomic demographics. This visualization of information can help gauge the relative safety of certain areas in NYC based on various indexes.

Maptiler Docs
Maptiler Raster Image
MapTiler Vector Tiles in Leaflet JS
Maptiler Account Details:
Email for API: [email protected]
This API will be used to create a map for our project that we will layer information on in many forms and with many different filters that the user will be able to use.
Goal: https://cuspmap.org/NYC/
https://data.cityofnewyork.us/login
NYC Open Data Account Details:
Email for NYC Open Data Account: [email protected]
This account will allow us to create an app token to use the APIs provided by by NYC Open Data

0) Create and activate an environment

python3 -m venv <<name>>
cd <<name>>
. bin/activate

1) Clone the project

git clone [email protected]:HarryZhu231227919/P04_BubblingBanjos.git

2) Navigate to root directory

cd P04_BubblingBanjos/

3) Install requirements

pip install -r requirements.txt

4) Cd into app/ and run the setup code (you can delete the downloaded csv and zip files after the database is made)

python3 setup.py

5) Run the program

python3 __init__.py

6) Click on the following link:

http://127.0.0.1:5000

7) Have fun!

NYC OPEN DATA
NYC motor vehicle collisions (The Motor Vehicle Collisions crash table contains details on the crash event. Each row represents a crash event. The Motor Vehicle Collisions data tables contain information from all police reported motor vehicle collisions in NYC)
details on the specific vehicles involved in collisions
NYC hate crimes (Dataset containing confirmed hate crime incidents in NYC, doesn’t have latitude, longitude)
NYC shooting incidents (List of every shooting incident that occurred in NYC going back to 2006 through the end of the previous calendar year)
NYC arrest data (List of every arrest in NYC going back to 2006 through the end of the previous calendar year)
Demographics by zip code