T RACK 5 - UMIS A PPLICATION S OFTWARE D EVELOPMENT

6 IMPLEMENTATION PLAN

6.5 T RACK 5 - UMIS A PPLICATION S OFTWARE D EVELOPMENT

This Track will involve the staged development of the UMIS Application Software Platform.

The UMIS is to be created through an “Agile” software development process that involves a series of incremental software development “sprints”, each building and refining upon the previous. In this regard, the UMIS POC can be seen as a first “pre-sprint” in the overall system development process. Track 4 is to build on the results of the PoC development, assessment and refined specifications prepared previously.

Each sprint is collaboratively defined, developed and tested with the full involvement of the UMIS task force and selected user representatives. This helps to ensure that the resulting system is very much tied to practical user requirements and priorities, the user interface is easy to understand and use, and the outputs are directly and compellingly critical for supporting important decision-making issues. It also helps to establish a base group of users who are fully familiar with the software and therefore well positioned to train others in its use, thus the Agile system development process also serves as an on-the-job, train-the-trainer program that will greatly help to accelerate system adoption and utilization during roll-out.

The development approach outlined in the sections following suggests that each UMIS sub-system be developed semi-independently within the framework of the existing conceptual design. This will provide maximum flexibility to adjust the form and function of each major sub-system according to module-specific user feedback, while maintaining any critical linkages and interdependencies among the components. It will be critical that this track be carefully coordinated with the Data Track to ensure that there is sufficient relevant data available to support the development and testing of each application.

Afghanistan UMIS Page 77 6.5.1 Activity 1 – Develop Data Clearinghouse and Data Management Environment The Data Clearinghouse is to include the basic database management and administration functionality needed to both maintain a physical archive of data to be compiled or created and maintained by UMIS staff as well as the ability to link to and consume data from online published data services from NSIA and others. The Clearinghouse is to be configured with the following basic components:

▪ Relational Data Base Management System (RDBMS);

▪ Geographic Information System (GIS);

▪ Statistical Analysis System (SAS);

▪ Multimedia Content Management System (CMS).

The following basis tasks will be carried out to establish and test the UMIS Data Clearinghouse environment in preparation for system and database development activities.

Task 1 – Acquire, install and configure each component. Each of the components listed above will be acquired, installed and configured to support UMIS development efforts.

Task 2 – Test and approve each component. Each of the installed and configured components will be tested to ensure that these sub-systems are up and running properly.

6.5.2 Activity 2 – Develop UMIS Portal Software

The UMIS Portal will provide an online, cloud-based master dashboard that can be used by authorized users to navigate to all of the UMIS applications, outputs and data sources. This includes provision of a common browser accessible interface that supports the interactive development of causal factor models, uploading of GIS data for alternative scenarios and conducting geostatistical analyses to help understand the implications of these scenarios.

The following basic tasks will be involved in carrying out this Activity:

Task 1 – Sprint 1 Kabul Foundation System. This first sprint will build upon the results of the PoC development and subsequent assessment, feedback and refinements. The results of the first sprint will be reviewed with the assigned users, thus providing feedback for consideration in the next sprint.

Task 2 – Sprint 2 Kabul Foundation System. Second sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

Task 3 – Sprint 3 Kabul Foundation System. Third sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

Task 4 – Sprint 4 PCC Rollout and Refinement. The fourth sprint will be carried out with the full participation of assigned users from each of the involved PCC’s. It will be important

Afghanistan UMIS Page 78 that this be timed to ensure there is a critical mass of location-specific data available for each PCC.

Task 5 – Sprint 5 PCC Rollout and Refinement. The fifth sprint will be carried out with the full participation of assigned users from each of the involved PCC’s. It is expected that this will be the final sprint required for the Phase 1 development of this module.

6.5.3 Activity 3 – Develop CIP&D Common Registry Management Application The CIP&D Common Registry Management Application is to include an online, cloud-based service that can be used by authorized organizations and their appointed staff to register capital investment plans and projects. These will include both on-budget government projects, off-budget projects developed by international organizations or NGO’s as well as any significant development projects planned by private sector entities. The system is to provide a common browser-accessible interface that supports the entry of the geographic boundary of the project as well as key metadata about each project from the very early stages, and the updating of the status of each plan/project until its completion and commissioning. The entry and updating of this information is to be required of every entity, across every sector and geography in the country as a prerequisite for project funding and/or government approvals. This module is also to include an automated change detection mechanism for identifying areas of significant land use change on a quarterly basis. Areas that exhibit changed conditions can then be compared against officially registered projects to identify any significant land use or infrastructure changes on the ground that may be falling outside of government oversight.

The following basic tasks will be involved in carrying out this Activity:

Task 2 – Sprint 2 Kabul Foundation System. Second sprint for the development of the foundation system focused on Kabul.

Task 3 – Sprint 3 Kabul Foundation System. Third sprint for the development of the foundation system focused on Kabul.

Task 4 – Sprint 4 PCC Rollout and Refinement. The fourth sprint will be carried out with the full participation of assigned users from each of the involved PCC’s. It will be important that this be timed to ensure there is a critical mass of location-specific data available for each PCC.

Afghanistan UMIS Page 79 Task 5 – Sprint 5 PCC Rollout and Refinement. The fifth sprint will be carried out with the full participation of assigned users from each of the involved PCC’s. It is expected that this will be the final sprint required for the Phase 1 development of this module.

6.5.4 Activity 4 – Develop Planning & Zoning Common Registry Management Application

The Planning and Zoning Common Registry Management Application is to include an online, cloud-based service that can be used by authorized organizations and their appointed staff to register all land use and infrastructure master plans. This includes provision of a common browser accessible interface that supports the entry of the geographic boundary of the plan as well as key metadata about each plan. It will also include a utility to support uploading plans that have been created according to an approved data standard that will allow the interpretation of land use characteristics and development implications. The entry and updating of this information is to be required of every entity, across every sector and geography in the country as a prerequisite for government approvals of any land use or infrastructure master plans. The following basic tasks will be involved in carrying out this Activity:

Task 2 – Sprint 2 Kabul Foundation System. Second sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

Task 3 – Sprint 3 Kabul Foundation System. Third sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

6.5.5 Activity 5 – Develop Urban Analysis Toolbox

The Urban Analysis Toolbox is to include an online, cloud-based service that can be used by authorized planners to conduct causal factor mapping and planning scenario development and analysis tools linked to GIS. This includes provision of a common browser accessible interface that supports the interactive development of causal factor models, uploading of GIS

Afghanistan UMIS Page 80 data for alternative scenarios and conducting geostatistical analyses to help understand the implications of these scenarios.

The following basic tasks will be involved in carrying out this Activity:

Task 2 – Sprint 2 Kabul Foundation System. Second sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

Task 3 – Sprint 3 Kabul Foundation System. Third sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

6.5.6 Activity 6 – Develop Urban Big Data Channel Management Application

The Urban Big Data Channel Management application is to include an online, cloud-based service that can be used by authorized planners to access, analyze and visualize selected urban big data sources. This includes provision of a common browser accessible interface that supports the user in selecting various big data sources that may be available (anonymous cell phone movement, waze .

The following basic tasks will be involved in carrying out this Activity:

Task 2 – Sprint 2 Kabul Foundation System. Second sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

Afghanistan UMIS Page 81 Task 3 – Sprint 3 Kabul Foundation System. Third sprint for the development of the foundation system focused on Kabul, based on feedback in the previous step.

In document Program Design. URBAN MANAGEMENT INFORMATION SYSTEM (UMIS) GeoSmart System for Sustainable Urban Development and Investment. Draft V1 18 March, 2019 (Page 76-81)