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.
Related Posts with how to merge the spatial data when there is no common variables in two dataset?
Plot the prediction the native-migrant LFP at the 25th and 75th percentile of an explanatory varibleHello, I trying to generate a plot that has the YSM on the x-axis and the native-migrants LFP differ…
Regression transformation with ln and squared values Hello, I assume a nonlinear relationship between TobinsQ and sumholdingpct. Is it then appropriat…
Avoid duplicate removal: Loop to create new id of a duplicate within panel?Dear Statalist Community, I have a problem with repeated time values in my panel (daily time interv…
Automating the process of copying and pasting in STATAHi, I am trying to copy and paste the first 20 observation onto a new column but the values start a…
code for classifying participants based on complex criteria on a 9-item scaleI'm looking for code to classify participants with depression using more complicated diagnostic crit…
Subscribe to:
Post Comments (Atom)
0 Response to how to merge the spatial data when there is no common variables in two dataset?
Post a Comment