GEO in JISF (Part -1)
About
JISF is a project undertaken by a2i to centralize, optimize, and manage government e-Services (Digital Services) in a better way. This project aims to centralize the e- Services of Judiciary department and units by providing them a set of standards and guidelines. Thus this project is establishing a digital framework for all e-Governance in Bangladesh. This project centralizes commonly used data and it’s use. This project also facilitates optimization of data and functional use by establishing an enterprise service bus (ESB) for government.
In this project a big set of information are used which are stored and managed in different data domains. Therefore, to get integrated with JISF project, it is required to understand the data and the definition of each standard data. From this point of understanding this “Data Definition Standard” documentation has been prepared.
This document will mention and explain all the data that are managed through the JISF Ecosystem.
How to use
Each data has different set of information which together defines a data properly. The information is explained against each standard data mentioned in this document:
|
General Information |
|
|
Title |
Description |
|
Reference No |
A reference number assigned by the committee |
|
Entity Name |
The name of the data domain or category. |
|
Attribute Name |
The name of the data item, aggregation or domain |
|
Data Source |
The original source of specified data, therefore, from where this data is originated. |
|
Description |
The description for the item. |
|
Core Definition |
|
|
Title |
Description |
|
Data Type |
The data might be numeric, alphabetic etc. The type of respective data is mentioned in this attribute |
|
Data Limit |
It is generally the length or maximum possible size of the data. |
|
Default Value |
Sometimes there remains some default value which is set by the system if the application or user do not provide any data for that specific field. This is known as Default Value. |
|
Attribute Type |
|
|
Nullable |
Null means “Defined Empty Field”. If a data has the provision to be empty, then then the data will be called as “Nullable” |
|
Unique |
Sometimes a data can be unique and cannot be stored duplicate, those Unique data types are mentioned by this section. |
|
Data Notes |
|
|
Title |
Description |
|
Multiplicity Notes |
Additional information on whether systems or collections should allow for multiple values per person for this item. In addition, for each Aggregation, the following is provided: |
|
Usage Note |
The usage type of a data is described in this section. |
|
Security Note |
How a data is kept secured, or whether keeping a data secure is necessary or not is described in this section. |
|
History Note |
There might have some additional historical information regarding to any data, which will be explained in this section. |
|
Collection Notes |
Additional information that will be useful to designers of data collections. |
Geological Data
Geological data sets are a very important and mandatory part of JISF. As any digital service of government is involved with the geological information of citizens, keeping a detailed list of geological data in JISF ecosystem is mandatory.
The geological data include country, division, district, Upazila, union, city corporation, municipality, thana, ward, post office, cantonment etc. type of data. All these data are explained below:
Geo Data, Country
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_countries |
|
Attribute Name |
id |
|
Data Sources |
|
|
Description |
A unique numeric identity for each Country, generated by system. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
11 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
Yes |
|
Function |
Auto Increment, Numeric |
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
System will generate this value uniquely, and no duplicate will be generated. |
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_countries |
|
Attribute Name |
name |
|
Data Sources |
|
|
Description |
Name of countries that will be used in the system. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
Yes |
|
Unique |
Yes |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_countries |
|
Attribute Name |
country_code |
|
Data Sources |
|
|
Description |
A unique code for each Country, inserted manually by user. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
Yes |
|
Unique |
Yes |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
Geo Data, Division
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_divisions |
|
Attribute Name |
id |
|
Data Sources |
|
|
Description |
A unique numeric identity for each division, generated by system. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
Yes |
|
Function |
Auto Increment, Numeric |
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
System will generate this value uniquely, and no duplicate will be generated. |
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_divisions |
|
Attribute Name |
division_name_eng |
|
Data Sources |
|
|
Description |
Name of division in English Text |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_divisions |
|
Attribute Name |
division_name_bng |
|
Data Sources |
|
|
Description |
Name of division in Unicode Bengali Text |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_divisions |
|
Attribute Name |
bbs_code |
|
Data Sources |
|
|
Description |
A unique code of geological location provided by Bangladesh Bureau of Statistics. |
|
Core Definitions |
|
|
Data Type |
char |
|
Data Limit |
4 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
Yes |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
BBS Code will be unique for each division. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
Geo Data, District
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_districts |
|
Attribute Name |
id |
|
Data Sources |
|
|
Description |
A unique numeric identity for each district, generated by system. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
Yes |
|
Function |
Auto Increment, Numeric |
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
System will generate this value uniquely, and no duplicate will be generated. |
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_districts |
|
Attribute Name |
geo_division_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of division which is associated with district. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_districts |
|
Attribute Name |
district_name_eng |
|
Data Sources |
|
|
Description |
Name of district in English Text |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_districts |
|
Attribute Name |
district_name_bng |
|
Data Sources |
|
|
Description |
Name of district in Unicode Bengali Text |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_districts |
|
Attribute Name |
bbs_code |
|
Data Sources |
|
|
Description |
A unique code of geological location provided by Bangladesh Bureau of Statistics. |
|
Core Definitions |
|
|
Data Type |
char |
|
Data Limit |
4 |
|
Default Value |
|
|
Nullable |
Yes |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
BBS Code will be unique for each district. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
Geo Data, City Corporation
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporations |
|
Attribute Name |
id |
|
Data Sources |
|
|
Description |
A unique numeric identity for each City Corporation, generated by system. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
Yes |
|
Function |
Auto Increment, Numeric |
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
System will generate this value uniquely, and no duplicate will be generated. |
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_citycorporations |
|
Attribute Name |
geo_division_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of division which is associated with city corporation. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_citycorporations |
|
Attribute Name |
geo_district_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of district which is associated with city corporation. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporations |
|
Attribute Name |
city_corporation_name_eng |
|
Data Sources |
|
|
Description |
Name of City Corporation in English Text. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporations |
|
Attribute Name |
city_corporations_name_bng |
|
Data Sources |
|
|
Description |
Name of City Corporation in Unicode Bengali Text. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporations |
|
Attribute Name |
bbs_code |
|
Data Sources |
|
|
Description |
A unique code of geological location provided by Bangladesh Bureau of Statistics. |
|
Core Definitions |
|
|
Data Type |
char |
|
Data Limit |
4 |
|
Default Value |
|
|
Nullable |
Yes |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
BBS Code will be unique for each district. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
Geo Data, City Corporation Wards
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporation_wards |
|
Attribute Name |
id |
|
Data Sources |
|
|
Description |
A unique numeric identity for each City Corporation Ward, generated by system. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
|
|
Nullable |
No |
|
Unique |
Yes |
|
Function |
Auto Increment, Numeric |
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
System will generate this value uniquely, and no duplicate will be generated. |
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_citycorporation_wards |
|
Attribute Name |
geo_division_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of division which is associated with city corporation ward. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_citycorporation_wards |
|
Attribute Name |
geo_district_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of district which is associated with city corporation ward. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_citycorporation_wards |
|
Attribute Name |
geo_city_corporation_id |
|
Data Sources |
|
|
Description |
The system generated unique ID of city corporation which is associated with city corporation ward. |
|
Core Definitions |
|
|
Data Type |
integer |
|
Data Limit |
8 |
|
Default Value |
|
|
Attribute Type |
Foreign Key |
|
Nullable |
No |
|
Unique |
|
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
|
|
Data Notes |
|
|
Multiplicity Notes |
|
|
Usage Note |
This data will be hidden from application viewers. |
|
Security Note |
This ID is a unique identifier for a data-set which is confidential and used only internally in the application. |
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporation_wards |
|
Attribute Name |
ward_name_eng |
|
Data Sources |
|
|
Description |
Name of Ward in English Text. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporation_wards |
|
Attribute Name |
ward_name_bng |
|
Data Sources |
|
|
Description |
Name of Ward in Unicode Bengali Text. |
|
Core Definitions |
|
|
Data Type |
varchar |
|
Data Limit |
255 |
|
Default Value |
|
|
Nullable |
No |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
This data will not be unique. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
|
General Information |
|
|
Reference No |
|
|
Entity Name |
geo_city_corporation_wards |
|
Attribute Name |
bbs_code |
|
Data Sources |
|
|
Description |
A unique code of geological location provided by Bangladesh Bureau of Statistics. |
|
Core Definitions |
|
|
Data Type |
char |
|
Data Limit |
4 |
|
Default Value |
|
|
Nullable |
Yes |
|
Unique |
No |
|
Function |
|
|
Item Level Validation |
|
|
Algorithms |
N/A |
|
Data Notes |
|
|
Multiplicity Notes |
BBS Code will be unique for each district. |
|
Usage Note |
This data will be viewable inside the application openly. |
|
Security Note |
|
|
History Notes |
|
|
Collection Notes |
|
No Comments