Example of finding OS things within a region.
SPARQL endpoint: http://data.ordnancesurvey.co.uk/datasets/os-linked-data/explorer/sparql
Tony Hirst psychemedia
psychemedia
/ schools.csv
Last active
August 29, 2015 13:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | outcome | url | |
|---|---|---|---|
| Long Knowle Primary School | Requires Improvement | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/104320 | |
| Whitehouse Primary School | Good | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/111549 | |
| Stow Heath Primary School | Inadequate | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/104323 | |
| Littleham Church of England Primary School | Good | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/113370 | |
| Whitby, Airy Hill Community Primary School | Requires Improvement | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/121345 | |
| Belvedere Infant School | Requires Improvement | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/101438 | |
| Greenacres Primary School | Requires Improvement | http://www.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/123592 | |
| Fearnville Primary School | Requires Improvement | http://www.ofsted.gov.uk/insp |
psychemedia
/ exampleData.txt
Last active
August 29, 2015 13:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| City | |
| Manchester, UK | |
| liverpool, uk | |
| London, UK | |
| New York, US |
psychemedia
/ electionsdemo-textAnalysis.ipynb
Last active
August 29, 2015 13:56
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
psychemedia
/ test.geojson
Last active
August 29, 2015 13:57
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
psychemedia
/ supplyChainGeojson.py
Last active
August 29, 2015 13:57
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pandas as pd | |
| import requests, json, geojson | |
| from geojson import Feature, Point, LineString, FeatureCollection | |
| def makeDataFrame(datalist): | |
| rawdata=zip(*datalist) | |
| return pd.DataFrame( {'from':list(rawdata[0]),'to':list(rawdata[1])} ) | |
| def geocode_mapquest(q,limit='1',format='json'): | |
| url = 'http://open.mapquestapi.com/nominatim/v1/search' |
psychemedia
/ README.md
Last active
August 29, 2015 13:57
Example of running a SPARQL query agains UK Ordnance Survey endpoint to find things contained within a region.
psychemedia
/ directors.csv
Created
May 6, 2014 12:14
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 8.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ID,code,did,source,role,oc,date,target | |
| ,gb/02405635,35112089,"DONG ENERGY SALES (UK) LIMITED",director,http://opencorporates.com/officers/35112089,2007-03-26,"MICHAEL JAMES HOGG" | |
| ,gb/02405635,35112097,"DONG ENERGY SALES (UK) LIMITED",director,http://opencorporates.com/officers/35112097,2008-05-16,"ANTHONY JAY WILLIAMSON" | |
| ,gb/02405635,48089079,"DONG ENERGY SALES (UK) LIMITED",director,http://opencorporates.com/officers/48089079,2012-04-30,"PETER ASBOE" | |
| ,gb/02405635,48089081,"DONG ENERGY SALES (UK) LIMITED",director,http://opencorporates.com/officers/48089081,2012-04-30,"EVERT GEERT DEN BOER" | |
| ,gb/02405635,48089082,"DONG ENERGY SALES (UK) LIMITED",director,http://opencorporates.com/officers/48089082,2011-07-01,"JOSEPH MANUEL VALENTE LETRAS" | |
| ,gb/02205902,34543546,"EASTHAM REFINERY LIMITED",director,http://opencorporates.com/officers/34543546,2007-12-10,"ROLF SVEN GORAN ALLGULANDER" | |
| ,gb/02205902,34543547,"EASTHAM REFINERY LIMITED",director,http://opencorporates.com/officers/34543547,2009-06-06,"ADRIAN GORDON BAGNA |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(shiny) | |
| library(ggplot2) | |
| library(reshape) | |
| shinyServer(function(input, output) { | |
| points=data.frame(pos=1:11,val=c(25,18,15,12,10,8,6,4,2,1,0)) | |
| points[[1,2]] | |
| a=245 | |
| v=255 | |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Demo TableExportTemplate to generate a geojson file containing a list of points.
Requires:
- the name of the column containing the marker description (Place in the example);
- a column containing numerical latitude co-ordinate values (Lat in the example);
- a column containing numerical longitude co-ordinate values (Long in the example).
Example data:
OlderNewer