20260727
13594400
1.0
FALSE
ExportFeatures main.DCCAddressbase \\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Devon_Addresses.gdb\DCCAddresses # NOT_USE_ALIAS "FormattedAddress "FormattedAddress" true true false 699 Text 0 0,First,#,main.DCCAddressbase,FormattedAddress,0,698;Uprn "Uprn" true true false 12 Text 0 0,First,#,main.DCCAddressbase,Uprn,0,11;AddressBasePostal "AddressBasePostal" true true false 1 Text 0 0,First,#,main.DCCAddressbase,AddressBasePostal,0,0;AddressPostalDesc "AddressPostalDesc" true true false 35 Text 0 0,First,#,main.DCCAddressbase,AddressPostalDesc,0,34;State "State" true true false 4 Long 0 0,First,#,main.DCCAddressbase,State,-1,-1;BuildingState "BuildingState" true true false 36 Text 0 0,First,#,main.DCCAddressbase,BuildingState,0,35;Class "Class" true true false 6 Text 0 0,First,#,main.DCCAddressbase,Class,0,5;Class_Desc "Class_Desc" true true false 200 Text 0 0,First,#,main.DCCAddressbase,Class_Desc,0,199;Primary_Desc "Primary_Desc" true true false 100 Text 0 0,First,#,main.DCCAddressbase,Primary_Desc,0,99;Secondary_Desc "Secondary_Desc" true true false 200 Text 0 0,First,#,main.DCCAddressbase,Secondary_Desc,0,199;Tertiary_Desc "Tertiary_Desc" true true false 200 Text 0 0,First,#,main.DCCAddressbase,Tertiary_Desc,0,199;Quaternary_Desc "Quaternary_Desc" true true false 100 Text 0 0,First,#,main.DCCAddressbase,Quaternary_Desc,0,99;ParentUPRN "ParentUPRN" true true false 12 Text 0 0,First,#,main.DCCAddressbase,ParentUPRN,0,11;WardCode "WardCode" true true false 35 Text 0 0,First,#,main.DCCAddressbase,WardCode,0,34;WardName "WardName" true true false 100 Text 0 0,First,#,main.DCCAddressbase,WardName,0,99;ParishCode "ParishCode" true true false 35 Text 0 0,First,#,main.DCCAddressbase,ParishCode,0,34;ParishName "ParishName" true true false 100 Text 0 0,First,#,main.DCCAddressbase,ParishName,0,99;BuildingName "BuildingName" true true false 50 Text 0 0,First,#,main.DCCAddressbase,BuildingName,0,49;OrganisationName "OrganisationName" true true false 100 Text 0 0,First,#,main.DCCAddressbase,OrganisationName,0,99;Thoroughfare "Thoroughfare" true true false 80 Text 0 0,First,#,main.DCCAddressbase,Thoroughfare,0,79;Locality "Locality" true true false 35 Text 0 0,First,#,main.DCCAddressbase,Locality,0,34;TownName "TownName" true true false 30 Text 0 0,First,#,main.DCCAddressbase,TownName,0,29;PostTown "PostTown" true true false 35 Text 0 0,First,#,main.DCCAddressbase,PostTown,0,34;PostCode "PostCode" true true false 8 Text 0 0,First,#,main.DCCAddressbase,PostCode,0,7;AdministrativeArea "AdministrativeArea" true true false 30 Text 0 0,First,#,main.DCCAddressbase,AdministrativeArea,0,29" #
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/3.4.0'><WorkspaceConnectionString>DATABASE=\\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Devon_Addresses.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DCCAddresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Existing_Authority</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>New_Authority</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
SpatialJoin DCCAddresses SDEADMIN.OS_BoundaryLineDistricts \\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb\DCCAddresses_ExistingJoin JOIN_ONE_TO_ONE KEEP_ALL "FormattedAddress "FormattedAddress" true true false 699 Text 0 0,First,#,DCCAddresses,FormattedAddress,0,698;Uprn "Uprn" true true false 12 Text 0 0,First,#,DCCAddresses,Uprn,0,11;AddressBasePostal "AddressBasePostal" true true false 1 Text 0 0,First,#,DCCAddresses,AddressBasePostal,0,0;AddressPostalDesc "AddressPostalDesc" true true false 35 Text 0 0,First,#,DCCAddresses,AddressPostalDesc,0,34;State "State" true true false 4 Long 0 0,First,#,DCCAddresses,State,-1,-1;BuildingState "BuildingState" true true false 36 Text 0 0,First,#,DCCAddresses,BuildingState,0,35;Class "Class" true true false 6 Text 0 0,First,#,DCCAddresses,Class,0,5;Class_Desc "Class_Desc" true true false 200 Text 0 0,First,#,DCCAddresses,Class_Desc,0,199;Primary_Desc "Primary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses,Primary_Desc,0,99;Secondary_Desc "Secondary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses,Secondary_Desc,0,199;Tertiary_Desc "Tertiary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses,Tertiary_Desc,0,199;Quaternary_Desc "Quaternary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses,Quaternary_Desc,0,99;ParentUPRN "ParentUPRN" true true false 12 Text 0 0,First,#,DCCAddresses,ParentUPRN,0,11;WardCode "WardCode" true true false 35 Text 0 0,First,#,DCCAddresses,WardCode,0,34;WardName "WardName" true true false 100 Text 0 0,First,#,DCCAddresses,WardName,0,99;ParishCode "ParishCode" true true false 35 Text 0 0,First,#,DCCAddresses,ParishCode,0,34;ParishName "ParishName" true true false 100 Text 0 0,First,#,DCCAddresses,ParishName,0,99;BuildingName "BuildingName" true true false 50 Text 0 0,First,#,DCCAddresses,BuildingName,0,49;OrganisationName "OrganisationName" true true false 100 Text 0 0,First,#,DCCAddresses,OrganisationName,0,99;Thoroughfare "Thoroughfare" true true false 80 Text 0 0,First,#,DCCAddresses,Thoroughfare,0,79;Locality "Locality" true true false 35 Text 0 0,First,#,DCCAddresses,Locality,0,34;TownName "TownName" true true false 30 Text 0 0,First,#,DCCAddresses,TownName,0,29;PostTown "PostTown" true true false 35 Text 0 0,First,#,DCCAddresses,PostTown,0,34;PostCode "PostCode" true true false 8 Text 0 0,First,#,DCCAddresses,PostCode,0,7;AdministrativeArea "AdministrativeArea" true true false 30 Text 0 0,First,#,DCCAddresses,AdministrativeArea,0,29;Existing_Authority "Existing_Authority" true true false 255 Text 0 0,First,#,DCCAddresses,Existing_Authority,0,254;New_Authority "New_Authority" true true false 255 Text 0 0,First,#,DCCAddresses,New_Authority,0,254;NAME "NAME" true true false 60 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,NAME,0,59;AREA_CODE "AREA_CODE" true true false 3 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,AREA_CODE,0,2;DESCRIPTIO "DESCRIPTIO" true true false 50 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,DESCRIPTIO,0,49;FILE_NAME "FILE_NAME" true true false 50 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,FILE_NAME,0,49;NUMBER "NUMBER" true true false 8 Double 0 11,First,#,SDEADMIN.OS_BoundaryLineDistricts,NUMBER,-1,-1;NUMBER0 "NUMBER0" true true false 8 Double 0 11,First,#,SDEADMIN.OS_BoundaryLineDistricts,NUMBER0,-1,-1;POLYGON_ID "POLYGON_ID" true true false 8 Double 0 11,First,#,SDEADMIN.OS_BoundaryLineDistricts,POLYGON_ID,-1,-1;UNIT_ID "UNIT_ID" true true false 8 Double 0 11,First,#,SDEADMIN.OS_BoundaryLineDistricts,UNIT_ID,-1,-1;CODE "CODE" true true false 9 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,CODE,0,8;HECTARES "HECTARES" true true false 8 Double 3 14,First,#,SDEADMIN.OS_BoundaryLineDistricts,HECTARES,-1,-1;AREA "AREA" true true false 8 Double 3 14,First,#,SDEADMIN.OS_BoundaryLineDistricts,SDEADMIN.OS_BoundaryLineDistricts.AREA,-1,-1;TYPE_CODE "TYPE_CODE" true true false 2 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,TYPE_CODE,0,1;DESCRIPT0 "DESCRIPT0" true true false 25 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,DESCRIPT0,0,24;TYPE_COD0 "TYPE_COD0" true true false 3 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,TYPE_COD0,0,2;DESCRIPT1 "DESCRIPT1" true true false 36 Text 0 0,First,#,SDEADMIN.OS_BoundaryLineDistricts,DESCRIPT1,0,35" WITHIN # # #
CalculateField DCCAddresses_ExistingJoin Existing_Authority !NAME! PYTHON3 # TEXT NO_ENFORCE_DOMAINS
ExportFeatures DCCAddresses_ExistingJoin \\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb\DCCAddresses_ExistingJoinCleaned # NOT_USE_ALIAS "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,DCCAddresses_ExistingJoin,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 8 BigInteger 0 0,First,#,DCCAddresses_ExistingJoin,TARGET_FID,-1,-1;FormattedAddress "FormattedAddress" true true false 699 Text 0 0,First,#,DCCAddresses_ExistingJoin,FormattedAddress,0,698;Uprn "Uprn" true true false 12 Text 0 0,First,#,DCCAddresses_ExistingJoin,Uprn,0,11;AddressBasePostal "AddressBasePostal" true true false 1 Text 0 0,First,#,DCCAddresses_ExistingJoin,AddressBasePostal,0,0;AddressPostalDesc "AddressPostalDesc" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoin,AddressPostalDesc,0,34;State "State" true true false 4 Long 0 0,First,#,DCCAddresses_ExistingJoin,State,-1,-1;BuildingState "BuildingState" true true false 36 Text 0 0,First,#,DCCAddresses_ExistingJoin,BuildingState,0,35;Class "Class" true true false 6 Text 0 0,First,#,DCCAddresses_ExistingJoin,Class,0,5;Class_Desc "Class_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoin,Class_Desc,0,199;Primary_Desc "Primary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoin,Primary_Desc,0,99;Secondary_Desc "Secondary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoin,Secondary_Desc,0,199;Tertiary_Desc "Tertiary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoin,Tertiary_Desc,0,199;Quaternary_Desc "Quaternary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoin,Quaternary_Desc,0,99;ParentUPRN "ParentUPRN" true true false 12 Text 0 0,First,#,DCCAddresses_ExistingJoin,ParentUPRN,0,11;WardCode "WardCode" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoin,WardCode,0,34;WardName "WardName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoin,WardName,0,99;ParishCode "ParishCode" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoin,ParishCode,0,34;ParishName "ParishName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoin,ParishName,0,99;BuildingName "BuildingName" true true false 50 Text 0 0,First,#,DCCAddresses_ExistingJoin,BuildingName,0,49;OrganisationName "OrganisationName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoin,OrganisationName,0,99;Thoroughfare "Thoroughfare" true true false 80 Text 0 0,First,#,DCCAddresses_ExistingJoin,Thoroughfare,0,79;Locality "Locality" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoin,Locality,0,34;TownName "TownName" true true false 30 Text 0 0,First,#,DCCAddresses_ExistingJoin,TownName,0,29;PostTown "PostTown" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoin,PostTown,0,34;PostCode "PostCode" true true false 8 Text 0 0,First,#,DCCAddresses_ExistingJoin,PostCode,0,7;AdministrativeArea "AdministrativeArea" true true false 30 Text 0 0,First,#,DCCAddresses_ExistingJoin,AdministrativeArea,0,29;Existing_Authority "Existing_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_ExistingJoin,Existing_Authority,0,254;New_Authority "New_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_ExistingJoin,New_Authority,0,254;NAME "NAME" true true false 60 Text 0 0,First,#,DCCAddresses_ExistingJoin,NAME,0,59;AREA_CODE "AREA_CODE" true true false 3 Text 0 0,First,#,DCCAddresses_ExistingJoin,AREA_CODE,0,2;DESCRIPTIO "DESCRIPTIO" true true false 50 Text 0 0,First,#,DCCAddresses_ExistingJoin,DESCRIPTIO,0,49;FILE_NAME "FILE_NAME" true true false 50 Text 0 0,First,#,DCCAddresses_ExistingJoin,FILE_NAME,0,49;NUMBER "NUMBER" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,NUMBER,-1,-1;NUMBER0 "NUMBER0" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,NUMBER0,-1,-1;POLYGON_ID "POLYGON_ID" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,POLYGON_ID,-1,-1;UNIT_ID "UNIT_ID" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,UNIT_ID,-1,-1;CODE "CODE" true true false 9 Text 0 0,First,#,DCCAddresses_ExistingJoin,CODE,0,8;HECTARES "HECTARES" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,HECTARES,-1,-1;AREA "AREA" true true false 8 Double 0 0,First,#,DCCAddresses_ExistingJoin,AREA,-1,-1;TYPE_CODE "TYPE_CODE" true true false 2 Text 0 0,First,#,DCCAddresses_ExistingJoin,TYPE_CODE,0,1;DESCRIPT0 "DESCRIPT0" true true false 25 Text 0 0,First,#,DCCAddresses_ExistingJoin,DESCRIPT0,0,24;TYPE_COD0 "TYPE_COD0" true true false 3 Text 0 0,First,#,DCCAddresses_ExistingJoin,TYPE_COD0,0,2;DESCRIPT1 "DESCRIPT1" true true false 36 Text 0 0,First,#,DCCAddresses_ExistingJoin,DESCRIPT1,0,35" #
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/3.4.0'><WorkspaceConnectionString>DATABASE=\\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DCCAddresses_ExistingJoinCleaned</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Join_Count</field_name><field_name>TARGET_FID</field_name><field_name>POLYGON_ID</field_name><field_name>UNIT_ID</field_name><field_name>CODE</field_name><field_name>TYPE_CODE</field_name><field_name>DESCRIPT0</field_name><field_name>TYPE_COD0</field_name><field_name>DESCRIPT1</field_name></DeleteField></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/3.4.0'><WorkspaceConnectionString>DATABASE=\\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DCCAddresses_ExistingJoinCleaned</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>FILE_NAME</field_name><field_name>NUMBER</field_name><field_name>NUMBER0</field_name><field_name>HECTARES</field_name><field_name>AREA</field_name></DeleteField></workflow></operationSequence>
SpatialJoin DCCAddresses_ExistingJoinCleaned SDEADMIN.DCC_ProvisionalFutureDevonBoundaries \\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb\DCCAddresses_Existing_New_Join JOIN_ONE_TO_ONE KEEP_ALL "FormattedAddress "FormattedAddress" true true false 699 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,FormattedAddress,0,698;Uprn "Uprn" true true false 12 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Uprn,0,11;AddressBasePostal "AddressBasePostal" true true false 1 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,AddressBasePostal,0,0;AddressPostalDesc "AddressPostalDesc" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,AddressPostalDesc,0,34;State "State" true true false 4 Long 0 0,First,#,DCCAddresses_ExistingJoinCleaned,State,-1,-1;BuildingState "BuildingState" true true false 36 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,BuildingState,0,35;Class "Class" true true false 6 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Class,0,5;Class_Desc "Class_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Class_Desc,0,199;Primary_Desc "Primary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Primary_Desc,0,99;Secondary_Desc "Secondary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Secondary_Desc,0,199;Tertiary_Desc "Tertiary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Tertiary_Desc,0,199;Quaternary_Desc "Quaternary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Quaternary_Desc,0,99;ParentUPRN "ParentUPRN" true true false 12 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,ParentUPRN,0,11;WardCode "WardCode" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,WardCode,0,34;WardName "WardName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,WardName,0,99;ParishCode "ParishCode" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,ParishCode,0,34;ParishName "ParishName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,ParishName,0,99;BuildingName "BuildingName" true true false 50 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,BuildingName,0,49;OrganisationName "OrganisationName" true true false 100 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,OrganisationName,0,99;Thoroughfare "Thoroughfare" true true false 80 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Thoroughfare,0,79;Locality "Locality" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Locality,0,34;TownName "TownName" true true false 30 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,TownName,0,29;PostTown "PostTown" true true false 35 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,PostTown,0,34;PostCode "PostCode" true true false 8 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,PostCode,0,7;AdministrativeArea "AdministrativeArea" true true false 30 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,AdministrativeArea,0,29;Existing_Authority "Existing_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,Existing_Authority,0,254;New_Authority "New_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,New_Authority,0,254;NAME "NAME" true true false 60 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,NAME,0,59;AREA_CODE "AREA_CODE" true true false 3 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,AREA_CODE,0,2;DESCRIPTIO "DESCRIPTIO" true true false 50 Text 0 0,First,#,DCCAddresses_ExistingJoinCleaned,DESCRIPTIO,0,49;UAName "UAName" true true false 254 Text 0 0,First,#,SDEADMIN.DCC_ProvisionalFutureDevonBoundaries,UAName,0,253;Shape_STAr "Shape_STAr" true true false 8 Double 8 38,First,#,SDEADMIN.DCC_ProvisionalFutureDevonBoundaries,Shape_STAr,-1,-1;Shape_STLe "Shape_STLe" true true false 8 Double 8 38,First,#,SDEADMIN.DCC_ProvisionalFutureDevonBoundaries,Shape_STLe,-1,-1" WITHIN # # #
CalculateField DCCAddresses_Existing_New_Join UAName !UAName! PYTHON3 # TEXT NO_ENFORCE_DOMAINS
CalculateField DCCAddresses_Existing_New_Join New_Authority !UAName! PYTHON3 # TEXT NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><WorkspaceConnectionString>DATABASE=\\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DCCAddresses_Existing_New_Join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>NAME</field_name><field_name>AREA_CODE</field_name><field_name>DESCRIPTIO</field_name><field_name>UAName</field_name><field_name>Shape_STAr</field_name><field_name>Shape_STLe</field_name></DeleteField></workflow></operationSequence>
ExportFeatures DCCAddresses_Existing_New_Join \\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb\DCCAddresses_Existing_New_Join_Cleaned # NOT_USE_ALIAS "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,DCCAddresses_Existing_New_Join,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 8 BigInteger 0 0,First,#,DCCAddresses_Existing_New_Join,TARGET_FID,-1,-1;FormattedAddress "FormattedAddress" true true false 699 Text 0 0,First,#,DCCAddresses_Existing_New_Join,FormattedAddress,0,698;Uprn "Uprn" true true false 12 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Uprn,0,11;AddressBasePostal "AddressBasePostal" true true false 1 Text 0 0,First,#,DCCAddresses_Existing_New_Join,AddressBasePostal,0,0;AddressPostalDesc "AddressPostalDesc" true true false 35 Text 0 0,First,#,DCCAddresses_Existing_New_Join,AddressPostalDesc,0,34;State "State" true true false 4 Long 0 0,First,#,DCCAddresses_Existing_New_Join,State,-1,-1;BuildingState "BuildingState" true true false 36 Text 0 0,First,#,DCCAddresses_Existing_New_Join,BuildingState,0,35;Class "Class" true true false 6 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Class,0,5;Class_Desc "Class_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Class_Desc,0,199;Primary_Desc "Primary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Primary_Desc,0,99;Secondary_Desc "Secondary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Secondary_Desc,0,199;Tertiary_Desc "Tertiary_Desc" true true false 200 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Tertiary_Desc,0,199;Quaternary_Desc "Quaternary_Desc" true true false 100 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Quaternary_Desc,0,99;ParentUPRN "ParentUPRN" true true false 12 Text 0 0,First,#,DCCAddresses_Existing_New_Join,ParentUPRN,0,11;WardCode "WardCode" true true false 35 Text 0 0,First,#,DCCAddresses_Existing_New_Join,WardCode,0,34;WardName "WardName" true true false 100 Text 0 0,First,#,DCCAddresses_Existing_New_Join,WardName,0,99;ParishCode "ParishCode" true true false 35 Text 0 0,First,#,DCCAddresses_Existing_New_Join,ParishCode,0,34;ParishName "ParishName" true true false 100 Text 0 0,First,#,DCCAddresses_Existing_New_Join,ParishName,0,99;BuildingName "BuildingName" true true false 50 Text 0 0,First,#,DCCAddresses_Existing_New_Join,BuildingName,0,49;OrganisationName "OrganisationName" true true false 100 Text 0 0,First,#,DCCAddresses_Existing_New_Join,OrganisationName,0,99;Thoroughfare "Thoroughfare" true true false 80 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Thoroughfare,0,79;Locality "Locality" true true false 35 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Locality,0,34;TownName "TownName" true true false 30 Text 0 0,First,#,DCCAddresses_Existing_New_Join,TownName,0,29;PostTown "PostTown" true true false 35 Text 0 0,First,#,DCCAddresses_Existing_New_Join,PostTown,0,34;PostCode "PostCode" true true false 8 Text 0 0,First,#,DCCAddresses_Existing_New_Join,PostCode,0,7;AdministrativeArea "AdministrativeArea" true true false 30 Text 0 0,First,#,DCCAddresses_Existing_New_Join,AdministrativeArea,0,29;Existing_Authority "Existing_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_Existing_New_Join,Existing_Authority,0,254;New_Authority "New_Authority" true true false 255 Text 0 0,First,#,DCCAddresses_Existing_New_Join,New_Authority,0,254" #
DCCAddresses_Existing_New_Join_Cleaned
002
file://\\stratagis1\strata\LGR\LGR_Data_Loading\LGR_Data_Loading.gdb
Local Area Network
Projected
GCS_OSGB_1936
Linear Unit: Meter (1.000000)
British_National_Grid
<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/3.4.0'><WKT>PROJCS["British_National_Grid",GEOGCS["GCS_OSGB_1936",DATUM["D_OSGB_1936",SPHEROID["Airy_1830",6377563.396,299.3249646]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",-100000.0],PARAMETER["Central_Meridian",-2.0],PARAMETER["Scale_Factor",0.9996012717],PARAMETER["Latitude_Of_Origin",49.0],UNIT["Meter",1.0],AUTHORITY["EPSG",27700]]</WKT><XOrigin>-5220400</XOrigin><YOrigin>-15524400</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>27700</WKID><LatestWKID>27700</LatestWKID></ProjectedCoordinateSystem>
20260727
16074200
20260727
16074200
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 26200) ; Esri ArcGIS 13.4.5.55405
LGR_DevonAddresses_New_Cleaned
Layer of Devon Addresses showing their existing Authority as of 21/07/2026 and the new Authority as at 01/04/2028
File Geodatabase Feature Class
dataset
EPSG
6.3(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
DCCAddresses_Existing_New_Join_Cleaned
Feature Class
0
OBJECTID
OBJECTID
OID
8
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Join_Count
Join_Count
Integer
4
0
0
TARGET_FID
TARGET_FID
BigInteger
8
0
0
FormattedAddress
FormattedAddress
String
699
0
0
Uprn
Uprn
String
12
0
0
AddressBasePostal
AddressBasePostal
String
1
0
0
AddressPostalDesc
AddressPostalDesc
String
35
0
0
State
State
Integer
4
0
0
BuildingState
BuildingState
String
36
0
0
Class
Class
String
6
0
0
Class_Desc
Class_Desc
String
200
0
0
Primary_Desc
Primary_Desc
String
100
0
0
Secondary_Desc
Secondary_Desc
String
200
0
0
Tertiary_Desc
Tertiary_Desc
String
200
0
0
Quaternary_Desc
Quaternary_Desc
String
100
0
0
ParentUPRN
ParentUPRN
String
12
0
0
WardCode
WardCode
String
35
0
0
WardName
WardName
String
100
0
0
ParishCode
ParishCode
String
35
0
0
ParishName
ParishName
String
100
0
0
BuildingName
BuildingName
String
50
0
0
OrganisationName
OrganisationName
String
100
0
0
Thoroughfare
Thoroughfare
String
80
0
0
Locality
Locality
String
35
0
0
TownName
TownName
String
30
0
0
PostTown
PostTown
String
35
0
0
PostCode
PostCode
String
8
0
0
AdministrativeArea
AdministrativeArea
String
30
0
0
Existing_Authority
Existing_Authority
String
255
0
0
New_Authority
New_Authority
String
255
0
0
20260727
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAEXxJREFUeJzt3QlwlGWex/Ff+r6P3OmEnARCIgQRCGdAblCOxVVmxwPXnXGs
Ga9xHV2vUcFxPdlyR9xidJ1yxoNBHBV1cVlccUEuiYSoCSQEAuQiCU36SLqTvrb6zRCkht11a4Dk
H3+fqq6E7jepp4vUt9737ed9Xk0sFouBiEgAzUAPgIjou2KwiEgMBouIxGCwiEgMBouIxGCwiEgM
BouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouI
xGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCw
iEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgMBouIxGCwiEgM
BouIxGCwiEgMBouIxGCwhIlEIkhISIBKpRrooRBdcgyWIN3d3fjH1c9AZ9DinnvvhtlsHughEV1S
DJYgLS0t2LehGbFIAoaP2ISFCxfCYrFAo+F/I30/8C9dkIyMDBTPTMfebfvhr+nCccNxJVgRSwQa
swaWZAtSXCkDPUyii4bBEsRkMuHWn1+PlVddi5fWvY4dn36Dpx+9H0naJIQCIZxsOslg0ZDGYAmT
lZeF3dW7EQmqoIpoEY6EoUpQQafRIeKNKOe54mEjGooYLGGikShyU3Kx6uG7EA6HkZGcoTwfi8UQ
M8RgMBgGeohEFw2DJYzvtA8pxhSYtX/+CWGoM4Sdn+3EtCunDcjYiC42BkuQaDSKtmNtePfDD+Gw
2HDNvGXQarXKa/HDwvykfHT7upU9L35ySEMRgyVEqDeEyp2V6DnWiz1bjkOdoMHlxQ0YlpEJvVYP
tVoNrVoLa9SKzlOdcCQ5GC0achgsIXw+H1LCKXDmOzF/aasSsBiieOzpFzC2dAR+uOwaZTuXxYXK
fZUomVSCxKTEgR420QXFYAnhafTAZXNBo9bgB0uWKc+98cF6tB6KYl+4WglWKBJCTXcNpi6cykt3
aEhisIQIRoLoCfcowTrj2gXLkWjfhoLsPOXf3qAXmSMzGSsashgsISwmC/QRvfK9x+9BRXUFyseV
Y2H5vP5trAYrtuzYAstCC+x2+wCOlujiYLCE8Hf4kWZIw94DFXj8uRfg6eyC0/k75GXm4d47b0F2
xjDo1DpMSZ+Cuqo6jJ00Fhot/3tpaOFftBCuEheO7D+C5vZWBPwhGOGA+5QHDn03QuGQsk38669+
vQbH6ztxx3MrcOWcmQM9bKILisESwu60Q1OmQVAfxNOZ90CToIFOp8Oqf3oev375Nfzy3ruU81sB
fwQmtQ1BT1CZt8V1s2goYbAEiV8nGD0dhd1hR0FaAfzdfoS6EtDscyuTRRNtiXjygfvh9ftgsZtR
X12P4SXDlQX/iIYCBksQvV4PywiLcr3gkW+OoOV4K0IeI3JHJyE1MVXZxmF1KI+4+Kz3np4eXl9I
QwaDJYjNZlMerS2tiGqjyEjJQGqOHvl5WdhVtQvji8dDq+m7VCcuQc2llGloYbCEia/KED/Eaw+2
Y3jqcKxZ9Uv87p0NWLP6fVy94jhW/vWK/m3DXWFUbK2AyqRC2cyyAR030YXAYAlT/3U9wr4wnBYn
Pv18B7b/VxV01hDUtgBcaWnnbJtjy0G6KR1Nxqb+0BFJxmAJE1VFoQ6okW5Ix0s7X4fnqBlXXjMC
T/5ied/rsSi64ov4GY1Qq9Ro9jUjbVQaY0VDAoMlTEFRAfZ37Icj7MDdP7kFX1TtR/nEqf2vb/l8
K9547RPMmFuCH113E3w9PgzTDxvQMRNdKAyWMPFlZEomlmD7R9tRllmGZXOvPud1j8+DDrcbanXf
v0tSS1BbWav8DA8JSToGS6D4tIZESyKMGuOfvbZi4bWYOGY8stOz+w8RI50RHK09ivyR+QMwWqIL
h8ESKL6npEvT4cF/fhQ2jQ33/O0dMOrPxit+feEZOyp24o0PN2DpTQuQmZupzOUikorBEiQ+CbSt
sQ3d/m588ck+NB7ogS4SQO3MwygtGo3eUC/WvPISGo60YdGiKXhr/cdo7mhBtr4UTQfa4J3lRUoK
71tIcjFYgsSnJhytPIrL0i7D0glLMNw2Eu2n2jGqYKRy4fOer/egqroG4U4Tvqmrga8jivIpE1CQ
n43sMRnK+S8iyRgsYeeu0kamwdvqxTDnMEy7YlL/a6+9+ybeeX03Js0vwLI5V6MorwgH5xxErisX
EVUE0fwoEhO5ZDLJxmAJk5mTiaqmKrhiLqgTzu4x5Q3LgT1jN2ZMmI7i/GLluTNfe8O9cLvdwLnz
SonEYbCEsVgtGD56OFpqWpDlyOp/vnz8VOVxPlFE0RPquYSjJLo4GCyBLHYL2iPtyhrves35P/U7
dOwQnFansopDIByAM8N5ycdJdKExWAKZzCakXZ6Gr/Z8hZ1bvkBrRztW3f1g/w0q6k8cwYMPvYik
FAueevQX6DZ2I83C40GSj8ESKn7PwQMJB7BjexXQY0DjyUblBPuZeVpp6U7YHRZotFp4o15k6c4e
PhJJxWAJFQqFkJ+cj9tv+yGe+s0a6LS6/tfys/Kw9tnH++MVDXCpZBoaGCxhPJ0edLZ2otfdC3Ov
GXu/PADL6VFY/9E7uOumn+KDTzaj8UQH/mb5EiQ5+qYxGGNG9Pb0Qm/gLHeSjcESNMu9oaYBmg4N
MqwZ0Oq0UOlVuGXF9Rg5YhfmTp6F097TWPfqBiSr8jFxQn1/sKIJUSSouBYWycdgCdHS0IKsniwY
nAZEIhG8v2UzwuEIFs+Zh8UzFynbGPQGrHroTlTXHcLYorH9P+uEE36PH4kpnDhKsjFYQsTCMWVB
vlfefg2nvO344tPjQEyFcaUlKMgq6N9uwmXjlce36VV6+L0MFsnHYAkRC8SU6wa3flSF3lAI0+bl
I9meek6s/icJSEAsGrsk4yS6mBgsAdrb2hHyhuByurDy5kWIxiJYUD77/7yYuaG5ARajBSaLCWCv
aAhgsAb56gx1X9ch2hxFYXKh8tzCmbO/0896/B7c+fAjyvSHtc8+CZ3j7LQHIqkYrEEsfnI91BlC
vuP/v1Joe2c7Yj4zYgiiw9+BouSiizJGokuJwRrENBoNXCUu7N26FxNzJqLd3Y6va6sxY2I5DDr9
effIfF0+aLU65Gfmo2xWHiwmM4qyihD0B4HkAXkbRBcMgzXIOROdUKeo8YfN7+D9D7ZC58+AQWfC
jG/dKeeMQw21WPXEbzC8MBNlk4txqMKNSTOSoVKpeNKdhgQGaxCLRqPYsmULnnjoGTg7xiAYVkOT
WofiwrvPu33dsTqcaDkBX/gUqpu+hLdNj1A4N/4xIUxW0yUfP9GFxmANYocP1+PZn78KZ9cYHA8c
gFmTiMVTy+C0Os67/RXFV2DW7GokJdtx8qQbDb1tuHLyNGigQXNjMxwp5/85IikYrEHM5cpA7rhE
dNR2YN3tT6Gh6RiWzFqsnNuKn89a/eKzWDhrFhZOW9C3fWoGHrnrHmWPKn7Cvqe3BxazRZnS0O3u
Hui3Q/QXY7AGMYvFgseffBiRYxG4TK5zZrB/dbAGnbUWbPJtx5TSybBb7crz8ZgpX9Ua6P90Yj4Y
DsKaYh2gd0F04TBYg1xmdiZq/bXwuX2wm/qiFDehdBxO39CJEfkFsFls/+vvCEaCMCeaL8FoiS4u
BmuQi69nFT9h3tXaBYPGgMfWPAeNRo1/+NkduGbBku/0O3pjvTCZeNKd5GOwBrn43Kr4CfMcdQ78
AT+OHm5DJBpCIBiA2Xh2ryl+E9VXN/4e+TnZmDdlLnbu3409Byrw4+tWwqg2wnfaB3vi2T00IokY
LCHnstra2zDCOgLPPPH3ypyqZOfZWaDHWo5h7ZvrcHRvGJvVe5Djysbaf/091O50fF6wF7OnlqOx
qRFZBVwmmWRjsAQcEpaMKUHbyTY0VDagML3vmsIDtQegVWtRmFOI3/7hTdRs98OnPY4Fs6fDarbi
tpU3oPrQYUwYfbly/8Jwd1j55JB3fybJGCwhzGYzvCqv8v1nFZ/hxnt/jJHWaRg2RoNYRI2eaAgN
p2vw3qYQ9n1ZjRt/sBQrli6GTqNTomdWm+H3+WF38LCQ5GKwhOg81Yl0W7ryvSpBhWxXNsK+IFoO
a2FKDqM10Ax9zIEiywzUH6/AA088hbz0jcjPysUj990OTYJGWbmBSDIGSwiz1Yy2ujbkOHMwfdx0
7HhjK440HVFu72U2mPH4C8/iuquX4OX1r+NUjxe+kBvNJ1sQ6PUrl/jYjDa4O9xITuEV0CQXgyWE
0WREEMFznouvyBB/xG1atx4n3SfxxjvvosBWiM6eVnRrW5GKYvzkvvtRXFiEUWPzYLrBhMzczAF6
F0R/GQZLiPgtukx5JnQ0diDZcv69pMrqKgQ7DDjs/XfYdMkYaZyCb9zb4exyobk7AV8f3IzMkhQG
i8RisARJTk1GQ10DksxJeOvDDVi/6X3cefOtmDlpmnIpzsyycrT8XSt2fZmEo1VeNHbVwBc6hWRD
NipP/QdMVjW0bh3qaupQOKrv00YiSRgsYZ8U+hP8ONh8EAcbDsPqHYW3//gxJpReDrvFDr1Wj5v/
6kYsmXUVHn3+aVR9GcQwczG8aEa2rQjJtlTYDQ7EWmPwuXyw2nl9IcnCYAkSvxnqhDkTlJtSzPZN
h8N8AONHX6nEKoYYPD6PctOJRHsiHrjjLjzy2Fp4uzyYNX8uuoJd+OPGbfjVvxzG0tlLUKouhiPb
gbdffw9Guxbz5s6BWWuGM90Jo9k40G+V6LwYLGHiq4c2Njais/s07lh5mzJ5NG5P1V68vXErLHYt
7vvpz+BKceGRB29FOBJWZr7/5+5t2GaoRX3NEWxqr0BXyIv3PtmMpsNumDQ26E8ZsKh8PqqbqlE6
pbR/1QeiwYR/lcLEJ4EWFxdj1yf7UHPkEC4rKMbnlTuxevUrsKnToE8JINDTd51hPFTRWFSJ3Pxp
c5GemoqPd2xBU2sbduysQKp7AgyWDnhiLUhMtcOT5MHIgpGMFQ1aDJZA727chG0vN+Do6FYsnu/F
2lfehD/sxpTpxbj+muXKIWFrZyu8Gi96E3ph6jIhLyUPaelpWPGja9Eb6cW6Nb/FtsP/hsxhmZg+
tQSTl01WXo/HjWiwYrAEWrL8Kuza/gXy8obhrY82ItCuw1VXTcVDt92n7FE1BBpgKjJhVOYo5frB
hvoGNDY3osvehZLLS5RLdJbfcDUWLJ6FUVNGIScnZ6DfEtF3wmAJZLVa8eIrz8Pn8+GBr1ZBo4oi
Qa1CIBTAid4TyCzNhM3et6hf/GLn3PxctNvakeHMUJ6zWC0oX1SuzICPH2ISScFgCeY57cGU6eOw
4cT7GD1vOioDlSibVgattu9E/BlqjRrp6X3XIX4bD/9IGgZLMIfTgSvKxmHspFJorBqMGDFioIdE
dFExWILFD+0KxxVyT4m+Nxgs4XhYR98nDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFg
EZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEY
DBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYR
icFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFg
EZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEY
DBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYR
icFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgEZEYDBYRicFgERGk+G/I3hHE4ze4pwAAAABJ
RU5ErkJggg==