FALSE 1.0 CalculateField "Tax Parcels" LASTUPDATE "2/23/2016" VB # CalculateField "Tax Parcels" CNVYNAME 'SUNSET COVE' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'BAY BREEZE' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'HACIENDA WALK' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'BLACKBIRD HOMES' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'SEA VIEW RANCH' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'LAS BRISAS SUBDIVISION' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'SUNSHINE GARDEN' PYTHON_9.3 # CalculateField "Tax Parcels" CNVYNAME 'APPLE HILL' PYTHON_9.3 # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Parcels_Project_Layer;Assessor_Parcels_Project_Lay "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,-1,-1,Parcels_Project_Layer,Parcels_Project.APN,-1,-1;PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0 ,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0 ,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.Assessee,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.InCareOf,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Street,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_City,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_State,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Zip,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0 ,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0 ,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0 ,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0 ,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0 ,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0 ,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0 ,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0 ,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0 ,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0 ,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0 ,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0 ,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0 ,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0 ,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0 ,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0 ,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0 ,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0 ,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0 ,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#" # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Parcels_Project_Layer;Assessor_Parcels_Project_Lay "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,-1,-1,Parcels_Project_Layer,Parcels_Project.APN,-1,-1;PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0 ,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0 ,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.Assessee,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.InCareOf,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Street,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_City,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_State,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Zip,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0 ,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0 ,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0 ,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0 ,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0 ,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0 ,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0 ,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0 ,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0 ,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0 ,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0 ,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0 ,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0 ,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0 ,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0 ,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0 ,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0 ,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0 ,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0 ,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#" # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Parcels_Project_Layer;Assessor_Parcels_Project_Lay "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,-1,-1,Parcels_Project_Layer,Parcels_Project.APN,-1,-1;PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0 ,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0 ,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.Assessee,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.InCareOf,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Street,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_City,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_State,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Zip,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0 ,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0 ,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0 ,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0 ,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0 ,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0 ,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0 ,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0 ,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0 ,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0 ,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0 ,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0 ,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0 ,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0 ,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0 ,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0 ,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0 ,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0 ,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0 ,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#" # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip):\n if OwnZip.find('-') > 0:\n output = OwnZip[OwnZip.find('-')+1:]\n else:\n output = None\n return output\n \n\n" CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Parcels_Project_Layer;Assessor_Parcels_Project_Lay "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,-1,-1,Parcels_Project_Layer,Parcels_Project.APN,-1,-1;PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0 ,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0 ,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.Assessee,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.InCareOf,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Street,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_City,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_State,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0 ,First,#,Parcels_Project_Layer,CntyData.A_Zip,-1,-1,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0 ,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0 ,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0 ,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0 ,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0 ,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0 ,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0 ,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0 ,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0 ,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0 ,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0 ,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0 ,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0 ,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0 ,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0 ,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0 ,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0 ,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0 ,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0 ,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0 ,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0 ,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0 ,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#" # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip):\n if OwnZip.find('-') > 0:\n output = OwnZip[OwnZip.find('-')+1:]\n else:\n output = None\n return output\n \n\n" CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # CalculateField "Tax Parcels" COUNTY "SC" VB # CalculateField "Tax Parcels" COUNTY "MO" VB # CalculateField "Tax Parcels" COUNTY "SC" VB # CalculateField "Tax Parcels" COUNTY "MO" VB # CalculateField "Tax Parcels" Strap int(!LOWPARCELID!) PYTHON_9.3 # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Parcels_Project_Layer;Assessor_Parcels_Project_Lay "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,0,32,Parcels_Project_Layer,Parcels_Project.APN,0,80;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#;BUILDING "Building Number" true true false 50 Text 0 0,First,#;UNIT "Unit Number" true true false 50 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,0,16;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,0,64;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.Assessee,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.InCareOf,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Street,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_City,0,35,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_State,0,2,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Zip,0,12,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,0,16;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#" # # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip): if OwnZip.find('-') > 0: output = OwnZip[OwnZip.find('-')+1:] else: output = None return output " CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" NO_TEST "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.APNNODASH,0,32,Parcels_Project_Layer,Parcels_Project.APN,0,80;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#;BUILDING "Building Number" true true false 50 Text 0 0,First,#;UNIT "Unit Number" true true false 50 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,0,16;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,0,64;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.Assessee,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.InCareOf,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Street,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_City,0,35,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_State,0,2,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Zip,0,12,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,0,16;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#" # # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip): if OwnZip.find('-') > 0: output = OwnZip[OwnZip.find('-')+1:] else: output = None return output " CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # DeleteField "Tax Parcels" Strap DeleteField "Tax Parcels" COUNTY UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\Parcel Updates\DataOut\working.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>CVTTXCD</field_name><field_type>TEXT</field_type><field_length>5</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\Parcel Updates\DataOut\working.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>CVTTXCD</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APN,0,30;BUILDING "Building Number" true true false 50 Text 0 0,First,#;UNIT "Unit Number" true true false 50 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0,First,#;CVTTXCD "Tax District Code" true true false 4 Text 0 0,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.ASRUSECD,0,16;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Project_Lay,ParcelInfo.USECDDESC,0,64;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.Assessee,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.InCareOf,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Street,0,50,Assessor_Parcels_Project_Lay,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_City,0,35,Assessor_Parcels_Project_Lay,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_State,0,2,Assessor_Parcels_Project_Lay,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Parcels_Project_Layer,CntyData.A_Zip,0,12,Assessor_Parcels_Project_Lay,ParcelInfo.OWNZIP,0,16;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#" # # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip): if OwnZip.find('-') > 0: output = OwnZip[OwnZip.find('-')+1:] else: output = None return output " CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # CalculateField TaxParcel_Layer SITEADDRESS conc(!WatsonvilleGISLGDM.DBO.ParcelInfo.SITEADD!,!WatsonvilleGISLGDM.DBO.ParcelInfo.SITEADD2!) PYTHON3 "def conc(siteadd, siteadd2): if len(siteadd) > 0: return siteadd + ', ' + siteadd2 else: return None" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APN,0,14;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#" # # CalculateField "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" USEDSCRP !USEDSCRP![4:] PYTHON_9.3 # CalculateField TaxParcel_Layer PSTLZIP4 ZipCalc( !PSTLZIP5!) PYTHON_9.3 "def ZipCalc(OwnZip): if OwnZip.find('-') > 0: output = OwnZip[OwnZip.find('-')+1:] else: output = None return output " CalculateField TaxParcel_Layer PSTLZIP5 !PSTLZIP5![:5] PYTHON_9.3 # CalculateField TaxParcel_Layer SITEADDRESS conc(!WatsonvilleGISLGDM.DBO.ParcelInfo.SITEADD!,!WatsonvilleGISLGDM.DBO.ParcelInfo.SITEADD2!) PYTHON3 "def conc(siteadd, siteadd2): if len(siteadd) > 0: return siteadd + ', ' + siteadd2 else: return None" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer1 "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#;BUILDING "Building Number" true true false 50 Text 0 0,First,#;UNIT "Unit Number" true true false 50 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0,First,#;CVTTXCD "Tax District Code" true true false 10 Text 0 0,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0,First,#;SCHLTXCD "School District Code" true true false 4 Text 0 0,First,#;SCHLDSCRP "School District Description" true true false 100 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0,First,#;CLASSDSCRP "Property Class" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;PRPRTYDSCRP "Property Description" true true false 255 Text 0 0,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;PSTLZIP4 "Postal Zip +4" true true false 4 Text 0 0,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0,First,#;BLDGAREA "Building Area" true true false 8 Double 0 0,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 0 0,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0,First,#;LNDVALUE "Land Value" true true false 8 Double 0 0,First,#;IMPRVVLAUE "Improvement Value" true true false 8 Double 0 0,First,#;PRSNLVALUE "Personal Value" true true false 8 Double 0 0,First,#;LVIMPVALUE "Living Improvement" true true false 8 Double 0 0,First,#;EXMPTAMNT "Exemption Amount" true true false 8 Double 0 0,First,#;EXMPTTYPE "Exemption Type" true true false 50 Text 0 0,First,#;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0,First,#;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0,First,#;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0,First,#;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0,First,#;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0,First,#;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # Append AssessorsParcels_Layer1 "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer1,AssessorsParcels.APN,0,14;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer1,AssessorsParcels.APN,0,14;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.USECDDESC,0,3;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.USECDDESC,0,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer1 "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer1,AssessorsParcels.APN,0,14;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer1,AssessorsParcels.APN,0,14;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.USECDDESC,2,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer1,ParcelInfo.SITEADD,0,64,AssessorsParcels_Layer1,ParcelInfo.SITEADD2,0,64;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer1,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer1,ParcelInfo.OWNZIP,0,16;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\Parcel Updates\DataOut\working.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>BUILDING</field_name><field_name>UNIT</field_name><field_name>LGLSTARTDT</field_name><field_name>CVTTXCD</field_name><field_name>CVTTXDSCRP</field_name><field_name>SCHLTXCD</field_name><field_name>SCHLDSCRP</field_name><field_name>NGHBRHDCD</field_name><field_name>CLASSCD</field_name><field_name>CLASSDSCRP</field_name><field_name>PRPRTYDSCRP</field_name><field_name>FLOORCOUNT</field_name><field_name>BLDGAREA</field_name><field_name>RESFLRAREA</field_name><field_name>RESYRBLT</field_name><field_name>RESSTRTYP</field_name><field_name>STRCLASS</field_name><field_name>CLASSMOD</field_name><field_name>LNDVALUE</field_name><field_name>IMPRVVLAUE</field_name><field_name>PRSNLVALUE</field_name><field_name>LVIMPVALUE</field_name><field_name>EXMPTAMNT</field_name><field_name>EXMPTTYPE</field_name><field_name>PRVASSDVAL</field_name><field_name>CNTASSDVAL</field_name><field_name>ASSDVALYRCG</field_name><field_name>ASSDPCNTCG</field_name><field_name>PRVTXBLVAL</field_name><field_name>CNTTXBLVAL</field_name><field_name>TXBLVALYRCHG</field_name><field_name>TXBLPCNTCHG</field_name><field_name>PRVWNTTXOD</field_name><field_name>PRVSMRTXOD</field_name><field_name>TOTPRVTXTOD</field_name><field_name>CNTWNTTXOD</field_name><field_name>CNTSMRTXOD</field_name><field_name>TOTCNTTXOD</field_name><field_name>TXODYRCHG</field_name><field_name>TXODPCNTCHG</field_name><field_name>WATERSERV</field_name><field_name>SEWERSERV</field_name></DeleteField></workflow></operationSequence> TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ";OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ";OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.SITEADD,0,255,AssessorsParcels_Layer,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,255;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,255,AssessorsParcels_Layer,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # DeleteField "TaxParcel (2)" PSTLZIP4 TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.SITEADD,0,255,AssessorsParcels_Layer,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,255;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,255,AssessorsParcels_Layer,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APN,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.SITEADD,0,255,AssessorsParcels_Layer,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,255;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,255,AssessorsParcels_Layer,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APNNODASH,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.APN,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.SITEADD,0,255,AssessorsParcels_Layer,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,255;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,255,AssessorsParcels_Layer,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels_Layer "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,Join,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.USECDDESC,0,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.SITEADD,0,64,AssessorsParcels_Layer,ParcelInfo.SITEADD2,0,64;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,", ",AssessorsParcels_Layer,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels_Layer,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels_Layer,ParcelInfo.OWNZIP,0,16;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels_Layer,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels,AssessorsParcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,Join,#;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ";OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,", ";OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ";PSTLCITY "Postal City" true true false 255 Text 0 0,First,#;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels,AssessorsParcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,Join,#,AssessorsParcels,ParcelInfo.APNNODASH,0,32,AssessorsParcels,ParcelInfo.APNSUFFIX,0,14;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels,ParcelInfo.USECDDESC,0,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels,ParcelInfo.SITEADD,0,64,AssessorsParcels,ParcelInfo.SITEADD2,0,64;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,", ",AssessorsParcels,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNZIP,0,16;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # CalculateField "TaxParcel (3)" USECD !USEDSCRP![:2] "Python 3" # CalculateField "TaxParcel (3)" USECD !USECD![:3] "Python 3" # CalculateField "TaxParcel (3)" USECD !USEDSCRP![:3] "Python 3" # CalculateField "TaxParcel (3)" USEDSCRP !USEDSCRP![4:] "Python 3" # DeleteField "TaxParcel (3)" CNVYNAME TruncateTable "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append AssessorsParcels "P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" "Use the Field Map to reconcile schema differences" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,AssessorsParcels,AssessorsParcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,Join,#,AssessorsParcels,ParcelInfo.APNNODASH,0,32,AssessorsParcels,ParcelInfo.APNSUFFIX,0,14;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,AssessorsParcels,ParcelInfo.SQUAREFT,0,30;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,AssessorsParcels,ParcelInfo.USECDDESC,0,2;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,AssessorsParcels,ParcelInfo.USECDDESC,4,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels,ParcelInfo.SITEADD,0,64,AssessorsParcels,ParcelInfo.SITEADD2,0,64;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,", ",AssessorsParcels,ParcelInfo.OWNNAME,0,254;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,AssessorsParcels,ParcelInfo.COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",AssessorsParcels,ParcelInfo.OWNERADD,0,64;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNCITY,0,32;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNSTATE,0,4;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,AssessorsParcels,ParcelInfo.OWNZIP,0,16;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,AssessorsParcels,AssessorsParcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # CopyMultiple "'P:\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel' FeatureClass" "P:\PROJECTS\Parcel Updates\WatsonvilleGISLGDM.sde" WatsonvilleGISLGDM.DBO.ParcelPublishing\TaxParcel "TaxParcel FeatureClass WatsonvilleGISLGDM.DBO.TaxParcel #" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.5.0'><FeatureDataset>WatsonvilleGISLGDM.DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>SERVER=arcgisdb;INSTANCE=sde:sqlserver:arcgisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=arcgisdb;DATABASE=WatsonvilleGISLGDM;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>WatsonvilleGISLGDM.DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>INCITY</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Inside City Limits</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>BooleanDomain</field_domain></AddField></workflow></operationSequence>" CalculateField "Tax Parcels" INCITY 1 PYTHON3 # Text CalculateField "Tax Parcels" INCITY 0 PYTHON3 # Text WatsonvilleGISLGDM.DBO.TaxParcel 002 6145872.540000 6237858.503000 1770112.100000 1861493.232000 1 Server=gisdb; Service=sde:sqlserver:gisdb; Database=GIS; Version=dbo.DEFAULT ArcSDE Connection Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_California_III_FIPS_0403_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS[&quot;NAD_1983_StatePlane_California_III_FIPS_0403_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,6561666.666666666],PARAMETER[&quot;False_Northing&quot;,1640416.666666667],PARAMETER[&quot;Central_Meridian&quot;,-120.5],PARAMETER[&quot;Standard_Parallel_1&quot;,37.06666666666667],PARAMETER[&quot;Standard_Parallel_2&quot;,38.43333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,36.5],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2227]]</WKT><XOrigin>-115860600</XOrigin><YOrigin>-93269500</YOrigin><XYScale>2000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102643</WKID><LatestWKID>2227</LatestWKID></ProjectedCoordinateSystem> 20200228 11382900 20200228 11382900 20200503 13221200 The published representation of real property areas, combined with assessing and tax information from CAMA and Tax systems, and organized for consumption in desktop and web applications. This feature class contains redundant geometry in cases where there are multiple condominium units on a given tax parcel. Tax Parcels X-Ray Tax Parcels; Assessment Information NaN NaN NaN NaN OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SHAPE SHAPE Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. LASTUPDATE Last Update Date Date 8 0 0 The date of last update in maintenance database LOWPARCELID Lowest Parcel Identification Number String 30 0 0 The lowest tax parcel identification number used to uniquely identify the polygon in the tax parcel fabric OWNERNME1 First Owner Name String 255 0 0 The first owner name OWNERNME2 Second Owner Name String 255 0 0 The second owner name PARCELID Parcel Identification Number String 30 0 0 The tax parcel identification number used to uniquely identify real property on the tax roll PSTLADDRESS Postal Address String 255 0 0 The mailing address for the tax parcel PSTLCITY Postal City String 255 0 0 The mailing city for the tax parcel PSTLSTATE Postal State String 5 0 0 The mailing state for the tax parcel PSTLZIP5 Postal Zip 5 String 20 0 0 The mailing postal code SITEADDRESS Site Address String 255 0 0 The site address for the tax parcel STATEDAREA Stated Area String 50 0 0 The stated legal area as defined on the source document USECD Assessing Use Code String 4 0 0 The assessors use code USEDSCRP Assessing Use Description String 100 0 0 The assessors use description GlobalID GlobalID GlobalID 38 0 0 WatsonvilleGISLGDM.DBO.TaxParcel Feature Class 29210 INCITY Inside City Limits SmallInteger 2 5 0 SHAPE.STArea() SHAPE.STArea() Double 0 0 0 SHAPE.STLength() SHAPE.STLength() Double 0 0 0 Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595 Munis 1 -121.925699 -121.606621 37.101890 36.847522 munis Service published for the Munis MapLink application SDE Feature Class dataset EPSG 5.3(9.0.0) 29210 Simple FALSE 29210 TRUE FALSE 20200228 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACqiMxvmUu2ME7T0x8uCP1qeRxHGWIzjoB3PpVeeZ4oJS6+W2wlWU7hnH0/nQA6UzxyNI v71DgCIDBHuDT0uI5J5YVbMkRAcY6ZGR9azbieWB5pHh3OkoEbqPvfJ+nWksWjuDa3BWJJDvDKw5 LA4JHA5yDQBtUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA UUUUAFFFFABRRRQAUUUUAFFVjMZZCkLKcDLNnO32+vWn+Qrf6zdJ7N0/LpQAjHdcooAOz5j7Z4H9 afLGs0TxuMo6lWHqDSoiRrtRVUegGKfQBk3YWCyuB5fmr5yjErbuy9c5z9Ko2pdb63jlMQDYnEaO pCsxOQO555rTvLVru1njj2ljICu/7pwAD/X8aqXUPk3HmzJ5UcTK0ckKjkYIwxI9T/KgACakupXP lSL5Wdyq+SMck8e+4fka0EvMrCzxsFlC7SOxPqO3b86Yl1JcSyxqjxr0jkKdfU/SnuLiG1kJk8yQ nC/IBjOB0zz+dAFyisuCe7VnT7MAkewbM8qCvOMZzzVyG489nGx1A6MRww55B/CgCxRRRQAUUUUA FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU1mCqWY4AGSaAIr XHkjAwmfkz/d7VPVeBglvvb5V+ZuewySP0rJu75ruJkjdIFXaWeVuBnp7E45289s0Aa73EasUVg0 uOEU5Nc1JLPI3nwSecrKrOxch0LMPl6ex4GOvpWrHFGbpp4fNQyMQ+EzuAGBg8jByD/hjFK80Nkq xRhjPt/dRsgXqQOMADqRQBZtpSUjjaSESgkMi+2egzVe41GM7oY5NkolCHcM475Hr/nvUwhQWzN5 vktlv3meA/I3YPFR+StlBJvlQ/vd6NJJtxkY6/8AfXFAGfLdSSIginlMjnCNuKKwxklc9eM9eKaR OtmsYvpLlsqGkdiu1gckZBA9B689akd4luUWdhGDNlE3E/KABuPbv+tRyWaalePDbzT/AGWTBmAy ApAUgc9CcDnn6dwAXrfzbV1IcTCYhm+8SAAAcEse/b61cEil5XiBYbQcJjlueOeM9KpyRxWgjt7J ER0+QZJxGuCSQOcnn9fao7K6jFt9qOEZMrIsg2EjJw31PH/1uaANkHIBxj2NOqGUzYTythOfm3nt j298VNQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU1lD KVYZBGCKdUM+/wAr92CWyBxjOM89fbNAGN/akSq1rMXEszbIwrbvvADjvgZ9OCDU+o2V3c72g2A8 qBkAlTjPbg8evpUVqbW21J4niZbp34AYkFcZBOeOM44/rV0XySXDW5wI3GEkDDn5c/y5oArWrJaX JSWcPn5N5z2AIGM4GAeo4/GqN/qEs1xFe2kMxihPzP5Y+bG7IBPTjPPv+FRfYpknu7qZGB2qIlDh HVc9QeeSOT6dOetXLeHzIzbNMggjjAMifKwIIAD/ADcng8/y6EAgk1BNX0y1FmZIwzfMckOuFycE cHhvX+uL06wySmRp2XzYwWRVyRgZBz7dfXpVOOCKzggHlkxgbpACoZWO4uzY4X654xjtVxY5obKa cxNcSM5dUCYIGT78/n70ARpp7S3gmimikRE/dOWyyHI68HqBjOe3SotPgRJpDFLLCXJQPkMp2ttC 8556fhU8EVpZxqgUW8s0a4V2YEtzwTk8Z/r1zUkV3OkogvoF3REMJQCysMHkHHB/+vQBVLW0Mslp PcsvzZEjMCSdvOF7DB685qSzgjtb1BAZJcKoYyDJCnGMHsBk/nTJPsTXdxM93GY5sfKd2Qy84POM cdOOtR6dNc+dMbrYZSSglMQWRegyxHGPr/8AWoA25JPN3RxHI+6754X/AOvTbORHiYRMGSNyin6f 5xWC80iTAXEiWkUzBnUjIfb6Arnd8o49BW2HNtGPJt2aEJuG3qzE9P6kmgC9RUUU0cwJjdXCkqdp zgjqKloAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigApkkiRIXkY Ko6ljgU+kIyMHpQBjzxPeXcMsQeNo8nJcfkeT14I9s1Hd2MUpnUxBxIQoaLG5SQM49M8/wCcVf8A 7MtRIsiQhCG34T5QxxjkdP8A9Q9KgdILSEq8JQD5sAbg3Pr9cH+dAEdxawOZkkkDTPwofHHGdpbG cc8+34k1YHiuo286wMglKR/vgHUtjAPsvX8/fFJDbSXaRIwjMBcADGWTb0GcnKnDZ55/GolkudOS Y/at8rOIo1lYAkYHzgE4zyOPT60AXbe3edHQMdsjFZiDnyxjlFHbn8efamlzHLeKuokKsQKKOSow uDknB7enX8S5ZrlJDbwgvcbfMeQ4Ic4B2nptPPHoKzZruS3uGZYZJpLjkuBjBGOBzkggEcgdqALE Hmz6X5Bjll2bEKoQGccjLMDn34xg960otTtYYoY97l3JAQZdgc9D3rMuHMMU32O2WJpQPNjA2lVA I3Y4wBg8f41oRpbX1pEWjAk+9GxwfmOTnjvkE+xoAr2U9lNMl0ISsMsjCGaZwuWYkkKDznI/zins 1n9qktCZZH3pkMoxwQT82OenIPp9KekaRWkcMmZVZdsatGSCdp6E9M/561LL5txEqQu4E3EkgblC MAgDPB6/lQBFqMFtLayTSy74jyu+Viuec8D0HpUd1NcXD/Zwqy7SA6ISN6MCOewGfX/Clmn2zSW8 dpKsNrGCrPH8jEdAp784/wA5pmnXsokmeR0dH2ukcfJT+8Tycf8A1j9aALlxEtrY/ZrZSHcgKIvl 2kkDdx0A/wA5rTqrFE3k/vHDSMxfevTrkfgBgUrTTIQvloznsGPPv04FAFmiiigAooooAKKKKACi iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACq93ardQiNmZcMGBXqMVYooAwLq8bR 5dghVI5EJVy4WLIAAB9DjHr0qBo1MDTeRC0ccitsbqqkjhRgHnJ4Ptitm+tPPEUqAefAxeInpnGM fjVOyie682adVAeQSFFZuCFXCkYHIIFAEN9ILOU3MbqZHYSyxy5zt+6dp7YH1pYdPnnbzHnVQnyp sjI+Uex5zkEZ7j8KvNfxSyCCJlFyVJUSL908cEdR1FU8mzkxeSxx/adyrIj7Qp6njAxzk5znJ+tA FaC6F8SrQFrqSJolkBCq/ByWHb7uMEf/AFrVnDJas3mFk8hTuVH3BwOQeg5w3PTJ7d6zLmS80+5i FuyTJEWjWFpPmYcAcjoTn69fc1pXNpDFGzkFxJKfMO4hmPIAAJ56njGDnp3oAkt7ORlSOUMUVRJH IHLBTxkAHnp0zn+lVtiyyXUFyI1kUNJGgO4KOATjHyjgHr1JqaY3MMECyzRxFWxFN5ZOBtIyw6A8 j9aiNvtmMTKJZoYmCkAgYJ3HPseB155oAdGq6iJt0hYq7bFBzu/hDYOcA7evA5OPWobq0azjg+xx tHdk5yqhsgcbj15wcfj9KsyQxWlvHPE4DvIsh77xydvHB4zj1OKhCym3uljfzLyQM3myLsUcj5Mj HbH+OKAL9mk1pbw2qKJQQT5hboepzx6mr0cQTJ6serHqaytKkuVmlWaOOOEguAigBTnBBI/rzwa1 Fnhd9iSIzEZwDmgCWiiq4uFL/dbyzwJP4Sf896ALFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFF ABRRRQAUUUUAFFFFABRRRQAUUUUAFZGpw+Qv2yB/KkQHhF/1h9/Xvwa16imj82PHcEMp9wcigDMi uI7228zyxJd2+GZQDGS2M8dfy5ptxc3TT7duNqlgqAE4PADZxjJ9PTtVmK1Zblrq4kj81kQNsXaA QTyD1wenNLJHbyh3t2j3ggvjGH9j2oAz3KxmES2N0QBkO+0hOmRnOcDGeR1APao5ze3zRtsmhVuI 5AxB56BtvTp17ZB+ui+pKsCZiDSSN5YjzwxyRwccjj8iKglnmj0d5UJjaNGkUqBynPHoMcflQBSt ZDeXEiGJEaWZZm3sTgqMYU8jHy4PTqeK0ILTygyJKBI6fJvBbCcAjqO/v6cmquk3Ezx/vpkikncs Y1jxtG0ZwenUhvqxzWpMQ0RjiMQZWCAPjH04/CgDPsppZdSRmbNr5YMSBOUYjHJHb7w9Mg+1TXkl vPfwWzy7QjbnUcZ7AE+mcDHenWttIl47S2wVWBcOMZ3ZPBI5PXirSWcMcRjQEAkEnqSffP0oAzrt fOv/ADfszrFbOZJiMASYHynPfAJOP8akttVjlmkZo5k6gGQBQFBx0znOevGfypktpO8vkQwFYkYN 5skmd/fA9qmlshd3oEgZIIE2oo43MT1z3xjp70AWZEmmDBZI/KJUjGTuXqeffp34p5EoUqyLIhGC qfKR+Z/wqUIyuu1gEAxtx/WkEsfnmHd+827tvt0/pQBW8ieMB4pCWxyjsSp5J6/jirayIzsiupZe oB5FVnnlmLx26rwMF2JAB9uOaXy2ZVVUMW09cjI+n196ALdFFFABRRRQAUUUUAFFFFABRRRQAUUU UAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAVJkYSeZtR1wPvn7nuBisiZXLXVzNJiORRjbkcfwtx/ I89q6KsnVY43P71QYxtLFSd0fJ+YgdR1/KgCGK0WG8gjjm3BUBJ35bd8+WA+vWoLtpEvLeM26XMB kZAo/gbIO0kkD6flzUsivb6jazpal0cCJNmVII3ckehB79MfSr0tgr3aShmVeTIgJw54xn6Yznr+ tAGZBaRWmo5c7YcM+wx4YN93dkeoXOc5/TGvbWiwsZC25uQCSeB1PHYk8mlSF5UcXIDByPkzkD6f 57e9W6ACiiigAooooAKztSty8Ek8If7QifJs69+nvgn860aKAKljAbe0RGLFyMtuxnPfoKt0UUAF FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFZOoxzw3sN/Ed wjUoULYByf8A6/6Ctamsu5Sp6EY4oAz51ivZI18x4pV+6yMD7kY/D07VpVQt0unIeQFGzhstnpxw PQ4z261foAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigD//Z