Newsletter Signup
Ranipet, India

Ranipet, India

  • Potentially Affected People:3,482,000
  • Type of Pollutants: Hexavalent Chromium
  • Source of Pollution:Tannery Operations

The Problem

Ranipet is a medium-sized community located about 100 miles from Chennai, the fourth largest urban area in India. A factory in Ranipet manufactures sodium chromate, chromium salts and Basic Chromium Sulfate Tanning Powder used locally in the leather tanning process. The raw materials used in the process include chromate ore, limestone soda ash, sulfuric acid and soldium chlorate.

Status of Clean-Up Activity

Site visited. This site will be pursued for remediation as it poses significant health risks to the population.


(default) 28 queries took 65 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `projects_reports`771
2DESCRIBE `site_reports`12121
3DESCRIBE `site_links`441
4DESCRIBE `gallery_images`881
5DESCRIBE `dynpages`19191
6DESCRIBE `dynpage_categories`551
7DESCRIBE `users`550
8SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC LIMIT 1111
9SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` = (18) 000
10SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` = (18) ORDER BY `ProjectsReports`.`weight` ASC 10103
11SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` = (18) ORDER BY weight ASC 17171
12SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`title` = '2013' ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC LIMIT 1110
13SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`parent_category` = 61 ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC 441
14SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC 771
15SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) 000
16SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY `ProjectsReports`.`weight` ASC 707021
17SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY weight ASC 3483483
18SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `id` = 51 ORDER BY `ProjectsReports`.`weight` ASC LIMIT 1110
19SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `id` = 2 LIMIT 1110
20SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` = (2) 000
21SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` = (2) ORDER BY `ProjectsReports`.`weight` ASC 10102
22SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` = (2) ORDER BY weight ASC 15151
23SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`title` = '2006' ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC LIMIT 1110
24SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`parent_category` = 4 ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC 550
25SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC 771
26SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) 000
27SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY `ProjectsReports`.`weight` ASC 707021
28SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY weight ASC 3483483
(projects) 14 queries took 645 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `project_summary`272730
2DESCRIBE `status`3329
3DESCRIBE `reports`5538
4DESCRIBE `countries`3329
5DESCRIBE `regions`3329
6DESCRIBE `project_images`5529
7DESCRIBE `project_pollutant`33257
8DESCRIBE `pollutants`2229
9DESCRIBE `project_transpath`3329
10DESCRIBE `project_resource`4429
11DESCRIBE `project_industry`3329
12DESCRIBE `industries`2229
13DESCRIBE `project_program`3330
14DESCRIBE `programs`2229