DB of cleaning/repair/construction companies

gauthams09 commented 6 years ago

DB of cleaning/repair/construction companies

A lot of companies in various districts have come up with free cleaning, repair as well as construction works for flood affected houses. A database of such companies would be helpful for the public.

What we need to have?

A curated database of companies that provide service for free (or maybe reduced price).

Basic workflow (Just a suggestion)

Have the data from public - Name of company, District of operation, locality (or across district), area of working, contact number(s), brief description of works they do, charge(if any)
Have Volunteers contact respective companies with details from collected data, confirm and mark as verified
Once verified by Volunteers, show up on our UI for the public with filters for easy search

How is this gonna help the public?

This will help to all those who are trying to provide the service as well as others who would like to clean/repair their homes using these services after flood.

If someone is gonna take this up, get the workflow ready first, have a proper plan on what needs to be done n then start work. Please check if Ushahidi can do this.

biswaz commented 6 years ago

https://keralarescue.in/ngo-volunteer/

We added this as NGO/Company /home needs update

vchacko commented 6 years ago

It (https://keralarescue.in/ngo-volunteer/) doesnt have district https://github.com/IEEEKeralaSection/rescuekerala/issues/812

laxman954 commented 6 years ago

@biswaz I have the below DB design concept

#company (Holds company basic details) company_name company_id company_status (verified/not) place comments

#company_service_details (holds company service details and company_id is foreign key) company_id service_id service_type service_desc price_range_from price_range_to

#company_contact_details (List of company contact details) company_id id number type

#service_region_details (List of area services covered) id service_id (needed if we give service specific to particular region alone) company_id service_area service_district

First anyone can add the company service details and one of volunteer call them and verify all the service details and cost, if its verified we can show it our website.