arcgisdb.DBO.UN_countries_BNDA_CTY_web Feature Class 217 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Feature geometry. ESRI Coordinates defining the features. Shape Geometry 8 0 0 ISO3CD ISO3CD String 3 0 0 ROMNAM ROMNAM String 254 0 0 CONTCD CONTCD String 3 0 0 MAPCLR MAPCLR String 3 0 0 STSCOD STSCOD SmallInteger 2 5 0 ece_id_coutry ece_id_coutry Integer 4 10 0 MAPLAB Cartographic Label String 255 0 0 Shape.STArea() Shape.STArea() Double 0 0 0 Shape.STLength() Shape.STLength() Double 0 0 0 20190115 16124800 FALSE 20200131 11343900 20200131 11343900 Union "'Y:\Projects\Database_QC\1mln\other datasets\bnd5.mdb\bnd5\UN_cntpoly_01_1' 1;'Y:\Projects\Database_QC\1mln\other datasets\bnd5.mdb\bnd5\salb_merge_1' 2;'Y:\Projects\Database_QC\1mln\other datasets\bnd5.mdb\bnd5\background_10' 3" "Y:\Projects\Database_QC\1mln\other datasets\bnd5.mdb\bnd5\salb_union5" ALL "0.000009 DecimalDegrees" NO_GAPS Union "'Y:\Projects\Database_QC\1mln\other datasets\Salb_final.gdb\salb_union5' #;'Y:\Projects\Database_QC\1mln\other datasets\Salb_final.gdb\Missing_countries' #" "Y:\Projects\Database_QC\1mln\other datasets\Salb_final.gdb\salb_union5_Union" ALL "0.000009 DecimalDegrees" NO_GAPS MultipartToSinglepart y_data\Salb_cnty "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep12" FeatureToPoint "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep12" "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" INSIDE AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" CONTCD TEXT # # 3 CONTCD NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ISO3CD TEXT # # 3 ISO3CD NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ROMNAM TEXT # # 256 ROMNAM NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" MAPCLR TEXT # # 3 MAPCLR NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" STSCOD SHORT # # # STSCOD NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM1CD TEXT # # 7 ADM1CD NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM1NM TEXT # # 256 ADM1NM NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM2CD TEXT # # 11 ADM2CD NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM2NM TEXT # # 256 ADM2NM NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" DATSOR TEXT # # 10 DATSOR NULLABLE NON_REQUIRED # AddField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADMSOR SHORT # # # ADMSOR NULLABLE NON_REQUIRED # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ISO3CD [ISO3_CODE] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ROMNAM [Terr_Name] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" MAPCLR [ISO3_CODE] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM1CD "Left( [ADM1_CODE],3 ) & "-" & Right( [ADM1_CODE],3 )" VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM1NM [ADM1_NAME] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM2CD "Left( [ADM2_CODE],3 ) & "-" & Mid( [ADM2_CODE],4,3 ) & "-" & Right( [ADM2_CODE],3 )" VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" ADM2NM [ADM2_NAME] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" DATSOR time.strftime('%d/%m/%Y') PYTHON_9.3 # DeleteField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" FID_salb_union5;FID_UN_cntpoly_01_1;ISO3_CODE;STATUS;CAPITAL;Terr_ID;Terr_Name;Color_Code;FID_background_10;FID_salb_merge_1;CNTRY_NAME;CNTRY_CODE;ADM1_NAME;ADM1_CODE;ADM2_NAME;ADM2_CODE;CNTRY_NAM_;FID_Missing_countries;ISO3_CODE_1;STATUS_1;CAPITAL_1;Terr_ID_1;Terr_Name_1;Color_Code_1;Shape_Leng;ORIG_FID;CONTCD DeleteField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" FID_salb_union5;FID_UN_cntpoly_01_1;ISO3_CODE;STATUS;CAPITAL;Terr_ID;Terr_Name;Color_Code;FID_background_10;FID_salb_merge_1;CNTRY_NAME;CNTRY_CODE;ADM1_NAME;ADM1_CODE;ADM2_NAME;ADM2_CODE;CNTRY_NAM_;FID_Missing_countries;ISO3_CODE_1;STATUS_1;CAPITAL_1;Terr_ID_1;Terr_Name_1;Color_Code_1;Shape_Leng;ORIG_FID FeatureClassToFeatureClass "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13" "C:\UN GIS WORK\T SALB\Y data\TEST" Salb_cnty_03101.shp # "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_MultipartToSinglep13,ADMSOR,-1,-1" # SpatialJoin Salb_cnty_03101 cnt_ply_01 "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19" JOIN_ONE_TO_ONE KEEP_ALL "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,Salb_cnty_03101,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,Salb_cnty_03101,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,Salb_cnty_03101,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,Salb_cnty_03101,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 5 Short 0 5 ,First,#,Salb_cnty_03101,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,Salb_cnty_03101,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,Salb_cnty_03101,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,Salb_cnty_03101,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,Salb_cnty_03101,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,Salb_cnty_03101,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 5 Short 0 5 ,First,#,Salb_cnty_03101,ADMSOR,-1,-1;ISO3_CODE "ISO3_CODE" true true false 3 Text 0 0 ,First,#,cnt_ply_01,ISO3_CODE,-1,-1;STATUS "STATUS" true true false 37 Text 0 0 ,First,#,cnt_ply_01,STATUS,-1,-1;CAPITAL "CAPITAL" true true false 22 Text 0 0 ,First,#,cnt_ply_01,CAPITAL,-1,-1;Terr_ID "Terr_ID" true true false 2 Short 0 0 ,First,#,cnt_ply_01,Terr_ID,-1,-1;Terr_Name "Terr_Name" true true false 50 Text 0 0 ,First,#,cnt_ply_01,Terr_Name,-1,-1;Color_Code "Color_Code" true true false 3 Text 0 0 ,First,#,cnt_ply_01,Color_Code,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,cnt_ply_01,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,cnt_ply_01,Shape_Area,-1,-1;test "3" true true false 2 Short 0 0 ,First,#,cnt_ply_01,test,-1,-1;test1 "test1" true true false 256 Text 0 0 ,First,#,cnt_ply_01,test1,-1,-1" WITHIN # # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19" STATUS !STATUS!.replace("Member State","1") PYTHON_9.3 # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19" STATUS !STATUS!.replace("PT Territory","11") PYTHON_9.3 # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19" STSCOD [STATUS] VB # FeatureClassToFeatureClass "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19" "C:\UN GIS WORK\T SALB\Y data\TEST" SALB_0316.shp # "Join_Count "Join_Count" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,TARGET_FID,-1,-1;CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ADMSOR,-1,-1;ISO3_CODE "ISO3_CODE" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,ISO3_CODE,-1,-1;STATUS "STATUS" true true false 37 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,STATUS,-1,-1;CAPITAL "CAPITAL" true true false 22 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,CAPITAL,-1,-1;Terr_ID "Terr_ID" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,Terr_ID,-1,-1;Terr_Name "Terr_Name" true true false 50 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,Terr_Name,-1,-1;Color_Code "Color_Code" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,Color_Code,-1,-1;test "3" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,test,-1,-1;test1 "test1" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\Salb_cnty_03101_SpatialJoin19,test1,-1,-1" # SpatialJoin "C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp" VALIDATED "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1" JOIN_ONE_TO_ONE KEEP_ALL "Join_Count "Join_Count" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,TARGET_FID,-1,-1;CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ADMSOR,-1,-1;ISO3_CODE "ISO3_CODE" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,ISO3_CODE,-1,-1;STATUS "STATUS" true true false 37 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,STATUS,-1,-1;CAPITAL "CAPITAL" true true false 22 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,CAPITAL,-1,-1;Terr_ID "Terr_ID" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,Terr_ID,-1,-1;Terr_Name "Terr_Name" true true false 50 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,Terr_Name,-1,-1;Color_Code "Color_Code" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,Color_Code,-1,-1;test "3" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,test,-1,-1;test1 "test1" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Y data\TEST\SALB_0316.shp,test1,-1,-1;ADMSOR_1 "ADMSOR_1" true true false 5 Short 0 5 ,First,#,VALIDATED,ADMSOR,-1,-1" WITHIN # # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1" ADMSOR [ADMSOR_1] VB # CalculateField "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1" ADMSOR [ADMSOR_1] VB # SpatialJoin "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1" under_validated "C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1_Spati" JOIN_ONE_TO_ONE KEEP_ALL "Join_Count "Join_Count" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,TARGET_FID,-1,-1;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,Join_Count_1,-1,-1;TARGET_FID_1 "TARGET_FID_1" true true false 4 Long 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,TARGET_FID_1,-1,-1;CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADMSOR,-1,-1;ISO3_CODE "ISO3_CODE" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ISO3_CODE,-1,-1;STATUS "STATUS" true true false 37 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,STATUS,-1,-1;CAPITAL "CAPITAL" true true false 22 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,CAPITAL,-1,-1;Terr_ID "Terr_ID" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,Terr_ID,-1,-1;Terr_Name "Terr_Name" true true false 50 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,Terr_Name,-1,-1;Color_Code "Color_Code" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,Color_Code,-1,-1;test "3" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,test,-1,-1;test1 "test1" true true false 256 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,test1,-1,-1;ADMSOR_1 "ADMSOR_1" true true false 2 Short 0 0 ,First,#,C:\UN GIS WORK\T SALB\Data convention\UNdata.gdb\SALB_0316_SpatialJoin1,ADMSOR_1,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,under_validated,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,under_validated,Shape_Area,-1,-1;ADMSOR_undervalidated "ADMSOR_undervalidated" true true false 2 Short 0 0 ,First,#,under_validated,ADMSOR_undervalidated,-1,-1" INTERSECT # # CalculateField SALB_0316_SpatialJoin1_Spati ADMSOR [ADMSOR_undervalidated] VB # DeleteField SALB_0316_SpatialJoin1_Spati Join_Count;TARGET_FID;Join_Count_1;TARGET_FID_1;Join_Count_12;TARGET_FID_12 FeatureClassToFeatureClass SALB_0316_SpatialJoin1_Spati "C:\UN GIS WORK\T SALB\PRODUCT" BNDP_03172017.shp # "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADMSOR,-1,-1;ISO3_CODE "ISO3_CODE" true true false 3 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ISO3_CODE,-1,-1;STATUS "STATUS" true true false 37 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,STATUS,-1,-1;CAPITAL "CAPITAL" true true false 22 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,CAPITAL,-1,-1;Terr_ID "Terr_ID" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,Terr_ID,-1,-1;Terr_Name "Terr_Name" true true false 50 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,Terr_Name,-1,-1;Color_Code "Color_Code" true true false 3 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,Color_Code,-1,-1;test "3" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,test,-1,-1;test1 "test1" true true false 256 Text 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,test1,-1,-1;ADMSOR_1 "ADMSOR_1" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADMSOR_1,-1,-1;ADMSOR_und "ADMSOR_und" true true false 2 Short 0 0 ,First,#,SALB_0316_SpatialJoin1_Spati,ADMSOR_undervalidated,-1,-1" # DeleteField "C:\UN GIS WORK\T SALB\PRODUCT\BNDP_03172017.shp" ISO3_CODE;STATUS;CAPITAL;Terr_ID;Terr_Name;Color_Code;test;test1;ADMSOR_1;ADMSOR_und CalculateField BNDP_03172017 CONTCD "AFR" VB # CopyFeatures "C:\UN GIS WORK\T SALB\PRODUCT\BNDP_03172017.shp" "C:\UN GIS WORK\T SALB\NEW\UNdata.gdb\UNmap0\BNDP_03172017" # 0 0 0 Merge BNDP_03172017;'C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp' "C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp" "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,BNDP_03172017,CONTCD,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,BNDP_03172017,ISO3CD,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,BNDP_03172017,ROMNAM,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,BNDP_03172017,MAPCLR,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,BNDP_03172017,STSCOD,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,BNDP_03172017,ADM1CD,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,BNDP_03172017,ADM1NM,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,BNDP_03172017,ADM2CD,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,BNDP_03172017,ADM2NM,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,BNDP_03172017,DATSOR,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,BNDP_03172017,ADMSOR,-1,-1,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADMSOR,-1,-1;ADM1_CD "ADM1_CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADM1_CD,-1,-1;OBJECTID "OBJECTID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,OBJECTID,-1,-1;ADMDAT "ADMDAT" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ADMDAT,-1,-1;ORIG_FID "ORIG_FID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,ORIG_FID,-1,-1;OBJECTID_1 "OBJECTID_1" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\YProjectsCORE03_SALB CORE\UN_VALIDATED\BNDP_UNvalidated_13.shp,OBJECTID_1,-1,-1" Merge 'C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp';BNDP_NER_ADMCDcoded C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNVALIDATED_REPLACE_Mer "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ISO3CD,-1,-1,BNDP_NER_ADMCDcoded,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ROMNAM,-1,-1,BNDP_NER_ADMCDcoded,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,MAPCLR,-1,-1,BNDP_NER_ADMCDcoded,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 5 Short 0 5 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,STSCOD,-1,-1,BNDP_NER_ADMCDcoded,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADM1CD,-1,-1,BNDP_NER_ADMCDcoded,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADM1NM,-1,-1,BNDP_NER_ADMCDcoded,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADM2CD,-1,-1,BNDP_NER_ADMCDcoded,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADM2NM,-1,-1,BNDP_NER_ADMCDcoded,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,DATSOR,-1,-1,BNDP_NER_ADMCDcoded,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 5 Short 0 5 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADMSOR,-1,-1,BNDP_NER_ADMCDcoded,ADMSOR,-1,-1;ADM1_CD "ADM1_CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADM1_CD,-1,-1;OBJECTID "OBJECTID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,OBJECTID,-1,-1,BNDP_NER_ADMCDcoded,OBJECTID,-1,-1;ADMDAT "ADMDAT" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ADMDAT,-1,-1,BNDP_NER_ADMCDcoded,ADMDAT,-1,-1;ORIG_FID "ORIG_FID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,ORIG_FID,-1,-1;OBJECTID_1 "OBJECTID_1" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\PRODUCT\BNDP_UNVALIDATED_REPLACE.shp,OBJECTID_1,-1,-1" Erase BNDP_UNVALIDATED_REPLACE C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge "C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp" # Merge 'C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp';C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge "C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE_ok.shp" "OBJECTID_1 "OBJECTID_1" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,OBJECTID_1,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,OBJECTID_1,-1,-1;CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,CONTCD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ISO3CD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ROMNAM,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,MAPCLR,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 5 Short 0 5 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,STSCOD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,STSCOD,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADM1CD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADM1CD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADM1NM,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADM1NM,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADM2CD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADM2CD,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADM2NM,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,DATSOR,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 5 Short 0 5 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADMSOR,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADMSOR,-1,-1;ADM1_CD "ADM1_CD" true true false 7 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADM1_CD,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADM1_CD,-1,-1;OBJECTID "OBJECTID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,OBJECTID,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,OBJECTID,-1,-1;ADMDAT "ADMDAT" true true false 10 Text 0 0 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ADMDAT,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ADMDAT,-1,-1;ORIG_FID "ORIG_FID" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,ORIG_FID,-1,-1,C:\Users\Ji.Liu\Documents\ArcGIS\Default.gdb\BNDP_UNvalidated_13_Merge,ORIG_FID,-1,-1;OBJECTID_2 "OBJECTID_2" true true false 10 Long 0 10 ,First,#,C:\UN GIS WORK\T SALB\TO GLS\BNDP_UNVALIDATED2_REPLACE.shp,OBJECTID_2,-1,-1" CalculateField BNDP_UNVALIDATEDSALB_REPLCE ISO3CD "PRT" VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE MAPCLR "PRT" VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE CONTCD "EUR" VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE ISO3CD "PRT" VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE MAPCLR "PRT" VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE MAPCLR [ISO3CD] VB # CalculateField BNDP_UNVALIDATEDSALB_REPLCE STSCOD 1 VB # DeleteField BNDP_UNVALIDATEDSALB_REPLCE OBJECTID_1;ADM1_CD;OBJECTID;ADMDAT;ORIG_FID;OBJECTID_2 CalculateField BNDP_SALB ROMNAM "Czechia" VB # CalculateField BNDP_SALB ROMNAM "Argentina" VB # CalculateField BNDP ROMNAM "Iran (Islamic Republic of)" VB # CalculateField BNDP CONTCD "--" VB # CalculateField BNDP CONTCD "--" VB # CalculateField BNDP ROMNAM "Antarctica" VB # CalculateField BNDP MAPCLR "ATA" VB # CalculateField BNDP STSCOD 4 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ISO3CD "GRL" VB # CalculateField BNDP ROMNAM "Greenland" VB # CalculateField BNDP CONTCD "--" VB # CalculateField BNDP ISO3CD "GRL" VB # CalculateField BNDP ISO3CD "GRL" VB # CalculateField BNDP CONTCD "--" VB # CalculateField BNDP ISO3CD "GRL" VB # CalculateField BNDP ROMNAM "Greenland" VB # CalculateField BNDP MAPCLR "GRL" VB # CalculateField BNDP STSCOD 16 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ROMNAM "Chile" VB # CalculateField BNDP MAPCLR "CHL" VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ROMNAM "Argentina" VB # CalculateField BNDP MAPCLR "ARG" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ROMNAM "Brazil" VB # CalculateField BNDP MAPCLR "BRA" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP MAPCLR "JPN" VB # CalculateField BNDP ROMNAM "Japan" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ROMNAM "Mexico" VB # CalculateField BNDP MAPCLR "MEX" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ISO3CD "ATF" VB # CalculateField BNDP ROMNAM "French Southern and Antarctic Territories" VB # CalculateField BNDP MAPCLR "FRA" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP STSCOD 3 VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "India" VB # CalculateField BNDP MAPCLR "IND" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "NZL" VB # CalculateField BNDP ROMNAM "New Zealand" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP ROMNAM "Tonga" VB # CalculateField BNDP MAPCLR "TON" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP MAPCLR "FJI" VB # CalculateField BNDP ROMNAM "Fiji" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP ROMNAM "Solomon Islands" VB # CalculateField BNDP MAPCLR "SLB" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "PNG" VB # CalculateField BNDP ROMNAM "Papua New Guinea" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP ROMNAM "Kiribati" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP MAPCLR "KIR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "Indonesia" VB # CalculateField BNDP MAPCLR "IDN" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ROMNAM "United Republic of Tanzania" VB # CalculateField BNDP MAPCLR "TZA" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ROMNAM "Seychelles" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP MAPCLR "SYC" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "TUV" VB # CalculateField BNDP ROMNAM "Tuvalu" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Angola" VB # CalculateField BNDP MAPCLR "AGO" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "Malaysia" VB # CalculateField BNDP MAPCLR "MYS" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "ECU" VB # CalculateField BNDP ROMNAM "Ecuador" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP ROMNAM "Marshall Islands" VB # CalculateField BNDP MAPCLR "MHL" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADM1CD "<Null>" VB # CalculateField BNDP ROMNAM "Micronesia (Federated States of)" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP MAPCLR "FSM" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Thailand" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "ASI" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Viet Nam" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "VNM" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Venezuela" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP MAPCLR "VEN" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "MMR" VB # CalculateField BNDP ROMNAM "Myanmar" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "MMR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Netherlands" VB # CalculateField BNDP MAPCLR "NLD" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Eritrea" VB # CalculateField BNDP MAPCLR "ERI" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Saudi Arabia" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "SAU" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Russian Federation" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP MAPCLR "RUS" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Svalbard and Jan Mayen Islands" VB # CalculateField BNDP MAPCLR "SJM" VB # CalculateField BNDP STSCOD 7 VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP MAPCLR "NOR" VB # CalculateField BNDP ISO3CD "SJM" VB # CalculateField BNDP ROMNAM "Iceland" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP MAPCLR "ISL" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Ireland" VB # CalculateField BNDP MAPCLR "IRL" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Belgium" VB # CalculateField BNDP ROMNAM "Cuba" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP MAPCLR "CUB" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "China" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "CHN" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Sudan" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP MAPCLR "SDN" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ROMNAM "Egypt" VB # CalculateField BNDP MAPCLR "EGY" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "Oman" VB # CalculateField BNDP MAPCLR "OMN" VB # CalculateField BNDP MAPCLR "PAK" VB # CalculateField BNDP ROMNAM "Pakistan" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "United Arab Emirates" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "PAK" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "KOR" VB # CalculateField BNDP ROMNAM "Republic of Korea" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPCLR "TUN" VB # CalculateField BNDP ROMNAM "Tunisia" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ROMNAM "Italy" VB # CalculateField BNDP MAPCLR "ITA" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "Turkey" VB # CalculateField BNDP MAPCLR "TUR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM ""Democratic People's Republic of Korea"" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "PRK" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP ROMNAM "Croatia" VB # CalculateField BNDP MAPCLR "HRV" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Ukraine" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP MAPCLR "UKR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "French Polynesia" VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP ISO3CD "PYF" VB # CalculateField BNDP MAPCLR "FRA" VB # CalculateField BNDP STSCOD 3 VB # CalculateField BNDP ROMNAM "New Caledonia" VB # CalculateField BNDP ISO3CD "NCL" VB # CalculateField BNDP MAPCLR "FRA" VB # CalculateField BNDP STSCOD 9 VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP STSCOD 9 VB # CalculateField BNDP ROMNAM "U.K. of Great Britain & Northern Ireland" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP ISO3CD "GBR" VB # CalculateField BNDP MAPCLR "GBR" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "United Kingdom of Great Britain & Northern Ireland" VB # CalculateField BNDP ROMNAM "United States Virgin Island" VB # CalculateField BNDP ISO3CD "VIR" VB # CalculateField BNDP MAPCLR "VIR" VB # CalculateField BNDP STSCOD 15 VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ROMNAM "British Virgin Islands" VB # CalculateField BNDP ISO3CD "VGB" VB # CalculateField BNDP MAPCLR "VGB" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP STSCOD 5 VB # CalculateField BNDP ROMNAM ""'Falkland Islands (Malvinas)"" VB # CalculateField BNDP ISO3CD "FLK" VB # CalculateField BNDP MAPCLR "FLK" VB # CalculateField BNDP STSCOD 5 VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ROMNAM "Falkland Islands (Malvinas)" VB # CalculateField BNDP ROMNAM "South Georgia & the South Sandwich Islands" VB # CalculateField BNDP ISO3CD "SGS" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP MAPCLR "GBR" VB # CalculateField BNDP STSCOD 8 VB # CalculateField BNDP ROMNAM "Turks and Caicos Islands" VB # CalculateField BNDP ISO3CD "TCA" VB # CalculateField BNDP MAPCLR "TCA" VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP STSCOD 5 VB # CalculateField BNDP ROMNAM "British Indian Ocean Territory" VB # CalculateField BNDP ISO3CD "IOT" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP MAPCLR "GBR" VB # CalculateField BNDP STSCOD 8 VB # CalculateField BNDP ROMNAM "Northern Mariana Islands" VB # CalculateField BNDP ISO3CD "MNP" VB # CalculateField BNDP MAPCLR "MNP" VB # CalculateField BNDP STSCOD 6 VB # CalculateField BNDP CONTCD "OCE" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP ROMNAM "Qatar" VB # CalculateField BNDP DATSOR "01/01/2017" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2009" VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2009" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2009" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP DATSOR "01/01/2003" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP DATSOR "01/01/2003" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP DATSOR "01/01/2009" VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP DATSOR "01/01/2003" VB # CalculateField BNDP DATSOR "01/01/2003" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP DATSOR "01/06/2006" VB # CalculateField BNDP DATSOR "01/06/2005" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2010" VB # CalculateField BNDP DATSOR "01/01/2005" VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2009" VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2006" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP DATSOR "01/05/2008" VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2007" VB # CalculateField BNDP DATSOR "01/01/2004" VB # CalculateField BNDP ADM1CD "" VB # CalculateField BNDP MAPCLR "ARE" VB # CalculateField BNDP ROMNAM "French Southern Territories" VB # CalculateField BNDP MAPCLR "FRA" VB # CalculateField BNDP ROMNAM "Cabo Verde" VB # CalculateField BNDP ROMNAM "Bolivia (Plurinational State of)" VB # CalculateField BNDP ROMNAM "Åland Islands" VB # CalculateField BNDP ISO3CD "ALA" VB # CalculateField BNDP ISO3CD "HKG" VB # CalculateField BNDP ROMNAM "Hong Kong, SAR China" VB # CalculateField BNDP STSCOD 13 VB # CalculateField BNDP MAPCLR "NZL" VB # CalculateField BNDP MAPCLR "DNK" VB # CalculateField BNDP MAPCLR "GBR" VB # CalculateField BNDP MAPCLR "THA" VB # CalculateField BNDP STSCOD 14 VB # CalculateField BNDP ROMNAM "China" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 2 VB # CalculateField BNDP STSCOD 3 VB # CalculateField BNDP STSCOD 5 VB # CalculateField BNDP STSCOD 6 VB # CalculateField BNDP STSCOD 10 VB # CalculateField BNDP STSCOD 9 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ROMNAM "Hong Kong" VB # CalculateField BNDP DATSOR "01/01/2002" VB # CalculateField BNDP DATSOR "01/01/2001" VB # CalculateField BNDP DATSOR "01/05/2015" VB # CalculateField BNDP ADM2CD "N/A" VB # CalculateField BNDP ADM2NM "N/A" VB # CalculateField BNDP TEMP "Under National Administration" VB # CalculateField BNDP ADM1NM "" VB # CalculateField BNDP ADM2NM "" VB # CalculateField BNDP ADM1NM [TEMP] VB # CalculateField BNDP ADM2NM [TEMP] VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP ISO3CD "ISL" VB # CalculateField BNDP ROMNAM "Iceland" VB # CalculateField BNDP MAPCLR "ISL" VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP DATSOR "04/10/2016" VB # CalculateField BNDP DATSOR "01/07/2003" VB # CalculateField BNDP DATSOR "01/11/2016" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP ROMNAM "South Georgia and the South Sandwich Islands" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP ADM1NM [ADM2NM] VB # CalculateField BNDP ADM2NM [ADM2CD] VB # CalculateField BNDP ADM1CD "ISL000" VB # CalculateField BNDP CONTCD "EUR" VB # CalculateField BNDP ISO3CD "SVN" VB # CalculateField BNDP ROMNAM "Slovenia" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP ADM2NM "N/A" VB # CalculateField BNDP ADM2CD "N/A" VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP STSCOD 8 VB # CalculateField BNDP STSCOD 0 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 99 VB # CalculateField BNDP STSCOD 98 VB # CalculateField BNDP STSCOD 0 VB # CalculateField BNDP STSCOD 97 VB # CalculateField BNDP STSCOD 96 VB # CalculateField BNDP STSCOD 95 VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP STSCOD 2 VB # CalculateField BNDP STSCOD 3 VB # CalculateField BNDP STSCOD 4 VB # CalculateField BNDP STSCOD 97 VB # CalculateField BNDP STSCOD 99 VB # CalculateField BNDP STSCOD 4 VB # CalculateField BNDP STSCOD 5 VB # CalculateField BNDP STSCOD 6 VB # CalculateField BNDP STSCOD 99 VB # CalculateField BNDP STSCOD 3 VB # CalculateField BNDP STSCOD 2 VB # CalculateField BNDP DATSOR "27/09/2017" VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP MAPLAB "Greenland (Denmark)" VB # CalculateField BNDP MAPLAB "Faroe Islands (Denmark)" VB # CalculateField BNDP MAPLAB "Guadeloupe (Fr.)" VB # CalculateField BNDP MAPLAB "Martinique (Fr.)" VB # CalculateField BNDP MAPLAB "French Guiana (Fr.)" VB # CalculateField BNDP MAPLAB "Mayotte (Fr.)" VB # CalculateField BNDP MAPLAB "French Southern Territories (Fr.)" VB # CalculateField BNDP MAPLAB "Cook Islands (NZ)" VB # CalculateField BNDP MAPLAB "Svalbard & Jan Mayen Is. (Norw.)" VB # CalculateField BNDP MAPLAB "Azores Is. (Port.)" VB # CalculateField BNDP MAPLAB "Cayman Is. (UK)" VB # CalculateField BNDP MAPLAB "Northern Mariana Is. (USA)" VB # CalculateField BNDP MAPLAB "Puerto Rico (USA)" VB # CalculateField BNDP ROMNAM "Saint Kitts and Nevis" VB # CalculateField BNDP MAPLAB "Saint Kitts and Nevis" VB # CalculateField BNDP MAPLAB "Hong Kong, SAR China" VB # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ISO3CD "LSO" VB # CalculateField BNDP ROMNAM "Lesotho" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP ADMSOR "30/08/2017" VB # CalculateField BNDP DATSOR "30/08/2017" VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP MAPLAB "Lesotho" VB # CalculateField BNDP ISO3CD "PHL" VB # Append joinedPHL_tb BNDP NO_TEST "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,joinedPHL_tb,CONTCD,-1,-1;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,joinedPHL_tb,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,joinedPHL_tb,ROMNAM,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,joinedPHL_tb,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,joinedPHL_tb,STSCOD,-1,-1;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,joinedPHL_tb,ADM1NM,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,joinedPHL_tb,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#,joinedPHL_tb,DATSOR,-1,-1;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#,joinedPHL_tb,ADMSOR,-1,-1;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,joinedPHL_tb,ADM1CD,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,joinedPHL_tb,ADM2CD,-1,-1;MAPLAB "Cartographic Label" true true false 256 Text 0 0 ,First,#,joinedPHL_tb,MAPLAB,-1,-1" # CalculateField BNDP ADM1CD [ADM2CD] VB # CalculateField BNDP ADM1CD "PHL024" VB # CalculateField BNDP CONTCD "ASI" VB # CalculateField BNDP DATSOR "13/10/2017" VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP ADM2CD [ADM1CD] VB # CalculateField BNDP ADM2CD "PHL016005" VB # CalculateField BNDP ADM1NM "Maseru" VB # CalculateField BNDP ADM1NM "Mafeteng" VB # CalculateField BNDP ADM1NM ""Mohale's Hoek"" VB # CalculateField BNDP ADM1NM "Quthing" VB # CalculateField BNDP ADM1NM ""Qacha's-Nek"" VB # CalculateField BNDP ADM1NM "Thaba Tseka" VB # CalculateField BNDP ADM1NM "Mokhotlong" VB # CalculateField BNDP ADM1NM "Butha-Buthe" VB # CalculateField BNDP ADM1NM "Leribe" VB # CalculateField BNDP ADM1NM "Teya Teyaneng" VB # CalculateField BNDP DATSOR "16/10/2017" VB # CalculateField BNDP DATSOR "16/10/2017" VB # CalculateField BNDP ROMNAM "Philippines" VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP MAPLAB "Turks and Caicos Islands (U.K.)" VB # CalculateField BNDP MAPLAB "British Virgin Islands (U.K.)" VB # CalculateField BNDP MAPLAB "United States Virgin Islands (U.K.)" VB # CalculateField BNDP MAPLAB "[ROMNAM] + " (U.K.)"" VB # CalculateField BNDP MAPLAB [ROMNAM]+" U.K." VB # CalculateField BNDP MAPLAB [ROMNAM]+" (U.K.)" VB # CalculateField BNDP MAPLAB [ROMNAM]+" (U.S.A.)" VB # CalculateField BNDP MAPLAB [ROMNAM]+" (Fr.)" VB # CalculateField BNDP ROMNAM "Pitcairn" VB # CalculateField BNDP MAPLAB "Pitcairn (U.K.)" VB # CalculateField BNDP MAPLAB "[ROMNAM] +" (Fr.)"" VB # CalculateField BNDP ADM1NM "Obalno-kraška" VB # CalculateField BNDP ADM1NM "Gorenjska" VB # CalculateField BNDP ADM1NM "Notranjsko-kraška" VB # CalculateField BNDP ADM1NM "Osrednjeslovenska" VB # CalculateField BNDP ADM1NM "Zasavska" VB # CalculateField BNDP ADM1NM "Savinjska" VB # CalculateField BNDP ADM1NM "Koroška" VB # CalculateField BNDP ADM1NM "Podravska" VB # CalculateField BNDP ADM1NM "Pomurska" VB # CalculateField BNDP ADM1NM "Spodnjeposavska" VB # CalculateField BNDP ADM2NM "Under National Administration" VB # CalculateField BNDP ADM1NM "Under National Administration" VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP MAPLAB [ROMNAM]+" (U.S.A.)" VB # CalculateField BNDP TMP [MAPLAB] VB # CalculateField BNDP MAPLAB [TMP] VB # CalculateField BNDP_1201 TYP005 2 VB # CalculateField BNDP_1201 TYP025 2 VB # CalculateField BNDP_1201 DEL025 0 VB # CalculateField BNDP_1201 DEL025 0 VB # CalculateField BNDP ROMNAM "Canary Islands" VB # CalculateField BNDP MAPLAB "Canary Is. (Sp.)" VB # CalculateField BNDP ROMNAM "Chagos Archipelago" VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP ROMNAM "Canary Islands" VB # CalculateField BNDP MAPLAB "Canary Is. (Sp.)" VB # CalculateField BNDP ROMNAM "Chagos Archipelagio" VB # CalculateField BNDP MAPLAB "Chagos Archipelagio" VB # CalculateField BNDP MAPLAB "Chagos Archipelagio **" VB # CalculateField BNDP MAPLAB "Falkland Islands (Malvinas) ***" VB # CalculateField BNDP TYP025 2 VB # Append CIV_reg33 BNDP NO_TEST "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,CIV_reg33,ADM1NM,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,CIV_reg33,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,CIV_reg33,ADM1CD,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,CIV_reg33,ADM2CD,-1,-1;MAPLAB "Cartographic Label" true true false 255 Text 0 0 ,First,#;TYP005 "TYP005" true true false 2 Short 0 0 ,First,#;TYP025 "TYP025" true true false 2 Short 0 0 ,First,#;DEL025 "DEL025" true true false 2 Short 0 0 ,First,#" # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ISO3CD "CIV" VB # CalculateField BNDP ROMNAM ""Côte d'Ivoire"" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP DATSOR "29/11/2017" VB # CalculateField BNDP TYP005 2 VB # CalculateField BNDP TYP025 2 VB # CalculateField BNDP DEL025 0 VB # Append lbr_adm BNDP NO_TEST "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,lbr_adm,ADM1NM,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,lbr_adm,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,lbr_adm,ADM1CD,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,lbr_adm,ADM2CD,-1,-1;MAPLAB "Cartographic Label" true true false 255 Text 0 0 ,First,#;TYP005 "TYP005" true true false 2 Short 0 0 ,First,#;TYP025 "TYP025" true true false 2 Short 0 0 ,First,#;DEL025 "DEL025" true true false 2 Short 0 0 ,First,#" # CalculateField BNDP CONTCD "AFR" VB # CalculateField BNDP ISO3CD "LBR" VB # CalculateField BNDP ROMNAM "Liberia" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP DATSOR 3 VB # CalculateField BNDP ADMSOR "01/01/2018" VB # CalculateField BNDP DATSOR "01/01/2018" VB # CalculateField BNDP ADMSOR 3 VB # CalculateField BNDP MAPLAB "Liberia" VB # CalculateField BNDP TYP005 0 VB # CalculateField BNDP TYP025 0 VB # CalculateField BNDP DEL025 0 VB # CalculateField BNDP ADMSOR 1 VB # CalculateField BNDP ADM1NM "Baghdād" VB # Append 'Y:\Temp\Lotus\Mexico DB.gdb\BND_Mexico_WGS84\BNDP_Mexico_WGS84' BNDP NO_TEST "CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#;ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#;ADM1NM "ADM1NM" true true false 254 Text 0 0 ,First,#,Y:\Temp\Lotus\Mexico DB.gdb\BND_Mexico_WGS84\BNDP_Mexico_WGS84,ADM1NM,-1,-1;ADM2NM "ADM2NM" true true false 254 Text 0 0 ,First,#,Y:\Temp\Lotus\Mexico DB.gdb\BND_Mexico_WGS84\BNDP_Mexico_WGS84,ADM2NM,-1,-1;DATSOR "DATSOR" true true false 10 Text 0 0 ,First,#;ADMSOR "ADMSOR" true true false 2 Short 0 0 ,First,#;ADM1CD "ADM1CD" true true false 7 Text 0 0 ,First,#,Y:\Temp\Lotus\Mexico DB.gdb\BND_Mexico_WGS84\BNDP_Mexico_WGS84,ADM1CD,-1,-1;ADM2CD "ADM2CD" true true false 11 Text 0 0 ,First,#,Y:\Temp\Lotus\Mexico DB.gdb\BND_Mexico_WGS84\BNDP_Mexico_WGS84,ADM2CD,-1,-1;MAPLAB "Cartographic Label" true true false 255 Text 0 0 ,First,#;TYP005 "TYP005" true true false 2 Short 0 0 ,First,#;TYP025 "TYP025" true true false 2 Short 0 0 ,First,#;DEL025 "DEL025" true true false 2 Short 0 0 ,First,#" # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ISO3CD "MEX" VB # CalculateField BNDP ROMNAM "Mexico" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP DATSOR "01/01/2018" VB # CalculateField BNDP DATSOR "13/11/2017" VB # CalculateField BNDP ADMSOR 2 VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP TYP005 2 VB # CalculateField BNDP TYP025 2 VB # CalculateField BNDP DEL025 0 VB # CalculateField BNDP CONTCD "AME" VB # CalculateField BNDP ISO3CD "MEX" VB # CalculateField BNDP ROMNAM "Mexico" VB # CalculateField BNDP MAPCLR [ISO3CD] VB # CalculateField BNDP STSCOD 1 VB # CalculateField BNDP MAPLAB [ROMNAM] VB # CalculateField BNDP TYP005 0 VB # CalculateField BNDP TYP025 0 VB # CalculateField BNDP DEL025 2 VB # CalculateField BNDP TYP025 2 VB # CalculateField BNDP TYP005 2 VB # CalculateField BNDP DEL025 0 VB # FeatureToPolygon 'Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDL_copy3' "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_A2_temp" # ATTRIBUTES "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDP" Dissolve "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_A2_temp" "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" ISO3CD;ROMNAM;MAPLAB "CONTCD FIRST;MAPCLR FIRST;STSCOD FIRST;TYP005 FIRST;TYP025 FIRST;DEL025 FIRST" MULTI_PART DISSOLVE_LINES AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_CONTCD CONTCD CONTCD TEXT 3 NULLABLE false AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_MAPCLR MAPCLR MAPCLR TEXT 3 NULLABLE false AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_STSCOD STSCOD STSCOD SHORT 2 NULLABLE false AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_TYP005 TYP005 TYP005 SHORT 2 NULLABLE false AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_TYP025 TYP025 TYP025 SHORT 2 NULLABLE false AlterField "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" FIRST_DEL025 DEL025 DEL025 SHORT 2 NULLABLE false DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\scratch.gdb\BNDA_CTY "Database Connections\NYVM2946-UNmap_internal-SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # TruncateTable "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # DeleteRows "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" Append C:\Users\Guillaume.Lesourd\Documents\ArcGIS\Default.gdb\BNDA_CTY "Database Connections\nyvm2946.UNmap_SDE.sde\unmap_internal.SDE.UNmap_0\unmap_internal.SDE.BNDA_CTY" TEST # # FeatureClassToFeatureClass UNmap_0\BNDA_CTY "Database Connections\GDB arcgisdb ARCGISDBUSER.sde\arcgisdb.DBO.UN_data" UN_countries_BNDA_CTY # "ISO3CD "ISO3CD" true true false 3 Text 0 0 ,First,#,UNmap_0\BNDA_CTY,ISO3CD,-1,-1;ROMNAM "ROMNAM" true true false 254 Text 0 0 ,First,#,UNmap_0\BNDA_CTY,ROMNAM,-1,-1;MAPLAB "Cartographic Label" true true false 255 Text 0 0 ,First,#,UNmap_0\BNDA_CTY,MAPLAB,-1,-1;CONTCD "CONTCD" true true false 3 Text 0 0 ,First,#,UNmap_0\BNDA_CTY,CONTCD,-1,-1;MAPCLR "MAPCLR" true true false 3 Text 0 0 ,First,#,UNmap_0\BNDA_CTY,MAPCLR,-1,-1;STSCOD "STSCOD" true true false 2 Short 0 0 ,First,#,UNmap_0\BNDA_CTY,STSCOD,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,UNmap_0\BNDA_CTY,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,UNmap_0\BNDA_CTY,Shape_Area,-1,-1;ece_id_coutry "ece_id_coutry" true true false 4 Long 0 0 ,First,#,UNmap_0\BNDA_CTY,ece_id_coutry,-1,-1" # Project "Database Connections\GDB arcgisdb ARCGISDBUSER.sde\arcgisdb.DBO.UN_data\arcgisdb.DBO.UN_countries_BNDA_CTY" "Database Connections\GDB arcgisdb ARCGISDBUSER.sde\arcgisdb.DBO.UN_data_web\arcgisdb.DBO.UN_countries_BNDA_CTY_web" PROJCS['WGS_1984_Web_Mercator_Auxiliary_Sphere',GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Mercator_Auxiliary_Sphere'],PARAMETER['False_Easting',0.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',0.0],PARAMETER['Standard_Parallel_1',0.0],PARAMETER['Auxiliary_Sphere_Type',0.0],UNIT['Meter',1.0]] # GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]] NO_PRESERVE_SHAPE # NO_VERTICAL AddIndex arcgisdb.DBO.UN_countries_BNDA_CTY_web ece_id_coutry ece_id_coutry_index NON_UNIQUE NON_ASCENDING AddRelate "List of agreements per country" ece_id_coutry un_data.DBO.qry_agr_country_count id_country Relate_id_country "One to one" RemoveRelate "List of agreements per country" Relate_id_country 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.4.0'><FeatureDataset>arcgisdb.DBO.UN_data_web</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68723464615842617a3156303748554a5554336c725870473557307473656a397348647859716d4d576c5a453d2a00;SERVER=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;INSTANCE=sde:sqlserver:ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DATABASE=arcgisdb;USER=arcgisdbuser;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>arcgisdb.DBO.UN_countries_BNDA_CTY_web</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>agr_list</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50000</field_length><field_alias>agr_list</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.4.0'><FeatureDataset>arcgisdb.DBO.UN_data_web</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6856657135336b364a576d725a4c3674644d2b6571494e3537677a7662567034736553657532674a742b5a513d2a00;SERVER=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;INSTANCE=sde:sqlserver:ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DATABASE=arcgisdb;USER=arcgisdbuser;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>arcgisdb.DBO.UN_countries_BNDA_CTY_web</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CountAgr</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>CountAgr</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.4.0'><FeatureDataset>arcgisdb.DBO.UN_data_web</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6856657135336b364a576d725a4c3674644d2b6571494e3537677a7662567034736553657532674a742b5a513d2a00;SERVER=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;INSTANCE=sde:sqlserver:ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=ECE-PRD-MS-28-SQL.UNOG.UN.ORG;DATABASE=arcgisdb;USER=arcgisdbuser;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>arcgisdb.DBO.UN_countries_BNDA_CTY_web</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>countAgr</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>countAgr</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> AddIndex "List of agreements per country" arcgisdb.DBO.UN_countries_BNDA_CTY_web.ece_id_coutry ix_id NON_UNIQUE NON_ASCENDING Server=ece-prd-ms-28-sql.unog.un.org; Service=sde:sqlserver:ece-prd-ms-28-sql.unog.un.org; Database=arcgisdb; User=arcgisdbuser; Version=sde.DEFAULT ArcSDE Connection arcgisdb.DBO.UN_countries_BNDA_CTY_web 0.000 -20037507.067200 20037507.067200 -30240971.958400 18422214.740200 1 002 Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> WGS_1984_Web_Mercator_Auxiliary_Sphere 1.0 150000000 500000 ItemDescription ArcGIS Metadata 1.0 Microsoft Windows 10 Version 10.0 (Build 16299) ; Esri ArcGIS 12.4.2.19948 ITIO ECO MS 1 -179.999989 179.999989 83.627419 -89.000000 ITIO ECO MS <div style='text-align:Left;'><div><div><br /></div></div></div> United Nations itio Enterprise Geodatabase Feature Class dataset EPSG 8.8(9.3.1.2) 217 Simple FALSE 217 TRUE FALSE 20200131 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1O5Kt qjxgBmCBsE8flSNCTkeQn4HFQCEhmMsbszEE5+b9asWrlV8uQMjZJUN6Z7VbOdeZGUmgBkjXaByV zwR/jTwkl2iM7BE4ZfLbJzSPIlzcJCMsmCxI6HHbNWgAoAAwB2pDK5+0xBiSkijkZ4JFTo29FYDA YZ5pWG5SucZGKhtn+TymwJE4I/kaBk9FFITzgUDFopMUc9P1oAOtGKUcCigBMUZweaWm8Fue1ADg QelFFFABRRRQAUUVE1zChIaVAR1BPSgRLRVU30WcRq8noVXj86jE11IScJEvbu1FhXRammjgjLyu FUdzTUuoJACsycnAGec1V8ndIJJXaRgMDPQfhTbpFFvJIFG5VJBA545p2C7NKiqMWqWryrCZArkc Z4DfT1q4JEKbwwK+ueKQ00x1FVFvo5rlYItzEjJYDjFWhwKATuLSGl6UnJOaBi0UUUAFITgZpabx u6UAOooooAKKKKACq9zGjSwM6K/zFcMM9R/9apI2ZgdyFefWoJ3EV3GzZYMp2qFJwR/+ugTJ2ZYU G1OM4AUdKabgAA7GPtik82bqYOPQNzSfbIgdrh0b0Kk/yoC5Kkm9iMEVWfdNOTGjK6MBu3cY75FS NewCMssik9lzgmmLBcGVnMioHxkKORjP+P6UCepbpO9VwWhuEjMjOrg/e7EVZoGIfWlpD0paBhRR RQAU0/eyB0pc+lAGBQAtFVX1G2jlaNnIZePunBPoDUkV1DNgJIu4/wAJOD+VAromooooGFYcSKL6 YGPzY5H3K5UcHHP8q1rqSSKAtHHvPp7f1qpbbBCFR92OvbH4dqaIlqyaiiigYUUUUARywpKpDKpO CASMkVDFZmNFjaVmiUYWMAKo/Lr+NWqKBWQx49xDKdrr91h2/wDrVYt5jKhDDDqcMKiqMt5Myy/w n5X+nrQPYvEZo5FLQeaRQUUfjRQAUUUUAFFFFABRmmsWyqIN0j8KPU082d6pwYFY+qucUAN61BcH 54wnMoOQB6d803z5QCS0LAdhnJp1oS8RlZSGcknPp2/SgW5YowPSiigYxoY3GGRT+FPqJnlBOIwR 9aaXn7Rj86BEkkKSgb1zjke1V45jCojkWUlSQDtJz6VaByOeDQRQFhscqSrlT+B4IpwPaont4Xcu UAc/xjg/nUdo5kMo3l1RtoJ6j1oC5aopOfWkzkAetAxksywRb3zjOAAMk1Vlma4k8uNtseAxYHlh 7U65w17EuMhUJ+h4wf50iRJGSVXBNMh3FWNFUKFGBTXhRx0AbqGHUGpKKBleGS/SNlkZHY8Bv7vv 70vky4wbqXHfnnNT0UCsRia7VVj2IxGP3hPBHv70KrGZ5XCgsAML7Z/xqSigLBRRRQMKKKKACiii gApGUOpVhkEYNLRQBWWCZHEom3SjjLDgj0qUvdMd3mIpA4VRkH61JRQKxLbXC3EeQRuH3lzyDU1U GjbzPMjkMb4weAc06zF4TKoBmXdxIxwAT2+lA0+hcZgqksQAO5p0cNxcIXiQKmM734B+lXYNK2zC WeQSbfuqBwD61pVNzRR7nPGK5igeWWNSicsynt60uQe9boySVKYFQNptk2SbWHJ77BRcOUzbRtmo wkjIYMn0PBz+lblVoLG3tnLxxgOeNx5IHoParNJlRVjk5bS1SE7lJx3B5NOiF2qfMYyBwFI5x7n/ AOtUcCLPIsqqwiXkbupP07VbM0YzlxxwaoxsR5uHGNqx+pzn8qpwhlJj3zCUHIdjnI9x0rQ86PON 4zUU7LiKRSM7gM+3egGhkF07oQ8Z3qcECrSncoOMZ7GqMck73Am8tArAqAGyW544xT3+3W97mRd9 rtyWRckH0wMk07XFzWLZIFKORUAuIzE8qhjs6jGDUsVvcTIryMIgwyUAyR+NFh8yI5Z/LYIq7mPP JwAPekgRo1bOAWbdtByBUb2qNeun8CAZwOufU/561aAAGB0oegLXUQ5PApcClopFFK6hkEqywqWY nDjPVef60iPvyMFWBwQe1XT0rPmEkVy1wcGJlAIA5X3PrTJehNRTN2eQeKcDmgBaKKKAE5z7Uc4P rQTigHNABzxRzn2paKAEGec0c496WigBOc+1Azk5paTPPFAC0UnNHNAC0hIyBkZPalq3pdlFeefJ Om6MEImfUckj8x+VAJX0Kaqsk0KSZ8tpFVsHBOTXTRWsMEPkxxhY/T1qtFpFnDMJVjO5emTkA+tX 6hs0jG25BiWEcYdB2PUD61ISXjBQ9e9PqKDjzAPuhzikWPXduIPTtTqKRs7Tt644oAWiqsLXZtXM saLNn5VByMf5zU8RkMSmUKHxyKAOXdzby+YMmJsl8c4NSxGKeISKvyt6imCK2dfkx04Oar2sawRF UneMbjxwQemSMitDAveUn90flUdxAk8Plk7RnOR2qMndhZLjKdeOCfxFNaJJHWO2dhI44+bjH0NC BvQs2FqVna5bcdyBVLfU8j061emj82Jo9xXPcdaHdYItzZ2qO1R/bIdpOTx2x/n0rRInQpICu63C mRlJGOmR6mnGzvmUEXRTHYEn8Kutcxq2GJHGelSKwdAy9CMilawbmdGQh2OCsnU7u9S1akiSVCrj I/lWdL9pt3IZVaMdG6Z+pqWik7E9FQfaQPvxuo9SOKlEiEgB1JPTmpHcHOBj1qjP+8m8o/cAyR/e q8/KGqFwSkiSHGB8rewNUhSJAKXGKRT606kBHNIY49ygEkgDPucUzyXf/WSt9F4pbn/VL/vp/wCh CpiQBknAoF1K22SLlCXT+6eo+lTROJF3KeKUAEZUgj1qIxSI5aJlG77wYZGfWgCeiocXP9+L/vk/ 40RSneYpMeYP/Hh60BcmooooGFIBikEiHo6n8aiF2hwSrqp6MRwaBXJ6Kh+1wf8APT9DTlnic4Vx mgLot6dYyX8bO8wi2ttKqMkfjWvp1m9hE0BlaVSxYMRjGe1UdCdjNdIATHkEt/tY6flitupbNYJW uFFFFSWFQhJI8hCpXOfm7VNRQBEZJE5kUFfVe1SKwYZUgj2pagwsE24ABH646A+tAE9FNDoejD86 XI9aAOJjSXaxEyIgLKuOuM96ltrpEUxysjiM7QVBORRbWvmHznhXY53Bc9PekaCd2RIoFdTIdxHy 7R6H9D+Na2uc7dtSae8gitmlRN7AcJjB/WmW80kV1HcSrH5ZGGKqcqKh1OEwWjJbxOWXapdhgEk8 c9x2qG3t7vcrzSQTgpg5B6+1O1iHJt2OjF1bSDieJh/vCoJ76ONikUYlkHXsB9TWTa2QgBLHJYkl R90fQVaVQowowKOYpXe5Iby6IOI4cn1zx/jU8OpRnCzKYWAH3sYJ9qq0hAPUA0uYdjYDAjIII9aj nkjSBjIyqpGPm6f/AF6yPIj6beOvWgQovKqM9s0+YNSKC7bykR5NpIxllIH606TyI0w0sIJOAV5P 4Y5p8iM6MpCkEdDVF5FaBbScxxzqoK7upx6flUibsXLfUB5jRSldi8CUHg8d/SmyBbskkHyew/vf /WpsMkckHmBUHHz8jj61KH3oGXBU9CDTBa7kKy+SfLkJJH3Tjlh/jTgssnLOY17KuM/iaSfP7s45 DjFWBg0AVJpDGvlytkh0Kt6jcKV0F8ZI2f8Acgjhep/GrZAPUA0AAdABSCxUmjNqqPCzBdwDLnjH r7VOkiyMQkyMfQEGpSARg1BPHtCyRr8yNnAHUd6B7Eu1v71QTbopElOCi8HJxjPep0dZFDKQQe4p SARgjIoAb5se1mDqQvXBziqF5NJMqxqTDC/BlYdv6fjS3vkqVeMb5FYDykIyfwqo88reS4jeV9x+ TcPQ9qaREpdDSQWs6EIqtg4JXipkASMRhDtUYA9qqJA9xIspKxKvTy+p/H0rTtrO4vyTEVjjU4Lt zn6CkylqQZwOFx9KI7Vr/wCSGDfg/fb5VH4/4VqWmikSFr0xygAhVXOOvU+9bEcaRIEjUKo6AUnI 0UL7lPS7E6fZLA0nmNuZi2MdTnFXqKKg0SsrBRRRQMKKbIWCEqMmlGdoz1oAWkIBGCMj3paKAGeT H/cX8BSeRH/d/U1JRQBw0GpSRTzxtbzNGHYRhVzhQcVXiv3jvpJy0hSQjKZI2Yx1HfrXQ3VuVIlg iUvn5ucZFUrW0juXuZ3WTzR8oQ444BGPfmt1ucjTtYfq2LjSvlia4Vvm/dHGSORxVLS2LWEYK7SB gr6VchhlV5InjZYXAJAYgg+oxWaxvbTUmhS03RSPgHd096Grom9ndmlRUP2hdp4IfOPLbg5zipX3 xOEmTYT0Ocg/jUWNboQgnvijDf3qQPvbbEpkbqQp6VA920cvltA4bIAXIyTRYLotDpRUW+f732V9 vpkbvy/+vQRcspcBYUUZJkG4/kDQFyQ5qCK2hna5jYAEOCGA55Ap0VtdTEtJcbF/hCJjP1zmmpDN a3u+WRWjl+XIXBz2z+tAvkPttLWGQvJI0vTCnoMZ5x+NMVJbbcjRs4LE7l5zWmOlIQD1ouVyroZc nmEo7xlYlOTk8+xqdSDyDmrTR9sZFV2slJzGzReuzGD+Bp6Cs0RySxIcO4B601ZEZtp3o3XDDGau wQLApAJZiclm6mnSQxyjEiBvqOlIdmVdg9TRsHqaSS1eBt8GWTHMZJJ+oJNEcgk3fKVKnBB6g0AM aEhi8TbGPUdj9aFuMELKpRunPQ/jTppPKiZhjdj5Qe5pW09pRmS5kDZz8gAH5EGgXoVwnkXaquSr 5bB5weKWby/uG3Ehbnbj05qQWNwJy3nqQVADFeRVi3tFg+diXlxhnJPP4dqLiSZRjgt5FEiwgq3O O35VsaLdCBI7B4ggy2xgRg85Ax9P5Viwi5dVgghIAO0sDjcf9n/GtKx0a/8ANinnmdBG5YR7lJPX HO30ofmON76I6eimRuJFzggjgg9jT6zOgKKKKACiiigAooooAKKKKACiiigDMqtdJccNatGpz84Y fepk08MOEkuwjZJ5PNTwMrx7kl8wE5DZroObfQrJNf8AmKGtVKkjLbwMVOluBIZJSHcElTj7o9Kn opBYoyXUSsX+xyMwOMhAT1I/pUc+oRyRhTaytn++vA4zzWlUM6zEDymRfXcKBlW0855siNYoQOy4 3H+f6VWmgU6tK5kUSkDYD1AwKs7dQRCz3EIABOdtZ9g011IZpm+6xypGDmk9hW1LJlZJCGl6dRtp tysv2Z/3o+YYHHrx/Wny3AHEa7znBbsKesA3B5DvcdM9B9KgskQEIoJycc02cRmF/N+5jJpzyKmN xxmo5NlzE8at1FAMZYq62q7yxJJI3HJx2qzUFtP5ibHwJV4ZanoBbBRTfMT+8PzqJ5W3gRshHuaB k9FQxy5JDsuc4GDUm9Ccbhn0oAdWesMzPNLCyEM+QrcA9B1q7L/qn/3TTbcH7KgwFO3tQJq5Hb2a x/PJh5Sck+n0qzUPkt/z1ajyG/56tQCViamuyqjMxwoGT9Kj8hv+erVFtNxKw3OYSuD2BNAMfArJ ChyUZfukdQKvR3V7Ja+eZ4okQnLspww9R+lV8ZGO1OsI7l4RAuogMM5Rl5xk/wD1qTKjuFnc3Vzc lIL6B5NhLARMAeRz+ta0a7wwnky656HGB61UW2uVf5rzgEcrGB9eaeYSsse+Z5I84JJ9elIsu27M 0eWbdycHGMipaKKQwooooAKKKKAEJCjJoDBulG0Zzjmmnk5XgjjFADmbaM44pQwxUKCQmbL/AHvu j+7xTYYJUj2yTbmz1xTA5pEVFwo/HufrQoeJ2eGQxlvvAAEH86dRVnPYmtL6d0ffGH2uRuzjI+lW lvYuj7kP+0KoWH+oYH7+87vrVqnzAloSzXkcY+UGRuuEqhPPFPMq3HnwblzlT8vHbI781ZCqoIVQ M+gqKWQwRbgu75gD7CjmCxSvBG0BS1nnkklDKOeOmTSW8WbTcsGG3MSASO54qzqD7LJp1G5o/nUD vjt+PSiGTZbxRQje4UDkFR9TxQ2K2upEBc3FvtCRxxnsvUVYQXEaAlvM9QeD+FPgiMSnccsx3HHT 8KlqS0iNHSbtyOoYcinhFU5CgH2FMki3ncp2uOjCmrOB8s2EYevQ/Q0ANvI1aBpMfPGCysOoI5qa Nt8atnORmqtxeorKkbqSeSR83H0zVCwuJyimUzJtyFVYtwIJ700rivqbHkx/3RQIo1OQgB9hTIJT IpDKVdTgg/zqakMZ5UYOdgz9KXy0znaM9c06igYHpVe3fbiFlIYAkehGf/r1YqnFKwmkMsbbgcZX kAdvegTLlNkkWNCzHio/tA/hjkJ7fL1/OmnzJpEJjKKpydx5/SgLiedNLu8qIBRx8/G76VLEnlQq vcVJSGgBelEUAub2OLeyYBbcnDDp3prtsXPU9h61rWFn9ljLOQ0r8sQOntSY0rltVCqAOlVniiS6 81kGGHJx3q1R1qTUQEMMg5FLVVY2eVvLfy4wcEDue/0p2+SE4f5l7Nj+dAFiimLKrKCD19qXevqK AHUU3evv+VG9ff8AI0AOpGUH6+tNaVFUsTxTEuY3OM9aAHEkjd3XrUg5GaY4xkjoeDT0+6KYHKUU UVZgLZfdm/66n+Qq1VWy+7N/11P8hVh9+PkxnPekxrYdTWUOm09DTMTcfMo/CpOlAyisNxOPsyhS EcEljj5auISchhhwcMKcjeVcK5+63yn+lJfstsy3BBwxCvgfkaq10QtB1FHWipLCkIB6gH60tFAD GhjdSCoGe4HNJBNHZt5Ur4Rz8jOe/pmpKjnhjuIjHIoZT2NNOxLRJchPMWaMoSRtYbgM+lRxzJJk AjcDgjPIrOt3tYkjiubdcghWfPerOzSzIpTdHJwFZcg4OKpq4k+xcJAGScCkBDDIOR7VU1G0iWEP KZJ3QFki3HBI9QOtTqjxYPlEK4Bwg4B70uUFLUlqKaLOZEYq4HX1+tH2iIdWwR1BpkspaRY43Vcg kt6dKkq6JIZBLErgg564pGikJJEpAJ6YpIzFD8gfkknk9aVrmFWVS4yxwKAuIYpO0pzUkMVxKCIk 83Zwxzjn2pe9WLCc29z5Ls3lP90Y4DfWgaLFlYMkhmuFG7oq9dtaNFFQaJWCiiigZEYmQloj1OSp 6GqNw9/5x2Mkadgyk9vUe9aJJBzjIoLqO9MDOtIr4MWM8Trg/KAev9KttJLFGWeJTgZ+U050Rm3f Mh9RxmmSo7RMomJyOBgUAVpdWjhnMErLG45Oc4NNbW7ePBYhlORlc9fTmgoCyO+2QsQhYHaQcd6s fYoGG1tpXPQnNAgililhW5Z94b7oHT8KRt3lOW2xoegbgmp47WCHlUAxRCA+ZTySTtJ9O1AyCOSQ wiVmLIxwABnA9eKnWTC4yKJyFiKKOW4AFOiwsYU9RxQI5iikBDAFSCD0IpasxFsvuzf9dT/IVaqj aSOomAhdh5h5BHt71Y86T/n2k/Nf8aQJ6E1IehqLzpP+faT/AL6X/GmiWVs5tnx2+Zf8aB3JmUOh U9CMVPbO09uRIOQShPrjjNUfNmlJjWF4/Vmxx9KkiZrTlQTGTlgT+tUiWOCvAVicDHRWHf8A+vT6 lvRm2LY5UgjHbmoqTQ0RzPsUfNtOfSoBM24Dzh0/u1aIB6jNG1f7o/KkUCncoIOc0tFFAFK5haOX 7TGvmAEM8R/ix3pxvrhl3R2ERJ5BZ8cdu1W6rNZRsxIeRc9lbimmS4laUySoqSqxldhvKtjjvj2q 1DqMsPlxSWzlc48wHIA9TUX2VY7pDvdtwIwT07/0q2kYjGBn8aLgkXVZJUDKQymoza25bcYI8+u0 VBbFhcsiH5MZYehq7VoQzyYtu3y0x6bRQ8SSRGNh8pGCBxT6KAMqGO6SQW/lvI5Y7ZGxtxn/AAq8 2mXbkAyRKAQcgEn61Pz261bt1LYkaQscYx6VEtCoK+hYHAFFRtLtnSPH3hnNSVmbBRULCcxSBWQO T8hPQD3pjLd/Z4wrRCbjeTnH4UAWaTABzgZpuH83OR5eOnfNMgE4D+eUJ3Hbt/u9s+9AE1ZR0y9I I/tJu/8AyzHrWrUcs6QqSxyfQcmmgZlRafdNbhBdDCuc/u+vbmo2sZo5cG8G3OSdgzz2H5GrCag/ 2iUJbSGNjnceOwpsO7dmbaAQyqT1HWnZk8yNB3Y5iRSTgDd2FTKoRQo6AYFVY5kgtzcTsEViOSfw FNOr2Axm4UZ6ZBFSUSSGRJ3kWMMuwck49c1MEEgDY6iqf9r2BBHnrxkEc9iB/UVLGJUUhUyCcj5q AKt1osMhMlufJkPJA+6T7ise6S4ssCeE5JwpX7rH69q6yqGr/wDHj/wNapMzlFWujGs0dI38xdpZ y2M5qxRRTJQh6UtB6UnWgYtNkAaNgehFKOtKRkYoAnhRXs40P3TGB+lVSHt2VJOVPCt/Q0+1lcSG EZeMD73932oYSXCeWZYznkEDnI5FaWujPYKKj80KpMnylfvA9qXzo/76/nWZdx9FMMqBS24EDrg0 wCaUbi/ljsAAT+OaAJqY80cf3mGew7mo2ty4O+aRj2wdv8sUWqqsZAUB1O1j3J96ABWzK0zgqoG1 d3FNmuUACrKisc/M3QYqZ2GdmwuTzgDNSQ6fD8sksYaTqc9B+FNITfQkso2jtEDsrMfmLL0OeasU iqFUKoAAGAB2pasQUUVVZ7lFG7ygSe9NIVy1SqzIcqSKrK1yxGPKI4yc1YpNDTJIiTcKSTnPU1fr NU4dSegINaVZz3NYbBRRRUFhRRUcsyxD1PYUALJKkY+Y/hVGR/MkLYxmkZi7Fm6mkrWMbGMpXCkZ Q64NLRVEk0E6zDyJkGe2RwRVg20J6xIce1UBhZFk7rWpWUlZm0XdFZ47aM4MKktzhVzTg1wwyqIo 9G60LkXb7iOVGz9c1PUlBWTql1G6fZkJaUOMgKcDv1oopoUtirSMSFJAyfSiiqMyLzZP+eJ/Ono7 MpLJtOe5oooAeKa6GXbEM5chRiiigC9LeQQCS2S2nwmR8qcHoev4/wA6oJqEPmEfZplYHGfL+n+N FFOITIZ7ZUuI0E7sWYsQ/Jx1xU3lR4x5a4+lFFOW5ESBvJ3gmBsg8YH+fSpo5fMONrLxnkUUVJQ5 3CLkke3vSw2Qc+dI7guBlBwPx96KKcSXuWo4I4SSi4J685qSiirAKKKKACmvGkgAdc4oooAEjSME IoAJzxTqKKAA1oROHjVh6UUVEy4bj6KKKzNSvLchSVQZYHn0qoSSxY9TRRWsEjGbdwoooqiQoooo ARiQMgZ9vWpTdySoo2bD3zzRRSkkOLYis3kuu4ZUjZn1Jp9xfw20gjlD78AnaOKKKye5tHY//9k=