20240318
18135500
1.0
FALSE
ConvertCoordinateNotation in_memory\xyTempResults "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCW_data" # # Shape "DD 2" # "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] INCLUDE_INVALID
CoordinateTableToPoint "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\bcw_simplified.csv" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCW_data" long "Decimal Degrees - Two Fields" lat "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision"
CalculateField BCW_data At20KM_AGRsZone 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data doublons isDuplicate(!Shape!) Python "uniqueList = []
def isDuplicate(inValue):
if inValue in uniqueList:
return 1
else:
uniqueList.append(inValue)
return 0" Text NO_ENFORCE_DOMAINS
CalculateField BCW_data coordXY !DDLat!+!DDLon! Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data doublons isDuplicate(!coordXY!) Python "uniqueList = []
def isDuplicate(inValue):
if inValue in uniqueList:
return 1
else:
uniqueList.append(inValue)
return 0" Text NO_ENFORCE_DOMAINS
DeleteField BCW_data doublons "Delete Fields"
DeleteField BCW_data coordXY "Delete Fields"
Append OSM_border_control BCW_data "Use the field map to reconcile field differences" "borderid "borderid" true true false 8000 Text 0 0,First,#;country1 "country1" true true false 8000 Text 0 0,First,#;country2 "country2" true true false 8000 Text 0 0,First,#;lat "lat" true true false 8 Double 0 0,First,#;long "long" true true false 8 Double 0 0,First,#;year "year" true true false 4 Long 0 0,First,#;road_status_1 "road_status_1" true true false 4 Long 0 0,First,#;road_status_2 "road_status_2" true true false 4 Long 0 0,First,#;gate_1 "gate_1" true true false 4 Long 0 0,First,#;multilane_1 "multilane_1" true true false 4 Long 0 0,First,#;split_1 "split_1" true true false 4 Long 0 0,First,#;ofbld_1 "ofbld_1" true true false 4 Long 0 0,First,#;numbld_1 "numbld_1" true true false 4 Long 0 0,First,#;gate_2 "gate_2" true true false 4 Long 0 0,First,#;multilane_2 "multilane_2" true true false 4 Long 0 0,First,#;split_2 "split_2" true true false 4 Long 0 0,First,#;ofbld_2 "ofbld_2" true true false 4 Long 0 0,First,#;numbld_2 "numbld_2" true true false 4 Long 0 0,First,#;data_source "data_source" true true false 8000 Text 0 0,First,#,OSM_border_control,F_id,0,1999999999;DDLat "DDLat" true true false 255 Text 0 0,First,#;DDLon "DDLon" true true false 255 Text 0 0,First,#;ORIG_OID "ORIG_OID" true true false 4 Long 0 0,First,#,OSM_border_control,OBJECTID,-1,-1;At20KM_AGRsZone "At20KM_AGRsZone" true true false 512 Text 0 0,First,#,C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\OSM_border_control,At20KM_AGRsZone,0,511" # # # NOT_UPDATE_GEOMETRY
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.2.0'><WorkspaceConnectionString>DATABASE=C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>BCW_data</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>At1KM_ROAD</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>At1KM_RAIL</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>At1KM_WW</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField BCW_data At1KM_ROAD 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data At1KM_RAIL 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data At1KM_WW 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data More1kmAGRinfra 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data At2KM_ROAD 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data At2KM_RAIL 1 Python # Text NO_ENFORCE_DOMAINS
CalculateField BCW_data At2KM_WW 1 Python # Text NO_ENFORCE_DOMAINS
Rename "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCW_data" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BC_data" FeatureClass
Rename "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BC_data" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data" FeatureClass
Append BCP_eTIB BCP_data "Use the field map to reconcile field differences" "data_source "data_source" true true false 8000 Text 0 0,First,#,BCP_eTIB,office_id,0,253" # # # NOT_UPDATE_GEOMETRY
DeleteField BCP_data At20KM_AGRsZone;At1KM_ROAD;At1KM_RAIL;At1KM_WW;More1kmAGRinfra;At2KM_ROAD;At2KM_RAIL;At2KM_WW "Delete Fields"
DeleteField BCP_data lat;long;year;road_status_1;road_status_2;gate_1;multilane_1;split_1;ofbld_1;numbld_1;gate_2;multilane_2;split_2;ofbld_2;numbld_2 "Delete Fields"
DeleteField BCP_data DDLat;DDLon;ORIG_OID "Delete Fields"
Rename "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_final_data" FeatureClass
Project BCP_data "C:\Users\dagan\OneDrive - United Nations\GIS\TER\SHP provided by consultant\TER data\TER data.gdb\BCP_data_3857" 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
CopyMultiple "'C:\Users\dagan\OneDrive - United Nations\GIS\TER\SHP provided by consultant\TER data\TER data.gdb\BCP_data_3857' FeatureClass" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb" BCP_data_3857 "BCP_data_3857 FeatureClass BCP_data_3857 #"
ExportFeatures "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data_3857" "C:\Users\dagan\AppData\Roaming\Esri\ArcGISPro\Favorites\ECE-PRD-MS-28-SQL arcgisdb (arcgisdbuser).sde\arcgisdb.DBO.UNECE_transport\arcgisdb.DBO.Border_Crossing_Points" # NOT_USE_ALIAS "borderid "borderid" true true false 8000 Text 0 0,First,#,C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data_3857,borderid,0,7999;country1 "country1" true true false 8000 Text 0 0,First,#,C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data_3857,country1,0,7999;country2 "country2" true true false 8000 Text 0 0,First,#,C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data_3857,country2,0,7999;data_source "data_source" true true false 8000 Text 0 0,First,#,C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UNECE\UNECE Transport Facilitations\Border Crossings\Border Crossings Data.gdb\BCP_data_3857,data_source,0,7999" #
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.2.0'><FeatureDataset>arcgisdb.DBO.UNECE_transport</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686f665768636c5139334a596b5978504759767068454b5571356d526f5256686f6c56795272747a45586d773d2a00;ENCRYPTED_PASSWORD=00022e68704735322f4b645a314547704d656a64754271436a4b49724555637a4334446e5a4c4269774b456f7868773d2a00;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.Border_Crossing_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><FeatureDataset>arcgisdb.DBO.UNECE_transport</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686f665768636c5139334a596b5978504759767068454b5571356d526f5256686f6c56795272747a45586d773d2a00;ENCRYPTED_PASSWORD=00022e684d6c744f326d496d667a42776643714b2f563349353831695a794672415472352b4f3346563352333950383d2a00;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.Border_Crossing_Points</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
Append Border_Crossing_Points "Border Crossing Points" "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY
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.Border_Crossing_Points
002
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.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>
150000000
5000
ItemDescription
20240318
18163900
20240319
14162900
Border crossings used for the UNECE maps (E Networks related to AGC, AGTC, AGR and AGN agreements).
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Data as of 2023</SPAN></P><P><SPAN>Sources: </SPAN></P><UL><LI><P><SPAN>https://mkenwick.com/datameasurement/</SPAN></P></LI><LI><P><SPAN>OSM</SPAN></P></LI><LI><P><SPAN>UNECE</SPAN></P></LI></UL><P><SPAN>Border crossings at more than 2 km from E Networks are excluded</SPAN></P></DIV></DIV></DIV>
Michael R. Kenwick, Beth A. Simmons, and Richard J. McAlexander. 2023. “Infrastructure and Authority at the State’s Edge: The Border Crossings of the World Dataset.” The Journal of Peace Research. Online First (https://doi.org/10.1177/00223433221145582), OpenStreetMap (https://www.openstreetmap.org/copyright), UNECE
Border_Crossing_Points
Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 13.2.0.49743
20240319
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
arcgisdb.DBO.Border_Crossing_Points
Feature Class
0
OBJECTID
OID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
borderid
borderid
String
1073741822
0
0
country1
country1
String
1073741822
0
0
country2
country2
String
1073741822
0
0
data_source
data_source
String
1073741822
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADEAxLAbyp9yn8JvVSQbQaacbXcAAed1AMBfhgVkGBaQ
YVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZh
ARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWsIoPNmgEIKsAlC0AAAAASUVORK5CYII=