Name Of The project
Period: April 2024 – June 2025
Client: Bangladesh Power Development Board
Subject: GIS Database Establishment and Analysis
The consultant needs to develop a fully functional GIS database and a Data Base Management System (DBMS) for data processing, inquiry and analysis by various departments of BPDB. The GIS platform will be the International Standard. The DBMS should consist of a set of software programs that controls the organization, storage, management, and retrieval of data in various databases established. DBMS should support the application programs and enable the transfer of appropriate data to various users. Initially the consultant will carry out a Business Area Analysis so as to design the GIS system requirements to the needs of all intended users and determine the appropriate functionalities to be incorporated within the GIS. Overall the database structure may include the access database, survey database, electrical network and analysis database and billing database plus any others as per the requirements of users. The specific structure of data storage and GIS system architecture should be determined after discussions with the various users to meet their various needs. A set of interactive macros for query and access between the databases will need to be developed. The data received from the Precise GPS Equipment and equipment records need to be verified and error checked for accuracy and consistency. For example, the network data can be checked with reference to the single line diagrams and geo-referencing with geographic maps. Basic analysis capabilities of the GIS shall include the following:
- Geospatial query and statically analysis: this will include items such as geographical queries like area and length calculations, details and quantification of various assets and their physical locations, equipment status, computation of area served by substations, feeders etc.;
- Electrical query and analysis: some of the features will be processed with internally developed software while items such as load flow analysis will be conducted using commercially available software packages that will be linked to the GIS data base. Internally generated query facility would include generation of single line diagrams (SLD), connected kVA on feeders etc.;
- Consumer related analysis: requirements would include features such as consumers connected to each feeder and line section, energy consumed by feeder etc.;
Our Task Was
The scope of the services of the consultant will include but not be limited to the following: This study will be conducted in two phases. Planning, design, development, implementation and operation of a comprehensive GIS -based network management system for 5 (five) S&D’s for improvement of customer services will be done under Phase-I. The prospective five S&D’s are:
- Sales & Distribution, Comilla
- Sales & Distribution, Brahmanbaria;
- Sales & Distribution, Lakshmipur;
- Sales & Distribution Ashuganj
- Sales & Distribution, Feni.
The pilot study will also be combined with a training program for S&D’s staff that will finally carry out the work in each of the S& D. The consultant’s duties will consist of development of applications to utilize the GPS based data for all forms of utility practice. For this purpose, the consultant will need to develop a well-planned database system and a number of application software and programs. In some instances, the consultant will assist BPDB in securing commercially or open source available software and link their application to the GIS based database. After successful completion of Phase-I the consultant will implement Phase-II following the activities and standard model developed during phaseI for rest of the S&D’s under BPDB areas.
Primary GIS data collection
The consultant will collect preliminary data for the BPDB system and will carry out an exercise in the collection of preliminary data at selected S&Ds to serve as a model exercise. During this exercise the consultant will train sufficient number of related S&Ds personnel to carry out data collection, operation and maintenance of GIS program. The activities to be carried out will include:
- Collection of pole by pole data for HT and LT lines and recording the locations by a Precise GPS receiver;
- On-site processing of GPS data and conversion to GIS data format;
- Verifying accuracy (to less than 1 meter) of field data of geographical locations;
- Keeping records appropriately and correction of defective data (at every following day);
- Daily uploading/Digitizing the field data collected to the database;
- Conductor information, equipment information and device information collection during the pole by pole survey using GIS inventory sheets by the consultant;
- Collection of data related to grid substations, switching stations, sub-stations;
- Collection of data related to important land marks using appropriate forms;
- Collection of information of transformer and other equipment/devices from ‘Equipment Record Cards (ERCs)’ and related documentation and integration of the data with electric distribution system’s GIS Database. A computerized database management program providing a suitable data assembly software will be needed for this purpose;
- Pole and Equipment information will be collected through Precise GPS Equipment or Temporary Stations (TS) and a short questionnaire survey. A digital data input format can also be used by applying some macros with the Precise GPS Equipment and Tablet Mobile based questionnaire survey and data input. In this case the Existing Equipment record card’s digital format can be used if any;
- Pole oriented consumer and transformer and other equipment data needs to be updated and uploaded to the database
Geo-referencing
The primary data needs to be supplemented by numerous secondary data that deals with the geographic features of the land, characteristics of the population served or to be served, important institutions located in the service area etc. The consultant will be responsible for the collection of the relevant secondary data not only related to the pilot S&Ds where detailed work is being conducted but also for the whole areas of BPDB. Information to be obtained includes:
- Processed geo-referenced satellite images or Arial photography information. Accuracy level of these images could be ±0.5 meter after post processing;
- Base maps with cadastral boundaries such as local administrative districts (village, union, upazilla, district, division etc.), linear features such as roads (primary, secondary, tertiary and quaternary), rivers, lakes, canals etc.;
- Preparation of the Base Map of S&Ds with demarcation of S&D’s boundary/Area/Location should be geo-referenced in Bangladesh reference system;
- Demographic and social data such as population, house hold / settlement type etc. occupation, stakeholder type can be collected from the Statistical Year Book of Bangladesh Bureau of Statistics (BBS). Such demographic and social data would be used for assessing future growth and trends such as projection of population and consumers, and service area demarcation;
Electrical network analysis through desktop and web based GIS software
- Capability to prepare auto Single Line Diagrams from the finished GIS/Geo-database.
- Ability to present the load of every feeder as allocated load, forecasted load, and generated load.
- Ability to identify the over loaded feeders and equipment depending on line ratings, transformer capacity etc. If any items attain a danger level a signal should be generated automatically.
- Spatial monitoring at the time of disaster and support to decision making.
Phasellus vitae purus vel tellus suscipit dignissim. Phasellus eu ipsum elementum, finibus nulla ut, interdum elit.
Nam convallis, tortor id egestas hendrerit, lorem leo fringilla dui, ut congue tellus urna eu elit.