def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Anoka'
countyObj.cty_fips = r'3'
countyObj.county_id = r'003'
countyObj.cty_abbr = r'ANOK'
countyObj.mngeo_web_id = r'Anoka 003'
countyObj.sourceZipFile = r'ANOK_parcels.zip'
countyObj.sourcePolygons = r'Parcels_UTM.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r'GIS_Extract_TXT.xlsx'
countyObj.joinInField = r'PIN2'
countyObj.joinJoinField = r'PIN'
countyObj.PIN_fieldList = ['Parcels_UTM_PIN']
countyObj.BLDG_NUM_fieldList = ['Parcels_UTM_LOC_NUMB']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = ['Parcels_UTM_LOC_PREFIX']
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['Parcels_UTM_LOC_NAME']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['Parcels_UTM_LOC_TYPE']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['Parcels_UTM_LOC_SUFFIX']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['Parcels_UTM_LOC_UNIT']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['Parcels_UTM_ACT_CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = ['Parcels_UTM_LOC_CITY']
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['Parcels_UTM_LOC_ZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['Parcels_UTM_PLAT']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['ANOK_t_BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['ANOK_t_LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Parcels_UTM_ACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = ['ANOK_t_PROPERTY_SEGMENT_s_']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['ANOK_t_OWNER__s_']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['ANOK_t_OWNER_Address']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['ANOK_t_TAXPAYER_Address']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['ANOK_t_LIMITED_LAND_VALUE']
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = ['ANOK_t_LIMITED_MARKET_VALUE']
countyObj.TAX_CAPAC_fieldList = ['ANOK_t_TAX_CAPACITY']
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = ['ANOK_t_SPECIAL_ASSESSMENTS']
countyObj.TAX_EXEMPT_fieldList = ['ANOK_t_EXEMPT_CODES']
countyObj.TAX_EXEMPT_transferType = 'ToYN'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = ['ANOK_t_STRUCTURE_TYPE']
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = ['ANOK_t_LIVING_SQ_FT']
countyObj.GARAGE_fieldList = ['ANOK_t_GARAGE']
countyObj.GARAGE_transferType = 'ToYN'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = ['ANOK_t_BASEMENT']
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = ['ANOK_t_SALE_Date']
countyObj.SALE_DATE_transferType = 'LongIntToDate'
countyObj.SALE_VALUE_fieldList = ['ANOK_t_SALE_PRICE']
countyObj.SCHOOL_DST_fieldList = ['Parcels_UTM_SCL_DIST']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = ['Parcels_UTM_WSD_DIST']
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['Parcels_UTM_SECTION']
countyObj.TOWNSHIP_fieldList = ['Parcels_UTM_TOWNSHIP']
countyObj.RANGE_fieldList = ['Parcels_UTM_RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['ANOK_t_LEGAL']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['Parcels_UTM_PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Clay'
countyObj.cty_fips = r'27'
countyObj.county_id = r'027'
countyObj.cty_abbr = r'CLAY'
countyObj.mngeo_web_id = r'Clay 027'
countyObj.sourceZipFile = r'CLAY_parcels.zip'
countyObj.sourcePolygons = r'Clay_County_Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['BLDG_NUM']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['STREETNAME']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['STREETTYPE']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['SUFFIX_DIR']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['UNIT_INFO']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLAT_NAME']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['CALC_ACREA']
countyObj.ACRES_DEED_fieldList = ['ACRES_DEED']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TAX_NAME']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TAX_ADD_L1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TAX_ADD_L2', 'TAX_ADD_L3', 'TAX_ADD_L4']
countyObj.TAX_ADD_L2_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['HOMESTEAD']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TAX_YEAR']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['EMV_LAND']
countyObj.EMV_BLDG_fieldList = ['EMV_BLDG']
countyObj.EMV_TOTAL_fieldList = ['EMV_TOTAL']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TOTAL_TAX']
countyObj.SPEC_ASSES_fieldList = ['SPEC_ASSES']
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = ['YEAR_BUILT']
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['SCHOOL_DST']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = ['WSHD_DIST']
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = ['GREEN_ACRE']
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = ['AG_PRESERV']
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['SectionNum']
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = ['RangeNumbe']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL_DESC']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Morrison'
countyObj.cty_fips = r'97'
countyObj.county_id = r'097'
countyObj.cty_abbr = r'MORR'
countyObj.mngeo_web_id = r'Morrison 097'
countyObj.sourceZipFile = r'MORR_parcels.zip'
countyObj.sourcePolygons = r'Parcels_20160718.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['SitusStNo']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['SitusStNam']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['SitusStTyp']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['SitusPostD']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['UnitNumber']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['SitusCity']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['SitusZip']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['displaynam']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['deliveryad']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['lastline']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = []
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Renville'
countyObj.cty_fips = r'129'
countyObj.county_id = r'129'
countyObj.cty_abbr = r'RENV'
countyObj.mngeo_web_id = r'Renville 129'
countyObj.sourceZipFile = r'RENV_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['Parcel_Num']
countyObj.BLDG_NUM_fieldList = ['APHOUS']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['APSNAM']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['APZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLDESC']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['APBLOK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['APLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = ['TPDEED']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWADR1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWADR2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWADR3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['OWCITY', 'OWSTATE', 'OWZIP5']
countyObj.OWN_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_NAME_fieldList = ['TXPRNAME']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TXPRADR1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TXPRADR2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TXPRADR3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['TXPRCITY', 'TXPRSTATE', 'TAXZIP5']
countyObj.TAX_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['APSCHL']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['APSECT']
countyObj.TOWNSHIP_fieldList = ['APTOWN']
countyObj.RANGE_fieldList = ['APRANG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['Parcel_Num']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Kandiyohi'
countyObj.cty_fips = r'67'
countyObj.county_id = r'067'
countyObj.cty_abbr = r'KAND'
countyObj.mngeo_web_id = r'Kandiyohi 067'
countyObj.sourceZipFile = r'KAND_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['PROPHSENUM']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = ['PROPDIR']
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['PROPROAD']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['PROPZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLATNAME']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCKNO']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOTNO']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['GISAcres']
countyObj.ACRES_DEED_fieldList = ['DEEDACRES']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['OWNNAME2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWNADDRESS']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWNADD2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWNCITY', 'OWNSTATE', 'OWNZIP']
countyObj.OWN_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TAXNAME', 'TAXNAME2']
countyObj.TAX_NAME_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L1_fieldList = ['TAXADDRESS']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TAXADD2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TAXCITY', 'TAXSTATE', 'TAXZIP']
countyObj.TAX_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = ['EMV']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['SCHOOLDIST']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['SECT']
countyObj.TOWNSHIP_fieldList = ['TWP']
countyObj.RANGE_fieldList = ['RNG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['DESC_', 'DESC1']
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Clearwater'
countyObj.cty_fips = r'29'
countyObj.county_id = r'029'
countyObj.cty_abbr = r'CLEA'
countyObj.mngeo_web_id = r'Clearwater 029'
countyObj.sourceZipFile = r'CLEA_parcels.zip'
countyObj.sourcePolygons = r'County_Parcel.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['Subdivisio']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['Block']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['Lot']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Acres']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = ['HomesteadC']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['Homestea_1']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['Homestea_2']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = ['Homestea_3', 'Homestea_4']
countyObj.USE4_DESC_transferType = 'concatTruncateTwoFields'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['PropAdd']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['PropCity']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TaxName']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TaxAddr']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TaxCity', 'TaxZip']
countyObj.TAX_ADD_L2_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TaxYear']
countyObj.MARKET_YEAR_fieldList = ['Assessment']
countyObj.EMV_LAND_fieldList = ['EMVLand']
countyObj.EMV_BLDG_fieldList = ['EMVBldg']
countyObj.EMV_TOTAL_fieldList = ['EMVTotal']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TotalTax']
countyObj.SPEC_ASSES_fieldList = ['SpecialAss']
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['Section']
countyObj.TOWNSHIP_fieldList = ['Township']
countyObj.RANGE_fieldList = ['Range']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['Legal']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Isanti'
countyObj.cty_fips = r'59'
countyObj.county_id = r'059'
countyObj.cty_abbr = r'ISAN'
countyObj.mngeo_web_id = r'Isanti 059'
countyObj.sourceZipFile = r'ISAN_parcels.zip'
countyObj.sourcePolygons = r'08222016.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['StreetNum']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['StreetName']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['UnitNumber']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['City']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['Plat']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['Block']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['Lot']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['GrossAcres']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = ['USE1_DESC']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['PriClass']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['SecClass']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = ['ThirdClass']
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['PrimaryTax']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TaxPayerAd']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TaxPayerCS']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['EMV_Land']
countyObj.EMV_BLDG_fieldList = ['EMV_Bldg']
countyObj.EMV_TOTAL_fieldList = ['TotalEMV']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TotalTax']
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = ['HOME_STYLE']
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = ['FIN_SQ_FT']
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = ['BASEMENT']
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = ['HEATING']
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = ['COOLING']
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = ['YEAR_BUILT']
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = ['SALE_VALUE']
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['Section_']
countyObj.TOWNSHIP_fieldList = ['Township']
countyObj.RANGE_fieldList = ['Range_']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LegalMetes']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Blue Earth'
countyObj.cty_fips = r'13'
countyObj.county_id = r'013'
countyObj.cty_abbr = r'BLUE'
countyObj.mngeo_web_id = r'Blue Earth 013'
countyObj.sourceZipFile = r'BLUE_parcels.zip'
countyObj.sourcePolygons = r'Parcel_BEC.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['HOUSENUM']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['ADDRESS']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = ['DEEDEDACRE']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['DEEDHOLD_1']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['DEEDHOLD_2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['MAILTO_ADD']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['MAILTO_A_1']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['MAILTO_CIT', 'MAILTO_STA', 'MAILTO_ZIP']
countyObj.OWN_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = []
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Pine'
countyObj.cty_fips = r'115'
countyObj.county_id = r'115'
countyObj.cty_abbr = r'PINE'
countyObj.mngeo_web_id = r'Pine 115'
countyObj.sourceZipFile = r'PINE_parcels.zip'
countyObj.sourcePolygons = r'PINE COUNTY.PARCELS\ENTIRE_COUNTY_PARCELS.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['ParcelID']
countyObj.BLDG_NUM_fieldList = ['HouseNumbe']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['City']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Acreage']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OwnerName1']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['OwnerName2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OwnerAddr1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OwnerAddr2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OwnerCity', 'OwnerState', 'OwnerZip']
countyObj.OWN_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TotTax']
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = ['YearBuilt']
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LegalDesc']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['ParcelID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Roseau'
countyObj.cty_fips = r'135'
countyObj.county_id = r'135'
countyObj.cty_abbr = r'ROSE'
countyObj.mngeo_web_id = r'Roseau 135'
countyObj.sourceZipFile = r'ROSE_parcels.zip'
countyObj.sourcePolygons = r'roseau.gdb\Parcels'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['RoseauAS400_dbo_tblParcelJoin_PIN']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['RoseauAS400_dbo_tblParcelJoin_PhysCity']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = [
'RoseauAS400_dbo_tblParcelJoin_Subdivision_Name'
]
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Block']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Lot']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Parcels_ACRES_2']
countyObj.ACRES_DEED_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Acres']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['RoseauAS400_dbo_tblParcelJoin_TaxName']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['RoseauAS400_dbo_tblParcelJoin_TaxAddr']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = [
'RoseauAS400_dbo_tblParcelJoin_TaxCity',
'RoseauAS400_dbo_tblParcelJoin_TaxState',
'RoseauAS400_dbo_tblParcelJoin_TaxZip'
]
countyObj.TAX_ADD_L2_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = [
'RoseauAS400_dbo_tblParcelJoin_School_District'
]
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['RoseauAS400_dbo_tblParcelJoin_lglSection']
countyObj.TOWNSHIP_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Township']
countyObj.RANGE_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Range']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['RoseauAS400_dbo_tblParcelJoin_Legal']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['RoseauAS400_dbo_tblParcelJoin_PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Cook'
countyObj.cty_fips = r'31'
countyObj.county_id = r'031'
countyObj.cty_abbr = r'COOK'
countyObj.mngeo_web_id = r'Cook 031'
countyObj.sourceZipFile = r'COOK_parcels.zip'
countyObj.sourcePolygons = r'CookCountyTaxParcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCELNBR']
countyObj.BLDG_NUM_fieldList = ['HOUSE_NBR']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLDESC']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCKNBR']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOTNBR']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Calculated']
countyObj.ACRES_DEED_fieldList = ['DEEDEDACRE']
countyObj.USE1_DESC_fieldList = ['ACCLDS1']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['ACCLDS2']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['ACCLDS3']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWNADR1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWNADR2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWNADR3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['OWNADR4', 'OWNZIP5']
countyObj.OWN_ADD_L4_transferType = 'concatTruncateTwoFields'
countyObj.TAX_NAME_fieldList = ['TAXNAME']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TAXADR1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TAXADR2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TAXADR3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['TAXADR4', 'TAXZIP5']
countyObj.TAX_ADD_L4_transferType = 'concatTruncateTwoFields'
countyObj.OWNERSHIP_fieldList = ['OWNTYPE']
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TAXYEAR']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['LANDEST']
countyObj.EMV_BLDG_fieldList = ['BUILDING']
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['SEC']
countyObj.TOWNSHIP_fieldList = ['TWP']
countyObj.RANGE_fieldList = ['RGE']
countyObj.RANGE_DIR_fieldList = ['DIR']
countyObj.LEGAL_DESC_fieldList = ['DSDESC']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCELNBR']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Chisago'
countyObj.cty_fips = r'25'
countyObj.county_id = r'025'
countyObj.cty_abbr = r'CHIS'
countyObj.mngeo_web_id = r'Chisago 025'
countyObj.sourceZipFile = r'CHIS_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PlatName']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['Block']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['Lot']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['gisacres']
countyObj.ACRES_DEED_fieldList = ['DeedAcre']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'concatTruncateTwoFields'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['Ownname']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['PropAddr', 'PropUnit']
countyObj.OWN_ADD_L1_transferType = 'concatTruncateTwoFields'
countyObj.OWN_ADD_L2_fieldList = ['PropCity', 'PropZip']
countyObj.OWN_ADD_L2_transferType = 'concatTruncateTwoFields'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['MailAddr']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['MailCity', 'MailZip']
countyObj.TAX_ADD_L2_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TaxYear']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['LandValue']
countyObj.EMV_BLDG_fieldList = ['BldgValue']
countyObj.EMV_TOTAL_fieldList = ['TotalValue']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['School']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['Section']
countyObj.TOWNSHIP_fieldList = ['Township']
countyObj.RANGE_fieldList = ['Range']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LegalDesc']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = [
'Anoka', 'Carver', 'Dakota', 'Hennepin', 'Ramsey', 'Scott',
'Washington'
]
countyObj.cty_fips = ['3', '19', '37', '53', '123', '139', '163']
countyObj.county_id = ['003', '019', '037', '053', '123', '139', '163']
countyObj.cty_abbr = [
'ANOK_mgc', 'CARV_mgc', 'DAKO_mgc', 'HENN_mgc', 'RAMS_mgc', 'SCOT_mgc',
'WASH_mgc'
]
countyObj.mngeo_web_id = [
'Anoka 003', 'Carver 019', 'Dakota 037', 'Hennepin 053', 'Ramsey 123',
'Scott 139', 'Washington 163'
]
countyObj.sourceZipFile = r'fgdb_plan_regonal_parcels_2015.zip'
countyObj.sourcePolygons = [
r'plan_regonal_parcels_2015.gdb\Parcels2015Anoka',
r'plan_regonal_parcels_2015.gdb\Parcels2015Carver',
r'plan_regonal_parcels_2015.gdb\Parcels2015Dakota',
r'plan_regonal_parcels_2015.gdb\Parcels2015Hennepin',
r'plan_regonal_parcels_2015.gdb\Parcels2015Ramsey',
r'plan_regonal_parcels_2015.gdb\Parcels2015Scott',
r'plan_regonal_parcels_2015.gdb\Parcels2015Washington'
]
countyObj.sourceOwnershipZipFile = ['', '', '', '', '', '', '']
countyObj.sourceOwnershipTable = ['', '', '', '', '', '', '']
countyObj.joinInField = ['', '', '', '', '', '', '']
countyObj.joinJoinField = ['', '', '', '', '', '', '']
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['BLDG_NUM']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = ['PREFIX_DIR']
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = ['PREFIXTYPE']
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['STREETNAME']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['STREETTYPE']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['SUFFIX_DIR']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['UNIT_INFO']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = ['CITY_USPS']
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['ZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = ['ZIP4']
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLAT_NAME']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['ACRES_POLY']
countyObj.ACRES_DEED_fieldList = ['ACRES_DEED']
countyObj.USE1_DESC_fieldList = ['USE1_DESC']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['USE2_DESC']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['USE3_DESC']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = ['USE4_DESC']
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = ['MULTI_USES']
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = ['LANDMARK']
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNER_NAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['OWNER_MORE']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWN_ADD_L1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWN_ADD_L2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWN_ADD_L3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TAX_NAME']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TAX_ADD_L1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TAX_ADD_L2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TAX_ADD_L3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['HOMESTEAD']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['EMV_LAND']
countyObj.EMV_BLDG_fieldList = ['EMV_BLDG']
countyObj.EMV_TOTAL_fieldList = ['EMV_TOTAL']
countyObj.TAX_CAPAC_fieldList = ['TAX_CAPAC']
countyObj.TOTAL_TAX_fieldList = ['TOTAL_TAX']
countyObj.SPEC_ASSES_fieldList = ['SPEC_ASSES']
countyObj.TAX_EXEMPT_fieldList = ['TAX_EXEMPT']
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = ['XUSE1_DESC']
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = ['XUSE2_DESC']
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = ['XUSE3_DESC']
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = ['XUSE4_DESC']
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = ['DWELL_TYPE']
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = ['HOME_STYLE']
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = ['FIN_SQ_FT']
countyObj.GARAGE_fieldList = ['GARAGE']
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = ['GARAGESQFT']
countyObj.BASEMENT_fieldList = ['BASEMENT']
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = ['HEATING']
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = ['COOLING']
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = ['YEAR_BUILT']
countyObj.NUM_UNITS_fieldList = ['NUM_UNITS']
countyObj.SALE_DATE_fieldList = ['SALE_DATE']
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = ['SALE_VALUE']
countyObj.SCHOOL_DST_fieldList = ['SCHOOL_DST']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = ['WSHD_DIST']
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = ['GREEN_ACRE']
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = ['OPEN_SPACE']
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = ['AG_PRESERV']
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = ['AGPRE_ENRD']
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = ['AGPRE_EXPD']
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = ['PARC_CODE']
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = []
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = []
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Beltrami'
countyObj.cty_fips = r'7'
countyObj.county_id = r'007'
countyObj.cty_abbr = r'BELT'
countyObj.mngeo_web_id = r'Beltrami 007'
countyObj.sourceZipFile = r'BELT_parcels.zip'
countyObj.sourcePolygons = r'Beltrami_Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['PAADRLN1']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['PAADRLN1']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['PACITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['PAZIPCD6']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PTDSC']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['PLBLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['PLLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['ACRES']
countyObj.ACRES_DEED_fieldList = ['PYACRES']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['NMNAME1']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['NMNAME2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['NAADRLN1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['NAADRLN2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['NACITY', 'NASTATE', 'NAZIPCD6']
countyObj.OWN_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['AVHSCD']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['PLSECTN']
countyObj.TOWNSHIP_fieldList = ['PLTWNSHP']
countyObj.RANGE_fieldList = ['PLRANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['DERIVED_01']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Wright'
countyObj.cty_fips = r'171'
countyObj.county_id = r'171'
countyObj.cty_abbr = r'WRIG'
countyObj.mngeo_web_id = r'Wright 171'
countyObj.sourceZipFile = r'WRIG_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCEL']
countyObj.BLDG_NUM_fieldList = ['PropHouse']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = ['PropHsSuf']
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['PropStr']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['PropStrTyp']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['PropStrDir']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['PropUnit']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['PropCity']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['PropZip']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['ACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TPSortName']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TPAddr1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TPAddr2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TPAddr3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['TPCity', 'TPState', 'TPZip']
countyObj.TAX_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TaxYear']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['SumMVLand']
countyObj.EMV_BLDG_fieldList = ['SumMVBldg']
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = ['SQ_FT']
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = ['SALPRICE']
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = []
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCEL']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Carlton'
countyObj.cty_fips = r'17'
countyObj.county_id = r'017'
countyObj.cty_abbr = r'CARL'
countyObj.mngeo_web_id = r'Carlton 017'
countyObj.sourceZipFile = r'CARL_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCELID']
countyObj.BLDG_NUM_fieldList = ['PHYSADDR']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['PHYSADDR']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['PHYSCITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['PHYSZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLDESC']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['APBLOK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['APLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWADR1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWADR2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWADR3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['OWADR4']
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TXNAME']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TXADR1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TXADR2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TXADR3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['TXADR4']
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = ['Land_Class']
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['TPHSTC']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['TPYEAR']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = ['ESTTOTVAL']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TPNTAX']
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['APSECT']
countyObj.TOWNSHIP_fieldList = ['APTOWN']
countyObj.RANGE_fieldList = ['APRANG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCELID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Dodge'
countyObj.cty_fips = r'39'
countyObj.county_id = r'039'
countyObj.cty_abbr = r'DODG'
countyObj.mngeo_web_id = r'Dodge 039'
countyObj.sourceZipFile = r'DODG_parcels.zip'
countyObj.sourcePolygons = r'dodge.gdb\Parcels'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['C0HSENO1']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['C0STRNM']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['C0STRTP']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['C0STRDIR']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['C0CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['C0ZIPCD6S']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = ['C0ZIPCD4S']
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['C0PLATDS']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['C0BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['C0LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['C0ACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['C0NAME1P']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['C0NAME2P']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['C0ADRLN1P']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['C0ADRLN2P']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['C0ADRLN3P']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['C0CITYP', 'C0STATEP', 'C0ZIPCD6P']
countyObj.OWN_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['C0ENTDSC']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['C0SECTN']
countyObj.TOWNSHIP_fieldList = ['C0TWNSHP']
countyObj.RANGE_fieldList = ['C0RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['SHORTLEGAL']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Lincoln'
countyObj.cty_fips = r'81'
countyObj.county_id = r'081'
countyObj.cty_abbr = r'LINC'
countyObj.mngeo_web_id = r'Lincoln 081'
countyObj.sourceZipFile = r'LINC_parcels.zip'
countyObj.sourcePolygons = r'parcels_12232013.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCEL_NUM']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['ADDITION']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['CALC_ACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['O_NAME1']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['O_NAME2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['O_ADD1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['O_ADD2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['O_CITY', 'O_STATE', 'O_ZIP']
countyObj.OWN_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TP_NAME1', 'TP_NAME2']
countyObj.TAX_NAME_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L1_fieldList = ['TP_ADD1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TP_ADD2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TP_CITY', 'TP_STATE', 'TP_ZIP']
countyObj.TAX_ADD_L3_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['SEC']
countyObj.TOWNSHIP_fieldList = ['TWP']
countyObj.RANGE_fieldList = ['RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGDES1', 'LEGDES2'] #TODO - ADD 'LEGDES3'
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCEL_NUM']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Grant'
countyObj.cty_fips = r'51'
countyObj.county_id = r'051'
countyObj.cty_abbr = r'GRAN'
countyObj.mngeo_web_id = r'Grant 051'
countyObj.sourceZipFile = r'GRAN_parcels.zip'
countyObj.sourcePolygons = r'grant.gdb\parcels'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = []
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_PROPERTY_ADDRESS'
]
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_PROPERTY_ZIP'
]
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_PLAT_NAME'
]
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['GrantCountyTaxData_dbo_tblParcelJoin_BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['GrantCountyTaxData_dbo_tblParcelJoin_LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['CDSTRL_Parcels_GIS_Acres']
countyObj.ACRES_DEED_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_DEEDED_ACRES'
]
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_OWNER_NAME'
]
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_OWNER_ADDRESS_1'
]
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_OWNER_ADDRESS_2'
]
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_TAXPAYER_NAME'
]
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_TAXPAYER_ADDRESS'
]
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_TAXPAYER_ADDRESS_2'
]
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_TAX_YEAR'
]
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_SCHOOL_DISTRICT_NAME'
]
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_SECTION'
]
countyObj.TOWNSHIP_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_TOWNSHIP'
]
countyObj.RANGE_fieldList = ['GrantCountyTaxData_dbo_tblParcelJoin_RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = [
'GrantCountyTaxData_dbo_tblParcelJoin_LEGAL'
]
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = []
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Brown'
countyObj.cty_fips = r'15'
countyObj.county_id = r'015'
countyObj.cty_abbr = r'BROW'
countyObj.mngeo_web_id = r'Brown 015'
countyObj.sourceZipFile = r'BROW_parcels.zip'
countyObj.sourcePolygons = r'parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['V1LOCHOUSE']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['V1LOCSTREE']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['V1LOCTP']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['V1LOCDIR']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['V1LOCCITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['V1LOCZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['V1LGLPLAT']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['V1LGLBLK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['V1LGLLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['V1SORTNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['V1OWHOUSE', 'V1OWSTREET']
countyObj.OWN_ADD_L1_transferType = 'concatTruncateTwoFields'
countyObj.OWN_ADD_L2_fieldList = ['V1OWADDR2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['V1OWADDR3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['V1OWCITY', 'V1OWST', 'V1OWZIP']
countyObj.OWN_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['V1EMVLAND']
countyObj.EMV_BLDG_fieldList = ['V1EMVBLDG']
countyObj.EMV_TOTAL_fieldList = ['V1EMVTOTAL']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['V1LGLSEC']
countyObj.TOWNSHIP_fieldList = ['V1LGLTWP']
countyObj.RANGE_fieldList = ['V1LGLRNG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['V1LGLDSC1']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Houston'
countyObj.cty_fips = r'55'
countyObj.county_id = r'055'
countyObj.cty_abbr = r'HOUS'
countyObj.mngeo_web_id = r'Houston 055'
countyObj.sourceZipFile = r'HOUS_parcels.zip'
countyObj.sourcePolygons = r'HoustonCoParcels5_2015.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCELID']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['GP_CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['GP_BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['GP_LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['GROSSACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNER']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['OWNER2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWNERADDR']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWNERCITY', 'OWNERZIP']
countyObj.OWN_ADD_L2_transferType = 'concatTruncateTwoFields'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['LandVal']
countyObj.EMV_BLDG_fieldList = ['BldgVal']
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['SchoolDist']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = ['WatershedD']
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['PLS_SECT']
countyObj.TOWNSHIP_fieldList = ['GP_LEGL_TW']
countyObj.RANGE_fieldList = ['GP_RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL1', 'LEGAL2']
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCELID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Pipestone'
countyObj.cty_fips = r'117'
countyObj.county_id = r'117'
countyObj.cty_abbr = r'PIPE'
countyObj.mngeo_web_id = r'Pipestone 117'
countyObj.sourceZipFile = r'PIPE_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PID']
countyObj.BLDG_NUM_fieldList = ['HouseNbr']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['Address']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['City']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['ZIP']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['Plat']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['Block']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['Lot']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['AcresGIS']
countyObj.ACRES_DEED_fieldList = ['AcresDeed']
countyObj.USE1_DESC_fieldList = ['Class']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = []
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TaxLName', 'AltTaxName']
countyObj.TAX_NAME_transferType = 'concatTruncateTwoFields'
countyObj.TAX_ADD_L1_fieldList = ['TaxAddL1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TaxAddL2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['AltTaxAddL']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['AltTaxAd_1']
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['HSTDDesc']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = ['Year']
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['EMVLand']
countyObj.EMV_BLDG_fieldList = ['EMVBldg']
countyObj.EMV_TOTAL_fieldList = ['EMVTotal']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['School']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['Section']
countyObj.TOWNSHIP_fieldList = ['Township']
countyObj.RANGE_fieldList = ['Range']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LegalD']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Mower'
countyObj.cty_fips = r'99'
countyObj.county_id = r'099'
countyObj.cty_abbr = r'MOWE'
countyObj.mngeo_web_id = r'Mower 099'
countyObj.sourceZipFile = r'MOWE_parcels.zip'
countyObj.sourcePolygons = r'01162015\20150113_Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = ['SAStreetNu']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = ['SAPredirec']
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['SAStreetNa']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = ['SAStreetTy']
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = ['SAPostdire']
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = ['SAUnitNumb']
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['SACity']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['SAPostalCd']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['CurOwnerNa']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['CurOwnerAd']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['CurOwnerCi', 'CurOwnerSt', 'CurOwnerPo']
countyObj.OWN_ADD_L2_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['AbbrDescr', 'AbbrDescr2']
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Murray'
countyObj.cty_fips = r'101'
countyObj.county_id = r'101'
countyObj.cty_abbr = r'MURR'
countyObj.mngeo_web_id = r'Murray 101'
countyObj.sourceZipFile = r'MURR_parcels.zip'
countyObj.sourcePolygons = r'MurrayCountyParcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PID']
countyObj.BLDG_NUM_fieldList = ['HouseNum']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['Street']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['City']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = ['ZipCode']
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['SECTWPRNG']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['CompAcres']
countyObj.ACRES_DEED_fieldList = ['DeedAcres']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['FIRSTLAST']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = []
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = []
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = []
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['ShortLegal']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Wilkin'
countyObj.cty_fips = r'167'
countyObj.county_id = r'167'
countyObj.cty_abbr = r'WILK'
countyObj.mngeo_web_id = r'Wilkin 167'
countyObj.sourceZipFile = r'WILK_parcels.zip'
countyObj.sourcePolygons = r'wilkin.gdb\Parcels'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['Parcels_PARCEL_NUM']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXPLATD']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXBLOK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXONAM']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXOAD1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXOAD2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXOAD3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXOAD4']
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTNAM']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTAD1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTAD2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTAD3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTAD4']
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = [
'WilkinAS400_dbo_Parcel_Values_Land_Market_Value'
]
countyObj.EMV_BLDG_fieldList = [
'WilkinAS400_dbo_Parcel_Values_Building_Market_Value'
]
countyObj.EMV_TOTAL_fieldList = [
'WilkinAS400_dbo_Parcel_Values_Total_Market_Value'
]
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXSECT']
countyObj.TOWNSHIP_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXTOWN']
countyObj.RANGE_fieldList = ['WilkinAS400_dbo_tblFlatTable_TXRANG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = [
'WilkinAS400_dbo_tblFlatTable_TXDSC1',
'WilkinAS400_dbo_tblFlatTable_TXDSC2'
] #TODO - MORE LEGAL DESC TO ADD
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['Parcels_PARCEL_NUM']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Fillmore'
countyObj.cty_fips = r'45'
countyObj.county_id = r'045'
countyObj.cty_abbr = r'FILL'
countyObj.mngeo_web_id = r'Fillmore 045'
countyObj.sourceZipFile = r'FILL_parcels.zip'
countyObj.sourcePolygons = r'FillmoreParcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PIN']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['Acres']
countyObj.ACRES_DEED_fieldList = ['P_DEEDACRE']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['N_NAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = ['N_NAME2']
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['PHYSADDR']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = []
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['MailAddr1']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['N_ADDR2']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['N_ADDR3']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = [
'N_CITY', 'N_STATE', 'N_ZIP', 'N_ZIP_PLUS'
]
countyObj.TAX_ADD_L4_transferType = 'concatTruncateTwoFields'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = ['H21']
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['AREVLA']
countyObj.EMV_BLDG_fieldList = ['AREVBL']
countyObj.EMV_TOTAL_fieldList = ['AREAMT']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['DISTRICT']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['GPSECTION']
countyObj.TOWNSHIP_fieldList = []
countyObj.RANGE_fieldList = ['GPRANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['L_LEGALDES']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Rice'
countyObj.cty_fips = r'131'
countyObj.county_id = r'131'
countyObj.cty_abbr = r'RICE'
countyObj.mngeo_web_id = r'Rice 131'
countyObj.sourceZipFile = r'RICE.zip'
countyObj.sourcePolygons = r'Rice County.gdb\parcel'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCELID']
countyObj.BLDG_NUM_fieldList = ['STREETNUM']
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = ['STREETNAME']
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = ['CITY']
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['GP_PLAT']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['GP_BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['GP_LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['GROSSACRES']
countyObj.ACRES_DEED_fieldList = []
countyObj.USE1_DESC_fieldList = ['CLASS']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['Class2']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['Class3']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = ['Class4']
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['DEEDHOLD']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['MAILADDR']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['MAILCITY', 'MAILSTATE', 'MAILZIP']
countyObj.OWN_ADD_L2_transferType = 'concatTruncateLastAddrLine'
countyObj.OWN_ADD_L3_fieldList = []
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['EMV_LAND']
countyObj.EMV_BLDG_fieldList = ['EMV_BLDG']
countyObj.EMV_TOTAL_fieldList = ['EMV_Total']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = ['TotTax']
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = ['SQFT']
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = ['YRBUILT']
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = ['SALEDATE']
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = ['SaleValue']
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['GP_SECTION']
countyObj.TOWNSHIP_fieldList = ['GP_LEGL_TW']
countyObj.RANGE_fieldList = ['GP_RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['Legal_Descr']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCELID']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Hubbard'
countyObj.cty_fips = r'57'
countyObj.county_id = r'057'
countyObj.cty_abbr = r'HUBB'
countyObj.mngeo_web_id = r'Hubbard 057'
countyObj.sourceZipFile = r'HUBB.zip'
countyObj.sourcePolygons = r'Hubbard.gdb\Parcels_07102016'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['hubbgis_GIS_Parcels_PIN']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = []
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['PLBLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['PLLOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['hubbgis_GIS_Parcels_Acres']
countyObj.ACRES_DEED_fieldList = ['PYACRES']
countyObj.USE1_DESC_fieldList = ['Class1']
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = ['Class2']
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = ['Class3']
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['PISORTNM']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['PIADRLN1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['PIADRLN2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['PIADRLN3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['PICITY', 'PISTATE', 'PIZIPCD6']
countyObj.OWN_ADD_L4_transferType = 'concatTruncateLastAddrLine'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['AVEVLA']
countyObj.EMV_BLDG_fieldList = ['AVEVBL']
countyObj.EMV_TOTAL_fieldList = ['EMVTOT']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['PLSECTN']
countyObj.TOWNSHIP_fieldList = ['PLTWNSHP']
countyObj.RANGE_fieldList = ['PLRANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LGDSC']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['hubbgis_GIS_Parcels_PIN']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Yellow Medicine'
countyObj.cty_fips = r'173'
countyObj.county_id = r'173'
countyObj.cty_abbr = r'YELL'
countyObj.mngeo_web_id = r'Yellow Medicine 173'
countyObj.sourceZipFile = r'YELL_parcels.zip'
countyObj.sourcePolygons = r'Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['PARCEL_NUM']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLAT_NAME']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = ['BLOCK']
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = ['LOT']
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = []
countyObj.ACRES_DEED_fieldList = ['DEEDED_ACR']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNER_NAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWNER_ADDR']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWNER_AD_1']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWNER_AD_2']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = ['OWNER_AD_3']
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = ['TAXPAYER_N']
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = ['TAXPAYER_A']
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = ['TAXPAYER_1']
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = ['TAXPAYER_2']
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = ['TAXPAYER_3']
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = []
countyObj.EMV_BLDG_fieldList = []
countyObj.EMV_TOTAL_fieldList = []
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = ['SCHOOL_DIS']
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['SECTION']
countyObj.TOWNSHIP_fieldList = ['TOWNSHIP']
countyObj.RANGE_fieldList = ['RANGE']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL']
countyObj.LEGAL_DESC_transferType = 'defaultTransfer'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['PARCEL_NUM']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
def createCountyObj():
countyObj = countyEtlParams()
countyObj.county_name = 'Todd'
countyObj.cty_fips = r'153'
countyObj.county_id = r'153'
countyObj.cty_abbr = r'TODD'
countyObj.mngeo_web_id = r'Todd 153'
countyObj.sourceZipFile = r'TODD_parcels.zip'
countyObj.sourcePolygons = r'Todd_Parcels.shp'
countyObj.sourceOwnershipZipFile = r''
countyObj.sourceOwnershipTable = r''
countyObj.joinInField = r''
countyObj.joinJoinField = r''
countyObj.PIN_fieldList = ['par_id']
countyObj.BLDG_NUM_fieldList = []
countyObj.BLDG_NUM_transferType = 'defaultTransfer'
countyObj.PREFIX_DIR_fieldList = []
countyObj.PREFIX_DIR_transferType = 'defaultTransfer'
countyObj.PREFIXTYPE_fieldList = []
countyObj.PREFIXTYPE_transferType = 'defaultTransfer'
countyObj.STREETNAME_fieldList = []
countyObj.STREETNAME_transferType = 'defaultTransfer'
countyObj.STREETTYPE_fieldList = []
countyObj.STREETTYPE_transferType = 'defaultTransfer'
countyObj.SUFFIX_DIR_fieldList = []
countyObj.SUFFIX_DIR_transferType = 'defaultTransfer'
countyObj.UNIT_INFO_fieldList = []
countyObj.UNIT_INFO_transferType = 'defaultTransfer'
countyObj.CITY_fieldList = []
countyObj.CITY_transferType = 'defaultTransfer'
countyObj.CITY_USPS_fieldList = []
countyObj.CITY_USPS_transferType = 'defaultTransfer'
countyObj.ZIP_fieldList = []
countyObj.ZIP_transferType = 'defaultTransfer'
countyObj.ZIP4_fieldList = []
countyObj.ZIP4_transferType = 'defaultTransfer'
countyObj.PLAT_NAME_fieldList = ['PLDESC']
countyObj.PLAT_NAME_transferType = 'defaultTransfer'
countyObj.BLOCK_fieldList = []
countyObj.BLOCK_transferType = 'defaultTransfer'
countyObj.LOT_fieldList = []
countyObj.LOT_transferType = 'defaultTransfer'
countyObj.ACRES_POLY_fieldList = ['GISacres']
countyObj.ACRES_DEED_fieldList = ['DeededAcre']
countyObj.USE1_DESC_fieldList = []
countyObj.USE1_DESC_transferType = 'defaultTransfer'
countyObj.USE2_DESC_fieldList = []
countyObj.USE2_DESC_transferType = 'defaultTransfer'
countyObj.USE3_DESC_fieldList = []
countyObj.USE3_DESC_transferType = 'defaultTransfer'
countyObj.USE4_DESC_fieldList = []
countyObj.USE4_DESC_transferType = 'defaultTransfer'
countyObj.MULTI_USES_fieldList = []
countyObj.MULTI_USES_transferType = 'defaultTransfer'
countyObj.LANDMARK_fieldList = []
countyObj.LANDMARK_transferType = 'defaultTransfer'
countyObj.OWNER_NAME_fieldList = ['OWNAME']
countyObj.OWNER_NAME_transferType = 'defaultTransfer'
countyObj.OWNER_MORE_fieldList = []
countyObj.OWNER_MORE_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L1_fieldList = ['OWADR1']
countyObj.OWN_ADD_L1_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L2_fieldList = ['OWADR2']
countyObj.OWN_ADD_L2_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L3_fieldList = ['OWADR3']
countyObj.OWN_ADD_L3_transferType = 'defaultTransfer'
countyObj.OWN_ADD_L4_fieldList = []
countyObj.OWN_ADD_L4_transferType = 'defaultTransfer'
countyObj.TAX_NAME_fieldList = []
countyObj.TAX_NAME_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L1_fieldList = []
countyObj.TAX_ADD_L1_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L2_fieldList = []
countyObj.TAX_ADD_L2_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L3_fieldList = []
countyObj.TAX_ADD_L3_transferType = 'defaultTransfer'
countyObj.TAX_ADD_L4_fieldList = []
countyObj.TAX_ADD_L4_transferType = 'defaultTransfer'
countyObj.OWNERSHIP_fieldList = []
countyObj.OWNERSHIP_transferType = 'defaultTransfer'
countyObj.HOMESTEAD_fieldList = []
countyObj.HOMESTEAD_transferType = 'defaultTransfer'
countyObj.TAX_YEAR_fieldList = []
countyObj.MARKET_YEAR_fieldList = []
countyObj.EMV_LAND_fieldList = ['AVLAND']
countyObj.EMV_BLDG_fieldList = ['AVBLDG']
countyObj.EMV_TOTAL_fieldList = ['AVTOTL']
countyObj.TAX_CAPAC_fieldList = []
countyObj.TOTAL_TAX_fieldList = []
countyObj.SPEC_ASSES_fieldList = []
countyObj.TAX_EXEMPT_fieldList = []
countyObj.TAX_EXEMPT_transferType = 'defaultTransfer'
countyObj.XUSE1_DESC_fieldList = []
countyObj.XUSE1_DESC_transferType = 'defaultTransfer'
countyObj.XUSE2_DESC_fieldList = []
countyObj.XUSE2_DESC_transferType = 'defaultTransfer'
countyObj.XUSE3_DESC_fieldList = []
countyObj.XUSE3_DESC_transferType = 'defaultTransfer'
countyObj.XUSE4_DESC_fieldList = []
countyObj.XUSE4_DESC_transferType = 'defaultTransfer'
countyObj.DWELL_TYPE_fieldList = []
countyObj.DWELL_TYPE_transferType = 'defaultTransfer'
countyObj.HOME_STYLE_fieldList = []
countyObj.HOME_STYLE_transferType = 'defaultTransfer'
countyObj.FIN_SQ_FT_fieldList = []
countyObj.GARAGE_fieldList = []
countyObj.GARAGE_transferType = 'defaultTransfer'
countyObj.GARAGESQFT_fieldList = []
countyObj.BASEMENT_fieldList = []
countyObj.BASEMENT_transferType = 'defaultTransfer'
countyObj.HEATING_fieldList = []
countyObj.HEATING_transferType = 'defaultTransfer'
countyObj.COOLING_fieldList = []
countyObj.COOLING_transferType = 'defaultTransfer'
countyObj.YEAR_BUILT_fieldList = []
countyObj.NUM_UNITS_fieldList = []
countyObj.SALE_DATE_fieldList = []
countyObj.SALE_DATE_transferType = 'ToDate'
countyObj.SALE_VALUE_fieldList = []
countyObj.SCHOOL_DST_fieldList = []
countyObj.SCHOOL_DST_transferType = 'defaultTransfer'
countyObj.WSHD_DIST_fieldList = []
countyObj.WSHD_DIST_transferType = 'defaultTransfer'
countyObj.GREEN_ACRE_fieldList = []
countyObj.GREEN_ACRE_transferType = 'defaultTransfer'
countyObj.OPEN_SPACE_fieldList = []
countyObj.OPEN_SPACE_transferType = 'defaultTransfer'
countyObj.AG_PRESERV_fieldList = []
countyObj.AG_PRESERV_transferType = 'defaultTransfer'
countyObj.AGPRE_ENRD_fieldList = []
countyObj.AGPRE_ENRD_transferType = 'ToDate'
countyObj.AGPRE_EXPD_fieldList = []
countyObj.AGPRE_EXPD_transferType = 'ToDate'
countyObj.PARC_CODE_fieldList = []
countyObj.SECTION_fieldList = ['PLSSEC']
countyObj.TOWNSHIP_fieldList = ['PLSTWP']
countyObj.RANGE_fieldList = ['PLSRNG']
countyObj.RANGE_DIR_fieldList = []
countyObj.LEGAL_DESC_fieldList = ['LEGAL1',
'LEGAL2'] #TODO - MORE LEGAL TO ADD IN
countyObj.LEGAL_DESC_transferType = 'concatTruncateTwoFields'
countyObj.EDIT_DATE_fieldList = []
countyObj.EDIT_DATE_transferType = 'ToDate'
countyObj.EXPORT_DATE_fieldList = []
countyObj.EXPORT_DATE_transferType = 'ToDate'
countyObj.ORIG_PIN_fieldList = ['par_id']
countyObj.ORIG_PIN_transferType = 'defaultTransfer'
return countyObj
