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,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer "G:\My Drive\GIS\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,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer1 "G:\My Drive\GIS\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,ParcelInfo.LOWPARCEL,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,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer "G:\My Drive\GIS\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,ParcelInfo.LOWPARCEL,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,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer2 "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;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,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;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,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # Append Assessor_Parcels_Layer2 "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;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,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;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,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;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,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer3 "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;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,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;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,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;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,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # Append Assessor_Parcels_Layer3 "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,Assessor_Parcels_Layer3,Assessor_Parcels.APN,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.ASRUSECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer4 "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,Assessor_Parcels_Layer3,Assessor_Parcels.APN,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.ASRUSECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,Assessor_Parcels_Layer3,Assessor_Parcels.APN,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.ASRUSECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "G:\My Drive\GIS\PROJECTS\Parcel Updates\DataOut\working.gdb\TaxParcel" Append Assessor_Parcels_Layer "G:\My Drive\GIS\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,#,Assessor_Parcels_Layer2,Assessor_Parcels.APNNODASH,0,11;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,Join,#,Assessor_Parcels_Layer4,ParcelInfo.APNNODASH,0,30,Assessor_Parcels_Layer4,ParcelInfo.APNSUFFIX,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.SQUAREFT,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.ASRUSECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Assessor_Parcels_Layer3,ParcelInfo.USECDDESC,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.SITEADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.SITEADD2,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNNAME,0,256;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.COBY,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,Join,", ",Assessor_Parcels_Layer2,ParcelInfo.OWNERADD,0,255,Assessor_Parcels_Layer2,ParcelInfo.OWNERADD2,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Assessor_Parcels_Layer2,ParcelInfo.OWNZIP,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Assessor_Parcels_Layer2,Assessor_Parcels.last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # TruncateTable "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\TaxParcel" TruncateTable "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\TaxParcel" Rename "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\TaxParcel" "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\TaxParcelSchema" FeatureClass Merge 'Tax Parcels';'Mail List Parcels';'Monterey Parcels' "C:\Users\austin.robey\Desktop\Parcel Updates\DataOut\working.gdb\Parcels" "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,Tax Parcels,LOWPARCELID,0,30,Mail List Parcels,APNNODASH,0,11,Monterey Parcels,APN,0,80;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,Tax Parcels,PARCELID,0,30,Mail List Parcels,APNNODASH,0,11,Monterey Parcels,APN,0,80;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Tax Parcels,STATEDAREA,0,50,Mail List Parcels,SQUAREFT,0,30,Monterey Parcels,GIS_SQFT,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Tax Parcels,USECD,0,4,Mail List Parcels,ASRUSECD,0,16;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Tax Parcels,USEDSCRP,0,100,Mail List Parcels,USECDDESC,0,64;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#,Tax Parcels,SITEADDRESS,0,255,Mail List Parcels,SITEADD,0,64,Monterey Parcels,Situs_St,0,29;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Tax Parcels,OWNERNME1,0,255,Mail List Parcels,OWNNAME,0,254,Monterey Parcels,Assessee,0,50;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Tax Parcels,OWNERNME2,0,255,Mail List Parcels,COBY,0,64;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,Tax Parcels,PSTLADDRESS,0,255,Mail List Parcels,OWNERADD,0,64,Monterey Parcels,A_Street,0,50;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Tax Parcels,PSTLCITY,0,255,Mail List Parcels,OWNCITY,0,32,Monterey Parcels,A_City,0,35;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Tax Parcels,PSTLSTATE,0,5,Mail List Parcels,OWNSTATE,0,4,Monterey Parcels,A_State,0,2;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Tax Parcels,PSTLZIP5,0,20,Mail List Parcels,OWNZIP,0,16,Monterey Parcels,A_Zip,0,12;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Tax Parcels,LASTUPDATE,-1,-1,Mail List Parcels,DataDate,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0,First,#,Tax Parcels,SHAPE_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0,First,#,Tax Parcels,SHAPE_Area,-1,-1" ADD_SOURCE_INFO FeatureClassToFeatureClass Parcels "C:\Users\austin.robey\Desktop\Parcel Updates\gisdb.sde\GIS.DBO.zzLoad" TaxParcels_New # "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,Parcels,LOWPARCELID,0,30;PARCELID "Parcel Identification Number" true true false 30 Text 0 0,First,#,Parcels,PARCELID,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,Parcels,STATEDAREA,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,Parcels,USECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,Parcels,USEDSCRP,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#,Parcels,SITEADDRESS,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,Parcels,OWNERNME1,0,255;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0,First,#,Parcels,OWNERNME2,0,255;PSTLADDRESS "Postal Address" true true false 255 Text 0 0,First,#,Parcels,PSTLADDRESS,0,255;PSTLCITY "Postal City" true true false 255 Text 0 0,First,#,Parcels,PSTLCITY,0,255;PSTLSTATE "Postal State" true true false 5 Text 0 0,First,#,Parcels,PSTLSTATE,0,5;PSTLZIP5 "Postal Zip 5" true true false 20 Text 0 0,First,#,Parcels,PSTLZIP5,0,20;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,Parcels,LASTUPDATE,-1,-1;MERGE_SRC "MERGE_SRC" true true false 255 Text 0 0,First,#,Parcels,MERGE_SRC,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Parcels,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Parcels,Shape_Area,-1,-1" # Rename "C:\Users\austin.robey\Desktop\Parcel Updates\gisdb.sde\GIS.DBO.ParcelPublishing\GIS.DBO.TaxParcels_New" "C:\Users\austin.robey\Desktop\Parcel Updates\gisdb.sde\GIS.DBO.ParcelPublishing\GIS.DBO.TaxParcels" FeatureClass Rename "C:\Users\austin.robey\Desktop\Parcel Updates\gisdb.sde\GIS.DBO.ParcelPublishing\GIS.DBO.TaxParcels" "C:\Users\austin.robey\Desktop\Parcel Updates\gisdb.sde\GIS.DBO.ParcelPublishing\GIS.DBO.TaxParcel" FeatureClass AddRelate GIS.DBO.TaxParcel LOWPARCELID GIS.DBO.ParcelSecuredRoll PIN Relate1 "One to many" RemoveRelate GIS.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.8.0'><FeatureDataset>GIS.DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>SERVER=GISDB;INSTANCE=sde:sqlserver:GISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSAC:\Users\austin.robey\Desktop\Watsonville GISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSAC:\Users\austin.robey\Desktop\ISO_Hydrants_WatsonvilleDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSAC:\Users\austin.robey\Desktop\Watsonville GISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>CDBG</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>3</field_length><field_alias>Community Development Block Grant</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" 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.8.0'><FeatureDataset>GIS.DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>SERVER=GISDB;INSTANCE=sde:sqlserver:GISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CDBG</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>CDBG</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>BooleanSymbolValue</field_domain></AddField></workflow><workflow><AddField><field_name>LLMAD</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>LLMAD</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 TaxParcel CDBG 0 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField TaxParcel LLMAD 0 "Python 3" # Text NO_ENFORCE_DOMAINS 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.8.0'><FeatureDataset>GIS.DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>SERVER=GISDB;INSTANCE=sde:sqlserver:GISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISDB;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>LLMAD</field_name><domain_name>BooleanSymbolValue</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField TaxParcel CDBG 1 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField TaxParcel LLMAD 1 "Python 3" # Text NO_ENFORCE_DOMAINS FeatureClassToFeatureClass "City-Owned Parcels" "P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb" CityOwnedParcels # "LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0,First,#,City-Owned Parcels,LOWPARCELID,0,30;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,City-Owned Parcels,STATEDAREA,0,50;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,City-Owned Parcels,USECD,0,4;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,City-Owned Parcels,USEDSCRP,0,100;SITEADDRESS "Site Address" true true false 255 Text 0 0,First,#,City-Owned Parcels,SITEADDRESS,0,255;OWNERNME1 "First Owner Name" true true false 255 Text 0 0,First,#,City-Owned Parcels,OWNERNME1,0,255;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,City-Owned Parcels,LASTUPDATE,-1,-1;MERGE_SRC "MERGE_SRC" true true false 255 Text 0 0,First,#,City-Owned Parcels,MERGE_SRC,0,255;CDBG "CDBG" true true false 2 Short 0 5,First,#,City-Owned Parcels,CDBG,-1,-1;LLMAD "LLMAD" true true false 2 Short 0 5,First,#,City-Owned Parcels,LLMAD,-1,-1" # 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.8.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CityOwnedParcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>CITYLIMITS</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>CITYLIMITS</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField CityOwnedParcels CITYLIMITS 'Within City Limits' "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField CityOwnedParcels CITYLIMITS 'Outside City Limits' "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField CityOwnedParcels CITYLIMITS "Within City Limits" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField CityOwnedParcels CITYLIMITS "Outside City Limits" "Python 3" # Text NO_ENFORCE_DOMAINS 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.8.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CityOwnedParcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>NAME</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LANDSCAPEAREA</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Landscape Area</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PARKINGLOT</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Parking Lot(s)</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PRIMARYUSE</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Primary Use</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.8.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CityOwnedParcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>z1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>z1</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>z1a</field_name><field_type>DOUBLE</field_type><field_alias>z1a</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>z2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>z2</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>z2a</field_name><field_type>DOUBLE</field_type><field_alias>z2a</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.8.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CityOwnedParcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>PRIMARY_ZONING</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>PRIMARY_ZONING</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PRIMARY_PCT</field_name><field_type>DOUBLE</field_type><field_alias>PRIMARY_PCT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>SECONDARY_ZONING</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>SECONDARY_ZONING</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>SECONDARY_PCT</field_name><field_type>DOUBLE</field_type><field_alias>SECONDARY_PCT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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.8.0'><WorkspaceConnectionString>DATABASE=P:\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CityOwnedParcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>z1</field_name><field_name>z1a</field_name><field_name>z2</field_name><field_name>z2a</field_name></DeleteField></workflow></operationSequence> CityOwnedParcels 002 6134083.659000 6245263.845000 1770112.100000 1869013.949000 1 file://\\city.watsonville.org\cityshares\GIS\PROJECTS\2022\22-003 City-Owned Property\22-003 City-Owned Property.gdb Local Area Network 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/2.8.0'><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>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102643</WKID><LatestWKID>2227</LatestWKID></ProjectedCoordinateSystem> 20220106 15454400 20220106 15454400 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 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SHAPE Shape Geometry 0 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 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 CityOwnedParcels Feature Class 0 MERGE_SRC MERGE_SRC String 255 0 0 CDBG CDBG SmallInteger 2 0 0 LLMAD LLMAD SmallInteger 2 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. Shape_Area Shape_Area Double 8 0 0 Area of feature in internal units squared. Esri Positive real numbers that are automatically generated. Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.8.3.29751 City_Owned Parcels 1 -121.966519 -121.581315 37.122783 36.847023 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. City-owned Parcels Property City-Owned parcels. Identified via query on TaxParcel data with containment of 'WATSONVILLE CITY' string in the FIRSTOWNER field. Returned 196 parcels. 171 within city limits and 25 outside. File Geodatabase Feature Class dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE 20220106 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2+jvS 5AFJ2NABwTmkzSgcUFPTmgBM0tG00dDnNABR2pcDsaTPzcdKACkdQy7ST9VOMUc55paAD6U1nSPl 2CgkDJPUnpTsYrC1DQZr29luDcxhXKlA8ZLJgAcHcO4J6d6BpJ7m6OlFNjDLEisxZgoBY9z606gQ UUUUAHSiiigApetJ0ooAXtSUvWigAobA7igdDTGjDHJJzQBHI4bAFIsbN7CpgoXoKWgAH7tcDJU9 aAyk9DTl6cjimYOSRigBxHtxURi546VIrH8qXg+ooAh8o+oqXGAF9BS59OKSgCJ48crUdWaY8YPI 60CsQ1YX7oquQQcGrC/cFIELRRRTGNXIUZHNOX+VIeTgU4AYoAM0daSigAoxxRRQAUH1xRSj0NAC D3pe1DcUCgBKDwBRS/wUANBO7pwe9LSDp1paACiiigAopaM0AMdQ6lSSAfSkijEYIBJHvT6KAGIC sjjkg85NPpe9JQAo60lL2+tJ0oAKKKKAHcEegFNpcgjrigjHvQA3HPUijBxnJpaRuwoAUHjNA6Uh 9KWgAooooAayhhTlGBiigdaACiiigCoL11AY255JGN4yOlWlbcoYDGRmm/Y7aRdvkoCOgxwaeqhQ FAwB0FABSiikoADRS0lAC96TNH40ZGaADPrTAWLg446U+mNKEZVfjd0PagB5UEcjIpT0FRbMT7xn BGDzxUpHSgCNlV0KMMqwwaeMdBSMQg3NwMgU4564H4CgBKKXJ9aM/wCcUAJ2oprSohAZ1B96BLG5 +VgT7UAPwfSjBpCM45ooAXgUZ9hSUUAKeue1JQPf8qKAClABPP40lKO49aAAYHQc0lFFABSfxfhS 0hHcdaADvS5HrQDmigAooxSY+tAC0UnSloAKKKKAAEjHPen43jcOvcVFT0JVs+lABR2pzKPvD7p/ SmYOaAF7UUlFABQKXFJQAUyRFmjKN3qSjjPSgCK3V1j2OQcdDUp60lL1+tADe9OzxjvTT1paACgk AZNL16U1+VIoAjdYZOXVWOMcimxrGh/doq/SombjKnJHam28zSSDaMgHBIoEaGDgU2lPakoGFFFF ABjmgjHfNHQYHSgnBH8qAAe9KOhpMc048DFADaKKKACiiigBMCjHuaWigBNv50Zx1GPelooAMijA pNo9BQvSgBaKKKAAj14NA70oJxwxxRkc8UAKrYJB6HqKGXafbsabUkZB+Vunr6UAMx+FBFKylWIN Jk0AJ2opc/SgY+hoATiig0UAAORRRR1oAXqKaKWgjPI60AFL1+tJmigDL1e0kNv51vuDo26RA2Ny 4OQKzNPultrmGaPBgnwrcevRv8+tdPwRgjIrl9R0u4sllNvGHttwdQDzHznGPTIqlbVMdr2sdSe1 ISM4zzVTTb7+0bMThCnJXGcg4OMj2q0yhh6H1qRNWFoJAGc8VAWKhlb04NND7ioboDQBa4pOp4oq JrO2d/MeIFs+/WgCZSMdcmkquljbRsGWIBhyDk1Z6jNACUUUUAFFFFABRRRQAUUUUAFIvc+9LTRk duKAHUUm72NLQAikFRtPHalHBqhY3GP3Tnj+E1d8xM/fUfjQA49eKXtg0Agrwc+9IeaAHhww2v07 H0pGUqeeQehptOV8DBGV9KAG0U8pnlDkU3FABnijHpSUtACUUvX60YoASjkGo7ieO2geaQnYoycD ms5NftnUN5FyAQCMx/8A16B2NU8jIorn5tduftCvHGI7YOu7cuXKZ+Y47VLe6zLNe29npflM06M/ nucqmOxA5z9cUPTccYc2xt0o54PSuTutW1rS9Vgk1E2p0vaQ7WqF23ds5OR2PANTHxfDN+9sbV7m 1Hlh5VbaQz9AAep9annRp7CejWqOiRFiUJGoVR0AGBT6ByM0uD6VRiV5ydwFRr94fWrTKGGDUZhH GDQA9Tvc4PApxIJx+lNd0gT5iB2qjDcO90SBndx9BQBf704daapyoOCM+tO6cUAGPSkpRQfUUAJR R2ooAKOaKKACiiigAoozRQAjfdNKM4pDyKWgDCqW2ikmO0iA4zjcpzUVPjcxuGFMRsRxiKJUAAx1 C9M06mqwdQwPUU6kMWikpaAEBI6U8SZ4YBh+tMooAeVVvutg+hppRl6iilDle9ADR1FKeeaeSh6r g+1N2kc9V9RQBj+I2b+yTChAa4ljgB9NzAEj3AyRVGW3+yzNAMFUA2nknHbNWfEiiW1t42VsfaUO VOCCASMVBBbTXRfyxnH3nY96umnrK4qjXKo21IXVcZboPwqERSiaAxwKBNJtEknyjb39z7V0kOm2 yrGzwq0i9Se5+lTyRRTLtkQMPQim6l1YhU7O5z+r+FDqlxA0V99nhjjZWgMKyLIexO7t6j6YIqd/ D0aaFFZW8mLmFhLHOeMyg5LED154960Jr2OPUYbJcGd0Yj/ZGM8/l+lPt7mSa4kjeBk8scuRwT7V lyrc6FXmko30RnW+q3cOoQWWq2kVu1wCIZYZzKjsBkqcqpBxyPoa2s+9cY+qN/wldzeX2nXwgsgI beTygEVX273JzzyByO1dd58Hn+R5sfnY3eXuG7HrilF3LqQtZpbolyfSlUrn3pKo32rwabNDFJFP LJMGKrCm4gDGSfzqm7GMYuTsiW5tmnZSDjHXPpQqMpMcShFHBbuaLK+t9QgM1q7FAxRsqVIYdQQe c1aDZXOOaLiaadmM37JETHLDr6U6oAwe6P8AsDB+tT0AFKOOaSlb9KAEooooAKKKKACiiigAoooo AKTHvS0UAYVFFFMkvWM3ymNiOORmr4YEcEGsIcMD/StSAiMZDZUj0xSGWR+R9KKTggGonuvLcqYZ W9Cq5zQMmoqubs7Qfs82CP7vNTqdyBsEZ7GgBaUdeaSigBeaikvIrbdukUMBkrnrUp7VmXmmpPcm UuylwARgdqTv0Kjy394zVkvNelWUQR2yRrmKJpcuc/xHtj2zXQW8CW9usSdFHOepPc1kXGgxKqzJ d3ETQZdTG2DwDR4evLhrNIdRuhJO3zJKwxkH+E+/v3qld6Dko/Fc2+d2MDbjrmmmWNJUjY4ZhlR6 0k7vFGSsbO4IG0cZycVV1VQkMVzjd9nfzCP0pEFSz2XniG7uvLJWGNY45PfLZ/n+tbJOKz9GgaLT gzAB5WMjH61oAimxIjmgiubeSGVA8UilWU9CD1FZn/CMaN5YQWSIwJIkjJSQE996kNn8a1gGDHGC p7U2OMxySMZGcMcgHov0qbJlqUo7MyhpF/bnNlrdwFzxFdos6gfXh/zY1U+x62t+b6ZrVpBF5SfZ 88jJJJDdM8dCenWukzTGkj84Rk4fHAPf1xQkkynUk00zl9H+3afqMNi13FPFcm4uJFaLEiEvn7wO OrDgj8a6jJ2YHJFUL3RLe7njuI2a2uoySs0OAeeufUGqmlahOdWvNLvLmKWW3ClG27HcEZJ29wOm RSWjsVJc65lulr/malvCUBeQDzGOT7VPRRVGIUDrS479B70cY60AHWkpc+goznqKAEopcdxyKSgA ooo6UAGKKKKACiiigDCooopkhVyzfcPLzyOlU6dG5jkDDtQBsopUYJzR3pUIZQw6EZpaRQo44zxV HVb2SxtQ0aqZHcRqWHyqT3P+euBV0Dio7iCO5geGUbkcYIoGjNt9bXGy7idJB/Eikq309PpV+2vY LokRkhhzhhg1lNoU28Kt6TCR8xZBv/Aimy2VxaXCCEO56o+Onsx/zmlN2fu7GlOMZJqTs/wN/qah k++KUfvUKtkZ/unFEmNyjvTMhl6cWFwf+mTfyrmY4ium20sPyjYFk7kOO/4iuouojPaTQqcNJGyg +mRiuft7DWJlltmSKygJAaQkSO4A/hHQfU8+wqoy5dRuHOrG1YajHcpHCZcziPcyH8qxdT1G4muJ LCaOJMtjA5J54IPQflS6jp1vo8MGp26MZLKQSTyEks8R+V8/QEtj/ZrM1icw6iskTDP2gFSW4bjP XuKI2bYpxtFNPc63MGm2K7UKquOM5ySaZHqlrIWBkEbDs/Gazbu8bU7MJDCZGXaS8Mowr46Zwe1O i0NJbpZpGOzGdhHzD2JFFlbUm7voaDzC8tp1tZ4nmVcAZBxVuAuYEEoUSY+YL0zUYSG2OIoQH2kg IvXHbNR28qC5Ba3MUs0YYsWHP+zjrkfSpKLY469ar311HaWxlkdlGQBtGSxPQAdyasHk8daxFK6j 4lkV5FeHTwCkY/56MDkn6DpSZUVfcet9rVzlrbTIIo84H2uYox/BVPFOtNOu21BdQ1KaFpkjaOKK FTtjDEFuTyxO0c4Fa2T9KQnHJosVz6WSsLx7mjPoBUf+sOckAdMcZo3FOGPH97/GmZjycnmjI9ab IcISOvameUAMgkHuRQBJ174FIjBsgHNM8t3Pzt8voBjNK+AAV/h9PSgCQHHSl4PsaSloAQjFFKD2 NGR/dFACUUhcZ2qmT9elHzY6gfQUALRSZI6jj1FLQBhUUUUyQooooA0LCbKmInkcirtYsUhikVx2 NbKsHUMOhpDQtL2pKKBhR1FKfakoAi5jbPakzulzUrDKmoYyN45pCJzwCaQEADnrS1F91wD07Uxj nAySQCpGCDXHaZozDxVJaTSMLS1h8y3jBzuVmIAJ/wBkADHsK3fEF/LaaYwtlzcTsIImLBVR2BAZ mPQA/X0xzWfootLm7nS11K4ub9YQguJgSoTI3eWcANzjJ55xzUt+9obQi1Bt7GwLq0t42WOOKKOO QrIOh4HYd6qaVvkurplEioxyu/OBz6GkuI9O0aMXEyPPcMcRr9+WV/RR6/5NW9K1FtQtHaW3+zTx SNHNCXDbCPceowfxqrrYy9nK1+hZZI7yMFZmwrdY2x7YNZUujXcl8ZGuiIFGVcn5s4/z0qouo3y3 14NHs47y1jbfI7SFAW/ijQ4+Zv0HTOauT66L2GJNLxLPOOAwwI/Xd6YpJroU4SS1K91qCxTpBp9w 91dsvQPxxxz+NW9M0CGxuXvpXeS/lXEku84xnOMdP0qWx0WG2w5dzMRh3BxuP+Faa8KBnOB1NPcV 7aIbhv736UBecnk+9Pz7UcelBIlBGRg0uR6UZHoKAIxHgj5jtHQU+lyPSjI9KAG4PTPFBAIwRxTu KMfjQBGmQNueRxzTgex60jICcgkN6iky44K7vdaAH0zcXJ2nCjv60AO5G7genrTwO1ACKoUcUveg 0maADtzSx8xqfamSE+W2PSnoQFAU8UAYVFFFMkKKKKACr9jP8vlH8KoU5GKOGHUUAbffFFQpN5gU j0qakUFLikooARiQMioUiywfPQ1Y96jTIJBoAfTWQMcmnUUAQ3Npb3ls1tcwpNC+N0bjIODnpXM6 nfDTfEHmSKE+y2ha0hjXAlz94E9guBxXUySpDsLkgMwQH3PSq2paZaatAsN3GXRW3DaxUj8QQamS vsa05qL97Yg03TSJF1G7kFxeTLkOB8san+FPQfzqC80KWfUpJEvDDaXCgXMKDDOR0+btkda3YFSC 1WKFQiRgKoHYUyjlVhe0kndEcMMVtAkMKLHEgwqqMACo4LSCGWWeOJVklOXYDrUvLnH8I6+9PqiL sZI5jUsqFyP4R3qv9sfvbyD3JFW6gNnbliTGMk+tAgiuHkfBgdR2JxU2T6fnTYoY4QRGoUHripOK AG4Pc/lRgU6k6UAHSkHNHOaKAFooAooAXPHNHHrR2pKAFwaMc0lL1oASiiigApnlj1I9s0+igDCo oopkhRRRQAUUUUAWrOXB2fiK0VYEcViqxVgw7VejuztBwmCeuelJjL1FNVw4yvSnUDClxnpSUUAF L7mjjqetU7298kiGJfMuH+6v+NA0m3ZGC2oSqL+0ANxC0haGffwmefx2n+VdFaT/AGm1jlPDEfMP Q96zrXQLYRn7Yi3DMOFYfKn0Hr79avW1p9kMgicmNjkI38J+tL0Lk4v1Li/dYe1MJx05NLHvLEHa Mg+9IFA9z6mmZgowoFLRRQADrR3ooPBoAKDRS4oASkxTuKKAEoopcUAJRS44ooAM/lSUUdKACiii gBfeko6Uv8qAExS49qaWJ+lJmgDEooopkhRRRQAUUUUAFWbSTBKE9eRRRQBoLKhIQsA56DPJqSii kUFFFFACE4BJ7VHHbosjTbR5r/eaiigCWiiigByHDr9aQjBOaKKAEpOp4oooAcAAck5prLubO4j6 UUUALS0UUAJRRRQAUtFFACUUUUABGelIrAqCOfeiigBaKKKAEJoPYUUUAJS4oooA/9k=