20240605
14452200
1.0
FALSE
ExportFeatures "Populated Places" "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UN\2023 UN Countries\2023 UN Countries.gdb\PopulatedPlaces_ExportFeatures" # NOT_USE_ALIAS "poptyp "POPTYP" true true false 0 Short 0 0,First,#,Populated Places,poptyp,-1,-1;scl_id "SCL_ID" true true false 0 Short 0 0,First,#,Populated Places,scl_id,-1,-1;cartolb "CARTOLB" true true false 256 Text 0 0,First,#,Populated Places,cartolb,0,255;romnam "ROMNAM" true true false 256 Text 0 0,First,#,Populated Places,romnam,0,255;altnam "ALTNAM" true true false 256 Text 0 0,First,#,Populated Places,altnam,0,255;athrty "ATHRTY" true true false 0 Short 0 0,First,#,Populated Places,athrty,-1,-1;pop_nb "POP_NB" true true false 0 Double 0 0,First,#,Populated Places,pop_nb,-1,-1;poprnk "POPRNK" true true false 0 Short 0 0,First,#,Populated Places,poprnk,-1,-1;un_rnk "UN_RNK" true true false 0 Short 0 0,First,#,Populated Places,un_rnk,-1,-1;iso3cd_1 "ISO3CD" true true false 3 Text 0 0,First,#,Populated Places,iso3cd_1,0,2;m49_cd_1 "M49 codes" true true false 3 Text 0 0,First,#,Populated Places,m49_cd_1,0,2;nam_en "Name (En.)" true true false 100 Text 0 0,First,#,Populated Places,nam_en,0,99;geo_cd "Geographic regions code" true true false 0 Long 0 0,First,#,Populated Places,geo_cd,-1,-1;sub_cd "Sub-regions code" true true false 0 Long 0 0,First,#,Populated Places,sub_cd,-1,-1;int_cd "Intermediary regions code" true true false 0 Long 0 0,First,#,Populated Places,int_cd,-1,-1;subreg "Sub-regions" true true false 50 Text 0 0,First,#,Populated Places,subreg,0,49;intreg "Intermediary regions" true true false 50 Text 0 0,First,#,Populated Places,intreg,0,49;iso2cd "ISO2CD" true true false 2 Text 0 0,First,#,Populated Places,iso2cd,0,1;name_fr "Name ( Fr.)" true true false 100 Text 0 0,First,#,Populated Places,name_fr,0,99;georeg "Geographic regions" true true false 3 Text 0 0,First,#,Populated Places,georeg,0,2;globalid "GlobalID" false false true 38 GlobalID 0 0,First,#,Populated Places,globalid,-1,-1" #
Project PopulatedPlaces_ExportFeatures "C:\Users\dagan\OneDrive - United Nations\GIS\Data\Data UN\2023 UN Countries\2023 UN Countries.gdb\PopulatedPlaces_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
ExportFeatures Capitals "C:\Users\dagan\AppData\Roaming\Esri\ArcGISPro\Favorites\ECE-PRD-MS-28-SQL arcgisdb (arcgisdbuser).sde\arcgisdb.DBO.UN_data_web\arcgisdb.DBO.UN_data_capitals" # NOT_USE_ALIAS "poptyp "POPTYP" true true false 2 Short 0 0,First,#,Capitals,poptyp,-1,-1;scl_id "SCL_ID" true true false 2 Short 0 0,First,#,Capitals,scl_id,-1,-1;cartolb "CARTOLB" true true false 256 Text 0 0,First,#,Capitals,cartolb,0,255;romnam "ROMNAM" true true false 256 Text 0 0,First,#,Capitals,romnam,0,255;altnam "ALTNAM" true true false 256 Text 0 0,First,#,Capitals,altnam,0,255;un_rnk "UN_RNK" true true false 2 Short 0 0,First,#,Capitals,un_rnk,-1,-1;iso3cd_1 "ISO3CD" true true false 3 Text 0 0,First,#,Capitals,iso3cd_1,0,2;m49_cd_1 "M49 codes" true true false 3 Text 0 0,First,#,Capitals,m49_cd_1,0,2;nam_en "Name (En.)" true true false 100 Text 0 0,First,#,Capitals,nam_en,0,99;geo_cd "Geographic regions code" true true false 4 Long 0 0,First,#,Capitals,geo_cd,-1,-1;sub_cd "Sub-regions code" true true false 4 Long 0 0,First,#,Capitals,sub_cd,-1,-1;int_cd "Intermediary regions code" true true false 4 Long 0 0,First,#,Capitals,int_cd,-1,-1;subreg "Sub-regions" true true false 50 Text 0 0,First,#,Capitals,subreg,0,49;intreg "Intermediary regions" true true false 50 Text 0 0,First,#,Capitals,intreg,0,49;iso2cd "ISO2CD" true true false 2 Text 0 0,First,#,Capitals,iso2cd,0,1;name_fr "Name ( Fr.)" true true false 100 Text 0 0,First,#,Capitals,name_fr,0,99;georeg "Geographic regions" true true false 3 Text 0 0,First,#,Capitals,georeg,0,2;globalid "GlobalID" false false true 38 GlobalID 0 0,First,#,Capitals,globalid,-1,-1" #
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_data_capitals
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
20240606
16130000
20240606
16130000
Populated places
UN_data_capitals
UN
Microsoft Windows 10 Version 10.0 (Build 22621) ; Esri ArcGIS 13.2.0.49743
20240606
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
arcgisdb.DBO.UN_data_capitals
Feature Class
0
OBJECTID
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
poptyp
POPTYP
SmallInteger
2
5
0
scl_id
SCL_ID
SmallInteger
2
5
0
cartolb
CARTOLB
String
256
0
0
romnam
ROMNAM
String
256
0
0
altnam
ALTNAM
String
256
0
0
un_rnk
UN_RNK
SmallInteger
2
5
0
iso3cd_1
ISO3CD
String
3
0
0
m49_cd_1
M49 codes
String
3
0
0
nam_en
Name (En.)
String
100
0
0
geo_cd
Geographic regions code
Integer
4
10
0
sub_cd
Sub-regions code
Integer
4
10
0
int_cd
Intermediary regions code
Integer
4
10
0
subreg
Sub-regions
String
50
0
0
intreg
Intermediary regions
String
50
0
0
iso2cd
ISO2CD
String
2
0
0
name_fr
Name ( Fr.)
String
100
0
0
georeg
Geographic regions
String
3
0
0
globalid
GlobalID
GlobalID
38
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAD59JREFUeJzt3WtvVFUbh/FFmRYRqgUsIAJSQaUiiApqPESNb/QL+DF97TuN
olHRBBWlChVUVFqQk9gDUGqulWc3kz4t7XSO997XL2mmDEOZzuz573sdd21+fn4+VcS9e/fSH3/8
kX7//fe0YcOGtGfPnvTAAw+kBx98MNVqtW4/vVI4d+5c6u/vTzt37syv6bp161JfX1+3n1alXb58
Od8ODw+n6Cr1KeWDQ0jxNTs7m65evZquXLmS5ubm0vT0dL5/y5Yt3X6aoW3fvj2/ppwUwOu8cePG
9MQTT3T7qVVWX4lOGJUKrHpUWI8++ujCnwmt77//Pn377bfpmWeeyR88Ne6hhx7KX/U++ugjA6vL
bt26lbZt25aiq2xgLbZ+/fp09OjRdPfu3XThwoX8BmPHjh1p06ZN3X56oR0+fDiNj4+n/fv3d/up
VFJ/f3/+KgMDa/ELUqulAwcO5OC6du1a7pM5dOiQfVxN4Mz+119/NXWgau1mZmZyC6IMDKzlXpha
LXdSElqEl53ya0fH++3bt5v4CWrG1atX0+7du0vxIhpYK71AtVqpOi272eQ2+DtvfHw8DQwMpM2b
N6cyMLBWmAYxNTWVS2redK3d0NBQrrKsVDvn4sWL6ebNm+n5559PZWFg3QeV1dNPP51++umnfIZi
VJHRRTWOgQuCnzlvao8rV67kL45bplfyWjOQVCYG1goYXXn22WdzX1Yx5aEs5XUn0elr07q9r++v
v/6aq6kyv84G1ioxoZSDgblazNF67LHHcmeyVuf8+fPp5Zdf7vmX659//kmff/55fm8ff/zx9PDD
D+f3nudPE4s5ZiMjI+mbb75JW7duzScwpsFQ0VBBMiL677//5ukw/IxOzS6fm5vLJ9UyhxUMrAar
LUpsDtyzZ8/meUV0JmtlNKUjfJgIGforea7cFivXuJ+RNlZE0LfJ9wQU3zObn5Civ4hmGP11ExMT
eXlSpwwMDKTBwcHc51rmZreB1SAO5L179+aDkzPxK6+8UppJee1EpcIHu9f7AHl/qaw4KTFAwPvM
0iImElPFUFmzNo/fha4B7uMxdBsQFBwTzONj3tmdO3c6+txHR0fTmTNn0osvvpjKysBaI5oG+/bt
S3/++Wc+wLXy68X6QppTvVyVUqlQGXFSonnI4vgbN26k5557Lt9SSR08eDD9/fffOayoapjJzy0n
Lh7H7ZEjR7ryGtdqtRyUZT2JGlhN4Ixaoc0umvLII4/kD9PHH3+cXn/99Z6ptJgbRtOuaK4SQoQW
9xFWfFFN0RSkoqLa4s/0Y/Le83iCgvsICvq7aD4SysVoHY/hz9y2c1rHxMREDqoyTx0p72/WIXa8
r/514sP8xhtv5GkiVFq9MNr6yy+/LDTv6FinuuJ5njx5MldZVE70V/I9HegMutCxTrVFhc3SLaqq
L7/8Mk+BIQAJJ6YX8D3NNH5fHvPbb7/lP7fD1NRUGhsbS2+++WYqMwOrCWVZn9VJVC980JmBzUha
Jzum79fJTuXELZUft4QWa0jpE+Ix3E+1RdVEONCXxZIXwo5g4vdgEIbf6+eff07vvvturnjoMiDA
eGw7zM7OLkwQPXbsWCo7A6sJHMAclG5F0xiqFioOqhM6p+u3+ek0wogAJaSogKieaFIxK5/NHgky
/sz9BA/NPzrVqajY44tRY6qx+n45qkfm7BEi/J70d/GzmQbRSt99910eDKDDvyo7YRhYTeDg5YzK
we3SncbxwSYUqGIIBppdnZ76wPQE+n0ILgKIAGBWPk03Qoi/p9oq7qfZx+0LL7ywMH2gvplH5cWx
QJORn8tjqM74Oa2oyKenp3PVxvPZtWtXKXYRbYSB1SR2KT19+nQ+k/by6Fcv4vUipPggT05OphMn
TqTjx4/n8OpklVw/MFCo33m2/v5C/WZ49X1xxc+r//f1/0ezYfXVV1/lsCRcq9h/amA1qTiYT506
lYe3rbTWFlw0CwkBmjlUXmXYHbPVTp06ladLEJBVDCsYWC0KLZoyP/74Y24e9MqQfTSEPaFPk+f6
9euV6ZdZrdHR0dwvRnOQJmYVQ8vAahE6VD/99NO8tkxrR9hTYV26dClXFDS1q/jBXMrQ0FD+YlSQ
jvylmqplZ2C1AOvJ6Hx/++23bRK2CNMEeF1/+OGH3AdEvxZ/pvnI91S0DHYstfyFUb2iP5EPeNn6
FgcGBvJ0hioysFqA5gsfIIbr1TqMgvFFMPFF5zxznorXm1G4+tec2ekEGMEG/g1NKCq2MpmZmanc
6GDBwGrBwcMo4WuvvWbTpY0VRf1gxnId8kudMBhVK1tgzVV4bzEDq8kDh6Ud7NhQtmZHWTBnivV8
ZeoHm6/w+lUDqwl0fDJ51KkMvR1YzF8q0x5RcxVeEmZgNYHhd4feexsd9mXa1G5ubm5hN4gqMrDW
iDWEjFb1wo4DWh59PUUnfBlMTU0t7AhRRQbWGjD6xFYk9F2pt9FkZ5F1sXh5LZd5Y+SRwRU69anU
Fnd4d6qPbOZ/AzxVnptmYDWIg5iwYka2YjQJCSu2fGlkL6pigTEhx7wuJrSyoJldUwmL+s34ik3/
2PWhXZvncZIcGxvLi6/L0rxdCwOrQRzEHLx05ioG1ilyRRmubkOorHRCYokVAcEi48XYjWEpPP6D
Dz5I77//fsPPjw3+2LWCn/Hqq6/mqrAek0QJqz179rR8i5poDKwGMNrEwfzSSy+17x1RW1BdsaSF
YFgudJiQypIg/r5+t4XVoMJi077iakqrmSdFQHE8sZEhlRNhSQXHc6CfqtifnVt2Zxh0YrKB1QjO
0KyWr+qkvchoxjFrnivesLkeTfr695ELThA2BNtaB1IIFH4+wbdSJURYffLJJ/lal8Vjiyv2aA0V
FiU07f6ifU5bnrMOLy4vLCNkVRqp4ADj961y/0F0vH+sUWRJD3uzU0lxHPPeMupLZ3Yzc+qKaxdy
kVWC6H77elHpcWFZq6YWBBYb6LOYlxe9eAMpUTkL0fHI98Ve1rzgnLnKelmhQpVnF5cNnfCcfAkN
jmmaYjTjWnEM07/J54Z+Kaq4pU7qXFKe/5c+KTUZWAQRIySLLytOO5o3eXHbnnD77LPP8geajmj+
vnjj6TwsSwe1zcBy4f1sV2BQWdG045Jm9EExUsm+/3wO6Edjl9VuXLewDGpUTFyVFzT/aMfTwbda
7Mnz1ltvLYygFdte8EYVl++m3KYpxZktaiVWzDCWVoMT9zvvvLPwWeCqObRIXHfanBrVVBFYX3zx
RXryySfX3OnIv1vq3xbhxf/F2SXiB5/fwTWDWgtO0owEqnk12tLso00FwW6ZjQ7nrvYNYyM1Zg0z
bEvHZLQmFv0cBpbUXTXmFFE9EFiturrHcuic5/psxd7nkUYZi3kxkrqnVlRAnepboknIfCZGIZ96
6qkURZW39JB6RVdKBkKLRZyNzArutgjPUSq7Wrc+/Fxem906mZzKsoRe74gv0xYlUlRd65QhtKiu
uCoKc1OYddzLVUwvPzepKrrai0xVRec7lVbEjnhJndX1YS8Cirlfvd4R7zwsqfu6HlgF9ilibReb
4zFPq9dmxDNK6CXope7qmcAC/VjsEsFSHkKrl7DEiHlkkrqnpwILLO3h8lmMyrWjo5ufy5rHog+N
Rdv8PyxMXW6kko37aBLa8S51V88FVjGbnJnl7VgKwwUJWE1P+BR7cxNi3H/o0KH/a4pS8TE7v5EF
4ZIqEliECFXWhx9+mI4ePZqbhlwthFFEtrIpqhxujx07ltcorhbhw64RSzU32febKRb1exidPHky
V3usuu+1PjWpinousMCukO+9914OC4KKzm5GDwmoAtvY0EnPlrQjIyMrrvOjkmK3CB67FKo59kdi
Iivf0ww8cOBAOn78eMt/P0klCixQ0RBcfC2FEKOZxg4QX3/99YrXCCy2xL3fFsfs18UW0IQhP7/X
Z99LVdOzgbVaBBCVEdvkLLc/9uTkZK7AhoeHV/x5hFS7d62QVNHAAk244sq8i9F5T9/XwYMHu/Lc
JLVOKQKLDniufLIUdoRgP233spLiK0VgUVmxrIeRvnrsbkpQse+8pPhK0ySks5wLZLJtDdMS6NNi
djrbPksqh1IEFtjkn0qLuVSMLHLRC+ZbOdInlUdpAqsYMaTCYlSQKwEVVwOSVA6lCqyiA365uVuS
YitdYEkqLwNLUhgGlqQwDCxJYRhYksIwsCSFYWBJCsPAkhSGgSUpDANLUhgGlqQwDCxJYRhYksIw
sCSFYWBJCsPAkhSGgSUpDANLUhgGlqQwDCxJYRhYksIwsCSFYWBJCsPAkhSGgSUpDANLUhgGlqQw
DCxJYRhYksIwsCSFYWBJCsPAkhSGgSUpDANLUhgGlqQwDCxJYRhYksIwsCS1xZ07d1JfX1+an59P
09PTad26dfnPc3Nzqb+/P9/eu3cvbdiwIT+Wx23cuDE/ZnZ2Nt9/+/btfDszM5MGBgYMLEntMTY2
lrZt25a2bNmSJiYm0o0bN9L69evT9u3bcwhdunQp/93Zs2dTrVbL31+7di0HF48/cuRIOnPmTL49
ffp02r9/v4ElqT2uX7+eK6edO3emu3fvpsOHD6cTJ07k+0dGRnJgnT9/Pu3duzcH1OTkZL7/woUL
affu3flxVGbg9ubNmwaWpNa7ePFi2rp1a7p161YaHx/Pt1RPg4ODadeuXblJuG/fvrRp06YcVDx2
eHg4f09VVjQjuT137lz+d5cvXzawJLUeoUMwUVkRPDt27MjNwdHR0RxCNAGHhoZyv9TmzZvzfSC4
6McC/5YQ4+94HH1edrpLarkidAgavu6HwFoKAUdfVz0DS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrD
wJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLC
MLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpak
MAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoEl
KQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFg
SQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEY
WJLCMLAkhWFgSQrDwJIUhoElKQwDS1IYBpakMAwsSWEYWJLCMLAkhWFgSQrDwJIUhoElKQwDS1IY
BpakMAwsSWEYWJLCMLAkhWFgSUpR/AehXME2OFalFwAAAABJRU5ErkJggg==