20181010
18121200
1.0
FALSE
CalculateField snoco_addresses Inc_Muni "LYNNWOOD" VB #
CalculateField snoco_addresses Resident "Resident" VB #
CalculateField snoco_addresses Resident "Non-Resident" VB #
AssignDomainToField "DB02 need to update from LAS29" Status AddressStatus #
AssignDomainToField "DB02 need to update from LAS29" Status AddressStatus #
DeleteRows "L:\GIS_shared_data\development\database_connections\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address"
Append export_snoco_addresses "C:\Users\mtenoldsvr\Desktop\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address" "Use the Field Map to reconcile schema differences" "Source "Source" true false false 75 Text 0 0,First,#;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,export_snoco_addresses,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,export_snoco_addresses,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,export_snoco_addresses,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,export_snoco_addresses,Site_NGUID,0,100;Country "Country" true false false 2 Text 0 0,First,#,export_snoco_addresses,Country,0,2;State "State" true false false 2 Text 0 0,First,#,export_snoco_addresses,State,0,2;County "County" true false false 40 Text 0 0,First,#,export_snoco_addresses,County,0,40;AddCode "AddCode" true false false 6 Text 0 0,First,#,export_snoco_addresses,AddCode,0,6;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,export_snoco_addresses,AddDataURI,0,254;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,export_snoco_addresses,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,export_snoco_addresses,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,export_snoco_addresses,Nbrhd_Comm,0,100;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,export_snoco_addresses,AddNum_Pre,0,15;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,export_snoco_addresses,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,export_snoco_addresses,AddNum_Suf,0,15;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,export_snoco_addresses,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,export_snoco_addresses,LSt_Name,0,75;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,export_snoco_addresses,LSt_Type,0,5;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,export_snoco_addresses,LSt_PostDi,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,export_snoco_addresses,ESN,0,5;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,export_snoco_addresses,MSAGComm,0,30;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PreMod,0,15;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,export_snoco_addresses,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,export_snoco_addresses,St_PreTyp,0,25;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,export_snoco_addresses,St_PreSep,0,20;StreetName "StreetName" true false false 60 Text 0 0,First,#,export_snoco_addresses,St_Name,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PosTyp,0,15;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,export_snoco_addresses,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PosMod,0,15;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,export_snoco_addresses,Post_Comm,0,40;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,export_snoco_addresses,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,export_snoco_addresses,Post_Code4,0,4;Building "Building" true false false 75 Text 0 0,First,#,export_snoco_addresses,Building,0,75;Floor "Floor" true false false 75 Text 0 0,First,#,export_snoco_addresses,Floor,0,75;Unit "Unit" true false false 75 Text 0 0,First,#,export_snoco_addresses,Unit,0,75;Room "Room" true false false 75 Text 0 0,First,#,export_snoco_addresses,Room,0,75;Seat "Seat" true false false 75 Text 0 0,First,#,export_snoco_addresses,Seat,0,75;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,export_snoco_addresses,Addtl_Loc,0,225;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,export_snoco_addresses,Place_Type,0,50;Placement "Placement" true false false 25 Text 0 0,First,#,export_snoco_addresses,Placement,0,25;Long "Long" true false false 8 Double 8 38,First,#,export_snoco_addresses,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,export_snoco_addresses,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,export_snoco_addresses,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,export_snoco_addresses,RCL_NGUID,0,100;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,export_snoco_addresses,FULL_ADDR,0,150;PSAP "PSAP" true false false 25 Text 0 0,First,#,export_snoco_addresses,PSAP,0,25;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,export_snoco_addresses,TOW_ZONE,0,25;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,export_snoco_addresses,SWCTYFRGRD,0,25;USECODE "USECODE" true false false 60 Text 0 0,First,#,export_snoco_addresses,USECODE,0,60;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,export_snoco_addresses,CATEGORY,0,10;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,export_snoco_addresses,COMMENTS,0,120;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,export_snoco_addresses,CNTYFRGRD,0,25;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,export_snoco_addresses,LFULL_ADD,0,150;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,export_snoco_addresses,GC_Excepti,0,100;Status "Status" true false false 30 Text 0 0,First,#;Resident "Resident" true true false 20 Text 0 0,First,#" # #
DeleteRows "C:\Users\mtenoldsvr\Desktop\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address"
Append export_snoco_addresses "C:\Users\mtenoldsvr\Desktop\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address" "Use the Field Map to reconcile schema differences" "Source "Source" true false false 75 Text 0 0,First,#;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,export_snoco_addresses,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,export_snoco_addresses,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,export_snoco_addresses,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,export_snoco_addresses,Site_NGUID,0,100;Country "Country" true false false 2 Text 0 0,First,#,export_snoco_addresses,Country,0,2;State "State" true false false 2 Text 0 0,First,#,export_snoco_addresses,State,0,2;County "County" true false false 40 Text 0 0,First,#,export_snoco_addresses,County,0,40;AddCode "AddCode" true false false 6 Text 0 0,First,#,export_snoco_addresses,AddCode,0,6;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,export_snoco_addresses,AddDataURI,0,254;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,export_snoco_addresses,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,export_snoco_addresses,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,export_snoco_addresses,Nbrhd_Comm,0,100;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,export_snoco_addresses,AddNum_Pre,0,15;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,export_snoco_addresses,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,export_snoco_addresses,AddNum_Suf,0,15;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,export_snoco_addresses,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,export_snoco_addresses,LSt_Name,0,75;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,export_snoco_addresses,LSt_Type,0,5;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,export_snoco_addresses,LSt_PostDi,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,export_snoco_addresses,ESN,0,5;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,export_snoco_addresses,MSAGComm,0,30;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PreMod,0,15;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,export_snoco_addresses,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,export_snoco_addresses,St_PreTyp,0,25;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,export_snoco_addresses,St_PreSep,0,20;StreetName "StreetName" true false false 60 Text 0 0,First,#,export_snoco_addresses,St_Name,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PosTyp,0,15;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,export_snoco_addresses,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,export_snoco_addresses,St_PosMod,0,15;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,export_snoco_addresses,Post_Comm,0,40;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,export_snoco_addresses,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,export_snoco_addresses,Post_Code4,0,4;Building "Building" true false false 75 Text 0 0,First,#,export_snoco_addresses,Building,0,75;Floor "Floor" true false false 75 Text 0 0,First,#,export_snoco_addresses,Floor,0,75;Unit "Unit" true false false 75 Text 0 0,First,#,export_snoco_addresses,Unit,0,75;Room "Room" true false false 75 Text 0 0,First,#,export_snoco_addresses,Room,0,75;Seat "Seat" true false false 75 Text 0 0,First,#,export_snoco_addresses,Seat,0,75;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,export_snoco_addresses,Addtl_Loc,0,225;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,export_snoco_addresses,Place_Type,0,50;Placement "Placement" true false false 25 Text 0 0,First,#,export_snoco_addresses,Placement,0,25;Long "Long" true false false 8 Double 8 38,First,#,export_snoco_addresses,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,export_snoco_addresses,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,export_snoco_addresses,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,export_snoco_addresses,RCL_NGUID,0,100;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,export_snoco_addresses,FULL_ADDR,0,150;PSAP "PSAP" true false false 25 Text 0 0,First,#,export_snoco_addresses,PSAP,0,25;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,export_snoco_addresses,TOW_ZONE,0,25;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,export_snoco_addresses,SWCTYFRGRD,0,25;USECODE "USECODE" true false false 60 Text 0 0,First,#,export_snoco_addresses,USECODE,0,60;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,export_snoco_addresses,CATEGORY,0,10;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,export_snoco_addresses,COMMENTS,0,120;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,export_snoco_addresses,CNTYFRGRD,0,25;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,export_snoco_addresses,LFULL_ADD,0,150;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,export_snoco_addresses,GC_Excepti,0,100;Status "Status" true false false 30 Text 0 0,First,#;Resident "Resident" true true false 20 Text 0 0,First,#" # #
CalculateField lynnwood_SDE.SDE.snoco_address Status 'Current' "Python 3" # Text
CalculateField lynnwood_SDE.SDE.snoco_address Status 'Current' "Python 3" # Text
CalculateField lynnwood_SDE.SDE.snoco_address Status "Current" "Python 3" # Text
RemoveSpatialIndex "C:\Users\mtenoldsvr\Desktop\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address"
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>lynnwood_sde.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685175474934456d492f6b51676a4f713071386831315373694a355764524335514638364c2b5043716d46303d2a00;SERVER=col-db14;INSTANCE=sde:sqlserver:col-db14;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=col-db14;DATABASE=lynnwood_SDE;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>lynnwood_SDE.SDE.snoco_address</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></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>lynnwood_sde.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e685175474934456d492f6b51676a4f713071386831315373694a355764524335514638364c2b5043716d46303d2a00;SERVER=col-db14;INSTANCE=sde:sqlserver:col-db14;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=col-db14;DATABASE=lynnwood_SDE;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>lynnwood_SDE.SDE.snoco_address</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
CopyFeatures "C:\Users\mtenoldws\Desktop\sde connection col-db14.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address" "\\col\coldata\gisserverdir\userdata\working\mtenold\arcgis pro\Fair on 44th\sde_connection_to_COL_DB19.sde\SDE.Address\SDE.snoco_address" # # # #
DeleteRows snoco_address_Layer
Append Building_Address_Points_Laye snoco_address_Layer "Use the field map to reconcile field differences" "Source "Source" true false false 75 Text 0 0,First,#;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Site_NGUID,0,48;Country "Country" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Country,0,2;State "State" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,State,0,2;County "County" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,County,0,9;AddCode "AddCode" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddCode,0,1;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddDataURI,0,1;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Inc_Muni,0,17;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Uninc_Comm,0,18;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Nbrhd_Comm,0,14;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Pre,0,1;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Suf,0,3;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Name,0,23;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Type,0,4;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,Building_Address_Points_Laye,LSt_PostDi,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,ESN,0,3;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,MSAGComm,0,17;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreMod,0,3;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreTyp,0,11;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreSep,0,1;StreetName "StreetName" true false false 60 Text 0 0,First,#,Building_Address_Points_Laye,St_Name,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosTyp,0,9;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosMod,0,1;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Comm,0,17;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code4,0,1;Building "Building" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Building,0,12;Floor "Floor" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Floor,0,10;Unit "Unit" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Unit,0,41;Room "Room" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Room,0,31;Seat "Seat" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Seat,0,1;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Addtl_Loc,0,1;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Place_Type,0,18;Placement "Placement" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Placement,0,9;Long "Long" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,RCL_NGUID,0,29;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,FULL_ADDR,0,60;PSAP "PSAP" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,PSAP,0,21;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,TOW_ZONE,0,11;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,SWCTYFRGRD,0,12;USECODE "USECODE" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,USECODE,0,50;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CATEGORY,0,3;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,COMMENTS,0,108;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CNTYFRGRD,0,5;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LFULL_ADD,0,52;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,GC_Excepti,0,8;Status "Status" true false false 30 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;Resident "Resident" true true false 20 Text 0 0,First,#" # #
CalculateField snoco_address_Layer Status 'Current' "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteRows DB19_snoco_address
Append '\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address' "\\col\coldata\gisserverdir\userdata\Database Connections\COL_DB19.sde\SDE.Address\SDE.snoco_address" "Use the field map to reconcile field differences" "Source "Source" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Source,0,75;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Site_NGUID,0,100;Country "Country" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Country,0,2;State "State" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,State,0,2;County "County" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,County,0,40;AddCode "AddCode" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddCode,0,6;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddDataURI,0,254;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Nbrhd_Comm,0,100;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddNum_Pre,0,15;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddNum_Suf,0,15;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_Name,0,75;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_Type,0,5;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LStPostDir,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,ESN,0,5;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,MSAGComm,0,30;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreMod,0,15;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreTyp,0,25;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreSep,0,20;StreetName "StreetName" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,StreetName,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosTyp,0,15;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosMod,0,15;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Comm,0,40;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Code4,0,4;Building "Building" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Building,0,75;Floor "Floor" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Floor,0,75;Unit "Unit" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Unit,0,75;Room "Room" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Room,0,75;Seat "Seat" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Seat,0,75;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Addtl_Loc,0,225;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Place_Type,0,50;Placement "Placement" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Placement,0,25;Long "Long" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,RCL_NGUID,0,100;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,FULL_ADDR,0,150;PSAP "PSAP" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,PSAP,0,25;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,TOW_ZONE,0,25;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,SWCTYFRGRD,0,25;USECODE "USECODE" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,USECODE,0,60;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,CATEGORY,0,10;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,COMMENTS,0,120;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,CNTYFRGRD,0,25;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LFULL_ADD,0,150;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,GC_Excepti,0,100;Status "Status" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Status,0,30;created_user "created_user" true true false 255 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,last_edited_date,-1,-1;Resident "Resident" true true false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Resident,0,20" # #
DeleteRows snoco_address_Layer
Append Building_Address_Points_Laye1 snoco_address_Layer "Use the field map to reconcile field differences" "Source "Source" true false false 75 Text 0 0,First,#;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Site_NGUID,0,48;Country "Country" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Country,0,2;State "State" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,State,0,2;County "County" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,County,0,9;AddCode "AddCode" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddCode,0,1;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddDataURI,0,1;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Inc_Muni,0,17;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Uninc_Comm,0,18;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Nbrhd_Comm,0,14;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Pre,0,1;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Suf,0,3;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Name,0,23;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Type,0,4;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,Building_Address_Points_Laye,LSt_PostDi,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,ESN,0,3;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,MSAGComm,0,17;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreMod,0,3;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreTyp,0,11;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreSep,0,1;StreetName "StreetName" true false false 60 Text 0 0,First,#,Building_Address_Points_Laye,St_Name,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosTyp,0,9;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosMod,0,1;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Comm,0,17;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code4,0,1;Building "Building" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Building,0,12;Floor "Floor" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Floor,0,10;Unit "Unit" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Unit,0,41;Room "Room" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Room,0,31;Seat "Seat" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Seat,0,1;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Addtl_Loc,0,1;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Place_Type,0,18;Placement "Placement" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Placement,0,9;Long "Long" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,RCL_NGUID,0,29;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,FULL_ADDR,0,60;PSAP "PSAP" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,PSAP,0,21;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,TOW_ZONE,0,11;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,SWCTYFRGRD,0,12;USECODE "USECODE" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,USECODE,0,50;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CATEGORY,0,3;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,COMMENTS,0,108;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CNTYFRGRD,0,5;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LFULL_ADD,0,52;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,GC_Excepti,0,8;Status "Status" true false false 30 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;Resident "Resident" true true false 20 Text 0 0,First,#" # #
CalculateField snoco_address_Layer1 Status 'Current' "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteRows DB19_snoco_address
Append '\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address' "\\col\coldata\gisserverdir\userdata\Database Connections\COL_DB19.sde\SDE.Address\SDE.snoco_address" "Use the field map to reconcile field differences" "Source "Source" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Source,0,75;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Site_NGUID,0,100;Country "Country" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Country,0,2;State "State" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,State,0,2;County "County" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,County,0,40;AddCode "AddCode" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddCode,0,6;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddDataURI,0,254;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Inc_Muni,0,100;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Uninc_Comm,0,100;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Nbrhd_Comm,0,100;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddNum_Pre,0,15;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,AddNum_Suf,0,15;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_Name,0,75;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LSt_Type,0,5;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LStPostDir,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,ESN,0,5;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,MSAGComm,0,30;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreMod,0,15;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreTyp,0,25;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PreSep,0,20;StreetName "StreetName" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,StreetName,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosTyp,0,15;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,St_PosMod,0,15;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Comm,0,40;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Post_Code4,0,4;Building "Building" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Building,0,75;Floor "Floor" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Floor,0,75;Unit "Unit" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Unit,0,75;Room "Room" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Room,0,75;Seat "Seat" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Seat,0,75;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Addtl_Loc,0,225;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Place_Type,0,50;Placement "Placement" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Placement,0,25;Long "Long" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,RCL_NGUID,0,100;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,FULL_ADDR,0,150;PSAP "PSAP" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,PSAP,0,25;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,TOW_ZONE,0,25;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,SWCTYFRGRD,0,25;USECODE "USECODE" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,USECODE,0,60;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,CATEGORY,0,10;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,COMMENTS,0,120;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,CNTYFRGRD,0,25;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,LFULL_ADD,0,150;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,GC_Excepti,0,100;Status "Status" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Status,0,30;created_user "created_user" true true false 255 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,last_edited_date,-1,-1;Resident "Resident" true true false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\Database Connections\GIS_DB.sde\lynnwood_sde.SDE.Address\lynnwood_SDE.SDE.snoco_address,Resident,0,20" # #
DeleteRows snoco_address_Layer
Append Building_Address_Points_Laye snoco_address_Layer "Use the field map to reconcile field differences" "Source "Source" true false false 75 Text 0 0,First,#;DateUpdate "DateUpdate" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,DateUpdate,-1,-1;Effective "Effective" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Effective,-1,-1;Expire "Expire" true true false 8 Date 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Expire,-1,-1;Site_NGUID "Site_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Site_NGUID,0,48;Country "Country" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Country,0,2;State "State" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,State,0,2;County "County" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,County,0,9;AddCode "AddCode" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddCode,0,1;AddDataURI "AddDataURI" true false false 254 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddDataURI,0,1;Inc_Muni "Inc_Muni" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Inc_Muni,0,17;Uninc_Comm "Uninc_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Uninc_Comm,0,18;Nbrhd_Comm "Nbrhd_Comm" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Nbrhd_Comm,0,14;AddNum_Pre "AddNum_Pre" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Pre,0,1;Add_Number "Add_Number" true false false 6 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Add_Number,0,6;AddNum_Suf "AddNum_Suf" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,AddNum_Suf,0,3;LSt_PreDir "LSt_PreDir" true false false 2 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_PreDir,0,2;LSt_Name "LSt_Name" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Name,0,23;LSt_Type "LSt_Type" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LSt_Type,0,4;LStPostDir "LStPostDir" true false false 2 Text 0 0,First,#,Building_Address_Points_Laye,LSt_PostDi,0,2;ESN "ESN" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,ESN,0,3;MSAGComm "MSAGComm" true false false 30 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,MSAGComm,0,17;St_PreMod "St_PreMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreMod,0,3;St_PreDir "St_PreDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreDir,0,9;St_PreTyp "St_PreTyp" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreTyp,0,11;St_PreSep "St_PreSep" true false false 20 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PreSep,0,1;StreetName "StreetName" true false false 60 Text 0 0,First,#,Building_Address_Points_Laye,St_Name,0,60;St_PosTyp "St_PosTyp" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosTyp,0,9;St_PosDir "St_PosDir" true false false 9 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosDir,0,9;St_PosMod "St_PosMod" true false false 15 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,St_PosMod,0,1;Post_Comm "Post_Comm" true false false 40 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Comm,0,17;Post_Code "Post_Code" true false false 5 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code,0,5;Post_Code4 "Post_Code4" true false false 4 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Post_Code4,0,1;Building "Building" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Building,0,12;Floor "Floor" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Floor,0,10;Unit "Unit" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Unit,0,41;Room "Room" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Room,0,31;Seat "Seat" true false false 75 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Seat,0,1;Addtl_Loc "Addtl_Loc" true false false 225 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Addtl_Loc,0,1;Place_Type "Place_Type" true false false 50 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Place_Type,0,18;Placement "Placement" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Placement,0,9;Long "Long" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Long,-1,-1;Lat "Lat" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Lat,-1,-1;Elev "Elev" true false false 8 Double 8 38,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,Elev,-1,-1;RCL_NGUID "RCL_NGUID" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,RCL_NGUID,0,29;FULL_ADDR "FULL_ADDR" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,FULL_ADDR,0,60;PSAP "PSAP" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,PSAP,0,21;TOW_ZONE "TOW_ZONE" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,TOW_ZONE,0,11;SWCTYFRGRD "SWCTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,SWCTYFRGRD,0,12;USECODE "USECODE" true false false 60 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,USECODE,0,50;CATEGORY "CATEGORY" true false false 10 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CATEGORY,0,3;COMMENTS "COMMENTS" true false false 120 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,COMMENTS,0,108;CNTYFRGRD "CNTYFRGRD" true false false 25 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,CNTYFRGRD,0,5;LFULL_ADD "LFULL_ADD" true false false 150 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,LFULL_ADD,0,52;GC_Excepti "GC_Excepti" true false false 100 Text 0 0,First,#,\\col\coldata\gisserverdir\userdata\data\shapefiles\Building_Address_Points.shp,GC_Excepti,0,8;Status "Status" true false false 30 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;Resident "Resident" true true false 20 Text 0 0,First,#" # #
CalculateField snoco_address_Layer1 Status 'Current' "Python 3" # Text NO_ENFORCE_DOMAINS
SDE.snoco_address
002
Server=COL-DB19; Service=sde:sqlserver:COL-DB19; Database=lynnwood_SDE; User=sde; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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.0.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20230322
16090300
20230322
16090300
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.0.3.36057
addresses
Snohomish County Addresses
Cartegraph
Addresses
Basemap
Snohomish County Addresses
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
SDE.snoco_address
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Source
Source
String
75
0
0
DateUpdate
DateUpdate
Date
8
0
0
Effective
Effective
Date
8
0
0
Expire
Expire
Date
8
0
0
Site_NGUID
Site_NGUID
String
100
0
0
Country
Country
String
2
0
0
State
State
String
2
0
0
County
County
String
40
0
0
AddCode
AddCode
String
6
0
0
AddDataURI
AddDataURI
String
254
0
0
Inc_Muni
Inc_Muni
String
100
0
0
Uninc_Comm
Uninc_Comm
String
100
0
0
Nbrhd_Comm
Nbrhd_Comm
String
100
0
0
AddNum_Pre
AddNum_Pre
String
15
0
0
Add_Number
Add_Number
String
6
0
0
AddNum_Suf
AddNum_Suf
String
15
0
0
LSt_PreDir
LSt_PreDir
String
2
0
0
LSt_Name
LSt_Name
String
75
0
0
LSt_Type
LSt_Type
String
5
0
0
LStPostDir
LStPostDir
String
2
0
0
ESN
ESN
String
5
0
0
MSAGComm
MSAGComm
String
30
0
0
St_PreMod
St_PreMod
String
15
0
0
St_PreDir
St_PreDir
String
9
0
0
St_PreTyp
St_PreTyp
String
25
0
0
St_PreSep
St_PreSep
String
20
0
0
StreetName
StreetName
String
60
0
0
St_PosTyp
St_PosTyp
String
15
0
0
St_PosDir
St_PosDir
String
9
0
0
St_PosMod
St_PosMod
String
15
0
0
Post_Comm
Post_Comm
String
40
0
0
Post_Code
Post_Code
String
5
0
0
Post_Code4
Post_Code4
String
4
0
0
Building
Building
String
75
0
0
Floor
Floor
String
75
0
0
Unit
Unit
String
75
0
0
Room
Room
String
75
0
0
Seat
Seat
String
75
0
0
Addtl_Loc
Addtl_Loc
String
225
0
0
Place_Type
Place_Type
String
50
0
0
Placement
Placement
String
25
0
0
Long
Long
Double
8
38
8
Lat
Lat
Double
8
38
8
Elev
Elev
Double
8
38
8
RCL_NGUID
RCL_NGUID
String
100
0
0
FULL_ADDR
FULL_ADDR
String
150
0
0
PSAP
PSAP
String
25
0
0
TOW_ZONE
TOW_ZONE
String
25
0
0
SWCTYFRGRD
SWCTYFRGRD
String
25
0
0
USECODE
USECODE
String
60
0
0
CATEGORY
CATEGORY
String
10
0
0
COMMENTS
COMMENTS
String
120
0
0
CNTYFRGRD
CNTYFRGRD
String
25
0
0
LFULL_ADD
LFULL_ADD
String
150
0
0
GC_Excepti
GC_Excepti
String
100
0
0
Status
Status
String
30
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
Resident
Resident
String
20
0
0
SHAPE
SHAPE
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20230322
/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
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigD//2Q==