Volume III:
Markets and Opportunities for Residential Development

Appendix A1: The Two Tables in the Database




Lot Data

Field Name

Type of data

Lot ID (primary key)

as Text

Block #

as Text

Lot #

as Number

Dimensions

as Text

Vacant?

as Yes/No (true/false in Excel files)

Building

as Text

Additional Lot

as Text

Acreage

as Number

Owner‘s name

as Text

Street Address of the Lot

as Text

Land Value

as Number

Improvement Value

as Number

Total Value

as Number

notes

as notes

Owner Data

Filed Name

Type of data

Owner’s name ( primary key: related to the field in the Lot Table)

as Text

Owner’s address (street)

as Text

Owner’s address (city)

as Text

Owner’s address (state)

as Text

Owner’s address (zip)

as Text

Owner-occupier?

As Yes/No (true/false in Excel files)



Project Community Contents Next Prev Download