semantic air quality portal
Skip this Video
Download Presentation
Semantic Air Quality Portal

Loading in 2 Seconds...

play fullscreen
1 / 27

Semantic Air Quality Portal - PowerPoint PPT Presentation

  • Uploaded on

Semantic Air Quality Portal. Semantic e-Science Fall 2011. Group. Apurva Tiwari : Ontology creation Charisma Ladiwala : Data acquisition Linyun Fu: Systems Administration Rohan Dhruva : Usecase & Documentation William Gill: Front End

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Semantic Air Quality Portal' - ghita

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
semantic air quality portal

Semantic Air Quality Portal

Semantic e-Science Fall 2011

  • ApurvaTiwari: Ontology creation
  • Charisma Ladiwala: Data acquisition
  • Linyun Fu: Systems Administration
  • RohanDhruva: Usecase & Documentation
  • William Gill: Front End

data sources
Data Sources
  • EPA CASTNET data
    • Collecting measurements for pollutants
    • In 50 sites, since 1991
  • Air Resources Board
    • California Environmental Protection Agency
    • Standard thresholds for pollutants
use case
Use Case
  • “Comparing and analysing Air Quality data”
  • Allow users to visualise the air quality data in the US
    • Data collated from various sources
  • Know the air quality in the user’s region of interest
    • Moving
    • Travelling
  • Determine the risk posed by air-borne pollutants
question 1
Question 1
  • How does the Air Quality of place X compare with the average air quality of New York State and what possible risks are posed by the air at place X?
  • Very useful for people who are planning to move to another state
question 2
Question 2
  • In place X, which season poses the lowest airborne risks for a person with asthma wishing to conduct outdoor actives?
  • Question particularly relevant for tourists and outdoor enthusiasts
  • Select the best route, area, and time, keeping in mind the health restrictions
  • Thresholds for different pollutants:
  • A Guide to Air Quality and Health.
  • U.S. Environmental Protection Agency
  • Office of Air Quality Planning and Standards
  • Outreach and Information Division
  • Research Triangle Park, NC August 2009
  • Collected it from website on 10/30/2011 at 8:32 pm . Why???
  • Converting concentration to AQI- Calculator:
  • AQI calculator: AQI to concentration
  • U.S. Environmental Protection Agency
  • Collected it from website on 10/30/2011 at 8:35 pm . Why???
Asthma Hospital Discharges - Rate per 10,000 Population, Total – Ten Year trend.

Department of Health, NY State.

2007-2009 SPARCS Data as of October, 2010

Revised September 2011.

Collected on 11/3/2011 at 9:36 am. Why???

  • About Asthma Emergency Department Visit Data, Hospital Discharge Data and Deaths

Department of Health, NY State.

SPARCS Data as of October, 2010.

Revised June 2009.

Collected on 11/3/2011 at 10:20 am. Why???

Air quality statistics and data ( Status and Trends) 2005-2009
  • Air Quality Monitoring Information
  • Updated December 17, 2010.
  • Collected on 10/31/2011 at 6:20 pm. Why???
additional provenance information
Additional Provenance Information
  • The csv2rdf4lod automation tool: was downloaded on October 15,2011 at 7:24pm.

Github social coding

Powered by: Dedicated serversand cloud computingof Rackspace Hosting.

  • Data on how the asthma data was collected.

>>> This data will be encoded in the visualization!!!

ny asthma hospitality data provenance
NY Asthma Hospitality Data Provenance
  • Raw data:
  • Companion provenance data: asthma6.htm.pml.ttl
  • Level 2 data (only keep the columns Region/County and Adjusted Average Rate and add a FIPS code column; delete regional/national total rows and metadata block): asthma-hospitality-discharges-2007-2009.csv
  • Companion provenance data: asthma-hospitality-discharges-2007-2009.csv.pml.ttl
  • Level 3 data: asthma-hospitality-discharges-2007-2009.csv.e1.ttl converted with csv2rdf4lod with the enhancement parameters asthma-hospitality-discharges-2007-2009.csv.e1.params.ttl
  • All files downloadable from
epa aqi category ontology
EPA AQI Category Ontology
  • Source:
  • Expressed in OWL: aqiCategory-owl.rdf
    • 0
  • Tested with Jena
pollutant ontology
Pollutant Ontology
  • Pollutant.owl
  • Not so useful now
ontology work
Ontology Work
  • Two main ontologies in our project
  • Threshold ontology
    • Defines the threshold levels for each pollutant
    • Data obtained from CA Air Resources Board
  • Pollutant ontology
    • Provides data for the map/timeline
    • Data obtained from EPA CASTNET project
    • Stipulated to NY State for now, to avoid data overload
  • Data Properties:
  • hasEPAValue- Type: Double
  • hasCAValue- Type Double
  • Object Properties:
  • hasPollutant
plans to improve the ontology
  • More Provenance data must be included:
    • More provenance data like the date and place for which the data has been collected should be incorporated.
  • Different Degrees of Thresholds:
    • Currently, due to lack of concrete numbers, only one level threshold has been included. But different levels of thresholds like average, hazardous, lethal etc. can be used.
  • New Ontology for Asthma:
    • Right now, any knowledge on asthma has not been admitted into the ontology. So, the ontology can be improved by letting it in the ontology.
  • Extension of the Pollutant Ontology:
    • The pollutant ontology can be extended to be more comprehensive and capture more detailed knowledge on pollutants.
  • PHP scripts that compose pre-built queries and cache results
    • Take JSON results and arrange data for fast lookup in client
    • 2 Dimensional arrays
      • Data[time][fips]
future middleware
Future Middleware
  • Smart look-aheads based on time and place settings made by the client
  • Found sparql endpoint returns max of 10k results
  • Currently limited data to NYS (~8k rows)
front end
Front End
  • Jquery UI api(slider)
  • Polymaps (map)
future work
Future Work
  • Add more sources of data
  • Parse and display data for all the states
thank you

Thank You!