20230928
17510500
1.0
FALSE
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\dagan\Downloads\UNECE AGTC Terminals</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>UNECE_yellow marked.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Country</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\dagan\Downloads\UNECE AGTC Terminals</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>UNECE_yellow marked.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>idcountry</field_name><field_type>SHORT</field_type><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\dagan\Downloads\UNECE AGTC Terminals</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>UNECE_yellow marked.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>source</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>False</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "Terminals (Work in progress)\corresponding AGTC terminals" source 'SGKV-corresponding terminals' Arcade # Text NO_ENFORCE_DOMAINS
Append 'Terminals (Work in progress)\possible alternatives to AGTC terminals' "Terminals (Work in progress)\corresponding AGTC terminals" "Use the field map to reconcile field differences" "ID_TERMINA "ID_TERMINA" true false false 10 Long 0 10,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,ID_TERMINA,-1,-1;SGKV_CODE "SGKV_CODE" true false false 254 Text 0 0,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,SGKV_CODE,0,254;TERMINAL_N "TERMINAL_N" true false false 254 Text 0 0,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,TERMINAL_N,0,254;LATITUDE "LATITUDE" true false false 24 Double 15 23,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true false false 24 Double 15 23,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,LONGITUDE,-1,-1;TERMINAL_O "TERMINAL_O" true false false 254 Text 0 0,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,TERMINAL_O,0,254;TERMINAL_L "TERMINAL_L" true false false 254 Text 0 0,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,TERMINAL_L,0,254;ART "ART" true false false 254 Text 0 0,First,#,C:\Users\dagan\Downloads\UNECE AGTC Terminals\UNECE_orange marked.shp,ART,0,254;Country "Country" true false false 254 Text 0 0,First,#;idcountry "idcountry" true false false 5 Long 0 5,First,#;source "source" true false false 254 Text 0 0,First,#" # # # NOT_UPDATE_GEOMETRY
CalculateField "Terminals (Work in progress)\corresponding AGTC terminals" source 'SGKV- possible corresponding terminals' Arcade # Text NO_ENFORCE_DOMAINS
ExportFeatures "Terminals (Work in progress)\AGTC terminals (SGKV)" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Sustainable Transport\AGC-AGTC\Terminals SGKV Source\AGTC_terminals.shp" # NOT_USE_ALIAS "ID_TERMINA "ID_TERMINA" true true false 10 Long 0 10,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),ID_TERMINA,-1,-1;SGKV_CODE "SGKV_CODE" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),SGKV_CODE,0,254;TERMINAL_N "TERMINAL_N" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),TERMINAL_N,0,254;LATITUDE "LATITUDE" true true false 24 Double 15 23,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 24 Double 15 23,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),LONGITUDE,-1,-1;TERMINAL_O "TERMINAL_O" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),TERMINAL_O,0,254;TERMINAL_L "TERMINAL_L" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),TERMINAL_L,0,254;ART "ART" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),ART,0,254;Country "Country" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),Country,0,254;idcountry "idcountry" true true false 5 Long 0 5,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),idcountry,-1,-1;source "source" true true false 254 Text 0 0,First,#,Terminals (Work in progress)\AGTC terminals (SGKV),source,0,254" #
CopyFeatures "AGTC_terminals SGKV" "C:\Users\dagan\AppData\Roaming\Esri\ArcGISPro\Favorites\ECE-PRD-MS-28-SQL arcgisdb (arcgisdbuser).sde\arcgisdb.DBO.UNECE_transport\arcgisdb.DBO.AGTC_terminals_SGKV" # # # #
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>arcgisdb.DBO.UNECE_transport</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686f665768636c5139334a596b5978504759767068454b5571356d526f5256686f6c56795272747a45586d773d2a00;ENCRYPTED_PASSWORD=00022e68505753592b435445635132436b3279575171535375675154623564342b6833646d66636435392b543074593d2a00;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.AGTC_terminals_SGKV</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>ART</field_name><new_field_name>Type</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
arcgisdb.DBO.AGTC_terminals_SGKV
002
0.000
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
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/3.1.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>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
20231009
12352400
20231009
16150300
150000000
5000
ItemDescription
Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 13.1.3.41833
AGTC_terminals_SGKV
Data transmitted by SGKV, to be reviewed and approved
SGKV (https://sgkv.de/en/), UNECE
UNECE
Enterprise Geodatabase Feature Class
0.000
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
arcgisdb.DBO.AGTC_terminals_SGKV
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.
ID_TERMINA
ID_TERMINA
Integer
4
10
0
SGKV_CODE
SGKV_CODE
String
254
0
0
TERMINAL_N
TERMINAL_N
String
254
0
0
LATITUDE
LATITUDE
Double
8
38
8
LONGITUDE
LONGITUDE
Double
8
38
8
TERMINAL_O
TERMINAL_O
String
254
0
0
TERMINAL_L
TERMINAL_L
String
254
0
0
ART
ART
String
254
0
0
Country
Country
String
254
0
0
idcountry
idcountry
Integer
4
10
0
source
source
String
254
0
0
20231009
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD0iiii
uw8wKKKKACiiigAooooAKKKKACiiigAoooPAoKRBCMtK46lse1ShsYDYBPam2cLTbRyE3FmI/lVu
e0YHdDgj+4f8azjNJWZ01aUpSbX9W0IKWUkZPUgDj8KjfEUmx22uexNLM5U/eXOcf/qq9Dms1uKW
ypIU5APUYFadmmy0iH+zn8+axL24NnFGbqZLdZGCK8rAZP0roEAWNQvQAAVxYqcZWUWZVGmtB1FF
FchiFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBjUUUV7J0hRRRQAUUUUAFFFFABRRRQ
AUUUUAFRzMRGQOp4FSVBcAl4vTdzUy2NqCTqK5oWEBhiJYYZv5CrTMEUsegpsbxsMIwO3jiobqTg
Rj6mudLmkdU58sbkEshuHG8AjsuOKsiCKa5D+UgSI8HaOT/gP89KgjjJ2gffbp7D1rRRFjQIo4FR
iKiXuo4alRxjbqyvfabZ6kka3lukwjbcm7satAADA6UUVxnKFFFFAgooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKAMaiiivZOkKKKKACiiigAooooAKKKKACiiigApkqF0wDgjkU+ik1fQqMn
GSkiKNgzbgSki9ccGr6WxltVupJFzJyEAOT7VTEAuZMElVX7zr1+g961beJkjTzCC6qFAUYCj2rm
rVeTRbm1SUIw5u/T+ugsMWzLN99uvt7VLRRXA3d3ZwSbk7sKKKKCQooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigDFDBgCD1paQqrEEjkdDSYYFjnd6A17J0jqKbvAALfKTxg06iwBRR
RQAUUUUAFFFFABRTJpY4ImllYIi9WPQc4pgu4OMyopK7sMccetK6Got7E1IQ7Hag+rdhUayrOxjg
lRnBwQDkj6CtS0tfIQbiSeuM9D/jWFWuoaLcbtBXl9xJBDsVcjkdB/nvU1FFee227s5pScndhRRR
SJCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigDGooor2TpCm7MMWBOT78U
6ii4DNzKo3DJz/CKdkZxkZ9KWk2jJOMH1o0GLRUZ8xFAUGQ57nHFOMsYO0sA3pmnYB1FRmZVOGDj
3KnFBniDbTIgb0JqQsx0kaSoUkUMpxkHvzmqf9jWc0pC2+92XaQSSAK0Io3uH2x8KOr9h/jWnDAk
CbUH1Pc1zVq0Y6LVidRw0RWsNNgsFYoMyN95z/Ie1XaKK4G77mEpOTuwooooJDtWVo+jHSZb1zdz
T/aZfMxIeE+n5/oK1aKB3CiiigQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQBj
UUUV7J0hRRRQAUUUUAFMeMSFc/wtmn0mcyLGoyzHoPT1pMqN76E0KTECSCYEg9zzSyXF4ylJJgM5
B4H+FWYIFgQhSSScknuabcRvIUVFySayU7vU6pwcY3iOs5cxiN1VWHTHRh61arIdWjfbuwyHgg1o
W1wJ0OeHXqK461HkfMtjz6kbO6KOsf2z5tl/ZRhCeb/pHmddnHT9f0rV7c0E4GT0qrY6jZ6lE0tn
cJMittJQ5wawMy1RRRQIKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igDGooor2TpCiiigAooooAKSGXy7osqAjGHJP5AUMcDgZPQD1q1dWn2aOHP3mX5j71La2ZpBSSc1
0HLeDd8yYX2NaNvLAIS6tu9eMGsi3gM8qoOAeprVe0EMY8scDrWNRRWh0UZTlq9hJ7KK4hBhAVh0
x39qxyHhlyPlkQ9/5Gti3crJjdgHrVe/siCZouQeSKUJX92Qq1K65kh8MyXMOcezKe3tUVjptnpk
TRWcCwozFmC9zVGN2hlEif8AAh/eFasUqzRh0OQa5K1J035HnSjYfRRRWRAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAGNRRRXsnSFFFFABTWdUGWOBTqvaZaeewuJA
PLB/djuT61MpKKuaU4ObsUVbgMjYPZhVoXgmCpe/dTkOg5PsRWlcadb3GCQUI7ocVUl0RGwIkVgB
xnqPxrnlWW9joVKUdL6GhbGBogbcqU9VqasC2tHtpDumkhlPG4Dj2yD1rSsr0zs0MwCzpycdGHqK
yunszeOxYeOMKWKZxUEc4Bwfun8auVRuwsJ3Dv2FNeY3pqYviK5bR7Q3UFnJdu7hVii9888fStCw
iMduHYFXkwzKf4fapIoiG8yTlzwP9kegqasalVy0voeVXqRk7R2CisrSr7Ubu8vo72wFvFE4EL5z
vFaFzcLa2stw4YrGpYhRknFZGFiWiqOkapDrOnpeQJIiOSMSDB4q9QAUUUUCCiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKAMeRJYP8AWpgf3xyKQHPStnrVWTT4HOVDRt6ocfp0rshi
v5kaqp3KFFTvp86/6uVXHYOMH8x/hTY7d/MAuA0Sdyq7s/TH+FbqvTa3NY2k7JjIo2nuI4V43Hk+
g710iqFUKoAA6AVmBLCOHEEypIvKs7YP61Zg1G2liBaeJW6EFx1rKpLm1R20rQ0LdP8Aux+7fyqK
OWKUEpIjKOpVs4qN74Z+VMj39KzSNiZwsi7ZFDD3qjNph3rNZzBJUzhXHBGOlSf2jbMP3e92/uqu
c/j0qM3Vy/8Aq40jHZnO4/kP8amTS16mcqtOO7K8sEsiE6hP0GBHFkZP9aZaWSW5L4O49MnOBU6R
sDuklaRh0z0H0FSVlKo2rHBXxHP7sdgoooqDlCggEYIyKKKAEVFRQqKFUdABgUtFFAwooooEFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQMTap7D8qNi/wB0flS0UDIp
UZRvi4I6qP4h6VBLJvhAQ8yHYPb1/TNXKiECibzAT3+Xtk960jUsrG9LEOEXFkiqEUKBgCloorMw
CiiigkKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP
/9k=