SupportTrack
Today
Items
Projects
Time
Logs
Timesheet
CTO Time
Reports
Overview
Meeting Notes
Activity Summary
PMDS Activity Summary
Time by Category
Time by Item
Normalized Tracking
Taxonomy
Automation
PMDS
Templates
Knowledge Base
Wiki
Organigram
Servers
URLs
Firewall Rules
--:--
MAD
NY
--:--
· IN
--:--
⏱️
No tasks running
⏹️
Wiki
Back
Edit page
Tshoot commands
Title
Slug
Status
Draft
Verified
Needs Review
Context
No context
AOM
CommsNet
DS
ESB
FSS
GIS
HR
ICC Training
IPPC
MediaNet
Mission Pin Code
OpsData
Organization
OSM
Sage
UA Maps
UA Notifications
UN Base
UN Dashboard
Unite Aware
UN Vector Tiles
Categories
Application Info
Documentation
General
Known Issue
Procedures
Tshoot
Topics
Azure
CommsNet
Compass
Databases
DD Boost FS
Disk Space
Files
Gateways
HeidiSQL
iNeed
Keepass
Linux
MariaDB
MongoDB
MySQL
Network
Organization
PostgresSQL
PowerBI
Remote Desktop Manager
Replication
Service Desk
Setup
UA Notifications
UN Base
UNICC
Updates
WHO
Windows
Markdown
# 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 ```
Cancel
Save
Stop Timer
Activity comments