Skip to content

Latest commit

 

History

History
92 lines (56 loc) · 3.57 KB

File metadata and controls

92 lines (56 loc) · 3.57 KB

China Air Pollution Data Monitoring Web System

Contributer:

Xiaoxiao Liu ([email protected])

Da Chen ([email protected])

Domain:

Through this database, we provide real-time data and comparisons between different attributes of air quality for different cities in China. The purpose is to demonstrate regional air pollution statistic data and potential major causes for different cities.

Areas of specialization

  1. REAL-TIME DATA In our project we use real-time data instead of solely static dataset to make our graph timeliness, always updated. The python scripts we created is responsible for making http request, retrieving data, parsing and interacting with our MySQL database.

  2. DATA VISUALIZATION We use ECharts API to create fine, animated, interactive charts, graphs and diagrams to clearly demonstrate the trend of data or comparison of multiple attributes.

Data source

Our data source consists two parts:

1. From public data APIs, examples are hourly-requested whether & pollution data, last-hour pm2.5 index, city air pollution level:

2. Dataset downloaded from internet, examples include (City_Chinese_name, City_English_name, City_Longitude_Latitude):

To view our results:

Our design and codes are all under git SVN control, Github link: https://github.com/xliu59/air_pollution

Run our code

We use LAMP architecture. To run our project:

  1. Clone our repo https://github.com/xliu59/air_pollution.git to your local webserver root and
  2. Change the database params to yours in conf.php
  3. Run CreateDB.sql to create schema and populate your Mysql Database.
  4. Open <your_root>/air_pollution/index.html

Limitations

We have finished real-time data retrieval, stored procedures, front-end data visualization, and some back-end logics to handle request. We are still working on the server side and currently it only shows data that is pre-selected. The sidebar for selecting dates and cities is to be implemented. We are confident that when finished, this web project will be useful, accurate and stable.

Project Output (some screenshots)

home page

screen_shot

screen_shot

screen_shot

screen_shot

screen_shot

screen_shot

screen_shot

screen_shot