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