# Beyond the Castle HackLancaster- Lancaster Urban Archaeological Database

## Non-Spatial REST

Non-Spatial RESTful services are provided by ArrestDB and can be accessed at http://lancasteruad.oxfordarchaeology.com/rest/index.php. To access a particular table, use the form:

http://lancasteruad.oxfordarchaeology.com/rest/index.php/tablename


See https://github.com/alixaxel/ArrestDB for information on how to use this.

You can get information on, or query the following tables in the database:

### Spatial

Note that querying the spatial data using rest will display the geometry of the table or record in well-known binary format.

• cellars: dataset of Lancaster Buildings showing presence or absence of cellars - point
• studyarea: study area boundary of Lancaster Urban Archaeological Database project - multipolygon
• listed_polys: boundaries of listed buildings - multipolygon
• event_points_full: dataset representing historic or archaeological events - point. The Image_Hyperlink column may contain hyperlinks to historic imagery.
• event_polys: dataset representing the outline of events such as archaeological digs - multipolygon. The image column may contain a hyperlink to imagery.
• mons_point: dataset representing historic or archaeological monuments - point
• monspres_polys: dataset representing definite monument outlines, eg extant or exposed by archaeological events - multipolygon
• monsint_polys: proposed outlines of monuments based on information from archaeological research, events and other information - multipolygon
• geophys: contour lines from geophysical survey - line (note this data has no attributes so might be best as base mapping)

### Non-Spatial

These are the principle tables in the database where the majority of information is stored

• tblBibliography - bibliographic references used for events and monuments
• tblDeposits - deposits identified for use in deposit model
• tblEvents - archaeological events. The Image_Hyperlink column may contain hyperlinks to historic imagery.
• tblEventsBibliography - joins events (by Recevent_Number) and bibliographic records (by UAD_BIB_Number)
• tblEventsMonuments - joins events (by Recevent_Number) and Monuments (by Monument_Number)
• tblExternalRefs_Events - lists identifying codes or names for events in other databases
• tblExternalRefs_Mon - lists identifying codes or names for monuments in other databases
• tblFieldworkers - lists principle fieldworkers for archaeological events
• tbl_mon_src - joins monuments (by Internal_cross_ref_mon) to bibliographic sources (by Internal_cross_ref_src)
• tblMonumentDates - lists different phases of use for a monument
• tblMonumentPeriods - lists periods in which a monument was extant
• tblMonuments - monuments
• tbl_monuments_listed - lists monuments that are listed buildings
• tblParentEvents - lists events that comprise multiple smaller events such as large-scale archaeological investigations
• tblSubMonuments - links collections of monuments together

### Lookups

These are descriptive tables, providing information on the terminology used in the tables above. Use them for reference only

• tlkpArchiveTypes - lists different types of archaeological archive
• tlkpAreaStatus - lists different area designations with their abbreviation and full description
• tlkpAssocOrganisations - lists the different archaeologicl/historical organisations that have done work in Lancaster
• tlkpAuthorsRole - lists different types of role with the creation of an archaeological archive or publication
• tlkpBookTypes - lists the different types of publication
• tlkpCurrDate - lists different ways of referring to the current date
• tlkpDatePrecision - lists different ways of referring to a date or date range in the past such as 'between', 'post', 'pre' etc
• tlkpDateTypes - lists different meanings for a date in the past, such as 'construction', 'disuse', 'use' etc
• tlkpDepositHorizons - lists different ways of describing a deposit horizon such as 'bottom', 'top', 'water' etc
• tlkpEventTypes - lists different types of archaeological event such as 'excavation', 'desk-based study' etc
• tlkpevidence - lists the different types of archaeological evidents such as 'wreckage', 'building', 'cropmark' etc
• tlkpExtInv - lists the different external inventories or databases that events and monuments may be listed in
• tlkpFieldworkerRole - lists the different roles a fieldworker may have in an archaeological investigation such as 'excavator', 'inspector', 'surveyor'
• tlkpItemNoQualifiers - lists different methods of referring to quantities of archaeological items and their precise meaning
• tlkpItemTypes - lists different types of archaeological item such as 'artefact', 'ecofact' etc
• tlkpMonDatePrecisions - lists different definitions of dates for time periods such as 'between', 'occasionally', 'throughout'
• tlkpNatGridPrecision - lists the different levels of precision of a National Grid Reference, such as 'within 1m', 'within 10m', 'within 1km' etc
• tlkpNGRQualifier - lists codes for determining what a Grid Reference actually refers to, such as the exact location of a find, the locality, the centre of a group of finds etc
• tlkpPeriods - lists the different time periods, their abbreviations, and their min and max dates where possible, such as 'Roman', 'Bronze Age', 'Post-Medieval' etc
• tlkpScientificDates - lists the different methods of obtaining a scientific date such as radiocarbon dating
• tlkpStatusQualifier - lists different methods of describing a location relative to another event or monument, such as 'adjacent to', 'excluded from' etc
• tlkp_Zconfidence - lists the level of confidence and the precision of any z (height) values

### Thesaurus

These are very specialist tables listing archaeological/historical terms and the relationships between them. Use them for reference only

• THESAURUS_TERM_PREFERENCES - lists terms with their preferred terms
• THESAURUS_TERM_RELATION - lists related terms
• THESAURUS_TERMS - dictionary of archaeological/historic terms
• THESAURUS_TERM_USES - lists uses for terms