-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 27, 2024 at 01:05 PM
-- Server version: 8.0.34
-- PHP Version: 8.1.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `businessgos_click`
--

-- --------------------------------------------------------

--
-- Table structure for table `rlcos`
--

CREATE TABLE `rlcos` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `category_id_name` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `department_id` bigint UNSIGNED NOT NULL,
  `department_id_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `latitude` double(10,7) NOT NULL,
  `longitude` double(10,7) NOT NULL,
  `main_info_video_path` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `main_info_photo_path` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `requirment_info_photo_path` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `document_info_photo_path` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `registration_num` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `process_time` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `process_time_unit` enum('Months','Days','') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'Days',
  `contact_num` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `fees` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `renewal_period` varchar(191) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `renewal_period_unit` enum('Months','Days','') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'Days',
  `address` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `doc_requirements` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `rlcos`
--

INSERT INTO `rlcos` (`id`, `name`, `category_id`, `category_id_name`, `department_id`, `department_id_name`, `latitude`, `longitude`, `main_info_video_path`, `main_info_photo_path`, `requirment_info_photo_path`, `document_info_photo_path`, `registration_num`, `process_time`, `process_time_unit`, `contact_num`, `fees`, `renewal_period`, `renewal_period_unit`, `address`, `doc_requirements`) VALUES
(1, 'Registration of Privately Managed Colleges', 2, 'Registration', 1, 'College Education Department', 24.8607343, 67.0011364, '4Gx1oZ_30jE', '', 'static/media/collegeDepartment.d267fa3383ef1cb5108d.PNG', 'document_main.png', 'CED-001', '10-12 Days', '', '(021) 99222230', 'Urban - Rural Rs.15000 Degree Awarding Urban - Rural Rs.20000', 'Renewal Period (Months)', '', '3rd Floor, Building No. 6, Sindh Secretariat, Karachi City, Sindh', '<ul>\r\n<li>Form-A (with all proforma\'s. etc. security, census, authority) and covering letter;</li>\r\n<li>Paid fee challan as per the following fee schedule;</li>\r\n<li>Inspection report;</li>\r\n<li>Admission policy;</li>\r\n<li>Admission committee;</li>\r\n<li>Curricular and Co-Curricular activities; </li>\r\n<li>List of teaching staff with the appointment order, degree, salary, designation, and qualification;</li>\r\n<li>List of Non-teaching staff with the appointment order, degree, salary, designation, and qualification</li>\r\n<li>Detail of Management Committee (MC) with name & designation;</li>\r\n<li>Record of 10 % free ship student list, with name, father Name, contact no. & address of students as Affidavit on stamp paper of PKR 50 or 100 (with  03 copies);</li>\r\n<li>Board of Governors</li>\r\n<li>Income and Expenditure;</li>\r\n</ul>'),
(2, 'Registration of Shops & Establishment', 2, 'Registration', 2, 'Labour and Human Resources Department', 24.8445189, 67.0244326, '9smMPO4JsI4', '', 'static/media/labourAndHumanResource.945f6acd071cf1bf047e.PNG', 'document_main.png', 'LD-001', 'Same Day', '', '0324-2554748', 'As per Schedule', 'Renewal Period (Months)', '', 'Block No 86, Sindh Secretariat IV-B, Court Road, Karachi.', '<ul>\r\n<li>Name of the establishment, if any;</li>\r\n<li>Postal address of the establishment; </li>\r\n<li>Full name of the employer (including father\'s name); </li>\r\n<li>Full name of the manager, if any (including father\'s name); </li>\r\n<li>Category of the establishment, i.e., whether a shop, industrial establishment, commercial establishment, residential hotel, restaurant, eating house,theatre or other place of public amusement or entertainment;</li>\r\n<li>Total number of employees (state separately the number of men, women and/or young persons, if any); and </li>\r\n<li>Date on which the establishment commenced its work.  </li>\r\n</ul>'),
(3, 'Registration of Factories', 2, 'Registration', 2, 'Labour and Human Resources Department', 24.8445189, 67.0244326, 'Ajk9N-uKE6s', '', 'static/media/labourAndHumanResource.945f6acd071cf1bf047e.PNG', 'document_main.png', 'LD-002', '10 days', '', '0324-2554748', 'As per Schedule', 'Renewal Period (Months)', '', 'Block No 86, Sindh Secretariat IV-B, Court Road, Karachi.', '<ul>\r\n<li>Name of the establishment, if any;</li>\r\n<li>Postal address of the establishment; </li>\r\n<li>Full name of the employer (including father\'s name); </li>\r\n<li>Full name of the manager, if any (including father\'s name); </li>\r\n<li>Category of the establishment, i.e., whether a shop, industrial establishment, commercial establishment, residential hotel, restaurant, eating house,theatre or other place of public amusement or entertainment;</li>\r\n<li>Total number of employees (state separately the number of men, women and/or young persons, if any); and </li>\r\n<li>Date on which the establishment commenced its work.  </li>\r\n</ul>'),
(4, 'Registration and Licensing of Food Business Operator', 2, 'Registration', 3, 'Sindh Food Authority (SFA)', 24.8683205, 67.0447531, '', '', 'static/media/SindhFood.6fa76dd731452b7654bb.PNG', 'document_main.png', 'SFA-001', '7 days', '', '(021) 99330164', 'As per Schedule', 'Renewal Period (Months)', '', 'Plot B, 12, Sindhi Muslim Cooperative Housing Society Block A Sindhi Muslim CHS (SMCHS), Karachi, Karachi City, Sindh', '<ul>\r\n<li>Copy of CNIC;</li>\r\n<li>Documents of the property/tenancy agreement or affidavit showing ownership;</li>\r\n<li>Previous registration certificate (if any) with any authority;</li>\r\n<li>Copy of Challan form;</li>\r\n<li>Lab testing reports (where required as per SOPs); and</li>\r\n<li>Medical reports of the staff/food handlers (where required as per SOPs). </li>\r\n</ul>'),
(5, 'License to sell Drugs by Way of Retail Sale (Form-6)', 1, 'License', 4, 'Health Department', 24.9388330, 67.0891410, 'VpDQbLBuzgo', '', 'static/media/HealthDepartment.d8d6c2ef08b308b9b02e.PNG', 'document_main.png', 'HD-001', '3 Month', '', '(021) 99222012', 'Rs.6000', 'Renewal Period (Months)', '', '6th Floor, Sindh Secretariat No 1 Kamal Atta Turk Road, Karachi', '<ul>\r\n<li>Attested copy of the qualified person (Dispenser / Compounder / B. Pharmacy/ Pharm-D);</li>\r\n<li>Photocopy (attested) of C.N.I.C of the proprietor and qualified person;</li>\r\n<li>Four attested photographs of the qualified person (Dispenser/ Compounder/ B. Pharmacy/ Pharm-D);</li>\r\n<li>Affidavit by the proprietor and qualified person to inform the Inspector of Drugs as soon as either of the party ceases to have interest in the license issued under the rules;</li>\r\n<li>Attested photocopy of the registration issued by the CCI and in case of Indenter/ Importer;</li>\r\n<li>Rent /receipt/agreement (attested);</li>\r\n<li>Treasury challan for Rs. 5,000; and</li>\r\n<li>Copy of NTN No. </li>\r\n</ul>'),
(6, 'License to sell Drugs by Way of Wholesale 7A', 1, 'License', 4, 'Health Department', 24.9388330, 67.0891410, 'f73EBHZnKKs', '', 'static/media/HealthDepartment.d8d6c2ef08b308b9b02e.PNG', 'document_main.png', 'HD-002', '3 Month', '', '(021) 99222012', 'Rs.5000', 'Renewal Period (Months)', '', '6th Floor, Sindh Secretariat No 1 Kamal Atta Turk Road, Karachi', '<ul>\r\n<li>Attested copy of the qualified person (Dispenser / Compounder / B. Pharmacy/ Pharm-D);</li>\r\n<li>Photocopy (attested) of C.N.I.C of the proprietor and qualified person;</li>\r\n<li>Four attested photographs of the qualified person (Dispenser/ Compounder/ B. Pharmacy/ Pharm-D);</li>\r\n<li>Affidavit by the proprietor and qualified person to inform the Inspector of Drugs as soon as either of the party ceases to have interest in the license issued under the rules;</li>\r\n<li>Attested photocopy of the registration issued by the CCI and in case of Indenter/ Importer;</li>\r\n<li>Rent /receipt/agreement (attested);</li>\r\n<li>Treasury challan for Rs. 5,000; and</li>\r\n<li>Copy of NTN No. </li>\r\n</ul>'),
(7, 'License to sell Drugs in Pharmacy (Form-8)', 1, 'License', 4, 'Health Department', 24.9388330, 67.0891410, '', '', 'static/media/HealthDepartment.d8d6c2ef08b308b9b02e.PNG', 'document_main.png', 'HD-003', '3 Month', '', '(021) 99222012', 'Rs.5000', 'Renewal Period (Months)', '', '6th Floor, Sindh Secretariat No 1 Kamal Atta Turk Road, Karachi', '<ul>\r\n<li>Attested copy of the qualified person (Dispenser / Compounder / B. Pharmacy/ Pharm-D);</li>\r\n<li>Photocopy (attested) of C.N.I.C of the proprietor and qualified person;</li>\r\n<li>Four attested photographs of the qualified person (Dispenser/ Compounder/ B. Pharmacy/ Pharm-D);</li>\r\n<li>Affidavit by the proprietor and qualified person to inform the Inspector of Drugs as soon as either of the party ceases to have interest in the license issued under the rules;</li>\r\n<li>Attested photocopy of the registration issued by the CCI and in case of Indenter/ Importer;</li>\r\n<li>Rent /receipt/agreement (attested);</li>\r\n<li>Treasury challan for Rs. 5,000; and</li>\r\n<li>Copy of NTN No. </li>\r\n</ul>'),
(8, 'License to sell Narcotics and Other Controlled Drugs/ Substances (Form-9)', 1, 'License', 4, 'Health Department', 24.9388330, 67.0891410, '', '', 'static/media/HealthDepartment.d8d6c2ef08b308b9b02e.PNG', 'document_main.png', 'HD-004', '3 Month', '', '(021) 99222012', 'Rs.5000', 'Renewal Period (Months)', '', '6th Floor, Sindh Secretariat No 1 Kamal Atta Turk Road, Karachi', '<ul>\r\n<li>Attested copy of the qualified person (Dispenser / Compounder / B. Pharmacy/ Pharm-D);</li>\r\n<li>Photocopy (attested) of C.N.I.C of the proprietor and qualified person;</li>\r\n<li>Four attested photographs of the qualified person (Dispenser/ Compounder/ B. Pharmacy/ Pharm-D);</li>\r\n<li>Affidavit by the proprietor and qualified person to inform the Inspector of Drugs as soon as either of the party ceases to have interest in the license issued under the rules;</li>\r\n<li>Attested photocopy of the registration issued by the CCI and in case of Indenter/ Importer;</li>\r\n<li>Rent /receipt/agreement (attested);</li>\r\n<li>Treasury challan for Rs. 5,000; and</li>\r\n<li>Copy of NTN No. </li>\r\n</ul>'),
(9, 'License to Manufacturer /Importer /Indenter of Drugs (Form-7)', 1, 'License', 4, 'Health Department', 24.9388330, 67.0891410, 'rmn2OlBCuPQ', '', 'static/media/HealthDepartment.d8d6c2ef08b308b9b02e.PNG', 'document_main.png', 'HD-005', '3 Month', '', '(021) 99222012', 'Rs.5000', 'Renewal Period (Months)', '', '6th Floor, Sindh Secretariat No 1 Kamal Atta Turk Road, Karachi', '<ul>\r\n<li>Attested copy of the qualified person (Dispenser / Compounder / B. Pharmacy/ Pharm-D);</li>\r\n<li>Photocopy (attested) of C.N.I.C of the proprietor and qualified person;</li>\r\n<li>Four attested photographs of the qualified person (Dispenser/ Compounder/ B. Pharmacy/ Pharm-D);</li>\r\n<li>Affidavit by the proprietor and qualified person to inform the Inspector of Drugs as soon as either of the party ceases to have interest in the license issued under the rules;</li>\r\n<li>Attested photocopy of the registration issued by the CCI and in case of Indenter/ Importer;</li>\r\n<li>Rent /receipt/agreement (attested);</li>\r\n<li>Treasury challan for Rs. 5,000; and</li>\r\n<li>Copy of NTN No. </li>\r\n</ul>'),
(10, 'Registration of Privately Managed Schools', 2, 'Registration', 5, 'School Education and Literacy Department (Institutions from Montessori up to Class-X)', 24.8553469, 66.9364199, 'A05s2CnTD8Y', '', 'static/media/SchoolEducationAndLiteracy.1ad6c56b4011179dc702.PNG', 'document_main.png', 'SELD-001', '30 Days', '', '(021) 99211227', 'Rs.7,000', 'Renewal Period (Months)', '', 'School Education & Literacy Department Government of Sindh 1st. Floor, Tughlaq House Sindh Secretariat, Saddar Karachi', '<ul>\r\n<li>Form-A and covering letter;</li>\r\n<li>Treasury challan original and (03) copies (Head of account: C-02818) in the favor of Secretary, Education & Literacy Department in accordance with following fee schedule;</li>\r\n<li>Society registration certificate with bylaws/ trust paper/ private limited or individual CNIC;</li>\r\n<li>If the owned building, then the property documents and other details of ownership. If rented building, then copy of rent agreement (attested by first class Magistrate);</li>\r\n<li>Floor-wise building map;</li>\r\n<li>Teacher-wise/ class-wise Timetable; </li>\r\n<li>Present class-wise enrolment</li>\r\n<li>List of teaching and non- teaching staff with name, father name, qualification, designation, date of appointment and salary;</li>\r\n<li>Class-wise list of textbooks; </li>\r\n<li>List of library books;</li>\r\n<li>List of furniture; </li>\r\n</ul>'),
(11, 'Registration of Privately Managed Schools', 2, 'Registration', 6, 'School Education and Literacy Department (Higher Secondary School)', 24.8553469, 66.9364199, 'A05s2CnTD8Y', '', 'static/media/SchoolEducationAndLiteracy.1ad6c56b4011179dc702.PNG', 'document_main.png', 'SELD-001', '30 Days', '', '(021) 99211227', 'Rs.15,000', 'Renewal Period (Months)', '', 'School Education & Literacy Department Government of Sindh 1st. Floor, Tughlaq House Sindh Secretariat, Saddar Karachi', '<ul>\r\n<li>Form-A and covering letter;</li>\r\n<li>Treasury challan original and (03) copies (Head of account: C-02818) in the favor of Secretary, Education & Literacy Department in accordance with following fee schedule;</li>\r\n<li>Society registration certificate with bylaws/ trust paper/ private limited or individual CNIC;</li>\r\n<li>If the owned building, then the property documents and other details of ownership. If rented building, then copy of rent agreement (attested by first class Magistrate);</li>\r\n<li>Floor-wise building map;</li>\r\n<li>Teacher-wise/ class-wise Timetable; </li>\r\n<li>Present class-wise enrolment</li>\r\n<li>List of teaching and non- teaching staff with name, father name, qualification, designation, date of appointment and salary;</li>\r\n<li>Class-wise list of textbooks; </li>\r\n<li>List of library books;</li>\r\n<li>List of furniture; </li>\r\n</ul>'),
(12, 'Registration of Privately Managed Schools', 2, 'Registration', 7, 'School Education and Literacy Department (Institutions of \"O\" & \"A\" Level)', 24.8553469, 66.9364199, 'A05s2CnTD8Y', '', 'static/media/SchoolEducationAndLiteracy.1ad6c56b4011179dc702.PNG', 'document_main.png', 'SELD-001', '30 Days', '', '(021) 99211227', 'Rs.30,000', 'Renewal Period (Months)', '', 'School Education & Literacy Department Government of Sindh 1st. Floor, Tughlaq House Sindh Secretariat, Saddar Karachi', '<ul>\r\n<li>Form-A and covering letter;</li>\r\n<li>Treasury challan original and (03) copies (Head of account: C-02818) in the favor of Secretary, Education & Literacy Department in accordance with following fee schedule;</li>\r\n<li>Society registration certificate with bylaws/ trust paper/ private limited or individual CNIC;</li>\r\n<li>If the owned building, then the property documents and other details of ownership. If rented building, then copy of rent agreement (attested by first class Magistrate);</li>\r\n<li>Floor-wise building map;</li>\r\n<li>Teacher-wise/ class-wise Timetable; </li>\r\n<li>Present class-wise enrolment</li>\r\n<li>List of teaching and non- teaching staff with name, father name, qualification, designation, date of appointment and salary;</li>\r\n<li>Class-wise list of textbooks; </li>\r\n<li>List of library books;</li>\r\n<li>List of furniture; </li>\r\n</ul>'),
(13, 'Registration of Privately Managed Schools', 2, 'Registration', 8, 'School Education and Literacy Department (Degree awarding institutes and universities including Institutions having academic linkage / foreign collaboration/affiliation with any other institutions of higher learning)', 24.8553469, 66.9364199, 'A05s2CnTD8Y', '', 'static/media/SchoolEducationAndLiteracy.1ad6c56b4011179dc702.PNG', 'document_main.png', 'SELD-001', '30 Days', '', '(021) 99211227', 'Rs.20,000', 'Renewal Period (Months)', '', 'School Education & Literacy Department Government of Sindh 1st. Floor, Tughlaq House Sindh Secretariat, Saddar Karachi', '<ul>\r\n<li>Form-A and covering letter;</li>\r\n<li>Treasury challan original and (03) copies (Head of account: C-02818) in the favor of Secretary, Education & Literacy Department in accordance with following fee schedule;</li>\r\n<li>Society registration certificate with bylaws/ trust paper/ private limited or individual CNIC;</li>\r\n<li>If the owned building, then the property documents and other details of ownership. If rented building, then copy of rent agreement (attested by first class Magistrate);</li>\r\n<li>Floor-wise building map;</li>\r\n<li>Teacher-wise/ class-wise Timetable; </li>\r\n<li>Present class-wise enrolment</li>\r\n<li>List of teaching and non- teaching staff with name, father name, qualification, designation, date of appointment and salary;</li>\r\n<li>Class-wise list of textbooks; </li>\r\n<li>List of library books;</li>\r\n<li>List of furniture; </li>\r\n</ul>'),
(14, 'Registration & Licensing of Healthcare Establishments', 2, 'Registration', 9, 'Sindh Health Care Commission ( Single specialty (i.e general practitioner, homeo, tibb, detist, nursing/ maternity home, laboratories, radiology centre etc.) (Category III & IV))', 24.8583639, 67.0495759, 'v_JbW3t5VNw', '', 'static/media/SindhHealthCare.2697414d9c9eccf8e911.PNG', 'document_main.png', 'SHCC-001', '30 Days', '', '(021) 38656000', 'Rs.500', 'Renewal Period (Months)', '', '2nd Floor, Block C, FTC Building, Shahrah-e-Faisal, Karachi', '<ul>\r\n<li>Copy of CNIC; </li>\r\n<li>Copy of Degree/Diploma; </li>\r\n<li>Copy of updated registration with relevant council (PMDC/PNC/NCH/NCT);</li>\r\n<li>HCE staff list;</li>\r\n<li>HCE Equipment and Machinery list; </li>\r\n<li>Affidavit on stamp paper (sample available in the application form);</li>\r\n<li>Pay order / demand draft in the name of the Sindh Health Care Commission for the registration fee as specified in below table;</li>\r\n</ul>'),
(15, 'Registration & Licensing of Healthcare Establishments', 2, 'Registration', 10, 'Sindh Health Care Commission (1-24 bedded Medical Centre/ Hospital (Category II-B))', 24.8583639, 67.0495759, 'v_JbW3t5VNw', '', 'static/media/SindhHealthCare.2697414d9c9eccf8e911.PNG', 'document_main.png', 'SHCC-001', '30 Days', '', '(021) 38656000', 'Rs.2,000', 'Renewal Period (Months)', '', '2nd Floor, Block C, FTC Building, Shahrah-e-Faisal, Karachi', '<ul>\r\n<li>Copy of CNIC; </li>\r\n<li>Copy of Degree/Diploma; </li>\r\n<li>Copy of updated registration with relevant council (PMDC/PNC/NCH/NCT);</li>\r\n<li>HCE staff list;</li>\r\n<li>HCE Equipment and Machinery list; </li>\r\n<li>Affidavit on stamp paper (sample available in the application form);</li>\r\n<li>Pay order / demand draft in the name of the Sindh Health Care Commission for the registration fee as specified in below table;</li>\r\n</ul>'),
(16, 'Registration & Licensing of Healthcare Establishments', 2, 'Registration', 11, 'Sindh Health Care Commission ( 25 and above bedded Hospital (Category I & II-A))', 24.8583639, 67.0495759, 'v_JbW3t5VNw', '', 'static/media/SindhHealthCare.2697414d9c9eccf8e911.PNG', 'document_main.png', 'SHCC-001', '30 Days', '', '(021) 38656000', 'Rs.5,000', 'Renewal Period (Months)', '', '2nd Floor, Block C, FTC Building, Shahrah-e-Faisal, Karachi', '<ul>\r\n<li>Copy of CNIC; </li>\r\n<li>Copy of Degree/Diploma; </li>\r\n<li>Copy of updated registration with relevant council (PMDC/PNC/NCH/NCT);</li>\r\n<li>HCE staff list;</li>\r\n<li>HCE Equipment and Machinery list; </li>\r\n<li>Affidavit on stamp paper (sample available in the application form);</li>\r\n<li>Pay order / demand draft in the name of the Sindh Health Care Commission for the registration fee as specified in below table;</li>\r\n</ul>'),
(17, 'Registration & Licensing of Healthcare Establishments', 2, 'Registration', 12, 'Sindh Health Care Commission', 24.8583639, 67.0495759, 'v_JbW3t5VNw', '', 'static/media/SindhHealthCare.2697414d9c9eccf8e911.PNG', 'document_main.png', 'SHCC-001', '30 Days', '', '(021) 38656000', 'As per schedule', 'Renewal Period (Months)', '', '2nd Floor, Block C, FTC Building, Shahrah-e-Faisal, Karachi', '<ul>\r\n<li>Copy of CNIC; </li>\r\n<li>Copy of Degree/Diploma; </li>\r\n<li>Copy of updated registration with relevant council (PMDC/PNC/NCH/NCT);</li>\r\n<li>HCE staff list;</li>\r\n<li>HCE Equipment and Machinery list; </li>\r\n<li>Affidavit on stamp paper (sample available in the application form);</li>\r\n<li>Pay order / demand draft in the name of the Sindh Health Care Commission for the registration fee as specified in below table;</li>\r\n</ul>'),
(18, 'Registration & Licensing of Healthcare Establishments', 2, 'Registration', 13, 'Sindh Health Care Commission (Any change in the already registered HCE)', 24.8583639, 67.0495759, 'v_JbW3t5VNw', '', 'static/media/SindhHealthCare.2697414d9c9eccf8e911.PNG', 'document_main.png', 'SHCC-001', '30 Days', '', '(021) 38656000', 'Rs.1,000', 'Renewal Period (Months)', '', '2nd Floor, Block C, FTC Building, Shahrah-e-Faisal, Karachi', '<ul>\r\n<li>Copy of CNIC; </li>\r\n<li>Copy of Degree/Diploma; </li>\r\n<li>Copy of updated registration with relevant council (PMDC/PNC/NCH/NCT);</li>\r\n<li>HCE staff list;</li>\r\n<li>HCE Equipment and Machinery list; </li>\r\n<li>Affidavit on stamp paper (sample available in the application form);</li>\r\n<li>Pay order / demand draft in the name of the Sindh Health Care Commission for the registration fee as specified in below table;</li>\r\n</ul>'),
(19, 'Registration Certificate of Partnership Firm', 2, 'Registration', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, 'Pjse_y80ElE', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-001', '3 Days', '', '(021) 99202190', 'Rs.110', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(20, 'Registration Certificate of Amendment/Dissolution /Rectification in Partnership Firm', 2, 'Registration', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, 'AIpM67XfHHo', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-002', '5 days', '', '(021) 99202190', 'Rs.55', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(21, 'Registration of New Boiler', 2, 'Registration', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, 'vxjUhcMkiQE', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-003', '10-15 Days', '', '(021) 99202190', 'S.R.O.88(I)/2008)', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(22, 'Registration of Old Boiler', 2, 'Registration', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, '_ulp3Nv-4nY', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-004', '10-15 Days', '', '(021) 99202190', 'S.R.O.88(I)/2008)', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(23, 'Approval of Plan and Particulars of Boilers Acceptable for Registration (New Boiler)', 5, 'Other', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, 'hw5Euiro6xo', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-005', '10-15 Days', '', '(021) 99202190', 'S.R.O.88(I)/2008)', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(24, 'Approval of Plan and Particulars of Boilers Acceptable for Registration (Used Boiler)', 5, 'Other', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, '3BsaA6lqPks', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-006', '10-15 Days', '', '(021) 99202190', 'S.R.O.88(I)/2008)', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(25, 'Transfer of Ownership', 5, 'Other', 14, 'Industries and Commerce Department', 24.8544337, 66.9871678, 'Ch2YOR83tmY', '', 'static/media/IndustrieAndCommerce.9536fa663c5860e82094.PNG', 'document_main.png', 'ICD-007', '10-15 Days', '', '(021) 99202190', 'S.R.O.88(I)/2008)', 'Renewal Period (Months)', '', 'statelife building no 11, 2nd floor Directorate of industries', '<ul>\r\n<li>Partnership deed; </li>\r\n<li>CNIC copies of all the local partners; </li>\r\n<li>Form 1 along with partnership witness form; and </li>\r\n<li>Prescribed fee challan of Rs. 110. </li>\r\n<b>In case a company is a partner</b>\r\n<li>Certified copy of incorporation certificate; </li>\r\n<li>Form 29 (in case a local company is a partner);</li>\r\n<li>Copy of Board Resolution; and</li>\r\n<li>Certified copy of Memorandum of association (MOA) & Article of Association clearly stating that partnership is allowed for the company. </li>\r\n<b>Additional requirements in case of a foreign company </b>\r\n<li>CEO\'s passport/ visa copy; and </li>\r\n<li>SECP equivalence letter. </li>\r\n</ul>'),
(26, 'License for Handling of Hazardous Substances', 1, 'License', 15, 'Sindh Environmental Protection Agency (SEPA)', 24.8376612, 67.0792909, 'Ee-N5EuQdEM', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-001', '7 Days', '', '(021) 35065950', 'Rs.50000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(27, 'License to Waste Contractor for Handling of Hazardous Substances and Non-Hazardous substances', 1, 'License', 15, 'Sindh Environmental Protection Agency (SEPA)', 24.8376612, 67.0792909, '', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-002', '7 days', '', '(021) 35065950', 'Rs.50000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(28, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 16, 'Sindh Environmental Protection Agency (SEPA) (Up to 20 Million)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'Rs.50,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(29, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 17, 'Sindh Environmental Protection Agency (SEPA) (Above 20 Million up to 100 Million)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'Rs.100,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(30, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 18, 'Sindh Environmental Protection Agency (SEPA) (Above 100 Milliion up to 200Million)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'Rs.200,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(31, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 19, 'Sindh Environmental Protection Agency (SEPA) (Above 200 Million up to 500 Million)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'Rs.400,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(32, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 20, 'Sindh Environmental Protection Agency (SEPA) (Above 500 Million)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'Rs.600,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(33, 'Approval Under Section 17 (IEE/EIA/EC)', 5, 'Other', 21, 'Sindh Environmental Protection Agency (SEPA) (Review fee for Environmental Checklist or EMP is)', 24.8376612, 67.0792909, 'ZRUTctbO298', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-003', 'EC (15 days) \r\nâ–ª IEE (30 days) \r\nâ–ª EIA (60 days)', '', '(021) 35065950', 'PKR 40,000.', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(34, 'Approval of an Environmental Management Plan', 5, 'Other', 15, 'Sindh Environmental Protection Agency (SEPA)', 24.8376612, 67.0792909, 'nxAdh1MJqGI', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-004', '7-10 Days', '', '(021) 35065950', 'PKR 40,000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(35, 'Certification of Environmental Lab', 4, 'Certificate', 22, 'Sindh Environmental Protection Agency (SEPA) (Security Fee)', 24.8376612, 67.0792909, '9l4IX-lMKOc', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-005', '7 Days', '', '(021) 35065950', 'Rs.20000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(36, 'Certification of Environmental Lab', 4, 'Certificate', 23, 'Sindh Environmental Protection Agency (SEPA) (Certificate Fee)', 24.8376612, 67.0792909, '9l4IX-lMKOc', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-005', '7 Days', '', '(021) 35065950', 'Rs.50000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(37, 'Approval of Hospital Waste Management Plan', 5, 'Other', 15, 'Sindh Environmental Protection Agency (SEPA)', 24.8376612, 67.0792909, '5-HiE-sVtcI', '', 'static/media/SindhEnviromentalProtection.564e0dab26b745481821.PNG', 'document_main.png', 'SEPA-006', '7 days', '', '(021) 35065950', 'Rs.50000', 'Renewal Period (Months)', '', 'ST-21,, Sector 23 Korangi Industrial Area, Karachi, Karachi City, Sindh', '<ul>\r\n<li>Covering letter;</li>\r\n<li>Hazardous substances management plan; and</li>\r\n<li>Pay order of PKR 50,000/- as prescribed in the Schedule-III of Hazardous Substances Rules, 2014.</li>\r\n</ul>'),
(38, 'Approval of proposed building plan for Category-I', 5, 'Other', 24, 'Sindh Building Control Authority (SBCA) (Residential area category I. I-A. II. III. IX & X.)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.15 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(39, 'Approval of proposed building plan for Category-I', 5, 'Other', 25, 'Sindh Building Control Authority (SBCA) (Residential area category Area category IV. V. VI. VII &. VIII)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(40, 'Approval of proposed building plan for Category-I', 5, 'Other', 26, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area Cat I. I-A. II. III. IX & X)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.20 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(41, 'Approval of proposed building plan for Category-I', 5, 'Other', 27, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area CatI V.V. VII. VII& VIII)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.16 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(42, 'Approval of proposed building plan for Category-I', 5, 'Other', 28, 'Sindh Building Control Authority (SBCA) (Industrial Scrutiny fee for industrial plot, which is situated beyond 50km from Municipal Limit All Cat)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.18 Rs.1', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(43, 'Approval of proposed building plan for Category-I', 5, 'Other', 29, 'Sindh Building Control Authority (SBCA) (Amanities)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-001 (A)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(44, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 24, 'Sindh Building Control Authority (SBCA) (Residential area category I. I-A. II. III. IX & X.)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.15 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(45, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 30, 'Sindh Building Control Authority (SBCA) (Residential area category IV. V. VI. VII &. VIII)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(46, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 26, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area Cat I. I-A. II. III. IX & X)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.20 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(47, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 27, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area CatI V.V. VII. VII& VIII)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.16 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(48, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 28, 'Sindh Building Control Authority (SBCA) (Industrial Scrutiny fee for industrial plot, which is situated beyond 50km from Municipal Limit All Cat)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.18 Rs.1', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(49, 'Approval of proposed building plan for Category-II, III, IV', 5, 'Other', 29, 'Sindh Building Control Authority (SBCA) (Amanities)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-001 (B)', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(50, 'Notice of Completion (Category I to IV', 5, 'Other', 24, 'Sindh Building Control Authority (SBCA) (Residential area category I. I-A. II. III. IX & X.)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.15 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(51, 'Notice of Completion (Category I to IV', 5, 'Other', 30, 'Sindh Building Control Authority (SBCA) (Residential area category IV. V. VI. VII &. VIII)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(52, 'Notice of Completion (Category I to IV', 5, 'Other', 26, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area Cat I. I-A. II. III. IX & X)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.20 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(53, 'Notice of Completion (Category I to IV', 5, 'Other', 27, 'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area CatI V.V. VII. VII& VIII)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.16 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(54, 'Notice of Completion (Category I to IV', 5, 'Other', 28, 'Sindh Building Control Authority (SBCA) (Industrial Scrutiny fee for industrial plot, which is situated beyond 50km from Municipal Limit All Cat)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.18 Rs.1', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(55, 'Notice of Completion (Category I to IV', 5, 'Other', 29, 'Sindh Building Control Authority (SBCA) (Amanities)', 24.8994201, 67.0535642, 'djpu_ePLeQs', '', '', 'document_main.png', 'SBCA-002', '5 days for Cat-I &; 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs.11 PSF', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(56, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 31, 'Sindh Building Control Authority (SBCA) (Cat A-l)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 5000/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(57, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 32, 'Sindh Building Control Authority (SBCA) (Cat : 2)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 5000/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(58, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 33, 'Sindh Building Control Authority (SBCA) (Cat : 3)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 2500/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(59, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 34, 'Sindh Building Control Authority (SBCA) (Cat : 4)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 2500/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(60, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 35, 'Sindh Building Control Authority (SBCA) (Cat : 5)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 1500/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(61, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 36, 'Sindh Building Control Authority (SBCA) (Cat : 6)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 700/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(62, 'Additional floor Charges for Category (I) / Betterment Charges for Category (II, III & IV', 5, 'Other', 37, 'Sindh Building Control Authority (SBCA) (Cat : 7)', 24.8994201, 67.0535642, '8N-Qlm3X3h4', '', '', 'document_main.png', 'SBCA-003', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Rs. 700/-', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(63, 'Renewal of Building Plan for Category (I To IV)', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'ETLaKy9ie6g', '', '', 'document_main.png', 'SBCA-004', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'As per schedule', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(64, 'Addition / Alteration / Revision of Building Plan for Category (I To IV)', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'SJPwZbTZQa4', '', '', 'document_main.png', 'SBCA-005', '15 days for Cat I and 60 Days for Cat-II, III &; IV', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(65, 'Permit to Demolish Buildings for Category (I To IV)', 3, 'Permit', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '31aDwDvJIhA', '', '', 'document_main.png', 'SBCA-006', '15 Days', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(66, 'Attestation Fee', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'A421Wc_c5JM', '', '', 'document_main.png', 'SBCA-007', '3 Days', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', '');
INSERT INTO `rlcos` (`id`, `name`, `category_id`, `category_id_name`, `department_id`, `department_id_name`, `latitude`, `longitude`, `main_info_video_path`, `main_info_photo_path`, `requirment_info_photo_path`, `document_info_photo_path`, `registration_num`, `process_time`, `process_time_unit`, `contact_num`, `fees`, `renewal_period`, `renewal_period_unit`, `address`, `doc_requirements`) VALUES
(67, 'COPY OF APPROVED BUILDING PLAN', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-008', '3 Days', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(68, 'NOC for Structure (Vetting & Departmental)', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'I0pkxrZGZPY', '', '', 'document_main.png', 'SBCA-009', '7 Days', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(69, 'Builder License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-010', '3 Month', '', '(021) 99230329', 'Not Available', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(70, 'Developer License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-011', '1 Month', '', '(021) 99230329', 'Rs.300,000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(71, 'Soil/ Material Testing', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-012', '3 Month', '', '(021) 99230329', 'Rs.10000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(72, 'Architecture License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'kzEbVdSxRlQ', '', '', 'document_main.png', 'SBCA-013', '3 Month', '', '(021) 99230329', 'Rs.20000 for Cat A For Cat B', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(73, 'Building Supervisor License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-014', '3 Month', '', '(021) 99230329', 'Rs.6000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(74, 'Professional Engineering License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, '', '', '', 'document_main.png', 'SBCA-015', '3 Month', '', '(021) 99230329', 'Rs.6000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(75, 'Structural Engineer License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'tj9ulgt3BNs', '', '', 'document_main.png', 'SBCA-016', '3 Month', '', '(021) 99230329', 'Rs.20000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(76, 'Town Planner License', 1, 'License', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'r141q7JdWfA', '', '', 'document_main.png', 'SBCA-017', '3 Month', '', '(021) 99230329', 'Rs.10000', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(77, 'Issuance of the NOC for Sale & Advertisement', 5, 'Other', 38, 'Sindh Building Control Authority (SBCA)', 24.8994201, 67.0535642, 'fMbuQPyN-DQ', '', '', 'document_main.png', 'SBCA-018', '1 Month', '', '(021) 99230329', 'Rs.500', 'Renewal Period (Months)', '', 'V3XF+X36, Civic Center, University Road, Pakistan, Block 14 Gulshan-e-Iqbal, Karachi, Karachi City, Sindh', ''),
(78, 'Distributor Registration / License (for both Pesticides and fertilizers)', 2, 'Registration', 39, 'Agriculture Department', 24.8555931, 67.0166176, 'Kf9KyIAN-qk', '', '', 'document_main.png', 'AD-001', '1 Month', '', '922199211468', 'Pesticide Rs.200,000/-', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(79, 'Distributor Registration / License (for both Pesticides and fertilizers)', 2, 'Registration', 39, 'Agriculture Department', 24.8555931, 67.0166176, 'Kf9KyIAN-qk', '', '', 'document_main.png', 'AD-001', '1 Month', '', '922199211468', 'Fertilizer Rs. 50,000/-', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(80, 'Product License for Fertilizer Micronutrients', 1, 'License', 39, 'Agriculture Department', 24.8555931, 67.0166176, 'cRh3fObW8TA', '', '', 'document_main.png', 'AD-002', '1 Month', '', '922199211468', 'Rs.5000 Lab Fee', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(81, 'Market Committee License (Retailer, Wholesaler, Factories)', 1, 'License', 39, 'Agriculture Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'AD-003', '7-10 days', '', '922199211468', 'Rs. 1,000 (for Factories - A group)', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(82, 'Market Committee License (Retailer, Wholesaler, Factories)', 1, 'License', 39, 'Agriculture Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'AD-003', '7-10 days', '', '922199211468', 'Rs. 500 (for wholesaler - B group)', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(83, 'Market Committee License (Retailer, Wholesaler, Factories)', 1, 'License', 39, 'Agriculture Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'AD-003', '7-10 days', '', '922199211468', 'Rs. 100 (for Retailers - C group)', 'Renewal Period (Months)', '', 'Sindh Secretariat Building # 2 (Tughluq House), Ground Floor, Karachi, Pakistan', ''),
(84, 'Allotment of Land/ Plot', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, '8mjOBP1AE-8', '', '', 'document_main.png', 'ICD-008 (A)', '60 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(85, 'Approval of Building Drawing', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'Qz7qi-BVPyM', '', '', 'document_main.png', 'ICD-008 (B)', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(86, 'Approval of Completion (Block) Plan', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'PHJjtXE1Ytg', '', '', 'document_main.png', 'ICD-008 (C)', '7 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(87, 'Collection of Additional Trade Fee', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'lPXbf7VMUh0', '', '', 'document_main.png', 'ICD-009', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(88, 'Subdivision/ Amalgamation/ Transfer/ Subletting/ Extension of Land or Plot/ Change in Constitution/ change in Constitution', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'ZGdIPCmJN98', '', '', 'document_main.png', 'ICD-010', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(89, 'Issuance of Lease Deed', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'shZj4wxXQb4', '', '', 'document_main.png', 'ICD-011', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(90, 'NOC for Utilities (Electricity, Gas, Cable, PTCL)', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, '2jGBSB9P8Gk', '', '', 'document_main.png', 'ICD-012', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(91, 'NOC for Mortgage', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'XiJAg3My7rg', '', '', 'document_main.png', 'ICD-013', '14 days', '', '(021) 99333152', 'Rs.50,000/-', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(92, 'NOC for Road Cutting', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'HFh7AnHpqbY', '', '', 'document_main.png', 'ICD-014', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(93, 'NOC for car parking/ beautification', 5, 'Other', 40, 'Sindh Industrial Trading Estate (S.I.T.E) Limited', 24.8913268, 66.9818463, 'U_RhOucontc', '', '', 'document_main.png', 'ICD-015', '14 days', '', '(021) 99333152', 'Not Available', 'Renewal Period (Months)', '', 'W267+673, Estate Ave, SITE Industrial Area, Karachi, Sindh, Sindh Industrial Trading Estate', ''),
(94, 'Allotment Order of Land/ Plot', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '6JSs3ytSJQE', '', '', 'document_main.png', 'ICD-016', '15 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(95, 'Approval of Drawing', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, 'Qz7qi-BVPyM', '', '', 'document_main.png', 'ICD-017', '5-10 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(96, 'Subdivision/Transfer/ Amalgamation/ Change in constitution (Corporate Setup)/ Change in Trade/ Subletting trade/ Conversion of plot from Industrial to Commercial/ CNG petroleum station/ Godowns & Distribution', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '', '', '', 'document_main.png', 'ICD-018', '5-10 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(97, 'NOC for Utilities (Electricity, Telephone, Gas, Water)', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '', '', '', 'document_main.png', 'ICD-019', '5-10 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(98, 'NOC for Road Cutting', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '', '', '', 'document_main.png', 'ICD-020', '5-10 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(99, 'Issuance of Lease Draft', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '', '', '', 'document_main.png', 'ICD-021', '15-25 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(100, 'NOC for Mortgage', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, '', '', '', 'document_main.png', 'ICD-022', '15-25 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(101, 'Un- authorized Construction', 5, 'Other', 41, 'Sindh Small Industries Corporation (SSIC)', 24.8589893, 67.0107249, 'G5DaqoSCcW0', '', '', 'document_main.png', 'ICD-023', '15-25 Days', '', '(021) 99332167-68', 'Not Available', 'Renewal Period (Months)', '', 'AM-310, Preedy Street, Saddar, Karachi', ''),
(102, 'Issuance of the True Copy of Land Record', 5, 'Other', 42, 'Board of Revenue', 24.8171329, 67.0054054, '_7I4EaKvHRc', '', '', 'document_main.png', 'BOR-001', 'Same Day', '', '(021) 111 267 467', 'Rs.300 Per Page', 'Renewal Period (Months)', '', 'ST-4, Revenue House, Adjacent Dr. Ziauddin Hospital Clifton Block-6, Karachi.', ''),
(103, 'Registration of Document', 5, 'Other', 42, 'Board of Revenue', 24.8171329, 67.0054054, '', '', '', 'document_main.png', 'BOR-004', '10 Days', '', '(021) 111 267 467', 'Not Available', 'Renewal Period (Months)', '', 'ST-4, Revenue House, Adjacent Dr. Ziauddin Hospital Clifton Block-6, Karachi.', ''),
(104, 'Trade License', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, 'k-HCy___i0o', '', '', 'document_main.png', 'DMC- 001', '1 day', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(105, 'Road Cutting Permission', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, '', '', '', 'document_main.png', 'DMC-002', '7-10 days', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(106, 'NOC/Permission for Holding Fairs, Events, Tournaments, and other Public Gatherings at DMC Central\'s Jurisdiction', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, '', '', '', 'document_main.png', 'DMC-003', '1 day', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(107, 'NOC/Permission for Holding Fairs, Events, Tournaments, and other Public Gatherings at DMC Central\'s Jurisdiction', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, 'c9HgWnNv4-w', '', '', 'document_main.png', 'DMC-004', '7 to 10 days', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(108, 'Permission for Keeping Building Material on Roads during Construction', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, '', '', '', 'document_main.png', 'DMC-005', '1 to 2 days', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(109, 'NOC/Permission for Holding Different Kind of Sports Activities in Playgrounds, Gymnasium, Sports Complex & Facilities of DMC-Central', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, '_OFfZN3_QrA', '', '', 'document_main.png', 'DMC-006', '7 to 15 days', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(110, 'NOC/Permission for Establishment of Nurseries in parks, Playgrounds & Open spaces of DMC-Centra', 5, 'Other', 43, 'District Municipal Corporation (DMC)', 24.9183104, 67.0938981, '', '', '', 'document_main.png', 'DMC-007', '7 to 15 days', '', '(021) 99260342', 'Not Available', 'Renewal Period (Months)', '', 'Rashid Minhas Rd, Karachi 75950 Rashid Minhas Rd, Federal B Area Block 16 Gulberg Town, Karachi, Karachi City, Sindh', ''),
(111, 'Transfer/ Mutation of Land', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'scsENrxlY3A', '', '', 'document_main.png', 'KMC-001', '15 days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(112, 'NOC for Sale', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '8mjOBP1AE-8', '', '', 'document_main.png', 'KMC-002', '15 days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(113, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '5w5jtZ_CyLU', '', '', 'document_main.png', 'KMC-003', '15 days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(114, 'Lease', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'PeTpr90aNKg', '', '', 'document_main.png', 'KMC-004', '1 month', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(115, 'Transfer/ Mutation of Land in Orangi Town', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'y-g5gfIwBxk', '', '', 'document_main.png', 'KMC-005', '15 days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(116, 'NOC for Sale', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '8mjOBP1AE-8', '', '', 'document_main.png', 'KMC-006', '15 days', '', '(021) 99215125', 'Residential Rs.1000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(117, 'NOC for Sale', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '8mjOBP1AE-8', '', '', 'document_main.png', 'KMC-006', '15 days', '', '(021) 99215125', 'Commercial Rs.2000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(118, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-007', '15 days', '', '(021) 99215125', 'Residential Rs.10,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(119, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-007', '15 days', '', '(021) 99215125', 'Residential Cum Commercial Rs.15,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(120, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-007', '15 days', '', '(021) 99215125', 'Commercial Rs.20,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(121, 'Pre-Lease', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '', '', '', 'document_main.png', 'KMC-008', '1 month', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(122, 'Lease', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'SnAf4qthctA', '', '', 'document_main.png', 'KMC-009', '1 month', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(123, 'Amalgamation and Subdivision of Land', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'xDEbd0FgMeM', '', '', 'document_main.png', 'KMC-010', '15 days', '', '(021) 99215125', 'Residential Per Sq Yard Rs.100', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(124, 'Amalgamation and Subdivision of Land', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'xDEbd0FgMeM', '', '', 'document_main.png', 'KMC-010', '15 days', '', '(021) 99215125', 'Commerical per sq yard Rs.200', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(125, 'Transfer / Mutation of Land in Katchi Abadi', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'W2nnCUU9BVY', '', '', 'document_main.png', 'KMC-011', '15 Days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(126, 'NOC for Sale', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '8mjOBP1AE-8', '', '', 'document_main.png', 'KMC-012', '15 Days', '', '(021) 99215125', 'Resedential Rs.1000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(127, 'NOC for Sale', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '8mjOBP1AE-8', '', '', 'document_main.png', 'KMC-012', '15 Days', '', '(021) 99215125', 'Commercial Rs.2000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(128, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-013', '15 Days', '', '(021) 99215125', 'Residential Rs.10,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(129, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-013', '15 Days', '', '(021) 99215125', 'Residential Cum Commercial Rs.15,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(130, 'NOC for Mortgage', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'ATfhnjIKAjo', '', '', 'document_main.png', 'KMC-013', '15 Days', '', '(021) 99215125', 'Commercial Rs.20,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(131, 'Lease', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '', '', '', 'document_main.png', 'KMC-014', '1 Month', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(132, 'Amalgamation and Subdivision of Land', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '', '', '', 'document_main.png', 'KMC-015', '15 Days', '', '(021) 99215125', 'Residential Per Sq Yard Rs.100', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(133, 'Amalgamation and Subdivision of Land', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '', '', '', 'document_main.png', 'KMC-015', '15 Days', '', '(021) 99215125', 'Commerical per sq yard Rs.200', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(134, 'Temporary NOC for Land use for beautification outside the premises of private property', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'quKll25QvWs', '', '', 'document_main.png', 'KMC-016', '15 Days', '', '(021) 99215125', 'Rs.1 Per Sq Ft Per Day', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(135, 'Temporary NOC for temporary installation of Generators outside the premises', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'WP5Z-f6Kmgc', '', '', 'document_main.png', 'KMC-017', '15 Days', '', '(021) 99215125', 'District Nort Rs.15000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(136, 'Temporary NOC for temporary installation of Generators outside the premises', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'WP5Z-f6Kmgc', '', '', 'document_main.png', 'KMC-017', '15 Days', '', '(021) 99215125', 'District East Rs.10000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(137, 'Temporary NOC for temporary installation of Generators outside the premises', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'WP5Z-f6Kmgc', '', '', 'document_main.png', 'KMC-017', '15 Days', '', '(021) 99215125', 'District Centeral Rs.7500', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(138, 'Temporary NOC for temporary installation of Generators outside the premises', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'vWP5Z-f6Kmgc', '', '', 'document_main.png', 'KMC-017', '15 Days', '', '(021) 99215125', 'District West Rs.5000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(139, 'Temporary NOC for keeping building materials on roads during construction', 5, 'Other', 45, 'Karachi Metropolitan Corporation (KMC) (Commercial Building & Complex)', 24.8576240, 67.0018004, '64t91Kj8si4', '', '', 'document_main.png', 'KMC-018', '15 Days', '', '(021) 99215125', 'On Streed Rs.10 Per Sq Ft', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(140, 'Temporary NOC for keeping building materials on roads during construction', 5, 'Other', 45, 'Karachi Metropolitan Corporation (KMC) (Commercial Building & Complex)', 24.8576240, 67.0018004, '64t91Kj8si4', '', '', 'document_main.png', 'KMC-018', '15 Days', '', '(021) 99215125', 'On Footpath Rs.5 Per Sq Ft', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(141, 'Temporary NOC for keeping building materials on roads during construction', 5, 'Other', 46, 'Karachi Metropolitan Corporation (KMC) (Resedential)', 24.8576240, 67.0018004, '64t91Kj8si4', '', '', 'document_main.png', 'KMC-018', '15 Days', '', '(021) 99215125', 'On street Rs.5 Per Sq Ft', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(142, 'Temporary NOC for keeping building materials on roads during construction', 5, 'Other', 46, 'Karachi Metropolitan Corporation (KMC) (Resedential)', 24.8576240, 67.0018004, '64t91Kj8si4', '', '', 'document_main.png', 'KMC-018', '15 Days', '', '(021) 99215125', 'On Footpath Rs.3 Per Sq Ft', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(143, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'Karachi Zoo & Park Rs.7000 Per Hour', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(144, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'Security Deposit Rs.25000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(145, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'In Karachi Zoo Rs.10,000 Per Hour', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(146, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'Security Deposit Rs.50,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(147, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'Karachi Safari Park Rs.7,000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(148, 'NOC for film and Ad shooting in Safari Park and Karachi Zoo', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'r07i0Y-m95M', '', '', 'document_main.png', 'KCM-019', '15 Days', '', '(021) 99215125', 'Secuirty Deposit Rs.25000', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(149, 'Outdoor Advertisement on major Bridges and underpass', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'IHOrg1sZY9I', '', '', 'document_main.png', 'KMC-020', '15 Days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(150, 'Road Cutting Permission', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'gtbEWDj_QUw', '', '', 'document_main.png', 'KMC-021', '15 Days', '', '(021) 99215125', 'As per schedule', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(151, 'NOC for organizing temporary Bachat Bazars', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, 'mwpIYdLtFM8', '', '', 'document_main.png', 'KMC-022', '15 Days', '', '(021) 99215125', 'Rs.57000 as a cost of the cabin', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(152, 'Reservation of KMC Sports Complexes and playgrounds in Karachi for Sports events', 5, 'Other', 44, 'Karachi Metropolitan Corporation (KMC)', 24.8576240, 67.0018004, '', '', '', 'document_main.png', 'KMC-023', '15 Days', '', '(021) 99215125', 'Rs.4000 Per Match Per day', 'Renewal Period (Months)', '', 'Adhumal Oodharam Quarter, Karachi, Karachi City, Sindh', ''),
(153, 'Electrical Contractor License', 1, 'License', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-001', 'NA', '', '(021) 99206272', 'Rs.5,000', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(154, 'Competency Certificate for Wireman', 4, 'Certificate', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-002', 'NA', '', '(021) 99206272', 'Rs.100', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(155, 'Competency Certificate for Wireman', 4, 'Certificate', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-002', 'NA', '', '(021) 99206272', 'Late Fee: Rs.150', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(156, 'Competency Certificate for Electric Supervisor', 4, 'Certificate', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-003', 'NA', '', '(021) 99206272', 'Rs.500', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(157, 'Competency Certificate for Electric Supervisor', 4, 'Certificate', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-003', 'NA', '', '(021) 99206272', 'Late Fee Rs.750', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(158, 'Exploration License for Coal (Large Scale)', 1, 'License', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-004', '100 Days', '', '(021) 99206272', 'Rs.200,000', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(159, 'Mining Lease (Large Scale)', 5, 'Other', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-005', 'NA', '', '(021) 99206272', 'Rs.300,000', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(160, 'Exploration Permit (Small Scale)', 3, 'Permit', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-006', 'NA', '', '(021) 99206272', 'Rs.100,000', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(161, 'Mining Permit (Small  Scale)', 3, 'Permit', 47, 'Energy Department', 24.8447116, 67.0219084, '', '', '', 'document_main.png', 'ED-007', 'NA', '', '(021) 99206272', 'Rs.200,000', 'Renewal Period (Months)', '', '3rd Floor, Statelife Building No.3, Dr. Opposite CM House, Doctor Ziauddin Ahmed Road, Kashmir Mujahid Colony, Karachi, Karachi City, Sindh', ''),
(162, 'Registration of an Establishments (R-1)', 2, 'Registration', 48, 'Sindh Employees Social Security Institution (SESSI)', 24.8612297, 67.1223026, '', '', '', 'document_main.png', 'SESSI-001', 'Same Day', '', '(021) 99243813', 'Not Available', 'Renewal Period (Months)', '', 'Plot no. G, 270, Jamal Goth Landhi Karachi Mansehra Colony Mansehra Colony Sector 32 Landhi Town, Karachi, Karachi City, Sindh', ''),
(163, 'Motor vehicle Registration', 2, 'Registration', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, 'Qc9b0b5go1g', '', '', 'document_main.png', 'ET&NC-001', '7 days', '', '(021) 99231410', 'As per schedule', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(164, 'Transfer on Motor vehicle', 5, 'Other', 50, 'Excise, Taxation & Narcotics Control Department(Motorcycle)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-002', '7 days', '', '(021) 99231410', 'Rs.200/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(165, 'Transfer on Motor vehicle', 5, 'Other', 51, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. up to 800 cc Engine Power)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-002', '7 days', '', '(021) 99231410', 'Rs.800/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(166, 'Transfer on Motor vehicle', 5, 'Other', 52, 'Excise, Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. from 801 cc to 2,000 cc Engine Power)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-002', '7 days', '', '(021) 99231410', 'Rs.1,000/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(167, 'Transfer on Motor vehicle', 5, 'Other', 53, 'Excise, Taxation & Narcotics Control Department(Rickshaws)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-002', '7 days', '', '(021) 99231410', 'Rs.400/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(168, 'Transfer on Motor vehicle', 5, 'Other', 54, 'Excise, Taxation & Narcotics Control Department(Tractors)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-002', '7 days', '', '(021) 99231410', 'Rs.1,000/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(169, 'Alteration of Vehicle', 5, 'Other', 55, 'Excise, Taxation & Narcotics Control Department(Big Vehicle)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-003', '7 days', '', '(021) 99231410', 'Rs.1,500/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(170, 'Alteration of Vehicle', 5, 'Other', 56, 'Excise, Taxation & Narcotics Control Department(Small Vehicle)', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-003', '7 days', '', '(021) 99231410', 'Rs.1,250/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(171, 'Motor Vehicle Dealer  License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-004', '7 days', '', '(021) 99231410', 'Prescribed fee of Rs. 7,000/- (32-A challan for)', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(172, 'Professional Tax Registration', 2, 'Registration', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-005', 'Same Day', '', '(021) 99231410', 'As per schedule', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(173, 'Distillery License for Intoxicating Liquor', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-006', '1 Month', '', '(021) 99231410', 'Distillery License for intoxicating Liquor 30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(174, 'Distillery License for Intoxicating Liquor', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-006', '1 Month', '', '(021) 99231410', 'Establishment Charges 3,500,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(175, 'Manufacturing of PMFL License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-007', '1 Month', '', '(021) 99231410', 'Manufacturing of PMFL License 30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(176, 'Manufacturing of PMFL License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-007', '1 Month', '', '(021) 99231410', 'Establishment Charges 3,500,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(177, 'Brewery License for Beer', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-008', '1 Month', '', '(021) 99231410', 'Establishing a Brewery for Beer 30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(178, 'Brewery License for Beer', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-008', '1 Month', '', '(021) 99231410', 'Establishment Charges 35,00,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(179, 'Trade and Import License for Portable Liquor (Wholesale) Note: At present, there is a complete ban on the grant / issuance of new liquor licenses in the Province of Sindh.', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-009', '1 Month', '', '(021) 99231410', 'Trade and Import License for Potable Liquor (Wholesale) Rs. 7,000,000/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(180, 'Retail Off Liquor License Note: At present, there is a complete ban on the grant / issuance of new liquor license in the Province of Sindh.', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-010', '1 Month', '', '(021) 99231410', 'Retail off Liquor License 5,000,000/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(181, 'Distillery License for Manufacturing of Ethanol', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-011', '1 Month', '', '(021) 99231410', 'Distillery License for manufacturing of Ethanol 30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(182, 'Distillery License for Manufacturing of Ethanol', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-011', '1 Month', '', '(021) 99231410', 'Establishment Fee 3,500,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(183, 'Sale of Rectified Spirit License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-012', '1 Month', '', '(021) 99231410', 'Sale of Rectified Spirit License 180,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(184, 'Denaturation of Rectified Spirit License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-013', '1 Month', '', '(021) 99231410', 'Denaturation of Rectified Spirit License 24,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(185, 'Denatured Spirit License for Wholesale', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-014', '1 Month', '', '(021) 99231410', 'Denatured Spirit License for Wholesale Rs.30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(186, 'Denatured Spirit License for Retail', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-015', '1 Month', '', '(021) 99231410', 'Denatured Spirit License for Retail-Sale 2400/- per anum (License fee) and 2400/- per anum (Bottling Fee)', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(187, 'Intoxicants (Drugs) Manufacturing License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-016', '1 Month', '', '(021) 99231410', 'Denatured Spirit License for Retail-Sale 2400/- per anum (License fee) and 2400/- per anum (Bottling Fee)', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(188, 'Intoxicants (Drugs) Commercial Sale License', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-017', '1 Month', '', '(021) 99231410', 'Intoxicants (Drugs) Commercial Sale License 25,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(189, 'Permit for Hotels for RetailSale of Intoxicating Liquor', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-018', '1 Month', '', '(021) 99231410', 'As per schedule', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(190, 'Club license', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-019', '1 Month', '', '(021) 99231410', 'Club License 60,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(191, 'Methanol Wholesale License for Commercial Use', 1, 'License', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-020', '1 Month', '', '(021) 99231410', 'Methanol Wholesale License for Commercial Use 30,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(192, 'Permission to Purchase and Use of Methanol Spirit in Arts or Industries', 5, 'Other', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-021', '1 Month', '', '(021) 99231410', 'Permission to Purchase and Use of Methanol Spirit in Arts or Industry 3,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(193, 'Permission to use Rectified Spirit in the Manufacturing of Spirituous / Medicinal / Homeopathic / Toilet Preparation', 5, 'Other', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-022', '1 Month', '', '(021) 99231410', 'Permission to use Rectified Spirit in the Manufacturing of Spirituous / Medicinal/ Toilet  Preparation 15,000/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(194, 'Permission to use Rectified Spirit in the Manufacturing of Spirituous / Medicinal / Homeopathic / Toilet Preparation', 5, 'Other', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-022', '1 Month', '', '(021) 99231410', 'Permission to use Rectified Spirit in the Manufacturing Homeopathic Medicine Preparation 600/- per annum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(195, 'Permission to use Rectified Spirit in the Manufacturing of Spirituous / Medicinal / Homeopathic / Toilet Preparation', 5, 'Other', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-022', '1 Month', '', '(021) 99231410', 'Establishment Charges 3,500,000/- per anum', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(196, 'Transport Permit (Buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023', '3 Days', '', '(021) 99231410', 'Transport Permit for Beer 76/- Per Liter', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(197, 'Transport Permit (Buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023', '3 Days', '', '(021) 99231410', 'Transport Permit for PMFL 2,160/- per Proof Gallon', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(198, 'Transport Permit (Buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023', '3 Days', '', '(021) 99231410', 'Transport Permit for Denatured Spirit 10/- per Bulk Gallon Vend Fee 6/- per Bulk Gallon', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(199, 'Transport Permit (Buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023', '3 Days', '', '(021) 99231410', 'Transport Permit for Methanol 10/- per bulk gallon Vend Fee 6/- per Bulk Gallon', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(200, 'Retail of Transport Permit (buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023 B', '1 Month', '', '(021) 99231410', 'fee challan of Rs. 60/-', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(201, 'Retail of Transport Permit (buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023 B', '1 Month', '', '(021) 99231410', 'Transport Permit for Beer Rs.02/- per bottle of Beer', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(202, 'Retail of Transport Permit (buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023 B', '1 Month', '', '(021) 99231410', 'Transport Permit for PMFL Rs.15/- per unit of PMFL', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', '');
INSERT INTO `rlcos` (`id`, `name`, `category_id`, `category_id_name`, `department_id`, `department_id_name`, `latitude`, `longitude`, `main_info_video_path`, `main_info_photo_path`, `requirment_info_photo_path`, `document_info_photo_path`, `registration_num`, `process_time`, `process_time_unit`, `contact_num`, `fees`, `renewal_period`, `renewal_period_unit`, `address`, `doc_requirements`) VALUES
(203, 'Retail of Transport Permit (buyer of the PMFL, Beer, Denatured Spirit, Methanol)', 3, 'Permit', 49, 'Excise, Taxation & Narcotics Control Department', 24.8555931, 67.0166176, '', '', '', 'document_main.png', 'ET&NC-023 B', '1 Month', '', '(021) 99231410', 'Transport Permit for Methanol Rs.10/- per bulk Gallon and Vend fee of Rs. 6 /- per bulk Gallon (both collected together)', 'Renewal Period (Months)', '', 'Tughlaq House Sindh Secretariat Karachi Pakistan', ''),
(204, 'Sindh Sales Tax on Services (SST)', 2, 'Registration', 57, 'Sindh Revenue Board', 24.8583667, 67.0103355, 'v6ll_4r3nOE', '', '', 'document_main.png', 'SRB-001', 'Same Day', '', '(021) 99217800', 'Free of cost', 'Renewal Period (Months)', '', 'Shaheen Complex, 3rd, 6th, 9th and 12th floor, Civil Lines, Karachi, Karachi City, Sindh', ''),
(206, 'Sanction Letter for Water Connection (Consumer and Bulk)', 5, 'Other', 58, 'Karachi Water & Sewerage Board', 24.9275284, 67.0792920, '', '', '', 'document_main.png', 'KWSB-001', '21 Days', '', '(021) 99230317', 'As per schedule', 'Renewal Period (Months)', '', 'Head office behind civic center old KBCA Building , Gulshan Iqbal', ''),
(207, 'License for Sub-soil Water Supply', 1, 'License', 58, 'Karachi Water & Sewerage Board', 24.9275284, 67.0792920, '', '', '', 'document_main.png', 'KWSB-002', 'Varies', '', '(021) 99230317', 'Non-refundable license fee per borehole Rs. 100,000/-', 'Renewal Period (Months)', '', 'Head office behind civic center old KBCA Building , Gulshan Iqbal', ''),
(208, 'License for Sub-soil Water Supply', 1, 'License', 58, 'Karachi Water & Sewerage Board', 24.9275284, 67.0792920, '', '', '', 'document_main.png', 'KWSB-002', 'Varies', '', '(021) 99230317', 'One-time advance security deposit per borehole Rs. 90,000/-', 'Renewal Period (Months)', '', 'Head office behind civic center old KBCA Building , Gulshan Iqbal', ''),
(209, 'License for Sub-soil Water Supply', 1, 'License', 58, 'Karachi Water & Sewerage Board', 24.9275284, 67.0792920, '', '', '', 'document_main.png', 'KWSB-002', 'Varies', '', '(021) 99230317', 'Monthly license fee per bore hole Rs. 30,000/-', 'Renewal Period (Months)', '', 'Head office behind civic center old KBCA Building , Gulshan Iqbal', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rlcos`
--
ALTER TABLE `rlcos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rlcos`
--
ALTER TABLE `rlcos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
