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 Residential Permits 002 1 -117.042443 -116.847337 47.776507 47.684781 Post Falls Residential Permits Residential Permit data that is from Opengov and the old Energov permitting software. Mechanical Plumbing and Electrical permit data is omitted form this data at this time 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 gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKAEoriYfD+ur4nvr+S6zaSI4iQTHOSMDjHFZ99oPi2TSLJLa6ZJ4dwkXzz83PBrmdaSV+V k3fY9GqORXaJlRtjkcNjODXEa94qufD+jpZgSHVEhRjIy71Prk+tbejzajquhafdNeCKZ03S7UUh /wDD8KuNaMnyrcd+htQLIkCLLJ5kgGGfGNx9cVPWBo9vf6dcyW1/qBvBLl4SyncPUZ9OlbpOASBk +laRd0MdRUMDvLCryRGJyOUJyRU1UAUUUUAJS1DLKkETyyMFRFLMT2A71x+q+P8ASrRFktbuK5Vw AEjDbgc/e9CAO3es51YQV5Owm0jtBjtS15fqfjvUE0i2vbC4tZVkco+5BGykKucglu5J+hrv7a4u rm0sLhRFtlQPPnOQCufl/GphWhOTUeg9L2RpUVTbUbRb9bFrmIXLLuERb5iPp+Bq5WtwCiiimAUU UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBFKZBExiCmTHyhjgZpGErwEBgkpXqBk A0kiSNJGyS7UUncuAd1Ecbo8jNKzhjlQQPl9hSAgsVvVWQXjo7b/AJCox8tPDmOcrNOpEpxEhGCO OR70/ZMZj86iHbjGPmz65rl9eXxEYYl0xTtXcjvIQX/3vyrOcuRXs2J6HRtHZzzyxMkTy7R5gK5O O2ax7/xLBpGpx6YliSPK3Kyuqovt7VNoVs03hyOC7uWuC6lWk27Gx6fh61Tl8CaTNcpcSPcs6nJL Sk5NRJycU4oNehrtq1vbQ2xvmS3nnIUQ7tzBj2965Lxtquv2WqWVtp8ojguDhTGMuTx1ro30y11D WFupbYKbNxsYry5x7joM9qvSOtxOgS380xSYZnGNnHUZ60SjKcbXt6A1oTwhrezQTS72RBvkbjPq TWFp3i+y1fVpbCxRpTGQDJuABGeSB3FW9d0uDX7Y6c93LC6ESHyWwe+M+1YuifD6z0a9juPt1zN5 bb1QkKN3qcdfpTm6nOlFadQd76Ha0VBA8j7/ADIvLw5C/NncPWp63Gch4t8MW2pLPqsl1dRvb27M I43wrbQTXG+DtCXxTok9rcefbQW1x5kUqAAuWGCM47YFetywpNE8UihkdSrA9wetV9P0y00m1+zW UKxRbi20ep6muSph4zmpPbW/mS43Zwx+E9ivEepXW3O4q2CM+1d0kT2emxwW4EjxRqiBzjOMDmrl UJ47ptQtmhcpCoJkychvbHr71rCjTp3cVa40ktjAu9Bmu/iBaamfMSG3gDlgBtZvmXb+ua601FBc Q3EfmRSLImSu5TkZBwf1qarjBRvbqNi0lY/iDX4PD9iLu4jkkUttAT1pNP8AENpqWgHWIA/kBGch hg/L1/lS9pHm5b6iubNVbW8gvo2kt5N6q5QnBHI4IryXUfirqcsbxW9rDDliPNQksFH14Brrvh3P qdxpk0l5bCG3dvMh+XG7dyTWMcTGc1GOoua529FFFdRQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA UUUUARNLGjKrOqs3QE8mq1jPDKjpDcNPsY7nbn8M1aaNHZWZQWXoSOlKiIgwihR6AYpa3Azre+M8 tzNvC2tuWQ99xHU5qPS7g3drNLDeLKZiZIdw+4p6celX5bOCW1ktmTEUgIYLxnPWqlhJZLi3t42j MS7AGQg7V9/Sos01diLEKTR2rC6mTdz86DaAKk8uVLTy45iZAuBI/PPqaqXFx598LL7MJotu6Zi3 Cjtx3p1ldzXc8ubZordOEd+C578elNNXsBHJaRWkM8xkmWSUqZHQknPsOwqwouTFGPOj80MPMIXg jPT2OKmuJ1t4WkZXYDsgyfyqOzELRGWKMx+axZgwwSenP5UWSdkBTvdWFpPdILSWRoYBLlFzvycB R71ajaCCJruT935+1n3HoSAAKryWi2usSapLcbYTAIih6A7s5rTYKwwwBHvQr3dwI5ZVhhaVs7UB JwMmmRXMVwzrGSSmNwIIxkZFSGaIMFMiBj0BYZNSYHpVdRlC/jlubeaziDo00Dqsw6IcYHv3/SuI TW5PAXl6VqBa/lnJn84PtCg8Ywc/3Sa9GxVC80jTtQlWW8s4ZnQYVnXJArKdOT1i7MTXYW9tpL63 QQ3Uts4IcNGevsfUVILgrO0UikBIw5kJGD68UkVmkV7NdB2zKqqUz8o29xUxhiMvnbB5m3bu749K 0s9xiQGJoVeDb5bDcCowDnvUxpoAUAAAAdAKzNaSaSyCW4dpDNHjbnj5gSTgjjFPoNK7sZ/ibwlb eJvLM93cQ7FwBG3B5yDj1pfDHh06R4a/sq72urFwVB42knj8q3VabzyrRr5QUEPnknuMVPWapQ5u e2pNle5i2/hXQ7SN0i0y3AkAD5TO7HTNakEEVtCsMEaxxIMKijAAqekqlFR2QxaKKKsAooooAKKK KACiiigAooooAKKKKACiiigAqKWVYYXkb7qKWOPQVLUb7GBRiPmGME9aAMSw8XaJfxhkv4o36FJD tI/OrH9tWl5cPZWF7bvdqofGdwx+FY48B6FCWllh3RgMX3euc5zXFapPp+ieLtNbQWaNZCqyOvIA JxgiuOdWcLc1vvJbaPXoBKIVE5UyfxFRgU9iqguew5NOXlR9KinaRYWaJVLgcBjgV17IorJfRM4Y RPskIVJAvDZqacXACtAV+U5ZSPvD0HpT4JElhV42UqR1XpWfqlzGkMkVyJooTtCyxZJJ9OKluyu2 ItTQ/bbIRymSAuAW8t8Mp9M1Qjs5tMkkkS5nuWuZlG2X5gg79Ki06eTUhcLPaXCW8rExtI3YYH4Z rUmuDbyR5CiA/KWJ5B7DFTpJcwXuV73/AEvNoscp+ZSzqdoA6g579Kjd4lsPsd9IS7RFZTGSSBg8 k9RwKsl5440eWeFQjnzTjjb2HselV7kagtxK1rb221goDMfmfnnP4ZofcCuujabBbxiKGVtzqyMC WZTxg89uAa2YUaOFEZzIygAu3VvejyYvtHnbR5u3Zu9uuKlq4xUdkMiWSN3dFYFkIDAHkZ5pZJUi jaR2CqoyxPYVFctDb2880g2oFJkIHJAFZOkXCXlhLdpbkmPdBGpJy6KeAc9zScrOwjSs9Ts9QklS 2nWUwkB9vY1N9pha6e3Dgyoodl9Ac4P6GqGn25sLWa5mh2zykySJEM49FHrgVpKFOH24JA5I5pxb a1GvMqPqFvHqMVgxY3MiGQKFJAUcZJ7Vz0iazZ+MIfKtkGm3UzNLKjszHCcbgeAM+lb9/emza1Ih DiWYRO5YLsBB5/PAx707U4L24ijWyuBA4lUuxXOU7ihlp8uttzQopBwOTmlqiAooooAKKKKACiii gAooooAKKKKAEooqteXsFhay3VzII4Yhudj2FAJX0RaxRiqcV9FPMkce5t8QlVwvylT7+tNsdQjv 1k2o8bxOUdHGCpoCzE02+OoW7StA8JWRk2P14OM1eoAxUO2b7QW3r5O3G3HOfXNIbJ6w7/w7b6hq cN7JcXKNHj5EkIU4rcqg+oxRXJgkWRDuVVYodrE+hpSipKzFa5U1Gyubm4CjV2tYnG1YlRcse/J6 1zjfDS2e++2vqly028OTsUdO1dTqFnLPPDPGkEvkAtGkg539iD2rQTcUBYANjkD1rOdGE37yuEop q45RtUDOcDGaZLuETbFDPg4BOMmpaK2AwItOvIoh5cssTzIQ6mTcsTdcitQQyukG6YhkwX2jh+Kt 1TKTQWsvkkzy8sgkbGT6Z9KhQS2BIjQz2VtPJcyNcIpLLsT5semO9S/a4WWTqxjUOybeQDyOPWq5 08z2TJdTTSMX8zCtgqf7oI7VbhJltw+xonZejD5h9aFfYClsl8mSSK3ikE0ittb5flOMk57gVq1R guApjgDNMy5R5QOAQM80xkvjK7rJGoBwiEZBGRyffrQnZaAaNFUi8yakqASNC8ROQo2qwPc+pz+l XasCKV44omeVlWMD5i3QCmQQwwqxhUBZGLkg8EnvVS4tbi9a9tpnC2ksSrGVxuB53f0qaKxWCG1h jkdY7ddoGfvDGOam7b2AnWaNpWiDgyIAWXuAelS1Sc2+mWTSMW8uJMs5+ZiB69zUdrJLqWlxSXEM tnLIAzR7vmTB6Zp3Y7O1yYJJPbEXEUXm5JUH5lBB+U/yqW2877PGJyhm2jeU+7nvikinWSWSMBsx 4BJHByM8HvUEEssV0beYvIzlpEdY8Kq54Un15oQLVF+imlgCASMnoKQMpYqGBI6jPSmIfRRRQAUU UUAFFFFABRRUUsiRRtJI6qi8lmOAKAJBRis6HVYLxIJbI/aoJZGQyxnKpgHk+2Rj8asPdxRXMEBJ 3zbthAyOOTzRcdmizWFraTXeiPA1s/nTMF2IQ23nhj6gYGawL34n6dY381m9jdM8UhjYrjrWvofi K18QWp1D7FPAkKlkeXuOhxj6Vgq0JvljLUlSs9BnhHW7G+0+KytZZJntU8uVzCUCsDjBB6Gt+5jn MX+jOiSFgSzLnIzz+lULPRLG21GXUrbeklwd7hThWJAGSPwrRluYLeKSSWVESMZck/d+tbLbU0k0 5XiZlhrkl7rF5p7addQrbNgXDr+7k+hrTZZvPQqyiIA7lI5J7c0lpdw3tus9u++NujY61PQS99rE N00wtpPs4UzBcoG7mqk8d9OLd4wsbL8zhm7+nHUVd8iP7QJ9v7wLtzntU1Jq4im8lyL+KMRg25Ql 39G7CpLa3+zw+X5kknJO6Q5PNWKKaQBRRRTAKKKgM8SzrAZFErKWCZ5IHegDHs9CubXxDc6idUne 3m5FofuKcYzW9VWWSVkQ2vlP+8Afc3QZ5xjvS285nVmeJ4sOVAkGCcdx7GktBtuWrHloonAJVWc8 DoWP9aZGtwLqVnkUwkL5aheVPOcnv2qlrGlyX8UcttIsV7bEvbyMMqrEEcj6GofDb6w9lL/bOwzC QhCjAgr+FJytJKwOyWhoebd/2l5X2dfsvlbvO3878/dx9O9XD04orJu4r99NjiDh5mlUSvFhRs3f N1/2eKYJXL1oZzaxm6VFnI+cIcrn2qxUNvAlvbxwx52RqFXJycD3qamJ7hVDU4nmtPLSJpCXTKrJ sONwJOfatCqkMJimncyvJ5jBgjEYTgDA9uM0AnZ3KOrSB7mwsmZgtzIQ20HOFG7qOnIHWtCW5gty iySKpdgignqx6D9Kn71QuLWVrtJYDCmSDKXXcTjpj04zSd0NvRIjF5b3ep+XFGHe1cpI7fLsJGeP Wr6wxrK8iqA743N64pr2sMgG+NThw/Ax8w71YpJPqIimZ0hdo03uBkLnGTSxsXjViACRkgHNMuIF ubd4XLBXGCVOD+dOhhS3hSKMbUQYA9qetwJaKKKYBRRRQBDKzrEzIm9wpKrnGT6Vmajpf9u6fbx3 W+Ab0llhGGDY6o3qK2aT6UWBNp3Rny2hW0S3s/KgQMoKhONmeQAMYyM81VsLLY32eeElbSTNtJyB tI4A5ySAcEmrcaXzR2zSyRRyIxMyRruVxggAE4x2P4VodqViuZpWPFz4XPiDxRrqLFMkdvdKEIwS dzEHr2GCfXFej+GfDsfh6w+zmYTlchXK7dqnnH0rfA9hVa/tzd2M9urbWljZATnAyPasY4enCXOl qKXLJ3SsVLyUtctbi9S3jWESnb/rAA3J9NuBioxbz3cLT24ggkllUs5HmCaIdPzFaCQbLVY8KzLH s5HB4/lUVlciZTbyeWlzEq+bHGchCRkYrYd9NC8AAMAYFLRRTJCiiigAooooAKKKKACovLTzBIUX eBgNjkD0zUtFAGfcaXDNZvbxM1uGfzN0PyndnOai1OyuL2SzWN1EEc4knBJBYAZAGPfFalVL2R4r OVoyRJjCkKWwe3FJ2SuNNrUEuxtiEqGJ5GKqjc5xn0+lSQW8VtFshjCICTtHqTk/rSWkhktlLyJJ Io2yFOm4das0IRmPLeRoJZ3hhijlYyYy26LBxz2PSp7eCC13+Ucee5k5bOSR2z9KVZ4pbia2wxeN VLZU4IOcc9+lR3DM9wqLamRo2Vg7cAZyCQfUCk9NRl3IBAJGT0p1Z88a3crRqXinhAKShfu7uuOx 6U9lea6G8SIkTBkYOMSZByCPai4h9pO08TMyqCHZflbd0OKQxQ28k97tbcyDeQSchc4wPxNRXM62 iIsJjRiTIU28so5bAHeptrSyQzLI6oASYyPvZ6Z9MUJ9OoXItOne4s1lkaJnJOTETt6+/eootVgv rOSbTSt20bbSisBznkHPSotJEMM11FCd0csrTKVyVGTgjPY5B4p+jaDY6Es62SuBPIZH3NnmpTk7 fiF9bmi8qRRGSVgigcljwKkByMiopYo54mjmjV426qwyD+FSgADAGAK0AWiqdq90zz/aI1RRIRFg 5JX1NXKSdwIY5Y5QTGysASpwc4I7VLVOzeBmnSGAxbJCG/d7QzdyPX61cNMHoLRRRQAVWt7aK1R0 iBAd2kOWJ+Zjk9fc1ZooAKKKKACq9zK0FtJKsTysi5Eafeb2FWKKAKlrctOH3wSQFWKhXxlgO49q YrQ3kx2+YGtpMHqozj9RUrW0T3SXDJmVFKq2TwD146dqs0rDdgooopiCiiigAooooAKKKKACiiig AooooAght4bcOIo1QOxdsdyepqeiigAooooAhuGmWFjAqvJ/CrHAP41NVd42eaKQSsqpnKDGHyO/ 0qxSArxRusjmSTzMsSmVxsHHFLPOsEYZgxBYL8qknk4qeii3YCjNp6zXMM6yzRNGc4jbCsOeCPxq 9RRTsAVBFKZTIDG6bGK5YY3e49qrTyZnMhiuCLcjbs6Sbsdu+KkkhuXuopUudkQHzxFM7vxzxU3A geULqvkhZCZosF1bIQj27detXoY2ihVGkaQqMF26mkEUayNIFUO2AzAcnFTUJWAKKiljWaJo2JCs MHacH86VECIFGcKMDJzVASUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAF FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA BRRRQAUUUUAFFFFABRRRQAUUUUAf/9k=