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 #
CalculateGeometryAttributes Parcel\Parcels "X_Coord CENTROID_X;Y_Coord CENTROID_Y;LAT CENTROID_Y;LONG CENTROID_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]] "Same as input"
CalculateGeometryAttributes Parcel\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]] "Decimal Degrees"
CalculateGeometryAttributes Parcel\Parcels "LONG CENTROID_X;LAT 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 Parcel\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 Parcel\Parcels "StrVw_X INSIDE_X;StrVw_Y 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 Parcel\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 Parcel\Parcels "LAT INSIDE_Y;LONG CENTROID_X;StrVw_X CENTROID_X;StrVw_Y 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"
CalculateField Parcel\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 )
" Arcade # Text NO_ENFORCE_DOMAINS
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 #
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/3.1.0'><FeatureDataset>SalemGIS.DBO.Parcels</FeatureDataset><WorkspaceConnectionString>SERVER=esrisql;INSTANCE=sde:sqlserver:esrisql\arcgis;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=esrisql\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>DIstrict</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass "Database Connections\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels" "Database Connections\SALEMGIS_PUBLIC_ESRI.sde\SalemGIS.DBO.Parcels" Parcels # "INDEX_ID "INDEX_ID" true true false 24 Text 0 0 ,First,#,Database Connections\PROD_SalemGIS_ESRI.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\PROD_SalemGIS_ESRI.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\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Y_Coord,-1,-1;GPIN "GPIN" true true false 15 Text 0 0 ,First,#,Database Connections\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,GPIN,-1,-1;LAT "LAT" true true false 8 Double 8 38 ,First,#,Database Connections\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LAT,-1,-1;LONG "LONG" true true false 8 Double 8 38 ,First,#,Database Connections\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,LONG,-1,-1;StrVw_X "StrVw_X" true true false 8 Double 8 38 ,First,#,Database Connections\PROD_SalemGIS_ESRI.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\PROD_SalemGIS_ESRI.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\PROD_SalemGIS_ESRI.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\PROD_SalemGIS_ESRI.sde\SalemGIS.DBO.Parcels\SalemGIS.DBO.Parcels,Shape.STLength(),-1,-1" #
Server=esrisql; Service=sde:sqlserver:esrisql\arcgispub; Database=SalemGIS; Version=dbo.DEFAULT
ArcSDE Connection
SalemGIS.DBO.Parcels
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/10.8'><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>
20230721
07074500
20230721
07074500
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Parcels_WMI
test
Parcels
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
SalemGIS.DBO.Parcels
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
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
StrVw_Y
StrVw_Y
Double
8
38
8
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230721
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3IqWL
Angj8qaSFixjA6U4gZPOCB1oPQdxWIArALxk496iuIlfy2Zc4PNPxndnv6UMd8WB1oAZHFGrvtjU
H1A60RYUMg6g802SUIASefT1pImEmJkB2uO9ACzElflHTrUg5A9CKXHUGhRgYxxQA0RjkHgGlULG
uCQAPWobi7WE4A3H0FY1zcyzyMGJxn7opXA1pr+FflX52Jxx0rOu9Xlt8MykAnAwKrbjFPCDyrZ+
bsKYkcgkfzMSpn8M0AWYZGnMjzStIrgbVz09quRRhUykarnrgYzVe2jhW5UYI9u2av5HksSMBTji
gCMeaD8r49RUizlT2/E1RW5QnDFh6HvQ7ow3Atuzxu9KLgWjcSFj85OPTtSxyTHJBY+tJCF8rJXg
nj3qZAY+ScL7UALdSGS3K7lU+prOkS4NuVX5j3xUt+UljRATgnFNsL9BEySKFeLhhnkjtTtdXJvr
YZp8MkCTMVZSemaYm5bpJ2k+YnAyKvrqMcmRtP8AhQY4ZXWUICRSKJzBJPIpkb92vOT/ABGs/U4l
adTG/Qd61GkLREYJOOg7VRMDlgXy2OSKt2sMWxh8lowCCTy1WL+7aCMfLxnqKkjwqFsDcPSs67E1
3Iq4281N7CKe+W5uVXaQf9o1o3nmJbBVI3DAp1naDz2ncEgDC5/nVuWNBGSw+U9aAMK2j8t9z8sG
wTVw2yGXOzqeMf1qxLDEiHBOTzzTXnEcMZHbrQrgRw2csNyzscqueB0/Kp0ZiA7RKrHrxzipZGfa
dmMnrQp8xNrrg+ooYEUgEcWI+SORS4ZX85yVTbyo6k+9SshQblK4A5zVfa4UtPIxwBgL3NG4Eclz
cFyFRVT68mmY85lljA+Xjd6UscYnnMrKRGPU/e+lSGDzJkUDbGnIQU9tQEeztZyrzW6uQ27OMHNV
PsoiZlgc7Mk/MOc1slUD4bAVhn6Gm7YU+ULxTbaEiYk7fSmk5A6Gmk4mAz1FLzjjpUjFPqKYVbJI
OMjH0p4AAo69BQBUitMS+ZM25u3PAq3jsOn0pCQoyx/CqdxdsQYozg/yoAmmuVijOCHcdgayXu5X
kJmcov8AdHFSEOgBKjHbBpxvF2AOo9ORxSAgSYSuViHOOM1DLbzJ8z/Xinho0uv3PBx+FWI8zozS
njP6UgK0TkAu/OGAAPSpFJDOHOM89KmlhiIAjcZPOKREW4Zw42gdxQBD9oMlxCqjADdutak8S29o
VU9Tls96pafbx/bCySBlStG4XzULdMdM00BmpC80e7YB/tEjipFgbBSQK47GmmAl/LUEk9SKuLbu
q4ZlA/OgCvJI0KJESQoGMgZpYLiMuRlzjrupZHeBiHj8xPUVGEs5ARGzJI3vQBHdsJgyAbQGBFUp
Ult5luIzvDfKybck+9WDb3ETYMJkX69atmKOKBfMLI7DAUHOKaYmhbWFShZhj1qwB8qiED3zWTBI
bCT7CmWeU7kJ7/U1uRRFYgZCCwHai1mCdyJCVkMbZK4ycVNEpkbcx+XPA9qc8exFcde9LkY3DkEd
qdgIApWSQgkluRn0ojY9G6Z+tEkmWUspXBwKTocGk9wZOCCSQeaRyzfK2MY4qFXPmbSflFSStIkZ
lVQxXtQtQGm3YuXB7Y5qrKfI2hmdCzdF5NSC5upCNyrGoJyBySKIUH2nzZW3HHTsKrRMCdSojyDz
05prLnbhjg9xTGK7tw6e1ORF8gHOCKTsO4koVA2/IQDqD1qAYvITEgZY88tndn25ojjN6TJI37lG
4HrT5tVtrZSPvAfdRRz/APWqkrAWI7CJYQkakBe2aXy1hGflUdyWrldQ8UXb3KQQssQbrsG4j8ab
DGktwPtd+G4DZYbgc9snihpESqRjub2oapp8cRVrhXcdFjOcmsS61qGCURh3fCjLKOM1JcWluNNN
2m1irEqePu57dq5S7Msjo0Mg2FeAxGRyeKaZCq82x6kVDEN3Bp/SoZJlgiUv64qFdSgJPD5AyeKi
zNi5/Kqs12rZjiYEjqwqvc3DzrsQlUPUd/xqqZEVQqZGOgA61LAsNcujYKHH940ios6FjuUbuTio
o45iw3vjvmrDmJoURy+CxOVpAVHjmRy6SiQf3ajMkM5MckGx/XOMVcSxLcrIWH+11/OmvYvKdvT/
AGt3NAFIW/lSgI4bI6d6swyCeF0wVbvUT6bPA28ODiptOjRZJMkliMncMYoAYttDkEyMrE8EUjOA
ZYImZjjAOOTVyWOydxlyMdgetVkjhhvlMUhPrmgDQ06yFvCA33m5ap7rYyYLYx6U7zMLuxWfM/nS
7QM/TpVAHnPDGWGT7sOlVDfPuUheM8nsTUk8dyAfLkz7GkSZo5I/MgAY9SO9IC1aTPM5LxnbillN
m4ZmRVKnGelMS5cQytt2ckAmoILRniYOQcsD9RQBaIlRcQyoEPVmboKseUkhTJDH1qC3tUPyogGO
ueatoqwgoW+pqkgKGpwMUDwAGVCCpq5C7fIpGXK845xUgIAJK9eADT1xGCVApsSXUJFfy8cDjvUc
WPLIBwAap3Avp3xGyxoew61LFbssXlSykZ7+tF7gSTOo2jhs9Kq3kUtwgMUnlZ7+nFTNbSb48Z2J
zSy8p8pGW7e9S0MxHkuYpAn26MsDhsjH/wCunie4ZXJvU8srw4GMHNaE9nASXeCMueclRmqKz2ss
qwS2kYLZXGQeh9KCG7bgi3ksZ8q8hfacEgVqwxvn5lHI5PasjU5H0uySa0iRVZ8HA5q5aazaTRpI
6iInhiT0NOwXSdi+ICHAAPSoLySO1jPmyKmfujqT+HeqlzrFxcKyabDux1lbp+Fcdcvqc+oKN7GR
nxw2Sfb/ADxTSBzitDoL3VZUtNqKVhUjftPzckdfSqt9Ah0hpgXUSKpQbh8x6k/THrSzW6x+TLPb
gguEliU4yex/+tV64W3miMKW8cayqcFQCxx2x2qrnPOq3axxrK7HEeGwud4Yj8K1bPWp47VbGaNW
UsFBCgH3zTotN3gSyzxoHbZtLBto9xirNvp0Mcd2WtmfYCVk5AyOQQOKBSlF7kj+U04EdvGojkBB
VyU6dMDg06TTLeeRpVjT5jk7U4z/AMBBH60+Wf7NOyLJHL9oQAn5mwR9Sc8Yq3Z3EVvBsLBecgbe
2KRm21saV1qMUHytGWOPwrLkvZbh2KAL32imXbCWXK4KjgAU6zh3Sj5RxWV2egQM0ysdxZSfWprW
Z1mzjcT61oSKjsQyhz7npVSSOSJFCL8uTnHUUAWluIpOGGD7VRujcKP9GLbAcnNQOMthN2B71LGs
qKCAx3dj0oAZa3V3GHdpBk9Aa1P7RMagmMhjzmsyNFc/MeRyRVkKGBfeQFHTGaEMurOJVG5+ozhq
ayKytH5uCeuO1UpoweI5OP7pHAqKJFDDfuyTjNAjQgtMHDnIHcVSSPzdRwhwC2RVzTWJa4y5O3np
UWnRvNeGU/dBoBm06DyTz0FUDG0aF8fKOuOtWL25SCEg4J9KyP7QnJIjxsz0NNgPjvC1yBtwPc1Y
NyI2BEgLZxjGaiime5m2tGq8Z3BeaswWcaq247iG3ZPHNAEzne7JNtIwMAd6aWREByAo469Ke7Dc
G4PbFVYoVkZp7iTCZwATwapIB6verETEi/eOGYjGKXfeqkpZI9+zKYPU1bCJLsOcxdQMYzUxC4xt
GelFxGdG+orChaFGc5yc0+GW8V0SSIHPfPSrQciQoc4FSEhVyeAKBmas2oqzb4AQGwPeop9SuN23
7OBjkjvUkmqI5ZApVP7x70Fo2iDrKOeDgYFJsB1rfzO64i2qRyM1eaKJmEw7jj2qpayxl9kcZ2jq
x71bH7ttgGY25x6VUdRbGbNrVh5r2pnBlQ4Y44BHvWLZOs3iGGVyNuTuweDk4FUtc0iW01zzbN2b
z+uX5UnrUlzdW2mqscFw+4f6xiQQx/LJqramUm+ZI3NfntYtLkhkba4bKr3rz6+1OVYyYxhD3PU1
19xp8GqaEbh3aWWYhg5PRs45x6Vz66bd2Un2LUYojFMcLIx+XPqGwcfjQrC9rFvQ1PD9w8vh4BHf
eWZigXrjnqe1SzxFJJbk5WWMhkI9cD8Km0y3jspY7MSBGQnYxGQxIH/2X51GupW9lL5BTzLuORgW
UDBH55pGDd5No56XWZJb83cjZJ4wew6cDsa1dOkgEcE882Zs+W6scDI4rGuWDtJ58A8sOcEDABPT
Pf8AlSWksFpfxvdW5YEgMWXJQkckD1/zimbNXjoaOtwm3vfPlljMb87AcbfwqQ6tPO5i83zPlwik
kj/POfwq7c21jJp05WMbyC8c24kk+hJFc1p0IvryCGVD5Ifbv5zyehP40ERs1r0L19rNw5X7PLGs
64PypjacYIrGfUtS3HfcybqmltpNP1WaEud0bFQwI6f/AKqtnU7e5Cs0JcqApbHpTNEklojtZozH
EREu5GOeOoplm4Q9Tkn8q0vsttb5KysD6bqryW29y6HcSOnSsLG4qW+6LJfaWOS/pU9vEkQLvP5o
xxiqV1LI8JiX5QPvA8GolDrGTGMKmOfU0AW5lt5pPlHlN64qtMswVULFlDfeFOivJ5TgpGcdjwas
fa4mbDDysDlaAI3kSDA2DJXr3NSJELuAAfKgb5qJLcTSKIp4iMdGPNWRayx2xjXZz6GmBBZKpMq9
9/A9qc43scwowHp1qOJTFO24FFwdxxUS3CrL+6L5ZsZo6AXNPt0TzWwRuGCvpT40+zptQY60sDSL
dOrdD29auLEjNnvTigMmK2dpXMzAFuQOpp8dh5W7coJJ6Vbm3x7liUCRuATUfltHFtMp8zqzUmrA
KkCI29XI7Yx0qRtxkJONgFNSJguEJZuuWqTJLnK4A9eM0wGyKsdk8mRkrkZqGNIRZxSSgMQvCjpn
2qS7lVo9ijdu4xTLWHfFG8x8vy+itjj3qnsBMJjg/uTkD7velWZiMmNgfShpIbVGYOHc8kA5JzVW
Z7lYzKW2bjhUqXoBK11ELj53AAHT3qO5lM8ZVPu9sGq6wZt5JZTgsfvY7VFBl2KhiFx0HehMCMQK
OMbyDxzVlrQy4ByhHPHSi2U+YzNHtA4zVn7qHaWdj1PpSsAQL5fDurcU25vCYdkYweQWzwo9apzv
5cbSSyhYumc8/h71zuo6yYtgCHyS3yqT9/1yauIm0tzRv5Li6tmS2R5tuSZCOSfauMLPM7+azIVb
aQexrpYvEcrxv5aLEoXKAHI/H1rEgi/tHz2WQQlydzuPlzjI59M96sx5227nQeEryOe0m0+R/m5K
j2PpWvcRRXVuLO+RwBwHB4PpzXm1tdS20qmJiuONykAirkGr3qGeNJ2cSD5vMycfSlYzlSbd0aCX
Bg1DazlhFLtDEE8DOD+FJezwy3Tsv7rA3BiSefpVDznhZrlywJ5JJz8xz+Hc1qWmh3OsWjXkLwgk
kjcDgnvzQU0o6soCSWaKa2aNT5uDuYE4xmqTSM9nFF5CMxHLE/MD06VdnSaydo9rtIu0Eq4ZVbn0
NVUlSLymnikN0cg4A6duP1plosRCaSGIO7KBgYPI/H0rsLPwxZpCDIzsWIc7WwM+2KrWUME+nyt9
llxIo2hYmw3r0zWp50tpFI0MIFpGvHmkqc+3GcfWpbOac29EcT4k0prPVJNquYH+ZG67faueYCI7
fN967rUNWa/vGs90IU/L8oy3Tnk/4Vz01vb+aeEb3yapG9OTSszvxOcfvj8gOfrU8PkMA8KndjJN
Z8/mQ7RIu0YwM96ltrlYI1O0knIzWB0EzoZJSJXzx0WichLQRrjaoH1JqZLlSQAmWIzkUs8KTLgK
ynPTFMDEdpvPRQNgPO6rcIt5GLzSESKMbsdRUs1vKG3YOO3FWIraN3AK4GNzHHp2pWC5W8ux3ArK
+71I4pGmvIpsxglAONrZBqy12qTODEpXOPpTsxyurL+7PoKAJ7RbiYLJcYAYYKgdamW0hLENGvqD
0NWAQcBenakkU53HGa0toBA4lDq2MgHt6Vaj5O4d6ryBGhbrke9LHIxUBRxiktwJ5gXAOOQaqGAu
AUk24PK+pqyHJTB496jZACGB571T1AbGDGQSSD61YR/MPQMfXpUAIYEdSOxqWBMMRjGfegCJ4lyS
eDmkDruG48981S1fVE02URCPfK4yCThR9a5dtTn1C58ue4KRPxkDCj6e9MiU0jspUUW0ssg+dnDZ
9s8ClW38xhNMckcqueBWdazm4jihmyi5yM/xAds1au7+JIdpYICcEk4qGm2UncrXl4k8vkxgsg7D
jJqO0gY3BaToAcKKpS65Z6aMsYwccAHLHnrismbxd5rMI4nK46E4yfahQfUbdjrElJlLsfLiAwN2
BWRd+I7XTY3xIJJ27DoK5oX0uoysZLl4z1Ct90H0JNYlxuadwWBAPVavlRPNfQ7yxhl1oyXE9wDj
hAo+59K5PUrGTTr57a5DF5T+7brv56k/0rrfBUok0UjushBrA8YXTJ4khOeYVRl/PP8AShbnNGUn
UaZSMTWqstwsi4JHKHH54qz4fdpL0WccixLLkO23cWHpzUGreJL3UIxbyiNYyAx2rz+dZsF09pJH
LGT5indupmnK3HU9HPhjTfsYt44vLIO7zRy5P1Nc9rOl2WlXcSrEZhIvAZuh7k1LP45YxKtva/OU
BLu3GfbFc5qGqz6nMJLtgSBhQBjFJJmVOE7+8UruKSF2XcWXoeMD/wCvXeeFfOt9AlMoXycny1HU
nvz9a4wOLgbihWH7oBbPQcV3vh6W2No9mAMbiwXHGDz/AFoZVZ+7Y5eSwNvc3H2hXiOBsUYJyemf
askO0E/2i1lLuM4O3Pt36/lXT6tdxLpEyRJIkpuCd5jOBg9j+FRQ+C547QzPeLgJvwinOcZouNTS
V5EWj61rOoX0dsZ3RBkMiRqpAx9Kn8SXN3A5gN9IkWxX2SEFmOenA9ql0qztbXzdR/tDEx+Ubxg5
rM8QSnUb0yxOzqm1SzLt5wxx+ho6kqznotCjcXjzRABC6PgyMVyVP9asS+HJJRHLDMdjoGH+c1b0
/SZjabmVVhb+Ned2ea6yLQrbylzcXHTj5u1FwlUUdiqGE92Fd90SH72QRn6VfNuiqgRgy5z7CoYb
KVGJ8iPZ1Kk1bggRhvQsgB5TPFYnWwurSJtjb9mOBiqIS4jkAWRjk9A3NXbmAgqc5Uc8mq0InMiB
iQgIJJpsEasMMkdsGuZFH17VF5sUkpSGQsoHzYFQXxa4cKSdi9SOlLaRfZLZpCMSSfdB7CmFicBE
Zow25pOnyjipEg8pQGHzsc8Y/wAKh8ovDkbtyc5BxmpoL3zlCsuyUDODVW6oC2CR24+tNbkEnPHb
FMh3F2Qk5POfSpA+Qwx+FG4DCn7vLjmkPCBgefSpV/e4UgAGiZlChCv40WAYZVC9MH0pocNwRz3q
J5Y9wBBJxxgVBLqEEGfMbaeuCOTQr3AstlJM9c08MQd2T9M1zV94tt4Mqibj0BPNY0/iaW5hkaWS
RFHAUDGaqwm0ja8SwWeoJHO13GskfAUHcSPp61zvnSWs0RkWPCnK7xlmHv6flS6be2bysscfl5+6
JlDH86TUr+NUNrFbbYyNzMRyx+vpQY813sX5daR1EVzJNsXlRAoAHHByeazdS1GcQp9lVcnhm2ky
A/jUJuluWiWaPHljaJMkZ9KkLkqSsQSM4j+YDr6imPnZgy+bu3zGQs/djyffNaaae0Onm7eQLuAa
IeYBn/GthdLiuo0lfyjkhScc8ZJwPw6+9WbKGO8Z7WdUitgdiqoHI7ZPrSuRKoUtOt4tR0KWOSSK
NRMPmK/MM/7Wa5mQBbg4JwO5Oa6e9tLbTb+WG0iTyhGd25txBxjP6/pVfRZNNuLqWbU4UwwyqEZ5
yc8flQEZWvLoJ4duSNLu083a+/j5ivbtiq3iTyZbu1uIgrZt1Egyc7ufzrZ/tOBLlv7N09VVoyuz
GAeetZeo6hI2npp0sAiaPOXxz/nrQCvzXsc25A2lc7sY61qWsFxexxq6Ewj+Ns/lnBqxa+Gbi6tY
50j3eYTtXPPHf2q5NDqdrA9vbAIsKtJMpx8ox2/KncuU09ELJY2z2YNvARJGeVL7toOcE4wQePT0
rPjsI3vY4biRY4nOcniqdvqThpXfG+VcE7iBkHPNWA7SrczQ2wETYyT/AAfSgLNDLdks0lTYrfNk
EqSVxx9MHPXmoi9zaKqxTzKz/MTG5IbPTpj8qiacIyhnLoO5BHOP/rVbk1IXCiPYzIO5PNBVgmmu
pNitAxPAQDJZj9MnNX9O1G/mv4oryW5aAMFkj3MpA6fw4qsipG0MqfMVYcbslfQ80lzdzf6zzduS
fu8c0EtX0sdTcPZ2M4XT2h3u/C7Myq3484+tZkc6rfTGa0Ba4PlPJLlDyQM8jHHPSuft7gx6nbXB
chkcMxY5zzXqNvJbyrMxKGJnypboeB/Wk9DGa5PMs20UUFrHFD/q0UBec8fWpa5a9t4mmaW2lmtl
AYf6OMA+5+tVIHvVgTytRdUIyAwOR+tKxj7O+tzbnnjlcLEGG7uD/SrcEb+U1uiqxVuST0pkMdpL
OzxkK8JywHSrUCPCsnK7nYknOcCsrHpXJ3uYYVETYdwPu44FRebPLarIlurbu3QVBDZb3YyvkN6d
cVekZYLcgMUPTGelMCsk0pOJLYJ2GDVqIpPkOCCp4zUNq67iyl2yerHNWeBLjAwRVJiADO75u/ao
J4VbEqAiVeAcZq9HGohBx271C5EbEAcHiqWgyC2ulGFfi4ZeQaJbgW+ZHJweCAM4/Ko54x5iSIWQ
gdu9VPtcn2yS3uSohkHyYFLcTdjXQlUDkErSXE8YTzG+VV7ms+O/FratC4dyn3cDlqhjs5r+QS3/
AMsYOVgB4/H1NUMRp5NQZmtbbfCB99jt3EcgCuU11rxnjM4aFgNnljgn0x6//Wr0HaEAA4A6DsKS
eCK4QCWNXXrhhmi4mrnj28rKVkVmVG6DtUyRuy7iPl7MR/h9a39X0ef+0rqOFmIRd0aZzx7Vnf2N
fTWVs6zRmAsFVC/IcnntxTMW0tGZrygTE7iSOcrzVua+SWCMq0rMV2yGQZXA7VBeWEtg7QyKTtPL
A/hU2lwzPeQyoqFYiGbeflIHagbta42IWV0ADI8LHACEFhn16VagZdjRsvmovAY/xfpXYrDJqqrM
6fZ4GQZXgs3fn0FY9uqxymGQNsiYjCsTv9cc9xSuZKdyKw0p7gkWVydrKSzbcBcgcZ/E/lViLQ44
7ORnMuN+AGk/w960TqZjtW+zRJDEnALkD+fT9ahsvJ1C5aOafzMjfhTwf8PwxSJblu2Y89jG6wyD
arM+HV+4xzgk4zmhzbWNw6pCT8xwCCOfQk4wfwxXWXC2VlaySSxpsA53DJb8+tcxdRzXELXrTfZ4
yoaGLYSeSQMHt0/Wi44zTFsYE1Cb940UQiUu5Izt/EYqPV7WN9z+Ytwm3mQN5Yz0AHXdWK2ZFMcq
GMK3Krk8+pOSf1rU06OwMDKyxs2DtwQGzg9+vcflTKkrO5saJdXBsopUgZ0RdhJ7Hv0yT+VYGqWd
9JeT3EZyk5JwzYPpgDOTXQ28N3YL5Nu8jRgEmOQZG3sVrZiS2u7RBtWRAMcjoaVzLn5XdHmKaasV
wwuo9nlrulVm29emB1qk8UyoIwCyk5GDwRXqd3oOnXiYa3VDjAZBgisO40m0hka2aTkEEbTzj6dD
TuaxrpnAybliCFGHccf59KntLYyQzSCQho1B245P0rq7/Tra1tnaMiXe6rvVuRnjlT9etQadah7S
7gmtGEoGV3Lltvfn8KdzT2itdGNBHcShnVC0qruHyHIXv07fWmxqbkBY9glkU5QDIOPT8quaRdJY
6tunB8plZGI5OCKpWk/2O7inib5o3LbQOo7c0Fa6kl1pdzZRQSyyxS+Z91I2yV+tdTFJbnTkWG3e
WaSJTtDbyGBznAJIrGl1qa+vN32G3jbacHaMD/a+tbWk6uvnC31BtqvjBGAGOBycdRSZlO7Wu5Jp
8V9drLDIoiD42yu5yBjkAYH61qf8I9ZYHmO7Njk7gv6VpmGJyj7R8vTFNluBE+32zU3OVzbehUur
I2pa4twMk/MD0IqWyvrInZsMcxHKn+laoTA+YgDGMVWlskdiyMFb1wM/nS9T0bW2IvOgjdSZlQkn
AY4pssauyFrhCPvcnrR/ZiysrTtvK9NwpF0OADayKw5xknuaaStqGpZgjVF+Ug5PrT3Vw6k9wQap
SaQskKxqCiq+7KnvQ+mYcyxzTiQDjMmQPwqrRC77GqJFCjOSKjbfMXAA29AarWIuQhFyykBsLjri
rFwVtkMruFjXnJo2GmRMzbsGLO3+dZN7Is82y0iV7tR98/dj9zVkLc6sxYF4LX++eGf6DsPeryW8
NnAqxRKozjj+tCVhtGPpdrvilFw8r3cbZZ2P5YHpWxbSAxKJMCTHIzzVKzaJtQndInQjCuSMBv61
bMKNNvQcd/Sm9xR2HkhWx3p+8bWBBH1pjsEP3iz9NqilVVxmXaD6ZzU3KIJrWC4XzDF5kijg1xVw
gjdUit2TLHawPHfj69K9CEirAcLx6ngVmz21vfPHFNGDCrbgckFW9aZnNJ7nAT2cs87tIvmyEDKo
STz3rY0qwnhlWRLcMm3ABXhW9fTP1rs7axt4EK/IF/ujGDWdE9wryQQ2jOEYhXzheuf84zTaZlUT
UdNSobKYPGLiciJ2OVU9Cefw71m3ttJFdiPT5nllb7wRckfj2rpV0truMNey5TP+qjyB+J61fjht
raLbBCqKvI2jGaVrbihSk/iOXsvCmVea/lYytyFznb9atDQJIUAt72RSpyPlFdAmScsAARkjNQuM
qyg496EzbkieV6tqF+0zxXE7nYxXbjFbVzr9uNOiSWMvI0Gxh0+Yd/zBqnqOmXEuu3SQWspTcWzt
4P41SfR7+63NFbu7IdrcAc9aNDOUI9TrLExanpqzG1hkQDHJwQR64rntQkGmRTJ5ar56K0YA+6PY
/iaradPfQmWK1uGtoc4cGPfiqOq3091FAlzMXES7VwAuP84FFiIwtLyLNr4j1KOdWW4LhflAYdq1
rbxJNavJcvGhjbmRV7H6dq5mCCZYhcJFvA4JHPGPSpvMjvyTO0gVFwojTIx6YBp2LcIvodBf+JtQ
mgSaOExW7/dP94VkpeMbwXL7mKtnZnJIqk8hjP3iyKNqZOSB6deKvW1vBPboYL+3E5HzxSfKcegJ
4/WgFGMUTPqJvXkhS3QSgEgZz09D3/8ArVprO1zHFcsBb7k2liDyPp3FYFxHLYTK5UxyjDJ7jvyO
OwrvLWNf7KWZIhJHJCCUzyvHbNJmdS0bWOEm0+5FxKFQbTlhIvIK4zmqChlTnLZAPIrtrFLOad9u
/YybPLeTa2T12560y+8NQ3RAhlWO3VQDti+dT7jI/P8ASi5aqpaMyNL0UakkxVj5wTfGT/FVOePy
Zvs8hfzYxzxzW3HY3umrbtPcM1of3aNEcFQe3bvV+98PrqlsrwwmB0JKu8rM7/XI4z60XJ9ok9Xo
ZuneJ57a3jtm+Zv4c8nFZ994gvpbpmkKqemMdq0oNBktG+1XNu0yM3zAYD59cE4qtd6NIbli9vMp
PIDsucf99UaCag3dHo+C6/MTjvTgSASoHtRG5IIzg0Fij5GT25qDrDy3YDcBn60mSvYke1PDMSMd
6YzMAV460ADTIOOeO1KWVVG0ZJ9+lQ/MCfkLGkyrna6lW9RQgHOMqzjsPmH9arW8TapMJ5hm2jOI
0P8AEfU1XnJlnNrFK53cyt2VfT8au/a0gh8u2jLtGNuF/h9KtAW5WKfMCFUDmoPPWZCIzuIPWoY/
Nn+ecgbf4F6fiaRCyRnywkamgZXt1eDU5lZCUfDlj0FaLSEgBFJz6VlX8T+XHO8zJHG4Jzxmtph+
6DKfpQ+5MdNCqDLI+ETA9qcFWCQlvmc9h2q7GjugDkqO/YmqVwnlzMB07VM20tAbsitNcBW2vJ8x
6A9qEeLH+sUk+9MuIY3jMhh81gOFqpaRQyzMGsvK28gk9a55S6Iy63Zpbfc4q3ZuELIeh5FVgCeA
CT7VNFCwYM/GO1OnzXuWiRpSjjd91+nsaeOVUY4zyaiucyRhNpznIrOvLXUDMk8MzKUH+r7NXQtW
U3Y0+STz39KjlIDYKtjuajtjdSRAsArNyd/b8KseSzD95KXPYAYFDHcrLhlcp6EA4rjF1K9tnkIn
CAsFJ8sYOAc/0rueBlTwRxgVzusaKsUMtwVLKzNhQcAZHr+FCM6sbo4S7mFpcCd1aTzOSCcYNQED
U15Ah2KMlu9U7lt9wygl1B4JzzWuqRx2ZDEbwu87efbB7jvVC2RHLamC1WRWJjIAJIx9cCqyTeWj
CNef7w7ir01294kSFQluo2rgjj1/WoLyzjgmPlTGSNh2GOaBJ9yj9pLLtZDtznGe/ripoweGbYCT
2OCR6UpQLD9wEN13f41EERyoAYAd2NBdzrrp7XVtFiNnlXsxiSI8uB6+/rSab4oWy00213C5C5SM
rzxisS1ja2kSRJMSE/eHAPb+o56VduNMuYmL3MDJGxO3kYz7UjHlj8LN7SNS097YpcCMeYckN/Wr
U8MWYZbC7P38bPM49fw6fSuRtrOLVonDpdeZED5aoAceuR6VPDDb2rsrLL/eDO/A9v8A9eKLEyhr
dHUzRxTxuX2K5G0sMdfcf1FXbS/G1YbohJgMBs/K/uDXmf2+6UsFfA3HBA6fjV+x8QTW7tb3iG6t
3A3BhyPpiiwnRdj0O+w1hMN2AV4NecarfXQvmDTFyABleg9q6JoYJ7Xz7W4lECqSyeYQwPv1qoPD
8sqJMbi3zKu/52OefWhaCilHc7yIbTnOQ1TFN3JGayjb3MLKsEpK7gdsnXrzWqzlRk9PUVNrHYnc
RlkUblA96iMilc9ycc1YEirGxdgE9z0rNuL9LlvLsYWuHB5I4UfjRy9hlxCu05fFUrq9EhNvZjzZ
ejP/AAp9T3+lR/ZJ5iDeOWT/AJ5RcAfU96txxRIu2A+WgP3NtPoBFYwLBAe7HmRz1Y1ZgslkLOoC
c9MUixsgAA4Jyat2zERAY5JNVET7CLZhQeV/75qKWExEMyBh3xV05AyzY+lQlWlyMEL6nvVXC3Yz
9SkVrN44o9xIz61a0yM/YoXcNu2jAPani3jjxsbHrS+ZJHxwR71Ogtb3ZZJCjJOBWfdEyHei/KOM
+tJczsVUEnLHACipMP8AdUYUDqe9TNpqyBq5lXKF4h+9aMA5ypxmqkS3bSqfPZ1AIOVwK1JbRpJA
GdcZ5AqVLbbIYwMAdTXI6chcpJbki3+Xr3PrU+SF5pvyqOOAB0qEzAzGPPOM10LRWKJblgIT8xHs
DQf3q7d2Gx+VRPCsyqZAQEOfrUmdyAocEjvQMzbovaXJvFVnI++OnH19K0Le4+1RLKjrsP8Adpss
cvk/MUdmPToMUltbRW8eIUKjOSM96voSlZlsMgYfLj370y+iW9sprXzHj8xCpZeoqOSVYwWkYADu
aq212byZtoIHQUlLoUcBeeEJdJeSZ8XFsvRgcHNA0LU204PbwjY45GfmI9MH/PFd3dgXFyIo/uxE
FiegNT9Kps5K1XllZHlDJNasUuYGU9PmXFU5SzOcAAD07169Nbw3ClZokcH+8Kx7nwpp0uWiQwue
68gfhRcUa66o4G2ZXjlVly/GDViKOK8kTMhRF4YsM100VjbWdzJFPshiyFVimQxHXn0zU8FlZ3Gs
SZkhKCMMoj4APrRcp1UZ1hpbxCJlWLyGfb5jMB2P+H61szBZrRWuiIhE37oR/d49/WrEmmTSzFlk
ijRgM7Vzk+uOnpXPeItP1K3BZZma0XBz/iKW5knzvcv3WrWYwYbmbBUqehwT2yaYXsmtQEaUwO5/
1kmM4xnpyegFctcKkMcOGUllyxYjk1Es2wK33gp5IORmnY1VNdDsnm0K7heP7IqSAYH7vknt061y
izOlyEbJEZ53jp0B4NT2v2a3UTyXDtOGz5YBA+pNJe2twT9skK7ZuVYnr9P0oHFcuhHb3EcSOCDh
uSM4H4AcVeXX153JGOeBjtT7ezgjtDLqQ+aWP9yg/hPqatAadHHGsukrvCjJ3dfegG0+h3t3PDbr
5kp2rjq2MVmDU55VY2UBZP8AnpMdqf4mpF0fzZhLcTPNIOdz9voO1WI9PRpC0haQr03HikdJVTTl
kAlvLhrljzsA2op+g6/jVlTKi7UCKg4AVePwq6qbQQOlCROeuP8ACi4FOOB1fzHdsn9KtfKozjn1
NSNC+RtIx3qFXYu6OpJU8YFFmAwOWKgYHzdKlA2CVM4I5qNZBKZQq4VeAfU0984D/wB5dpqkJgiE
YZmLPjuelMmumV/LQF5P7opolCAPIcdsHrTokAZpc5LHPPas2xkEYlSeNp3LSOThAeFFTypLI3Eg
Ve/FIVH23zZHyWUqijtVSZlX5jBOzdstkUWQE/2Pc+5pJvoG4qaPeu4FcKowvOc1SiWUoBypPJHf
NTNA4i+aZhj0qQGwzObh/wB75hUdFGB9M1aPmjDsyqnfjJqlEsi+Y7OWCjgAYq3vZrWNVIDleM1S
2AQ3HzfLGxHUseBVGx33N1LcHGCdq+1WJ52giWIL5srD0qaBTFbqCFDY5x0pAS529TmkLZ+XOM+g
qKWYRqTncw7Cq0N3LNMU8oHA5YHgUXAsMN08fTAyBUpBVMDBP1xVBGdrrGThTzV6aURRGRucDgCi
+gjPubeeWQGQoV9Bxinlf7PspWjQtJt+VRyagtBNc3XmTnAHITP860JIg8kbMucc9KasMo2jxLGF
3Ylbllbhs/Q81aqV0iljbfEr/UVn27NbqlvKG3biAw5HcgZ+lM4atFx95alukYhVJPAFLVe95tXT
OPM+TP14oOdHDaibye8jdj+6nbfEVbPv296g1gKREWJldVCBj7d+uauaho62Rlnsp2FsDt2NyCO+
D7GsW5kkmdULZx0CnAAqjthZ2sdV4d8QRrbC0uhIPLHEp+YAehxUOpeKdJ1azmsmFzGSfvMoAyPo
Sf0rmrbM8qxtJ5cbnD45AHvU0sqoBHEEYDncEHX60WF7OPNcSRbZFCx+YW+8dznkY9MVJDBNI4SC
IqW6YG5v/rVHb+bPcYzvkP3lz1FdDao9ux8m2lZwuW4yD6jPcZoHJ2Kp8OXENm91MqoFG4hjlsd+
nT8KyhPJcIyRqxVEJBJOMd/pz/Oura9na3/fpO8T/Ku35Qv1qsulW8lv5EFxtndgSANozzznr/8A
qouQpv7Ry8ZuLzUBEZsPkIHLHCjtXQCy+zFoZHtp2U4LyOsZ+mM9PeuXmjksJZbeQMkqthmDYNb1
lZme0jkd0LEdXTn8abNGj1E8MFI6frUU13BCSCct6Ciik9joKhmu5smKEKp6FzTg12nUr+HSiisw
JPOugOQPzqJ3vZUIVUj3HGSR0oop3YD4FW3UQ5yepJqyiq0G3rziiinEClt3u3yFscdelSYlC4hC
49DmiilLcS2IShW7jkmcjA454z6U5ZYJZci4Jx2HSiikMmQokjKq8kZz60yYtImxUb5j16UUUARR
rGGeCNsE9ecmmtciGdYZBt4+RqKKaAbJewrJtQGSToTjgfjVqDzHTfJtXnO0c0UUkAGMSDhgqg54
70BYYiFGBk8Ad6KKAIpYkRmZfvSEDPpTdSmMdnsUgM3TJxRRSAj0qLyrdpX+Zn7+1X+W64B/lRRT
QFdpkgYhyMntWZEGuL/d9oIRP3gjHIPUf5+tFFC3Mq38NmlVS92DyWmIESv82TgdMD9aKKo8+O5k
3NnJd29zFAhKsxYYGBjOeOefyrkYrKWW8MWSSWwqjGc/SiiqR2qKUdCxLbpY3M0MqoxTAJzgg4yc
c/55rotC0i1uLIy3Fr1YgKx6D9KKKT2MqknZG7FY2kIxHbxr/wABFWKKKRhco3+nLeQsqP5bHuOm
fpWTp2nzPM0NwAIoX6qc54AwD+FFFD2NqGu5sR6dpwkMklpG7H+Jxk/rWgjBFCxIqp2CrxRRUJs7
Uf/Z