Semantic air quality portal
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

    • <owl:Restriction> <owl:onProperty rdf:resource="&e1prop;daily_aqi_value"/> <owl:someValuesFrom> <rdfs:Datatype> <owl:onDatatype rdf:resource="&xsd;integer"/> <owl:withRestrictions rdf:parseType="Collection“> <rdf:Description rdf:about="#Good-AQI-Category-Min“> <xsd:minInclusive rdf:datatype="&xsd;integer">0</xsd:minInclusive> </rdf:Description> </owl:withRestrictions> </rdfs:Datatype> </owl:someValuesFrom></owl:Restriction>

  • Tested with Jena

Pollutant ontology
Pollutant Ontology

  • Pollutant.owl

    • <owl:Class rdf:about="#Aldehyde“> <rdfs:subClassOf rdf:resource="#Organic"/></owl:Class><owl:Class rdf:about="#Alkane“> <rdfs:subClassOf rdf:resource="#PureHydrocarbon"/></owl:Class>

  • 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!