Sub-location data

[matmaxgeds]

Main use case is for M&E - to know who/where to contact - and to know the cities/local governments, this is not about reporting

@mohamedgele22 to provide a list of the locations that MoPIED is thinking about.

• Not same structure as the sectors

• No financial data, therefore not show in the chart

• New column in the location report table which lists the sub-locations like is done now with the implementers

• Maintain a list of sub-location data - to help users

• List needs to relate to the Location parent level

• Also have a free text field to give flexibility

• Not mandatory

• Need to figure out how to allow lower levels of data to be filtered, maybe something graphical.....this is a UI issue to solve later.

• Hint information e.g. completing the typing for people etc

• Can think about autocomplete, and maybe a bit heuristic etc e.g. to make Hiiran the same as Hiran

[raashidahmad]

@matmaxgeds @mohamedgele22 I am working on document for Phase 2 tasks and putting estimated efforts for tasks. We need to work out on the approach to solve this problem. As I am calculating efforts and will submit the document.

Below are the given list of tasks, and a possible approach that we will take to solve the Issue.

1. As we have list of sub locations. The better way would be write the script to import the locations. If we are expecting the locations will grow, we need to devise a strategy how this addition will take place?

2. We need a way to relate the imported locations with the parent level locations we currently have in the database. Do we need a Management section for it?

3. We will provide a multi-select sublocations dropdown while entering the percentages for locations on data entry page. Do we need to enter the percentage for sublocations as well? If so, can we please work on a mockup and suggest, It will help to estimate the efforts. The sublocations will be stored as strings in the database (More technically as JSON objects)

4. Do we need to filter the projects by sublocations?

5. Do we need filters for sublocations on all the reports? This is important to know as it will help to calculate the extent of changes in backend APIs and UI as well.

Please feel free to suggest anything on it and add/remove anything I missed. All of the above are only suggestions and a possible approach for a solution.

[matmaxgeds]

Closing here as is a duplicate of #606 - answering these comments there

[matmaxgeds]

1. Any sub-location import will be a one-off, additions or deletions will be done by management users just like they are done now for sub-sectors
2. Yes, we will need to a management page for the sublocations to manage the list, and also link them to the parent locations - also when deleting a location, it will need to re-allocate the sub-locations before it can be deleted just like with sub-sectors
3. There will not be any amounts allocated to the sublocations, we just need a way for the users to search lists of sub-locations and select the appropriate ones (there will often be multiple). I am wondering about a search-as-you.type multi-select? 3b. When the parent locations are selected, the AIMS should only show/allow sub-locations to be added that are child locations of those parent locations
4. Not specifically, but the sub-locations should be found by the text search elsewhere on the site
5. No, 4. see above

[matmaxgeds]

Question - when we have sub-national locations, what will we do with the ones that do not have this info? City and district are not the same level, within a city there are districts People want to see what is happening in a specific town/city/district Maybe we can tag things underneath the FMS? Can we make this searchable/reportable........who supplies the dropdown? Select the FMS, then get just the 'locations' within that? Not get financial breakdowns with tags/cities.......this means no reports by cities - That seems ok Need to then have a management page to edit the list

[matmaxgeds]

Matt: to figure out how to do the entry, noting that unlimited detailed-locations can be added, so then need child table - for the detailed locations

[matmaxgeds]

Data entry...

• add to the 'Sector+Location' screen, field name is 'Detailed Location'
• Have a series of multi-selects the same as the ones used e.g. when adding a organisation to the filters on the projects list.....text search, and multi-add.
• Filter (when it is available) the detailed locations by the 'Location' e.g. if a user has entered Puntland, then only the Detailed Locations based in Puntland will be available in the dropdown
• Need Gele to share the different lists of detailed-locations, we will probably have different types e.g.
• The Detail Location table therefore has multiple columns e.g. "Detailed Location", "Detailed Location Type", "Location", where type is to be discussed by probably e.g. Town/City, District, Other......this will help the users to pick the right dropdown to find what they are looking for.
• Need a management page for the detailed locations
• As discussed, no financial information, and allow multiple
• Detailed location needs adding to all the various filter screens for the projects list, and the reports.