The Database API reference discovery

From University Map Wiki
Revision as of 16:46, 11 December 2012 by dje39 (talk | contribs) (→‎In detail)
Jump to navigationJump to search

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|ref|...

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, the API 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.

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)
  • building
  • 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.

    |----- 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.

References explained

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.

In detail

If X stands for one or more upper case letters, nnn for three digits and n for digits in general,

sites/colleges:  X  
subsites:  X/X  
site and subsite entrances:  X-X  X/X-X  
buildings:  Xnnn  X/Xnnn  
sub-buildings:  Xnnn.n  X/Xnnn.n  
building entrances:  Xnnn-X  Xnnn.n-X  X/Xnnn.n-X  X/Xnnn.n-X  
college staircases:  X--X  X/X--X  


Finally, then, you can ask for the desendants 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:*

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:*

All the staircases at Clare College (main site only):*

and at Memorial Court:*