|
Anyone know where I can find a list of all colleges and universities in the UK, along with their postcode? Preferably in excel format. The UCAS big map http://www.ucas.com/documents/ucasguides/bigmap2011.pdf is handy, but only shows institutes offering degree courses, and doesn't have the all important postcodes. |
|
Here's an excerpt from the JISC's Monitoring Unit dataset that lists all UK Universities and Colleges, their lat and long and postcode: http://tinyurl.com/68smyh8 The response comes from a query against the SPARQL endpoint of an RDF version of the JISCmu dataset hosted at http://api.talis.com/stores/jisc-prod-dev1/services/sparql The query has been piped through the SPARQL client at http://data-gov.tw.rpi.edu/ws/sparqlproxy.php because it gives CSV as an output format. The JISC MU dataset itself only holds a single geographical point per institution, but it is linked in the Talis store to freebase.com identifiers and excerpts, which may hold more in some cases. You can get at freebase.com data by sticking ?muOrg owl:sameAs ?fbID . in the query below The SPARQL query itself is:
|
|
The JISC Monitoring Unit (JISCMU) API may have what you need, at least for HE? See also the Linked Data conversion that Jo Walsh/@Metazool put together: Institutional locations as Linked Data through Google Refine Something I noticed looking at HESA coding schemes was that as well as institutional identifiers there are campus identifiers. Something I don't know offhand is whether the JISCMU data includes HESA institutional identifiers, and "central" postcodes for HEIs, or if it goes as far as providing postcode/location data for campuses along with HESA campus identifiers? There are also UCAS identifier codes - I'm not sure where the official list is, but there is a mapping from university name to UCAS identifier on the Guardian Datastore Rosetta data spreadsheet. There must be mappings from HESA to UCAS codes somewhere? Though maybe easy enough to do via reconciliation on institution name? Try:
(04 May '11, 10:55)
Wilbert
|
|
Follow up to my earlier response: You can find out the shape of the JISC MU dataset by running something like:
Against the SPARQL endpoint at http://api.talis.com/stores/jisc-prod-dev1/services/sparql All the data in that set are organisations with those kinds of properties. Yes, they do include both HESA and UCAS codes. To get at something like the domain name of each organisation, try:
Running the query via http://data-gov.tw.rpi.edu/ws/sparqlproxy.php can give you html and spreadsheets |
|
Note: as of this "touch time" the links below return nothing. Thus, the remote store might be undergoing maintenance of the data has moved. Coincidentally I made a similar demo elsewhere [1] a few minutes ago. Here are some variations of this example courtesy of Virtuoso and its support of SPARQL-FED:
If I have a URL for the entire data set, the demonstration can be expanded across many other dimensions that includes joins across the LOD cloud plus facets driven follow-your-nose oriented pages etc.. Links:
|
|
Now that I've loaded the data into our URIBurner [1] and LOD Cloud cache [2] instances of Virtuoso, here are some additional demo links:
Kingsley |
Get the Data