import arcpy
from arcpy import env


def DelField(table,oldfield):	
# def DeleteField(table,oldfield,newfield,dtype2):	
	# print 'arcpy ADD FIELD >>>', newfield
	# arcpy.AddField_management(table,newfield,dtype2)
	# expr = '!' + oldfield + '!'	
	# print 'arcpy CALCULATE FIELD >>>', newfield
	# arcpy.CalculateField_management(table,newfield,expr,"PYTHON_9.3")
	print 'arcpy DELETE FIELD >>>', oldfield
	arcpy.DeleteField_management(table,oldfield)
	# print
	
	
def FixNULL(ds,field):
		# check for missing FIPS after join
		arcpy.MakeTableView_management(ds,'tabview')
		where = '"' + field + '" IS NULL'
		arcpy.SelectLayerByAttribute_management('tabview','NEW_SELECTION',where)
		print 'arcpy CALCULATE FIELD >>>', field
		arcpy.CalculateField_management('tabview',field,"0","PYTHON_9.3")
		arcpy.Delete_management('tabview')
		
		
# def Fix999(ds,field):
		# # check for missing FIPS after join
		# arcpy.MakeTableView_management(ds,'tabview')
		# where = '"' + field + '" = -999'
		# arcpy.SelectLayerByAttribute_management('tabview','NEW_SELECTION',where)
		# print 'arcpy CALCULATE FIELD >>>', field
		# arcpy.CalculateField_management('tabview',field,"0","PYTHON_9.3")
		# arcpy.Delete_management('tabview')
	
	
	
c = 0
ws = 'z:/Housing_data/PBG_change/pbg00_projections_2050_PLA2.gdb/'
env.workspace = ws

for fc in arcpy.ListFeatureClasses():

	stab = fc[:2]
	print stab
	
	if stab == 'al':
	
		# change NULL values to zeroes
		FixNULL(fc, 'PUBFLAG')
		FixNULL(fc, 'WATER00')
		
		FixNULL(fc, 'HU1940ADJ')
		FixNULL(fc, 'HU1950ADJ')
		FixNULL(fc, 'HU1960ADJ')
		FixNULL(fc, 'HU1970ADJ')
		FixNULL(fc, 'HU1980ADJ')
		FixNULL(fc, 'HU1990ADJ')
		FixNULL(fc, 'HU2000ADJ')
		FixNULL(fc, 'HU2010ADJ')
		FixNULL(fc, 'HU2020ADJ')
		FixNULL(fc, 'HU2030ADJ')
		FixNULL(fc, 'HU2040ADJ')
		FixNULL(fc, 'HU2050ADJ')

		FixNULL(fc, 'HDEN1940')
		FixNULL(fc, 'HDEN1950')
		FixNULL(fc, 'HDEN1960')
		FixNULL(fc, 'HDEN1970')
		FixNULL(fc, 'HDEN1980')
		FixNULL(fc, 'HDEN1990')
		FixNULL(fc, 'HDEN2000')
		FixNULL(fc, 'HDEN2010')
		FixNULL(fc, 'HDEN2020')
		FixNULL(fc, 'HDEN2030')
		FixNULL(fc, 'HDEN2040')
		FixNULL(fc, 'HDEN2050')
		
		# Delete Fields
		DelField(fc,'Growth_2000_2010')
		DelField(fc,'HU00BLK')
		DelField(fc,'HU10BLK')
		
	
	print