20170920
14174700
1.0
FALSE
EnableAttachments Parcels
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet2 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet3 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet4 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet5 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet6 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet7 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet8 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet9 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet10 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet11 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet12 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_Sheet13 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet14 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet15 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_Sheet16 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_Sheet16 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet17 #
AddAttachments Parcels OBJECTID Parcels OBJECTID Plat_sheet18 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C1 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C1 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C2 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C3 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C4 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C5 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C6 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C7 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C8 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C9 #
AddAttachments Parcels OBJECTID Parcels OBJECTID C10 #
DeleteField "Database Connections\ARCGIS_SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels" OBJECTID_1;INDEX_ID_1;Plat;Plat_sheet2;Plat_sheet3;Plat_sheet4;Plat_sheet5;Plat_sheet6;Plat_sheet7;Plat_sheet8;Plat_sheet9;Plat_sheet10;Plat_sheet11;Plat_sheet12;Plat_Sheet13;Plat_sheet14;Plat_sheet15;Plat_Sheet16;Plat_sheet17;Plat_sheet18;C1;C2;C3;C4;C5;C6;C7;C8;C9;C10
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 )
" VB #
AddRelate Parcels INDEX_ID SalemGIS.DBO.RealEstateTable tax_map_number Relate1 "One to many"
RemoveRelate Parcels Relate1
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 )
" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 )
" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels StrVw_X [LONG] VB #
CalculateField SalemGIS.DBO.Parcels StrVw_Y [LAT] VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CopyFeatures "Database Connections\ARCGIS_SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels" C:\Backup.gdb\Parcels # 0 0 0
FeatureClassToFeatureClass "Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels" "Database Connections\ARCGIS_SalemGIS.sde\SalemGIS.DBO.Parcels" Parcels # "INDEX_ID "INDEX_ID" true true false 24 Text 0 0 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,INDEX_ID,-1,-1;X_Coord "X_Coord" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Y_Coord,-1,-1;GPIN "GPIN" true true false 15 Text 0 0 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,GPIN,-1,-1;LAT "LAT" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LAT,-1,-1;LONG "LONG" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LONG,-1,-1;StrVw_X "StrVw_X" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,StrVw_X,-1,-1;StrVw_Y "StrVw_Y" true true false 8 Double 8 38 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,StrVw_Y,-1,-1;Shape_STArea() "Shape_STArea()" false false true 0 Double 0 0 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Shape.STArea(),-1,-1;Shape_STLength() "Shape_STLength()" false false true 0 Double 0 0 ,First,#,Database Connections\CGRANT ARCGISPUB SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Shape.STLength(),-1,-1" #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID ShanksParcelsPaths_ExcelToTable INDEX_ID Path #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID PalmerAddition INDEX_ID PATH #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID GlenmorePlatParcels INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID KaseyPlatAttachments INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID CareyParcels INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID VictoriaLandParcelsFinal INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID C:\Users\jsimpson\Documents\ArcGIS\Projects\PlatEdits\PlatEdits.gdb\SteeltonParcels INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID DixieParcelTable INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID CrestonParcels INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID BOSecond INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID BOLeeStreet INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID SalemImproveDDCC INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # # "Same as input"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID StoutamireParcels INDEX_ID PATH "C:\Users\jsimpson\Desktop\plat attachments"
AddAttachments SalemGIS.DBO.Parcels INDEX_ID CIPRESTONPARCELS INDEX_ID PATH #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID NMarketParcels INDEX_ID PATH #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID C:\Users\jsimpson\Documents\ArcGIS\Projects\PlatEdits\PlatEdits.gdb\HangingRockOrchardsParcels INDEX_ID PATH #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG INSIDE_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
FeatureClassToFeatureClass C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb ParcelPlats21 # "INDEX_ID "INDEX_ID" true true false 24 Text 0 0,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,INDEX_ID,0,24;X_Coord "X_Coord" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Y_Coord,-1,-1;GPIN "GPIN" true true false 15 Text 0 0,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,GPIN,0,15;LAT "LAT" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LAT,-1,-1;LONG "LONG" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LONG,-1,-1;StrVw_X "StrVw_X" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,StrVw_X,-1,-1;StrVw_Y "StrVw_Y" true true false 8 Double 8 38,First,#,C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,StrVw_Y,-1,-1" #
AddAttachments ParcelPlats21 INDEX_ID C:\Users\jsimpson\Desktop\Burwell.xls\Burwell$ INDEX_ID PATH C:\Users\jsimpson\Desktop\ATT
AddAttachments ParcelPlats21 INDEX_ID C:\Users\jsimpson\Desktop\Burwell.xls\Burwell$ INDEX_ID PATH C:\Users\jsimpson\Desktop\ATT
AddAttachments ParcelPlats21 INDEX_ID ShanksTableConvertFinal INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID ShanksTableConvertFinal INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID Dennis_Shanks_Palmer$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID SALEM_IMPROVEMENT$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID PRESTONMccLELLANDADDITION_geo_t$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID Victoria_Lands_Excel_TableToExc$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID VictoriaNewPlat_Excel$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID SalemDevelopment_Excel$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID C:\Users\jsimpson\Desktop\ATT\ExcelTables\BandO_Excel.xls\BandO_Excel$ INDEX_ID PATH #
AddAttachments ParcelPlats21 INDEX_ID C:\Users\jsimpson\Desktop\ATT\ExcelTables\RobertM_Excel.xls\RobertM_Excel$ INDEX_ID PATH #
FeatureClassToFeatureClass C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21 N:\shareall\cgrant\Parcel_Reattach.gdb ParcelPlats21 # "INDEX_ID "INDEX_ID" true true false 24 Text 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,INDEX_ID,0,24;X_Coord "X_Coord" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,Y_Coord,-1,-1;GPIN "GPIN" true true false 15 Text 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,GPIN,0,15;LAT "LAT" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,LAT,-1,-1;LONG "LONG" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,LONG,-1,-1;StrVw_X "StrVw_X" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,StrVw_X,-1,-1;StrVw_Y "StrVw_Y" true true false 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,StrVw_Y,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,C:\Users\jsimpson\Desktop\JMSParcelATTACHMENTS\PlatsTEst.gdb\ParcelPlats21,Shape_Area,-1,-1" #
AddAttachments SalemGIS.DBO.Parcels INDEX_ID Table2_TableToExcel$ INDEX_ID PATH #
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord INSIDE_X;Y_Coord INSIDE_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateField SalemGIS.DBO.Parcels GPIN "str(!X_Coord!)[2] + str(!Y_Coord!)[1] + str(!X_Coord!)[3] + str(!Y_Coord!)[2] + '-' + str(!X_Coord!)[4] + str(!Y_Coord!)[3] + '-' + str(!X_Coord!)[5] + str(!Y_Coord!)[4] + str(!X_Coord!)[6] + str(!Y_Coord!)[5] + str(!X_Coord!)[7] + str(!Y_Coord!)[6]" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateField SalemGIS.DBO.Parcels GPIN "str(!X_Coord!)[2] + str(!Y_Coord!)[1] + str(!X_Coord!)[3] + str(!Y_Coord!)[2] + '-' + str(!X_Coord!)[4] + str(!Y_Coord!)[3] + '-' + str(!X_Coord!)[5] + str(!Y_Coord!)[4] + str(!X_Coord!)[6] + str(!Y_Coord!)[5] + str(!X_Coord!)[7] + str(!Y_Coord!)[6]" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateField SalemGIS.DBO.Parcels GPIN "str(!X_Coord!)[2] + str(!Y_Coord!)[1] + str(!X_Coord!)[3] + str(!Y_Coord!)[2] + '-' + str(!X_Coord!)[4] + str(!Y_Coord!)[3] + '-' + str(!X_Coord!)[5] + str(!Y_Coord!)[4] + str(!X_Coord!)[6] + str(!Y_Coord!)[5] + str(!X_Coord!)[7] + str(!Y_Coord!)[6]" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateField SalemGIS.DBO.Parcels GPIN "str(!X_Coord!)[2] + str(!Y_Coord!)[1] + str(!X_Coord!)[3] + str(!Y_Coord!)[2] + '-' + str(!X_Coord!)[4] + str(!Y_Coord!)[3] + '-' + str(!X_Coord!)[5] + str(!Y_Coord!)[4] + str(!X_Coord!)[6] + str(!Y_Coord!)[5] + str(!X_Coord!)[7] + str(!Y_Coord!)[6]" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
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>SalemGIS.DBO.Parcels</FeatureDataset><WorkspaceConnectionString>SERVER=GISSQL;INSTANCE=sde:sqlserver:GISSQL\ARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISSQL\ARCGIS;DATABASE=SalemGIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SalemGIS.DBO.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>DATEVISITED</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>DATE VISITED:</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><FeatureDataset>SalemGIS.DBO.Parcels</FeatureDataset><WorkspaceConnectionString>SERVER=GISSQL;INSTANCE=sde:sqlserver:GISSQL\ARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISSQL\ARCGIS;DATABASE=SalemGIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SalemGIS.DBO.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>DATEVISITED</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>DATE VISITED:</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><FeatureDataset>SalemGIS.DBO.Parcels</FeatureDataset><WorkspaceConnectionString>SERVER=GISSQL;INSTANCE=sde:sqlserver:GISSQL\ARCGIS;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GISSQL\ARCGIS;DATABASE=SalemGIS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>SalemGIS.DBO.Parcels</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>DATEVISITED</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>DATE VISITED:</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_X;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateGeometryAttributes SalemGIS.DBO.Parcels "LAT CENTROID_Y;LONG CENTROID_X" # # # "Decimal Degrees"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
AddRelate SalemGIS.DBO.Parcels INDEX_ID SalemGIS.DBO.RealEstateTable tax_map_number Relate1 "One to many"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
AddAttachments Parcels INDEX_ID "C:\Users\rojarratt\Desktop\Completed tasks\2022\September\TaxParcel\TaxParcels_ExcelToTable1.dbf" INDEX_ID Path #
CalculateGeometryAttributes Parcels "X_Coord INSIDE_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes Parcels "LAT INSIDE_Y;LONG INSIDE_X" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Decimal Degrees"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
CalculateGeometryAttributes Parcels "X_Coord INSIDE_X;Y_Coord CENTROID_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Decimal Degrees"
CalculateGeometryAttributes Parcels "X_Coord INSIDE_X;Y_Coord INSIDE_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes Parcels "LONG INSIDE_X;LAT INSIDE_Y" # # PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Decimal Degrees"
CalculateField SalemGIS.DBO.Parcels GPIN "Mid( [X_Coord],3,1 ) & Mid( [Y_Coord],2,1 ) & Mid( [X_Coord],4,1 ) & Mid( [Y_Coord],3,1 ) & "-" & Mid( [X_Coord],5,1 ) & Mid( [Y_Coord],4,1) & "-" & Mid( [X_Coord],6,1 ) & Mid( [Y_Coord],5,1 ) & Mid( [X_Coord],7,1 ) & Mid( [Y_Coord],6,1 ) & Mid( [X_Coord],8,1 ) & Mid( [Y_Coord],7,1 )" VB #
ExportFeatures SalemGIS.DBO.Parcels C:\Users\jsimpson\Documents\ArcGIS\Projects\MyProject20\MyProject20.gdb\City_Blueprints_Documents # NOT_USE_ALIAS "INDEX_ID "INDEX_ID" true true false 24 Text 0 0,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.INDEX_ID,0,24;X_Coord "X_Coord" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.X_Coord,-1,-1;Y_Coord "Y_Coord" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.Y_Coord,-1,-1;GPIN "GPIN" true true false 15 Text 0 0,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.GPIN,0,15;LAT "LAT" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.LAT,-1,-1;LONG "LONG" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.LONG,-1,-1;StrVw_X "StrVw_X" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.StrVw_X,-1,-1;StrVw_Y "StrVw_Y" true true false 8 Double 8 38,First,#,SalemGIS.DBO.Parcels,SalemGIS.DBO.Parcels.StrVw_Y,-1,-1;ID "ID" true true false 255 Text 0 0,First,#,SalemGIS.DBO.Parcels,Sheet1$.ID,0,255;PATH "PATH" true true false 255 Text 0 0,First,#,SalemGIS.DBO.Parcels,Sheet1$.PATH,0,255;ObjectID "ObjectID" false true false 4 Long 0 9,First,#,SalemGIS.DBO.Parcels,Sheet1$.ObjectID,-1,-1" #
AddAttachments City_Blueprints_Documents INDEX_ID Sheet1$ ID PATH #
CopyFeatures City_Blueprints_Documents C:\Users\jsimpson\AppData\Roaming\ESRI\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.City_Blueprints_Documents # # # #
CopyFeatures C:\Users\jsimpson\AppData\Roaming\Esri\ArcGISPro\Favorites\SalemGIS.sde\SalemGIS.DBO.City_Blueprints_Documents "C:\Users\jsimpson\Documents\ArcGIS\Projects\MyProject20\PUB (2).sde\SalemGIS.DBO.City_Blueprints_Documents" # # # #
Server=gissql; Service=sde:sqlserver:gissql\arcgispub; Database=SalemGIS; Version=dbo.DEFAULT
ArcSDE Connection
SalemGIS.DBO.City_Blueprints_Documents
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS["NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",11482916.66666666],PARAMETER["False_Northing",3280833.333333333],PARAMETER["Central_Meridian",-78.5],PARAMETER["Standard_Parallel_1",36.76666666666667],PARAMETER["Standard_Parallel_2",37.96666666666667],PARAMETER["Latitude_Of_Origin",36.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2284]]</WKT><XOrigin>-111140600</XOrigin><YOrigin>-91532100</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102747</WKID><LatestWKID>2284</LatestWKID></ProjectedCoordinateSystem>
20230315
09390700
20230315
09390700
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.0.3.36057
City Blueprints and Plans
City
Plans
City of Salem Blueprints and Documents
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SalemGIS.DBO.City_Blueprints_Documents
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
ObjectID
Integer
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
INDEX_ID
INDEX_ID
String
24
0
0
X_Coord
X_Coord
Double
8
38
8
Y_Coord
Y_Coord
Double
8
38
8
GPIN
GPIN
String
15
0
0
LAT
LAT
Double
8
38
8
LONG
LONG
Double
8
38
8
StrVw_X
StrVw_X
Double
8
38
8
ID
ID
String
255
0
0
PATH
PATH
String
255
0
0
StrVw_Y
StrVw_Y
Double
8
38
8
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230315
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDy5juY
n1pK149BlP8ArZ41/wB0Fv8ACrUeiWiffeSQ/UAGsZV4LqWoSOepyRvI21EZm9FGTXUx2NnF9y2j
/wCBDd/OrAYhdo4X0HSsnil0RapPqczHpN9J0t2X/fIX+dai2EqpGmV+VQCc960aKzeIkylTRSWx
IIJcce1SDT7dGldTLvk6ksCOueOKs0Vm6031K5EV1soR1Bb6mrEeYVKxkop6gHrRQSoXczooPQsw
GalylLcdkgrjpbnQX1a+bVrW4aTzQqBSQNoHOcHr+ddRJqNlF964DeyAk1nXV/psxO6xE5/vSAfy
rooKUXexnUs+pW0G509tVu49MgZLYorAnPB79ST+tdIAWOACT6CudGrvECLa3ggB7Imf51BLqN5M
MPcSFf7oOB+VVOjKcubYmM1FWOncrFnzHSPHZ2AP5Gq0mp2MfW43+0akn9cVzBJPUk0lNYaPVg6r
N6TXoV4it3b3dsD8h/jVSTXbtv8AVrFH9Ez/AOhZqgsErjKxORu25C9/T61bXR7w790YTYQDk9WP
YY6mtY0YLoYzxMY/FKxBNfXc4Ky3ErL/AHSxx+VV6208PkMvnTdOHCDJ3f3R6n+VWk0S1RQrh5H3
fMVPf+4vqfU9q1UbbHHPMaK63OaorV1q1jgeNokCg5DbB8gI7D1x3NZVJnTRqqrBTXUKKKKDUKKK
KACr1i2YnX0OR/n8Ko1asWxKy+q0mCGXa4uW98GoKt34wyv22n9KzjdL2Q/iaEBNRVY3TdlUU03E
h/ix9BimBbooQ7oEcnJPBooAKKKKACiiigDsqKy5NdgX/VwOx/2jgVVk124biNI0H0ya89YebOh1
Im+AT0BP0prssYy7oo92rmJdRu5vv3Dn6HFVmYscsST6k1qsL3ZDq9jp5NSso+s4Y/7AzTZrwpIy
oowO5rnIV3Txr6sB+ta7nLk+9WqEELnbLCXkpkGSMemKhjvp7i1DuVBLHG0YpgOEkb+6hNRWwxYx
/wC839KrkiuguZkxdj1Yn8ao6kx89EJ+7GP15/rVyqOoHN43+6o/8dFWlqSyrRRRViCren2YvZyj
SCNVG5mPYVUq7pMgj1CMllUdNzDOPfHrTRjXclSk4b2NZdFtU8zcWxjOX/5Zr6n1Y9hVyO0t7dhI
sKxGNcAkZMYPc+sh7DtUwwg3HKBPm+bkoT/EfVz2Hal+58zZTYeB94xk/wDoUh/SrsfNTxFWWkpN
/wBf1/W6KBGAceXs4VRz5eew9ZD69qXlSONrL8oC87M/wr6ue57Ucoem1l+UBefLz/Cvq57ntR93
5Rww+T5Odv8AsL6n1NBje4fd4HDD5Pk52/7K+p9TRjGFUZJ+T5P/AEBf6tQOMKoyT8nyf+gL/VqA
M8DkH5CU43f7Ceg9TQIytdjDWaOAp2vt3g8f7qD0Hc+tc9XVamvm6dLgjAXgqv3sc4X0Udz3rkHu
EVTtO49uKmW59Dlsr0bdmS0VUNxIehA+gq4SCqtuHzDNSeiJRQCCMggj2ooAKmtDi5T3OPz4qGnI
2x1YdQc0AXNQ4tt4GSp/n/8AqrBrpLpN9vIo6dq5wgg4IpIGJRRRTAu2p3WzD+61PqKyPMieoqWg
AxQSB1IH41BclhtwSBiq1AF0zRj+LP0pn2mP+6fzqrRQBoUUUUAFFFFAE1qM3cP++D+tabfeP1rP
sBm8j/H+Rq/UvcaEc4t5j/sEUkQxaw/7mf1NJcHFlN68D9akxtjiX+6gH9aQxKzr05vp/aRh+tac
a75FX1OKyZ38yeR/7zE/rTW4mR0UUVQgqW1kMV1FICQVYHIHNRU2TPlNgkEc0EyV00zuCQmHY+Xt
PHcoT/6FIf0pN4Q8kq6HYAnzGMn+Ff70h7ntVSzlD2sLqwyFCgxDPlk/wp/ekb17VOq7CFUEMD5X
7s5KE/8ALKP1c/xP2qz5OUbNp/1/X9eb94Q7VB3D93+7OdpP/LNPVv7zdqFkyyooGT+7/dn/AMcT
+rVGBjCIMk5iAiP5xxn/ANCegckBTuB+TMXG/H/LOP0Qd2qibE+M/KOQfkJTjd/sJ6KO5pP9ZgAA
qflwvAcD+FfRB3PelP7wjGGVhgbTgOB/Cvog7nvQP3vAw6uO3yiQD/0GMfrUiuR3AM1u6p8wkUgb
fl3gen92MevevPSMEj0r0Z8SRkYEgcZ+b5RIB3P92MenevP71dl7MM5G8kELtBHrjtSkexlMvij6
EFFFFSeyXLM5jkX05qSoLI4nx/eGKnPWgAooooA1V/eW4/2kx+OKw7scq34Vs2bZt0P90kf1/rWX
eptDr/dakhso0UUUxE9o225X34q0wwxFUEbbIrehrRlH7w46GgCvcDMOfQ1Uq+43RuPUVQoAKKKK
AND8R+dJlScBlz6A1QqSFtkyMegPNAFyinOMORTaALenD/S9391Sf0x/WrtVNNGZZf8Armf5irdS
9xojuuLNv9pgKmk4YD/ZH8hUNzzBEP8ApqP5VNJ/rG9jikMWE4nQ+jA1iVsg4WQ+kbEfkaxqa3Ew
oooqhBRjII9RiiigDodElZtNjwZd65iDKBuGf4Ih/ePduwrRAwAiLknMQEJ/OOM+n9+SsTQXwJ4Q
CXZsAIfnYH+Ff7oPdvQVsj5l2r8wYeWTFxvA/wCWcf8AdQfxN3q+h8xio8laS8wzv+VcMGHlkxfK
HA/5Zx/3Yx/E3ej/AFnAw6sNvyfKJAP4V/uxDue9H+s4G11Ybfl+USAfwr/diHc96T/Wns6uO/yi
UD/0GMfrTOZu39f1/X4WF/exqRh1YY6bRIB/6DGP1pSQw5w4cZ+b5RIB3P8AdjHYd6bGwaNs4cN8
3zceYB3I7IOw70vX5mwxb5/n4DY/if0UdlpE/wBf1/X/AADOSWYhy3z/ALzgPj+N/RB2XvXH+IIJ
BqskpWVhIofc4wT7kDp06emK7HGSSTkn94TJ/wChv/7KtYGvoFuo2HBkUhtxy7Z/ib0J9Owolseh
ls7Vrd0ctRQRg4oqD6IkgbZMh96vSDDms0HBzWk53BW9RQA2iiigC9Yt8jr6EH/P5VXv0/eSD+8u
aksTiZh6rTr5fmjbsRg0uo+hh0UrDDEehpKYgrSzuijb1Ws2r8B3Wg/2WxQAvQ1FcInkgqoBB5x3
qWkYblZfUUAUKKKKACiiigC/HIZ0LYwVwDS0W6xpb7hnLjmigC9pw+WZvYD8/wD9VWqr6eMW8x9W
UD9asVPUYyddz2qf3mJ/KpHO52b1Oaa3N5aD0yaWkMRztt5m9EI/Pj+tZFas5xZT+4A/8eFZVOIm
FFFFUIKKKKANDRWI1BoxvIlj2lU4L4PTPYep9K38+aeAGVhtwvyiQD+Ff7sY7nvXM2GTfQfLuy20
ru25B4wT6V1QheQnhWVh/uiXHb/ZiH61cdj5/M48tbm7oZ/rT2dXH+6JAP8A0GIfrSlgR2cN83zc
eZj+JvRB2Hehz1zh93PzfL5mP4m/uxjsO9NJz8zHcW+f5+N3+23oo7LVHnf1/X9f8B8J+clvmLjd
84+9/tN6KOwqXBySTk/fJk/9Df8AotEXCbzyx+cmT/0Nv6ClZuSBwfvkv2/239/QUgAnAwDgj5yZ
Odv+2/qfRayNej/0RMB8o+WB5Iz3c/3j6dhWr93gEqV+Ys/JUn+JvVj2Haqeqx7tNmQKf3eGO5vu
HPc93P6Ch7HRhJclaL8ziZ1KzMccE5FR1buRmIH0NVKzPqQrSO0QxhemKzavxHdaofTigBaKKKAJ
bVttyh9Tj8+KtXq5hB9GqipKsGHUHNadwu63fHpkUnuMwLgYmb35qKrF0vKt6iq9MQVcszmOVfoa
p1Zsjifb/eBFAE9HSjvRQBTmXbKw7dRUdaASNmy65OKk3RjgRjH0oAzVjd/uqT9BQqFnC984rSMz
Y4AApFk2jhRn1xQAiwmGDYzAnOabSsxY5NJQBpWQ/wBCJ9ZD/IVNUdoNtig/vMW/p/SpKgoQ86gv
tDmlpB/x/Sn+5GF/OloQEV4cWLe8ij9DWZWjfHFog/vPn8h/9es6qiJhRRRTEFFFFADo22SK3Bwc
812u/wAxAfvhxu+b5fMx3P8AdjHp3riK6+wfzLGF2wSyBsSNkHbxvkPZFxgL3NVE8jNYaRkPk++X
Yhi48z5+NwH8b+iDsvemgEksxyx/eEyf+hv/AEWrGwM26Tk/6wmXjjtJIOw/urSllUkKuD/rGMgz
t/239/Ras8XyQ2M4jZRwQd5Mnb/bf39FpPu5AJXb8xL87c/xN6sew7U4uRlR8u35iX5KZ/ib1c9h
2pPuZAJj2csx58vPc/3pD6dqkBPuZAJj2csx58vPc+sh7DtUU8Ye2kj2hFVSuD82wkdP9qQ/pUv3
fWNYz2+YoT/6FIf0penrGEOwCP5ihP8AAn96Q927UDi7O6/r+v68+GlXdE4744qstvM3SNvyrRuo
zDdzR42lXIwGzjn170zzGxjNQfXQfNFNFVbGU9cD8asxwmGFlZgcnPFIWY9zSUFBRRRQAVqxnfbr
7pj8cVlVo2bZt1/2SR/WkxoxLrImIJNQ1dvoW847VJwSDgVSpiCpIG2zofeo6VQSeASfagDRcYcj
3ptPl5IYjqAaZQAUUUUAacKKLdNwBGM8is0nJJ6ZrUkOy3bHZeKyqSGwooopiNaAYsoPof8A0I06
lZdgWP8AuKFP1A5pUGXX0zzUFDF5urxv92lqO3bek7+slSUICtqB/cwD3Y/yqhV3Uj88I/6Z5/U1
SqlsJhRRRTEFFFFABXS6A4awK5jzG5Yhl+RMf8tJD3xn5V7muarb8PysPOjzgLiQF/uIRxuI/iI7
D1NOO5w5jHmoPysbzNtyASCP3hMvJXP/AC0k9WP8Kdqb935RlCp3Ev8AMUJ/ib+9Iew7Un3flXKF
TuJf5ihP8Tf3pD2Hal+5wCY9h5P3jGT/AOhSH9K0Pm/6/r+v+C8Quq/L+72ckn5jHnv/ALUh/So8
bcdY1jOAB8xjJ7D+9If0qzF/q1GNipwADkofT3c+vaoCMH+4qHYPL5K5/hT1c927VI/6/r+v+CnT
HWNUOwCPkoT/AAJ/ekPdu1JnOAAVA/dBYTkjP/LKP1Y/xP2pCc4ABAH7sCLt/sJ7nu1PA6cZJHlK
sRxkf884/Qf3noGtDlNWjEeoyACIDj5Yvur7A98dM98VSrY8QI3nwyE7gV2gqMIMdkH90dM9+ax6
l7n0+Enz0YvyCiiikdIUUUUAFXbE/K6+mDVKrNk2JyPVaTBBeDbcE9iKqLawAZZmJ9M1evl5RvbF
U6EA4LAn3YgfrzTvOIGFUAVHRTAVmLdaSiigAooooA0rtsW7e5rNq9fH92i+pzVGkgYVNaoJLqJS
MqWGfp3/AEqGrmnL++d/7iE/nx/U0PYEXWYs5Y9SaQtsikf+6hxRUV42yyI/vtj8qkoLMbbL/efN
S02JdlpCvtu/OnAZOKAKWon/AEhV/uoB/X+tVKsXzbr2T2O38hj+lV6pbEsKKKKYBRRRQAVoaJJ5
epL8yqSCAzDO0+oHc+nvWfVixlMN9C4Zkw4yyjJA9R700Y4iHPSlHumdd9zIGY9nUn5jGT/6FIf0
oAx2MaocADkoT2Hq57ntQBtxwY1j4AHJQnsPWQ+vaj8Nqr8oCc7f9lfVj3NWfKf1/X9f8GxAfk/u
hDtATnb/ALK+repqGb/WHqAPkATt/sJ7+rU+BskjGAPlAToP9lff1NJMArg4ySNgCHr/ALK/1NIC
MDGOMk/Iqx/+gJ7erUuPYOzjYAnAYD+BfRB3bvSfhvZvkATjd/sL6KO5pMeYcDEm/wCX5eBJj+Ef
3Yx3PemMyNdUPbxS5Vjuxv6bh6KOyjp71g11OrL5mnSbTuJw24Ly+PQfwoOg9a5aplue/lsr0bdm
FFFFSeiFFFFABUtu224Q++KipQdrAjtzQBfvVzBn+6az61Jxut3x6ZrLpIbCiiimIKKKKACiiigC
7eRyOy7UJUDqKplWHUGr4vYieQw98VILmF/+Wg/4F/8AXqdRmXWjYrttXb++4A/Af/XqTZDJ/DG3
0/8ArVM8awpHEq7cLkgep5/lihsEhlVr8ktDEOuM49z0qyBk4FVmxNqwUfdVsD6CkBbcANtHQACl
jx5i7unemscsT6mmyNst5n9EI/PijoMyXYu7OerHJpCQBkkAe9FRXJHlAdyeKskcJYywUNkk46U/
HOKoAkEEdRUjXErdX/KgC3RQPmiR/Uc0UAFAJBBHUUUUAdnA4kgjkHyoAAPL525/hX1c9z2p5Occ
YA+QCPt/sJ6n1aqWlyNLpsJO/geWCBgn/YQep6lqvAYxxkn92qx9/wDYT29Wqz5KrHkqOPZsfB8r
jIGT8gCf+gr/AFNPnH3TjczfIAnG7/ZX0X1NRRnEinhmb5Bs6N/sr6KO571LMpkTAG/dx8vG/HYe
iDue9BmVgPMOB8+/5fl434/hHog7nvTvv/KuH3jk/dEgH/oMY/Wj7/yrh945P3RIB/6DGP1pcb+B
hw43Ev8AKHA/ib+7GOw70A3/AF/X9fpFcL51tKikt5iFifu7wB94/wB1B2HeuNPBrt+HQknch/eZ
k48z/po/og/hXvXGXC7LiRRkgMeox+lKR7GVS+KJHRRRUnshRRRQAUUUUAakR326+64rMIwSPStC
ybMH+6apXC7Z3HvSW42R0UUUxBRRRQAUUUUAFFFFAEttF51ykZ+6T8xHYd/0rVdi7ljxk5xVK1YW
9ndXZXcUjbaM4zgEn+WPxpLm6ntZNjxWxJVmGJW5AjWT+76Nj6g0rXYXsXQ3lhpD0Qbv8P1qpp4J
eaU88Y/Opb9xHAI1/wCWjZ/Af5NLarss19XYt/SkMkqG9bZaBe7t+g/yKmqnqL5mWP8AuLz9T/kU
dQKdRXAzDn0P+f6VLSMoZSp6GqEUKKfKnlyFQcimUAXbY7rYr/dNPqGyzvYYOCOuKmoAKKKKAOg8
PyAwSJgl921VVvncH+Ff7o65b0rX9Ojs42AR8BgP4E9EHdu9c9oMhF1JEFZvMTG1Rgt7Fuy+v0rf
AMjdpN4xx8okA7D+7GP1q1sfN4+HLXl56/1/X/AFy5GPn38fL8vmAdh/djHc96tyDzIyo2vvXkk7
Q4H8ox+tVfv8DD7xyT8okA/9BjH61aU+ZGACGDDJLDAYDu3og7DvTZxf1/X9f8Ct9/gYcONxL/KH
A/ib+7GOw70cOCSQyH94TLwJMf8ALST0Qfwr3oOGB3cqfnPmcb8fxv6KOy96UnOXc4UfvSZR+Ukg
/wDQUpDQhOSXc4X/AFpMo/KSQf8AoKVy2royalIWWQbsN+9PzHPc+n0rqTndliUCnzP3nJUn/lo/
q57L2rntfjCXaMFCll5UnL/Vz6nrQ9jvy2dq1u6MmiiioPoQooooAKKKKALli3Dr9CKjvRifPqKL
JsT49Ripb5eEb8KXUfQpUUUUxBRRRQAUUUUAFFFT2cQmuUU/dHLfQUAaAjVLZYGUMpQ7weh3Dn9O
KiaxtpXy1ujMeOe/GP5cVOzFmLHqTmjd5cby/wBxcj69BUXaHZFC+k8+9YJyAdi471fZQgVB0RQt
UbBN9wZCMiMbvx7f59qu9TTYIcg3OBWTPJ5s7vnOTx9K05ZPJtpJO5G1fqayKEDCiiiqEHlxO2ZF
zx608eUn3Yx9cVGxCqWPQU2OVZX2qDnFAE5mPYAVH1NLikoAKKKKALmltjUIlxuDfKVLbQfqfT1r
qvv8DD7xkk8BwO/tGPTvXGwNsnjbjhgfm6fjXZA7xwdwYbiX43D+83oo7DvVxPDzWNpxl5B97IGG
DfMS/AYD+JvRR2HerMRDRZOSud2ZON3+03oPQVW4IyeVPz/Pxu/229B6Cp4DkMWPH3/n/wDQm/oK
bPKRFIPnYsQADv8A3n/ob/0WjnO5jsCnzP3nOzP8b+rnsvanyj94WY7QPn+cfd/229W9BUbNs9UK
Hd83JQn+JvWQ9h2pB5IUnYO6bDuAb5ihP8Tf3pD2HasbXoiLeM4YbGwV67c/3j3Y962P9We6Mp/3
jGT/AOhSH9Ko6vDu02T5QDGRxu4Q+n+0x7mm9jowkuStF+f9f1/T5aiiisz6kKKKKACiiigCSBts
6H3q7eLm3P8Asms8HBBHatSRTJCwHUrxSY0ZVFWFspT1wv1NTLYqPvOT9KLiKNKFLHCgn6CtJbeF
OiA/XmpVwhBCggc49aLjsZq2szfw4Hqan/s2YAbs5Iz901s3pgivVe3KNErcKMc4OeRSNPCXY7p2
yc9entRcDmq0LBNsDyHqx2j6dT/Ss8DJwOtbIXy40iH8K8/XvQwQlQX77II4u7nefoOB/WrCqWYK
Bkk4FUJj9r1DYh+UsEU+w4z/AFpdQLVqnlWi/wB6Q7j9O3+fepKc5Bb5RhRwB6ChMZyfuqMmkMpa
g+GSEfwjLfU1Sp8shllZz1Y5plUtiQooopgRXDlUCgcMOTVUEg5BwatXAzDn0NVKAJYJAkwZySOh
q2CGXcvKmqKoznCqT9KvQRuluyupGDkZoAKKKKACuxtm821jdhwVDnefvf7b+3oK46t+w1G3gsIl
mkQMG4TBPP8Aeb1x2FVE83MqUpwi4q7ua/XLMcD7/wA//obf0WpoPvktlQBu+cZx/tN7nsKw5fEE
IZ/Ljd9pym/u399vU+g7VFHr1w9zEI0VFB6H5iWP8R9TTbR5kMvry6WOiuTsKtyu35vm52f7R9XP
YVWeVLcMzuIzH8xJOTFnufWQ/pWDf3dy0KEzP8r7hg459frWUzM5JZixJySTnNJSOqOVP7cjqm1O
zgZFM204JynzeWD6ernue1Z93rcU1q0UUJBOVGeiL7e57msdYpH+6jH6CpVspT12qPc0nI66eXUY
NSd2yvRV5bFR95yfoKlW2hX+DP1NTc9CxmgE9ATUi20zfwED1PFaYAXoAPoMUUXHYpLYt/E4HsKl
WziHXc36VYoJCjLEAeppXCwxYo0+6ij8KfUTXMK/x5PtzULXy/woT9TRYC3RWe15K3TC/QVC0jv9
5yfxosFzTaWNPvOo9qia9iHQM1Z9FOwXLTXzn7qqP1qM3MxOd5qGinYRasYfMn3MPkj+Zv8ACr5J
YknqeaKKl7jQ5AfLkdSAVX5SfU8D/H8Kq2Vu8LSSyLggbVPuf/rZ/OiipGT1Fdv5VoR/FIcfh3oo
qgMyiiiqJCiiigCK4GYc+hqssbv91GP0FFFAF60iliV9y4BHHNOLsepoooAbRRRQAUoBY4AJPtRR
QBKtrM38BH+9xU0dmysGMijBzwM0UUgLbqrqVYZB7UixRp91FH4ZooqSh2Se9FFFABgmmNLGn3pF
H45oopoRE17EOm5vwxUTXzH7qKPrzRRQK5C1zM3VyPpxURJJyTk0UVQBRRRQAUUUUAFFFFABTXfa
cc9KKKAP/9k=