Data Model

This page describes how we model data from each form from the MPP project. Each form will be treated in a subsection. Loci forms will be treated together.

Loci Forms

Several pieces of each loci form are identical across the three types.

1. Earth Loci (Color: yellow - most common)

2. Architectural Loci (Color: pink)

3. Installation Loci (Color: purple)

Burials (Color: Brown) are not strictly a loci since they do not get a locus number, but are attached to an earth locus. THEREFORE, burial forms are child entities of an earth locus.

Earth Locus

{{{!#latex \noindent \begin{tabular}{|l|l|l|l|p{3in}|}

• \hline

  \textbf{Section} & \textbf{Element Identifier} & \textbf{Element Type} & \textbf{Default} & \textbf{Description} \\ \hline 0.None & & & & \\ \hline

  • & Cleanup & Boolean & False & Check only if debris is interseasonal erosion and if there are pottery, bones, and other objects that need listing \\ \hline & Balk Removal & Boolean & False & Check only if you excavated a locus during the balk removal and you don't have the original locus sheet \\ \hline

  1.Identification & & & & \\ \hline

  • & A.Locus & Integer & None & IF there exists true in section 0. This is a Cleanup or Removal Excavation NOTE DEV. from Manual due to database constraints. \\ \hline & B.Site & Char & None & Single Char identifier of site \\ \hline & C.Season & Integer & Year(today) & Convention is last two digits of year --> Bah make it four digits \\ \hline & D.Field & Char & None & Single letter field designation \\ \hline & E.Square & varchar(8) & None & Sample: "6L46" or "A6" seems random.\\ \hline & F.StartDate & Date & Today() & Sample: 18 Jul 2009 [dd/mm/yyyy] \\ \hline & F.EndDate & Date & NULL & same. \\ \hline & G.Sheet & Integer & NULL & \textbf{NOT USED!} When we print out sheets they will have page numbers \\ \hline & H.Supervisor & varchar(25)[] & NOT NULL & If you worked on this sheet add your name to the list! \\ \hline & I.BALK & char(1) & NULL & Used for balk removal (seldom used) \\ \hline & J.Designation & varchar(80) & NULL & Free form description of the layer \\ \hline

  2.Rational & & & & \\ \hline

  • & A.Reason & varchar(80) & NULL & Free form reason for change (Color change,...) \\ \hline & B.Separability.Top & selection & Average & Selection from \textbf{Separability Entity:Very Clear, Clear, Average, Unclear, Very Unclear, Arbitrary } \\ \hline & B.Separability.Bot & selection & Average & Bottom of locus is from Separability Entity \\ \hline

  3.Description & & & & \emph{Description is significantly different across loci forms } \\ \hline 4.Stratigraphy & N/A & Child Element & NULL & Model: Association Table Stratigraphy(This, Loci, Spatial Relationship:\emph{above, below, equal, contiguous to, seals against, but by, cuts, FT, Abuts, Abutted by, sealed against by, bonded to}) \\ \hline 5.Levels & & & & Spatial Object Query - We now collect all spatial information with the Total Station. Therefore this section now is just a reference to the coordinates take at different times. Use intersection Table with point sets\\ \hline 6.Identification & & & & Printed header on subsequent pages - not recorded! \\ \hline 7.Pottery & & & & List of pottery bucket numbers. Model data as an intersection table. \textbf{Requires Entity: Pottery\_Bucket(see figure on p.26)} \\ \hline 8.Bones & & & & List of bone bucket numbers and associated Pottery Bucket numbers. \textbf{Requires Entity: Bones(Pail\#,Date,Location,Comments)}\\ \hline 9.Seeds & & & & Identical to Bones model - \textbf{Requires Entity: Seeds(Pail\#,Date,Sample\#,Location,Reading)} \\ \hline 10.Objects & & & & Similar to Seeds model - \textbf{Requires Entity: Object(Pail\#,Date,Field\#,Spatial Coordinates Set\#,Reading) : Associated with pictures,loci...} \\ \hline 11.Photographs & & & & List of photo numbers model - intersection table. \\ \hline 12.Biodata Samples & BioDataSamples & varchar(80) & Pollen & PROGRAMMING: list elements to check, allow additional information to be typed. The combination goes here. \\ \hline 13.Drawings & & Intersection Table & NULL & \textbf{Requires Entity: Drawing(ID,Image,...)} \\ \hline 14.Interpretation & & & & \\ \hline

  • & A.Fucntion & varchar(500) & NULL & What was this loci used for in antiquity \\ \hline & B.Stratigraphy & varchar(500) & NULL & This is a textual check on the data that we collect with the total station \\ \hline & C.CleanLocus & boolean & false & Did this layer produce pottery from one period only with no mixing of ceramic horizons? Yes--> true \\ \hline & D.Locus Date & varchar(50) & NULL & Excavators dating of the layer & E.Phase & varchar(10) & NULL & Completed later ... & F.Stratum & varchar(10) & NULL & Completed later ...

\end{tabular} }}}