Difference between revisions of "The Database API reference discovery"
|Line 91:||Line 91:|
For casual use, and for illustration, a live reference hierarchy browser is under construction. This will be at
For casual use , and for illustration , a live reference hierarchy browser is under construction. This will be at
Revision as of 17:25, 11 December 2012
This page describes how the (version 6) University Map Database API can be used to navigate among geographical objects and thereby determine relevant ref codes.
API calls of the form
yield the geographical entities (buildings, sites, colleges, entrances and nonuniversity premises known to the map) with the given refs.
However, this assumes you know what the refs are.
For those buildings etc which have names, searching for them by name either with the API or the interactive map will provide the record from which its ref can be determined. But (a) colleges yield the institution not the geographical college site when looked up by name, and (b) many entities, especially entrances, do not have names at all.
Therefore, both the API and the interactive also provides the ability to look up all the subordinate geographical entities for some entity (the geographical entities are arranged in a hierarchy) using a wildcard and thereby determine related (and ultimately, if necessary, all) references. For example, using the API:
and for the interactive map
Geographical entity hierarchy
There are five kinds of geographical entity stored in the University Map database:
- site (comprising university properties grouped in one physical location)
- college (which is like a site, but refers to college properties)
- entrance (to a building or to a site)
- nonuniversity (selected buildings/sites useful to display and reference)
Except for nonuniversity, which stands alone, these are organised into a hierarchy.
site/college | |----- subsite | | | |----- building/sub-building | | | | | |----- (building) entrance | | | |----- (site) entrance | | | |----- (staircase) entrance | |----- building/sub-building | | | |----- (building) entrance | |----- (site) entrance | |----- (staircase) entrance
A subsite looks just like a site, but represents a lesser group of buildings. It is not geographically contained within a site, but is linked to a parent site because of the way in which University Property Codes have historically been organised, and in the case of colleges because many colleges have separate outlying subsites.
A sub-building is just a convenient mechanism for broadening the property codes while keeping the underlying numbering scheme.
The hierarchy is reflected in the syntax of references, the codes which uniquely identify these entities. These reference codes are store along with their outlines in OpenStreetMap from which the data is obtained, using the property ("tag") ref.
References derive originally from University Estates Department property codes. These do not include college properties, so the numbering scheme has been extended to include these, and do not originally have any concept of subsites.
These property codes comprise an upper case letter which identifies a site followed by three digits identifying the building. For example M039 is the Cockcroft Building on the New Museums Site ("M"). (Estates did use an earlier numbering scheme which can be seen on the white sign boards at many entrances to the central sites. However these were abandoned in favour of this more regular scheme, and the sign boards have just not been updated).
Sometimes it is useful to represent an "Estates" building as more than one building, either because it actually is more than one (usually abutting) physical structure, or a code has been used to cover a group of not-very-distinct buildings, as in some of the farms, or it is useful to break up a large building into pieces where it is occupied in distinct parts (the Austin Robinson Building on the Sidgwick Site for example). These are represented by adding a period and another number to the reference (a decimal part, if you like). For example, the southern part of the Austin Robinson Building (the bit with the Sidgwick Buttery) is S012.3
Entrances are then represented by the building (for doors) or site (for gates etc) by the building or site code followed by a dash and one or more upper case letters. For example S012.3-A
Subsites are formed by following the site code with a slash and some more upper case letters. For example L/MATHS is the group of buildings and grounds of the Centre for Mathematical Studies.
Colleges follow the same pattern. Their codes for their main sites are their sub-domain names in upper case. For example CLARE for Clare College. Outliers are just like subsites, hence CLARE/MEM is Clare's Memorial Court property. Note that LUCY-CAV is unusual, being the only one with a dash in the code.
Finally, college staircases, though individually part of particular buildings, are actually represented college-wide. Hence they are subiordinate to college sites and subsites, and their letter is separated from the site code by two dashes. Thus DOW--P is Downing's P staircase, which happens to be in the East Range though there is nothing to tell you that.
If X stands for one or more upper case letters, nnn for three digits and n for digits in general,
|site and subsite entrances:||X-X||X/X-X|
For casual use to determine a reference, and for illustration of the API, a live reference hierarchy browser is under construction. This will be at
This uses exactly the API wildcard requests as shown below.
Finally, then, you can ask for the descendants of a referenced item using an asterisk as a wildcard in place of the relevant piece.
There can only be one wildcard per ref. Also, it is not a general regular expression: a wildcard matches the whole of one piece, i.e. X, nnn and n above.
A single asterisk provides a starting point in the absence of any other, providing all the top-level sites and colleges, thus (using the API):
Given a particular site, CLARE say (obtained from the result of the above) one can then obtain all its subsites (if any), thus:
Note that buildings of a site or subsite yields sub-buildings as well, because they aren't actually subdivisions, thus:
includes S031.3 (as in the example above). However, one can also obtain the sub-buildings of a building code even if the building that would be represented with that code does not actually exist. Hence:
This is useful in circumstances where you have the original property code but don't know whether it is divided up or not in the map. This will be useful in those circumstances.
All the staircases at Clare College (main site only):
and at Memorial Court:
As with non-wildcard references, several can be requested at once, separating them with a vertical bar. Therefore, all entrances of both M031.1, M031.2 and M031.3 can be obtained thus:
Note that you can't use ref=M031.*-* as you can only have one wildcard per reference.
Non university premises
In general, non-university premises do not have standard University property codes, for obvious reasons. They may not even have ref tags in OpenStreetMap. Therefore their "reference" is more general, comprising the name of the operator of the premises, followed by a colon, followed the the 'ref' if there is one or the building or site name (which may be the same as the operator name) if not. For example:
Arbury Road Baptist Church:Arbury Road Baptist Church Anglia Ruskin University:Anglia Ruskin University (Cambridge Campus)
No particular distinction is made between sites and buildings for non-university properties in the record returned (though they are drawn differently on the map).
There are a few buildings operated by non-university organisations which do actually have University property codes (usually because they are leased from the University). Hence MRC-CBU occupies:
Medical Research Council:L050
In this case, note that all its entrances can be obtained with
not including the "Medical Research Council:" part.
Other starting points
As well as listing everything from the top or searching by name to obtain a reference, there are three other options if you don't know a reference:
- When you ask for institutions, their locations and (main) entrances (both provided in the address info elements) contain references to the buildings and/or sites they occupy and the main entrances to get there. These can be followed up with a ref query to obtain more detail or a wildcard ref query to obtain subordinates.
- By bounding box. Using a 'bb' query, one can obtain all institutions within an area, and these can be filtered by institution class as in filter=academic|nonacademic. However, it is also possible to use filters for site (which includes college sites, as opposed to college institutions, and includes subsites), building and entrance within an area. When qualify with any of these, institutions are not also returned unless you also explicitly filter for them. Thus filter=building only yields buildings. The centroid of buildings and sites must lie within the bounding box for them to be located, except that when requesting sites, if any main entrance falls within the box, the site is found. Thus, the following example provides all of the buildings in and around the New Museums Site:
- For college staircases, you can guess! The college code is its upper case sub domain and the staircase letter is used in the reference code. So if you want staircase P in Downing, it is easy to ask for ref=DOW--P