----------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spat
> ial_data\compiling_spatial_data_2025july19.smcl
  log type:  smcl
 opened on:  19 Jul 2025, 06:37:36

. do "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_dat
> a\compiling_spatial_data.do"

. 
. 
. 
. /* compiling spatial data for accessibility measures */
. 
. 
. /* Instruments */
. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\elev_m.dbf", clear
(9 vars, 2,268 obs)

. rename RASTER elev_m

. keep dwllid elev_m

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp1.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp1.dta saved

. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\temp_jan.dbf", clear
(9 vars, 2,268 obs)

. rename RASTER temp_jan

. keep dwllid temp_jan

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp2.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp2.dta saved

. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\prec_jan.dbf", clear
(9 vars, 2,268 obs)

. rename RASTER prec_jan

. keep dwllid prec_jan

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp3.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp3.dta saved

. 
. 
. /* connectivity measures */
. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\KM_CBD.dbf", clear
(13 vars, 2,268 obs)

. rename Distance KM_CBD

. replace KM_CBD=KM_CBD/1000
(2,268 real changes made)

. keep dwllid KM_CBD C_CODE_BNG

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp4.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp4.dta saved

. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\MtoTaxibe.dbf", clear
(24 vars, 2,268 obs)

. rename Distance MtoTaxibe

. keep dwllid MtoTaxibe

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp5.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp5.dta saved

. 
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\MtoSubUBus.dbf", clear
(24 vars, 2,268 obs)

. rename Distance MtoSubUBus

. keep dwllid MtoSubUBus

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp6.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp6.dta saved

. 
. 
. /* MIN_CBD */
. import delimited using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\
> OpenData\spatial_data\MIN_CBD.txt", clear
(encoding automatically selected: ISO-8859-1)
(8 vars, 2,246 obs)

. generate dwllid=substr(name, 1, strpos(name," - ")-1 )

. destring dwllid, replace
dwllid: all characters numeric; replaced as long

. rename total_hr MIN_CBD

. replace MIN_CBD=MIN_CBD*60
(2,246 real changes made)

. keep dwllid MIN_CBD

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp7.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp7.dta saved

. 
. 
. /* w_MIN_BUZ */
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\Job_Areas_2.dbf", clear
(13 vars, 1,092 obs)

. rename AREA_KM2 JobArea

. sum JobArea

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
     JobArea |      1,092    .0110654    .0230731   .0000776   .3705586

. generate total_JobArea=r(sum)

. keep JobAreaID JobArea total_JobArea

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\JobArea.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\JobArea.dta saved

. 
. import delimited using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\
> OpenData\spatial_data\HR_HH_JobArea.txt", clear
(encoding automatically selected: ISO-8859-1)
(6 vars, 2,441,405 obs)

. generate dwllid=substr(name, 1, strpos(name," - ")-1 )

. generate JobAreaID=substr(name, strpos(name," - ")+3,.)

. destring dwllid JobAreaID total_hr, replace
dwllid: all characters numeric; replaced as long
JobAreaID: all characters numeric; replaced as int
total_hr_s1 already numeric; no replace

. joinby JobAreaID using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\
> OpenData\spatial_data\JobArea.dta", unmatched(master)

. generate w_MIN_BUZ=total_hr*JobArea/total_JobArea

. collapse (sum) w_MIN_BUZ, by(dwllid)

. replace w_MIN_BUZ=w_MIN_BUZ*60
(2,249 real changes made)

. keep dwllid w_MIN_BUZ

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp8.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp8.dta saved

. 
. 
. /* w_MIN_ALL */
. import dbase using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Open
> Data\spatial_data\bulidings_cell_200m.dbf", clear
(7 vars, 18,324 obs)

. rename Sum__m2 BuiltArea

. sum BuiltArea

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
   BuiltArea |     18,324     1956.17    3301.988          0   28403.07

. generate total_BuiltArea=r(sum)

. keep CELL_ID BuiltArea total_BuiltArea

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\BuiltArea.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\BuiltArea.dta saved

. 
. import delimited using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\
> OpenData\spatial_data\HR_HH_Cell200.txt", clear
(encoding automatically selected: ISO-8859-1)
(6 vars, 39,785,677 obs)

. generate dwllid=substr(name, 1, strpos(name," - ")-1 )

. generate CELL_ID=substr(name, strpos(name," - ")+3,.)

. destring dwllid CELL_ID total_hr, replace
dwllid: all characters numeric; replaced as long
CELL_ID: all characters numeric; replaced as int
total_hr_s1 already numeric; no replace

. joinby CELL_ID using "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\BuiltArea.dta", unmatched(master)

. generate w_MIN_ALL=total_hr*BuiltArea/total_BuiltArea

. collapse (sum) w_MIN_ALL, by(dwllid)

. replace w_MIN_ALL=w_MIN_ALL*60
(2,257 real changes made)

. keep dwllid w_MIN_ALL

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp9.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\temp9.dta saved

. 
. 
. 
. /* compiling all data */
. 
. use  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\temp1.dta", clear

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp2.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp3.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp4.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp5.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp6.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp7.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp8.dta", unmatched(master)

. drop _m

. joinby dwllid using  "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\Op
> enData\spatial_data\temp9.dta", unmatched(master)

. drop _m

. save "C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_d
> ata\spatial_data.dta", replace
file C:\Users\wb282057\OneDrive -
    WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spatial_data\spatial_data.dta saved

. 
. 
. [END]
[ is not a valid command name
r(199);

end of do-file

r(199);

. log close
      name:  <unnamed>
       log:  C:\Users\wb282057\OneDrive - WBG\Documents\AFR_INF_DR\Labor_Stat\MDG\accessibility_measures\OpenData\spat
> ial_data\compiling_spatial_data_2025july19.smcl
  log type:  smcl
 closed on:  19 Jul 2025, 06:42:44
----------------------------------------------------------------------------------------------------------------------
