Meeting

We had a meeting yesterday. Sir Nes, Sir Tony, Ate Daidee and me were present during the said meeting.

Discussed during the said meeting were the digitizing, workplan, deliverables and others.

Basic PDMS Orientation for the Cambodian Partners

3 Cambodians from Stung Treng arrived in Bohol to join the Local Kick-off Activity which was last July 29 and 30.

Yesterday, July 31, the Bohol Provincial Implementing Team headed by Dr. Pestelos gave them a Special Orientation on PDMS. It is designed to gave them information about How PDMS works, the Survey Process, Questionnaire and others.

Today, we are continuing the Workshop, here in Baclayon - Pestelos' Residence.

Backup Data Checking

Im currently checking the backup data of Pilar, Bohol.

What I'm trying to verify is if there is any barangay that has been encoded in two or more PCs which could raise an issue once all the data will be put in one single DB.

Meeting with the Field-Testing Team

We had a meeting with the Team that conducted the field-testing of the questionnaire in Maribojoc last Friday.

We discussed about the questionnaire, ways to improve it, errors to be corrected and clarified as well as the general experience of the field testing. We also talked about the survey, encoding of the data and ways on how to improve the integrity of the data.

Realising DReAMS Questionnaire Field Testing

We field tested the Realising DReAMS Questionnaire in San Vicente, Maribojoc last July 13, 2010.

We did a spot check in the morning and had a meeting with the Barangay Captain. We started the interviews around 3:00 p.m., and completed before 5:00 p.m.

Trip to Pilar

Been to Pilar with Joyce and Jessica Julia Baier last July 9 to get a backup copy of the PDMS data they have been encoding.

Sample Code for Generating FIs

Here is the sample code to generate the name of FIs and the number of the households they have interviewed.

SELECT DISTINCT s.enumeratorlastname LastName, s.enumeratorfirstname FirstName, COUNT(*) as Surveyed,pl.locationname Municipality
FROM survey s, household h, location l, location ll, location pl, surveydate sd
WHERE s.householdid = h.householdid AND h.locationid = l.locationid
AND ll.locationid = l.parentid AND pl.locationid = ll.parentid AND s.surveydateid = s.surveydateid
AND pl.locationname = "Sagbayan" AND sd.surveyyear = 2004
GROUP BY LastName, FirstName
ORDER BY LastName, FirstName;