20170816 09084900 1.0 FALSE CalculateField Buildings UNIT_TYPE "RES" VB # CalculateField Buildings UNIT_TYPE "RES_ACC" VB # CalculateField Buildings UNIT_TYPE "RES_MULTI" VB # CalculateField Buildings UNIT_TYPE "RES" VB # CalculateField "Residential Units" HU 2 VB # CalculateField "Residential Units" HU 3 VB # CalculateField "Residential Units" HU 4 VB # CalculateField "Residential Units" HU 6 VB # CalculateField "Residential Units" Code 40 VB # CalculateField "Residential Units" HU 0 VB # CalculateField Buildings HU 1 VB # CalculateField Buildings HU 1 VB # CalculateField Buildings HU 2 VB # CalculateField Buildings HU 1 VB # CalculateField Buildings HU 2 VB # CalculateField Buildings HU 10 VB # CalculateField Buildings HU 1 VB # CalculateField Buildings HU 1 VB # CalculateField Buildings UNIT_TYPE "RES_MULTI" VB # CalculateField Buildings UNIT_TYPE "COMM" VB # CalculateField Buildings HU 2 VB # CalculateField Buildings HU 0 VB # CalculateField Buildings UNIT_TYPE "COMM" VB # CalculateField Buildings HU 32 VB # CalculateField Buildings UNIT_TYPE "RES_MULTI" VB # CalculateField Buildings STRUC_TYPE "APT" VB # CalculateField Buildings HU 34 VB # CalculateField Buildings HU 24 VB # CalculateField Buildings HU 24 VB # CalculateField Buildings UNIT_TYPE "RES_MULTI" VB # CalculateField Buildings UNIT_TYPE "RES_MULTI" VB # CalculateField Buildings HU 24 VB # CalculateField Buildings UNIT_TYPE "INST" VB # CalculateField Buildings UNIT_TYPE "INST_ACC" VB # CalculateField Buildings HU 0 VB # CalculateField Buildings HU NULL VB # CalculateField Buildings HU 1 VB # CalculateField Buildings UNIT_TYPE "RES" VB # CalculateField Buildings ADDRESS "113 W 19TH AVE" VB # CalculateField Buildings UNIT_TYPE "RES" VB # CalculateField Buildings UNIT_TYPE "COM" VB # CalculateField Buildings UNIT_TYPE "INS" VB # CalculateField Buildings UNIT_TYPE "RES_ACC" VB # CalculateField Buildings UNIT_TYPE "RES_ACC" VB # CalculateField Buildings UNIT_TYPE "RES_ACC" VB # CalculateField STRUCTURES HU 1 VB # CalculateField STRUCTURES UNIT_TYPE "RES" VB # CalculateField STRUCTURES UNIT_TYPE "RES" VB # CalculateField STRUCTURES LBCS_StructureCode "3500" VB # CalculateField STRUCTURES UNIT_TYPE "INST" VB # CalculateField STRUCTURES UNIT_TYPE "COMM_ACC" VB # CalculateField STRUCTURES UNIT_TYPE "COM" VB # CalculateField STRUCTURES UNIT_TYPE "COMM" VB # CalculateField STRUCTURES UNIT_TYPE "COMM" VB # CalculateField STRUCTURES UNIT_TYPE "COMM_ACC" VB # CalculateField STRUCTURES HU 2 VB # CalculateField STRUCTURES UNIT_TYPE "MULTI_RES" VB # CalculateField STRUCTURES UNIT_TYPE "RES_MULTI" VB # CalculateField STRUCTURES HU 0 VB # CalculateField STRUCTURES HU 1 VB # CalculateField STRUCTURES STRUC_TYPE "HS" VB # CalculateField STRUCTURES UNIT_TYPE "RES" VB # CalculateField STRUCTURES UNIT_TYPE "COMM" VB # CalculateField STRUCTURES HU 0 VB # CalculateField STRUCTURES LBCS_STRUCTURE 1242 VB # CalculateField STRUCTURES LBCS_STRUCTURE 1202 VB # CalculateField STRUCTURES LBCS_STRUCTURE 1121 VB # CalculateField STRUCTURES UNIT_TYPE "RES_MULTI" VB # CalculateField STRUCTURES LBCS_STRUCTURE 1100 VB # CalculateField STRUCTURES LBCS_STRUCTURE 9902 VB # CalculateField STRUCTURES LBCS_STRUCTURE 9901 VB # CalculateField STRUCTURES LBCS_STRUCTURE 9905 VB # CalculateField STRUCTURES LBCS_STRUCTURE 9909 VB # CalculateField STRUCTURES LBCS_STRUCTURE 6000 VB # CalculateField STRUCTURES LBCS_STRUCTURE 2000 VB # CalculateField STRUCTURES LBCS_STRUCTURE 4000 VB # CalculateField STRUCTURES TU 0 VB # CalculateField STRUCTURES DESCRIPTION "POST FALLS" VB # CalculateField "Residential Structures" DESCRIPTION mid([DESCRIPTION],13,16) VB # CalculateField "Residential Structures" PID mid([DESCRIPTION],13,16) VB # CalculateField "Residential Structures" DESCRIPTION mid([DESCRIPTION],13,16) VB # CalculateField "Residential Structures" PID mid([DESCRIPTION],13,16) VB # CalculateField "Residential Structures" DESCRIPTION "POST FALLS - (" & [DESCRIPTION] & ")" VB # CalculateField "Residential Structures" PID mid([DESCRIPTION],13,16) VB # CalculateField "Residential Structures" DESCRIPTION "PF" VB # CalculateField "Residential Structures" PID mid( [DESCRIPTION],13,16) VB # CalculateField "Residential Structures" DESCRIPTION "PF" VB # CopyFeatures \\192.168.10.15\gis\FILEGDB\04_PLANNING\Planning_Replica.gdb\STRUCTURES \\192.168.10.15\gis\FILEGDB\08_SERVICES\02_CURRENT\PLANNING.gdb\STRUCTURES # 0 0 0 CalculateField "03 Structures\Buildings" HU 12 VB # CalculateField "03 Structures\Buildings" HU 14 VB # CalculateField "03 Structures\Buildings" HU 15 VB # CalculateField "03 Structures\Buildings" HU 10 VB # CalculateField "03 Structures\Buildings" HU 3 VB # CalculateField "03 Structures\Buildings" HU 1 VB # CalculateField "03 Structures\Buildings" UNIT_TYPE "RES_MULTI" VB # CalculateField "03 Structures\Buildings" HU 1 VB # CalculateField "03 Structures\Buildings" UNIT_TYPE "RES" VB # CalculateField "03 Structures\Buildings" HU 1 VB # CalculateField "03 Structures\Buildings" ADDRESS "[ADDRESS] & " " & [ADDRESS_SUBUNIT]" VB # CalculateField "03 Structures\Buildings" ADDRESS "[ADDRESS] & " " & [ADDRESS_SUBUNIT]" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Assisted Living" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Fire Station" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Idaho National Guard" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Government" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Government" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Health Care" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Church" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Funeral Homes" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Health Care" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Police" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Fire District Admin" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Drivers License / Veterans Services" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "Post Falls City Hall" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" DESCRIPTION "School" VB # CalculateField "03 Structures\Buildings" LAST_UPDATED 02/04/2015 VB # CalculateField "03 Structures\Buildings" STRUC_TYPE "MH" VB # CalculateField "03 Structures\Buildings" STRUC_TYPE "HS" VB # CalculateField "03 Structures\Buildings" STRUC_TYPE "MH" VB # CalculateField "03 Structures\Buildings" STRUC_TYPE "MH" VB # CalculateField PLANNING.DBO.STRUCTURES STRUC_TYPE "COM" VB # CalculateField PLANNING.DBO.STRUCTURES UNIT_TYPE "RES_MULTI" VB # CalculateField PLANNING.DBO.STRUCTURES DESCRIPTION "PF" VB # CalculateField PLANNING.DBO.STRUCTURES PID "P-K386-000-003-0" VB # CalculateField PLANNING.DBO.STRUCTURES PID "P-J345-009-022-0" VB # CalculateField PLANNING.DBO.STRUCTURES LAST_UPDATED "10/23/2015" VB # CalculateField PLANNING.DBO.STRUCTURES UNIT_TYPE "RES" VB # CalculateField PLANNING.DBO.STRUCTURES HEIGHT 20 VB # CalculateField PLANNING.DBO.STRUCTURES STRUC_TYPE "ACC" VB # CalculateField PLANNING.DBO.STRUCTURES STRUC_TYPE "" VB # CalculateField PLANNING.DBO.STRUCTURES HU 24 VB # CalculateField PLANNING.DBO.STRUCTURES UNIT_TYPE "RES_MULTI" VB # CalculateField PLANNING.DBO.STRUCTURES YEAR_BUILT 2018 VB # CalculateField PLANNING.DBO.STRUCTURES PID "P-0000-036-8775" VB # CalculateField PLANNING.DBO.STRUCTURES HU 12 VB # RegisterAsVersioned "Database Servers\GIS-SVR_SQLEXPRESS.gds\Planning (VERSION:dbo.DEFAULT)\PLANNING.DBO.STRUCTURES" NO_EDITS_TO_BASE DeleteField "Database Servers\GIS-SVR_SQLEXPRESS.gds\Planning (VERSION:dbo.DEFAULT)\PLANNING.DBO.STRUCTURES" BASE_HEIGHT CalculateField PLANNING.DBO.STRUCTURES HU 1 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES DESCRIPTION "PF" "Python 3" # CalculateField PLANNING.DBO.STRUCTURES HEIGHT 10 "Python 3" # UnregisterAsVersioned "Database Servers\GIS-SVR_SQLEXPRESS.gds\Planning (VERSION:dbo.DEFAULT)\PLANNING.DBO.STRUCTURES" KEEP_EDIT COMPRESS_DEFAULT CalculateField PLANNING.DBO.STRUCTURES HU 1 "Python 3" # CalculateField "PLANNING.DBO.STRUCTURES selection" HU 0 "Python 3" # CalculateField "PLANNING.DBO.STRUCTURES selection" HU 0 "Python 3" # CalculateField "PLANNING.DBO.STRUCTURES selection" STRUC_TYPE "APT" "Python 3" # 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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure Type</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>UNIT_TYPE</field_name><domain_name>Unit Type</domain_name></AssignDomainToField></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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure Type</domain_name></AssignDomainToField></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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure Type</domain_name></AssignDomainToField></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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure Type</domain_name></AssignDomainToField></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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>STRUC_TYPE</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure Type</domain_name></AssignDomainToField></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>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=Planning;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>PLANNING.DBO.STRUCTURES</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>STRUC_TYPE</field_name><domain_name>Structure type</domain_name></AssignDomainToField></workflow></operationSequence>" CalculateField PLANNING.DBO.STRUCTURES BASE_HEIGHT 0 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES HU 0 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES LBCS_STRUCTURE 1150 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES HU 1 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = "-" return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = "-" return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT "" " + !ADDRESS_SUBUNIT!" "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = "-" return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS !ADDRESS_SUBUNIT! "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = " " return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = " " return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS !ADDRESS_SUBUNIT! "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT !DESCRIPTION! "Python 3" # CalculateField PLANNING.DBO.STRUCTURES HU 0 "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = " " return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT !DESCRIPTION! "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT !DESCRIPTION! "Python 3" # CalculateField PLANNING.DBO.STRUCTURES ADDRESS ConcatenateFields(!ADDRESS!, !ADDRESS_SUBUNIT!) "Python 3" "# Joins two or more fields into a single string value # More calculator examples at esriurl.com/CalculatorExamples def ConcatenateFields(*args): sep = " " return sep.join([i for i in args if i])" CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT !ADDRESS! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT "!ADDRESS! + " " + "A-B"" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT "!ADDRESS! + " " + "A-B"" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS_SUBUNIT !ADDRESS_SUBUNIT!.upper() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS !ADDRESS!.upper() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS !ADDRESS!.rstrip(" ") "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField PLANNING.DBO.STRUCTURES ADDRESS !ADDRESS!.rstrip(" ") "Python 3" # Text NO_ENFORCE_DOMAINS FeatureClassToFeatureClass PLANNING.DBO.STRUCTURES C:\Users\nlowe\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS.sde\GIS.DBO.Development_Activity SF_Build_Permits # "STRUC_TYPE "STRUC_TYPE" true true false 3 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.STRUC_TYPE,0,3;ADDRESS "ADDRESS" true true false 50 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.ADDRESS,0,50;ADDRESS_SUBUNIT "ADDRESS_SUBUNIT" true true false 50 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.ADDRESS_SUBUNIT,0,50;HU "HU" true true false 2 Short 0 5,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.HU,-1,-1;LBCS_STRUCTURE "LBCS_STRUCTURE" true true false 4 Long 0 10,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.LBCS_STRUCTURE,-1,-1;UNIT_TYPE "UNIT_TYPE" true true false 50 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.UNIT_TYPE,0,50;HEIGHT "HEIGHT" true true false 2 Short 0 5,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.HEIGHT,-1,-1;BASE_HEIGHT "BASE_HEIGHT" true true false 2 Short 0 5,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.BASE_HEIGHT,-1,-1;LAST_UPDATED "LAST_UPDATED" true true false 8 Date 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.LAST_UPDATED,-1,-1;DESCRIPTION "DESCRIPTION" true true false 200 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.DESCRIPTION,0,200;PID "PID" true true false 20 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.PID,0,20;YEAR_BUILT "YEAR_BUILT" true true false 4 Long 0 10,First,#,PLANNING.DBO.STRUCTURES,PLANNING.DBO.STRUCTURES.YEAR_BUILT,-1,-1;OBJECTID "OBJECTID" false false false 4 Long 0 9,First,#,PLANNING.DBO.STRUCTURES,Development_all.OBJECTID,-1,-1;NAME "Owner Name" true true false 80 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.NAME,0,80;LOC_ADDR "Address" true true false 120 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.LOC_ADDR,0,120;Valuation_2020 "Valuation" true true false 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Valuation_2020,-1,-1;HU "Housing Units" true true false 2 Short 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.HU,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Shape_Area,-1,-1;Type "Development Type" true true false 255 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Type,0,255;IssueYear "Year" true true false 10 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.IssueYear,0,10;UseType "UseType" true true false 255 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.UseType,0,255;PermitNum "Permit/Plan Number" true true false 255 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.PermitNum,0,255;ProjName "Project Name" true true false 255 Text 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.ProjName,0,255;Valuation_2021 "Valuation 2021" true true false 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Valuation_2021,-1,-1;Valuation_2022 "Valuation 2022" true true false 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Valuation_2022,-1,-1;Valuation_Total "Valuation Total" true true false 8 Double 0 0,First,#,PLANNING.DBO.STRUCTURES,Development_all.Valuation_Total,-1,-1" # 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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Valuation_2020</field_name><field_name>Valuation_2021</field_name><field_name>Valuation_2022</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>HU_1</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>UseType</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ADDRESS_SUBUNIT</field_name><field_name>LOC_ADDR</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>OBJECTID</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>STRUC_TYPE</field_name><field_name>UNIT_TYPE</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>BASE_HEIGHT</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>LBCS_STRUCTURE</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>NAME</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>HEIGHT</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>AppDate</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>Apply Date</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>IssueDate</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>Issue Date</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>PermitType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Permit Type</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>WorkType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Work Type</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>IssueYear</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>BuildingType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Building Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" CalculateField GIS.DBO.SF_Build_Permits BuildingType !Type! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Type</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.SF_Build_Permits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>PermitType</field_name><domain_name>Permit Type</domain_name></AssignDomainToField></workflow></operationSequence>" FeatureClassToFeatureClass GIS.DBO.SF_Build_Permits C:\Users\nlowe\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS.sde\GIS.DBO.Development_Activity BuildPermits_All # "ADDRESS "ADDRESS" true true false 50 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,ADDRESS,0,50;HU "HU" true true false 2 Short 0 5,First,#,GIS.DBO.SF_Build_Permits,HU,-1,-1;LAST_UPDATED "LAST_UPDATED" true true false 8 Date 0 0,First,#,GIS.DBO.SF_Build_Permits,LAST_UPDATED,-1,-1;DESCRIPTION "DESCRIPTION" true true false 200 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,DESCRIPTION,0,200;PID "PID" true true false 20 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,PID,0,20;YEAR_BUILT "YEAR_BUILT" true true false 4 Long 0 10,First,#,GIS.DBO.SF_Build_Permits,YEAR_BUILT,-1,-1;PermitNum "Permit/Plan Number" true true false 255 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,PermitNum,0,255;ProjName "Project Name" true true false 255 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,ProjName,0,255;Valuation_Total "Valuation Total" true true false 8 Double 8 38,First,#,GIS.DBO.SF_Build_Permits,Valuation_Total,-1,-1;AppDate "Apply Date" true true false 8 Date 0 0,First,#,GIS.DBO.SF_Build_Permits,AppDate,-1,-1;IssueDate "Issue Date" true true false 8 Date 0 0,First,#,GIS.DBO.SF_Build_Permits,IssueDate,-1,-1;PermitType "Permit Type" true true false 255 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,PermitType,0,255;WorkType "Work Type" true true false 255 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,WorkType,0,255;BuildingType "Building Type" true true false 255 Text 0 0,First,#,GIS.DBO.SF_Build_Permits,BuildingType,0,255" # FeatureToPoint GIS.DBO.BuildPermits_All C:\Users\nlowe\AppData\Roaming\Esri\ArcGISPro\Favorites\GIS.sde\GIS.DBO.Development_Activity\GIS.DBO.BuildPermits CENTROID 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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ORIG_FID</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>PermitType</field_name><domain_name>Permit Type</domain_name></AssignDomainToField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Record__</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Record__</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Record__ !PermitNum! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>PermitNum</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Address</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Address</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Address !ADDRESS! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>ADDRESS</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Valuation</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>USER_Valuation</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USER_Valuation</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Valuation</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>USER_Valuation</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Valuation !Valuation_Total! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Valuation_Total</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_F__of_Units</field_name><field_type>LONG</field_type><field_precision>5</field_precision><field_alias>USER_F__of_Units</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_F__of_Units !HU! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>HU</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Record_Type</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Record_Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Record_Type !PermitType! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteField><field_name>PermitType</field_name></DeleteField></workflow><workflow><AssignDomainToField><field_name>USER_Record_Type</field_name><domain_name>Permit Type</domain_name></AssignDomainToField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Date_Submitted</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>USER_Date_Submitted</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Date_Submitted !AppDate! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>AppDate</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Permit_License_Issued_Da</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>USER_Permit_License_Issued_Da</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USER_Permit_License_Issued_Da</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Permit_License_Issued_Da</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_alias>USER_Permit_License_Issued_Da</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USER_Permit_License_Issued_Da</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Building_Type</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Building_Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Building_Type !WorkType! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>WorkType</field_name></DeleteField></workflow></operationSequence> AddField GIS.DBO.BuildPermits USER_Permit_License_Issued_Date Date # # # # NULLABLE NON_REQUIRED # CalculateField GIS.DBO.BuildPermits USER_Permit_License_Issued_Date !IssueDate! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>IssueDate</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Type_of_Work</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Type_of_Work</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Type_of_Work !USER_Building_Type! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USER_Building_Type</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Building_Type</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Building_Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Building_Type !BuildingType! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>BuildingType</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>USER_Location</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Location</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField GIS.DBO.BuildPermits USER_Location !USER_Address! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>USER_Address</field_name></DeleteField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>USER_Amount</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Permit Fees</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>USER_Record_Status</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>USER_Record_Status</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Record Status</field_domain></AddField></workflow></operationSequence>" Append OGPermits_7222022_copy_Geocoded GIS.DBO.BuildPermits "Skip and warn if schema does not match" # # "Status <> 'U'" Append OGPermits_7222022_copy_Geocoded GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 10,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Location,0,255;USER_Amount "Permit Fees" true true false 8 Double 1 7,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Amount,-1,-1;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\OGPermits_7222022_copy_Geocoded,USER_Record_Status,0,255" # "Status <> 'U'" DeleteIdentical GIS.DBO.BuildPermits USER_Record__ # 0 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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>USER_Building_Type</field_name><domain_name>BuildingType</domain_name></AssignDomainToField></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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Fees</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Fees</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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteField><field_name>USER_Amount</field_name></DeleteField></workflow><workflow><AddField><field_name>USER_Amount</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Permit Fees</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" CalculateField GIS.DBO.BuildPermits USER_Amount !Fees! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Fees</field_name></DeleteField></workflow></operationSequence> DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # 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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>PID</field_name><field_name>YEAR_BUILT</field_name><field_name>ProjName</field_name><field_name>USER_F__of_Units</field_name></DeleteField></workflow></operationSequence> DeleteRows GIS.DBO.BuildPermits DeleteRows GIS.DBO.BuildPermits CalculateField GIS.DBO.BuildPermits DESCRIPTION !USER_Permit_License_Issued_Date! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField GIS.DBO.BuildPermits DESCRIPTION !USER_Record_Status! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField GIS.DBO.BuildPermits DESCRIPTION !USER_Permit_License_Issued_Date! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField GIS.DBO.BuildPermits DESCRIPTION !USER_Record_Status! "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.9.0'><FeatureDataset>GIS.DBO.Development_Activity</FeatureDataset><WorkspaceConnectionString>SERVER=GIS-SVR;INSTANCE=sde:sqlserver:GIS-SVR\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GIS-SVR\sqlexpress;DATABASE=GIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.DBO.BuildPermits</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>USER_Building_Type</field_name></RemoveDomainFromField></workflow></operationSequence> DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append GIS.DBO.ADDRESS_POINTS GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY Append RootAddress GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,RootAddress,Permits_for_rematch.USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,RootAddress,Permits_for_rematch.USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,RootAddress,Permits_for_rematch.USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,RootAddress,Permits_for_rematch.USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\GeocodedPermits GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append GIS.DBO.ADDRESS_POINTS GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,GIS.DBO.ADDRESS_POINTS,Permits_for_rematch.USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY Append RootAddress GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,RootAddress,Permits_for_rematch.USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,RootAddress,Permits_for_rematch.USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,RootAddress,Permits_for_rematch.USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,RootAddress,Permits_for_rematch.USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,RootAddress,Permits_for_rematch.USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append GeocodedPermits_Layer GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY Append Unmatched_Recode GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,Unmatched_Recode,USER_USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Unmatched_Recode,USER_USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Unmatched_Recode,USER_USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Unmatched_Recode,USER_USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,Unmatched_Recode,USER_USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY Append RootAddress GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "LAST_UPDATED "Last Updated" true true false 8 Date 0 0,First,#;DESCRIPTION "Comment" true true false 200 Text 0 0,First,#;USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 8 38,First,#,RootAddress,Unmatched_Recode.USER_USER_Valuation,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,RootAddress,Unmatched_Recode.USER_USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 8 38,First,#,RootAddress,Unmatched_Recode.USER_USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY DeleteRows GIS.DBO.BuildPermits Append GeocodedPermits_Layer GIS.DBO.BuildPermits "Use the field map to reconcile field differences" "USER_Record__ "USER_Record__" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record__,0,255;USER_Valuation "USER_Valuation" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Valuation,-1,-1;USER_F__of_Units "USER_F__of_Units" true true false 4 Long 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_F__of_Units,-1,-1;USER_Record_Type "USER_Record_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Type,0,255;USER_Date_Submitted "USER_Date_Submitted" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Date_Submitted,-1,-1;USER_Permit_License_Issued_Date "USER_Permit_License_Issued_Date" true true false 8 Date 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Permit_License_Issued_Date,-1,-1;USER_Type_of_Work "USER_Type_of_Work" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Type_of_Work,0,255;USER_Building_Type "USER_Building_Type" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Building_Type,0,255;USER_Location "USER_Location" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Location,0,255;USER_Record_Status "USER_Record_Status" true true false 255 Text 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Record_Status,0,255;USER_Amount "Permit Fees" true true false 8 Double 0 0,First,#,Y:\GIS_SHARED\Permitting\Permit_Activity\Default.gdb\TobeGeocodedPermitTable_View,USER_Amount,-1,-1" # # # NOT_UPDATE_GEOMETRY Server=GIS-SVR; Service=sde:sqlserver:GIS-SVR\sqlexpress; Database=GIS; Version=dbo.DEFAULT ArcSDE Connection GIS.DBO.BuildPermits 002 2306880.662554 2354399.242714 2196608.632972 2229340.272561 1 Projected GCS_North_American_1983 NAD_1983_StatePlane_Idaho_West_FIPS_1103_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.9.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Idaho_West_FIPS_1103_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;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,2624666.666666666],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-115.75],PARAMETER[&quot;Scale_Factor&quot;,0.9999333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,41.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2243]]</WKT><XOrigin>-15822600</XOrigin><YOrigin>-47951700</YOrigin><XYScale>3048.0060960121918</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102670</WKID><LatestWKID>2243</LatestWKID></ProjectedCoordinateSystem> Linear Unit: Foot_US (0.304801) FGDC CSDGM Metadata 20220708 14172100 20220708 14172100 Microsoft Windows 10 Version 10.0 (Build 19041) ; Esri ArcGIS 12.9.3.32739 Building Permits 002 1 -117.042443 -116.847337 47.776507 47.684781 Post Falls Enterprise Geodatabase Feature Class dataset EPSG 5.3(9.0.0) Simple FALSE 0 TRUE FALSE 0 GIS.DBO.BuildPermits Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. SHAPE Shape Geometry 8 0 0 Feature geometry. ESRI Coordinates defining the features. ADDRESS Address String 50 0 0 HU Housing Units SmallInteger 2 5 0 LAST_UPDATED Last Updated Date 8 0 0 DESCRIPTION Comment String 200 0 0 PID PID String 20 0 0 PermitNum Permit Number String 255 0 0 ProjName Project Name String 255 0 0 Valuation_Total Valuation Total Double 8 38 8 AppDate Apply Date Date 8 0 0 IssueDate Issue Date Date 8 0 0 PermitType Permit Type String 255 0 0 WorkType Work Type String 255 0 0 BuildingType Building Type String 255 0 0 ORIG_FID ORIG_FID Integer 4 10 0 YEAR_BUILT Structure Year Integer 4 10 0 20220708 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKjd1jQu7BVAySTgCn9q5P4jNMvgu98nfk4DbBk7e9NK7sJuyudFDf 2d0xW2u4JmAziOQMf0NcLa6Vr9944i1C+1W08m1d1WCGUbgnPGB9RnPpXl/gzR9Q1LXUSzv5bMQx s4lwQoxz1q14Rnkh8V3AuLmeTfDNh1UguxUnP49a29ny3szD2nNa6PoX7RCc/vU46/MKlzmvlKWa +juHCT3BEkn3WZtzfSvoXw7rFhZ6FpNneXiw3UlqriOd/mI9eaidNxLhUUjp8Vj6WNaGqX/9pNAb PcPswjHIHvXkt18UNduvEQtYXSK3S72fu0/h3YGT3r0LxZF4sa4tZvD00ezbtkjfAGT3OaXI1v1H zp7dDrljRCxVVBY5YgdTUleMeKbXxpY+I/7ZgaZo4o4jIY8lAQoDbR0wWzxXrOl3E11plvPcR+XN JGGdPQ0nGyuUpXdi9SUVn6prFlo0Mct9N5aSOEXjOTUlGjRTFZXQMpypGQfUU+gAooooAKKKKACi iigAorL1y+n0zSbi7trRrmWMAiNe/PJ/DrXkLfGLVX1H5YYorZnBCPH91Pc1UYOWxEpqO57jRXjd /wDF66OlPJZQ2wnM2EIO/wCUHn5fU8Y+tbXw38d6j4sv7y3vRCUjQOhSMoRzggim4NK4KpFux6XR WLPq15F4ig05NOke1kQs10Puqafr+pXWlaY1zZ2L3socL5Seh6mpsVc16KhgdpYI3dDGzKCUPUH0 qakMKKKw9Z1PUbG6s4rHTzdJM5WR88JQlcTdjbpaxdCbWWiuTrKwq4lPk+X/AHPetqhgncKKKKBh RRRQAUwMpJAIyOoz0qrqOp2ek2v2m9mWGLcF3N6muavfD9/HqLavoN9iW7dTKJTldnXimkJux2VR O0eCrsvTJBPanDIX5jzjk1wmr6Jp/ildS1HSb55rzy/J2LJhAw/+tQlfcG7bHUaxpFtqukzWcsjW 8TrzJEQpABz9MUzSdJ0mwtbZ7KK2bagRLgKpZ+Ou4dSai0nS5W8KwadqY+cwmKUK3Y+/0rD1DwZP LcaVYWdyYtGtSZJF3fOz5J69/wClNW2uS772Oql0jS55PNm02zkk/vPApP5kVwHxD8E6r4o1a0/s +2tlt4oSPOMmwg56EYOeOnHc816PBPBIWiilR2i+VgGyR9aDcwLOsDTIJWGQhYZI9cURk4u6HKKk rM8OsPhj4j0/xHZzSW0NzBHKsjkSL5ZPHJ+634Yr3cdB/SlyCM15bf8AxRv7XxdcaKmkIRFJtG4t uI9c9BTbc2SlGmj1IjIxWNouiyaOLrzNQuLvz5C480/cHoOayvCms63rd9qE97Zrb6crlLbkHdg9 QR1BFTQeNtMufFM2gKHE8Z2iQ/dZv7tKz2RV1uzobi5gtLd57iVIokGWd2wB+NcxL4v8J6nqkGky 3FvdOx3IzANGG9MnvXI/GaC8igsbpb2QWbyLG9uGI5BznA6//WFcv8LtDj1nxUWuo3MNpH5jLv8A lLk8HirjBcvM2ZyqPn5Uj6DGAAB07YpawX8T2kXiqLw+Uf7RJHvDDoOCcfoazvGfjqz8JRImz7Re SfdhBxgeprNRb0NXJJXOworyHRvjDd6lrEFi+lxOZDgrCW3A/jXrueKcouO4oyUthaKKKkoqX92t jYXF2yllhjZyq9TgZryjUvjCl5YXdnFp89nM8bqk6TqzIex2kCvXXjWRGR1DKwwQehFcP4n8CeG7 fQNQvIdKhSeKF5FKDHPWri49SJqX2WeOJ4g8T38M9pBqGoyxyRl5GilMmxF69STz6A9K59mVmdWS Z3ACPnP4csOK0tBu2XxFYIu4eZMsTRxg5UMQCCO4254/2q94/wCFW+E3O9rB8sOf3zc/rXRKagzl hB1FufOgla3mZSUURAMfMVS4TGDg4688dDXqfwWLNrF87YO6HIIB6bzjnJzxiuuPwg8J8hLadAWy QJjz7fStvw54L0jwtLNPYJIJJVCu8khbgfWs5VU4tGsKUoyTOkri/iZrmoeHvCZvNOuY7e4M6R+c 8e/aMEnj3xj8a3tTku7zSZv7FuYftJ4R8ggHvXN+PrK7ufh2yXWZb+Ly2LRcAPnBOPTBNZRWqubS ejsVfhh4o1TxHBqCancCeS2dQG8sIRkA4OK9Drjfh14XtfDugrPCJRPfKs0wk6qcdK7KiVr6Cjfl Vx1FFFSWFFFFABRRRQAUUUUAU76wtdSt/IvIEmiyG2sO4rH0XxfpOr6jLplp5iTwZGx0wCB6VL4j 8RW2gQRNcJOzT7lQxR79pA6kfj0rB+HFtLLY3mrXchlubmZhvdMMFB9TVJaXZDfvWRvaf4jg1HXN R0lLeZJLPG92A2nP8vx61p2Wm2emrItpbpCJG3sEHU1zukwQ23jbVFi0iaEyxB2vC5Kv04A6DPt/ droX1Ozjv0sHuEW6ddyxE8kUn5DT7jINZsLnUptOiuVa7hGZIx1FUoPEUU2s6hp32S5Q2Sb2lK/K wxnj+nrVeXU9G03xWLQ2qw393HlrnYAG9AW/D+VLrOh3erapF/xM3h08wtHNapwZM9/5fl707ILv ocCfiFoWji/n0ixuhqN2WJEhBGR3HPIp2h3N5491K2vXtWjMdu0NxdxuFKE7tpAz1x29zWNq/wAN 00zxCbOBp54HBljPk7gAOdp7fliur8NT38UY1m5EejaPa5RrWOLaJzjG4gdydvOO3FaO1rxMFzXt IkvoPG3hwiz0nOp2rpsidhloz6nPT8TivNdY8P8Ai+0ubq6v7a9bzOJ5gvyFOvzNnH64r6LtbqG9 tY7mBxJDKoZGHcGkvbK31G0ktbqMSwyDDKe9SqluhpKkn1PMfBdhrtv4BlV9Qg0u1ch7R5HBCKWJ PzdgcjrzUPgvwlanxlJqaa1HqD2pJkPksrM5756Ee9b3imC3mtbXwxYLarBGym4jaTa0ScYPPHc+ vautsdNtNJsfL0+2jXCfwAAuQOMnvQ5aeoKOq8jG8Z+HLnxLZ2lrA0CoswaUyZ3Bf9kj/PSrXhbw nY+FrGSC1w7yuWkl2BS3tXO+CrfXF1XWU1OyuLeC8y4kaT7hyRxyeeTz/sityO0fwf4bmFotzqDo 5cIzc8n27Unf4bjVn71in48k1LT9LF7odgJNQJ8trlI9zxJjqOCT6fjXgWuXupX9zNdajHNNcOCZ d/DgjA4H8JHavo/w/wCJH16S4jk0y5snhAyJhwc/hUmranqFhqdjFBZJJZSk/aLh32iP9aqMnHS2 pM4Ket9DwzwJ5y+N9MmtYJdryLy/LbO+7HcV9IYpowQCMEHoRWPbaTcW/iC71J9RnlgnQKtqx+RD xz6dv1NTKXNqXCPLojaornvFmt3uh6O1zYWRuZScdMhPc4qfwxrJ13Q7e9cx+cw/erHnCt6c1Nna 5XMr2Nus7W7CTVNEvLGKQRvPEUDntmtGmllXGSBn1NIZ5T4N+H8vhPV5tX1+bT1giUiJ/MztYkAE swHbj8a9EXXtIe3e4TVLJoU4aQTrtX6nNcZ8WbkTeCx9kaOci5UttO5QAGznB/ya8INsxnkaWEPv dv3h6t6D1HPvWyg56tmDmoaJH1lZ6hZ36b7O7guF9YpAw/Sp5I1lieNxlWUqR7GvAPhLDCnjWMtA WmWFl8yM4CnBzuHp27c4r6ErOceV2NIT51c4bQNV0zRdduPDQtJ7NjIWhebJExJ7HGPpXbEBgQQC D1BrjrDwc9v44vNduXinjkGYd4y6H29MVuabr1tqWp31hDFMslmwDs6YU59KJa6oI6aM2KKKKksK KKKACiiigAooooAKKKKAIJlj2F5UDhAW5XOPpXI3HiO91LRDJ4d0593nGF9y7fLH94Yrd1/VpNF0 77VFYzXjbwvlxdee54Nc1J4m1bTLCVdVs4Ybu7crYxouQcj+PB/+v7VUV1Ik+hr+Fb+D7F/Z0utQ 6jfxM3mYfLDnp+FaV5Y6ZFd/2zcwoJ7eM/vj1Va85i+H3iNL6PWrO+ttP1CRt0kSg4jzwcfeB4HT jqea3tS1HWdf8JXsNjplzDdrIIWEmFLr3Izj/Pem0r6MSk7aoWe3bxpqUUjRo2iIN8U8bbZN46g9 /wAKNdsL+bx/oktqtyLeKPErqTsA54//AF+orf02OPw/4Wh+0qEW1t98oRehAyeB1rzTw9qut3Um ueIbGaSWWS4KWtpLNkHJyVwzAEqAOB60Ly2E9N92eneIbzUrHTxLpViLy43gbPQVV0eS/wBa066h 13SUtVL7BETkMv8AnvVM+MxZiaDUNPuxd21uJZhFHlc9wDn9elb1rqkFzplvfO32eKdQVE5CEZ6D 60tUti7pvc5yx8H6jpj2y2muTC2imLtERwV9BXSatqlroumzX95IEhiGSf5CuX0XV9X1Tx5qkL74 dMtBsWNgCHPTPTjpnr3rrb60tb2zkt7yGOa3YfOkgyCKHvqKNraHn+n+H7bx9EuvX8DWUrOVzA3+ uUcAn0I6fhWp4n07VIZdGTR47h4LZ/nEbdh61t+G7zSbnTfL0Qr9kgcpgKRg9e/JznOfeq3iaOWN bbUDq8lha2j75lVC3mD04/8Ar0czvYXKrXM/TfFl1rsGoafb2jWWswoxSOZTt7c59eaLPUPGMmiR mTToVvknCOW4DJ3IFX9B1231rU7xrbTpIkQLtvGj2+cv1IB/n+FdLQ3boNK63KFtqlnPeS2aXERv IVBmiU8rWBf654Z8TWkumSamoBn8nCvtJcenqK5/SrWzvPiJ4ntoZr6GaW3KCTI2pnG4r+mPxrP8 PadZ6ZbMbXR7rV54r8Rs80fleXj+IAFj78/pVKKJcmegeHtTW7e5sI7K4gjsSIleX+MVv1iapHrk lxYNpctvFAHBuVkGSV9Bx/hW1UM0XYY6q6FHAKkYIPesi+vtK8KaUJGi8i234CRJnk+1F7pV/Prd pfQam8FvCpD2wXIf9azjpOvnTNUinvbW7nlfNoJYwVQe/HX8+lCSE2+x0yTRyRJKGGxwCpPGc1x/ jbTU8QaTcS6bfTNe2KtiK1fJLehA71pXGgTavpWmx6vdSLdW5WSRrZtqsw/D9eKv6ZoWnaTLcS2c HlvOcyEsTn86a01BpvQ8Q8Hw3GieIhqfiCK8t7CKNg5njbYWPAXB4Y9D+Feq6f4q8IanqUdhZz2U txKN0aiIYb6HHJqv8TdNvtT8JMmn2zXE8U6S+WpOSBkcY5OM54ry/wACeE/EVp40sJ7i0nFtHLuc yW7IFHP3Se3NaO005PcyV4NRWx7RrOhm6024j0l4tOvZVAFxHGAcZ6ZFZ+gW3iPSNN1BdWuI7zyQ Wtju5bAJ5Pp061o2XiW1vtfvNFjjmW5tV3MXAAYcdOc96XR9RvNXivRfaW9mI5WiVZDnzF/L/EVn qlY10buN8K63Jr+iLeypHHLvZWRGzjB/StpY0V2ZUUM3Ugcn61zfh5po01Czg0X+zI4pD5LMxIkJ 7/8A6s1oaDHrEVgV1qWGW78w4aIcbe3Ye/6UmtQT0Rrj6Vx2ueLNW03VJLa28P3F1EoGJVBw36Vv 63pj6vpctml3Las+MSxdRVm1tfs1nDA0jTGNAvmOeWx3NF0twd+mhbooopFBRRRQAUUUUAFFFFAB UTwxylTIisVOVyM4NS0UAJRilrJHiLRjdfZf7TtfP3mPy/NGd3pigLmmQGUggEHqDXkuo3jr8RIN I1iOCGxgkM8Ah+UKp5BYjv8AL3r0bXrjVLbTS+j2yXF1uHyNjpnk9RUN54esNXQ3F7ZxLfSQeW0o GShI7euM1UXbUiSvoXvt1rJpz30BWeEIWBjGdwHauG8Ua7a634asfL0yeWeef9zb7trKRkZ46jmu r8M6KPD+kx6a1157BmYEjHB9qml0Cwm1uDV2jb7XAhRCGwuOe34n86E0mDTaM6XxCNC8MwX+r2vk XLqF8iIZJbsKb4S1PW9XW4vNRtUt7OTm2THzY/wrobi0t7tAlxFHKoO4B1zg+tZOseKdL0S+tLG4 djcXDBVjjGSoPcj0o30SB6O7ehJd6ho/hq0Z3EdvEZfmSJRnc3OSBXN+NfFF5o97Zj7FFe6VdJ88 ZXJaiSC2HjOQ2Vr/AGoLl9t8GlDrbMPbt+P0rf1u4vLW4sY7XRhfRM+HbA/dD1HHFNWTE7tMzrLx hbz22lf2bp80sFy/kuEXAgIA4P55+grr68uh8b6pb+IJdHsPDWwZYJBtKNuzw5OMY6fh3rrPCPiR /EOnyC5RY72Byk0aggDngj/9dEotahGSelxbXwfaWfjC48RRzSCWaMqYv4QT1NW7x4NasL2y0zUU iuR8rSQnJRvfFT6488ei3bWts9xN5RCxIcFs+lcb8NLa7sjeQXWhy2LkBmmmY7pOTjggUlqrjejs dzp1tLZ6dBbz3DXEsaBWlbqx9auVjeJZ9Tg0K6k0ePzL0L+7GMke4HeuNsNG8d6lG0OqamLa2miV 964LKwPC4GCOOv0oSvrcblbRI9Morz6xvte8N6g/9uvPfQ3cwit1iAbb/tf/AFutegjkUmrDTuFF QzS+XE8hUttBOFGScelZ2g62mu2L3KW00AWQptlGCcelKwX6GvRRRQMzYtEsIdYk1RIALyRdjPnq PpWlSUUBYWiiigAqnPZRzyb2klU4xhScVcrzy/vvG8Oo3KQvpywiQ+UGdM7e3Vgf0ppXJbseh0UU UigooooAKKKKACkPAJpapalqFrpdjJeXkmyBPvHGevFAHz/qPxM19dbuxFqU6eXcNCI1A2qMkDgj HX8feu28G/E+yGmvF4h1RnvPOKpmLt6ZHWorr4XWmqz6rqdnKHt71RcWaRvj5zyM57dfzqXRvhDY TaRE2sPcR3Z5dUkGF+npW7cGtTnSqKWhZ1D4w6Va6xFa20JubV1BM6kgnnBwCO3v6Vq3fgXw14ms k1C3hkge4/erNExUnPPK9Me2K8j8a+H9L0OfzNJ1G2u43LRCNny6Mo5z2xx+tehfCjxl/alkmjXR zPEmYio42jsfpSlFJXiEZNy5ZHpFlarp9hDbea7rCgXfIck47k0+2ure8hE1tMksZ4DI2RTpYkmh eKQbkcFWHqDWBos+jaTqEnhvT1kWWIGVgQSOcHr+IrLc3vYp6uNNm1GTW7PzL7UdNUr9nifjPv8A /WpILHXL/wAQWmvPcS29mtqT/Z+8jLEH5WHTrg59hV+7n0PwpKbpoPJkvpdrNGhJY+9WNVtdWub3 TpNOvEgt45N1wjDl14/+v+dO5Nh/h+91G/sDLqdiLOcOVCA9R61iyeCUvPGTa9qFwZ1j2tbw8gIw 6E84OOfzrrpJEijLyOqqOrMcAVzWseJNHl0q7hTV0iMmbcSxHcY3IPPH+eKE3fQbStqHh7w3Poc+ rXLTrPcXsrSK2zGOpAP4ntxV3RpdVhsm/t6a2E7SkRlCACOw7c1y9/5vhrStDtLjxBIskU3zhQWM qk5A9cDpzWlay2Hj23LTQXMKWVx8jbsbyPpTavqyU0tEdVKpCPJEiNMEIXPGT2GfTNc34M0STTLW 7uLqwitLy6mZ5BGxO4Z4PJOK3NU1K30fTpby5LCGIDO0ZPJwKo6h4khtdDj1W2t5buOTbtSMfMAe 59KSvYp2vdmVe2HiDWZrmCec6db28we3kt2IaUeh5/yfWqVoZdPj1LxbqmnyW18imPyfM+VwMAHv 7D8OAM1dvtW8R2mvWksWnmfSbkKuxV+eMn19D+lX/GsFvceFrxbu4kggADOyLuJ56Yp9kTbd9jJ0 /wAaarc2c2ozaBItgIRJGUbczn/PtXUQatbvplve3JFqs4GFnO0gntXHWPjmztNP0e0tLOV4ZnEG ZflOBxmrni+QancJoa6ZLczmMzwS52oHGevtj+Yoa12sCel73N3S/wC2v7UvzqLW5sS3+i+X1x7/ AIVs1Q0c3h0m2/tCNI7rYPMRDwDV/tUstbFPU9St9J0+W9uiwhiGW2jJp9jewahZRXduxMMq7lJG OKllijnjaOVFdGGCrDINQ3FnHNYSWikxRshQeXwVHtQGpHDq1hPfS2UV1E1zEAXjDcjNZfiHxZYe GDCL2Kd/NBIMS5A/M1wEHhHS7nWr3Q9P1K5XU4JFmknfgFQBlRj/AHlPvgeleg+Jb3TNL0CRtTMb L5ZRA4BZmxjjPeq5UmQpNrsZ3hXx5beK9SurW3tWiSFA4dnBJ9sV1k0nlwvJgttUthepx6Vwfw38 I22kWB1TkzXOTHnPyofb1rvwysSAQSOuD0pStfQcLuOpmaDrH9t2LXP2Sa22uU2Sjk4707XNVj0X SJ7+WN5REPuIOSScD6fWtIADoMU10WRCrqGU9QRkGlpcrWxkeGdTvdX0eK9vrT7LJISQnPK9jg9K 8y8UaB4Ig8Q3Z1C91WO6kbzJFi2soJ9CwzXqun63p+o3d1aWc6vLattlUD7tTy6fZTyGSa1idz1L KM07itcuUlFc54p8Rv4fFiUgWX7TN5Z3HGBx/jSSu7IbaSuzpKKap3KD6jNOpDCiiigBjMEUsegG TXnt18TvC1yTZXcE0iPKYnR41YDB64z6/jXoTKGUqRkEYIrkf+Fa+FvtYuTp+X8wybS525JyeOlV Hl6ky5uh0thJbTWFvLabfszxqYtowNuOMDtxXBeJfFusnV7/AEPSre3ZxHgSiQB19TyQCfbt712e saOupaM+nRzPaoQArRcbQO30rjG+EGlM286heeYSSWO0nnrThy7smfM9EeNaxOJyLT7KsZjVkaUn cXfd82Sc98DA/XNenfBKwtYrS/ufLIuhtQu6gErjOfzzWhD8E9FgUqmoXZy24llUnOc+ldH4P8C2 Hg5ZhZ3E8xkABMmOn4VpOpFxsZwpyUrs62oPIhE5mEUYmI2mTaNxHpnrU9FYHQUdRjD2UjCKGSSN S8YmGVDDofaud8N+MLa/tYINTvrRdTkZlEUZIBweOvGT2557Vp+KrzUbHQZ5tLszd3XCiMDPB6nH euZm8MWb+F7bU20FRq0SiUww/ISxPIOO2OcVUUrakSbvobl9faNr9zfeG7hpg8ce6Uj5Rj2Pt7jF c9rfhnTpPCQh8N3FjColBZ3cN5rD+EMejZ7DH4VdtPC17f8AiceIbmRbeO4tQr2m35lYrgg+oqXS /AcUOkPp2pTedGLozxeUSu32/KqTS2ZLTe6Ob8L+DL7WdQXWfFbyPLGAsMDHDELkAsMZAH15616J o2hWmg2cltY7wsjlyZG3HJrG1zwpdXmt2uq6ZqElrcxbUdSSVKD/AD0qprHxDt9ODLb28kzQziGZ nUqPqKTvLYFaG5u6Rp+pxQXcOtXcV8sspMa7BgJ6EY/Tn61neH/D93oV5q+o3Nz9p89i0UUQIwo5 Ax69sU6LxtZXHiyDQrdfNaSPe0obhTjOPf8A+uKk8S+KRot1a6fb27z3l3wgX+DsCfxo97buVeO/ YwvD/iu8vtW1eW6nMYjiZ4tPlQqV2jOd20f5PtXQeFNYk8T+HVur23hBd2R4wMqQD3B/+vWNd6b4 rt9NjvYFsptUDMJiI13SR9lz3+ldDot3a2tpZWE6WtlfSR7zZxkDaTyeKcrW0FG99TRk02xlMJez gbyDuizGPkPt6VcoorM0CiiigDM1u0urzSbm3srk21w64SUdj/8AX6V5VpfjHxXc3A8MXe23u5FM Ud20ZWQNnA69R74r2aqE2m6cb5NSmt4RcxKQs7AAqPrVRkluTKLeqZ574LsdT0Px3qFjqNwbqSW1 VvOEZbcRjq5G7H5g+2K6Xxpo0msLpq272i3EdwGUXD7Sw7gDv9K6lQjEOuCSOCO4rO1DQbHU7+0v blXM1qcx4YgfiO9HNrcXL7tjRjUrGqnGQADtGB+FZOlaFBpN/f3UVxPK15L5jLK+Qp68fn+WPSmt Nq58ULEn2c6WIsvyN4b6dfSt2lsVuFFFcydT12NtYeTS1aO3ANmFPMv+etCVwbsVNE0mfRfFGoRW 2mhNPuB5punkyxb0+nXg/nXYVz11LruoeHLeawRLLUH2s6Sc7R3HNbUXnLDGJPmk2jcQOM96b1Et NEQ6ZfrqenQXixSRLMm4JIMMKW902z1HyxdwJN5Tb03D7prJ8J69JrenuLmN0vLZvLnJTapbnkfl XR0noxrVBXM+JtWu9Mksza3djChkzP8AaZApKccgEjPfp7V01YWr+FdK128jutQt2lkjXYMSMox+ B9zRG19Qle2hrwypPCksTq6OMqynII9qmrBu7+XSL7TdMstLeS1l+QyIcLEK1Rd2zXL2qzxmdRua MMNwHriiwXJQ6sxQMNw6jPIp9cjqXgq1n17+3Yri6W7Q7/LRwA5A6ZxkfnSp4p1G1sbWTUtGmSe4 uTDsh52r/ePWi19hc1tzqXdY0LuwVFGSxOABWF4fnvru4vbqbUrW8sZJP9G8g52j0NLHqF5cazfa fqFhHFpxUJDM7j99kcjGee9MvPB9jPp9vZWsk1lDBN5wELfePvmntuDu9UdJRTQMADnj1p1SUFFF FABRRRQBla9rKaFppvXt5pwGC7Yhk81et5hcW0cwRkEihtrDBGfWp6YwJUhTg44PpQI5DVPFtxpf jiy0eW3X7JdIAsijLbjn/CsC/wDFEniDWZtK0rw9HdQwT5uJJVxnB5bI6fjXa6Dpd9YWrrql/wDb 5/NZo5GXlFPYZq69qIILqSxggjupQW3bAN7Y4LY61V0mTZtbnKWNtoOs3Vzr2mabJ/aFi7KEHyCV wDj2/l70WvikrHbXXiLRHs7t7gw258slsf3uQCBzW3p95daVoAuPEM1vFOHPmOgwDk8dB1/CrOra zp2l6aL+8mTyPvIcZ3Htii+tgtpcvz+abeT7Pt87adm7pnHGa4bTfB92y3Ws6nII9elDGNw25YvQ gD2+uKm1LxxJBFo2o21v/wASy7m8uZpV+dfpg+mT3roNc0OPXYrZWup4BDKJQYjjd9aavEHaXyPP tE8e6nc3em6OZYzdi48ud5QTvXPB7Vual40vNP8AHkWm3EXk6VjY0jRMSzEcEEe5A/OtS48B6HNr EWqCGSK4RxIfLfAYjuR/hWLq3hzWLXxLdXWiWVtMt0olM11h/KkB6rnofTIPeqvBsi00j0QYIyO9 LWWNQXTdNtZNauIYZ3Co5HCl/ardteW14GNtcRzbDhtjA4NZWNrj5po7eB5pWCRxqWZj0AFcZ4x1 Gz1bwLcz2M0s0TEKphB656MOMCuvvbYXljPbbigljZNw7ZGKz/Dehjw/o6WAnM21i24jHWmmlqTJ N6HOaBFrU/wzji3TWl8kR8tnU79qnIHrkgY6Vb0vxJqF14PN5a2FxdX0GI2WRdvmEdWGM5H0rY8Q XGrQWcTaNbRTzmVQ6yHgJ3P8qg0P/hIvtN4dYNv5Rb9wIh0/Tp9cmne6uK1nYzL7RdV3jXdKQx6v OirLbzyZRB3x0rr49/lp5mPMwN2Ome+Kk6CuEjv9d8Q+IbW6sPPsNPs5miuIpTjzffGOeMfSlqx6 ROm17Up9J0xrm3spbuQMB5UYJPJ68VetpWntopWjaNnQMUbqpI6GrFczqmra5a+I7Gzs9JE+nykC W4J5Xrk9eMcdjnNC1G9DomZUUsxAVRkk9hWdaa/pN9CZYLyN1VihOe4rSKhlKsAQRgg1nw6fbaeh hstPhSIkuQiADcetAalmd0s7aedYi2xWkKRry5Az+JrHtvFVo3h9dXvo3soi2zbIOc5xxXRVznjL w03inw++mpci2currIU3AEe2RQrdQd+ht21zDeW6TwSLJE4yrKcgimX1z9jsZ7kRPL5SFtiDJbHa uc8HeEJvC0MqSapJd+YANm3ain1AyefyrqZZUgjaWV1RFGWZjgAUO19ATbWpS0XUzq+lw3pt5Lfz P+WcnUUyHQ7GDW5tWjiIvJk2O2eMcdvwH5VdtrqC8gWe2lSWJvuujZBrnR4301fEx0OSG6S5L7Fc oNrH889/ShJu9hNpWuKvjfTY9bvdMvT9je2YKHmIAfPTFY/ijxaLXXbaCxvv+PTEtzAiFvMUkcA9 OldHfeE9G1O+a+u7PzLllA372HTocZxmufHgO501Zp9J1MrfSy5eadc/u/7oHPt9cY4qlykvmLHi q/0d9J0rWb+K8MQdZYljypGQD8w/AVtaTrKeItDa80/dDv3IhkHQjvWheWMOoWElncjdFIm1scfl Uek6VbaLp0VjahvJj6bjkmldWKs7kOg22pWulpFqt0tzdBjmRfTtWtRVLU75NN06e8kjkkSFdxWM ZY/Sp3Y9kXaKo6VqMeraZBfRRyRpKu4LIMMKvUDCiiigAooooA4X4iWuvTw6fJoIuPNjdi5h5x0w cfnWp4Ottdg0knXrkzTuQyhvvKPQ10vaiq5tLE8utylqGm2mq2jWt7Cs0JIJVvUVHe6Lp+oW0Vrd WsckMRBRCOFxWlRU3Y7IqtZWzwpE0ERjQgqhUYXHpUWr6h/Zelz3ogefylz5aDk1meIvE0Ph+exi lgeX7XL5eVbG0ev+cfWtKw1Wx1IzC0uUlMLlJNv8J/z3p2e4XWw/Tbz+0NOguzE8PmoG8t+q1Fq2 s2Oi2q3F/OIomcICRnn/ACDWjVHU9KsdYsza6hbJcQEg7H9aWlw1sMvdO07XLWL7TClxCCJIyen1 FN0rQrDRvtBsojH57735zz7VfjjSKNY41CoowqjoBUtO72Cy3Mo69YjXxopZ/tZj8zG04x9a1axF 1fSH8Qvp/mw/2miYwUw2OuA2OeoOK2AytnBBxwcHpQwQ+iiikMzbzWrDT7+1srmcJPdHES46mtEA DoMZqrLY2lzPDcTW0Uk0JzG7KCUPsallljhjaSV1jRRlmY4A+poEYni82p0Xy7rVP7OV5FCy5xk5 6VrWaqLGALMZlEa4kJzvGOv41BqGl6frlqkd5BHcwgh056H1BFXI4lhhWKJVRVXaigcADpTvoFtb nAWuvDU/iHEbddQEShoWQrhAR3+n+Nei4rmPCula1pyXr6zfC4knmLoqnIUfkPyqrrfj+x0PU3sZ rG+lkQAl4k+U59OaHq9BLRanY1Xe5gjlSJ5kWR/uqWGTWNE2p2Oo6nfapewf2QqboVAwUA65/X1z kVmaR4X0m91IeIYtQuL7fIZIdzHantj/APVRZdQu+h2lQXNtFeWsltOgeKRSrKe4qeikUU9O0610 qyS0s4/LhTouc1M0ELyrK0aGReQxXkVNRQAUUUUAFFFFABSEAjBGRS0UANAAGAAAOwp1FFABRRRQ AVAtxC8zwrKjSp95A3I/Cp64y407TvDnimbxHdal5Ed2PKMbA4LH39OM/hTSuJux0mraiulaZPet E8oiGdiDk1z2nav4h1PXoZY7BYNFeMPukHzHP9ammumvPGNvBaa1GqQw7p7IDO8HnOcYPBHfjj1q bxR4nj8MxWbNavMLiURgLxihLoS31JWvrHxPZanpdneSxyIDDLIgwyE5GR+RqXw5ox0DSlsjdy3O GJ3yfyFQa1GbLQb+608wWNwyiRpmXH1zgdcZH1NXdDuze6LaXDXMdw7xjdLGMBj34o6aDW+u5V8T 6QdU0iUQW8Mt9GpNs0n8DeoPrXiEuj+LfC2qJCFvIvPPmE2jEq3OAOO/rX0S+dp2kBscZrlNDsfF kGrCTVtRtprPDZRBznPHYf8A6quEmkROCbR01mWNlAX3bzGu7d1zjvVmimswVSx6AZNZmpy/ie28 S3d7bw6NPHbWpGZZc/MDmruvGeDwrdg+dNOLcqWh4YnGCR/OoNJ8THX9Hu7vTLR/MiZkjWUgB2Hv mqHg61197i81PXbnEk7FVtUIKoBjB4Jx3qvXoR6dRPD/AIV0+aw0fU7mGf7dDGG3SNhjnkBvXGeK 29I8P2+j3d7cQyzO10+9hI2Qv0ptzc6uniK1gt7ON9MZCZpiwyrc/wD1vzqK51LUZdZtI9Mit7qw 3FbqVZATGfTrwaG2wSSOgoooqSwqhqmm2+rafLZXQYwyjB2nB9etX6rXTTJaTNbIHnCExoTgFscC hAxtjZw6dZQ2luCIol2qCcnFW6ytDn1K40tJdWgS3usncinjHY1YtL+y1KOX7JdRzqjGNzG4O0+n FNiRZSRJBlGVgDjIOaGjVjkoCfXFZmh6DbaFbSwW0ksiySFyZWyQa1s0mC8zB0/Q528PyaXrV22o eaGWR2yCVPbOc1f0rTLTRdOisbKMpBEMKCST+JNW4pkmiSWNgyOoZSO4PSpKbYJIWiiikMKKKKAC iiigAooooAKKKKACiiigAooooAKy9b0Sy17T3s76IPGeVPdD6j3rUooTsDVzH0rw9pmjJEbW2QTJ EIvPIG9lHqajez1V/EiztdRHShH/AKgoCd3r/wDXrbop3FZFDWNPGraRdWBkMYnjKbwM4rIOlato 3ha20/RZ4pLqHau+UYBXvgc101cpq/it9L8RQaT9jZhcR5jm7bz0H0zQr7IUrLVmV46062v00iPU 7q9hnkYR/wChqCu44yeenNbHhnwfD4ZuLiaK/ubjzlA2yEYGPYCtDRDqVzp6vrdtEl0shIC4IA7G tim5O1hKKvzBWHZ+HIbTUtSu2ubiYX4w8UjfKo6cVu0VNyrHAaHYW3hvxVd6PHqM7Q3cZkitCCQm f9onr9KzPC3iaz0rWbnRotPlhiNy3nXE03CHtnjH/wCuvSmt4TOJ/KTzgMCQryB9a8u8aWWoaZpM p1Ge3ljub5W3ImCqAE8mtIvmdmZyXKrroeqBlkBAYMO+DXJeFNKttD1fVbNNSjmllfzfIAOUHvn+ lLJajQY7zXdKWfUWulTZbqxKqvqPasbxD4a1JZ18QaKbqPULpl86EH7gPWkl0uOT622PSap6pu/s q52XQtW8s4nP8HvXm+reJdY07xrp0epGW1s9wijjjG7zicAsex5K12ejaZqn2W8g166jvYpWOxQP 4aXLbUpSvoUotGOv+Eba0uNZmuTuD/aoTgtg9Dn+tdHDPbLL9jW4V540G5C+Xx6nvVSVtO8MaIzr H5NnbrnagzVDQP7B1m7m8Q6ZueaUeVIzZGCMdj0PSh66gtNOpJL4qsF1S90sxTNc28RkKbf9YO4X 1rz/AMKXN5c6hqx8MwNaytPG8kVzJuRUycgDHr+Q6Yrp9U0nUdS8UT3UVgIZbSH/AES6LYV27A+t YltBeaN8QrKSd4ft19Zt50cf3TJg7QcdM4HPTg+tVG1nYzle6uei6pqkOjaTNf3mfLhXL7f6V5pq J8K+K7s6s3iC6tjKAPKIHGPT2rr59M1XxH4Nu9P1lIYLucFQB93rxnFcFYfBjUYbba1/DEdxO1C2 B9KUeVbscuZ7I9euru202ye4uZFhgiX5mI4UdBwKy/D8uqzNd3N7dW89lM+6zMP9w9OwrQuEtNX0 +eHEN1C4KlScqSOx/Guc0fS/E6vYG5ubeztrZirW0K8MnbpxUrYt3udnRRRSKCiiigAooooAKKKK ACiiigAooooAKKKKACiiigAooooAq3lubqzntxK8RlQoJEPzLkYyK4220rVPClvd3t/enV7S1j32 8TJ+8DexOSv1ya7ymkAjBGR7007aCavqZ+jal/a+kW199neDzl3eW/Vf8a0qaAAMAYA7CnUhhWFq lrrFxqGnyWF+tvbxSZuY2XJkXj2+o7dc9q3aKE7CauFcPb2em6t4n1uwuL27ug6ASWsgIjTkcqQe o47Dr3ruKiWGNJGkVFDt95gOTTTsDVyg+lLDoTaZp0ptAsXlxOvJT3rIvfC17qHhu202bXLlLiFg zXKAgvjseQcfjWlda9HbeILbSDbTM86bxKo+VevB/KjXtRvtOs0lsLE3kpkCsgP3R60K4nYy9M8E 2doIn1C6uNSngm82GWd2ynTjGeeQD9a62oo2Zo1Zl2sQCV9D6UrqWjZVYqSCAw7UNt7jSS2Oe8Ux 6/cJawaILYo8mLgzqGG30IPVfXHNO0LRbzStTv2E9uNNlYNb20MQQRnv0H4dT+FYvhrw1rdl4lub /VdRmmhTKwKZMhwc9fQe3rXe9Kb00RK11Ylecaj4dvl8Qa5q8t0lhbvAPJvSdzJyuQMcjOCOPXjO a728vrWwiEt3OkKMwUM5xkntTrm2t761e3uI1lgkXDKwyGFJOw5JM51rJPEejWUVpr8jtblGkngb mQj+8AQQa6hV2qFyxwMZrH0fwzpmgT3EunwmLz+q7iQPYDtW3Q32Gl3MvRtEstCt5LayVlSSQyNu bJyf/wBVadFFJghaKKKBhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU UUAFFFFADMAkHAyOhrltIawh8X6nDFqVxPdyDc0Dg7E+h6UUU1syXujrKKKKRQUUUUAZ+p6RZaxA sN9AJURg6gkjBq6qBFCqMKBgAdqKKAsPooooA//Z