30 August 2011
Good Morning!
I am John Morales from GMA News, a leading news broadcast network based in Manila, Philippines.
Currently, I am working on a story about the conditional cash transfer program of my country. As the flagship anti-poverty program of the Philippines, the CCT program is a welfare program which provides cash incentives to targeted beneficiaries once they meet the conditionalities on health and education set by the government.
Thus, we asked our concerned government agencies for the breakdown of the social services and public infrastructure in place in towns as well as the list of CCT areas where the program is installed.
We would like to assess if the CCT areas have enough schools, public roads and schools, so that the targeted beneficiaries can meet the conditions set by the government (i.e. children between 0 and 14 age attend schools at least 85 percent every month and mothers have to attend health centers twice a month). We would like to look into the state of public roads in these towns, because the targeted beneficiaries, particularly in far-flung areas, have to receive their month cash allocations in government banks located in urban centers. We also receive reports that poor families who meet government’s requirements for the cash allocation are not enrolled in the program, because government employees fail to come over far-flung areas where there is insufficient, or lack, of public roads leading to these areas.
They provided us the data that we needed such as the list of barangays (our country’s smallest political unit) without elementary schools and health centers and the list of barangays where the CCT program is installed. However, we have difficulties in constructing a database, because the list of barangays without elementary schools and health centers and thee list of barangays where the CCT program is installed does provide a unique geographic numeric code.
We already received from our government’s statistical agency the list of barangays with their corresponding official geographic code.
Our main problem is how we could be to include the geographic code in our data which do not have a geographic code. The data are formatted in excel.
We have already tried your suggestions we found in database/excel fora in the Internet. We tried the match and transfer functions. However, the suggestions did not work.
We hope you could be able to help us. We are attaching the documents.
The excel file named “2011_OFFICIAL_GEOGRAPHIC_CODE” contains the list of barangays with their corresponding unique numeric code. The file does not have the unique geographic code.
The excel file named “4Ps_DATABASE” contains the list of barangays where the CCT program is installed. The file does not have the unique geographic code.
The excel file named “BWOBHS” (or the Barangay Without Barangay Health Centers) contains the list of barangays without health centers. The file does not have the unique geographic code.
The excel file named “BWOES_DATABASE” (or the Barangay Without Elementary Schools) contains the list of barangays without elementary schools. The file does not have the unique geographic code.
Our purpose is to construct a database in MS Access. We understand that MS Access requires a unique primary key in construction relationships between data.
We hope you could accommodate our request as we are airing our report in our primetime news program, 24 Oras (24 Hours), later this week.
I have attached my data file in zip form.
Here’s my e-email number: alliage.morales[at]gmail.com
Respectfully yours,
John Morales
Researcher
GMA News
Good Morning!
I am John Morales from GMA News, a leading news broadcast network based in Manila, Philippines.
Currently, I am working on a story about the conditional cash transfer program of my country. As the flagship anti-poverty program of the Philippines, the CCT program is a welfare program which provides cash incentives to targeted beneficiaries once they meet the conditionalities on health and education set by the government.
Thus, we asked our concerned government agencies for the breakdown of the social services and public infrastructure in place in towns as well as the list of CCT areas where the program is installed.
We would like to assess if the CCT areas have enough schools, public roads and schools, so that the targeted beneficiaries can meet the conditions set by the government (i.e. children between 0 and 14 age attend schools at least 85 percent every month and mothers have to attend health centers twice a month). We would like to look into the state of public roads in these towns, because the targeted beneficiaries, particularly in far-flung areas, have to receive their month cash allocations in government banks located in urban centers. We also receive reports that poor families who meet government’s requirements for the cash allocation are not enrolled in the program, because government employees fail to come over far-flung areas where there is insufficient, or lack, of public roads leading to these areas.
They provided us the data that we needed such as the list of barangays (our country’s smallest political unit) without elementary schools and health centers and the list of barangays where the CCT program is installed. However, we have difficulties in constructing a database, because the list of barangays without elementary schools and health centers and thee list of barangays where the CCT program is installed does provide a unique geographic numeric code.
We already received from our government’s statistical agency the list of barangays with their corresponding official geographic code.
Our main problem is how we could be to include the geographic code in our data which do not have a geographic code. The data are formatted in excel.
We have already tried your suggestions we found in database/excel fora in the Internet. We tried the match and transfer functions. However, the suggestions did not work.
We hope you could be able to help us. We are attaching the documents.
The excel file named “2011_OFFICIAL_GEOGRAPHIC_CODE” contains the list of barangays with their corresponding unique numeric code. The file does not have the unique geographic code.
The excel file named “4Ps_DATABASE” contains the list of barangays where the CCT program is installed. The file does not have the unique geographic code.
The excel file named “BWOBHS” (or the Barangay Without Barangay Health Centers) contains the list of barangays without health centers. The file does not have the unique geographic code.
The excel file named “BWOES_DATABASE” (or the Barangay Without Elementary Schools) contains the list of barangays without elementary schools. The file does not have the unique geographic code.
Our purpose is to construct a database in MS Access. We understand that MS Access requires a unique primary key in construction relationships between data.
We hope you could accommodate our request as we are airing our report in our primetime news program, 24 Oras (24 Hours), later this week.
I have attached my data file in zip form.
Here’s my e-email number: alliage.morales[at]gmail.com
Respectfully yours,
John Morales
Researcher
GMA News
