Structure for table MAS.DBF (Typical)

Table type DBASE

--------------------------------------

Field Information FIELD DESCRIPTION

Field Field Name Type Len Dec

1 TAXYEAR N 4 0

2 PARCEL C 9 0 Unique identifier for each property

3 SFRCONDO C 1 0 (Note: some may be coded "C" strictly for grouping purposes)

4 COMPLEXID N 4 0 Used to group condo complexes together for valuation purposes

5 INSPECTION D 8 0 Date of last field check

6 CLASS N 1 0 Used to stratify homes based on design, workmanship and materials.

7 STORIES N 4 1 Number of stories (>4.0 denotes a condo/townhouse project)

8 ROOMS N 2 0 Number of rooms

9 QUALITY N 1 0 Used to further satisfy homes within the same class.

10 WALLS N 1 0 Exterior wall construction

11 ROOF N 1 0 Roof materials

12 HEAT N 1 0 Type of heating

13 COOL N 1 0 Type of cooling

14 BATHFIXTUR N 2 0 Number of total bath fixtures

15 PATIO N 1 0 Type of patio

16 PATIONUMBE N 1 0 Number of spaces

17 CONDITION N 1 0 Physical condition (this field is not maintained)

18 SQFT N 5 0 Livable square footage

19 YEAR N 4 0 Effective construction year

20 GARAGE N 1 0 Type of garage

21 GARAGECAPA N 1 0 Number of spaces

22 POOLAREA N 4 0 Does not indicate exact area of pool

23 MAIN N 7 0 Value determined by regression analysis

24 CONTROL N 7 0 Value adjusted for market/additional house

25 ACTUAL N 7 0 Final value placed on property

26 LASTACTION C 8 0 Internal use

27 VALUATIONC C 2 0 Internal use

28 APPLICATIO C 4 0 Internal use

29 ENHANCEMEN N 18 0 Nominal value assigned to additional structures (ie a workshop)

30 ADJUSTMENT N 5 3 Adjustment applied to property for some known deficiency

--------------------------------------

*Total* 111 bytes per record

Because the above file is a database, each filed contains "codes" that represent data. Below is a conversion

code list for such items.

Class

0 = "LM"

1 = "R-1"

2 = "R-2"

3 = "R-3"

4 = "R-4"

5 = "R-5"

6 = "R-6"

Quality

1 = "Minimum"

2 = "Fair"

3 = "Good"

4 = "Excellent"

Walls

0 = "Framed Wood"

1 = "Framed Block"

2 = "8in Painted"

3 = "8in Stucco"

4 = "Brick"

5 = "Stone"

6 = "Slump Block"

7 = "Adobe"

8 = "Other"

Roof

0 = "Wood"

1 = "Asphalt"

2 = "Asbestos"

3 = "Built Up"

4 = "Tile"

5 = "Slate"

6 = "Metal"

7 = "Prepared Roll"

8 = "Other"

Heat

0 = "Gravity"

1 = "Forced"

2 = "Steam"

3 = "Hot Water"

4 = "Radiant"

5 = "Floor Furnace"

6 = "Wall Furnace"

7 = "Electric Panel"

8 = "Other"

9 = "None"

Cool

0 = "Refrigeration"

1 = "Evaprative"

2 = "Wall"

9 = "None"

Patio/Porch

1 = "Slab"

3 = "Covered"

6 = "Slab\Covered (both)"

9 = "None"

Condition

1 = "Minimum"

2 = "Fair"

3 = "Good"

4 = "Excellent"

Garage

1 = "Garage"

3 = "Carport"

6 = "Garage\Carport (both)"

9 = "None"