Comparative Archaeology Database, University of Pittsburgh

Upper Daling Region Settlement Dataset 
The data files SURVCOLL.TXT and SURVCOLL.XLS contain information about each individual collection unit in the regional survey. They provide the complete calculation, survey collection unit by survey collection unit, of the areadensity index that was the basis of reconstructing demographic distributions (see Chapter 4 in the printed volume and details online). Surface remains of architecture were not abundant in the Upper Daling region, but two sites are worth singling out for special mention. The excavated ceremonial structures of the Dongshanzui site correspond to collection units A001A004. And collection units C015C018 correspond to a Lower Xiajiadian fortified hilltop with a stone defensive wall and ditch that completely encircles these units.
SURVCOLL.TXT is a commadelimited ASCII text file, which should be easy to import into spreadsheet, database, and statistical programs for manipulation and analysis. SURVCOLL.XLS contains the same data in the form of an Excel spreadsheet which is easier to browse, and can also be imported into many programs. Each line represents one survey collection unit. There are 2863 lines, each with 33 variables separated by commas. The variables are, in the following order:
1  Collection Unit Number. Begins with a letter indicating the survey team that recorded the unit, followed by a threedigit number. Matches the numbers in the regional GIS dataset and in the tables of artifacts below. 
2  Surface visibility:
0=Missing data 1=Low 2=Medium 3=High 
3  Collection type:
0=General 1=Systematic with 1 circle (10 square meters total) 2=Systematic with 2 circles (20 square meters total) 3=Systematic with 3 circles (30 square meters total) 4=Systematic with 4 circles (40 square meters total) 5=Systematic with 5 circles (50 square meters total) 
4  Area included in the collection unit (in hectares). 
5  Total number of sherds. 
6  Number of Early Neolithic sherds (preHongshan, cf. Xinglongwa, Zhaobaogou). 
7  Number of Hongshan sherds from vessels. 
8  Number of Hongshan tongxingqi sherds. 
9  Number of Xiaoheyan sherds. 
10  Number of Lower Xiajiadian sherds. 
11  Number of Upper Xiajiadian sherds. 
12  Number of ZhanguoHan sherds from vessels. 
13  Number of ZhanguoHan sherds from roof tiles. 
14  Number of Liao sherds from vessels. 
15  Number of Liao sherds from roof tiles. 
16  Number of Recent (postLiao but pre20thcentury) sherds. 
17  Number of Modern (20thcentury sherds). 
18  Number of unclassified ancient sherds. 
19  Total number of ancient vessel sherdsthe sum of variables 6 + 7 + 9 + 10 + 11 + 12 + 14. 
20  Total number of ancient vessel sherds plus unclassified sherdsthe sum of variables 18 + 19). 
21  Total sherd density per square metervariable 20 / (10 x variable 3) for systematic collections; see complete derivation of density values for general collections. 
22  Hongshan sherd density per square meter(variable 7 / variable 19) x variable 21. 
23  Xiaoheyan sherd density per square meter(variable 9 / variable 19) x variable 21. 
24  Lower Xiajiadian sherd density per square meter(variable 10 / variable 19) x variable 21. 
25  Upper Xiajiadian sherd density per square meter(variable 11 / variable 19) x variable 21. 
26  ZhanguoHan sherd density per square meter(variable 12 / variable 19) x variable 21. 
27  Liao sherd density per square meter(variable 14 / variable 19) x variable 21. 
28  Hongshan areadensity indexvariable 22 x variable 4. 
29  Xiaoheyan areadensity indexvariable 23 x variable 4. 
30  Lower Xiajiadian areadensity indexvariable 24 x variable 4. 
31  Upper Xiajiadian areadensity indexvariable 25 x variable 4. 
32  ZhanguoHan areadensity indexvariable 26 x variable 4. 
33  Liao areadensity indexvariable 27 x variable 4. 
The first line of the ASCII text file, for example, looks like this:
A001,3,2,0.269,24,0,16,2,0,0,0,0,0,1,0,0,5,0,17,17,0.85,0.8,0,0,0,0,0.05,0.215,0,0,0,0,0.013
This means that the data belong to collection unit number A001. The surface visibility was high. The collection carried out was systematic with 2 collection circles. The total area of the collection unit was 0.269 hectares. There was a total of 24 sherds in this collection, including 16 Hongshan sherds from vessels, 2 Hongshan tongxingqi sherds, 1 Liao vessel sherd, and 5 modern sherds. This makes for a total of 17 ancient sherds, as well as a total of 17 sherds if ancient and unclassified sherds are taken together. The total sherd density per square meter for the systematic collection is .850. The Hongshan sherd density per square meter is .800. The Liao sherd density per square meter is .050. The Hongshan areadensity index is .215 and the Liao areadensity index is .013.
The last, or 2863rd line of the ASCII text file is:
F012,1,5,0.183,13,0,8,1,4,0,0,0,0,0,0,0,0,0,12,12,0.24,0.16,0.08,0,0,0,0,0.029,0.015,0,0,0,0
This means that the data belong to collection unit number F012. The surface visibility was low. The collection carried out was systematic with 5 collection circles. The total area of the collection unit was 0.183 hectares. There was a total of 13 sherds in this collection, including 8 Hongshan sherds from vessels, 1 Hongshan tongxingqi sherd, and 4 Xiaoheyan sherds. This makes for a total of 12 ancient sherds, as well as a total of 12 sherds if ancient and unclassified sherds are taken together. The total sherd density per square meter for the systematic collection is .240. The Hongshan sherd density per square meter is .16. The Xiaoheyan sherd density per square meter is .080. The Hongshan areadensity index is .029 and the Xiaoheyan areadensity index is .015.
Click here to download the file SURVCOLL.TXT (247 KB) or the file SURVCOLL.XLS (922 KB).