DGHS Project

Looking for help?
< All Topics
Print

LR Data Modelling (Deprecated)

Overview

SHR and MCI may store the location registry data locally in Cassandra database.

Queries:

Only read. Location information may be retrieved by passing a string created by concatenating the following ids (in the order mentioned) – division id, district id, upazilla id, citycorp id, ward id.

Row Key:

division id + district id + upazilla id + citycorp id + ward id

Column Family:

location

Columns:

division, district, upazilla, citycorp, ward

Example:

For ward #20, Banani, Dhaka (division id: 30, district id: 26, upazilla id: 07, citycorp id: 25, union id: 20), the data in Cassandra may look like:

location: {

3026072520: {

division: “Dhaka”,

district: “Dhaka”,

upazilla: “Banani”,

citycorp: “ward 20”,

ward: “ward 20”

}

}

References:

Table of Contents