Location Hierarchy and generating IDs
Peter WONTUO
Location Hierarchy and ID generation
After the OpenHDS expo, I have been looking particularly at the location hierarchy interface and to reason out its implementation on the ground. One good thing about the OpenHDS is the ability to generate its own internal ids randomly. This has resolved the problem of security with individual identification as it was with HRS. With this feature data can easily be given out without the external know IDs of individuals etc. However, these external known IDs are very critical tools when it comes to field work i.e. locating houses, migrants, selection of areas for an intervention etc. This is where I took the interest to look at the “Location Hierarchy” implementation and how IDs are generated. Maybe these examples will best explain my point so that “Location Hierarchy” tool will figure out the implementation.
Navrongo – the DSS site is being clustered and coded and within each cluster, houses were numbered. From there, the eternal IDs were generated
|
Cluster Coded |
Compound Number |
LOCATIONID |
HOUSEHOLDS ID |
INDIVIDUALID |
|
EAA |
01 |
EAA01 |
EAA0101 EAA0102 |
EAA01001 ……n |
Dodowa – the DSS site is grouped into area councils and coded and each is then classified into their communities (coded) and within each community, the houses are numbered. From there, the eternal IDs were generated
|
Area Council Coded |
Community Codes |
Compound Number |
LOCATIONID |
HOUSEHOLDS ID |
INDIVIDUALS ID |
|
PR |
AU |
001 |
PRAU001 |
PRAU00101 PRAU00102 |
PRAU0010101 ……n PRAU0010201 .…..n |
Kintampo – the study area is grouped into villages (coded) and within each village, houses were numbered. From there, the eternal IDs were generated but due to FWA operations, after number the houses in each village, they were clustered alphabetically.
|
Villages Coded |
Compound Number |
Cluster |
Compound Number |
LOCATIONID |
HOUSEHOLDS ID |
INDIVIDUALS ID |
|
AA |
0001 |
A |
0001 |
AA0001 |
AA000101 AA000102 |
AA000101001 ……n AA000102001 .…..n |
Nahuche – the study area is grouped into districts (coded). Each district then clustered alphabetically and within each cluster, the houses were numbered. From there, the eternal IDs were generated.
|
District Coded |
District Clustering Coded |
Compound Number |
LOCATIONID |
HOUSEHOLDS ID |
INDIVIDUALS ID |
|
NK |
A |
001 |
NKA001 |
NKA00101 NKA00102 |
NKA001001001 ……n NKA001002001 .…..n |
This, however, is not a problem with sites that have passed the baseline and are now running updates. The problem then comes when new external IDs are to be generated for BIRTHS, External Inmigration and Temporary IDs because it will have to conform to the inherited ID generation procedures illustrated above. For new site, it may be just following the location hierarchy approach with some modifications, maybe.
======================================================
Peter Wontuo (PW)
Health Research Officer (IT)
Navrongo Health Research Centre (NHRC) - GHS
P. O. Box 114 > > Navrongo KNDE/UER - Ghana W/A
Tel: +233-3821-22380(Director)/22310(Admin)/22716(Server Room)
Fax: +233-3821-22320 - Cell: +233 24 4010034 / 20 7389978
Alt email: pwo...@hotmail.com; Peter....@gmail.com
Website: www.navrongo.org NOTE the change in my email address to pwo...@navrongo.mimcom.ORG
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
·Adding manpower to a late software project makes it later. Luke 6:41-42
David Roberge
Dave
--
You received this message because you are subscribed to the Google Groups "openhds-users" group.
To post to this group, send email to openhd...@googlegroups.com.
To unsubscribe from this group, send email to openhds-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openhds-users?hl=en.
Peter WONTUO
Hi Dave,
Nice getting back to you. The point I am making here is for you to understand how some site have build up their Location Hierarchy and based on that IDs were generated. There was no any other better way than giving some scenarios. The Location Hierarchy implemented by OpenHDS is okay but that may affect older site that have developed a system of generating IDs for Locations, Socialgroups, Individuals etc. Please, what do you think about that?
Regards
Peter
Bruce MacLeod
Greetings ! Thank you for the detailed insight into the various techniques for forming IDs. It is very helpful.
When you say "it may affect older sites" ... do you mean that there will need to be a data migration process that builds the location hierarchy for sites that want to transition to the OpenHDS ? If so, I completely agree.
Great to hear from you,
Bruce
Dave
Website: www.navrongo.org NOTE the change in my email address to MailScanner has detected a possible fraud attempt from "mc" claiming to be MailScanner has detected a possible fraud attempt from "mc" claiming to be pwo...@navrongo.mimcom.ORG
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
·Adding manpower to a late software project makes it later. Luke 6:41-42
--
You received this message because you are subscribed to the Google Groups "openhds-users" group.
To post to this group, send email to openhd...@googlegroups.com.
To unsubscribe from this group, send email to openhds-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openhds-users?hl=en.
--
You received this message because you are subscribed to the Google Groups "openhds-users" group.
To post to this group, send email to openhd...@googlegroups.com.
To unsubscribe from this group, send email to openhds-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openhds-users?hl=en.
Peter WONTUO
Hi Bruce,
Very happy to hear from you. I think that is what I could not explain better. You’ve gotten my point.
“be a data migration process that builds the location hierarchy for sites that want to transition to the OpenHDS”
Regards
Peter