{
  "fields": [{"type":"int","id":"_id"},{"type":"varchar","id":"fid"},{"type":"int4","id":"date_updat"},{"type":"varchar","id":"region"},{"type":"varchar","id":"country"},{"type":"varchar","id":"prov_state"},{"type":"varchar","id":"project"},{"type":"varchar","id":"rivers"},{"type":"varchar","id":"basin"},{"type":"float4","id":"latitude"},{"type":"float4","id":"longitude"},{"type":"varchar","id":"purpose"},{"type":"varchar","id":"numb_dams"},{"type":"float4","id":"capacity"},{"type":"varchar","id":"size"},{"type":"varchar","id":"turbines"},{"type":"float4","id":"dam_height"},{"type":"varchar","id":"res_elev"},{"type":"varchar","id":"res_area_k"},{"type":"varchar","id":"res_capmil"},{"type":"varchar","id":"certainty"},{"type":"varchar","id":"status"},{"type":"varchar","id":"china_ovrs"},{"type":"int4","id":"cost_us_m"},{"type":"varchar","id":"financier"},{"type":"varchar","id":"financier2"},{"type":"varchar","id":"financier3"},{"type":"varchar","id":"developer"},{"type":"varchar","id":"builder"},{"type":"varchar","id":"sionhydrob"},{"type":"varchar","id":"contractor"},{"type":"varchar","id":"operator"},{"type":"varchar","id":"risk_insr"},{"type":"int4","id":"start_date"},{"type":"varchar","id":"complet_da"},{"type":"varchar","id":"oper_date"},{"type":"varchar","id":"hist_notes"},{"type":"varchar","id":"trans_line"},{"type":"varchar","id":"approv_not"},{"type":"varchar","id":"mdb_risk_c"},{"type":"varchar","id":"mdb_loan_t"},{"type":"varchar","id":"mdb_status"},{"type":"varchar","id":"proj_desc"},{"type":"varchar","id":"resettl_ge"},{"type":"varchar","id":"resettl_pe"},{"type":"varchar","id":"resettl_ho"},{"type":"varchar","id":"local_name"},{"type":"varchar","id":"notes"},{"type":"varchar","id":"source"},{"type":"int4","id":"cartodb_id"},{"type":"varchar","id":"created_at"},{"type":"varchar","id":"updated_at"},{"type":"geometry","id":"the_geom"}],
  "records": [
    [3,"mekongdams.322",41310,"Asia (E)","China","Yunnan Province, Jinghong City","Meng Song","Lancang River","Mekong",21.78,101.147,"","",600,"","",0,"519","","","","Cancelled","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","230","","","","1st Summit of the Mekong River Comission: http://www.mrcsummit2010.org/Speech-of-Vice-Minister-Song-Tao.pdf http://ns1.mrcmekong.org/download/Presentations/2nd-BDP-reg-stakeholder-forum/3.1.1-Lancang-River-Hydropower.pdf\nhttp://www.reuters.com/article/20",1,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000C520B0726849594048E17A14AEC73540"],
    [8,"mekongdams.326",41310,"Asia (E)","China","Yunnan Province, Jinghong City","Gan Lan Ba","Lancang River","Mekong",21.8614,100.914,"","",155,"","",0,"533","","","","Under Construction","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","58","","","Sinohydro is the builder","http://www.probeinternational.org/files/energypulse.pdf",4,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000D122DBF97E3A59403FC6DCB584DC3540"],
    [17,"mekongdams.333",41310,"Asia (E)","China","Yunnan Province, Jinghong City","Jing Hong","Lancang River","Mekong",22.0531,100.767,"","",1750,"","",0,"602","","","","Operational","",0,"GMS Power (Thai)","Yunnan Electric Power Group Corporation","Yunnan Development and Investment Company","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","Ecology: project cuts through Xishuangbanna national\nreserve. Huaneng working with Kate Lazarus and WWF to trial HSAP.","","1700","","","Other estimates for expected migrants is 2264.","http://finance.ifeng.com/roll/20090603/737536.shtml http://mekong.waterandfood.org/portal/whats-on/70-advancing-sustainable-hydropower",13,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000000C022B8716315940E86A2BF6970D3640"],
    [24,"mekongdams.340",41310,"Asia (E)","China","Yunnan Province, Simao District of Pu'er City","Nuo Zha Du","Lancang River","Mekong",22.6344,100.433,"","",5850,"","",0,"812","","","","Operational","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","Approved by NDRC in 2011.","","43000","","","","Lancong-Mekong Initiative: http://mouthtosource.org/rivers/mekong/2011/04/20/lancang-mekong-initiative/ http://www.probeinternational.org/files/energypulse.pdf http://en.wikipedia.org/wiki/Nuozhadu_Dam",20,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000C1CAA145B61B59401895D40968A23640"],
    [49,"mekongdams.407",41310,"Asia (E)","China","Yunnan Province, Deqin County","Guo Nian","Lancang River","Mekong",28.32,98.867,"","",1200,"","",0,"2080","","","","Suspended","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","2970","","","","",86,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000736891ED7CB7584052B81E85EB513C40"],
    [50,"mekongdams.359",41310,"Asia (E)","China","Yunnan Province, Jingdong Yizu County","Da Chao Shan","Lancang River","Mekong",24.0249,100.3703,"","",1350,"","",0,"899","","","","Operational","",0,"State Development and Investment Corporation","Hongta Group","Yunnan Development and Investment Company, Yunnan Electric Power Group Corporation, China Huaneng Group, CDB, ADB funded transmission line","SDIC Yunnan Dachaoshan Hydropower Co.,","","","","","",0,"NoData","","","","","","","","Ecology: downstream impacts to fisheries, erosion, far-reaching impacts for lower SE Asian countries. Social: lack of adequate compensation, problems with food security and increased incidence of disease.","","5200","","","Inconsistency in dam height between this spreadsheet and the Major Dams China Wikipedia spreadsheet (111 m). Other estimates for expected migrants is 6052","http://www.chinawater.net.cn/icold2000/st-a5-01.html http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253973998192-1279253974002813.pdf http://in.china-embassy.org/eng/szyss/jm/zhongguonongye/Water%20Conservancy/t144255.htm http://www.probeintern",43,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000005D6DC5FEB21759409FABADD85F063840"],
    [57,"mekongdams.366",41310,"Asia (E)","China","Yunnan Province, Jingdong Yizu County","Man Wan","Lancang River","Mekong",24.6222,100.4489,"","",1550,"","",0,"994","","","","Operational","",0,"Department of Water Resources, Yunnan Province","","","Yunnan Electric Power Industry Bureau","","","","","",0,"NoData","","","","","","","","Ecology: downstream impacts to fisheries, erosion, far-reaching impacts for lower SE Asian countries. Social: lack of adequate compensation, problems with food security and increased incidence of disease.","","3042","","","","http://www.probeinternational.org/files/energypulse.pdf                                             http://in.china-embassy.org/eng/szyss/jm/zhongguonongye/Water%20Conservancy/t144255.htm",50,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E610000029CB10C7BA1C59403A92CB7F489F3840"],
    [59,"mekongdams.369",41310,"Asia (E)","China","Yunnan Province, Nanjian Yi Autonomous County","Xiao Wan","Lancang River","Mekong",24.705,100.0914,"","",4200,"Large","",292,"1240","","","","Operational","",0,"Yunnan Electric Power Group Corporation","Yunnan Development andInvestment Company","Yunnan Hongta Industrial Company Ltd.","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","In an article dated May 28, 2009, International Probe cited a UN Report from May 21 of that year that stated that Xiaowan Dam alone is capable of reducing the water volume and running speed, lowering water quality and biodiversity of areas downstream on","","28748","","","Other estimates for expected migrants is 32737","http://www.probeinternational.org/mekong-utility-watch/un-says-china-dams-threaten-water-supplies-mekong-delta-farmers http://www.probeinternational.org/files/energypulse.pdf",53,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000AEB6627FD905594014AE47E17AB43840"],
    [67,"mekongdams.377",41310,"Asia (E)","China","Yunnan Province, Yunlong County","Gong Guo Qiao","Lancang River","Mekong",25.5502,99.3445,"","",900,"","",0,"1307","","","","Operational","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","Gongguoqiao is unliekly to be a sustainable project, has poor additionality and feasibility arguments in the PDD, and does not meet the criteria of the world comisssion on dams, with which projects seeking approval by the swiss government (a project part","","4596","","","This dam is part of the UN's Clean Development Mechanism (CDM) Program. Sinohydro is the builder.","http://www.probeinternational.org/mekong-utility-watch/un-says-china-dams-threaten-water-supplies-mekong-delta-farmers UN CDM Reports: http://cdm.unfccc.int/Projects/Validation/DB/YHK3P49SQB7TBBT9H4W13Q49YZLKY1/view.html",61,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000355EBA490CD658405B423EE8D98C3940"],
    [68,"mekongdams.386",41310,"Asia (E)","China","Yunnan Province, Yunlong County","Miao Wei","Lancang River","Mekong",25.8546,99.1739,"","",1400,"","",0,"1408","","","","Under Construction","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","11036","","","Sinohydro is the builder","http://probeinternational.org/mekong-utility-watch/yunnan-prefecture-promotes-lancang-hydro-development http://en.wikipedia.org/wiki/List_of_major_power_stations_in_Yunnan",65,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000009031772D21CB58405F29CB10C7DA3940"],
    [80,"mekongdams.398",41310,"Asia (E)","China","Yunnan Province, Lanping Bai and Pumi Autonomous County","Huang Deng","Lancang River","Mekong",26.5468,99.1037,"","",1900,"","",0,"1619","","","","Under Construction","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","4415","","","Sinohydro is the builder","http://www.ecn.nl/docs/library/report/2003/c03027.pdf http://blogs.ei.columbia.edu/2011/05/19/the-push-to-dam-china%E2%80%99s-rivers/ http://zh.wikipedia.org/wiki/File:Huangdeng_Hydropower_Station_under_construction.jpg",77,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E610000018265305A3C65840EB73B515FB8B3A40"],
    [84,"mekongdams.402",41310,"Asia (E)","China","Yunnan Province, Weixi Lisu Autonomous County","Tuo Ba","Lancang River","Mekong",27.193,99.104,"","",1250,"","",0,"1735","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","5951","","","This dam was part of a two part project that includes the construction of the Hongjiang hydropower plant. Sinohydro is the builder","Hydrochina Website Tuoba Page: http://en.msdi.cn/showArticle.aspx?id=110 http://www.bentley.com/en-US/Community/BE+Awards/power+generation.htm",81,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000002DB29DEFA7C65840C520B07268313B40"],
    [85,"mekongdams.403",41310,"Asia (E)","China","Yunnan Province, Weixi Lisu Autonomous County","Li Di","Lancang River","Mekong",27.5024,99.0201,"","",420,"","",0,"1819.500000","","","","Under Construction","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","575","","","Sinohydro is the builder","http://en.wikipedia.org/wiki/List_of_major_power_stations_in_Yunnan http://groups.google.com/group/Lancang-Mekong/browse_thread/thread/c6eb324999415fca http://groups.google.com/group/lancang-mekong/msg/967b28891da99d64",82,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E610000093A9825149C15840AA8251499D803B40"],
    [91,"mekongdams.410",41310,"Asia (E)","China","Yunnan Province, Deqin County","Gu Shui","Lancang River","Mekong",28.6069,98.7464,"","",2600,"","",0,"2340","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","Started pre-feasiblity studies","","3776","","","","http://eng.greensos.cn/ShowArticle.aspx?articleId=981http://www.tibet3.com/news/content/2011-01/18/content_439558.htm",89,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000006F8104C5AF584041F163CC5D9B3C40"],
    [109,"mekongdams.428",41310,"Asia (E)","China","Tibet, Kham","Lin Chang","Lancang River","Mekong",31.1804,97.1852,"","",72,"","",0,"3257","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","69","","","","",106,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E610000007CE1951DA4B5840CA32C4B12E2E3F40"],
    [110,"mekongdams.429",41310,"Asia (E)","China","Tibet, Kham","Ru Yi","Lancang River","Mekong",31.221,97.175,"","",114,"","",0,"3295","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","146","","","","",107,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E610000033333333334B58407F6ABC7493383F40"],
    [113,"mekongdams.432",41310,"Asia (E)","China","Tibet, Kham","Xiang Da","Lancang River","Mekong",31.4524,97.183,"","",66,"","",0,"3359","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","46","","","","",110,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E6100000C1CAA145B64B5840DDB5847CD0733F40"],
    [114,"mekongdams.433",41310,"Asia (E)","China","Tibet, Kham","Guo Duo","Lancang River","Mekong",31.5233,97.1946,"","",150,"","",0,"3412","","","","Under Construction","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","658","","","","",111,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000004DF38E53744C58402EFF21FDF6853F40"],
    [116,"mekongdams.435",41310,"Asia (E)","China","Tibet, Kham","Dong Zhong","Lancang River","Mekong",31.876,96.99,"","",108,"","",0,"3503","","","","Planned","",0,"China Huaneng Group","","","China Huaneng Lancang River Hydropower Company","","","","","",0,"NoData","","","","","","","","","","717","","","","",113,"2015-07-13T18:12:22Z","2015-07-13T18:12:22Z","0101000020E61000008FC2F5285C3F5840C74B378941E03F40"]
]}