--
-- Host: localhost    Database: click_api
-- ------------------------------------------------------


--
-- Dumping data for table `lookup_departments`
--

INSERT INTO `lookup_departments` VALUES (1,'College Education Department',24.8607343,67.0011364,1),(2,'Labour and Human Resources Department',24.8445189,67.0244326,1),(3,'Sindh Food Authority (SFA)',24.8683205,67.0447531,1),(4,'Health Department',0.0000000,0.0000000,1),(5,'School Education and Literacy Department (Institutions from Montessori up to Class-X)',24.8553469,66.9364199,1),(6,'School Education and Literacy Department (Higher Secondary School)',24.8553469,66.9364199,1),(7,'School Education and Literacy Department (Institutions of \"O\" & \"A\" Level)',24.8553469,66.9364199,1),(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,1),(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,1),(10,'Sindh Health Care Commission (1-24 bedded Medical Centre/ Hospital (Category II-B))',24.8583639,67.0495759,1),(11,'Sindh Health Care Commission ( 25 and above bedded Hospital (Category I & II-A))',24.8583639,67.0495759,1),(12,'Sindh Health Care Commission',24.8583639,67.0495759,1),(13,'Sindh Health Care Commission (Any change in the already registered HCE)',24.8583639,67.0495759,1),(14,'Industries and Commerce Department',24.8544337,66.9871678,1),(15,'Sindh Environmental Protection Agency (SEPA)',24.8376612,67.0792909,1),(16,'Sindh Environmental Protection Agency (SEPA) (Up to 20 Million)',24.8376612,67.0792909,1),(17,'Sindh Environmental Protection Agency (SEPA) (Above 20 Million up to 100 Million)',24.8376612,67.0792909,1),(18,'Sindh Environmental Protection Agency (SEPA) (Above 100 Milliion up to 200Million)',24.8376612,67.0792909,1),(19,'Sindh Environmental Protection Agency (SEPA) (Above 200 Million up to 500 Million)',24.8376612,67.0792909,1),(20,'Sindh Environmental Protection Agency (SEPA) (Above 500 Million)',24.8376612,67.0792909,1),(21,'Sindh Environmental Protection Agency (SEPA) (Review fee for Environmental Checklist or EMP is)',24.8376612,67.0792909,1),(22,'Sindh Environmental Protection Agency (SEPA) (Security Fee)',24.8376612,67.0792909,1),(23,'Sindh Environmental Protection Agency (SEPA) (Certificate Fee)',24.8376612,67.0792909,1),(24,'Sindh Building Control Authority (SBCA) (Residential area category I. I-A. II. III. IX & X.)',0.0000000,0.0000000,1),(25,'Sindh Building Control Authority (SBCA) (Residential area category Area category IV. V. VI. VII &. VIII)',0.0000000,0.0000000,1),(26,'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area Cat I. I-A. II. III. IX & X)',0.0000000,0.0000000,1),(27,'Sindh Building Control Authority (SBCA) (Commercial Public Sale Projects Area CatI V.V. VII. VII& VIII)',0.0000000,0.0000000,1),(28,'Sindh Building Control Authority (SBCA) (Industrial Scrutiny fee for industrial plot, which is situated beyond 50km from Municipal Limit All Cat)',0.0000000,0.0000000,1),(29,'Sindh Building Control Authority (SBCA) (Amanities)',0.0000000,0.0000000,1),(30,'Sindh Building Control Authority (SBCA) (Residential area category IV. V. VI. VII &. VIII)',0.0000000,0.0000000,1),(31,'Sindh Building Control Authority (SBCA) (Cat A-l)',0.0000000,0.0000000,1),(32,'Sindh Building Control Authority (SBCA) (Cat : 2)',0.0000000,0.0000000,1),(33,'Sindh Building Control Authority (SBCA) (Cat : 3)',0.0000000,0.0000000,1),(34,'Sindh Building Control Authority (SBCA) (Cat : 4)',0.0000000,0.0000000,1),(35,'Sindh Building Control Authority (SBCA) (Cat : 5)',0.0000000,0.0000000,1),(36,'Sindh Building Control Authority (SBCA) (Cat : 6)',0.0000000,0.0000000,1),(37,'Sindh Building Control Authority (SBCA) (Cat : 7)',0.0000000,0.0000000,1),(38,'Sindh Building Control Authority (SBCA)',0.0000000,0.0000000,1),(39,'Agriculture Department',0.0000000,0.0000000,1),(40,'Sindh Industrial Trading Estate (S.I.T.E) Limited',0.0000000,0.0000000,1),(41,'Sindh Small Industries Corporation (SSIC)',0.0000000,0.0000000,1),(42,'Board of Revenue',0.0000000,0.0000000,1),(43,'District Municipal Corporation (DMC)',0.0000000,0.0000000,1),(44,'Karachi Metropolitan Corporation (KMC)',0.0000000,0.0000000,1),(45,'Karachi Metropolitan Corporation (KMC) (Commercial Building & Complex)',0.0000000,0.0000000,1),(46,'Karachi Metropolitan Corporation (KMC) (Resedential)',0.0000000,0.0000000,1),(47,'Energy Department',0.0000000,0.0000000,1),(48,'Sindh Employees Social Security Institution (SESSI)',24.8612297,67.1223026,1),(49,'Excise Taxation & Narcotics Control Department',0.0000000,0.0000000,1),(50,'Excise Taxation & Narcotics Control Department(Motorcycle)',0.0000000,0.0000000,1),(51,'Excise Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. up to 800 cc Engine Power)',0.0000000,0.0000000,1),(52,'Excise Taxation & Narcotics Control Department(M/Cars, Jeeps, etc. from 801 cc to 2,000 cc Engine Power)',0.0000000,0.0000000,1),(53,'Excise Taxation & Narcotics Control Department(Rickshaws)',0.0000000,0.0000000,1),(54,'Excise Taxation & Narcotics Control Department(Tractors)',0.0000000,0.0000000,1),(55,'Excise Taxation & Narcotics Control Department(Big Vehicle)',0.0000000,0.0000000,1),(56,'Excise Taxation & Narcotics Control Department(Small Vehicle)',0.0000000,0.0000000,1),(57,'Sindh Revenue Board',24.8583667,67.0103355,1),(58,'Karachi Water & Sewerage Board',0.0000000,0.0000000,1),(59,'Karachi Water & Sewerage Board',24.9275284,67.0792920,1);


