Comparative Archaeology Database, University of Pittsburgh
URL: http://www.cadb.pitt.edu
Email: cadb@pitt.edu

Upper Daling Region Settlement Dataset
Christian E. Peterson, Lu Xueming, Robert D. Drennan, and Zhu Da


Regional Survey Collection Unit Data

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 area-density 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 A001-A004. And collection units C015-C018 correspond to a Lower Xiajiadian fortified hilltop with a stone defensive wall and ditch that completely encircles these units.

SURVCOLL.TXT is a comma-delimited 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 three-digit 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 (pre-Hongshan, 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 Zhanguo-Han sherds from vessels.
13 Number of Zhanguo-Han sherds from roof tiles.
14 Number of Liao sherds from vessels.
15 Number of Liao sherds from roof tiles.
16 Number of Recent (post-Liao but pre-20th-century) sherds.
17 Number of Modern (20th-century sherds).
18 Number of unclassified ancient sherds.
19 Total number of ancient vessel sherds--the sum of variables 6 + 7 + 9 + 10 + 11 + 12 + 14.
20 Total number of ancient vessel sherds plus unclassified sherds--the sum of variables 18 + 19).
21 Total sherd density per square meter--variable 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 Zhanguo-Han 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 area-density index--variable 22 x variable 4.
29 Xiaoheyan area-density index--variable 23 x variable 4.
30 Lower Xiajiadian area-density index--variable 24 x variable 4.
31 Upper Xiajiadian area-density index--variable 25 x variable 4.
32 Zhanguo-Han area-density index--variable 26 x variable 4.
33 Liao area-density index--variable 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 area-density index is .215 and the Liao area-density 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 area-density index is .029 and the Xiaoheyan area-density index is .015.

Click here to download the file SURVCOLL.TXT (247 KB) or the file SURVCOLL.XLS (922 KB).


Return to the Table of Contents