ITEC 4961/CSCI 4961 Web Science (Fall 2010)/project3 notes

From Web Science 2009 class

Contents 1 links 2 Example query 3 NYtimes Location Dataset 3.1 links 3.2 Names Graph 3.3 Example query 4 NY Senate Datasets 4.1 NY Senate links 4.2 LOGD Named Graphs of NY Senate Datasets

links

• http://logd.tw.rpi.edu/
• tutorials http://logd.tw.rpi.edu/tutorials
• Example of demos http://logd.tw.rpi.edu/demos
• Even more examples http://tw.rpi.edu/portal/Mashaton/Examples
• Simple example http://logd.tw.rpi.edu/mashathon2010/example/5
• LOGD SPARQL Endpoint http://logd.tw.rpi.edu/sparql
• SPARQL docs http://www.w3.org/TR/rdf-sparql-query/
• quick SPARQL tutorial http://logd.tw.rpi.edu/mashathon2010/sparql
• Source code for Demos
• Google Vis API docs and help: http://tw.rpi.edu/portal/Mashaton/Google_Vis_Docs

Example query

PREFIX nys: <http://logd.tw.rpi.edu/source/nysenate-gov/dataset/senator-funding-appropriations-to-community-projects-2009-2010/vocab/enhancement/1/>
SELECT ?t ?y ?s
WHERE {
 GRAPH <http://logd.tw.rpi.edu/source/nysenate-gov/dataset/senator-funding-appropriations-to-community-projects-2009-2010/version/2010-Nov-30>  {
  ?x nys:senator ?z .
 ?z nys:senator_s_name ?t .
?t ?y ?s.
 }
} 
limit 300

NYtimes Location Dataset

links

• http://data.nytimes.com/

Names Graph

• http://data.nytimes.com/locations

Example query

PREFIX conversion: <http://purl.org/twc/vocab/conversion/>
SELECT *
WHERE {
 GRAPH <http://data.nytimes.com/locations>  {
  ?x ?y ?z
 }
} 
limit 100

NY Senate Datasets

NY Senate links

• http://www.nysenate.gov/opendata#opendata-results
• Payroll Report - End Date 10/27/10 http://www.nysenate.gov/payroll-report-end-date-102710
• 2009-10 Senator Allocations of 2004-05, 2006-07 Appropriations to Community Projects http://www.nysenate.gov/report/2009-10-senator-allocations-2004-05-2006-07-appropriations-community-projects-cpfs
• Senator Allocations of Funding to Community Projects (CPFs): 2009-2010 http://www.nysenate.gov/report/senator-allocations-funding-community-projects-cpfs-2009-2010

LOGD Named Graphs of NY Senate Datasets

• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/senator-funding-appropriations-to-community-projects-2009-2010/version/2010-Nov-30
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/senator-funding-appropriations-to-community-projects-2004-2005-and-2006-2007/version/2010-Nov-30
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/expenditure/version/2009-09-30
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/expenditure/version/2010-03-31
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-08-05
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-08-19
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-09-02
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-09-16
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-09-30
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-10-14
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-10-28
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-11-11
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-11-25
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2009-12-23
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-01-06
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-01-20
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-02-03
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-02-17
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-03-03
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-03-17
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-03-31
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-04-14
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-04-28
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-05-12
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-05-26
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-06-09
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-06-23
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-07-21
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-08-04
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-08-18
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-09-01
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-09-29
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-10-13
• http://logd.tw.rpi.edu/source/nysenate-gov/dataset/payroll/version/2010-11-10