Wiki /
Back to index
Wiki › UN Vector Tiles › Tshoot commands

Tshoot commands

Draft Updated 57 days ago
Edit

Web Servers

Access with vectortile user:

su - vectortile

Access mysql

mysql -u vectortile -pOQbfeF60KWI!

Restart MySQL

sudo systemctl restart mysqld

vtdata folder

cd /vtdata/hosting/coesite4/

logs vtdata

cd /vtdata/hosting/coesite4/log

vtdata config important files

/vtdata/hosting/coesite4/config/default.hjson
/vtdata/hosting/coesite4/.env

restart coesite

cd /vtdata/hosting/coesite4/
./restart-coe.sh

location: /usr/local/bin/pm2

monitoring

pm2 status coesite4
/usr/local/bin/pm2 status coesite4

stop services

pm2 stop coesite4

check dowloaded files?

cd /vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
ls -rlt

getting some JS file

wget https://raw.githubusercontent.com/unvt/coesite4/refs/heads/main/routes/VT-r.js

interesting combo

sudo /usr/local/bin/pm2 stop coesite4
sudo /usr/local/bin/pm2 delete all
sudo /usr/local/bin/pm2 start app.js -i 1 --name coesite4 --no-daemon

App Servers

root

test connections
   75  2025-04-22 09:03:03 nc -zv dfs-unvttlk-01.dpko.un.org 443
   76  2025-04-22 09:03:08 nc -zv dfs-unvttlk-01.dpko.un.org 22

create user
   78  2025-04-22 09:03:35 su - vectortile

permissions for /data folder
   82  2025-04-23 10:02:48 chown vectortile:vectortile /data/

check tippecanoe version
   83  2025-04-23 10:03:00 tippecanoe --version


check installed packages
   92  2025-04-23 10:11:48 dnf module list mysql
   93  2025-04-23 10:11:58 dnf module list nodejs
   94  2025-04-23 10:12:14 node -v
   95  2025-04-23 10:12:29 dnf search nodejs
   96  2025-04-23 10:12:47 dnf info nodejs.x86_64
   97  2025-04-23 10:13:04 yum history
   98  2025-04-23 10:13:41 dnf search posgresql
   99  2025-04-23 10:13:48 dnf search posgres
  100  2025-04-23 10:13:59 dnf search postgresql
  101  2025-04-23 10:14:25 dnf info postgresql.x86_64
  102  2025-04-23 10:14:37 psql -V
  103  2025-04-23 10:15:05 dnf module list postgresql
  104  2025-04-23 10:15:25 rpm -qa | grep -i postgresql
  105  2025-04-23 10:15:46 rpm -qa | grep -i postgre
  106  2025-04-23 10:16:17 dnf unistalle postgresql-server-10.23-4
  107  2025-04-23 10:16:24 dnf unistalle postgresql-server

postgres status
  108  2025-04-23 10:16:52 systemctl status postgresql


upgrade nodejs
  115  2025-04-23 12:05:41  dnf remove nodejs
  116  2025-04-23 12:06:51  dnf module reset nodejs:10
  117  2025-04-23 12:07:37  dnf module enable nodejs:22
  118  2025-04-23 12:08:17 cd /etc/yum.repos.d/
  120  2025-04-23 12:08:21 ls- lrt
  121  2025-04-23 12:08:27 ls -lrt
  122  2025-04-23 12:08:35 mv nodesource-nodejs.repo /root/
  123  2025-04-23 12:09:02 dnf update
  124  2025-04-23 12:11:06 reboot


  129  2025-04-23 13:26:35 dnf install -y nodejs
  130  2025-04-23 13:27:21 nodejs -v
  131  2025-04-23 13:27:31 node -v
  132  2025-04-23 13:29:24 clear

install postgres
  133  2025-04-23 13:30:38 dnf module list postgresql
  134  2025-04-23 13:31:32 dnf install -y postgresql
  136  2025-04-23 13:32:08 psql -V

  137  2025-04-23 13:33:08 dnf install sqlite-devel zlib-devel
  139  2025-04-23 13:38:06 su - vectortile
  140  2025-04-23 13:48:21 dnf search npm
  141  2025-04-23 13:48:45 dnf install npm
  142  2025-04-23 13:49:10 npm -V
  143  2025-04-23 13:49:19 npm -v
  144  2025-04-23 13:49:55 su - vectortile
  145  2025-04-23 12:13:26  dnf module list nodejs
  146  2025-04-23 12:13:49 dnf serach nodejs
  147  2025-04-23 12:13:56 dnf search nodejs
  148  2025-04-23 12:14:11 dnf info nodejs.x86_64
  149  2025-04-23 12:15:45 ls -lrt
  150  2025-04-23 12:15:48 cd
  151  2025-04-23 12:15:51 su - vectortile
  152  2025-04-23 12:18:49 mv /usr/local/bin/tippecanoe /usr/local/bin/_tippecanoe_
  153  2025-04-23 12:19:20 ls -l /usr/local/share/man/man1/tippecanoe.1
  154  2025-04-23 12:19:29 mv /usr/local/share/man/man1/tippecanoe.1 /usr/local/share/man/man1/_tippecanoe.1_
  155  2025-04-23 12:19:50 ls -ld $HOME/.local/bin/tippecanoe
  156  2025-04-23 12:20:00 su - vectortile
  157  2025-04-23 13:10:54 dnf module list nodejs
  158  2025-04-23 13:11:19 dnf search nodejs
  159  2025-04-23 13:11:32 dnf info nodejs.x86_64


  161  2025-04-23 13:36:23 ls -ld /home/global.un.org/adm.cdemarco
  162  2025-04-23 13:36:34 visudo
  163  2025-04-23 13:39:06 cat /etc/sudoers
  164  2025-04-25 05:55:24 nc -zv unbs-r-db-02.global.un.org 5432
  165  2025-04-25 05:55:47 nc -zv unosm-r-app-02.global.un.org 5432

  166  2025-04-25 05:56:27 su - vectortile
  167  2025-04-29 06:57:11 su - vectortile
  168  2025-04-29 10:28:50 df -h
  169  2025-04-29 10:29:00 umount /data
  170  2025-04-29 10:29:11 mv /data /vtdata
  171  2025-04-29 10:29:14 vi /etc/fstab
  172  2025-04-29 10:29:25 mount -s
  173  2025-04-29 10:29:27 mount -a
  174  2025-04-29 10:29:36 systemctl daemon-reload
  175  2025-04-29 10:29:37 df -h
  176  2025-04-29 10:31:50 cd /vtdata/
  177  2025-04-29 10:31:51 ls -rlt
  178  2025-04-29 10:34:01 vi /etc/fstab
  179  2025-04-29 10:34:16 vi /etc/passwd
  180  2025-04-29 10:46:54 su - vectortile

vector tile

install tippecanoe
    3  2024-10-25 14:09:17 sudo git clone https://github.com/mapbox/tippecanoe
    4  2024-10-25 14:09:57 cd tippecanoe/
    5  2024-10-25 14:09:59 sudo make -j3 -latomic
    6  2024-10-25 14:11:33 make install
    8  2024-10-25 14:11:52 export PATH=$PATH:/usr/local/bin
    9  2024-10-25 14:12:00 tippecanoe --version
   10  2024-10-25 14:12:51 sudo make install



   13  2024-10-25 14:14:34 ssh-keygen
   14  2024-10-25 14:17:20 ssh-copy-id vectortile@vttlk-r-web-01
   19  2024-10-28 15:26:53 ssh 'vectortile@vttlk-r-web-01'


   21  2024-10-28 15:31:52 mkdir ~/data_conversion
   22  2024-10-28 15:32:01 cd ~/data_conversion

   23  2024-10-28 15:32:09 sudo git clone https://github.com/unvt/produce-gsc-6
   24  2024-10-28 15:34:12 sudo chown -R vectortile:vectortile produce-gsc-6
   25  2024-10-28 15:34:20 cd produce-gsc-6
   26  2024-10-28 15:34:27 sudo npm install
   27  2024-10-28 15:40:21 npm install -g npm@10.9.0

   35  2025-04-23 09:56:39 tippecanoe --version
   36  2025-04-23 09:59:12 df -h
   37  2025-04-23 09:59:20 ls -alrt
   38  2025-04-23 09:59:23 cd /data/
   39  2025-04-23 09:59:25 ls -rlt
   40  2025-04-23 09:59:28 ls -alrt
   41  2025-04-23 09:59:32 cd -
   42  2025-04-23 09:59:35 ls -alrt
   43  2025-04-23 09:59:44 cd data_conversion/

   81  2025-04-23 13:46:15 mkdir data_conversion
   82  2025-04-23 13:46:22 cd data_conversion/
   84  2025-04-23 13:46:56 git clone https://github.com/unvt/produce-gsc-6
   85  2025-04-23 13:47:29 cd produce-gsc-6
   88  2025-04-23 13:47:59 sudo npm install
   89  2025-04-23 13:50:13 cd data_conversion/
   90  2025-04-23 13:50:19 cd produce-gsc-6/
   93  2025-04-23 13:50:57 sudo npm install

   94  2025-04-23 13:53:01 cd config/
   95  2025-04-23 13:53:42 cp default-sample.hjson default.hjson
   96  2025-04-23 13:54:13 vi default.hjson
   99  2025-04-23 14:15:54 cd ..
  100  2025-04-23 14:16:14 chmod 777 work*.sh
  101  2025-04-23 14:16:59 ls -lha


  103  2025-04-23 14:18:19 node ./produce-gsc-small/index_un-s.js
  104  2025-04-23 14:20:25 nc -zv unbs-r-db-02.global.un.org
  105  2025-04-23 14:20:46 nc -zv unbs-r-db-02.global.un.org 5432
  106  2025-04-23 14:21:09 nc -zv unosm-r-app-02.global.un.org 5432
  107  2025-04-23 14:21:59 ls -l
  108  2025-04-23 14:22:07 ls -lrt
  109  2025-04-23 14:22:27 cd produce-gsc-small/
  110  2025-04-23 14:22:30 ls -lrt
  111  2025-04-23 14:22:49 cd un-s-tile/
  112  2025-04-23 14:22:53 ls -l
  113  2025-04-23 14:23:17 cd ..
  114  2025-04-23 14:23:26 cd osm-s-tile/
  115  2025-04-25 05:56:30 ls -rlt
  116  2025-04-25 05:56:38 cd data_conversion/
  117  2025-04-25 05:56:40 ls -lrt
  118  2025-04-25 05:56:42 cd produce-gsc-6/
  119  2025-04-25 05:56:43 ls -rlt
  120  2025-04-25 05:59:40 node ./produce-gsc-small/index_un-s.js
  121  2025-04-25 06:02:16 ls -lrt
  122  2025-04-25 06:02:23 cd small_tiles/
  123  2025-04-25 06:02:26 cd unosm/
  124  2025-04-25 06:02:30 cd ..
  125  2025-04-25 06:02:33 ls -rlt
  126  2025-04-25 06:02:37 cd produce-gsc-small
  127  2025-04-25 06:02:41 ls -rlt
  128  2025-04-25 06:02:45 cd osm-s-tile/
  129  2025-04-25 06:02:47 cd ..
  130  2025-04-25 06:02:49 cd un-s-tile/
  131  2025-04-25 06:02:52 ls -rlt
  132  2025-04-25 06:02:53 cd ..
  133  2025-04-25 06:05:13 ls -rlt
  134  2025-04-25 06:05:15 cd config/
  135  2025-04-25 06:05:18 ls -rlt
  136  2025-04-25 06:05:24 vi default.hjson
  137  2025-04-25 06:19:12 cd ..
  138  2025-04-25 06:19:16 node ./produce-gsc-small/index_un-s.js
  139  2025-04-25 06:22:15 grep wtps config/default.hjson
  140  2025-04-25 06:22:31 grep wtps config/default*
  141  2025-04-25 06:22:57 grep un-s config/default.hjson
  142  2025-04-25 06:23:14 vi config/default.hjson
  143  2025-04-25 06:23:55 vi config/default-sample2.hjson
  144  2025-04-25 06:25:42 ls -rlt
  145  2025-04-25 06:25:48 cd produce-gsc-small
  146  2025-04-25 06:25:50 ls -rlt
  147  2025-04-25 06:26:04 mv un-s-tile/0-0-0.mbtiles .
  148  2025-04-25 06:26:10 ls -l un-s-tile/*
  149  2025-04-25 06:26:13 ls -rlt
  150  2025-04-25 06:26:18 cd ..
  151  2025-04-25 06:26:24 node ./produce-gsc-small/index_un-s.js
  152  2025-04-25 06:27:20 cd -
  153  2025-04-25 06:27:22 ls -lrt
  154  2025-04-25 06:27:26 cd un-s-tile/
  155  2025-04-25 06:27:31 ls -rlt
  156  2025-04-25 06:27:32 cd ..
  157  2025-04-25 06:27:34 cd osm-s-tile/
  158  2025-04-25 06:27:40 cat tile-here.txt
  159  2025-04-25 06:27:42 cd ..
  160  2025-04-25 06:27:44 ls -rlt
  161  2025-04-25 06:27:48 rm 0-0-0.mbtiles
  162  2025-04-25 06:27:51 cd ..
  163  2025-04-25 06:27:53 cd config/
  164  2025-04-25 06:27:54 ls -rlt
  165  2025-04-25 06:28:00 vi default.hjson
  166  2025-04-25 06:30:06 psql -h unosm-r-app-02.global.un.org -U vectortile_reader -d osm_planet -W
  167  2025-04-25 06:30:14 vi default.hjson
  168  2025-04-25 06:32:18 cd ..
  169  2025-04-25 06:32:20 ls -rlt
  170  2025-04-25 06:32:45 cd node_modules/
  171  2025-04-25 06:32:48 ls -rlt
  172  2025-04-25 06:32:50 cd ..
  173  2025-04-25 06:32:51 ls -rlt
  174  2025-04-25 06:34:04 cd log/
  175  2025-04-25 06:34:06 ls -lrt
  176  2025-04-25 06:34:12 more produce-un-small-2025-04-25.log
  177  2025-04-25 06:34:58  ls -rlt
  178  2025-04-25 06:35:05 more produce-un-small-2025-04-23.log
  179  2025-04-25 06:35:16 cd ..
  180  2025-04-25 06:35:21 ls -lrt
  181  2025-04-25 06:35:38 more produce-gsc-small
  182  2025-04-25 06:35:41 cd produce-gsc-small
  183  2025-04-25 06:35:42 ls -rlt
  184  2025-04-25 06:35:48 cd osm-s-tile/
  185  2025-04-25 06:35:51 cd ..
  186  2025-04-25 06:35:54 ls -lrt
  187  2025-04-25 06:36:17 cd produce-gsc-small/
  188  2025-04-25 06:36:18 ls -rlt
  189  2025-04-25 06:36:43 more index_un-s.js
  190  2025-04-25 06:36:59      cd ..
  191  2025-04-25 06:37:01 cd ..
  192  2025-04-25 06:37:02 cd -
  193  2025-04-25 06:37:03 ls -rlt
  194  2025-04-25 06:37:39 node ./produce-gsc-small/index_osm-s-compact.js
  195  2025-04-29 06:57:17 ls -l
  196  2025-04-29 06:57:23 cd data_conversion/
  197  2025-04-29 06:57:26 ls -l
  198  2025-04-29 06:57:37 cd produce-gsc-6/
  199  2025-04-29 06:57:40 cd config/
  200  2025-04-29 06:57:42 ls -l
  201  2025-04-29 06:57:54 vi default.hjson
  202  2025-04-29 06:58:46 lss default.hjson
  203  2025-04-29 06:58:55 les default.hjson
  204  2025-04-29 06:59:02 less default.hjson
  205  2025-04-29 10:03:51 ls -rlt
  206  2025-04-29 10:03:55 cd data_conversion/
  207  2025-04-29 10:03:57 cd produce-gsc-6/
  208  2025-04-29 10:03:58 ls -rlt
  209  2025-04-29 10:04:11 cd produce-gsc-small
  210  2025-04-29 10:04:14 ls -rlt
  211  2025-04-29 10:04:18 cd un-s-tile
  212  2025-04-29 10:04:19 ls -rlt
  213  2025-04-29 10:04:21 cd ..
  214  2025-04-29 10:04:43 cd osm-s-tile
  215  2025-04-29 10:04:45 ls -rlt
  216  2025-04-29 10:04:48 cd ..
  217  2025-04-29 10:04:51 ls -rlt
  218  2025-04-29 10:06:41 tile-join --no-tile-size-limit -f -o small_tiles/unosm/small-scale.mbtiles produce-gsc-small/un-s-tile/0-0-0.mbtiles produce-gsc-small/osm-s-tile/0-0-0.mbtiles
  219  2025-04-29 10:06:56 ls -ld small_tiles/unosm/small-scale.mbtiles
  220  2025-04-29 10:18:34 scp -r ./small_tiles/unosm/small-scale.mbtiles vectortile@hosting/coesite4/mbtiles/UniteStreetMapVector:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  221  2025-04-29 10:18:48 scp -r ./small_tiles/unosm/small-scale.mbtiles vectortile@hosting/coesite4/mbtiles/UniteStreetMapVector:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector/
  222  2025-04-29 10:22:35 ls -ld ./small_tiles/unosm/small-scale.mbtiles
  223  2025-04-29 10:26:32 ls -lrt
  224  2025-04-29 10:26:42 \ls -lrt
  225  2025-04-29 10:28:33 cd
  226  2025-04-29 10:46:58 crontab -e
  227  2025-04-29 10:47:39 crontab -l
  228  2025-04-29 10:47:48 ls -ld /vtdata/data_conversion/produce-gsc-6



  229  2025-04-29 10:48:02 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_every.sh
  230  2025-04-29 10:48:12 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day01.sh
  231  2025-04-29 10:48:16 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day02.sh
  232  2025-04-29 10:48:19 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day03.sh
  233  2025-04-29 10:48:22 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day04.sh
  234  2025-04-29 10:48:25 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day05.sh
  235  2025-04-29 10:48:28 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day06.sh
  236  2025-04-29 10:48:30 \ls -ld /vtdata/data_conversion/produce-gsc-6/work_day07.sh



  237  2025-04-29 10:48:42 ls -ld /vtdata/data_conversion/cron-log/
  238  2025-04-29 10:48:52 cd /vtdata/data_conversion/


  239  2025-04-29 10:48:54 ls -rlt
  240  2025-04-29 10:49:04 mkdir cron-log
  241  2025-04-29 10:49:05 ls -rlt
  242  2025-04-29 10:50:12 crontab -l
  243  2025-04-29 10:53:54 dnf search pm2
  244  2025-04-29 13:03:32 ls -rlt
  245  2025-04-29 13:03:36 cd data_conversion/produce-gsc-6/
  246  2025-04-29 13:03:38 ls -rlt
  247  2025-04-29 13:03:43 ls -l work_small.sh
  248  2025-04-29 13:04:16 cat work_small.sh
  249  2025-04-29 13:04:44 vi work_small.sh
  250  2025-04-29 13:09:16 cat work_
  251  2025-04-29 13:09:20 cat work_small.sh
  252  2025-04-29 13:13:33 crontab -l
  253  2025-04-29 13:13:46 more ./work_day01.sh
  254  2025-04-29 13:15:09 cat work_day01.sh
  255  2025-04-29 13:15:49 cd ..
  256  2025-04-29 13:15:50 ls -lrt
  257  2025-04-29 13:15:55 cd produce-gsc-6/config/
  258  2025-04-29 13:15:57 ls -rlt
  259  2025-04-29 13:16:02 vi default.hjson
  260  2025-04-29 13:17:33 cd ..
  261  2025-04-29 13:17:35 ls -rlt
  262  2025-04-29 13:17:42 cat work_day01.sh
  263  2025-04-29 13:18:19 sed 's/(username)/vectortile/' work_day01.sh
  264  2025-04-29 13:19:35 sed -i 's/(username)/vectortile/' work_day0*sh
  265  2025-04-29 13:19:55 cat work_day01.sh
  266  2025-04-29 13:20:03 cat work_day02.sh
  267  2025-04-29 13:20:53 sed 's/(hostingserver)/vttlk-r-web-01.global.un.org/' work_day01.sh
  268  2025-04-29 13:21:20 sed -i 's/(hostingserver)/vttlk-r-web-01.global.un.org/' work_day0*.sh
  269  2025-04-29 13:21:23 cat work_day02.sh
  270  2025-04-29 13:23:41 sed 's/:(path)\/mbtiles\/unosm$/\/vtdata\/hosting\/coesite3\/mbtiles\/UniteStreetMapVector/' work_day01.sh
  271  2025-04-29 13:23:55 sed 's/:(path)\/mbtiles\/unosm$/:\/vtdata\/hosting\/coesite3\/mbtiles\/UniteStreetMapVector/' work_day01.sh
  272  2025-04-29 13:24:15 sed -i 's/:(path)\/mbtiles\/unosm$/:\/vtdata\/hosting\/coesite3\/mbtiles\/UniteStreetMapVector/' work_day0*.sh
  273  2025-04-29 13:24:18 ls -lrt
  274  2025-04-29 13:24:24 cat work_day01.sh
  275  2025-04-29 13:25:06 sed '/scp/s/-i XXX(path to your ssh key)//' work_day01.sh
  276  2025-04-29 13:25:15 sed '/scp/s/ -i XXX(path to your ssh key)//' work_day01.sh
  277  2025-04-29 13:25:42 sed -i '/scp/s/ -i XXX(path to your ssh key)//' work_day0*.sh
  278  2025-04-29 13:25:44 ls -rlt
  279  2025-04-29 13:25:50 cat work_day01.sh
  280  2025-04-29 13:26:25 cat work_small.sh
  281  2025-04-29 13:26:38 cat work_every.sh
  282  2025-04-29 13:26:48 vi work_every.sh
  283  2025-04-29 13:27:00 ls -rlt
  284  2025-04-29 13:27:28 ssh
  285  2025-04-29 13:27:34 hostname -f
  286  2025-04-29 13:27:54 ssh vttlk-r-app-02.global.un.org
  287  2025-04-29 13:28:02 cd
  288  2025-04-29 13:28:05 cd .ssh/
  289  2025-04-29 13:28:16 cat id_rsa.pub
  290  2025-04-29 13:29:05 ssh vttlk-r-app-02.global.un.org
  291  2025-04-29 13:30:00 cd
  292  2025-04-29 13:30:03 ls -rlt
  293  2025-04-29 13:30:08 cd data_conversion/produce-gsc-6/
  294  2025-04-29 13:30:09 ls -rlt
  295  2025-04-29 13:30:56 echo $PWD
  296  2025-04-29 13:31:10 scp work_day0* vttlk-r-app-02:$PWD
  297  2025-04-29 13:31:34 scp work_every.sh  vttlk-r-app-02:$PWD
  298  2025-04-29 13:31:42 scp work_small.sh  vttlk-r-app-02:$PWD
  299  2025-04-29 13:31:45 ls -rlt
  300  2025-04-29 13:31:51 cat work_undata.sh
  301  2025-04-29 13:31:56 cat work_clearmap.sh
  302  2025-05-07 07:17:44 cd data_conversion/produce-gsc-6/config/
  303  2025-05-07 07:17:48 more default.hjson
  304  2025-05-07 07:25:41 cd
  305  2025-05-07 07:25:43 cd .ssh/
  306  2025-05-14 14:12:31 cd data_conversion/
  307  2025-05-14 14:12:35 cd produce-gsc-6/
  308  2025-05-14 14:13:09 chronetab -l
  309  2025-05-14 14:13:41 crontab -l
  310  2025-05-14 14:14:10 ls
  311  2025-05-14 14:14:13 cd log/
  312  2025-05-14 14:15:10 ls -lrt
  313  2025-05-14 14:15:36 less produce-day03-2025-05-14.log
  314  2025-05-14 14:39:49 crontab -l
  315  2025-05-13 08:28:15 crontab -l
  316  2025-05-13 08:28:27 cat work_day01.sh
  317  2025-05-13 08:28:35 cd /vtdata/data_conversion/produce-gsc-6
  318  2025-05-13 10:31:22 more work_day01.sh
  319  2025-05-13 10:31:52 cd ./large_tiles/unosm/tile_day01/
  320  2025-05-13 10:31:55 ls /rlt
  321  2025-05-13 10:32:03 ls -rlt
  322  2025-05-13 10:34:01 cd -
  323  2025-05-13 10:34:03 ls -rlt
  324  2025-05-13 10:34:10 cat work_*
  325  2025-05-13 10:35:23 sed '/coesite3/s/coesite3/coesite4/g' work_*sh | grep coesite
  326  2025-05-13 10:36:31 grep XXX work_*sh
  327  2025-05-13 10:36:39 \grep XXX work_*sh
  328  2025-05-13 10:37:16 sed -i '/coesite3/s/coesite3/coesite4/g' work_*sh
  329  2025-05-13 10:37:39 vi work_clearmap.sh
  330  2025-05-13 10:39:28 ls -rlt
  331  2025-05-13 10:39:38 cd log/
  332  2025-05-13 10:39:39 ls -rlt
  333  2025-05-13 10:39:46 cat produce-day02-2025-05-13.log
  334  2025-05-13 10:39:51 cd ..
  335  2025-05-13 10:39:52 ls -rlt
  336  2025-05-13 10:39:57 cat work_small.sh
  337  2025-05-13 10:40:07 scp -r ./small_tiles/unosm/small-scale.mbtiles vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  338  2025-05-13 10:40:25 cat work_day01.sh
  339  2025-05-13 10:40:35 scp -r ./large_tiles/unosm/tile_day01/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  340  2025-05-13 10:40:48 scp -r ./large_tiles/unosm/tile_day02/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  341  2025-05-13 10:40:56 scp -r ./large_tiles/unosm/tile_day03/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  342  2025-05-13 10:41:11 cat work_day04.sh
  343  2025-05-13 10:41:39 scp -r ./large_tiles/unosm/tile_day04/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  344  2025-05-13 10:41:46 scp -r ./large_tiles/unosm/tile_day05/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  345  2025-05-13 10:41:54 scp -r ./large_tiles/unosm/tile_day06/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  346  2025-05-13 10:42:01 scp -r ./large_tiles/unosm/tile_day07/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
  347  2025-05-13 10:42:04 ls -rlt
  348  2025-05-13 10:42:14 crontab -l
  349  2025-05-13 10:42:28 cat work_every.sh
  350  2025-05-13 11:17:02 ls -lrt
  351  2025-05-13 11:17:24 sudo node app.js
  352  2025-05-13 11:17:33 cd ..
  353  2025-05-13 11:17:34 ll
  354  2025-05-13 11:45:18 crontab -l
  355  2025-05-13 11:45:26 more /vtdata/data_conversion/cron-log/day1-log.log
  356  2025-05-13 11:47:30 ls -rlt
  357  2025-05-13 11:47:34 cd produce-gsc-6/config/
  358  2025-05-13 11:47:35 ls -rlt
  359  2025-05-13 11:47:41 more default.hjson
  360  2025-05-13 11:48:17 psql -U vectortile_reader -h unbs-r-db-02.global.un.org -d som_planet
  361  2025-05-13 11:48:29 psql -U vectortile_reader -h unbs-r-db-02.global.un.org -d osm_planet
  362  2025-05-13 11:48:39 more default.hjson
  363  2025-05-13 11:48:58 psql -U vectortile_reader -h unosm-r-app-02.global.un.org -d osm_planet
  364  2025-05-13 12:10:12 more default.hjson
  365  2025-05-13 12:10:16 psql -U vectortile_reader -h unosm-r-app-02.global.un.org -d osm_planet
  366  2025-05-13 12:50:11 more default.hjson
  367  2025-05-13 12:53:34 psql -U vectortile_reader -h unosm-r-app-02.global.un.org -d osm_planet
  368  2025-05-13 13:01:48 ls -rlt
  369  2025-05-13 13:01:53 cd ..
  370  2025-05-13 13:01:54 ls -rlt
  371  2025-05-13 13:02:00 crontab -l
  372  2025-05-13 13:02:29 cat work_day01.sh
  373  2025-05-13 13:02:48 node produce-gsc-osm/index_day01.js
  374  2025-05-14 06:06:31 ls -lrt
  375  2025-05-14 06:06:46 crontab -l
  376  2025-05-14 06:06:50 cd /vtdata/data_conversion/produce-gsc-6
  377  2025-05-14 06:06:52 ls -rlt
  378  2025-05-14 06:07:02 cat ./work_day01.sh
  379  2025-05-14 06:07:18 cd ./large_tiles/unosm/tile_day01/
  380  2025-05-14 06:07:19 ls -rlt
  381  2025-05-14 06:47:38 cd ..
  382  2025-05-14 06:47:44 ls -rlt
  383  2025-05-14 06:47:50 cat work_day07.sh
  384  2025-05-14 07:28:54 crontab -l
  385  2025-05-14 10:41:16 ls -rlt
  386  2025-05-14 10:41:19 cd config/
  387  2025-05-14 10:41:20 ls -rlt
  388  2025-05-14 10:41:49 diff default-sample.hjson default-sample2.hjson
  389  2025-05-14 10:41:58 ls -rlt
  390  2025-05-14 10:42:05 vi default-sample.hjson
  391  2025-05-14 14:20:19 ls -rlt
  392  2025-05-14 14:21:06 diff default-sample.hjson default-sample2.hjson
  393  2025-05-14 14:21:25 ls -rt
  394  2025-05-14 14:21:32 diff default-sample.hjson default-sample2.hjson
  395  2025-05-14 14:21:55 cd ..
  396  2025-05-14 14:21:57 sl -rlt
  397  2025-05-14 14:21:59 ls -rlt
  398  2025-05-14 14:22:06 crontab -l
  399  2025-05-14 14:22:13 cd log/
  400  2025-05-14 14:22:14 ls -rlt
  401  2025-05-14 14:22:52 ps -ef
  402  2025-05-14 14:22:59
  403  2025-05-14 14:23:00 cd ..
  404  2025-05-14 14:23:02 ls -rlt
  405  2025-05-14 14:23:14 crontab -l
  406  2025-05-14 14:23:22 cat work_every.sh
  407  2025-05-14 14:23:54 cat
  408  2025-05-14 14:23:57 cd log/
  409  2025-05-14 14:23:58 ls -rlt
  410  2025-05-14 14:24:14 cat produce-everyday-2025-05-14.log
  411  2025-05-14 14:24:26 ps -ef | grep node
  412  2025-05-14 14:24:41 ps -ef | grep vect
  413  2025-05-14 14:25:09 ls -rlt
  414  2025-05-14 14:25:15 more produce-day03-2025-05-14.log
  415  2025-05-14 14:25:25
  416  2025-05-14 14:25:28 more produce-day03-2025-05-14.log
  417  2025-05-14 14:25:37                grep -i error *
  418  2025-05-14 14:25:40 ls -rlt
  419  2025-05-14 14:25:46 more produce-everyday-2025-05-01.log
  420  2025-05-14 14:25:49
  421  2025-05-14 14:25:52 more *
  422  2025-05-14 14:26:46 crontab -l
  423  2025-05-14 14:26:55 pwd
  424  2025-05-14 14:27:07 cd  /vtdata/data_conversion/cron-log
  425  2025-05-14 14:27:08 ls -rlt
  426  2025-05-14 14:27:30 more everyday-log.log
  427  2025-05-14 14:27:42  ls -rlt
  428  2025-05-14 14:27:50 more day2-log.log
  429  2025-05-14 14:28:09 ls -rlt
  430  2025-05-14 14:28:13 more day3-log.log
  431  2025-05-14 14:28:24 more day2-log.log
  432  2025-05-14 14:29:37 cd ..
  433  2025-05-14 14:29:40 ls -rlt
  434  2025-05-14 14:29:42 cd
  435  2025-05-14 14:29:50 cd data_conversion/produce-gsc-6/
  436  2025-05-14 14:30:02 ls -rlt
  437  2025-05-14 14:30:06 cat work_day02.sh
  438  2025-05-14 14:31:15 cd ..
  439  2025-05-14 14:31:22 crontab -l
  440  2025-05-14 14:31:28 cd /vtdata/data_conversion/cron-log
  441  2025-05-14 14:31:29 ls -rlt
  442  2025-05-14 14:31:35 cat day3-log.log
  443  2025-05-14 14:31:46 ps -ef | grep day3
  444  2025-05-15 07:07:42 ls -rlt
  445  2025-05-15 07:07:52 tail -f everyday-log.log
  446  2025-05-15 07:08:09 tail -f day3-log.log
  447  2025-05-15 07:08:23 vi day3-log.log
  448  2025-05-15 07:08:51 ps -ef | grep day
  449  2025-05-15 07:12:34 ls -lrt
  450  2025-05-15 07:12:43 tail everyday-log.log
  451  2025-05-15 07:12:49 ls -lrt
  452  2025-05-15 07:13:02 cat everyday-log.log
  453  2025-05-15 07:13:04 ls- rlt
  454  2025-05-15 07:16:47 ls -rlt
  455  2025-05-15 07:16:55 more everyday-log.log
  456  2025-05-15 07:16:58
  457  2025-05-15 07:17:08 cd
  458  2025-05-15 07:17:17 cd data_conversion/produce-gsc-6/
  459  2025-05-15 07:17:20 ls -rlt
  460  2025-05-15 07:17:28 cat work_day01.sh
  461  2025-05-15 07:17:40 cd ./large_tiles/unosm/tile_day03
  462  2025-05-15 07:17:43 ls -rlt
  463  2025-05-15 07:17:56 cat 6-35-22.mbtiles-journal
  464  2025-05-15 07:28:24 PuTTYPuTTY
  465  2025-05-15 07:28:28 du -hs *
  466  2025-05-15 07:28:40 ls -rlt
  467  2025-05-15 07:28:51 cd ..
  468  2025-05-15 07:28:57 cd tile_day02
  469  2025-05-15 07:28:59 ls -rlt
  470  2025-05-15 07:29:06 cd ..
  471  2025-05-15 07:29:10 ls -rlt
  472  2025-05-15 07:29:17 cd tile_every
  473  2025-05-15 07:29:19 ls -rlt
  474  2025-05-15 07:29:23 cd ..
  475  2025-05-15 07:29:24 ls -rlt
  476  2025-05-15 07:29:34 ls -l tile_*/*
  477  2025-05-15 07:29:46 du -hs * tile_*/*
  478  2025-05-15 07:30:07 du -hs * tile_*/*mbtiles
  479  2025-05-15 07:30:20 du -hs tile_*/*mbtiles
  480  2025-05-15 07:30:29 du -hs tile_*/*mbtiles | more
  481  2025-05-15 07:31:11 du -hs tile_*/*
  482  2025-05-15 07:31:15
  483  2025-05-15 07:31:27 crontab -l
  484  2025-05-15 07:31:46 man 5 crontab
  485  2025-05-15 07:32:48 more /vtdata/data_conversion/cron-log/day3-log.log
  486  2025-05-15 07:37:44 ls -l produce-gsc-un/mbtiles/un_tile/6-32-17.mbtiles
  487  2025-05-15 07:37:54 cd produce-gsc-un/mbtiles/un_tile
  488  2025-05-15 07:38:01 cd --
  489  2025-05-15 07:38:09 d ..
  490  2025-05-15 07:38:14 pwd
  491  2025-05-15 07:38:18 cd
  492  2025-05-15 07:38:25 cd data_conversion/produce-gsc-6/
  493  2025-05-15 07:38:29 ls -l produce-gsc-un/mbtiles/un_tile
  494  2025-05-15 07:38:40 cd produce-gsc-un/mbtiles/un_tile
  495  2025-05-15 07:38:42 ls -rlt
  496  2025-05-15 07:44:42 cd ..
  497  2025-05-15 07:44:48 ls -rlt
  498  2025-05-15 07:44:57 cat work_day03.sh
  499  2025-05-15 07:46:52 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; date; echo  `basename ${f}`; ls -alh large_tiles/unosm/tile_day03/`basename ${f}` ;done
  500  2025-05-15 07:49:15 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; date; echo  `basename ${f}`; ls -1h large_tiles/unosm/tile_day03/`basename ${f}; ls -1h  produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  501  2025-05-15 07:50:59 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; date; echo  `basename ${f}`; ls -1h large_tiles/unosm/tile_day03/`basename ${f}; produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  502  2025-05-15 07:51:46 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; date; echo  `basename ${f}`; ls -1h large_tiles/unosm/tile_day03/`basename ${f}`; ls -1h produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  503  2025-05-15 07:53:09 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; echo  `basename ${f}`; ls -1h large_tiles/unosm/tile_day03/`basename ${f}`; ls -1h produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  504  2025-05-15 07:53:31 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; echo  `basename ${f}`; ls -lh large_tiles/unosm/tile_day03/`basename ${f}`; ls -1h produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  505  2025-05-15 07:53:44 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; echo  `basename ${f}`; ls -lh large_tiles/unosm/tile_day03/`basename ${f}`; ls -lh produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  506  2025-05-15 07:54:15 ls -l large_tiles/unosm/tile_day03/6-35-22.mbtiles*
  507  2025-05-15 07:54:26 cat large_tiles/unosm/tile_day03/6-35-22.mbtiles-journal
  508  2025-05-15 07:54:51 PuTTYPuTTY
  509  2025-05-15 07:55:10 ls -ld large_tiles/unosm/tile_day03/6-35-22.mbtiles
  510  2025-05-15 07:55:15 ls -ld large_tiles/unosm/tile_day03/6-35-22.mbtiles*
  511  2025-05-15 07:55:23 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; echo  `basename ${f}`; ls -lh large_tiles/unosm/tile_day03/`basename ${f}`; ls -lh produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  512  2025-05-15 07:55:36 ls -ld large_tiles/unosm/tile_day03/6-35-22.mbtiles*
  513  2025-05-15 07:56:12 ls -ld produce-gsc-un/mbtiles/un_tile/6-35-21.mbtiles*
  514  2025-05-15 07:56:33 ls -lh produce-gsc-un/mbtiles/un_tile/6-35-21.mbtiles*
  515  2025-05-15 07:56:44 cat produce-gsc-un/mbtiles/un_tile/6-35-21.mbtiles
  516  2025-05-15 07:57:02 ls -rlt
  517  2025-05-15 07:57:10 cat work_small.sh
  518  2025-05-15 07:57:52 ls -lh small_tiles/unosm/small-scale.mbtiles* produce-gsc-small/un-s-tile/0-0-0.mbtiles produce-gsc-small/osm-s-tile/0-0-0.mbtiles*
  519  2025-05-15 07:59:21 ls -l  produce-gsc-small/un-s-tile/0-0-0.mbtiles produce-gsc-small/osm-s-tile/0-0-0.mbtiles*
  520  2025-05-15 07:59:56 ls -l  produce-gsc-small/un-s-tile/0-0-0.mbtiles* produce-gsc-small/osm-s-tile/0-0-0.mbtiles*
  521  2025-05-15 08:00:18 ls -lrt
  522  2025-05-15 08:00:41 cat work_clearmap.sh
  523  2025-05-15 08:01:41 for f in produce-gsc-osm/mbtiles/osm_tile_day03/*.mbtiles; do echo /usr/local/bin/tile-join --no-tile-size-limit -f -o large_tiles/unosm/tile_day03/`basename ${f}` produce-gsc-un/mbtiles/un_tile/`basename ${f}` produce-gsc-osm/mbtiles/osm_tile_day03/`basename ${f}`; echo  `basename ${f}`; ls -lh large_tiles/unosm/tile_day03/`basename ${f}`; ls -lh produce-gsc-un/mbtiles/un_tile/`basename ${f}` ;done
  524  2025-05-15 08:02:10 ls -lh large_tiles/unosm/tile_day03/6-35-22.mbtiles* produce-gsc-un/mbtiles/un_tile/6-35-22.mbtiles*
  525  2025-05-15 08:02:32 more config/default.hjson
  526  2025-05-15 08:02:49 nc -zp unbs-r-db-02.global.un.org 5432
  527  2025-05-15 08:03:04 nc -zv unbs-r-db-02.global.un.org 5432
  528  2025-05-15 08:03:39 psql -U vectortile_reader -d un_base -h unbs-r-db-02.global.un.org
  529  2025-05-15 08:04:49 sl -rlt
  530  2025-05-15 08:04:55 more config/default
  531  2025-05-15 08:05:02 more config/default.hjson
  532  2025-05-15 08:06:27 nc -zv dfs-unvttlk-01.dpko.un.org 22
  533  2025-05-15 08:06:43 ssh dfs-unvttlk-01.dpko.un.org *
  534  2025-05-15 08:06:50 ssh dfs-unvttlk-01.dpko.un.org
  535  2025-05-15 08:07:31 ls -rlt
  536  2025-05-15 08:09:25 cat work_day03.sh
  537  2025-05-15 08:09:54 ls -lh produce-gsc-osm/mbtiles/osm_tile_day*/*
  538  2025-05-15 08:10:42 ls -lh produce-gsc-osm/mbtiles/osm_tile_day*/*mbtiles*
  539  2025-05-15 08:11:05 ls -lh produce-gsc-osm/mbtiles/osm_tile_day*/*mbtiles* | more
  540  2025-05-15 08:11:22
  541  2025-05-15 08:11:33 ls -lh produce-gsc-osm/mbtiles/osm_tile_day03/*mbtiles* | more
  542  2025-05-15 08:11:53 cat work_day03.sh
  543  2025-05-15 08:12:43 ls -lh large_tiles/unosm/tile_day03/*
  544  2025-05-15 08:13:06 ls -lh large_tiles/unosm/tile_day03/*mbtiles*
  545  2025-05-15 08:13:27 ls -lh large_tiles/unosm/tile_day03/*mbtiles
  546  2025-05-15 08:13:43 ls -lh large_tiles/unosm/tile_day03/6*mbtiles
  547  2025-05-15 08:13:49 ls -lh large_tiles/unosm/tile_day03/6*mbtiles | wc -l
  548  2025-05-15 08:14:25 ls -lh produce-gsc-osm/mbtiles/osm_tile_day03/*mbtiles*
  549  2025-05-15 08:14:31 ls -lh produce-gsc-osm/mbtiles/osm_tile_day03/*mbtiles* | wc -l
  550  2025-05-15 08:15:09 ls -lh large_tiles/unosm/tile_day03/6*mbtiles | wc -l
  551  2025-05-15 09:22:36 ls -rlt
  552  2025-05-15 09:22:39 cd log/
  553  2025-05-15 09:22:41 ls -rlt
  554  2025-05-15 09:22:51 tail -f produce-everyday-2025-05-15.log
  555  2025-05-15 09:23:04 ps -ef | grep vect
  556  2025-05-15 09:23:33 crontab -l
  557  2025-05-15 09:23:45 ps -ef | grep day
  558  2025-05-15 09:24:16 ps -ef | grep day5
  559  2025-05-15 09:24:26 ps -ef | grep day
  560  2025-05-15 09:24:41 date
  561  2025-05-15 09:25:01 crontab -l
  562  2025-05-15 09:25:26 ls -rlt
  563  2025-05-15 09:25:56 ls -l *day4*
  564  2025-05-15 09:26:02 ls -l *day04*
  565  2025-05-15 09:26:14 cat produce-day04-2025-05-01.log | more
  566  2025-05-15 09:26:22 ls -l *day04*
  567  2025-05-15 09:26:32 more produce-day04-2025-05-08.log
  568  2025-05-15 09:26:38
  569  2025-05-15 09:26:45 cd ..
  570  2025-05-15 09:26:51 crontab -l
  571  2025-05-15 09:27:01 cd /vtdata/data_conversion/cron-log/
  572  2025-05-15 09:27:03 ls -rlt
  573  2025-05-15 09:27:12 more day4-log.log
  574  2025-05-15 09:27:32 ls -rlt
  575  2025-05-15 09:28:06 more day3-log.log
  576  2025-05-15 09:28:44 grep "no such table" day3-log.log
  577  2025-05-15 09:28:55 grep "no such table" day3-log.log | wc -l
  578  2025-05-15 09:29:18 cd ..
  579  2025-05-15 09:29:25 pwd
  580  2025-05-15 09:29:33 cd produce-gsc-6/config/
  581  2025-05-15 09:29:42 more default.hjson
  582  2025-05-15 09:30:09 grep unbase default.hjson
  583  2025-05-15 09:30:19 grep un_base default.hjson
  584  2025-05-15 09:30:28 grep un_base default.hjson |wc -l
  585  2025-05-15 09:30:39 grep un_base default.hjson| more
  586  2025-05-15 09:31:00 vi default.hjson
  587  2025-05-15 09:32:53 grep un_base default.hjson| more
  588  2025-05-15 09:34:20 for row in $(grep un_base default.hjson | sed 's/  *//'); do echo $row; done
  589  2025-05-15 09:34:25 for row in $(grep un_base default.hjson | sed 's/  *//'); do echo $row; done | more
  590  2025-05-15 09:35:49 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' {print $1}'); echo $db; done
  591  2025-05-15 09:36:00 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); echo $db; done
  592  2025-05-15 09:36:06 for row in $(grep un_base default.hjson | sed 's/  *//'); do echo $row; done | more
  593  2025-05-15 09:37:23 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); echo $db $sc $tb; done
  594  2025-05-15 09:38:01 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf("%S%S%S\n), $db, $sc, $tb); done
  595  2025-05-15 09:38:10 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf("%S%S%S\n", $db, $sc, $tb); done
  596  2025-05-15 09:38:21 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf($db, $sc, $tb); done
  597  2025-05-15 09:39:28 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "%S%S%S\n" "$db" "$sc" "$tb"; done
  598  2025-05-15 09:39:48 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "%S %S %S\n" "$db" "$sc" "$tb"; done
  599  2025-05-15 09:39:58 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "%S %S %S \n" "$db" "$sc" "$tb"; done
  600  2025-05-15 09:40:36 name="John"
  601  2025-05-15 09:40:36 age=25
  602  2025-05-15 09:40:36 printf "Name: %s, Age: %d\n" "$name" "$age"
  603  2025-05-15 09:41:03 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "%s %s %s \n" "$db" "$sc" "$tb"; done
  604  2025-05-15 09:41:30 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h %s %s %s \n" "$db" "$sc" "$tb"; done
  605  2025-05-15 09:41:37 more default.hjson
  606  2025-05-15 09:42:37 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c "select from %s.%s limit 1;\n" "$db" "$sc" "$tb"; done
  607  2025-05-15 09:42:58 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1\";\n" "$db" "$sc" "$tb"; done
  608  2025-05-15 09:43:20 more default.hjson
  609  2025-05-15 09:43:39 export PG_PASSWORD=vtt_r_ungs
  610  2025-05-15 09:43:56 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1\";\n" "$db" "$sc" "$tb"; done
  611  2025-05-15 09:44:26 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_06_p limit 1;"
  612  2025-05-15 09:44:38 export PG_PASSWORD=vtt_r_ungs
  613  2025-05-15 09:44:40 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_06_p limit 1;"
  614  2025-05-15 09:45:43 export PGPASSWORD=vtt_r_ungs
  615  2025-05-15 09:45:45 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_06_p limit 1;"
  616  2025-05-15 09:46:21 more default.hjson
  617  2025-05-15 09:46:48 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_06_p limit 1;"
  618  2025-05-15 09:47:01 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base
  619  2025-05-15 09:47:11 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -W
  620  2025-05-15 09:47:36 export PGPASSWORD=vtt_r_ungsc
  621  2025-05-15 09:47:44 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_06_p limit 1;"
  622  2025-05-15 09:48:07 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1\";\n" "$db" "$sc" "$tb"; done
  623  2025-05-15 09:48:21 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_wbya_label_05_p limit 1";
  624  2025-05-15 09:48:38 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1;\"\n" "$db" "$sc" "$tb"; done
  625  2025-05-15 09:48:53 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1;\"\n" "$db" "$sc" "$tb"; done | head
  626  2025-05-15 09:49:05 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.custom_planet_land_08_a limit 1;"
  627  2025-05-15 09:49:23 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.un_glc30_global_lc_ss_a limit 1;"
  628  2025-05-15 09:49:55 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select from %s.%s limit 1;\"\n" "$db" "$sc" "$tb"; done >/tmp/test.sql
  629  2025-05-15 09:50:20 sh /tmp/test.ql
  630  2025-05-15 09:50:29 cat /tmp/test.sql
  631  2025-05-15 09:50:39 sh /tmp/test.sql
  632  2025-05-15 09:50:48 sh /tmp/test.sql | more
  633  2025-05-15 09:52:45 cat /tmp/test.sql | more
  634  2025-05-15 10:13:02 sh /tmp/test.sql | more
  635  2025-05-15 10:13:16 cat /tmp/test.sql
  636  2025-05-15 10:13:33 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_phyp_label_04_p limit 1;"
  637  2025-05-15 10:13:42 psql -h unbs-r-db-01.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.unmap_phyp_label_04_p limit 1;"
  638  2025-05-15 10:18:28 more default.hjson
  639  2025-05-15 10:24:57 grep custom_planet_land_main_a /tmp/test.sql
  640  2025-05-15 10:25:15 psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.custom_planet_land_main_a limit 1;"
  641  2025-05-15 10:25:45 psql -h unbs-r-db-01.global.un.org -U vectortile_reader -d un_base -c "select from vectortile.custom_planet_land_main_a limit 1;"
  642  2025-05-15 10:26:05 psql -h unbs-r-db-01.global.un.org -U vectortile_reader -d un_base
  643  2025-05-15 10:27:30 cat /tmp/test.sql
  644  2025-05-15 10:27:59 for row in $(grep un_base default.hjson | sed 's/  *//'); do db=$(echo $row | awk -F'::' '{print $1}'); sc=$(echo $row | awk -F'::' '{print $2}'); tb=$(echo $row | awk -F'::' '{print $3}'); printf "psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d %s -c \"select * from %s.%s limit 1;\"\n" "$db" "$sc" "$tb"; done >/tmp/test.sql
  645  2025-05-15 10:28:04 cat /tmp/test.sql
  646  2025-05-15 10:28:30 cd /tmp/
  647  2025-05-15 10:28:39 ls -rlt
  648  2025-05-15 10:28:44 sh test.sql
  649  2025-05-15 10:29:07 ls -rlt
  650  2025-05-15 10:29:09 cd
  651  2025-05-15 10:29:10 date
  652  2025-05-15 10:29:19 pwd
  653  2025-05-15 10:29:24 crontab -l
  654  2025-05-15 10:29:36 cd ps -ef | grep day
  655  2025-05-15 10:29:47 ps -ef | grep day
  656  2025-05-15 10:29:57 crontab -l
  657  2025-05-15 10:30:05 cd /vtdata/data_conversion/cron-log/
  658  2025-05-15 10:30:06 ls -rt
  659  2025-05-15 10:30:16 cat day4-log.log
  660  2025-05-15 10:30:26 ls -rlt
  661  2025-05-15 10:30:44 cat everyday-log.log
  662  2025-05-15 10:30:48 ls -rlt
  663  2025-05-15 10:30:53 cat everyday-log.log
  664  2025-05-15 10:31:06 ps -ef | grep day04
  665  2025-05-15 10:31:43 cd ..
  666  2025-05-15 10:31:44 ls -rlt
  667  2025-05-15 10:31:47 cd produce-gsc-6/
  668  2025-05-15 10:31:51 cd produce-gsc-un
  669  2025-05-15 10:31:53 ls -rlt
  670  2025-05-15 10:31:56 cd mbtiles/
  671  2025-05-15 10:31:58 ls -rlt
  672  2025-05-15 10:31:59 pwd
  673  2025-05-15 10:32:01 cd un_tile/
  674  2025-05-15 10:32:07 ls -lrt
  675  2025-05-15 10:32:11 cd
  676  2025-05-15 10:32:17 cd /vtdata/
  677  2025-05-15 10:32:24 cd data_conversion/
  678  2025-05-15 10:32:26 ls -rlt
  679  2025-05-15 10:32:30 cd produce-gsc-6/
  680  2025-05-15 10:32:32 ls -rlt
  681  2025-05-15 10:32:47 cd produce-gsc-un
  682  2025-05-15 10:32:50 cd .
  683  2025-05-15 10:32:51 cd lo
  684  2025-05-15 10:32:55 cd ..
  685  2025-05-15 10:32:57 cd log/
  686  2025-05-15 10:32:59 ls -rlt
  687  2025-05-15 10:33:08 more produce-day04-2025-05-15.log
  688  2025-05-15 10:33:19
  689  2025-05-22 14:22:05 crontab -l
  690  2025-05-22 14:22:21 ./work_day06.sh > /vtdata/data_conversion/cron-log/day6-log.log 2>&1
  691  2025-05-23 07:06:40 cat work_day06.sh
  692  2025-05-23 07:06:52 -alh large_tiles/unosm/tile_day06/*
  693  2025-05-23 07:07:03 ls -alh large_tiles/unosm/tile_day06/*
  694  2025-05-23 07:07:15 more large_tiles/unosm/tile_day06/4-8-10.mbtiles
  695  2025-05-23 07:07:26 df -h
  696  2025-05-23 07:33:17 node produce-gsc-un/index.js
  697  2025-05-22 14:04:25 cd data_conversion/produce-gsc-6/
  698  2025-05-22 14:04:26 ls -rlt
  699  2025-05-22 14:04:36 cd log/
  700  2025-05-22 14:04:38 ls -rlt
  701  2025-05-22 14:04:56 tail -100f produce-day06-2025-05-22.log
  702  2025-05-22 14:05:24 cd ..
  703  2025-05-22 14:05:25 ls -rlt
  704  2025-05-22 14:05:32 cd produce-gsc-osm
  705  2025-05-22 14:05:33 ls -rlt
  706  2025-05-22 14:05:38 cd mbtiles
  707  2025-05-22 14:05:39 ls -rlt
  708  2025-05-22 14:05:43 cd osm_tile_day06
  709  2025-05-22 14:05:44 ls -rlt
  710  2025-05-22 14:07:53 cd ..
  711  2025-05-22 14:07:54 ls -rlt
  712  2025-05-22 14:08:00 cd osm_tile_day05
  713  2025-05-22 14:08:01 ls -rlt
  714  2025-05-22 14:08:06 rm part-4-0-1*
  715  2025-05-22 14:08:08 ls -rlt
  716  2025-05-22 14:08:09 cd ..
  717  2025-05-22 14:08:13 ls -rlt
  718  2025-05-22 14:08:17 cd osm_tile_day07
  719  2025-05-22 14:08:19 ls -rlt
  720  2025-05-22 14:08:23 rm part-4-*
  721  2025-05-22 14:08:24 cd ..
  722  2025-05-22 14:08:26 ls -rlt
  723  2025-05-22 14:08:30 cd osm_tile_day01
  724  2025-05-22 14:08:32 ls -rlt
  725  2025-05-22 14:08:38 rm part-5-2*
  726  2025-05-22 14:08:40 ls -rlt
  727  2025-05-22 14:08:45 cd ..
  728  2025-05-22 14:08:46 ls -rlt
  729  2025-05-22 14:08:49 osm_tile_day02
  730  2025-05-22 14:08:53 cd osm_tile_day02
  731  2025-05-22 14:08:54 ls -rlt
  732  2025-05-22 14:09:03 cd ..
  733  2025-05-22 14:09:11 cd osm_tile_day03/
  734  2025-05-22 14:09:15 cd ..
  735  2025-05-22 14:09:24 cd osm_tile_day04
  736  2025-05-22 14:09:24 sl
  737  2025-05-22 14:09:28 cd ..
  738  2025-05-22 14:09:34 cd osm_tile_day05
  739  2025-05-22 14:09:37 cd ..
  740  2025-05-22 14:09:39 ls -rlt
  741  2025-05-22 14:09:43 cd osm_tile_day06
  742  2025-05-22 14:09:44 ls -rlt
  743  2025-05-22 14:09:53 cd ..
  744  2025-05-22 14:09:59 ls -rlt
  745  2025-05-22 14:10:03 cd ..
  746  2025-05-22 14:10:05 ls -rlt
  747  2025-05-22 14:10:09 cd produce-gsc-un
  748  2025-05-22 14:10:10 ls -rlt
  749  2025-05-22 14:10:14 cd mbtiles/
  750  2025-05-22 14:10:16 cd un_tile/
  751  2025-05-22 14:10:17 ls -rlt
  752  2025-05-22 14:10:31 ls -lrt
  753  2025-05-22 14:10:34 ls -lrt | more
  754  2025-05-22 14:10:39
  755  2025-05-22 14:10:51 rm 6-*
  756  2025-05-22 14:10:52 ls -rlt
  757  2025-05-22 14:11:00 rm 5-*
  758  2025-05-22 14:11:06 rm 4-*
  759  2025-05-22 14:11:08 sl -rlt
  760  2025-05-22 14:11:11 ls -rlt
  761  2025-05-22 14:11:16 rm *
  762  2025-05-22 14:11:18 ls -rlt
  763  2025-05-22 14:11:35 touch tile_here.txt
  764  2025-05-22 14:11:36 sl -rlt
  765  2025-05-22 14:11:38 ls -rlt
  766  2025-05-22 14:11:41 cd ..
  767  2025-05-22 14:11:46 ls -rlt
  768  2025-05-22 14:12:02 ls -l large_tiles/
  769  2025-05-22 14:12:11 cd large_tiles/unosm/
  770  2025-05-22 14:12:13 ls -rlt
  771  2025-05-22 14:12:19 cd tile_day05
  772  2025-05-22 14:12:20 ls -rlt
  773  2025-05-22 14:12:27 rm part-4-0-1*
  774  2025-05-22 14:12:29 cd ..
  775  2025-05-22 14:12:30 ls -rlt
  776  2025-05-22 14:12:58 rm tile_day0*/part-*
  777  2025-05-22 14:13:04 cd tile_day07
  778  2025-05-22 14:13:06 ls -rlt
  779  2025-05-22 14:13:07 cd ..
  780  2025-05-22 14:13:11 cd tile_day01
  781  2025-05-22 14:13:13 cd ..
  782  2025-05-22 14:13:16 cd tile_every
  783  2025-05-22 14:13:20 ls -rlt
  784  2025-05-22 14:13:41 cd ..
  785  2025-05-22 14:13:53 ls -lrt
  786  2025-05-22 14:13:56 cd log/
  787  2025-05-22 14:13:57 ls -rlt
  788  2025-05-22 14:14:08 tail -f produce-day06-2025-05-22.log
  789  2025-05-22 14:14:47 crontab -l
  790  2025-05-22 14:14:58 cd ..
  791  2025-05-22 14:14:59 ls -rlt
  792  2025-05-22 14:15:03 cat work_day01.sh
  793  2025-05-22 14:16:37 ls -rlt
  794  2025-05-22 14:16:45 cd produce-gsc-osm
  795  2025-05-22 14:16:47 ls -rlt
  796  2025-05-22 14:16:49 cd mbtiles/
  797  2025-05-22 14:16:51 ls -rlt
  798  2025-05-22 14:16:59 cd osm_tile_day06
  799  2025-05-22 14:17:00 ls -rlt
  800  2025-05-22 14:17:23 \rm part-4-*
  801  2025-05-22 14:17:25 ls -rlt
  802  2025-05-22 14:17:28 cd ..
  803  2025-05-22 14:17:34 ls -rlt
  804  2025-05-22 14:17:40 cd produce-gsc-un/mbtiles/
  805  2025-05-22 14:17:43 cd un_tile/
  806  2025-05-22 14:17:46 cd ..
  807  2025-05-22 14:17:52 ls -rlt
  808  2025-05-22 14:18:02 vi work_day06.sh
  809  2025-05-23 11:59:24 date
  810  2025-05-23 11:59:31 ps -ef | grep day
  811  2025-05-23 11:59:37 date
  812  2025-05-23 11:59:41 ps -ef | grep day
  813  2025-05-23 12:00:01 date
  814  2025-05-23 12:00:04 ps -ef | grep day
  815  2025-05-23 12:00:11 crontab -e
  816  2025-05-23 12:00:24 crontab -l
  817  2025-05-23 13:31:55 ls -rlt
  818  2025-05-23 13:32:02 cd produce-gsc-un/mbtiles/un_tile/
  819  2025-05-23 13:32:03 ls -rlt
  820  2025-05-23 13:32:57 cd
  821  2025-05-23 13:33:06 ps -ef | grep day5
  822  2025-05-23 13:33:20 cd data_conversion/produce-gsc-6/
  823  2025-05-23 13:33:21 ls -rlt
  824  2025-05-23 13:33:42 cd produce-gsc-osm/mbtiles/osm_tile_day05/
  825  2025-05-23 13:33:44 ls -rlt
  826  2025-05-23 13:34:20 cd ..
  827  2025-05-23 13:34:22 ls -rlt
  828  2025-05-23 13:34:23 cd
  829  2025-05-23 13:34:26 cd data_conversion/
  830  2025-05-23 13:34:29 ls -rlt
  831  2025-05-23 13:34:31 cd produce-gsc-6/
  832  2025-05-23 13:34:32 ls
  833  2025-05-23 13:34:34 ls -rlt
  834  2025-05-23 13:34:47 cd large_tiles/unosm/tile_day06/
  835  2025-05-23 13:34:49 ls -rlt
  836  2025-05-23 13:35:17 cd ..
  837  2025-05-23 13:35:19 ls -lrt
  838  2025-05-23 13:35:28 cd ..
  839  2025-05-23 13:35:31 ls -rlt
  840  2025-05-23 13:35:41 cat work_day06.sh
  841  2025-05-26 06:37:48 ls -lrt
  842  2025-05-26 06:37:53 crontab -l
  843  2025-05-26 06:38:12 cd /vtdata/data_conversion/cron-log
  844  2025-05-26 06:38:14 ls -rlt
  845  2025-05-26 06:38:21 cat day5-log.log
  846  2025-05-26 06:38:32 ls -rlt
  847  2025-05-26 06:38:36 cat day6-log.log
  848  2025-05-26 06:38:40 cd
  849  2025-05-26 06:38:51 cd data_conversion/produce-gsc-6/
  850  2025-05-26 06:38:53 ls -rlt
  851  2025-05-26 06:38:56 cd large_tiles/
  852  2025-05-26 06:38:58 ls -rlt
  853  2025-05-26 06:39:00 cd unosm/
  854  2025-05-26 06:39:02 ls -rlt
  855  2025-05-26 06:39:06 cd tile_day05
  856  2025-05-26 06:39:08 ls -rlt
  857  2025-05-16 06:26:03 cd data_conversion/produce-gsc-6/
  858  2025-05-16 06:26:04 ls -rlt
  859  2025-05-16 06:26:06 cd log/
  860  2025-05-16 06:26:07 ls -rlt
  861  2025-05-16 06:26:17 cat produce-day04-2025-05-15.log
  862  2025-05-16 06:26:27 ls -rlt
  863  2025-05-16 06:26:32 cat produce-day04-2025-05-16.log
  864  2025-05-16 06:26:38 cat produce-day04-2025-05-16.log| more
  865  2025-05-16 06:26:44                   ls- lrt
  866  2025-05-16 06:26:46 ls -rlt
  867  2025-05-16 06:26:53 more produce-day04-2025-05-15.log produce-day04-2025-05-16.log
  868  2025-05-16 06:27:05
  869  2025-05-16 06:27:06 ls -rlt
  870  2025-05-16 06:27:12 mire produce-everyday-2025-05-15.log
  871  2025-05-16 06:27:15 more produce-everyday-2025-05-15.log
  872  2025-05-16 06:27:24                            ls -rlt
  873  2025-05-16 06:27:31 more produce-everyday-2025-05-16.log
  874  2025-05-16 06:27:34
  875  2025-05-16 06:27:39 ls -rlt
  876  2025-05-16 06:27:52 more produce-day03-2025-05-14.log
  877  2025-05-16 06:27:57                  ls -rlt
  878  2025-05-16 06:28:01 more produce-day03-2025-05-15.log
  879  2025-05-16 06:28:12 cd ..
  880  2025-05-16 06:28:14 ls -rlt
  881  2025-05-16 06:28:21 crontab -l
  882  2025-05-16 06:28:32 cd  /vtdata/data_conversion/cron-log/
  883  2025-05-16 06:28:33 ls -rlt
  884  2025-05-16 06:28:39 cat day4-log.log
  885  2025-05-16 06:28:44 more day4-log.log
  886  2025-05-16 06:28:47
  887  2025-05-16 06:28:49 ls -rlt
  888  2025-05-16 06:28:54 more day3-log.log
  889  2025-05-16 06:29:10
  890  2025-05-16 06:29:13 ls -rlt
  891  2025-05-16 06:29:19 cat day4-log.log
  892  2025-05-16 06:29:25 ps -ef | grep day
  893  2025-05-16 06:30:06 ls -lrt
  894  2025-05-16 06:30:27 more day4-log.log
  895  2025-05-16 06:30:52   ls -lrt
  896  2025-05-16 06:30:56 more everyday-log.log
  897  2025-05-16 07:03:58 ls -rlt
  898  2025-05-16 07:04:04 more day4-log.log
  899  2025-05-16 07:04:12          date
  900  2025-05-16 07:04:20 crontab -e
  901  2025-05-16 07:06:48 man 5 crontab
  902  2025-05-16 07:06:56 crontab -e
  903  2025-05-16 07:07:09 ls -rlt
  904  2025-05-16 07:07:16 ls -l
  905  2025-05-16 07:12:35 crontab -l
  906  2025-05-16 07:12:47 crontab -l | grep -v ^#
  907  2025-05-16 07:13:03 cd ..
  908  2025-05-16 07:13:12 diff ./work_day02.sh ./work_day04.sh
  909  2025-05-16 07:13:17 cd produce-gsc-6/
  910  2025-05-16 07:13:19 diff ./work_day02.sh ./work_day04.sh
  911  2025-05-16 07:13:46 diff produce-gsc-osm/index_day02.js produce-gsc-osm/index_day04.js
  912  2025-05-16 07:14:22 cd produce-gsc-osm/
  913  2025-05-16 07:14:32 diff index_day01.js index_day02.js
  914  2025-05-16 07:14:51 ls -rlt
  915  2025-05-16 07:15:00 cat index_day07.js
  916  2025-05-16 07:15:05 diff index_day01.js index_day02.js
  917  2025-05-16 07:15:31 crontab -l | grep -v ^#
  918  2025-05-16 07:16:18 man 5 crontab
  919  2025-05-16 07:16:52 crontab -l
  920  2025-05-16 07:16:56 crontab -e
  921  2025-05-16 07:30:43 ls -lrt
  922  2025-05-16 07:30:46 cd ..
  923  2025-05-16 07:30:48 ls -rlt
  924  2025-05-16 07:31:02 vi run_work_day.sh
  925  2025-05-16 07:32:39 crontab -l
  926  2025-05-16 07:32:56 crontab -e
  927  2025-05-16 07:33:02 vi run_work_day.sh
  928  2025-05-16 07:39:03 chmod +x run_work_day.sh
  929  2025-05-16 07:39:06 ./run_work_day.sh
  930  2025-05-16 07:39:11 vi run_work_day.sh
  931  2025-05-16 07:41:46 ./run_work_day.sh
  932  2025-05-16 07:41:50 vi run_work_day.sh
  933  2025-05-16 07:42:21 ./run_work_day.sh
  934  2025-05-16 07:42:24 vi run_work_day.sh
  935  2025-05-16 07:42:45 ./run_work_day.sh
  936  2025-05-16 07:43:02 ls -ld work_5.sh
  937  2025-05-16 07:43:07 ls -lrt
  938  2025-05-16 07:43:21 vi run_work_day.sh
  939  2025-05-16 07:43:46 ./run_work_day.sh
  940  2025-05-16 07:43:56 ls -l ./work_day05.sh
  941  2025-05-16 07:44:08 cat run_work_day.sh
  942  2025-05-16 07:45:25 date +%w
  943  2025-05-16 07:45:36 date +%m | sed 's/^0*//'
  944  2025-05-16 07:45:51 ls -lrt
  945  2025-05-16 07:45:57 vi run_work_day.sh
  946  2025-05-16 07:46:50 ./run_work_day.sh
  947  2025-05-16 07:46:53 vi run_work_day.sh
  948  2025-05-16 07:47:25 ./run_work_day.sh
  949  2025-05-16 07:47:36 vi run_work_day.sh
  950  2025-05-16 07:48:10 ./run_work_day.sh
  951  2025-05-16 07:48:13 vi run_work_day.sh
  952  2025-05-16 07:48:19 ./run_work_day.sh
  953  2025-05-16 07:48:36 vi run_work_day.sh
  954  2025-05-16 07:48:52 ./run_work_day.sh
  955  2025-05-16 07:49:17 vi run_work_day.sh
  956  2025-05-16 07:49:42 crontab -l | grep -v ^#
  957  2025-05-16 07:50:40 crontab -e
  958  2025-05-16 08:01:13 ls- l work_day05.sh
  959  2025-05-16 08:01:18 ls- l work_day0*.sh
  960  2025-05-16 08:01:21 ls -rlt
  961  2025-05-16 08:01:32 ls -l work_day0*.sh
  962  2025-05-16 08:01:39 ls -1 work_day0*.sh
  963  2025-05-16 08:12:56 crontab -e
  964  2025-05-16 08:28:58 crontab -l
  965  2025-05-16 12:24:29 cd /vtdata/data_conversion/cron-log/
  966  2025-05-16 12:24:30 ls -rlt
  967  2025-05-16 12:24:37 tail -f day4-log.log
  968  2025-05-16 12:24:43 vi day4-log.log
  969  2025-05-16 12:25:08 ls -rlt
  970  2025-05-16 12:25:14 cat everyday-log.log
  971  2025-05-16 14:01:36 ls -rlt
  972  2025-05-16 14:01:40 cat everyday-log.log
  973  2025-05-16 14:01:44 cd
  974  2025-05-16 14:01:50 cd data_conversion/
  975  2025-05-16 14:01:52 ls -rlt
  976  2025-05-16 14:01:54 cd produce-gsc-6/
  977  2025-05-16 14:01:56 ls -rlt
  978  2025-05-16 14:02:33 cat \rm run_work_day.sh
  979  2025-05-16 14:02:43 ls -rlt
  980  2025-05-16 14:02:52 rm run_work_day.sh
  981  2025-05-16 14:03:01 cat work_undata.sh
  982  2025-05-16 14:03:09 cat work_every.sh
  983  2025-05-19 06:41:06 ls -rlt
  984  2025-05-19 06:43:34 crontab -l
  985  2025-05-20 09:46:56 cd  /vtdata/data_conversion/cron-log/
  986  2025-05-20 09:46:57 ls -rlt
  987  2025-05-20 09:47:06 cat day3-log.log
  988  2025-05-20 09:47:46 ls -rlt
  989  2025-05-20 09:47:50 more day4-log.log
  990  2025-05-20 09:48:19            ls -lrt
  991  2025-05-20 09:48:24 more day3-log.log
  992  2025-05-20 09:50:05  cd
  993  2025-05-20 09:50:08 ls -lrt
  994  2025-05-20 09:50:11 cd data_conversion/
  995  2025-05-20 09:50:13 cd produce-gsc-6/
  996  2025-05-20 09:50:15 ls -rlt
  997  2025-05-20 09:50:16 cd config/
  998  2025-05-20 09:50:17 ls -rlt
  999  2025-05-20 09:50:22 more default.hjson
 1000  2025-05-20 09:51:04 crontab -l
 1001  2025-05-20 09:51:12 cd  /vtdata/data_conversion/cron-log/
 1002  2025-05-20 09:51:14 ls -rlt
 1003  2025-05-20 09:51:25 tail -f day3-log.log
 1004  2025-05-20 09:51:33 more day3-log.log
 1005  2025-05-20 09:51:52 cd -
 1006  2025-05-20 09:52:00 grep 6-35-21 default.hjson
 1007  2025-05-20 09:52:10 vi default.hjson
 1008  2025-05-20 09:52:58 cd -
 1009  2025-05-20 09:53:02 more day3-log.log
 1010  2025-05-20 09:53:21 cd -
 1011  2025-05-20 09:53:24 vi default.hjson
 1012  2025-05-20 09:56:26 cd -
 1013  2025-05-20 09:56:28 ls -lrt
 1014  2025-05-20 09:57:21 cd -
 1015  2025-05-20 09:57:26 cd ..
 1016  2025-05-20 09:57:27 ls -rlt
 1017  2025-05-20 09:57:33 cat work_day01.sh
 1018  2025-05-20 09:57:41 diff work_day01.sh work_day02.sh
 1019  2025-05-20 09:58:02 diff produce-gsc-osm/index_day01.js produce-gsc-osm/index_day02.js
 1020  2025-05-20 09:58:31 grep day01Tilelist config/default.hjson
 1021  2025-05-20 09:58:40 vi config/default.hjson
 1022  2025-05-20 12:29:29 ls -rlt
 1023  2025-05-20 12:29:33 df -h
 1024  2025-05-20 12:29:38 crontab -l
 1025  2025-05-20 12:29:45 cd /vtdata/data_conversion/cron-log/
 1026  2025-05-20 12:29:46 ls -rlt
 1027  2025-05-20 12:29:53 cat day3-log.log
 1028  2025-05-20 12:29:56 ls -rlt
 1029  2025-05-20 12:30:02 cat day4-log.log
 1030  2025-05-20 12:30:35 cat day3-log.log
 1031  2025-05-20 12:31:44 ls -rlt
 1032  2025-05-21 06:27:58 cd /vtdata/data_conversion/produce-gsc-6/large_tiles/unosm
 1033  2025-05-21 06:28:00 ls -rlt
 1034  2025-05-21 06:28:07 cd tile_day03
 1035  2025-05-21 06:28:09 ls -rlt
 1036  2025-05-21 06:28:18 cat 6-35-22.mbtiles-journal
 1037  2025-05-21 06:29:23 cd  produce-gsc-un/mbtiles/un_tile/
 1038  2025-05-21 06:29:26 cd ..
 1039  2025-05-21 06:29:28 cd
 1040  2025-05-21 06:29:34 cd data_conversion/produce-gsc-6/
 1041  2025-05-21 06:29:35 cd  produce-gsc-un/mbtiles/un_tile/
 1042  2025-05-21 06:29:37 ls -rlt
 1043  2025-05-21 06:29:52 ls -lrh
 1044  2025-05-21 06:30:05 du -hs *
 1045  2025-05-21 06:31:10 cd ..
 1046  2025-05-21 06:31:12 ls -rlt
 1047  2025-05-21 06:31:21 cd ..
 1048  2025-05-21 06:31:24 ls -rlt
 1049  2025-05-21 06:31:33 cd large_tiles
 1050  2025-05-21 06:31:34 ls -rlt
 1051  2025-05-21 06:31:37 cd unosm/
 1052  2025-05-21 06:31:41 cd tile_day03
 1053  2025-05-21 06:31:43 du -hs *
 1054  2025-05-21 06:31:54 df -h
 1055  2025-05-21 06:32:03 crontab -l
 1056  2025-05-21 06:32:09 cd  /vtdata/data_conversion/cron-log/
 1057  2025-05-21 06:32:11 ls -rlt
 1058  2025-05-21 06:32:22 ps -ef | grep day
 1059  2025-05-21 06:32:39 ps -ef | grep work
 1060  2025-05-21 06:35:20 date
 1061  2025-05-21 06:35:24 cd ..
 1062  2025-05-21 06:35:26 ls -rlt
 1063  2025-05-21 06:35:30 cd produce-gsc-6/
 1064  2025-05-21 06:35:33 ls -rlt
 1065  2025-05-21 06:35:36 cd small_tiles/
 1066  2025-05-21 06:35:37 ls -rlt
 1067  2025-05-21 06:35:39 cd unosm/
 1068  2025-05-21 06:35:43 cd ..
 1069  2025-05-21 06:35:48 cd config/
 1070  2025-05-21 06:35:50 ls -rlt
 1071  2025-05-21 06:35:53 vi default.hjson
 1072  2025-05-21 06:36:39 cd ..
 1073  2025-05-21 06:36:45 cd produce-gsc-small/
 1074  2025-05-21 06:36:47 ls -rlt
 1075  2025-05-21 06:36:50 cd un-s-tile/
 1076  2025-05-21 06:36:54 du -hs *
 1077  2025-05-21 06:36:55 cd ..
 1078  2025-05-21 06:36:57 cd osm-s-tile/
 1079  2025-05-21 06:37:00 du -hs *
 1080  2025-05-21 06:37:10 \rm 0-0-0.mbtiles
 1081  2025-05-21 06:37:12 cd ..
 1082  2025-05-21 06:37:14 cd un-s-tile/
 1083  2025-05-21 06:37:17 cd ..
 1084  2025-05-21 06:37:18 ls -rlt
 1085  2025-05-21 06:37:21 cd un-s-tile/
 1086  2025-05-21 06:37:22 ls -rlt
 1087  2025-05-21 06:37:27 \rm 0-0-0.mbtiles
 1088  2025-05-21 06:37:28 ls -rlt
 1089  2025-05-21 06:37:30 cd ..
 1090  2025-05-21 06:37:33 cd osm-s-tile/
 1091  2025-05-21 06:37:34 ls -rlt
 1092  2025-05-21 06:37:35 cd ..
 1093  2025-05-21 06:37:41 ls -rlt
 1094  2025-05-21 06:37:52 ./work_small.sh
 1095  2025-05-21 07:06:38 ls -rlt
 1096  2025-05-21 07:06:43 cd produce-gsc-small
 1097  2025-05-21 07:06:45 ls -rlt
 1098  2025-05-21 07:06:50 cd un-s-tile
 1099  2025-05-21 07:06:51 ls -rlt
 1100  2025-05-21 07:06:55 du -hs *
 1101  2025-05-21 07:07:00 cd ..
 1102  2025-05-21 07:07:01 cd osm-s-tile/
 1103  2025-05-21 07:07:03 ls -rlt
 1104  2025-05-21 07:07:06 du -hs *
 1105  2025-05-21 07:07:09 cd ..
 1106  2025-05-21 07:07:12 ls -rlt
 1107  2025-05-21 07:07:40 cd produce-gsc-osm
 1108  2025-05-21 07:07:42 ls -rlt
 1109  2025-05-21 07:07:45 cd mbtiles/
 1110  2025-05-21 07:07:49 ls -rlt
 1111  2025-05-21 07:07:51 pwd
 1112  2025-05-21 07:08:00 ls -rlt
 1113  2025-05-21 07:08:05 cd osm_tile_day03
 1114  2025-05-21 07:08:07 ls -rlt
 1115  2025-05-21 07:08:18 cd ..
 1116  2025-05-21 07:08:22 ls -rlt
 1117  2025-05-21 07:08:32 cat work_day03.sh
 1118  2025-05-21 07:08:40 ls -rlt
 1119  2025-05-21 07:08:46 cd large_tiles/
 1120  2025-05-21 07:08:48 ls -rlt
 1121  2025-05-21 07:08:49 cd unosm/
 1122  2025-05-21 07:08:51 ls -rlt
 1123  2025-05-21 07:08:56 cd tile_day03
 1124  2025-05-21 07:08:57 sl -rlt
 1125  2025-05-21 07:08:59 ùls -rlt
 1126  2025-05-21 07:09:01 ls -rlt
 1127  2025-05-21 07:56:16 cd ..
 1128  2025-05-21 07:56:18 ls -rlt
 1129  2025-05-21 07:56:30 cd ..
 1130  2025-05-21 07:56:33 ls -rlt
 1131  2025-05-21 07:56:47 cd large_tiles
 1132  2025-05-21 07:56:54 cd --
 1133  2025-05-21 07:56:57 cd -
 1134  2025-05-21 07:57:00 cd ..
 1135  2025-05-21 07:57:02 ls -rlt
 1136  2025-05-21 07:57:08 crontab -l
 1137  2025-05-21 07:57:17 cd  /vtdata/data_conversion/cron-log/
 1138  2025-05-21 07:57:19 ls -rlt
 1139  2025-05-21 07:57:26 cat day3-log.log
 1140  2025-05-21 07:57:39 cd -
 1141  2025-05-21 07:57:41 ls -lrt
 1142  2025-05-21 07:57:47 cd config/
 1143  2025-05-21 07:57:48 ls -rlt
 1144  2025-05-21 07:57:54 more default.hjson
 1145  2025-05-21 08:02:32 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); done
 1146  2025-05-21 08:02:38 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); echo $db; done
 1147  2025-05-21 08:04:04 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo $db $schema $view; done
 1148  2025-05-21 08:04:16 more default.hjson
 1149  2025-05-21 08:06:25 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo $schema.%view; echo psql -U vectortile_reader -d $db -c "\"select osmid $schema.$view limit 1;\""; done
 1150  2025-05-21 08:07:30 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo -e "$schema.%view :"; echo -e psql -U vectortile_reader -d $db -c "\"select osmid from $schema.$view limit 1;\"\n"; done
 1151  2025-05-21 08:07:47 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo -e "$schema.%view :"; echo -e psql -U vectortile_reader -d $db -c "\"select osmid from $schema.$view limit 1;\""; done
 1152  2025-05-21 08:08:03 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; echo psql -U vectortile_reader -d $db -c "\"select osmid from $schema.$view limit 1;\""; done
 1153  2025-05-21 08:08:38 more default.hjson
 1154  2025-05-21 08:09:16 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; echo psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "\"select osmid from $schema.$view limit 1;\""; done
 1155  2025-05-21 08:10:00 export PGPASSWORD=vtt_r_ungsc
 1156  2025-05-21 08:10:24 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select osmid from $schema.$view limit 1;"; done
 1157  2025-05-21 08:10:36 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select osm_id from $schema.$view limit 1;"; done
 1158  2025-05-21 08:10:51 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select id from $schema.$view limit 1;"; done
 1159  2025-05-21 08:11:28  psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d un_base
 1160  2025-05-21 08:12:02 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.%view :"; psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;"; done
 1161  2025-05-21 08:12:28 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.$view :"; psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;"; done | more
 1162  2025-05-21 08:13:59 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.$view :"; oid=`psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;" | sed -n '2p'`; echo $oid; done | more
 1163  2025-05-21 08:14:08 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); echo "$schema.$view :"; oid=`psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;" | sed -n '3p'`; echo $oid; done | more
 1164  2025-05-21 08:14:55 for row in $(sed -n '/un-l/,/mbtilesDir/p' default.hjson | grep "un_base::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); oid=`psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;" | sed -n '3p'`; echo "$schema.$view : $oid"; done | more
 1165  2025-05-21 08:15:22 more default.hjson
 1166  2025-05-21 08:17:03 for row in $(sed -n '/osm-l/,/mbtilesDir/p' default.hjson | grep "osm_planet::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); oid=`psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select objectid from $schema.$view limit 1;" | sed -n '3p'`; echo "$schema.$view : $oid"; done | more
 1167  2025-05-21 08:17:25 for row in $(sed -n '/osm-l/,/mbtilesDir/p' default.hjson | grep "osm_planet::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); oid=`psql -h unbs-r-db-02.global.un.org -U vectortile_reader -d $db -c "select osm_id from $schema.$view limit 1;" | sed -n '3p'`; echo "$schema.$view : $oid"; done | more
 1168  2025-05-21 08:17:41 more default.hjson
 1169  2025-05-21 08:18:04 for row in $(sed -n '/osm-l/,/mbtilesDir/p' default.hjson | grep "osm_planet::vectortile::" | sed 's/ *//'); do db=$(echo $row | awk -F '::' '{print $1}'); schema=$(echo $row | awk -F '::' '{print $2}'); view=$(echo $row | awk -F '::' '{print $3}'); oid=`psql -h unosm-r-app-02.global.un.org -U vectortile_reader -d $db -c "select osm_id from $schema.$view limit 1;" | sed -n '3p'`; echo "$schema.$view : $oid"; done | more
 1170  2025-05-21 09:00:05 cd ..
 1171  2025-05-21 09:00:07 ls -rlt
 1172  2025-05-21 09:00:24 cd large_tiles
 1173  2025-05-21 09:00:26 ls -rlt
 1174  2025-05-21 09:00:28 cd unosm/
 1175  2025-05-21 09:00:30 ls -rlt
 1176  2025-05-21 09:00:36 cd tile_day03
 1177  2025-05-21 09:00:37 ls -rlt
 1178  2025-05-21 09:00:55 ls -rlt | head
 1179  2025-05-21 09:02:07 cd ..
 1180  2025-05-21 09:02:10 ls- lrt
 1181  2025-05-21 09:02:13 ls -rlt
 1182  2025-05-21 09:02:14 cd ..
 1183  2025-05-21 09:02:16 ls -rlt
 1184  2025-05-21 09:02:38 cat work_day03.sh
 1185  2025-05-21 09:03:01 cd produce-gsc-un/mbtiles/un_tile
 1186  2025-05-21 09:03:04 ls -rlt
 1187  2025-05-21 09:03:11 ls -rlt | head
 1188  2025-05-21 09:04:00 cd ..
 1189  2025-05-21 09:04:06 ls -rlt
 1190  2025-05-21 09:04:12 cd large_tiles
 1191  2025-05-21 09:04:15 ls -rlt
 1192  2025-05-21 09:04:17 cd unosm/
 1193  2025-05-21 09:04:19 ls -rlt
 1194  2025-05-21 09:04:38 cd ..
 1195  2025-05-21 09:04:40 ls -rlt
 1196  2025-05-21 09:04:45 cd produce-gsc-un
 1197  2025-05-21 09:04:46 ls -rlt
 1198  2025-05-21 09:04:51 cd mbtiles
 1199  2025-05-21 09:04:52 ls -rlt
 1200  2025-05-21 09:04:55 cd un_tile/
 1201  2025-05-21 09:04:56 ls -rlt
 1202  2025-05-21 09:05:31 crontab -l
 1203  2025-05-21 09:05:41 date
 1204  2025-05-21 09:11:23 cd ..
 1205  2025-05-21 09:11:26 ls -rlt
 1206  2025-05-21 09:11:30 cd ..
 1207  2025-05-21 09:11:32 ls -rlt
 1208  2025-05-21 09:13:02 cd produce-gsc-un
 1209  2025-05-21 09:13:04 ls -rlt
 1210  2025-05-21 09:13:07 cd mbtiles/
 1211  2025-05-22 13:32:39 crontab -l
 1212  2025-05-22 13:32:52 cd ..
 1213  2025-05-22 13:33:06 cat work_day01.sh
 1214  2025-05-22 13:34:49 ls -lrt
 1215  2025-05-22 13:35:25 ls -rlt
 1216  2025-05-22 13:35:33 cd produce-gsc-osm
 1217  2025-05-22 13:35:35 ls -rlt
 1218  2025-05-22 13:35:40 cd mbtiles
 1219  2025-05-22 13:35:42 ls -rlt
 1220  2025-05-22 13:35:51 cd osm_tile_day04
 1221  2025-05-22 13:35:54 ls -rlt
 1222  2025-05-22 13:36:05 cd ..
 1223  2025-05-22 13:36:07 ls -rlt
 1224  2025-05-22 13:36:19 cd osm_tile_day03
 1225  2025-05-22 13:36:20 ls -rlt
 1226  2025-05-22 13:36:31 cd ..
 1227  2025-05-22 13:36:33 ls -rlt
 1228  2025-05-22 13:36:37 cd osm_tile_day01
 1229  2025-05-22 13:36:39 ls -rlt
 1230  2025-05-22 13:36:54 cd ..
 1231  2025-05-22 13:36:55 ls -rlt
 1232  2025-05-22 13:37:02 cd osm_tile_day02
 1233  2025-05-22 13:37:04 ls -rlt
 1234  2025-05-22 13:37:16 ps -ef | grep day
 1235  2025-05-22 13:37:34 cd ..
 1236  2025-05-22 13:37:35 ls -rlt
 1237  2025-05-22 13:37:52 cd ..
 1238  2025-05-22 13:37:55 ls -rlt
 1239  2025-05-22 13:38:02 cat work_day07.sh
 1240  2025-05-22 13:38:15 cd produce-gsc-un/mbtiles/un_tile/
 1241  2025-05-22 13:38:18 ls -rlt
 1242  2025-05-22 13:38:22 pwd
 1243  2025-05-22 13:38:38 cd
 1244  2025-05-22 13:38:40 ls -rlt
 1245  2025-05-22 13:38:46 cd data_conversion/
 1246  2025-05-22 13:38:48 ls -rlt
 1247  2025-05-22 13:38:51 cd produce-gsc-6/
 1248  2025-05-22 13:38:52 ls -rlt
 1249  2025-05-22 13:38:57 cd small_tiles
 1250  2025-05-22 13:38:59 ls -rlt
 1251  2025-05-22 13:39:07 cd cd ..
 1252  2025-05-22 13:39:10 cat work_small.sh
 1253  2025-05-22 13:39:16 cd ..
 1254  2025-05-22 13:39:17 cat work_small.sh
 1255  2025-05-22 13:39:26 cd  ./small_tiles/unosm/
 1256  2025-05-22 13:39:49 ls -lrt
 1257  2025-05-22 13:40:01 cd  produce-gsc-small/
 1258  2025-05-22 13:40:02 d ..
 1259  2025-05-22 13:40:04 cd ..
 1260  2025-05-22 13:40:06 cd  produce-gsc-small/
 1261  2025-05-22 13:40:11 cd ..
 1262  2025-05-22 13:40:13 cd  produce-gsc-small/
 1263  2025-05-22 13:40:15 ls -rlt
 1264  2025-05-22 13:40:20 cd osm-s-tile
 1265  2025-05-22 13:40:21 ls -rlt
 1266  2025-05-22 13:40:34 du -hs 0-0-0.mbtiles
 1267  2025-05-22 13:40:38 cd ..
 1268  2025-05-22 13:40:40 ls -rlt
 1269  2025-05-22 13:40:44 cd un-s-tile
 1270  2025-05-22 13:40:45 ls -rlt
 1271  2025-05-22 13:40:52 du -hs 0-0-0.mbtiles
 1272  2025-05-22 13:43:28 cd ..
 1273  2025-05-22 13:43:34 ls -rlt
 1274  2025-05-22 13:43:55 cd config/
 1275  2025-05-22 13:43:57 ls -rlt
 1276  2025-05-22 13:44:12 mv default.hjson _default.hjson_
 1277  2025-05-22 13:44:21 vi default.hjson
 1278  2025-05-22 13:46:01 vi _default.hjson_
 1279  2025-05-22 13:47:53 ls -rlt
 1280  2025-05-22 13:48:02 cp _default.hjson_ default.hjson
 1281  2025-05-22 13:48:06 vi default.hjson
 1282  2025-05-22 13:49:18 cd ..
 1283  2025-05-22 13:49:19 ls -rlt
 1284  2025-05-22 13:50:43 node produce-gsc-un/index.js
 1285  2025-05-22 13:51:59 cd config/
 1286  2025-05-22 13:52:03 ls -rlt
 1287  2025-05-22 13:52:07 vi default.hjson
 1288  2025-05-22 13:53:09 cd ..
 1289  2025-05-22 13:53:11 ls -rlt
 1290  2025-05-22 13:53:32 cd produce-gsc-un
 1291  2025-05-22 13:53:34 ls -rlt
 1292  2025-05-22 13:53:36 cd mbtiles/
 1293  2025-05-22 13:53:38 ls -rlt
 1294  2025-05-22 13:53:42 cd un_tile/
 1295  2025-05-22 13:53:43 ls -rlt
 1296  2025-05-22 13:54:09 more 4-8-10.mbtiles
 1297  2025-05-22 13:54:19 cd ..
 1298  2025-05-22 13:54:22 ls -rlt
 1299  2025-05-22 13:54:29 cd ..
 1300  2025-05-22 13:54:31 ls -rlt
 1301  2025-05-22 13:54:35 cd config/
 1302  2025-05-22 13:54:36 ls -rlt
 1303  2025-05-22 13:54:44 vi _default.hjson_
 1304  2025-05-22 13:55:21 cat default.hjson
 1305  2025-05-22 13:56:08 cp default.hjson default.hjson_20250522
 1306  2025-05-22 13:56:24 cp _default.hjson_ default.hjson
 1307  2025-05-22 13:56:27 vi default.hjson
 1308  2025-05-22 13:56:50 cd ..
 1309  2025-05-22 13:56:51 ls -rlt
 1310  2025-05-22 13:56:58 cd produce-gsc-osm
 1311  2025-05-22 13:57:00 ls -rlt
 1312  2025-05-22 13:57:04 cd mbtiles/
 1313  2025-05-22 13:57:06 ls -rlt
 1314  2025-05-22 13:57:16 cd ..
 1315  2025-05-22 13:57:19 cd config/
 1316  2025-05-22 13:57:20 ls -rlt
 1317  2025-05-22 13:57:27 cat default.hjson_20250522
 1318  2025-05-22 13:57:39 cd ..
 1319  2025-05-22 13:57:41 sl -rlt
 1320  2025-05-22 13:57:43 ls -rlt
 1321  2025-05-22 13:57:49 cd produce-gsc-osm
 1322  2025-05-22 13:57:51 ls -rlt
 1323  2025-05-22 13:57:54 cd mbtiles/
 1324  2025-05-22 13:57:56 ls -rlt
 1325  2025-05-22 13:58:39 cd ..
 1326  2025-05-22 13:58:42 ls -rlt
 1327  2025-05-22 13:58:46 cd ..
 1328  2025-05-22 14:00:12 ls -l produce-gsc-osm/index_day06.js
 1329  2025-05-22 14:00:29 cd config/
 1330  2025-05-22 14:00:31 ls -rlt
 1331  2025-05-22 14:00:35 cat default.hjson
 1332  2025-05-22 14:00:39 ls -rlt
 1333  2025-05-22 14:00:47 \rm default.hjson
 1334  2025-05-22 14:00:55 mv default.hjson_20250522 default.hjson
 1335  2025-05-22 14:00:57 ls -rlt
 1336  2025-05-22 14:01:00 cat default.hjson
 1337  2025-05-22 14:01:21 cd ..
 1338  2025-05-22 14:01:22 ls -rlt
 1339  2025-05-22 14:01:45 node produce-gsc-osm/index_day06.js
 1340  2025-05-22 14:20:58 node produce-gsc-un/index.js
 1341  2025-05-22 14:21:11 ls -rlt
 1342  2025-05-22 14:21:34 crontab -l
 1343  2025-05-22 14:22:00 tmux
 1344  2025-05-22 14:22:30 cd log/
 1345  2025-05-22 14:22:32 ls -rlt
 1346  2025-05-22 14:22:39 tail -f produce-day06-2025-05-22.log
 1347  2025-05-22 14:22:51 cd ..
 1348  2025-05-22 14:22:52 ls -rlt
 1349  2025-05-22 14:23:08 cd produce-gsc-osm/mbtiles/osm_tile_day06/
 1350  2025-05-22 14:23:10 sl -rlt
 1351  2025-05-22 14:23:12 ls -rlt
 1352  2025-05-22 14:23:17 cd ..
 1353  2025-05-22 14:23:28 cd produce-gsc-un/mbtiles/un_tile/
 1354  2025-05-22 14:23:30 ls -rlt
 1355  2025-05-22 14:29:32 ssh 10.130.202.38
 1356  2025-05-22 14:29:48 ls -rlt
 1357  2025-05-23 07:05:41 ls -lrt
 1358  2025-05-23 07:06:00 ls -l
 1359  2025-05-23 07:06:14 tmux ls
 1360  2025-05-23 07:06:18 tmux attach-session
 1361  2025-05-23 07:07:36 ls -rlt
 1362  2025-05-23 07:07:56 crontab -l
 1363  2025-05-23 07:14:26 ls -rlt
 1364  2025-05-23 07:14:35 ps -ef | grep day
 1365  2025-05-23 07:14:42 date
 1366  2025-05-23 07:14:54 cd
 1367  2025-05-23 07:14:58 cd data_conversion/produce-gsc-6/
 1368  2025-05-23 07:14:59 òls -rlt
 1369  2025-05-23 07:15:01 ls -rlt
 1370  2025-05-23 07:15:12 cat work_day01.sh
 1371  2025-05-23 07:15:22 vi work_day06.sh
 1372  2025-05-23 07:15:34 cat work_day06.sh
 1373  2025-05-23 07:15:37 ls -rlt
 1374  2025-05-23 07:27:12 cat work_day06.sh
 1375  2025-05-23 07:27:45 df -h
 1376  2025-05-23 07:27:59 cd /vtdata/data_conversion/produce-gsc-6/
 1377  2025-05-23 07:28:00 ls -rlt
 1378  2025-05-23 07:28:23 cat large_tiles/unosm/tile_day06/
 1379  2025-05-23 07:28:26 ls -rlt
 1380  2025-05-23 07:28:34 cat large_tiles/unosm/tile_day06/
 1381  2025-05-23 07:28:40 cd  large_tiles/unosm/tile_day06/
 1382  2025-05-23 07:28:42 ls -rlt
 1383  2025-05-23 07:28:48 cd -
 1384  2025-05-23 07:29:06 cd produce-gsc-osm/mbtiles/osm_tile_day06/
 1385  2025-05-23 07:29:09 ls -rlt
 1386  2025-05-23 07:29:22 du -hs 4-8-10.mbtiles
 1387  2025-05-23 07:29:25 cd -
 1388  2025-05-23 07:29:35 cd large_tiles/unosm/tile_day06/
 1389  2025-05-23 07:29:42 du -hs *
 1390  2025-05-23 07:29:49 cd
 1391  2025-05-23 07:29:55 cd data_conversion/
 1392  2025-05-23 07:29:56 ls -rlt
 1393  2025-05-23 07:29:58 cd produce-gsc-6/
 1394  2025-05-23 07:29:59 ls -rlt
 1395  2025-05-23 07:30:03 cd produce-gsc-un
 1396  2025-05-23 07:30:04 ls -rlt
 1397  2025-05-23 07:30:08 cd mbtiles/
 1398  2025-05-23 07:30:09 ls -rlt
 1399  2025-05-23 07:30:12 cd un_tile/
 1400  2025-05-23 07:30:14 ls -rlt
 1401  2025-05-23 07:30:20 ls -rlt | more
 1402  2025-05-23 07:30:32 rm 6-*
 1403  2025-05-23 07:30:37 rm 5-*
 1404  2025-05-23 07:30:39 ls -rlt
 1405  2025-05-23 07:30:42 cd
 1406  2025-05-23 07:30:48 crontab -e
 1407  2025-05-23 07:31:22 crontab -l
 1408  2025-05-23 07:31:31 cd data_conversion/produce-gsc-6/
 1409  2025-05-23 07:31:32 ls -rlt
 1410  2025-05-23 07:31:35 cd config/
 1411  2025-05-23 07:31:36 ls -rlt
 1412  2025-05-23 07:32:06 mv default.hjson koji_default.hjson_
 1413  2025-05-23 07:32:18 cp _default.hjson_ default.hjson
 1414  2025-05-23 07:32:20 ls -rlt
 1415  2025-05-23 07:32:26 cat default.hjson
 1416  2025-05-23 07:32:29 cd
 1417  2025-05-23 07:32:38 ls -rlt
 1418  2025-05-23 07:32:49 cd data_conversion/produce-gsc-6/
 1419  2025-05-23 07:32:51 ls -rlt
 1420  2025-05-23 07:33:01 tmux
 1421  2025-05-23 08:27:31 tmux attach-session ach
 1422  2025-05-23 08:27:34 tmux attach-session
 1423  2025-05-23 08:27:46 df -h
 1424  2025-05-23 08:27:51 ls- lrt
 1425  2025-05-23 08:27:53 ls -rlt
 1426  2025-05-23 08:28:01 cd produce-gsc-un/mbtiles/un_tile/
 1427  2025-05-23 08:28:03 ls -rlt
 1428  2025-05-23 08:28:17 cd
 1429  2025-05-23 11:55:05 cd -
 1430  2025-05-23 11:55:07 ls -rlt
 1431  2025-05-23 11:55:17 tmux attach-session
 1432  2025-05-23 11:55:25 cd
 1433  2025-05-23 11:55:29 ls -rlt
 1434  2025-05-23 11:55:33 cd data_conversion/produce-gsc-6/
 1435  2025-05-23 11:55:34 ls -rlt
 1436  2025-05-23 11:55:39 date
 1437  2025-05-23 11:55:49 crontab -e
 1438  2025-05-23 11:56:37 date
 1439  2025-05-23 11:56:45 crontab -e
 1440  2025-05-23 11:56:59 date
 1441  2025-05-23 11:57:04 crontab -l
 1442  2025-05-27 13:31:40 cd /vtdata/data_conversion/cron-log/
 1443  2025-05-27 13:31:41 ls -rlt
 1444  2025-05-27 13:32:00 ps -ef | grep day
 1445  2025-05-27 13:32:12 cd
 1446  2025-05-27 13:32:18 cd data_conversion/produce-gsc-6/
 1447  2025-05-27 13:32:20 ls -rlt
 1448  2025-05-27 13:32:34 cd large_tiles/unosm/tile_day06
 1449  2025-05-27 13:32:36 sl -rlt
 1450  2025-05-27 13:32:38 ls -rlt
 1451  2025-05-27 13:43:58 crontab -l
 1452  2025-06-04 09:49:04 cd /vtdata/data_conversion/cron-log
 1453  2025-06-04 09:49:09 ls -rlt
 1454  2025-06-04 09:49:15 cat day1-log.log
 1455  2025-06-04 09:49:22 ls -lrt
 1456  2025-06-04 09:49:26 cat day2-log.log
 1457  2025-06-04 09:49:39 ps -ef | grep day
 1458  2025-06-04 09:49:53 crontab -l
 1459  2025-06-04 09:50:14 ls -rlt
 1460  2025-06-04 09:50:22 cat day4-log.log
 1461  2025-06-04 09:50:30 ls -rlt
 1462  2025-06-04 09:50:35 cat day5-log.log
 1463  2025-06-16 14:08:21 crontab -l
 1464  2025-06-16 14:08:29 cd data_conversion/produce-gsc-6/
 1465  2025-06-16 14:08:31 ls -rlt
 1466  2025-06-16 14:12:40 hostname
 1467  2025-07-01 15:17:01 crontab -l
 1468  2025-07-07 09:44:56 ls /lrt
 1469  2025-07-07 09:44:59 df /h
 1470  2025-07-07 09:45:12 cd /vtdata/data_conversion/produce-gsc-6
 1471  2025-07-07 09:45:14 ls -rlt
 1472  2025-07-07 09:45:27 cd /vtdata/data_conversion/cron-log
 1473  2025-07-07 09:45:29 ls -lrt
 1474  2025-07-07 09:45:37 tail -f day3-log.log
 1475  2025-07-07 09:45:55 more day2-log.log
 1476  2025-07-07 09:46:18
 1477  2025-07-07 09:46:21 cd -
 1478  2025-07-07 09:46:23 ls -rlt
 1479  2025-07-07 09:46:32 cd produce-gsc-osm
 1480  2025-07-07 09:46:33 ls -rlt
 1481  2025-07-07 09:46:36 cd mbtiles/
 1482  2025-07-07 09:46:38 ls -rlt
 1483  2025-07-07 09:46:47 cd osm_tile_day02
 1484  2025-07-07 09:46:49 ls -rlt
 1485  2025-07-07 09:47:09 cd ..
 1486  2025-07-07 09:47:10 ll
 1487  2025-07-07 09:47:15 cd osm_tile_every
 1488  2025-07-07 09:47:16 ls -lrt
 1489  2025-07-07 09:47:21 cd ..
 1490  2025-07-10 08:53:21 cd data_conversion/
 1491  2025-07-10 08:53:24 ls -rlt
 1492  2025-07-10 08:53:27 cd produce-gsc-6/
 1493  2025-07-10 08:53:29 ls -rlt
 1494  2025-07-10 08:53:39 more config/
 1495  2025-07-10 08:53:41 cd config/
 1496  2025-07-10 08:53:43 ls -rlt
 1497  2025-07-10 08:53:46 more default
 1498  2025-07-10 08:53:49 more default.hjson
 1499  2025-07-10 08:54:08 vi default.hjson
 1500  2025-07-10 09:20:33 psql -h unosm-r-app-02.global.un.org -U vectortile_reader -d osm_planet
 1501  2025-07-10 10:28:25 ls -lrt
 1502  2025-07-10 10:28:41 cd ..
 1503  2025-07-10 10:28:43 ls -lrt
 1504  2025-07-10 10:28:48 cd produce-gsc-osm
 1505  2025-07-10 10:28:49 ls -rlt
 1506  2025-07-10 10:28:54 cd mbtiles
 1507  2025-07-10 10:28:55 ls -rlt
 1508  2025-07-10 10:29:02 cd osm_tile_every
 1509  2025-07-10 10:29:04 ls -rlt
 1510  2025-07-10 10:30:01 cd ..
 1511  2025-07-10 10:30:03 ls -lrt
 1512  2025-07-10 10:30:06 cd ..
 1513  2025-07-10 10:30:07 ls -rlt
 1514  2025-07-10 10:30:10 cd ..
 1515  2025-07-10 10:30:12 ls -lrt
 1516  2025-07-10 10:30:20 cd config/
 1517  2025-07-10 10:30:22 ls -rlt
 1518  2025-07-10 10:30:27 more default
 1519  2025-07-10 10:30:30 more default.hjson
 1520  2025-07-10 10:31:03 vi default.hjson
 1521  2025-07-10 10:38:40 pwd
 1522  2025-07-10 10:38:50 ls -lr
 1523  2025-07-10 10:38:53 ls -lrt
 1524  2025-07-10 10:38:58 pwd
 1525  2025-07-10 10:41:23 vi default.hjson
 1526  2025-07-10 11:41:00 crontab -l
 1527  2025-07-10 11:41:09 cd ..
 1528  2025-07-10 11:41:14 cat ./work_every.sh
 1529  2025-07-10 13:31:46 cd ..
 1530  2025-07-10 13:31:50 cd -
 1531  2025-07-10 13:31:52 cd config/
 1532  2025-07-10 13:31:54 vi default.hjson
 1533  2025-07-10 13:36:04 cd ..
 1534  2025-07-10 13:36:09 crontab -l
 1535  2025-07-10 13:36:18 cd /vtdata/data_conversion/cron-log/
 1536  2025-07-10 13:36:33 vi everyday-log.log
 1537  2025-07-10 13:38:17 ps -ef | grep work
 1538  2025-07-10 13:38:38 crontab -l
 1539  2025-07-10 13:41:41 cd ..
 1540  2025-07-10 13:41:42 ls -rlt
 1541  2025-07-10 13:41:49 cd produce-gsc-6
 1542  2025-07-10 13:41:55 ls -rlt
 1543  2025-07-10 13:42:01 cd produce-gsc-osm
 1544  2025-07-10 13:42:02 ls -rlt
 1545  2025-07-10 13:42:05 cd mbtiles/
 1546  2025-07-10 13:42:06 ls -rlt
 1547  2025-07-10 13:42:12 cd osm_tile_every
 1548  2025-07-10 13:42:21 ls -rlt
 1549  2025-07-10 13:42:45 cd ..
 1550  2025-07-10 13:42:47 ls- lrt
 1551  2025-07-10 13:42:49 ls -rlt
 1552  2025-07-10 13:42:53 cd ..
 1553  2025-07-10 13:42:54 ls -rlt
 1554  2025-07-10 13:43:08 cd large_tiles
 1555  2025-07-10 13:43:10 ls -rlt
 1556  2025-07-10 13:43:12 cd unosm/
 1557  2025-07-10 13:43:15 ls -rlt
 1558  2025-07-10 13:43:20 cd tile_every
 1559  2025-07-10 13:43:22 ls -rlt
 1560  2025-07-10 13:45:04 cd ..
 1561  2025-07-10 13:45:11 ls -rlt
 1562  2025-07-10 13:45:14 cd config/
 1563  2025-07-10 13:45:17 vi default.hjson
 1564  2025-07-11 12:25:58 cd /vtdata/data_conversion/produce-gsc-6/log/
 1565  2025-07-11 12:25:59 ls -rlt
 1566  2025-07-11 12:26:46 vi produce-everyday-2025-07-10.log
 1567  2025-07-11 12:27:47 grep buildings_a produce-everyday-2025-07-10.log
 1568  2025-07-11 12:28:31 grep buildings_a produce-everyday-*log
 1569  2025-07-11 12:28:36 grep buildings_a produce-everyday-2025-07-10.log
 1570  2025-07-11 12:28:40 grep buildings_a produce-everyday-*log
 1571  2025-07-11 12:28:59  | grep 6-35-31
 1572  2025-07-11 12:29:10 grep buildings_a produce-everyday-*log | grep '6-35-31'
 1573  2025-07-11 12:29:34 ps -ef | grep work
 1574  2025-07-11 12:29:44 grep buildings_a produce-everyday-*log | grep '6-35-31'
 1575  2025-07-11 12:30:02 grep buildings_a produce-everyday-2025-07-10.log | grep 6-35-31
 1576  2025-07-11 12:30:15 grep buildings_a produce-everyday-2025-07-10.log
 1577  2025-07-11 12:30:28 grep buildings_a produce-everyday-*log | grep '6-35-31'
 1578  2025-07-11 12:30:35 grep buildings_a produce-everyday-2025-07-10.log | grep 6-35-31
 1579  2025-07-11 12:34:05 pwd
 1580  2025-07-11 12:38:05 ls -l 6-35-31.mbtiles
 1581  2025-07-11 12:38:11 ls -l *6-35-31.mbtiles
 1582  2025-07-11 12:38:17 ls -l *6-35-31*
 1583  2025-07-11 12:38:20 ls -lrt
 1584  2025-07-11 12:38:22 cd ..
 1585  2025-07-11 12:38:23 ll
 1586  2025-07-11 12:38:34 cd produce-gsc-osm/mbtiles/osm_tile_every/
 1587  2025-07-11 12:38:38 ls -l *produce-gsc-osm*
 1588  2025-07-11 12:38:46 ls -l *6-35-31*
 1589  2025-07-11 12:39:50 ps -ef | grep work
 1590  2025-07-11 12:40:13 pwd
 1591  2025-07-14 09:55:03 ls -rlt
 1592  2025-07-14 09:55:13 cd data_conversion/
 1593  2025-07-14 09:55:15 ls -rlt
 1594  2025-07-14 09:55:22 cat cron-log/everyday-log.log
 1595  2025-07-14 09:55:33 ps -ef | grep ever
 1596  2025-07-14 09:55:46 date
 1597  2025-07-14 09:55:54 crontab -e
 1598  2025-07-14 09:56:54 ls -lrt
 1599  2025-07-14 09:57:19 cd cron-log
 1600  2025-07-14 09:57:21 ls -rlt
 1601  2025-07-14 09:57:27 cat everyday-log.log
 1602  2025-07-14 09:57:45 ps -ef | grep wor
 1603  2025-07-15 08:13:57 ps -ef | grep work
 1604  2025-07-15 08:14:12 cat /vtdata/data_conversion/cron-log/everyday-log.log
 1605  2025-07-18 06:21:00 vi /vtdata/data_conversion/cron-log/everyday-log.log
 1606  2025-07-18 06:22:26 more /vtdata/data_conversion/cron-log/everyday-log.log
 1607  2025-07-18 06:25:19
 1608  2025-07-18 06:25:23 cd
 1609  2025-07-18 06:25:28 cd data_conversion/
 1610  2025-07-18 06:25:30 ls -rlt
 1611  2025-07-18 06:25:33 cd produce-gsc-6/
 1612  2025-07-18 06:25:34 ls -rlt
 1613  2025-07-18 06:25:47 cat work_every.sh
 1614  2025-07-18 06:27:31 cd produce-gsc-osm/mbtiles/osm_tile_every/
 1615  2025-07-18 06:27:48 ls -l 6-35-31.mbtiles
 1616  2025-07-18 06:31:54 ls -rlt
 1617  2025-07-18 06:31:58 cd
 1618  2025-07-18 06:32:06 ls -lrt
 1619  2025-07-18 06:32:13 cd data_conversion/produce-gsc-6/
 1620  2025-07-18 06:32:15 ls -rlt
 1621  2025-07-18 06:32:21 vi work_every.sh
 1622  2025-07-18 06:33:38 cat work_every.sh
 1623  2025-07-18 06:33:45 scp -r ./large_tiles/unosm/tile_every/* vectortile@vttlk-r-web-01.global.un.org:/vtdata/hosting/coesite4/mbtiles/UniteStreetMapVector
 1624  2025-07-18 06:37:52 cat work_every.sh
 1625  2025-07-18 06:38:22 clear
 1626  2025-07-18 06:38:24 ls -rlt
 1627  2025-07-18 06:38:32 cat work_*
 1628  2025-07-18 06:43:28 crontab -e
 1629  2025-07-18 12:18:44 cd
 1630  2025-07-18 12:18:46 ls -rlt
 1631  2025-07-18 12:18:53 cd data_conversion/
 1632  2025-07-18 12:18:55 ls -rlt
 1633  2025-07-18 12:18:57 cd produce-gsc-6/
 1634  2025-07-18 12:18:58 ls- lrt
 1635  2025-07-18 12:19:00 ls -rlt
 1636  2025-07-18 12:19:13 cd ..
 1637  2025-07-18 12:19:14 ll
 1638  2025-07-18 12:19:17 cd ..
 1639  2025-07-18 12:19:18 ll
 1640  2025-07-18 13:06:54 crontab -l
 1641  2025-07-18 13:07:07 cd /vtdata/data_conversion/produce-gsc-6
 1642  2025-07-18 13:07:12 cat work_every.sh
 1643  2025-07-18 13:08:21 ls -lrt
 1644  2025-07-18 13:08:26 cat work_every.sh
 1645  2025-07-18 13:11:03 cat work_*
 1646  2025-07-18 13:12:00 cat work_every.sh
 1647  2025-08-08 06:43:16 clear
 1648  2025-08-08 06:43:18 ls -rlt
 1649  2025-08-08 06:43:23 crontab -l
 1650  2025-08-08 06:43:44 cd more /vtdata/data_conversion/cron-log/everyday-log.log
 1651  2025-08-08 06:43:47 more /vtdata/data_conversion/cron-log/everyday-log.log
 1652  2025-08-08 06:44:05 ps -ef | grep work
 1653  2025-08-08 06:44:27 more /vtdata/data_conversion/cron-log/day4-log.log
 1654  2025-08-12 12:08:36
 1655  2025-08-12 12:08:41 ls /rlt
 1656  2025-08-12 12:08:47 ls -lrt
 1657  2025-08-12 12:08:52 cd data_conversion/
 1658  2025-08-12 12:08:54 ls -rlt
 1659  2025-08-12 12:08:57 cd produce-gsc-6/
 1660  2025-08-12 12:08:58 ls -rlt
 1661  2025-08-12 12:09:02 cd config/
 1662  2025-08-12 12:09:04 ls -rlt
 1663  2025-08-12 12:09:10 cat default
 1664  2025-08-12 12:09:14 cat default.hjson
 1665  2025-08-12 12:09:21 cat default.hjson | more
 1666  2025-08-12 12:10:19 sed -n '/^un-l: {/,$p' default.hjson | more
 1667  2025-08-12 12:10:47 sed -n '/^un-l: {/,$p' default.hjson | grep "osm_planet::vectortile::"
 1668  2025-08-12 12:10:52 sed -n '/^un-l: {/,$p' default.hjson | grep "osm_planet::vectortile::" | wc -l
 1669  2025-08-12 12:11:15 grep default.hjson "osm_planet::vectortile::" | wc -l
 1670  2025-08-12 12:11:33 grep "osm_planet::vectortile::" default.hjson | wc -l
 1671  2025-08-12 12:11:36 grep "osm_planet::vectortile::" default.hjson
 1672  2025-08-12 12:11:52 grep "::vectortile::" default.hjson
 1673  2025-08-12 12:12:21 grep "osm_planet::vectortile::" default.hjson
 1674  2025-08-12 12:13:18 grep "osm_planet::vectortile::" default.hjson  | awk -F '::' '{print $3}'
 1675  2025-08-12 13:34:39 ls -rlt
 1676  2025-08-12 13:34:46 vi default.hjson
 1677  2025-08-12 13:52:12 grep "osm_base::vectortile::" default.hjson  | awk -F '::' '{print $3}'
 1678  2025-08-12 13:52:31 grep "un_base::vectortile::" default.hjson  | awk -F '::' '{print $3}'
 1679  2025-08-12 13:52:48 more default.hjson
 1680  2025-08-12 13:53:43 sed -n '/un-l: {/,$p' default | grep "un_base::vectortile::" | awk -F '::' '{print $3}'
 1681  2025-08-12 13:53:51 sed -n '/un-l: {/,$p' default.hjson | grep "un_base::vectortile::" | awk -F '::' '{print $3}'
 1682  2025-08-12 13:54:05 custom_planet_land_main_a
 1683  2025-08-12 13:54:05 custom_planet_land_antarctica_a
 1684  2025-08-12 13:54:05 custom_planet_land_08_a
 1685  2025-08-12 13:54:05 unmap_bndl_l
 1686  2025-08-12 13:54:05 custom_unmap_bndl_l
 1687  2025-08-12 13:54:05 un_unmik_bndl_l
 1688  2025-08-12 13:54:05 un_unvmc_igac_bndl_l
 1689  2025-08-12 13:54:05 un_mimu_bndl
 1690  2025-08-12 13:54:05 custom_ne_rivers_lakecentrelines_l
 1691  2025-08-12 13:54:05 un_glc30_global_lc_ms_a
 1692  2025-08-12 13:54:05 un_mission_lc_ls_a
 1693  2025-08-12 13:54:05 un_global_places_p
 1694  2025-08-12 13:54:05 unmap_phyp_label_06_p
 1695  2025-08-12 13:54:05 unmap_bnda_a1_ap
 1696  2025-08-12 13:54:05 unmap_bnda_a2_ap
 1697  2025-08-12 13:54:05 custom_unmap_bnda_a1_ap
 1698  2025-08-12 13:54:05 custom_unmap_bnda_a2_ap
 1699  2025-08-12 13:54:05 un_unmik_bnda_a2_ap
 1700  2025-08-12 13:54:05 un_unmik_bnda_a3_ap
 1701  2025-08-12 13:54:05 un_unvmc_igac_bnda_a1_departments_ap
 1702  2025-08-12 13:54:05 un_unvmc_igac_bnda_a2_municipalities_ap
 1703  2025-08-12 13:54:05 un_unvmc_igac_bnda_a3_rural_units_ap
 1704  2025-08-12 13:54:05 unmap_bnda05_cty_a
 1705  2025-08-12 13:54:05 unmap_bnda_cty_anno_06_p
 1706  2025-08-12 13:54:05 un_global_pois_p
 1707  2025-08-12 13:54:05 un_minusca_pois_p
 1708  2025-08-12 13:54:05 unmap_phyp_p
 1709  2025-08-12 13:54:05 unmap_popp_p
 1710  2025-08-12 13:54:05 custom_planet_coastline_l
 1711  2025-08-12 13:54:05 custom_planet_land_08_a
 1712  2025-08-12 13:54:05 custom_planet_ocean_08_a
 1713  2025-08-12 13:54:05 un_glc30_global_lc_ss_a
 1714  2025-08-12 13:54:05 unmap_bndl_l
 1715  2025-08-12 13:54:05 unmap_bndl05_l
 1716  2025-08-12 13:54:05 unmap_bndl25_l
 1717  2025-08-12 13:54:05 unmap_bnda_cty_anno_03_p
 1718  2025-08-12 13:54:05 unmap_bnda_cty_anno_04_p
 1719  2025-08-12 13:54:05 unmap_bnda_cty_anno_05_p
 1720  2025-08-12 13:54:05 unmap_bnda_cty_anno_06_p
 1721  2025-08-12 13:54:05 unmap_phyp_label_04_p
 1722  2025-08-12 13:54:05 unmap_phyp_label_06_p
 1723  2025-08-12 13:54:05 unmap_popp_p
 1724  2025-08-12 13:54:05 unmap_wbya10_a
 1725  2025-08-12 13:54:05 unmap_dral10_l
 1726  2025-08-12 13:54:05 custom_ne_10m_bathymetry_a
 1727  2025-08-12 13:54:05 unmap_wbya_label_05_p
 1728  2025-08-25 12:54:15 ls -rlt
 1729  2025-08-25 12:54:21 cd tippecanoe/
 1730  2025-08-25 12:54:22 ls -rlt
 1731  2025-08-25 12:54:27 cd ..
 1732  2025-08-25 12:54:28 ll
 1733  2025-08-25 12:54:30 cd data_conversion/
 1734  2025-08-25 12:54:35 cd produce-gsc-6/
 1735  2025-08-25 12:54:37 ls -lrt
 1736  2025-08-25 12:54:41 cd config/
 1737  2025-08-25 12:54:43 ls -rlt
 1738  2025-08-25 12:54:49 more default.hjson
 1739  2025-08-27 10:42:18 top
 1740  2025-08-27 10:42:27 cd
 1741  2025-11-28 09:45:25 history | grep git
 1742  2026-02-18 14:07:44 history
Attachments
No attachments.
Related pages
Created: 2026-02-17 11:40 · Updated: 2026-02-19 08:01