WINDHAM REGIONAL COMMERCIAL AND INDUSTRIAL
STRUCTURES INVENTORY 

DATABASE FORMAT

information from Town of Rockingham lister cards, WRC field visits, and Town of Rockingham
data review

field name	type	width	description of contents

(STATUS)	C	1	status code for each record, used by WRC; A,B,C.
MODDATE		date	8	date of most recent entry, update, or verification to record
SITENAME	C	30	common name for site, generally structure name or name of 
					business
PARCELNUM	C	18	parcel number
*NEWSTR		C	30	911 structure address (### ROADNAME RD)
OWNER		C	30	owner's name; last, first
*CONTACT	C	100        name/address contact (separated by commas)
LOCATION	C	50	location of site
FIPS6		N	6	FIPS code of town, used by WRC
BLDGID		N	5	unique number for each building in a town
KEY		N	11	FIPS6 + BLDGID, this provides a unique number for every 
					structure in the database
YR_BUILT	N	4	year main building was constructed
LANDAREA	N	4.2	acreage of parcel
SQFTG		N	7	total square footage of the exterior of the building, 
					excluding porches and open sheds (i.e. square 
					footage of footprint)
*SQFTGTOT	N	7	total sq footage
SQFTGUSE	N	7	square footage of dominant commercial or industrial use 
					(may be greater than the building footprint if 
					additional floors are used for commercial purposes, 
					or less than the building footprint if portion of 
					building is unfinished, used for storages, etc.; 
					this figure is often a rough estimate based 
					on a number of factors, and needs to be reviewed 
					by the town)
*BLDGHT		N	5	bldg height in feet, estimated
(NUMFLOORS)	N	2.1	number of floors in main portion of building
PARKING		C	3	on-site parking, based on observations when visiting the 
					site: 1=adequate, 2=limited, 3=none
DESCR		C	60	brief description of building, site, additions, etc. 
					(this is a catch-all category intended to give 
					details about the building and its surroundings)
CONST		C	10	type of construction (wood, conc. block, brick, etc.)
*(PROPCLASS)	N	4	current use code, when available (codes developed by 
					Department of Property Valuation and Review)
CURRUSE		N	4	current use code, Vermont Center for Geographic 
					Information scheme
*CURRUSE2	N	4	secondary current use
*CURRUSE3	N	4	current use (multi-use)
USENOTES	N	60	notes on the use of the building
CEILHT		N	3	ceiling height, if available from lister cards
COND		N	1	condition of building, taken from lister cards: 1=excellent, 
					2=good, 3=fair, 4=poor, 5=delapitaded
ASVAL 		N	8	assessment, from lister cards	
(ASSES NOTE)	C	20	notes on assessment, including year
ZONING		C	30	zoning of parcel, from lister cards
*ROOFMAT	N	1	1=asphalt shingle, 2=metal panel, 3=membrane, 
					4=tar/gravel, 5=slate shingle, 6=standing seam, 
					7=wood shingle, 8=other
(SPRNKLR)	C	1	sprinkers (if information available from lister cards):  
					F=full, P=partial, N=none
*LOADDCK	N	2	# of loading docks
(STRUNOTE)	C	60	notes on building features or structural details
(ELECTCO)	C	10	name of electric company that serves the site
WATER		N 	1	water source, from lister cards: 1=muni supply, 2=on-site, 
					3=no water
SEWER		N	1	sewer system: 1=muni, 2=on-site septic, 3=none
HEAT		N	1	type of heating system, from lister cards:  1=oil, 
					2=natural gas, 3=propane, 4=wood, 5=other fuel, 
					6=unheated
ELECT		N	1	electrical service available to site; 1=three phase, 
					2=single phase, 3=none
(UTILNOTES)	C	30	other info on utilities
(LOCNOTES)	C	60	other locational notes


Some changes:

(FIELDNAME)	If a field name is found in parenthesis, the field is for WRC use only
			(i.e. not part of state-wide database format).
*FIELDNAME	If a field name has an asterik, the field is new (new compared with 
			1996 version).
	

05/02/00