[LAHI] Add "Other" location values for all locations

[utkarshavni]

Use case:
Students do not necessarily share all address level details like District, block and other lower level locations through Whatsapp (Glific chatbot). This means that once the integration is done and data from Glific is pulled into Avni for Registration, it will not have all location details. In order to complete the Registration for these students, we should have the option "Other" for all the location fields.

Goal:
State, District, Block, School name, UDISE code to have Other option.

Acceptance criteria:

• Have locations with complete hierarchy with title "Other" - From State to UDISE
• Have "Other" District, block, School and UDISE locations created under existing States.

When Student registrations are done by pulling data from Gliffic. The location values should be selected as "Other".

[vedfordev]

steps for dev

1. create one "State" as "Other" via web-app.

2. create one csv file with title with order as following: "State" , "District", "Block", "School", "UDISE"

3. Note down count from the following query :

select count(distinct title)
from address_level where type_id = (select id
                                    from address_level_type
                                    where name = 'State' and
                                            is_voided = false);

4. Copy State from query and paste into csv sheet :

select distinct title
from address_level where type_id = (select id
                                    from address_level_type
                                    where name = 'State' and
                                            is_voided = false);

5. Fill csv sheet "District", "Block", "School", "UDISE" as other for all "State" and upload:
6. verification query and it should match with count of step 3 :

select count(*)
--       state.title,district.title,block.title,school.title,udise.title
from address_level state
join address_level district on state.id = district.parent_id
join address_level block on district.id = block.parent_id
join address_level school on block.id = school.parent_id
join address_level udise on school.id = udise.parent_id
where state.type_id = (select id
                    from address_level_type
                    where name = 'State' and
                            is_voided = false)
and district.title = 'Other'
and block.title = 'Other'
and school.title = 'Other'
and udise.title = 'Other';