Hi all,

My data contains households’ GPS info (latitude, longitude, and altitude) and don’t have data such as administration level 3,
and I saw from other STATA forums such as (https://www.stata.com/support/faqs/g...pmap-and-maps/ and https://www.stata.com/stata15/spatia...essive-models/ )
they all say that should download shp. and dbf. format files of the place that I conducted research, and then merge them with my original data file.

-so I downloaded Malawi (where my data come from) shapefile from the internet, and then I used the command spshape2dta to turn them into dta. format files.
Now I got 19 variables as below, but no variable that I can use to 1:1 merge with my original data.
_ID
_CX
_CY
Shape_Leng Shape_Area
ADM3_EN
DM3_PCODE
ADM3_REF
ADM3ALT1EN
ADM3ALT2EN
ADM2_EN
ADM2_PCODE
ADM1_EN
ADM1_PCODE
ADM0_EN
ADM0_PCODE
ate valid
On validTo

And then, I tried to find the administration level 3 based on my GPS info in google map & also in the google excel sheet with Plus Code plugin so that I can merge them with variable DM3_PCODE, but the problem is this method is not feasible.
Any information would be appreciated.

Thanks.