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;

Notes on Generating the Names of FIs

One missing feature of the PDMS for now is the capability to generate the names of the Field Interviewers who conducted the survey on a certain year.

To do this, you have to link the survey table with the household table, then the household table with the location table.

Sample Code
SELECT DISTINCT s.enumeratorlastname LastName, s.enumeratorfirstname FirstName, 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
ORDER BY LastName;

Site Updates

Posted some contents of the Realising DReAMS Blogspot yesterday.

One about the fund transfer and the other is about the Provincial Implementing Team.

Meeting with Tony

Tony and I met the other day to discuss about the mapping feature of the PDMS.

He will be teaching me on how to use shapefiles to map the household data sometime next week.

We also had some discussion on the DB structure as I was trying to generate the names of FIs that time.

Blogspot Updates

Updated the Blogspot yesterday. Added contents and updates about meetings and orientations.

For the admin panel of the pdms, still coding some parts of it.

New Features to the DReAMS Blogspot

I have added today new features to the DReAMS Blogspot:

1. Live Traffic Feed - enables us to monitor the site's visitor, their country of origin and the time since their visit

2. Stat Counter / Blog Counter - summarizes the visitors by country

I will just be adding more features to the site once I find something interesting - for the site to be more user friendly, informative and an awesome user experience. (hehe)

June 4 Project Orientation and Consultation

Yesterday, June 4, the provincial implementing team had a meeting with the Municipal Planning and Development Coordinators of the 5 pilot municipalities of the Realising DReAMS Project here in Bohol.

June 2 Technical Briefing

Last June 2, 2010, the Provincial Implementing Team met for the Technical Briefing and discussion on how to start the integration of PDMS and ecoBudget.

It was agreed upon during the said meeting that ecoBudget indicators will be integrated using the PDMS Mapping Tool (only some indicators, others will be at the household level if applicable).

A prototype / demo of the DReAMS Software is due to be presented by the end of June.