Launch the app
The application aims to provide demographic and social-economic information, nearby amenities, transportation condition, and crime density for any place in Philadelphia to users.
Proposal
There are four web pages in the app.
Crime data
shooting victim data: https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+shootings&filename=shootings&format=geojson&skipfields=cartodb_id, queried from carto.
Public transportation stops
SEPTA stop and station location: https://services2.arcgis.com/9U43PSoL47wawX5S/arcgis/rest/services/Spring_2019_Stops_By_Route/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json , the data is stored in AWS database, queried by pgAdmin.
Amenities
Open street map, queried by Big Query
Basic Information
Race, age economics and housing value data come from ACS 2018 Census data. Queried by Big Query.