('Fagal-Obock-Tadjoura-Sarrey',3968,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2798,0,'130-118 ka (Th/U)',12,43,1650642,4759798,'Djibouti','Africa',NULL,'',12.0667,43.4,'WAHR','89257',12.0519825718,43.3825473059,12.0561875727,43.3875337513,12.0667,43.4),('Kahuku Point, Oahu, Hawaii',3969,'Waimanalo','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2799,0,'121-113 ka, last interglacial',21,-158,2938357,-16801658,'United States','North America',101,'',21.6167,-158.0667,'WAHR','89290',21.6019037632,-158.02957316,21.6019037632,-158.02957316,21.6167,-158.0667),('Kaena Point, Oahu, Hawaii',3970,'Waimanalo','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2799,0,'127-115 ka, last interglacial',21,-158,2931686,-16826516,'United States','North America',101,'',21.5667,-158.2667,'WAHR','89292',21.5519124477,-158.229555245,21.5519124477,-158.229555245,21.5667,-158.2667),('Oahu, Mokapu and Hahaione, Hawaii',3971,'Waimanalo','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2799,0,'',21,-157,2916112,-16776379,'United States','North America',101,'',21.45,-157.7167,'WAHR','89294',21.4351889993,-157.679616954,21.4351889993,-157.679616954,21.45,-157.7167),('Haleakala Ridge, offshore Maui, Hawaii',3972,'','Neogene','Pleistocene','middle Pleistocene',0.10,0.80,33,'Recent',0,0,3,0,'Outcropping reef ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,NULL,'','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2800,0,'dredge 32 (1555-1705 m depth), reef terrace 1 (shallowest and youngest terrace), 750 ka',20,-155,2815911,-16611895,'United States','North America',101,'',20.7,-155.6833,'WAHR','89410',20.5658677992,-155.351908276,20.5658677992,-155.351908276,20.7,-155.6833),('Offshore Lanai, Hawaii',3973,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,1,'Temperate',3,'Ramp or Slope','3a','Upper slope or inner ramp','2','Below fair weather wave base','2','Algae','2','Algae','29','Coralline algae only (some corals)','1','Red algae','0','10','90',0,'no',0,'no',NULL,'',NULL,'3','Binder guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2801,0,'algal-dominated mounds at fore-reef slope during glacial',20,-156,2811457,-16722652,'United States','North America',101,'',20.6667,-156.7,'WAHR','89415',20.6518492488,-156.66305341,20.6518492488,-156.66305341,20.6667,-156.7),('Lifou, Loyalty Islands, Melanesia',3974,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,NULL,'','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2802,0,'terrace at 3.5 m, exact locations on Lifou Island unknown',-20,167,-2840418,17829130,'New Caledonia','Pacific',NULL,'',-20.8833,167.2167,'WAHR','89423',-20.9109757483,167.207088549,-20.9030683843,167.209833663,-20.9099383907,167.214631361),('Ouvea, Loyalty Islands, Melanesia',3975,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,NULL,'','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2802,0,'terrace at 7.5 m, 117 ka (Th/U)',-20,167,-2840418,17829130,'New Caledonia','Pacific',NULL,'',-20.8833,167.2167,'WAHR','89422',-20.9109757483,167.207088549,-20.9030683843,167.209833663,-20.9099383907,167.214631361),('Beautemps-Beaupre, Loyalty Islands, Melanesia',3976,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,NULL,'','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2802,0,'terrace at 2m, small island Beautemps-Beaupre WNW of Ouvea, Loyalty Island\n>200 ka (Th/U)',-20,166,-2778012,17747306,'New Caledonia','Pacific',NULL,'',-20.4167,166.1333,'WAHR','89421',-20.4447779969,166.123291943,-20.4367556876,166.126150401,-20.443767213,166.130829007),('Amedee 4 core, off Noumea',3977,'','Neogene','Pleistocene','middle Pleistocene',0.10,0.80,33,'Recent',0,0,3,1,'Seismic data available ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,'4','More than 1000 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','60','40',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2803,0,'coral framestone interbedded with layers of grainstones/packstones rich in molluscs, echinids, foraminifers\nunit 7: 46-52 m, 410-250 ka, MIS 11?\nunit 8: 40-46 m, ~278 ka, MIS 9?',-22,166,-3053840,17627510,'New Caledonia','Pacific',NULL,'',-22.4833,166.4667,'WAHR','89432',-22.6650061148,166.407957755,-22.663009374,166.408600906,-22.7257209956,166.45398522),('Amedee 4 core, off Noumea',3978,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,1,'Seismic data available ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,'4','More than 1000 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','60','40',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2803,0,'Youngest reef level OIS 5',-22,166,-3053840,17627510,'New Caledonia','Pacific',NULL,'',-22.4833,166.4667,'WAHR','89435',-22.5112551225,166.457634417,-22.5032679563,166.460223535,-22.5102361012,166.46522795),('Ile des Pins',3979,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2804,0,'Ref. 2803 provides middle Pleistocene ages as well (unreliable).',-22,167,-3062717,17722808,'New Caledonia','Pacific',NULL,'',-22.55,167.4167,'WAHR','89436',-22.5776002742,167.407854626,-22.5697145041,167.410380811,-22.5765580339,167.415442963),('Urelapa Island',3980,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,1,'Seismic data available ',1,'True reef','2','10 to 100 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae',NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species',NULL,'1','Constructor guild','1','Present','1','Present','2','Medium zonation',NULL,'',NULL,'',NULL,'','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2805,0,'glacial reef\nbranching coral facies of Acropora, various small coral buildups including favids and encrusting coralline algae\n\'keep-up\' reef growth mode; medium- to high-energy conditions close to the sea surface (reef crest or upper fore-reef slope)',-15,167,-2132148,18145155,'Vanuatu','Oceania',827,'',-15.6167,167.0167,'WAHR','89441',-15.6395447837,167.04578688,-15.6330171165,167.037474348,-15.631540088,167.052424877),('Salt Rocks, Little Cayman, Cayman Islands',3981,'Ironshore','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','80','20',0,'no',0,'no','2','6 to 24 reef building species','8','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2806,0,'',19,-80,2675313,-8582622,'United Kingdom','Europe',331,'',19.65,-80.1,'WAHR','89553',19.6459611936,-80.0881648204,19.6471156529,-80.0915461141,19.6559722345,-80.0904410033),('Tiarei outer ridge, Tahiti',3982,'','Neogene','Pleistocene','Pleistocene',0.00,2.60,33,'Recent',0,1,2,1,'Seismic data available ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','60','40',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2807,0,'coralgal frameworks associated with coral rudstone-floatstone and skeletal limestone (unit IIa); sandy packstones/grainstones and volcaniclastic siltstones and sandstones with coral fragments (units IIb-d)',-17,-149,-2381862,-16135260,'French Polynesia','Pacific',983,'',-17.4667,-149.4,'WAHR','89554',-17.8576373771,-148.461000636,-17.8576373771,-148.461000636,-17.4667,-149.4),('Maraa western transect, Tahiti',3983,'','Neogene','Pleistocene','Pleistocene',0.00,2.60,33,'Recent',0,1,2,1,'Seismic data available ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2807,0,'coralgal frameworks associated with rudstone-floatstones; floatstone-rudstone rich in rhodoliths and coral fragments; sandy skeletal grainstone-packstones',-17,-149,-2422267,-16136661,'French Polynesia','Pacific',983,'',-17.7667,-149.5667,'WAHR','89555',-18.1576319592,-148.628077247,-18.1576319592,-148.628077247,-17.7667,-149.5667),('Faaa, Tahiti',3984,'','Neogene','Pleistocene','Pleistocene',0.00,2.60,33,'Recent',0,1,2,1,'Seismic data available ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','60','40',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2807,0,'',-17,-149,-2393084,-16154081,'French Polynesia','Pacific',983,'',-17.55,-149.6167,'WAHR','89556',-17.9409296879,-148.678176387,-17.9409296879,-148.678176387,-17.55,-149.6167),('Mitiaro',3985,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2808,0,'A lower reef unit is also present (middle Pleistocene?)',-19,-157,-2697658,-16888248,'Cook Islands','Pacific',NULL,'',-19.8167,-157.7167,'WAHR','89568',-19.8315109637,-157.681403598,-19.8315109637,-157.681403598,-19.8167,-157.7167),('Atiu',3986,'','Neogene','Pleistocene','middle Pleistocene',0.10,0.80,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2808,0,'',-19,-158,-2719982,-16920053,'Cook Islands','Pacific',NULL,'',-19.9833,-158.1167,'WAHR','89569',-20.1166221859,-157.799374326,-20.1166221859,-157.799374326,-19.9833,-158.1167),('Mauke',3987,'','Neogene','Pleistocene','middle/late Pleistocene',0.00,0.80,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2808,0,'2 reefal units:\nlower unit: 243-204 ka (MIS 7); upper unit: 136-119 ka (MIS 5e)',-20,-157,-2742309,-16825149,'Cook Islands','Pacific',NULL,'',-20.15,-157.3333,'WAHR','89570',-20.2687445089,-157.050707322,-20.2687445089,-157.050707322,-20.15,-157.3333),('Kish Island, Persian Gulf',3988,'','Neogene','Pleistocene','middle/late Pleistocene',0.00,0.80,0,'Vendian',605,0,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no','3','25 or more reef building species','33','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2809,0,'252-213 (MIS 7) and 148-100 ka (MIS 5) (ESR and Th/U dated)',26,53,3589723,5601528,'Iran','Asia',505,'',26.5333,53.9667,'WAHR','89571',26.4363796107,53.8836729964,26.4351524451,53.8826221724,26.3893489451,53.8990147384),('Qeshm Island, Persian Gulf',3989,'','Quaternary','Pleistocene','late Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2809,0,'138-115 ka (MIS 5) (ESR and Th/U dated)',26,56,3648846,5820744,'Iran','Asia',505,'',26.9833,56.2167,'WAHR','89572',26.965678106,56.2017530153,26.9707131054,56.2060234912,26.9648027009,56.2080097875),('Punta San Telmo, Baja California',3990,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','80','20',0,'no',0,'no','1','Less than 6 reef building species','5','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2810,0,'reef facies (mainly Porites) above conglomerates with molluscs and corals, sandy near-reef facies',25,-110,3427240,-11591153,'Mexico','North America',105,'',25.3,-110.95,'WAHR','89597',25.272105769,-110.891334541,25.2800761992,-110.908095072,25.2940794166,-110.921174864),('Santa Maria Island, Azores',3991,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,1,'Temperate',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','2','Algae','2','Algae','29','Coralline algae only (some corals)','1','Red algae','0','0','100',0,'no',0,'no','1','Less than 6 reef building species','4','3','Binder guild','1','Present','1','Present','1','Low zonation','1','Low zonation',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2811,0,'Red algal biostrome. MIS 5.5\nshallow depths, probably less than 10 m',36,-25,4934563,-2428135,'Portugal','Europe',304,'',36.9667,-25.1,'WAHR','89618',36.9587692529,-25.109651565,36.9610353764,-25.1068939698,36.9667,-25.1),('Loma de San Jua, Michoacan',3992,'','Cretaceous','Lower Cretaceous','lower Aptian',120.00,125.00,23,'late Valanginian - early Aptian',126,122,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick','9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','14','1','Constructor guild','1','Present','1','Present','2','Medium zonation','1','Low zonation',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2812,0,'coral boundstone bed, at least 9 m thick, above a rudist (Amphitriscoelus) rudstone bed (see reef 2489',18,-100,390908,-6324430,'Mexico','North America',105,'',18.5167,-100.9333,'WAHR','89846',15.1511860858,-52.7185307264,14.1204907484,-51.4158107761,16.4175534375,-57.338537946),('Chumbitaro, Guerrero',3993,'Mal Paso','Cretaceous','Middle Cretaceous','Albian/Cenomanian',93.90,113.00,24,'late Aptian - middle Cenomanian',107,99,2,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick','19','2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','5','Rudists','50','Corals - stromatoporoids (chaetetids) - algae (stromatolites) - rudists - (spicular sponges)',NULL,NULL,'20','70','10',0,'no',0,'no','2','6 to 24 reef building species','16','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2812,0,'Late Albian - Early Cenomanian\nThe coral reef (MP 13) is about 19 m thick and\nprimarily composed of medium- to large-sized massive corals and sparsely distributed, medium- to large-sized phaceloid and ramose corals. Non-coral taxa found within this bed\ninclude abundant Pecten roemeri Hill, 1889, Radiolites cf. R. costata Scott, 1990, large nerineids, Mexicaprina alata Filkorn, 2002a, and massive colonies of the stromatoporoid\nActinostromaria sp.',18,-100,1689167,-6707540,'Mexico','North America',105,'',18.4833,-100.7,'WAHR','89857',17.5584676508,-62.3589936865,17.5584676508,-62.3589936865,19.4019962858,-67.2381072155),('Godogani',3994,'','Cretaceous','Lower Cretaceous','Hauterivian',129.40,132.90,23,'late Valanginian - early Aptian',126,133,2,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,NULL,NULL,NULL,'2','10 - 100 m',NULL,'70','1971',0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','4','Stromatoporoids','10','Scleractinian corals - (chaetetids, stromatoporoids-hydrozoans-spongiomorphids) - algae - microbes',NULL,NULL,'10','90','0',0,'no',0,'no','2','6 to 24 reef building species','7','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2813,1184,'coral-stromatoporoid bioherm',42,42,4953869,3565151,'Georgia','Europe',301,'',42.2667,42.7667,'WAHR','89971',34.3444576915,51.8714799153,34.3444576915,51.8714799153,36.2360369233,52.2681665564),('Mukhura, Dzirul Massif',3995,'','Cretaceous','Lower Cretaceous','Hauterivian',129.40,132.90,23,'late Valanginian - early Aptian',126,133,2,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,NULL,NULL,NULL,'2','10 - 100 m',NULL,'70','1971',0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'5','95','0',0,'no',0,'no','3','25 or more reef building species','22','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2813,1184,'',42,43,4961422,3602013,'Georgia','Europe',301,'',42.3167,43.1,'WAHR','89974',34.4868424879,52.1228847079,34.4868424879,52.1228847079,36.3576497255,52.541408793),('Modinakhe',3996,'','Cretaceous','Lower Cretaceous','Hauterivian',129.40,132.90,23,'late Valanginian - early Aptian',126,133,2,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,NULL,NULL,NULL,'2','10 - 100 m',NULL,'70','1971',0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)',NULL,NULL,'10','90','0',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2813,1184,'',42,42,4982808,3490862,'Georgia','Europe',301,'',42.5333,42.1833,'WAHR','89978',34.4220527053,51.2648308047,34.4220527053,51.2648308047,36.3616308676,51.6591661502),('Bolshoy Zelenchuk River, Ispravnaya, Caucasus',3997,'','Jurassic','Upper Jurassic','Oxfordian-Kimmeridgian',152.10,163.50,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick','12',NULL,NULL,NULL,'2','10 - 100 m',NULL,'50',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species','42','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2814,502,'',44,41,5039330,3861989,'Russia','Asia',624,'',44.0667,41.6,'WAHR','89995',32.7868049293,50.8425151613,32.7868049293,50.8425151613,37.0406308041,54.1606623021),('Zhinvali-Aranisi + Kokh Mountain, Caucasus',3998,'','Jurassic','Upper Jurassic','upper Oxfordian',157.30,163.50,21,'late Bathonian - early Tithonian',151,156,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','17','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2814,0,'Kokh Mountain and Dzhvarisubani are unresolved late Oxfordian-Kimmeridgian.\nZhinvali-Aranisi is late Oxfordian',42,44,5026781,4124857,'Georgia','Europe',301,'',42.1,44.7833,'WAHR','90000',31.8839186516,54.9933702161,31.8839186516,54.9933702161,36.5387934193,58.3506447878),('Alkhashenda, Ribisa, Valkhokh',3999,'','Jurassic','Upper Jurassic','Oxfordian/Kimmeridgian',157.30,157.30,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','3','25 or more reef building species','33','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2814,0,'unresolved late Oxfordian-Kimmeridgian.',42,43,5014225,4075400,'Georgia','Europe',301,'',42.45,43.7833,'WAHR','90002',32.1566730478,53.2846437782,32.1566730478,53.2846437782,36.0448633528,56.6396335771),('Korta, Racha Region',4000,'','Jurassic','Upper Jurassic','Oxfordian/Kimmeridgian',157.30,157.30,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3999',0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','3','25 or more reef building species','50','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2814,0,'unresolved late Oxfordian-Kimmeridgian.\nTaxonomic data from local area, probably oversplitted',42,43,5026781,4028706,'Georgia','Europe',301,'',42.5333,43.4167,'WAHR','90017',32.1032168846,52.9566397621,32.1032168846,52.9566397621,36.0210442202,56.2910889368),('Belaya-Pshekha Rivers, Caucasus',4001,'','Jurassic','Upper Jurassic','Oxfordian-Kimmeridgian',152.10,163.50,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2017',0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','1','Corals','1','Corals','2','Corals only',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','18',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2814,0,'',44,39,5145741,3647919,'Russia','Asia',624,'',44.2167,39.85,'WAHR','90020',32.3352995986,49.4407746321,32.3352995986,49.4407746321,36.7088747394,52.6349825775),('Ferques, Boulonnais',4002,'Ferques','Devonian','Upper Devonian','lower Frasnian',372.20,382.70,10,'Givetian - early Famennian',375,382,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,NULL,NULL,NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea',NULL,'','4','Stromatoporoids','1','Corals','9','Stromatoporoids - rugose/tabulate corals - microbes - (bryozoans) - (algae) - (echinoderms)',NULL,NULL,'45','0','55',0,'no',0,'no','3','25 or more reef building species','26','3','Binder guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2815,0,'Bois Member of the Freques formation. Largely biostromal\nasymmetricus zone',50,1,-2735613,304838,'France','Europe',331,'',50.8333,1.7667,'WAHR','38689',-22.7772982276,-13.9876029707,-22.7772982276,-13.9876029707,-4.0871881035,-69.2395317051),('Penaguila, Valencia',4003,'','Paleogene','Eocene','Upper Eocene',33.90,38.00,29,'Priabonian - Rupelian',33,35,2,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick','15','2','10 - 100 m wide',NULL,'3','More than 100 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present','2','Medium zonation','3','Pronounced zonation',NULL,'',NULL,'','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2817,0,'Coral reef developed in HST on top of deep shelf limestone sequence. \r\nBuried coral reef also inferred for between Ibi and Carrasqueta.\r\n\r\ncoralgal buildups interfingering with miliolid-rotaliid limestones. The top shows a thickening-up bedding pattern and consists of packstones and grainstones with exclusively rotaliids and some coral debris. The unit of pebbly rotaliid limestones with coralgal reefs is considered to represent a highstand prograding barrier with fore-reef, reef and interreef subenvironments.',38,0,4913552,-300298,'Spain','Europe',304,'',38.6833,-0.35,'',NULL,35.61908233,-4.37315732004,35.61908233,-4.37315732004,37.4332017848,-0.566951404357),('Normandville II, Alberta',4004,'Pekisko','Carboniferous','Lower Carboniferous','middle Tournasian',346.70,358.90,11,'late Famennian - early Visean',351,357,3,1,'Seismic data available ',3,'Mud mound or bank','1','Less than 10 m thick','10',NULL,NULL,NULL,'3','More than 100 m',NULL,'50',NULL,0,'Tropical or unknown',4,'Basin','4a','Shallow basin','2','Below fair weather wave base','3','Microbes','7','Bryozoans','17','Bryozoans - crinoids - sponge spicules - (brachiopods) - (microbes) - (Tubiphytes)',NULL,NULL,'70','0','30',0,'no',0,'no',NULL,'',NULL,'4','Microbial precipitation',NULL,'',NULL,'','1','Low zonation','1','Low zonation','3','More than 60% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',2,'Actual reservoir',2822,0,'Described as Waulsortian-type mud mounds (bryozoan-crinoidal).\nTwo facies in core: 1. fenestrate bryozoan facies with minor mud. 2. carbonate mud with minor bryozoans.',55,-117,795136,-4300755,'Canada','North America',121,'',55.8333,-117.4167,'FALSCH','0',-7.41693499972,-46.2301939611,-7.41693499972,-46.2301939611,14.1716121316,-95.8229874906),('Mulu Quarry, Gunung Mulu, Sarawak',4005,'Temburong','Neogene','Miocene','early Aquitanian',22.00,23.00,30,'Chattian - Aquitanian',22,22,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','60','40',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'','1','Less than 30% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2823,0,'Reefal olistoliths in deepwater Temburong shales developed during backstepping of the platform',4,114,781444,13097662,'Malaysia','Asia',614,'',4.0333,114.9167,'','',4.28138087538,112.168692934,4.53258739722,112.485441513,-0.0212238767739,116.489278053),('Tazhong oil field, Tarim',4006,'Lianglitag','Ordovician','Upper Ordovician','Sandbian',453.00,458.40,5,'Darriwilian - Ashgillian',452,456,1,1,'Seismic data available ',2,'Reef mound','2','10 to 100 m thick','20','2','10 - 100 m wide',NULL,'3','More than 100 m',NULL,'20',NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','1','Corals','4','Stromatoporoids','9','Stromatoporoids - rugose/tabulate corals - microbes - (bryozoans) - (algae) - (echinoderms)','1','Red algae','50','30','20',0,'no',0,'no','2','6 to 24 reef building species',NULL,'2','Baffler guild',NULL,'',NULL,'','2','Medium zonation','2','Medium zonation','2','30-60% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',2,'Actual reservoir',2824,0,'age indicated as early late Ordovician.\nCorals, stromatoporoids, solenoporaceans and calcimicrobes as reef builders.\nLargest oil field in China. oil in reef-flat and grainstones.\nReef facies in well Tazhong-30: Reef mounds are coral framestones coral bafflestones in 10-20 m thick horizons. Mud mounds are up to 30 m thick.',39,84,342914,12502173,'China','Asia',602,'',39.25,84.6667,'','',-4.61406847865,60.6266019359,-4.61406847865,60.6266019359,-4.61406847865,60.6266019359),('Goznitsa, Lovech',4007,'Smochan','Cretaceous','Lower Cretaceous','upper Barremian',125.00,129.40,23,'late Valanginian - early Aptian',126,126,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'2','10 - 100 m',NULL,'5',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','6','1','Constructor guild','1','Present',NULL,'','1','Low zonation','2','Medium zonation','2','30-60% micrite','1','Less than 10% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2826,2827,'Small biostromes and patch reefs in lagoonal marls, siltstones and sandstones.\n\nThey are built of colonial corals, faceloid and dendroid, adapted to a soft substratum (clayey bottom). They are preserved in the rock in situ, the dimensions of the colonies varying from several centimeters to several tens of centimeters.\nMassive colonies dominate the central parts, and dendroid corals, the peripheries.',43,24,2635077,2247345,'Bulgaria','Europe',319,'',43.15,24.6833,'WAHR','91679',31.5600172617,37.0119886761,31.5600172617,37.0119886761,34.4244036631,35.9389966621),('Veliko Tarnovo',4008,'Emen','Cretaceous','Lower Cretaceous','lower Barremian',125.00,129.40,23,'late Valanginian - early Aptian',126,128,3,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2828,0,'Corals described from underlying marls, siltstones and sandstones (Balgarene Formation).\nReefs in Emen Fm.',43,25,2614948,2313019,'Bulgaria','Europe',319,'',43.0667,25.6167,'WAHR','85417',31.6909762457,37.803426605,31.6909762457,37.803426605,34.5102983309,36.7651445338),('Mare Island',4009,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'4','More than 1000 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no','3','25 or more reef building species','41','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'','1','Less than 30% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2833,0,'',-21,167,-2927229,17851474,'New Caledonia','Pacific',NULL,'',-21.5333,167.8833,'WAHR','90042',-21.5607232913,167.874096208,-21.552888075,167.87672482,-21.559669763,167.88165242),('Mare Island',4010,'','Neogene','Pleistocene','Pleistocene',0.00,2.60,33,'Recent',0,0,2,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'4','More than 1000 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae','0','70','30',0,'no',0,'no','3','25 or more reef building species','41','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'','1','Less than 30% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2833,0,'',-21,167,-2916112,17868441,'New Caledonia','Pacific',NULL,'',-21.45,167.9833,'WAHR','90061',-21.9566058877,167.81435889,-21.9585618025,167.813713446,-22.1345246522,167.944702169),('Castrojimeno',4011,'Hortezuelos','Cretaceous','Upper Cretaceous','upper Coniacian',86.30,89.80,25,'late Cenomanian - early Campanian',91,86,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick','8','2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','5','Rudists','5','Rudists','72','Rudists only (sometimes with microbial encrustations)',NULL,NULL,'60','40','0',0,'no',0,'no','1','Less than 6 reef building species','5','1','Constructor guild','1','Present','1','Present','2','Medium zonation','1','Low zonation','2','30-60% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2834,0,'segment reefs, spaced and close cluster reefs and close cluster/frame reefs with oligospecific or monospecific rudist assemblages, and bioclastic beds\n5 rudist species (Radiolitidae and Hippuritidae).',41,-3,3919205,-20463,'Spain','Europe',304,'',41.4,-3.8333,'WAHR','91495',34.2472816533,0.893935232648,34.2472816533,0.893935232648,34.4024203587,-1.01984236473),('Fucheng, Shaanxi',4012,'Xiannudong','Cambrian','Lower Cambrian','Atdabanian/Botomian',514.00,521.00,1,'Nemakit/Daldynian - Toyonian',520,519,2,0,'Outcropping reef ',2,'Reef mound',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','3','Microbes','10','Archaeocyaths','7','Archaeocyaths - microbes',NULL,NULL,'0','0','100',0,'no',0,'no','2','6 to 24 reef building species','7','3','Binder guild',NULL,'',NULL,'','2','Medium zonation','1','Low zonation','3','More than 60% micrite','2','10-25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2835,0,'Upper Atdabanian-Lower Botomian\nsix microbial reef complexes; 1.1-12.5 m thick, laterally extensive; irregular archaeocyaths comprise max. 3.7% of the reefs and were not involved in reef construction.\nMostly in inter-reef settings.',32,107,3056063,15903806,'China','Asia',602,'',32.4667,107.2333,'WAHR','91498',-6.6123751032,80.6738618772,-4.532383383,78.1221076725,-4.532383383,78.1221076725),('Novo Selo',4013,'Emen','Cretaceous','Lower Cretaceous','lower Barremian',125.00,129.40,23,'late Valanginian - early Aptian',126,128,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,'2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,'4008',0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2828,2826,'reefal limestones (Emen Formation) separated by lagoonal marls, siltstones and sandstones (Balgarene Formation)',43,25,2621659,2301852,'Bulgaria','Europe',319,'',43.0833,25.3667,'WAHR','91676',31.6501847942,37.5933722296,31.6501847942,37.5933722296,34.4815354288,36.5454097266),('Derbent, SW Gissar Range',4014,'','Jurassic','Upper Jurassic','Oxfordian/Kimmeridgian',157.30,157.30,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2','Shelf/platform margin','1','Above fair weather wave base','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2836,0,'late Oxfordian - lower Kimmeridgian',38,67,5400412,6103758,'Uzbekistan','Asia',301,'',38.2,67.0167,'WAHR','91788',37.2975300856,74.5252617879,37.2975300856,74.5252617879,39.0224968663,79.2837785526),('Kugitang',4015,'','Jurassic','Middle Jurassic','Oxfordian/Kimmeridgian',157.30,157.30,21,'late Bathonian - early Tithonian',151,155,2,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,NULL,NULL,NULL,'4','More than 1000 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1','Shelf/platform interior','1','Above fair weather wave base',NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'no',0,'no',NULL,'',NULL,NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',1974,2836,'',37,66,5427573,6149023,'Uzbekistan','Asia',301,'',37.9667,66.7333,'WAHR','91829',36.9827203223,74.4358261655,36.9827203223,74.4358261655,38.7202098273,79.1384013904),('Flank of theSchulterkofel, Carnic Alps, Ringmauer area',4068,'Grenzland, Upper Pseudoschwagerina Limestone','Carboniferous','Upper Carboniferous','upper Gzhelian',298.90,303.70,14,'Gzhelian - Asselian',290,NULL,1,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','20','2','10 - 100 m wide','30',NULL,NULL,'100',NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','1','Shelf/platform interior','3','Below storm wave base','2','Algae','3','Microbes','49','Algae - microbes - stromatoporoids - (corals) - (bryozoans)','2','Green algae',NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','7',NULL,'','1','Present','1','Present',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','1','Present',0,'No or unknown reservoir potentia',2915,NULL,NULL,NULL,NULL,NULL,NULL,'Austria','Europe',NULL,NULL,46.35,13.1,NULL,NULL,-11.5635825947,28.7302399619,-11.5635825947,28.7302399619,-7.99909148279,4.01161802865),('Son Sastre, Mallorca',4016,'Son Sastre','Paleogene','Oligocene','lower Rupelian',30.00,33.90,29,'Priabonian - Rupelian',33,32,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','14','1','Constructor guild','1','Present','1','Present',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite','2','Medium production of reefal debris','0','',0,'No or unknown reservoir potential',2837,0,'coral patches and small patch-reefs probably in a lagoonal environment\nSon Satre sandstone and Lutites Fm.',39,2,5264111,-75656,'Spain','Europe',304,'',39.5439,2.9675,'WAHR','92080',37.9143713444,-2.54599445497,37.8641630229,-2.54331907699,38.9204679651,2.10218399466),('Guppy Hills, Canning Basin',4017,'Pillara','Devonian','Upper Devonian','lower Frasnian',372.20,382.70,10,'Givetian - early Famennian',375,382,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea','2','Below fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)',NULL,NULL,'100','0','0',0,'no',0,'no','2','6 to 24 reef building species','8','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite',NULL,'','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2838,0,'corals as a mound, 2.5 m wide, in deeper subtidal back-reef environment\nOtherwise only biostromes are devloped',-18,126,-2802536,12991060,'Australia','Oceania',801,'',-18.2167,126.1333,'WAHR','92875',-24.0315856567,114.246213665,-24.0315856567,114.246213665,-31.1040086463,156.734486758),('Napier Range, Canning Basin',4018,'Pillara','Devonian','Upper Devonian','late Frasnian',372.20,382.70,10,'Givetian - early Famennian',375,376,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'100','0','0',0,'no',0,'no','1','Less than 6 reef building species','5',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2838,0,'Back-reef environment',-17,124,-2671291,12832556,'Australia','Oceania',801,'',-17.1333,124.7,'WAHR','92885',-23.6341315822,112.390719106,-23.6341315822,112.390719106,-31.5784451568,154.77051535),('Dingo Gap, Napier Range, Canning Basin',4019,'Napier','Devonian','Upper Devonian','latest Frasnian',372.20,382.70,10,'Givetian - early Famennian',375,375,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','4','Stromatoporoids','1','Corals',NULL,NULL,NULL,NULL,'100','0','0',0,'no',0,'no',NULL,'',NULL,NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2838,0,'sponge/coral bioherms',-17,124,-2671291,12832556,'Australia','Oceania',801,'',-17.1333,124.7,'WAHR','92896',-23.6341315822,112.390719106,-23.6341315822,112.390719106,-31.5784451568,154.77051535),('Neuvelle-les-Champlitte, Franche-Comte',4020,'','Jurassic','Upper Jurassic','middle Oxfordian',157.30,163.50,21,'late Bathonian - early Tithonian',151,157,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','2','1','Less than 10 m wide','10','1','Less than 20 m','10',NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea',NULL,'','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no','3','25 or more reef building species','29','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2839,0,'Donacosmilia bioherm (2 m thick and 10 m in diameter), 3 smaller bioherms (30-60 cm thick and 1-2 m in diameter) and flanking marly limestones',47,5,4506998,833960,'France','Europe',331,'',47.5833,5.55,'WAHR','87801',26.4071023683,23.774002969,26.4071023683,23.774002969,32.5527530741,24.4726236246),('Charcenne, Franche-Comte',4021,'','Jurassic','Upper Jurassic','middle-late Oxfordian',157.30,163.50,21,'late Bathonian - early Tithonian',151,157,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','2','1','Less than 10 m wide','10','1','Less than 20 m','10',NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea',NULL,'','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no','3','25 or more reef building species','24','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2839,0,'small Argovian and Sequanian coral reefs',47,5,4494198,854432,'France','Europe',331,'',47.35,5.7667,'WAHR','93102',26.2224764086,24.00209609,26.2224764086,24.00209609,32.3628948098,24.7091846749),('Mantoche, Franche-Comte',4022,'','Jurassic','Upper Jurassic','middle Oxfordian',157.30,163.50,21,'late Bathonian - early Tithonian',151,157,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1c','Epeiric sea',NULL,'','1','Corals',NULL,NULL,NULL,NULL,NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','14','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2839,0,'small coral patch reefs',47,5,4500598,831282,'France','Europe',331,'',47.4167,5.5333,'WAHR','93083',26.2436937872,23.8123368065,26.2436937872,23.8123368065,32.3885158373,24.5083597011),('Tuyeh, Alborz Mts.',4023,'Lalun','Cambrian','Lower Cambrian','Toyonian',509.00,514.00,1,'Nemakit/Daldynian - Toyonian',520,511,2,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick','2','1','Less than 10 m wide','5','1','Less than 20 m','20',NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','10','Archaeocyaths','3','Microbes','7','Archaeocyaths - microbes',NULL,NULL,'0','0','100',0,'no',0,'no',NULL,'',NULL,'1','Constructor guild',NULL,'',NULL,'','2','Medium zonation','1','Low zonation',NULL,'',NULL,'','1','Low production of reefal debris','2','Intense',0,'No or unknown reservoir potential',2840,0,'Archaeocyath-stromatolite calyptras in marginal marine setting. No calcimicrobes',36,54,-685578,14177429,'Iran','Asia',505,'',36.45,54.1667,'','',-38.2892391745,57.165906027,-40.6968053255,59.9855415835,-40.6968053255,59.9855415835),('Salient Mountain, Britisch Columbia',4024,'Byng','Ediacaran','Upper Ediacaran','upper Ediacaran',541.00,635.00,0,'Vendian',605,546,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','2','1','Less than 10 m wide','15','1','Less than 20 m','10',NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','3','Microbes','1','Corals','64','Microbes/stromatolites  - (cements) - (worm tubes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','3','3','Binder guild',NULL,'',NULL,'','1','Low zonation','1','Low zonation','2','30-60% micrite',NULL,'',NULL,'','1','Present',0,'No or unknown reservoir potential',2841,0,'Small mounds and more extensive biostromes of stromatolites and thrombolites containing namacalathus and Cloudina',53,-118,-4976520,-8267714,'Canada','North America',121,'',53.0333,-118.7333,'','',-46.8357809456,158.112952861,-46.8357809456,158.112952861,-46.8357809456,158.112952861),('Inaba Cave, Sambosan, Shikoku',4025,'','Triassic','Upper Triassic','Norian',208.50,228.00,18,'late Carnian - middle Hettangian',218,210,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,'3','More than 100 m',NULL,'50','178',0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','6','Calcisponges','3','Microbes','8','Coralline sponges (chaetetids) - microbes - corals',NULL,NULL,'0','100','0',0,'no',0,'no','2','6 to 24 reef building species','15','1','Constructor guild',NULL,'',NULL,'','3','Pronounced zonation',NULL,'','2','30-60% micrite','1','Less than 10% sparite','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2843,0,'Norian part of reef complex, dominated by sponge-microbial association',33,133,4378746,13498245,'Japan','Asia',625,'',33.4333,133.0833,'FALSCH','0',40.7739076187,145.466330765,40.0305492795,145.070345893,41.3978812714,152.022034192),('Inaba Cave, Sambosan, Shikoku',4026,'','Triassic','Upper Triassic','Norian-Rhaetian',201.30,228.00,18,'late Carnian - middle Hettangian',218,203,2,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,'3','More than 100 m',NULL,'50','178',0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1','Above fair weather wave base','6','Calcisponges','1','Corals','8','Coralline sponges (chaetetids) - microbes - corals',NULL,NULL,'0','100','0',0,'no',0,'no','3','25 or more reef building species','27','1','Constructor guild',NULL,'',NULL,'','3','Pronounced zonation',NULL,'','2','30-60% micrite','1','Less than 10% sparite','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2843,0,'Norian-Rhaetian part of reef complex. Sponge-coralmicrobial reef.',33,133,4378746,13508244,'Japan','Asia',625,'',33.4361,133.0847,'FALSCH','165294, 165295, 165296, 165297',46.1025846894,148.474542774,45.3659625383,148.03871833,41.132760127,154.273454866),('Amagour mound complex, Anti Atlas',4027,'Issafen','Cambrian','Lower Cambrian','lower Botomian',509.00,514.00,1,'Nemakit/Daldynian - Toyonian',520,514,3,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','60','2','10 - 100 m wide','80','2','10 - 100 m','80',NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','10','Archaeocyaths','7','Archaeocyaths - microbes',NULL,NULL,'100','0','0',0,'no',0,'no','2','6 to 24 reef building species',NULL,'3','Binder guild',NULL,'',NULL,'','1','Low zonation','1','Low zonation','3','More than 60% micrite','3','More than 25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2844,0,'Mound complex on grainstones. \nMound cores exhibit microbial (mainly Epiphyton and Renalcis) patches, up to 0.8 m thick and 1 m long, surrounded by massive microsparite bearing scattered shelly debris. Archaeocyaths, both\npreserved in life position and forming parautochthonous accumulations, are dominated by simple forms.\nAbundant stromatactis',29,-8,-6996358,7847364,'Morocco','Africa',714,'',29.7167,-8.9167,'','',-75.4123346275,-29.1662322052,-75.840465975,-36.1871923118,-75.840465975,-36.1871923118);
INSERT INTO `reefstest` VALUES ('Aguerd complex, Anti-Atlas',4028,'Issafen','Cambrian','Lower Cambrian','upper Botomian',509.00,514.00,1,'Nemakit/Daldynian - Toyonian',520,513,NULL,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','15','2','10 - 100 m wide',NULL,'3','More than 100 m',NULL,'50',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','3','Microbes','10','Archaeocyaths','7','Archaeocyaths - microbes',NULL,NULL,'100','0','0',0,'no',0,'no','2','6 to 24 reef building species','8','3','Binder guild',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','2','10-25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2844,0,'Reef complexes described from Aguerd (W), Tadakoust (middle) and Tamezrar (E). \nAguerd member of Issafen Fm.\nCoordinates for Tadakoust',29,-8,-7007576,7851194,'Morocco','Africa',714,'',29.2708,-8.7722,'','',-75.8708479851,-29.4340929303,-76.2807101295,-36.786403143,-76.2807101295,-36.786403143),('Pamyatno-Sasovskoye oilfield, Zhirnovsk',4029,'Evlanovian-Livnian','Devonian','Upper Devonian','middle-upper Frasnian',372.20,382.70,10,'Givetian - early Famennian',375,378,3,1,'Seismic data available ',1,'True reef','3','101-500 m thick','200','3','101-1000 m wide','1000','4','More than 1000 m','15000','80','2241',0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','1','Above fair weather wave base','3','Microbes','4','Stromatoporoids','9','Stromatoporoids - rugose/tabulate corals - microbes - (bryozoans) - (algae) - (echinoderms)','1','Red algae','0','10','90',0,'no',0,'no',NULL,'',NULL,'3','Binder guild',NULL,'',NULL,'','2','Medium zonation',NULL,'',NULL,'',NULL,'','2','Medium production of reefal debris','2','Intense',2,'Actual reservoir',2845,0,'Intrabasin buildup.\nflat-topped, narrow, and extended reef\nsteep (southeast) foreslope composed of relatively deep-water deposits and more gentle inner (north-west) slope represented by lagoonal deposits.\nUpward increase of the role of stromatoporoids, corals, crinoids, calcareous algae (green and red), and cyanobacteria.\n8% porosity, 10% detritus (fossils), 32% algal, rest is spar (dolomite)',50,45,-82309,2435104,'Russia','Asia',624,'',50.7833,45.15,'','',-4.31871094163,6.41136656897,-4.31871094163,6.41136656897,20.3248054592,-57.4590064232),('Godavari quarry',4030,'Chandragiri','Ordovician','Upper Ordovician','Upper Ordovician',443.40,458.40,5,'Darriwilian - Ashgillian',452,460,1,0,'Outcropping reef ',3,'Mud mound or bank','2','10 to 100 m thick','35','2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3a','Upper slope or inner ramp','2','Below fair weather wave base','3','Microbes','2','Algae','15','Algae - microbes - (encrusting forams) - (rare songes)','2','Green algae','0','60','40',0,'no',0,'no','1','Less than 6 reef building species','4','3','Binder guild',NULL,'',NULL,'','1','Low zonation','2','Medium zonation','3','More than 60% micrite','2','10-25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2848,0,'Mud mound with common stromatactis, similar to Meiklejohn Peak.\r\nAge poorly constrained',28,85,0,0,'Nepal','Asia',NULL,'',27.59,85.389722,'WAHR','118944',-19.9253282289,96.6761788664,-19.9253282289,96.6761788664,-19.9253282289,96.6761788664),('Santa Teresiola, Taranto',4031,'','Neogene','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,0,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick','1','2','10 - 100 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,1,'Temperate',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,'0','100','0',0,'no',0,'no','1','Less than 6 reef building species','1','1','Constructor guild','1','Present','1','Present','1','Low zonation','1','Low zonation','1','Less than 30% micrite','1','Less than 10% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2851,0,'The bank (or \'open frame reef\') is formed by numerous, contiguous colonies of coral embedded in a sandy matrix up to 1 m high covering a surface of nearly 0.6 km².',40,17,0,0,'Italy','Europe',344,'',40,17,'WAHR','130581',39.9910068315,16.9883000709,39.9935763579,16.9916426855,39.9929775971,17.0003500711),('Kongul Yayla',4032,'Kongul','Carboniferous','Lower Carboniferous','Asbian',336.00,340.00,12,'middle Visean - Serpukhovian',329,332,3,0,'Outcropping reef ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'no',0,'no',NULL,'',NULL,NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,NULL,2852,NULL,NULL,36,32,NULL,NULL,'Turkey','Asia',522,NULL,36.93,32.43,NULL,NULL,-55.9711534141,33.841433751,-55.3069909171,33.5930743334,-33.6763803515,1.26022275738),('NE Taebaek Basin',4033,'Daegi','Cambrian','Middle Cambrian','Middle Cambrian',497.00,509.00,2,'Middle Cambrian - Dresbachian',502,332,3,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1e','Open-marine shelf','1','Above fair weather wave base','3','Microbes','11','Siliceous sponges','33','Siliceous sponges - microbes - (Tubiphytes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','4','3','Binder guild',NULL,'',NULL,'','2','Medium zonation',NULL,'','3','More than 60% micrite','2','10-25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2852,0,'Described as siliceous-sponge microbial reefs. Epiphyton dominant, followed by Siliceous sponges, Renalcis and Epiphyton. 170 m thick section with several intervals. Described is only 14 m thick example. Ooids indicate shallow marine deposition. late Stage 5 to middle Guzhangian.',36,32,NULL,NULL,'South Korea','Asia',NULL,NULL,37.09,129,NULL,NULL,-27.1936870372,79.3999619657,-29.9592277698,84.3468123261,-29.9592277698,84.3468123261),('Lake Georgetown Spillway',4034,'Edwards','Cretaceous','Lower Cretaceous','Albian',100.50,113.00,24,'late Aptian - middle Cenomanian',107,332,2,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,'2','10 - 100 m wide','40',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','5','Rudists','12','Foraminifera','62','Rudists - stromatoporoids (hydrozoans) - (algae)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species',NULL,NULL,'',NULL,'',NULL,'','2','Medium zonation','3','Pronounced zonation',NULL,'',NULL,'',NULL,'','1','Present',2,'Actual reservoir',2852,0,'Outcrops of rudist-bearing shallow water carbonates. Weakly cemented, circular, flat-topped radiolitid–caprinid–toucasid mounds developed above the toucasid mounds and low relief, often sucrosic-dolomitized mounds',36,32,NULL,NULL,'Texas','North America',NULL,NULL,30.4,97.43,NULL,NULL,37.9493013187,106.85468669,37.9493013187,106.85468669,35.8903572804,103.258462882),('Sant Onofre',4035,'','Neogene','Pliocene','lower Pliocene',3.60,5.30,32,'Tortonian - Gelasian',6,NULL,3,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,1,'Temperate',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','8','Serpulids, worms, vermetids','2','Algae','48','Red algae - vermetids',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','4','1','Constructor guild','2','Intensive','2','Intensive','1','Low zonation','1','Low zonation','2','30-60% micrite','1','Less than 10% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2853,0,'Dendropoma and Spongites are the main builders',NULL,NULL,NULL,NULL,'Spain','Europe',304,NULL,40.7667,0.5833,'Y','153720',40.4101593545,-0.227481261408,40.4113737133,-0.224756615148,40.5763526103,0.557314590707),('East Island Wall',4036,'Assoul','Jurassic','Middle Jurassic','Bajocian',168.30,170.30,20,'middle Aalenian - middle Bathonian',166,NULL,3,0,'Outcropping reef ',3,'Mud mound or bank','2','10 to 100 m thick','20','3','101-1000 m wide',NULL,NULL,NULL,'310',NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3a','Upper slope or inner ramp','1','Above fair weather wave base','3','Microbes','13','Echinoderms','6','Corals - bivalves - (stromatoporoids)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','8',NULL,'',NULL,'',NULL,'','3','Pronounced zonation','1','Low zonation','3','More than 60% micrite','3','More than 25% sparite','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2859,0,NULL,NULL,NULL,NULL,NULL,'Morocco','Africa',714,NULL,31.59,5,NULL,NULL,11.0190660285,11.4964211205,11.0190660285,11.4964211205,14.6695533551,10.4403762655),('Bonifacio Basin, SE Corsica',4037,'Cala di Labra','Neogene','Lower Neogene','Burdigalian',16.00,20.40,31,'Burdigalian - Serravallian',14,NULL,3,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1d','Marginal marine - coastal -  siliciclastic shelf','1','Above fair weather wave base','1','Corals','2','Algae','41','Corals - bryozoans - (algae) - (bivalves)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','16',NULL,'',NULL,'',NULL,'','1','Low zonation','1','Low zonation','1','Less than 30% micrite',NULL,'','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2860,0,NULL,NULL,NULL,NULL,NULL,'France','Europe',331,NULL,41.22,9.11,'Y','151413, 151414, 151415',39.5959752714,3.78818668753,39.7835983875,5.22610841007,40.16584893,8.67162396966),('Rocky Camp Mound',4038,'Taravale','Devonian','Lower Devonian','Emsian',393.30,407.60,9,'late Pragian - Eifelian',395,400,3,0,'Outcropping reef ',3,'Mud mound or bank','4','More than 500 m thick','600','3','101-1000 m wide','1000','4','More than 1000 m','1000','10',NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'1','Above fair weather wave base','1','Corals','4','Stromatoporoids','50','Corals - stromatoporoids (chaetetids) - algae (stromatolites) - rudists - (spicular sponges)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','15','2','Baffler guild','1','Present','1','Present',NULL,'',NULL,'','3','More than 60% micrite','1','Less than 10% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2861,0,'Micritic components of the mud-mound were predominantly produced in situ by autochthonous algae and/or other skeletalorganisms. Green algae and stromatactis,together with sponge spicules in the lower facies of this mound - “microbial mud-mound” model',NULL,NULL,NULL,NULL,'Australia','Oceania',801,NULL,37.29,148.1,NULL,NULL,35,145,NULL,NULL,37.29,148.1),('Marsica',4039,'Ellipsactinia Limestones','Jurassic','Upper Jurassic','Tithonian',145.00,152.10,21,'late Bathonian - early Tithonian',151,NULL,1,0,'Outcropping reef ',1,'True reef','3','101-500 m thick','200','2','10 - 100 m wide',NULL,NULL,NULL,NULL,'3',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','6','Calcisponges','10','Scleractinian corals - (chaetetids, stromatoporoids-hydrozoans-spongiomorphids) - algae - microbes',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','10',NULL,'','2','Intensive','2','Intensive',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2858,0,'Biota - corals and calcified demosponges. Sedimentary features - grain size, sorting and reworking degree, bioerosion, cement crusts and cavities.',NULL,NULL,NULL,NULL,'Italy','Europe',344,NULL,41.5,14.8,'Y','154046, 154047, 154048',15.4057335468,19.5443542673,15.4057335468,19.5443542673,17.4313208575,23.2181407916),('Santanyi',4040,'Santanyí Limestone','Neogene','Upper Neogene','Tortonian',7.30,11.60,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',4,'Biostrome','2','10 to 100 m thick','30','1','Less than 10 m wide','6',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','2','Below fair weather wave base','3','Microbes',NULL,NULL,'64','Microbes/stromatolites  - (cements) - (worm tubes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','4','4','Microbial precipitation',NULL,'','1','Present',NULL,'',NULL,'','3','More than 60% micrite',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2862,0,NULL,NULL,NULL,NULL,NULL,'Spain','Europe',304,NULL,39.2,3.1,NULL,NULL,38.9234549155,1.07383075073,38.9243571708,1.06805015418,38.7567091323,2.987689051),('Shuibatang ',4041,'Shihniulan ','Silurian','Llandovery','Aeronian',438.50,440.80,6,'Rhuddanian-Telychian',435,NULL,1,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,1,'Temperate',1,'Intrashelf/ Intraplatform',NULL,NULL,'1','Above fair weather wave base','1','Corals','4','Stromatoporoids','9','Stromatoporoids - rugose/tabulate corals - microbes - (bryozoans) - (algae) - (echinoderms)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species',NULL,'1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2863,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,28.43,107.05,NULL,NULL,3.56130282896,69.3803871063,3.56130282896,69.3803871063,3.56130282896,69.3803871063),('Gosausee',4072,'Dachstein','Triassic','Upper Triassic','Rhaetian',201.30,208.50,18,'late Carnian - middle Hettangian',218,NULL,3,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'4','More than 1000 m wide','3500','4','More than 1000 m','5000',NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2','Shelf/platform margin','1',NULL,'3','Microbes','1',NULL,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'50','3',NULL,'1',NULL,'1',NULL,'1',NULL,'3',NULL,'2',NULL,'3',NULL,'2',NULL,'0',NULL,0,NULL,2931,NULL,'Probably part of the same reef tract as Gosaukamm reef (Rf #28), however, the Gosausee site is only lower Rhaetian. Also, although the microbialites are volumetrically the most abundant reef builders, corals and sponges are more important in certain zones',NULL,NULL,NULL,NULL,'Austria','Europe',NULL,NULL,47.536521,13.522713,NULL,NULL,26.6940525928,30.3028407271,26.6940525928,30.3028407271,28.7594453052,23.1379116288),('Seokgaejae pass',4042,'Dumugol','Ordovician','Lower Ordovician','Floian',470.00,477.70,4,'late Early - early Middle Ordovician',472,NULL,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,NULL,NULL,NULL,NULL,NULL,1,'Temperate',1,'Intrashelf/ Intraplatform',NULL,NULL,'1','Above fair weather wave base','3','Microbes','6','Calcisponges','14','Sponges - bryozoans - (microbes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no',NULL,'',NULL,'4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2864,NULL,NULL,NULL,NULL,NULL,NULL,'South Korea','Asia',NULL,NULL,36.13,129.1,NULL,NULL,-32.1181267484,91.4960321963,-32.1181267484,91.4960321963,-32.1181267484,91.4960321963),('Zhangzhai',4043,'Hunghuayuan','Ordovician','Lower Ordovician','upper Tremadocian',477.70,485.40,3,'Franconian - Tremadocian',488,NULL,1,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,1,'Temperate',2,'Shelf or Platform margin',NULL,NULL,'1','Above fair weather wave base','3','Microbes','6','Calcisponges','14','Sponges - bryozoans - (microbes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','5','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2865,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,27.27,109.02,NULL,NULL,-15.2402706884,89.9607464719,-15.2402706884,89.9607464719,-15.2402706884,89.9607464719),('Zhangzhai Calathium',4044,'Hunghuayuan','Ordovician','Lower Ordovician','Floian',470.00,477.70,4,'late Early - early Middle Ordovician',472,NULL,2,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','4.5','1','Less than 10 m wide','12','1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','6','Calcisponges','3','Microbes','14','Sponges - bryozoans - (microbes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','6',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2865,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,30.1,107.9,NULL,NULL,-13.4766972424,89.8010710917,-13.4766972424,89.8010710917,-13.4766972424,89.8010710917),('Haoshihe',4045,'Jinghe','Ordovician','Middle Ordovician','Darriwilian',458.40,467.30,5,'Darriwilian - Ashgillian',452,NULL,1,NULL,NULL,2,'Reef mound','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,1,'Temperate',1,'Intrashelf/ Intraplatform',NULL,NULL,'1','Above fair weather wave base','3','Microbes','1','Corals','19','Algae, microbes - bryozoans - corals - (sponges/stromatoporoids)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species',NULL,'4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2866,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,34.37,108.09,NULL,NULL,32.7652716288,95.9046659056,32.7652716288,95.9046659056,32.7652716288,95.9046659056),('Shigeyasu Mine',4048,'Akiyoshi Limestone','Permian','Middle Permian','Murghabian',265.10,268.80,16,'Roadian - Changhsingian',261,NULL,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'2','','11','Siliceous sponges','7',NULL,'14',NULL,'1',NULL,NULL,NULL,NULL,0,'no',0,'no','2','','12','4','',NULL,'',NULL,'','2','','2','','3','','3','',NULL,'','0','',0,'No or unknown reservoir potential',3002,NULL,NULL,NULL,NULL,NULL,NULL,'Japan','Asia',NULL,NULL,34.18,131.18,NULL,'173376',6.5268806937,127.887449044,6.5268806937,127.887449044,22.524615824,105.891890194),('Nanyigou section',4049,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,6,'Rhuddanian-Telychian',435,NULL,1,0,'Outcropping reef ',4,'Biostrome','3','101-500 m thick','178',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','2','Algae','15','Algae - microbes - (encrusting forams) - (rare songes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','11','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','3','More than 25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2868,NULL,'Bioclasts are rare in the lower part of the reef. In the middle part of the reef bindstones are common and stromatolitic structures are becoming more abundant than in the lower part- which can be observed especially on weathered rock surfaces. In the top part of the reef thin-bedded micritic mudstones occur with rare bioclasts.',NULL,NULL,NULL,NULL,'China','Asia',602,NULL,40.05,78.5,NULL,'154867',-3.61270627373,53.2963041801,-3.61270627373,53.2963041801,-3.61270627373,53.2963041801),('Børglum Elv, Peary Land',4051,'Turesø','Ordovician','Upper Ordovician','late Katian',445.20,453.00,5,'Darriwilian - Ashgillian',452,NULL,2,0,'Outcropping reef ',3,'Mud mound or bank',NULL,NULL,NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',4,'Basin','4a','Shallow basin','3','Below storm wave base','3','Microbes','1','Corals','44','Worms - microbes - (forams) - (bryozoans) - (corals)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','7',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','2','10-25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2867,NULL,'The individual mounds rarely exceed 1m in height. In terms of the rock fabrics, the North Greenland mudmounds show some similarity to the “thromboid”–bryozoan–worm tube association in the thin interval of “Red River reefs”',NULL,NULL,NULL,NULL,'Denmark','Europe',102,NULL,82.33,-30.15,NULL,NULL,7.88366730582,-84.9839396229,7.88366730582,-84.9839396229,7.88366730582,-84.9839396229),('Aïn El Bergoug',4052,'','Neogene','Miocene','late Tortonian',7.30,9.00,31,'Burdigalian - Serravallian',14,NULL,1,1,'Seismic data available ',1,'True reef','1','Less than 10 m thick',NULL,NULL,NULL,NULL,NULL,NULL,'800',NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)','2','Below fair weather wave base','1','Corals','1','Corals','2','Corals only',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','7','1','Constructor guild','1','Present',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2876,NULL,NULL,NULL,NULL,NULL,NULL,'Morocco','Africa',714,NULL,35.5,9.02,NULL,NULL,34.2539143906,7.61933135528,34.4232420322,7.80796988695,34.5280876447,9.01925929372),('Vasalemma Nordkalk quarry',4053,'Vasalemma','Ordovician','Upper Ordovician','Sandbian',453.00,458.40,5,'Darriwilian - Ashgillian',452,NULL,1,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick','15',NULL,NULL,NULL,'4','More than 1000 m','2.300',NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)',NULL,'','13','Echinoderms','7','Bryozoans','53','Echinoderms - bryozoans - tabulate corals - (lithistids)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','12','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','3','More than 25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2877,NULL,'Hemicosmitenkalk or cystoid limestone - the rock building abundance\r\nof echinoderm (mainly Hemicosmites, Rhombifera) bioclasts\r\nin this limestone',NULL,NULL,NULL,NULL,'Estonia','Europe',NULL,NULL,59.14,24.19,NULL,'87273',-29.0547990973,-61.1310049985,-29.0547990973,-61.1310049985,-29.0547990973,-61.1310049985),('Gisliflue-Homberg',4054,'','Jurassic','Middle Jurassic','Bajocian',168.30,170.30,20,'middle Aalenian - middle Bathonian',166,NULL,2,1,'Seismic data available ',4,'Biostrome','4','More than 500 m thick','800',NULL,NULL,NULL,'4','More than 1000 m',NULL,'4.5',NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2c','Atoll (circular structure)',NULL,'','1','Corals','1','Corals','2','Corals only',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','26','1','Constructor guild',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2875,NULL,NULL,NULL,NULL,NULL,NULL,'Switzerland','Europe',331,NULL,47.25,8.06,NULL,'162347',26.8374486534,28.0994883559,26.8374486534,28.0994883559,31.1236442073,28.349518978),('North Road Section',4055,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,6,'Rhuddanian-Telychian',435,NULL,2,0,'Outcropping reef ',NULL,NULL,'2','10 to 100 m thick','30','2','10 - 100 m wide','50',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','1','Corals','56','Microbes - crinoids - tabulate/rugose corals',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','5','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','3','More than 25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2868,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,40.09,78.5,NULL,NULL,-3.59605530213,53.2598625322,-3.59605530213,53.2598625322,-3.59605530213,53.2598625322),('Microwave  Station',4056,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,6,'Rhuddanian-Telychian',435,NULL,1,0,'Outcropping reef ',NULL,NULL,'2','10 to 100 m thick',NULL,NULL,NULL,NULL,'3','More than 100 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','1','Corals','61','Microbes (thrombolites) - algae - corals',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','9','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','3','More than 25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2868,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,40.8,78.49,NULL,NULL,-5.13464111343,29.1807814417,-5.13464111343,29.1807814417,-5.13464111343,29.1807814417),('Aggtelek',4057,'Steinalm','Jurassic','Middle Triassic','Anisian-Ladinian',237.00,247.20,17,'Induan - early Carnian',235,NULL,1,0,'Outcropping reef ',2,'Reef mound','3','101-500 m thick',NULL,'3','101-1000 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1e','Open-marine shelf','2','Below fair weather wave base','2','Algae','12','Foraminifera','13','Algae - encrusting forams',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species','26',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2875,NULL,NULL,NULL,NULL,NULL,NULL,'Hungary','Europe',NULL,NULL,48.5,20.55,NULL,NULL,11.8508212251,40.2155667597,11.8508212251,40.2155667597,14.5900350522,24.9108453414),('Microwave  Station',4058,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,6,'Rhuddanian-Telychian',435,NULL,1,0,'Outcropping reef ',NULL,NULL,'2','10 to 100 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','1','Corals','61','Microbes (thrombolites) - algae - corals',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','4','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2868,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',602,NULL,40,78.56,NULL,NULL,-3.59171890362,53.3610118146,-3.59171890362,53.3610118146,-3.59171890362,53.3610118146),('Aggtelek',4059,'Jenei','Triassic','Middle Triassic','Anisian-Ladinian',237.00,247.20,17,'Induan - early Carnian',235,NULL,3,0,'Outcropping reef ',2,'Reef mound','3','101-500 m thick',NULL,'3','101-1000 m wide',NULL,'3','More than 100 m',NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1e','Open-marine shelf','3','Below storm wave base','2','Algae','2','Algae',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','20',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','2','30-60% micrite','2','10-25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2875,NULL,NULL,NULL,NULL,NULL,NULL,'Hungary','Europe',NULL,NULL,48.5,20.55,NULL,NULL,11.8508212251,40.2155667597,11.8508212251,40.2155667597,14.5900350522,24.9108453414),('Taebaeksan Basin',4060,'Duwibong','Ordovician','Middle Ordovician','Darriwilian',458.40,467.30,5,'Darriwilian - Ashgillian',452,NULL,2,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','7',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,2,'Cold - water',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','2','Below fair weather wave base','4','Stromatoporoids','7','Bryozoans','22','Stromatoporoids/sponges - corals - (algae)','2','Green algae',NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','2',NULL,'','1','Present','1','Present','1','Low zonation','1','Low zonation','1','Less than 30% micrite','1','Less than 10% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2881,NULL,'Stromatoporoids and bryozoans comprise more than 50 areal percent of these frameworks. Cystostroma stromatoporoids -34%, Nicholsonella bryozoans -16%, unidentified tubular organisms - 4% and siliceous sponge <2%.',NULL,NULL,NULL,NULL,'Korea','Asia',NULL,NULL,37.08,128.57,NULL,NULL,21.8468018521,81.4703322159,21.8468018521,81.4703322159,21.8468018521,81.4703322159),('Capo Colonna',4061,'','Quaternary','Pleistocene','upper Pleistocene',0.00,0.10,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick','5',NULL,NULL,NULL,NULL,NULL,NULL,'2.5',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','2','Algae','15','Non-rudist bivalves','39','Algae - bivalves - (bryozoans) - (siliceous sponges)','1','Red algae',NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species','35',NULL,'','1','Present','1','Present','1','Low zonation','1','Low zonation','3','More than 60% micrite','1','Less than 10% sparite','1','Low production of reefal debris','1','Present',0,'No or unknown reservoir potential',2882,NULL,'The Capo Colonna deposits include rigid build-ups, rhodolith accumulations, and a maerl bed. The build-ups, identified as a fossil example of the present day Mediterranean coralligenous, are primarily formed by Mesophyllum alternans',NULL,NULL,NULL,NULL,'Italy','Europe',NULL,NULL,39.1,17.11,NULL,'166071, 166072, 166073, 166074',39.0910114283,17.0983490547,39.0935796415,17.1016776808,39.0968849744,17.1089387657),('Maroni',4062,'Koronia Member - Pakhna Formation','Neogene','Miocene','Tortonian-Messinian',5.30,11.60,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','2','Algae','41','Corals - bryozoans - (algae) - (bivalves)','1','Red algae',NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','7',NULL,'',NULL,'',NULL,'','1','Low zonation','1','Low zonation',NULL,'',NULL,'','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2891,NULL,NULL,NULL,NULL,NULL,NULL,'Cyprus','Europe',NULL,NULL,34.45,33.21,NULL,NULL,33.4773383939,31.6529819143,33.480230056,31.6575284453,32.976123571,32.8120387276),('Ainsa-Jaca Basin',4063,'Arguis','Paleogene','Eocene','Priabonian',33.90,38.00,29,'Priabonian - Rupelian',33,NULL,1,0,'Outcropping reef ',NULL,NULL,'3','101-500 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3b','Deeper slope or outer ramp','1','Above fair weather wave base','1','Corals','2','Algae','41','Corals - bryozoans - (algae) - (bivalves)','1','Red algae',NULL,NULL,NULL,0,'no',0,'no','3','25 or more reef building species','44',NULL,'','2','Intensive','1','Present',NULL,'',NULL,'',NULL,'',NULL,'','3','High production of reefal debris','1','Present',0,'No or unknown reservoir potential',2893,NULL,'upper part of Arguis Fm',NULL,NULL,NULL,NULL,'Spain','Europe',NULL,NULL,42.2,-0.38,NULL,'152582',39.1338850831,-4.52137692186,39.1338850831,-4.52137692186,40.9498812584,-0.600243517045),('south Qinling Mountains, Sanlixia, Xunyang',4064,'Yangshan','Permian','Lower Permian','Asselian-Sakmarian',290.10,298.90,14,'Gzhelian - Asselian',290,294,1,0,'Outcropping reef ',3,'Mud mound or bank','2','10 to 100 m thick','40',NULL,NULL,NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2','Shelf/platform margin','2','Below fair weather wave base','3','Microbes','2','Algae','61','Microbes (thrombolites) - algae - corals','4','Others',NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','12','3','Binder guild',NULL,'',NULL,'','1','Low zonation','1','Low zonation','3','More than 60% micrite','3','More than 25% sparite',NULL,'','0','',0,'No or unknown reservoir potential',2899,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,33.01,109.21,NULL,NULL,-5.44762078631,126.585235966,-5.44762078631,126.585235966,42.3900348172,129.23461243),('West Barbados',4065,'','Neogene','Pleistocene','middle Pleistocene',0.10,0.80,0,'Vendian',605,NULL,3,0,'Outcropping reef ',3,'Mud mound or bank',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1','Above fair weather wave base','1','Corals','2','Algae','1','Scleractinian corals - red algae - (hydrozoans) - (foraminifera) - (microbes) - (sponges)','1','Red algae',NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','14',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','0','',0,'No or unknown reservoir potential',2900,NULL,NULL,NULL,NULL,NULL,NULL,'Barbados','North America',NULL,NULL,13.16,-59.38,NULL,'88831',13.1062251021,-59.3123317277,13.1068161894,-59.3130749068,13.16,-59.38),('Dunmore',4066,'','Carboniferous','Lower Carboniferous','Tournaisian/Visean',330.90,358.90,11,'late Famennian - early Visean',351,NULL,2,0,'Outcropping reef ',3,'Mud mound or bank','1','Less than 10 m thick','3.2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3','Below storm wave base','7','Bryozoans','6','Calcisponges','60','Bryozoans - Pelmatozoans - (microbes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','2','6 to 24 reef building species','24',NULL,'',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite',NULL,'','3','High production of reefal debris','0','',0,'No or unknown reservoir potential',2908,NULL,NULL,NULL,NULL,NULL,NULL,'Ireland','Europe',NULL,NULL,53.38,-8.45,NULL,NULL,-33.1253298072,-15.2413807516,-33.1253298072,-15.2413807516,-4.14364090342,-47.3501090304),('Tiandong 10, Kaijiang, east Sichuan',4067,'','Triassic','Lower Triassic','Induan',251.20,252.20,17,'Induan - early Carnian',235,NULL,1,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,NULL,NULL,NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,'','3','Microbes','3','Microbes','64','Microbes/stromatolites  - (cements) - (worm tubes)',NULL,NULL,NULL,NULL,NULL,0,'no',0,'no','1','Less than 6 reef building species','2','4','Microbial precipitation',NULL,'',NULL,'',NULL,'',NULL,'','3','More than 60% micrite','3','More than 25% sparite','1','Low production of reefal debris','0','',0,'No or unknown reservoir potential',2911,NULL,'?Microbialite',NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,31.1,107.57,NULL,NULL,-8.94860352871,106.961364897,-8.94860352871,106.961364897,14.8704195218,123.874690811),('N of Port Sudan, Red Sea coast',4077,'','Quaternary','Pleistocene','Pleistocene',0.00,2.60,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',NULL,NULL,'2','10 to 100 m thick','15','3','101-1000 m wide','550',NULL,NULL,NULL,'700',NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,'1','Corals','1',NULL,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'32','2',NULL,'2',NULL,'1',NULL,NULL,NULL,NULL,NULL,'3',NULL,'2',NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3008,NULL,'terraces which are exposed in the coastal plain north of the city of Port Sudan, between 19° 54\' N and 21° 50\' N and 36° 51\' E and 37° 17\' E, until near to the border between Sudan and Egypt',NULL,NULL,NULL,NULL,'Sudan','Africa',NULL,NULL,19.54,36.51,NULL,'101414',19.3977448475,36.2963144811,19.3971949003,36.2954903276,19.3059566964,36.4035468966),('Sharm Al Arab',4078,'','Quaternary','Pleistocene','late Pleistocene',0.00,0.10,33,'Recent',0,NULL,3,1,'Seismic data available ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3a','Upper slope or inner ramp','3',NULL,'1','Corals','1',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,26.57,33.54,NULL,'176527',26.5643272244,33.5313410577,26.5643272244,33.5313410577,26.5612339686,33.5367803743),('Sharm Al Arab II',4079,'','Quaternary','Pleistocene','middle Pleistocene',0.10,0.80,32,'Tortonian - Gelasian',6,NULL,3,1,'Seismic data available ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','1','Shelf/platform interior','3',NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,26.57,33.54,NULL,'176528',26.5183584782,33.4612351936,26.5189262024,33.4621003557,26.4911155401,33.5109988367),('Wadi Gawasis',4080,'','Quaternary','Pleistocene','middle Pleistocene',0.10,0.80,32,'Tortonian - Gelasian',6,NULL,3,2,'NA',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3','Slope/ramp','3',NULL,'1','Corals','1',NULL,'85',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,26.33,34.02,NULL,'176529',26.2786239447,33.9411861935,26.2791887551,33.9420518961,26.2507525844,33.9904435238),('Wadi Gawasis II',4081,'','Quaternary','Pleistocene','late Pleistocene',0.00,0.10,33,'Recent',0,NULL,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3','Slope/ramp','3',NULL,'1','Corals','1',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,26.33,34.02,NULL,'176530',26.3243564269,34.0113356915,26.3243564269,34.0113356915,26.3211936361,34.0167186052),('Wadi Wizr',4082,'','Quaternary','Pleistocene','middle Pleistocene',0.10,0.80,32,'Tortonian - Gelasian',6,NULL,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform',NULL,NULL,'3',NULL,'1','Corals','1',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,25.47,34.29,NULL,'176532',25.4187749966,34.2116625822,25.4193381475,34.2125230605,25.3905511082,34.2594685245),('Wadi Wizr II',4083,'','Quaternary','Pleistocene','middle Pleistocene',0.10,0.80,33,'Recent',0,NULL,3,0,'Outcropping reef ',1,'True reef',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform',NULL,NULL,'3',NULL,'1','Corals','1',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,'No or unknown reservoir potential',3009,NULL,NULL,NULL,NULL,NULL,NULL,'Egypt','Africa',NULL,NULL,25.47,34.29,NULL,'176533',NULL,NULL,25.4193381475,34.2125230605,25.4611712236,34.2866102002),('Isla Juanilla, Sandino Basin',4084,'Juanilla','Paleogene','Oligocene','Chattian',23.00,28.10,30,'Chattian - Aquitanian',22,27,2,0,'Outcropping reef ',2,'Reef mound','2','10 to 100 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',4,'Basin','4','Basin',NULL,NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'3',NULL,'2',NULL,'0',NULL,0,NULL,3016,NULL,NULL,NULL,NULL,NULL,NULL,'Costa Rica','North America',NULL,NULL,10.58,-85.42,NULL,'179809',8.86800411643,-85.6533405436,8.86800411643,-85.6533405436,13.0463026931,-80.4874091395),('Monte Postale',4085,'','Paleogene','Eocene','Ypresian',47.80,56.00,27,'Thanetian - Ypresian',53,51,1,2,'NA',1,'True reef','2','10 to 100 m thick','15','2','10 - 100 m wide','30','2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,'3',NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'22','1',NULL,'2',NULL,'2',NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'2',NULL,'0',NULL,0,NULL,3017,NULL,NULL,NULL,NULL,NULL,NULL,'Italy','Europe',NULL,NULL,45.35,11.12,NULL,'180311',38.3108461491,8.45360519391,38.3108461491,8.45360519391,39.9593645561,12.3480594542),('Topuk Tepe, near Pinargözü',4086,'Kasımlar','Triassic','Upper Triassic','Norian',208.50,228.00,18,'late Carnian - middle Hettangian',218,214,1,0,'Outcropping reef ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,'11','Siliceous sponges',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3020,NULL,'tectonically\r\nisolated carbonate block composed of Dachstein-type limestones with megalodonts and large dendroid corals. At the top of this\r\nsedimentation a reefal fauna is developed with similarities to the cipit fauna. The Topuk Tepe locality is surrounded by reef\r\nboulder bearing shales of Kasımlar Formation.',NULL,NULL,NULL,NULL,'Turkey','Asia',NULL,NULL,37.26,44.08,NULL,NULL,5.57491768489,45.8310963157,5.35457637676,45.861654778,-2.41448043874,38.0359179196),('Vojsko Plateau',4087,'Bellerophon','Permian','Lopingian','Changhsingian',252.20,254.10,16,'Roadian - Changhsingian',261,NULL,2,0,'Outcropping reef ',4,'Biostrome','2','10 to 100 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',3,'Ramp or Slope','3a','Upper slope or inner ramp','2',NULL,'11','Siliceous sponges','8',NULL,'8',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'7','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,0,NULL,3021,NULL,'The major biostrome builders are medium-sized coralline sponges, Demospongea and Calcarea, encrusted by smaller sponges, tube worms, sessile foraminifera, calcareous algae - Archaeolithoporella - and Shamovella - Tubiphytes-, all of which are typically covered by microbial crusts. The biostromes are characteristically composed of bafflestone and bindstone, incorporating sporadic framestone.\r\nNarrowbelts of floatstone surround the buildups, and sponge debris is also present in lenseswithin the mud matrix between metazoan bafflestones',NULL,NULL,NULL,NULL,'Slovenia','Europe',NULL,NULL,46.1,13.55,NULL,'183939',10.6700695789,36.2515879092,10.6700695789,36.2515879092,8.24886331102,28.4326710133),('Akdag locality',4088,'','Triassic','Upper Triassic','Norian',208.50,228.00,18,'late Carnian - middle Hettangian',218,NULL,1,0,'Outcropping reef ',NULL,NULL,'1','Less than 10 m thick',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',4,'Basin','4a','Shallow basin',NULL,NULL,NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3020,NULL,NULL,NULL,NULL,NULL,NULL,'Turkey','Asia',NULL,NULL,37.8,30.53,NULL,'183686',9.04896245868,35.9716691423,8.85503872176,36.0162275963,5.80197383438,27.9335857191),('Yeongwol County, Yeongheung Fm',4089,'Yeongheung','Ordovician','Middle Ordovician','Darriwilian',458.40,467.30,5,'Darriwilian - Ashgillian',452,NULL,1,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick','1','1','Less than 10 m wide','1','1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,'1a','Shallow intra-platform','3',NULL,'4','Stromatoporoids',NULL,NULL,'75',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'3','4',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,'1',NULL,0,NULL,3022,NULL,'A fabric composed of peloids up to several tens of micrometers in diameter, micrite, patches of calcite cement, and ghosts of either in-place or dissociated cyst plates and pillars occupies areas where the internal textures of stromatoporoid skeletons are poorly preserved. This fabric commonly grades intowellpreserved stromatoporoid skeletons, or rarely replace the bulk of each\r\nskeleton.\r\nFramework basically just Labechia, rare calcimicrobes and bryozoans',NULL,NULL,NULL,NULL,'South Korea','Asia',NULL,NULL,37.14,128.26,NULL,'184483',21.9608543485,81.7154207905,21.9608543485,81.7154207905,21.9608543485,81.7154207905),('Well He 3',4090,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,5,'Darriwilian - Ashgillian',452,NULL,1,0,'Outcropping reef ',2,'Reef mound',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform',NULL,NULL,'3',NULL,'7','Bryozoans','1',NULL,'41',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'12','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,'0',NULL,0,NULL,3023,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,38.46,79.56,NULL,NULL,-3.51599816814,55.0864737108,-3.51599816814,55.0864737108,-3.51599816814,55.0864737108),('Wells Ma 5',4091,'Lianglitag','Ordovician','Upper Ordovician','Katian',445.20,453.00,5,'Darriwilian - Ashgillian',452,NULL,1,1,'Seismic data available ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3',NULL,'7','Bryozoans','1',NULL,'18',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'10','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'1',NULL,'0',NULL,0,NULL,3023,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,38.36,79.33,NULL,'184490',-3.72127913586,55.1049652613,-3.72127913586,55.1049652613,-3.72127913586,55.1049652613),('Yadana field, offshore Myanmar',4092,'Upper Burman Limestone','Neogene','Oligocene/Miocene','Aquitanian',20.40,23.00,30,'Chattian - Aquitanian',22,NULL,1,1,'Seismic data available ',1,'True reef','4','More than 500 m thick','850','4','More than 1000 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','3','Slope/ramp',NULL,NULL,'12','Foraminifera','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'0',NULL,2,NULL,3024,NULL,NULL,NULL,NULL,NULL,NULL,'Burma (Myanmar)','Asia',NULL,NULL,15.1,94.4,NULL,NULL,11.3621401341,92.0375422188,11.3621401341,92.0375422188,4.68120729728,91.8573420608),('Myrmidon Reef MYR_3',4093,'','Quaternary','Pleistocene','late Pleistocene',0.00,0.10,33,'Recent',0,NULL,1,0,'Outcropping reef ',NULL,NULL,'2','10 to 100 m thick',NULL,'2','10 - 100 m wide','28',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform',NULL,NULL,'1','Corals','3',NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3025,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-18.15,147.23,NULL,NULL,-18.1833690371,147.215702935,-18.1738348905,147.219787403,-18.1828711451,147.223259823),('Stanley',4094,'','Quaternary','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,NULL,1,2,'NA',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','3b','Deeper slope or outer ramp',NULL,NULL,'2','Algae','1',NULL,'5',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3025,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-19.17,148.4,NULL,'184511',-19.2031420365,148.386153001,-19.1936727529,148.390108823,-19.2026102232,148.393739267),('Heron',4095,'','Quaternary','Pleistocene','late Pleistocene',0.00,0.10,33,'Recent',0,NULL,1,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','2',NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3025,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-23.26,152.55,NULL,NULL,-23.2830185063,152.541508979,-23.2830185063,152.541508979,-70.6915101198,127.880641711),('One Tree',4096,'','Quaternary','Pleistocene','Upper Paleocene',56.00,59.20,33,'Recent',0,NULL,1,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2a','Margin of shallow basins (platform margin)','2',NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3025,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-23.3,152.5,NULL,'184510',-45.0182333752,153.269672221,-45.0182333752,153.269672221,-49.6652478445,151.407828343),('Fairfax',4097,'','Quaternary','Pleistocene','upper Pleistocene',0.00,0.10,33,'Recent',0,NULL,1,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick',NULL,'2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2b','Margin of deep basins (shelf margin)','1',NULL,'1','Corals','2',NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3025,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-23.51,152.22,NULL,'184506',-23.5423051154,152.208104244,-23.5330749902,152.211502352,-23.5416641551,152.215818109),('Precordillera',4098,'La Silla','Ordovician','Lower Ordovician','early-mid Tremadocian',477.70,485.40,3,'Franconian - Tremadocian',488,NULL,3,0,'Outcropping reef ',2,'Reef mound','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3',NULL,'1','Corals','3',NULL,'96',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'7','4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'2',NULL,'2',NULL,'0',NULL,0,NULL,3026,NULL,'Stromatolites, and particularly thrombolites, are ubiquitous and very common components of the higher-frequency cycles.  Calcarenites are mainly composed of peloids, well-rounded intraclasts, aggregate lime grains, micritized ooids, and a few bioclasts. Bioclasts are very scarce and include rare calcareous algae such as Nuia sp. and scattered fragments of gastropods, trilobites, and nautiloids within the cross-bedded subtidal grainstone-packstone intervals.  Abundant in situ gas-\r\ntropods seem intimately related with domical thrombolites.',NULL,NULL,NULL,NULL,'Argentina','South America',NULL,NULL,-30.16,-58.4,NULL,'8880',-31.4877371732,-173.400594115,-31.4877371732,-173.400594115,-31.4877371732,-173.400594115),('Portada Covunco',4099,'La Manga','Jurassic','Upper Jurassic','Oxfordian',157.30,163.50,20,'middle Aalenian - middle Bathonian',166,NULL,1,0,'Outcropping reef ',1,'True reef','2','10 to 100 m thick','12','2','10 - 100 m wide',NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3',NULL,'1','Corals','11',NULL,'46',NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'15','1',NULL,'2',NULL,'2',NULL,NULL,NULL,NULL,NULL,'3',NULL,'2',NULL,'3',NULL,'1',NULL,0,NULL,3028,NULL,NULL,NULL,NULL,NULL,NULL,'Argentina','South America',NULL,NULL,-38.47,-70.11,NULL,'184598',-43.8045831536,-37.1589075683,-43.8045831536,-37.1589075683,-40.0569900847,-37.4993867609),('Nanyigou section',4100,'Yijianfang','Ordovician','Middle Ordovician','Darriwilian',458.40,467.30,5,'Darriwilian - Ashgillian',452,NULL,1,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick','2','1','Less than 10 m wide','6',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1',NULL,'2','Algae','6',NULL,'15',NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'11','4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'0',NULL,0,NULL,3029,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,40.05,78.5,NULL,'154821',-13.718412382,64.5292892321,-13.718412382,64.5292892321,-13.718412382,64.5292892321),('Yangmaile',4101,'','Ordovician','Middle Ordovician','Darriwilian',458.40,467.30,5,'Darriwilian - Ashgillian',452,NULL,1,0,'Outcropping reef ',4,'Biostrome','1','Less than 10 m thick','5','1','Less than 10 m wide',NULL,'1','Less than 20 m',NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,'2','Algae',NULL,NULL,'15',NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'0',NULL,0,NULL,3029,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,39.57,79.03,NULL,'184658',-13.4893345114,65.1324499252,-13.4893345114,65.1324499252,-13.4893345114,65.1324499252),('Sidi Mohamed Smaine',4102,'Sidi Mohamed Smaine','Devonian','Middle Devonian','Givetian',382.70,387.70,10,'Givetian - early Famennian',375,NULL,1,0,'Outcropping reef ',4,'Biostrome','3','101-500 m thick','170',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3',NULL,'4','Stromatoporoids','1',NULL,'9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'7',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1',NULL,NULL,NULL,'2',NULL,'1',NULL,0,NULL,3031,NULL,NULL,NULL,NULL,NULL,NULL,'Morocco','Africa',NULL,NULL,33.29,-6.59,NULL,'176209',-36.3663689255,-12.276805532,-36.3663689255,-12.276805532,-41.1668433055,-6.98478423855),('Barcoo 1',4103,'','Neogene','Miocene','Burdigalian',16.00,20.40,31,'Burdigalian - Serravallian',14,NULL,1,1,'Seismic data available ',NULL,NULL,'4','More than 500 m thick',NULL,'4','More than 1000 m wide',NULL,'4','More than 1000 m',NULL,'250',NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform',NULL,NULL,'1','Corals','12',NULL,'20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,1,NULL,3032,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-15.22,120.35,NULL,NULL,-26.9093060116,113.824515082,-24.3502323429,115.09122708,-27.30371532,116.145287895),('Brecknock 1',4104,'','Neogene','Miocene','Aquitanian-Burdigalian',16.00,23.00,31,'Burdigalian - Serravallian',14,NULL,1,1,'Seismic data available ',1,'True reef','4','More than 500 m thick',NULL,'4','More than 1000 m wide',NULL,'4','More than 1000 m',NULL,'250','Barcoo 1',0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','1',NULL,'1','Corals','12',NULL,'20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'3',NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,1,NULL,3032,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-14.35,121.42,NULL,NULL,-24.1548836113,115.853334109,-24.1548836113,115.853334109,-27.262674148,117.033123872),('Lombardina 1',4105,'','Neogene','Miocene','Miocene/Pliocene',2.60,20.00,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',NULL,NULL,'3','101-500 m thick',NULL,'3','101-1000 m wide',NULL,'4','More than 1000 m',NULL,NULL,'Barcoo 1',0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,1,NULL,3032,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-15.44,121.32,NULL,NULL,-21.0807998672,118.131955692,-21.0807998672,118.131955692,-23.1869652728,118.680106014),('Lynher 1',4106,'','Paleogene','Miocene','Upper Miocene',5.30,11.60,32,'Tortonian - Gelasian',6,NULL,1,0,'Outcropping reef ',NULL,NULL,'4','More than 500 m thick',NULL,'4','More than 1000 m wide',NULL,'4','More than 1000 m',NULL,'20','Barcoo 1',0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,1,NULL,3032,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-15.28,121.5,NULL,NULL,-19.4734696584,119.13722868,-19.4734696584,119.13722868,-21.1264167755,119.502529571),('North Scott Reef 1',4107,'','Paleogene','Miocene','Miocene',5.30,23.00,31,'Burdigalian - Serravallian',14,NULL,1,0,'Outcropping reef ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Barcoo 1',0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,1,NULL,3032,NULL,NULL,NULL,NULL,NULL,NULL,'Australia','Oceania',NULL,NULL,-13.53,121.53,NULL,NULL,-20.6170350806,117.544880056,-20.6170350806,117.544880056,-23.07139082,118.307006768),('Panaca Hills',4108,'Highland Peak','Cambrian','Upper Cambrian','Middle-Upper Cambrian',485.00,509.00,2,'Middle Cambrian - Dresbachian',502,NULL,1,2,'NA',3,'Mud mound or bank','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','2','Shelf/platform margin','3',NULL,'3','Microbes',NULL,NULL,'93',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,NULL,NULL,'1',NULL,0,NULL,3034,NULL,NULL,NULL,NULL,NULL,NULL,'United States','North America',NULL,NULL,37.8,-114.37,NULL,NULL,30.9550329829,-134.717174022,31.7762474621,-125.053166947,31.7762474621,-125.053166947),('Delamar Mountains, Nopah Fm',4109,'Nopah','Cambrian','Upper Cambrian','Upper Cambrian',485.00,497.00,2,'Middle Cambrian - Dresbachian',502,NULL,1,0,'Outcropping reef ',3,'Mud mound or bank','1','Less than 10 m thick',NULL,'1','Less than 10 m wide',NULL,'2','10 - 100 m',NULL,NULL,NULL,0,'Tropical or unknown',2,'Shelf or Platform margin','1a','Shallow intra-platform','1',NULL,'3','Microbes',NULL,NULL,'93',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,NULL,NULL,'1',NULL,0,NULL,3034,NULL,NULL,NULL,NULL,NULL,NULL,'United States','North America',NULL,NULL,37.05,-114.92,NULL,NULL,31.1224635109,-121.934611404,31.1224635109,-121.934611404,31.1224635109,-121.934611404),('Qaidam Basin, Huaitoutala Fm',4110,'Huaitoutala','Carboniferous','Lower Carboniferous','Visean',330.90,346.70,12,'middle Visean - Serpukhovian',329,NULL,3,0,'Outcropping reef ',1,'True reef','1','Less than 10 m thick',NULL,'1','Less than 10 m wide','7',NULL,NULL,NULL,NULL,NULL,0,'Tropical or unknown',NULL,NULL,NULL,NULL,NULL,NULL,'1','Corals','14',NULL,'57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,'7',NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,0,NULL,3035,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,37.33,96.1,NULL,NULL,29.7690094268,125.330924579,29.7690094268,125.330924579,29.6413931569,41.0502934904),('Wubaiti, eastern Sichuan',4111,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,'Roadian - Changhsingian',261,252,3,1,'Seismic data available',1,'True reef','3','101-500 m thick','200','2','10 - 100 m wide',NULL,'3',NULL,NULL,NULL,NULL,0,'Tropical or unknown',1,'Intrashelf/ Intraplatform','1a','Shallow intra-platform','3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China','Asia',NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,-10.0236080552,106.329387278,11.8419056024,125.429185034),('Wubaiti, eastern Sichuan',4112,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4113,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4114,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4115,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4116,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4117,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4118,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4119,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('Wubaiti, eastern Sichuan',4120,'Changhsing','Permian','Upper Permian','middle-upper Changhsingian',252.20,254.10,16,NULL,NULL,NULL,3,1,NULL,1,NULL,'3',NULL,'200','2',NULL,NULL,'3',NULL,NULL,NULL,NULL,0,NULL,1,NULL,'1a',NULL,'3',NULL,'1','Corals','6',NULL,'3',NULL,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'4',NULL,NULL,NULL,NULL,NULL,'2',NULL,'2',NULL,'2',NULL,'3',NULL,'2',NULL,'1',NULL,1,NULL,3036,NULL,NULL,NULL,NULL,NULL,NULL,'China',NULL,NULL,NULL,31.05,108.01,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `scotese_intervalls`
--

CREATE TABLE `scotese_intervalls` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SCOTESE_INTERVALLS` varchar(67) DEFAULT NULL,
  `SCOTESE_TIME` int(3) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `scotese_intervalls`
--

INSERT INTO `scotese_intervalls` VALUES (0,NULL,NULL),(1,'Pleistocene - Calabrian - Gelasian',1),(2,'Piacenzian - Zanclean',4),(3,'latest Miocene (Messinian, 6.3 Ma)',5),(4,'Middle/Late Miocene (Serravallian&Tortonian, 10.5 Ma)',10),(5,'Middle Miocene (Langhian, 14.9 Ma)',15),(6,'Early Miocene (Aquitanian&Burdigalian, 19.5 Ma)',20),(7,'Late Oligocene (Chattian, 25.6 Ma)',25),(8,'Early Oligocene (Rupelian, 31 Ma)',30),(9,'Late Eocene (Priabonian, 35.9 Ma)',35),(10,'late Middle Eocene (Bartonian, 39.5 Ma)',40),(11,'early Middle Eocene (Lutetian, 44.5 Ma)',45),(12,'Early Eocene (Ypresian, 51.9 Ma)',50),(13,'Paleocene/Eocene Boundary (PETM, 56 Ma)',55),(14,'Paleocene (Danian&Thanetian, 61 Ma)',60),(15,'KT Boundary (latest Maastrichtian, 66 Ma)',65),(16,'Late Cretaceous (Maastrichtian, 69 Ma)',70),(17,'Late Cretaceous (Late Campanian, 75 Ma)',75),(18,'Late Cretaceous (Early Campanian, 80.8 Ma)',80),(19,'Late Cretaceous (Santonian&Coniacian, 86.7 Ma)',85),(20,'Mid-Cretaceous (Turonian , 91.9 Ma)',90),(21,'Mid-Cretaceous (Cenomanian, 97.2 Ma)',95),(22,'Early Cretaceous (late Albian, 102.6 Ma)',100),(23,'Early Cretaceous (middle Albian, 107 Ma)',105),(24,'Early Cretaceous (early Albian, 111 Ma)',110),(25,'Early Cretaceous (late Aptian, 115.8 Ma)',115),(26,'Early Cretaceous (early Aptian, 121.8 Ma)',120),(27,'Early Cretaceous (Barremian, 127.2 Ma)',125),(28,'Early Cretaceous (Hauterivian, 131.2 Ma)',130),(29,'Early Cretaceous (Valanginian, 136.4 Ma)',135),(30,'Early Cretaceous (Berriasian, 142.4 Ma)',140),(31,'Jurassic/Cretaceous Boundary (145 Ma)',145),(32,'Late Jurassic (Tithonian, 148.6 Ma)',150),(33,'Late Jurassic (Kimmeridgian, 154.7 Ma)',155),(34,'Late Jurassic (Oxfordian, 160.4 Ma)',160),(35,'Middle Jurassic (Callovian, 164.8 Ma)',165),(36,'Middle Jurassic (Bajocian&Bathonian, 168.2)',170),(37,'Middle Jurassic (Aalenian, 172.2 Ma)',175),(38,'Early Jurassic (Toarcian, 178.4 Ma)',180),(39,'Early Jurassic (Pliensbachian, 186.8 Ma)',185),(40,'Early Jurassic (Sinemurian/Pliensbachian, 190.8 Ma)',190),(41,'Early Jurassic (Hettangian&Sinemurian, 196 Ma)',195),(42,'Late Triassic (Rhaetian/Hettangian, 201.3 Ma)',200),(43,'49 Late Triassic (Rhaetian, 204.9 Ma)',205),(44,'Late Triassic (Norian, 213.2 Ma)',210),(45,'Late Triassic (mid Norian, 217.8 Ma)',215),(46,'Late Triassic (early Norian, 222.4 Ma)',220),(47,'Late Triassic (Carnian/Norian 227 Ma)',225),(48,'Late Triassic (Carnian, 232 Ma)',230),(49,'Late Triassic (early Carnian, 233.6)',235),(50,'Middle Triassic (Ladinian, 239.5 Ma)',240),(51,'Middle Triassic (Anisian, 244.6 Ma)',245),(52,'Permo-Triassic Boundary (252 Ma)',250),(53,'Late Permian (Lopingian, 256 Ma)',255),(54,'late Middle Permian (Capitanian, 262.5 Ma)',260),(55,'Middle Permian (Wordian/Capitanian Boundary 265.1 Ma)',265),(56,'Middle Permian (Roadian&Wordian, 268.7 Ma)',270),(57,'Early Permian (late Kungurian, 275 Ma)',275),(58,'Early Permian (early Kungurian, 280 Ma)',280),(59,'Early Permian (Artinskian, 286.8 Ma)',285),(60,'Early Permian (Sakmarian, 292.6 Ma)',290),(61,'Early Permian (Asselian, 297 Ma)',295),(62,'Late Pennsylvanian (Gzhelian, 301.3 Ma)',300),(63,'Late Pennsylvanian (Kasimovian, 305.4 Ma)',305),(64,'Middle Pennsylvanian (Moscovian, 311.1 Ma)',310),(65,'Early/Middle Carboniferous (Baskirian/Moscovian boundary, 314.6 Ma)',315),(66,'Early Pennsylvanian (Bashkirian, 319.2 Ma)',320),(67,'Late Mississippian (Serpukhovian, 327 Ma)',325),(68,'Late Mississippian (Visean/Serpukhovian boundary, 330.9 Ma)',330),(69,'Middle Mississippian (Early Visean, 338.8Ma)',340),(70,'Early Mississippian (Tournaisian, 349 Ma)',350),(71,'Devono-Carboniferous Boundary (358.9 Ma)',360),(72,'Late Devonian (early Famennian, 370 Ma)',370),(73,'Late Devonian (early Frasnian, 380 Ma)',380),(74,'Middle Devonian (Givetian, 385.2 Ma)',385),(75,'Middle Devonian (Eifelian, 390.5 Ma)',390),(76,'Early Devonian (late Emsian, 395 Ma)',395),(77,'Early Devonian (Emsian, 400 Ma)',400),(78,'Early Devonian (Pragian, 409.2 Ma)',410),(79,'Early Devonian (Lochkovian, 415 Ma)',415),(80,'Late Silurian (Pridoli - Ludlow, 425.2 Ma)',420),(81,'Middle Silurian (Wenlock, 430.4 Ma)',425),(82,'Early Silurian (late Llandovery, 430 Ma)',430),(83,'Early Silurian (early Llandovery, 441.2 Ma)',440),(84,'Late Ordovician (Hirnantian, 444.5 Ma) ',445),(85,'Late Ordovician (Sandbian - Katian, 449.1 Ma)',450),(86,'Middle Ordovician (late Darwillian,460 Ma)',460),(87,'Middle Ordovician (early Darwillian,465 Ma)',465),(88,'Early Ordovician (Floian/Dapingianboundary, 470 Ma)',470),(89,'Early Ordovician (Tremadoc, 481.6 Ma)',480),(90,'Cambro-Ordovician Boundary (485.4 Ma)',485),(91,'Late Cambrian (Jiangshanian, 491.8 Ma)',490),(92,'late Middle Cambrian (Guzhangian, 498.8 Ma)',500),(93,'early Middle Cambrian (late Epoch 2, 510 Ma)',510),(94,'Early/Middle Cambrian boundary (520 Ma)',520),(95,'Early Cambrian (middle Terreneuvian, 530 Ma)',530),(96,'Cambrian/Precambrian boundary (541 Ma)',540),(97,'Late Neoproterozoic (middle Ediacaran, 600 Ma)',600),(98,'Middle Neoproterozoic (late Cryogenian, 690 Ma)',690),(99,'Early Neoproterozoic (late Tonian. 750 Ma)',750);

--
-- Table structure for table `stages`
--

CREATE TABLE `stages` (
  `STAGES_CODE` double DEFAULT NULL,
  `TIME_SLICE` double DEFAULT NULL,
  `STAGES` varchar(23) DEFAULT NULL,
  `BASE` double DEFAULT NULL,
  `TOP` double DEFAULT NULL,
  UNIQUE KEY `STAGES_CODE` (`STAGES_CODE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `stages`
--

INSERT INTO `stages` VALUES (1,1,'Nemakit-Daldynian',543,522),(2,1,'Tommotian',522,520),(3,1,'Atdabanian',520,518),(4,1,'Botomian-Toyonian',518,510),(5,2,'Middle Cambrian',510,500),(6,2,'Upper Cambrian',500,490),(7,3,'Upper Cambrian',500,490),(8,3,'Tremadocian',490,483),(9,4,'Arenigian',483,473),(10,4,'lower Middle Ordovician',473,465),(11,5,'Darriwilian',465,458),(12,5,'Caradocian',458,449),(13,5,'Ashgillian',449,443),(14,6,'Llandoverian',443,428),(15,7,'Wenlockian',428,423),(16,7,'Ludlovian',423,419),(17,7,'Pridolian',419,417),(18,8,'Pridolian',419,417),(19,8,'Lochkovian',417,412),(20,8,'Pragian',412,408),(21,9,'Pragian',412,408),(22,9,'Emsian',408,395),(23,9,'Eifelian',395,388),(24,10,'Givetian',388,382),(25,10,'Frasnian',382,374),(26,10,'Famennian',374,362),(27,11,'Famennian',374,362),(28,11,'Tournaisian',362,344),(29,11,'Visean',344,328),(30,12,'Visean',344,328),(31,12,'Serpukhovian',328,323),(32,13,'Bashkirian',323,311),(33,13,'Moscovian',311,303),(34,13,'Kasimovian',303,296),(35,14,'Gzhelian',296,291),(36,14,'Asselian',291,288),(37,15,'Sakmarian',288,283),(38,15,'Artinskian',283,277),(39,15,'Kungurian',277,269),(40,16,'Gudalupian',269,260),(41,16,'Lopingian',260,251),(42,17,'Scythian',251,245),(43,17,'Anisian',245,241),(44,17,'Ladinian',241,230),(45,17,'Carnian',230,219),(46,18,'Carnian',230,219),(47,18,'Norian',219,204),(48,18,'Rhaetian',204,199),(49,18,'Hettangian',199,196),(50,19,'Hettangian',199,196),(51,19,'Sinemurian',196,191),(52,19,'Pliensbachian',191,183),(53,19,'Toarcian',183,178),(54,19,'Aalenian',178,174),(55,20,'Aalenian',178,174),(56,20,'Bajocian',174,166),(57,20,'Bathonian',166,160),(58,21,'Bathonian',166,160),(59,21,'Callovian',160,156),(60,21,'Oxfordian',156,152),(61,21,'Kimmeridgian',152,148),(62,21,'Tithonian',148,141),(63,22,'Tithonian',148,141),(64,22,'Berriasian',141,137),(65,22,'Valanginian',137,132),(66,23,'Valanginian',137,132),(67,23,'Hauterivian',132,127),(68,23,'Barremian',127,121),(69,23,'Aptian',121,112),(70,24,'Aptian',121,112),(71,24,'Albian',112,99),(72,24,'Cenomanian',99,94),(73,25,'Cenomanian',99,94),(74,25,'Turonian',94,89),(75,25,'Coniacian',89,86),(76,25,'Santonian',86,83),(77,25,'Campanian',83,71),(78,26,'Campanian',83,71),(79,26,'Maastrichtian',71,65),(80,26,'Danian-Selandian',65,60),(81,27,'Thanetian',60,54),(82,27,'Ypresian',54,49),(83,28,'Lutetian-Bartonian',49,37),(84,29,'Priabonian',37,33),(85,29,'Rupelian',33,28),(86,30,'Chattian',28,23),(87,30,'Aquitanian',23,20),(88,31,'Burdigalian',20,16),(89,31,'Langhian',16,14),(90,31,'Serravallian',14,11),(91,32,'Tortonian',11,7),(92,32,'Messinian',7,5),(93,32,'Pliocene',5,1);

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(3) DEFAULT NULL,
  `state` varchar(22) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'Afghanistan'),(2,'Albania'),(3,'Algeria'),(4,'Antarctica'),(5,'Antigua and Barbuda'),(6,'Argentina'),(7,'Armenia'),(8,'Atlantic'),(9,'Australia'),(10,'Austria'),(11,'Azerbaijan'),(12,'Bahamas'),(13,'Bangladesh'),(14,'Barbados'),(15,'Belarus'),(16,'Belgium'),(17,'Belize'),(18,'Bermuda'),(19,'Bosnia and Herzegovina'),(20,'Brazil'),(21,'Brunei'),(22,'Bulgaria'),(23,'Burma'),(24,'Burma (Myanmar)'),(25,'Cambodia'),(26,'Canada'),(27,'Chile'),(28,'China'),(29,'Colombia'),(30,'Cook Islands'),(31,'Costa Rica'),(32,'Croatia'),(33,'Cuba'),(34,'Cyprus'),(35,'Czech Republic'),(36,'Denmark'),(37,'Djibouti'),(38,'Dominican Republic'),(39,'Ecuador'),(40,'Egypt'),(41,'Eritrea'),(42,'Estonia'),(43,'Ethiopia'),(44,'Fiji'),(45,'France'),(46,'French Polynesia'),(47,'Georgia'),(48,'Germany'),(49,'Greece'),(50,'Guatemala'),(51,'Haiti'),(52,'Hungary'),(53,'India'),(54,'Indian Ocean'),(55,'Indonesia'),(56,'Iran'),(57,'Iraq'),(58,'Ireland'),(59,'Israel'),(60,'Italy'),(61,'Jamaica'),(62,'Japan'),(63,'Jordan'),(64,'Kazakhstan'),(65,'Kenya'),(66,'Kiribati'),(67,'Korea'),(68,'Kyrgyzstan'),(69,'Laos'),(70,'Latvia'),(71,'Lebanon'),(72,'Lettland'),(73,'Libya'),(74,'Lithuania'),(75,'Luxembourg'),(76,'Macedonia'),(77,'Madagascar'),(78,'Malaysia'),(79,'Maldives'),(80,'Malta'),(81,'Marshall Islands'),(82,'Mauritania'),(83,'Mauritius'),(84,'Mexico'),(85,'Micronesia'),(86,'Moldova'),(87,'Mongolia'),(88,'Morocco'),(89,'Mozambique'),(90,'Namibia'),(91,'Nauru'),(92,'Nepal'),(93,'Netherlands'),(94,'New Caledonia'),(95,'New Zealand'),(96,'Nigeria'),(97,'North Korea'),(98,'Norway'),(99,'Oman'),(100,'Pacific'),(101,'Pakistan'),(102,'Panama'),(103,'Papua New Guinea'),(104,'Peru'),(105,'Philippines'),(106,'Pitcairn'),(107,'Poland'),(108,'Portugal'),(109,'Romania'),(110,'Russia'),(111,'Saint Kitts and Nevis'),(112,'Saudi Arabia'),(113,'Seychelles'),(114,'Singapore'),(115,'Slovakia'),(116,'Slovenia'),(117,'Solomon Islands'),(118,'Somalia'),(119,'South Korea'),(120,'Spain'),(121,'Sudan'),(122,'Sweden'),(123,'Switzerland'),(124,'Syria'),(125,'Taiwan'),(126,'Tajikistan'),(127,'Tanzania'),(128,'Texas'),(129,'Thailand'),(130,'Timor'),(131,'Tonga'),(132,'Trinidad and Tobago'),(133,'Tunisia'),(134,'Turkey'),(135,'Turkmenistan'),(136,'Ukraine'),(137,'United Arab Emirates'),(138,'United Kingdom'),(139,'United States'),(140,'Uzbekistan'),(141,'Vanuatu'),(142,'Venezuela'),(143,'Vietnam'),(144,'Yemen'),(145,'Yugoslavia'),(146,'Andaman Sea'),(NULL,NULL);

--
-- Table structure for table `timescale`
--

CREATE TABLE `timescale` (
  `id` int(2) NOT NULL,
  `sys` varchar(10) DEFAULT NULL,
  `system` varchar(50) DEFAULT NULL,
  `series` varchar(50) DEFAULT NULL,
  `stage` varchar(50) DEFAULT NULL,
  `tens` varchar(50) DEFAULT NULL,
  `short` varchar(20) DEFAULT NULL,
  `gts2004` float DEFAULT NULL,
  `gts2008` float DEFAULT NULL,
  `gts2012` float DEFAULT NULL,
  `gts2016` float DEFAULT NULL,
  `gts2020max` decimal(5,2) DEFAULT NULL,
  `gts2020min` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `timescale`
--

INSERT INTO `timescale` VALUES (1,'E','Ediacaran','Upper Ediacaran','Avalon Assemblage','','Ava',630,635,635,635,635.00,585.00),(2,'E','Ediacaran','Upper Ediacaran','White Sea Assemblage','','Whs',NULL,NULL,NULL,NULL,585.00,556.00),(3,'E','Ediacaran','Upper Ediacaran','Nama Assemblage','','Nam',NULL,NULL,NULL,NULL,556.00,538.80),(4,'Cm','Cambrian','Terreneuvian','Fortunian','Cambrian 1','For',542,542,541,541,538.80,529.00),(5,'Cm','Cambrian','Terreneuvian','Stage 2','Cambrian 2','St2',531,528,529,530,529.00,521.00),(6,'Cm','Cambrian','Series 2','Stage 3','Cambrian 2','St3',522.5,521,521,520,521.00,514.50),(7,'Cm','Cambrian','Series 2','Stage 4','Cambrian 3','St4',513,515,514,514,514.50,509.00),(8,'Cm','Cambrian','Maolingian','Wulian','Cambrian 3','Wul',510,510,509,509,509.00,504.50),(9,'Cm','Cambrian','Maolingian','Drumian','Cambrian 3','Dru',507,506.5,504.5,504.5,504.50,500.50),(10,'Cm','Cambrian','Maolingian','Guzhangian','Cambrian 3','Guz',503,503,500.5,500.5,500.50,497.00),(11,'Cm','Cambrian','Furongian','Paibian','Cambrian 4','Pai',501,499,497,497,497.00,494.20),(12,'Cm','Cambrian','Furongian','Jiangshanian','Cambrian 4','Jia',498,496,494,494,494.20,491.00),(13,'Cm','Cambrian','Furongian','Stage 10','Cambrian 4','Law',491.8,492,489.5,489.5,491.00,486.85),(14,'O','Ordovician','Lower Ordovician','Tremadocian','Ordovician 1','Tre',488.3,488.3,485.37,485.4,486.85,477.08),(15,'O','Ordovician','Lower Ordovician','Floian','Ordovician 2','Flo',478.6,478.6,477.72,477.72,477.08,471.26),(16,'O','Ordovician','Middle Ordovician','Dapingian','Ordovician 2','Dap',471.8,471.8,469.96,469.96,471.26,469.42),(17,'O','Ordovician','Middle Ordovician','Darriwilian','Ordovician 3','Dar',468.1,468.1,467.3,467.3,469.42,458.18),(18,'O','Ordovician','Upper Ordovician','Sandbian','Ordovician 4','Sbd',460.9,460.9,458.36,458.36,458.18,452.75),(19,'O','Ordovician','Upper Ordovician','Katian','Ordovician 4','Kat',455.8,455.8,452.97,452.97,452.75,445.21),(20,'O','Ordovician','Upper Ordovician','Hirnantian','Ordovician 5','Hir',445.6,445.6,445.16,445.16,445.21,443.07),(21,'S','Silurian','Llandovery','Rhuddanian','Silurian 1','Rhu',443.7,443.7,443.83,443.83,443.07,440.49),(22,'S','Silurian','Llandovery','Aeronian','Silurian 1','Aer',439,439,440.77,440.77,440.49,438.59),(23,'S','Silurian','Llandovery','Telychian','Silurian 1','Tel',436,436,438.49,438.49,438.59,432.93),(24,'S','Silurian','Wenlock','Sheinwoodian','Silurian 2','She',428.2,428.2,433.35,433.35,432.93,430.62),(25,'S','Silurian','Wenlock','Homerian','Silurian 2','Hom',426.2,426.2,430.45,430.45,430.62,426.74),(26,'S','Silurian','Ludlow','Gorstian','Silurian 2','Gor',422.9,422.9,427.36,427.36,426.74,425.01),(27,'S','Silurian','Ludlow','Ludfordian','Silurian 2','Lud',421.3,421.3,425.57,425.57,425.01,422.73),(28,'S','Silurian','Pridoli','Pridoli','Silurian 2','Pri',418.7,418.7,422.96,422.96,422.73,419.00),(29,'D','Devonian','Lower Devonian','Lochkovian','Devonian 1','Loc',416,416,419.2,419.2,419.00,412.40),(30,'D','Devonian','Lower Devonian','Pragian','Devonian 1','Pra',411.2,411.2,410.78,410.78,412.40,410.50),(31,'D','Devonian','Lower Devonian','Emsian','Devonian 2','Ems',407,407,407.57,407.57,410.50,394.30),(32,'D','Devonian','Middle Devonian','Eifelian','Devonian 3','Eif',397.5,397.5,393.25,393.25,394.30,385.30),(33,'D','Devonian','Middle Devonian','Givetian','Devonian 3','Giv',391.8,391.8,387.72,387.72,385.30,378.90),(34,'D','Devonian','Upper Devonian','Frasnian','Devonian 4','Fra',385.3,385.3,382.69,382.69,378.90,371.10),(35,'D','Devonian','Upper Devonian','Famennian','Devonian 5','Fam',374.5,374.5,372.24,372.24,371.10,359.30),(36,'C','Carboniferous','Mississippian','Tournaisian','Carboniferous 1','Tou',359.2,359.2,358.94,358.94,359.30,346.73),(37,'C','Carboniferous','Mississippian','Visean','Carboniferous 2','Vis',345.3,345.3,346.73,346.73,346.73,330.34),(38,'C','Carboniferous','Mississippian','Serpukhovian','Carboniferous 3','Ser',326.4,328.3,330.92,330.92,330.34,323.40),(39,'C','Carboniferous','Pennsylvanian','Bashkirian','Carboniferous 4','Bas',318.1,318.1,323.23,323.23,323.40,315.15),(40,'C','Carboniferous','Pennsylvanian','Moscovian','Carboniferous 4','Mos',311.7,311.7,315.16,314.6,315.15,307.02),(41,'C','Carboniferous','Pennsylvanian','Kasimovian','Carboniferous 5','Kas',306.5,307.2,306.99,306.65,307.02,303.68),(42,'C','Carboniferous','Pennsylvanian','Gzhelian','Carboniferous 5','Gzh',303.9,303.4,303.67,303.4,303.68,298.89),(43,'P','Permian','Cisuralian','Asselian','Permian 1','Ass',299,299,298.9,298.9,298.89,293.52),(44,'P','Permian','Cisuralian','Sakmarian','Permian 1','Sak',294.6,294.6,295.53,295.5,293.52,290.51),(45,'P','Permian','Cisuralian','Artinskian','Permian 2','Art',284.4,284.4,290.06,290.06,290.51,283.30),(46,'P','Permian','Cisuralian','Kungurian','Permian 2','Kun',275.6,275.6,279.3,282,283.30,274.37),(47,'P','Permian','Guadalupian','Roadian','Permian 3','Roa',270.6,270.6,272.3,272.3,274.37,269.21),(48,'P','Permian','Guadalupian','Wordian','Permian 3','Wor',268,268,268.8,268.8,269.21,264.34),(49,'P','Permian','Guadalupian','Capitanian','Permian 3','Cap',265.8,265.8,265.1,265.1,264.34,259.55),(50,'P','Permian','Lopingian','Wuchiapingian','Permian 4','Wuc',260.4,260.4,259.81,259.8,259.55,254.24),(51,'P','Permian','Lopingian','Changhsingian','Permian 4','Chg',253.8,253.8,254.2,254.2,254.24,251.90),(52,'Tr','Triassic','Lower Triassic','Induan','Triassic 1','Ind',251,251,252.16,251.9,251.90,249.88),(53,'Tr','Triassic','Lower Triassic','Olenekian','Triassic 1','Ole',249.7,249.5,250.01,249.81,249.88,246.70),(54,'Tr','Triassic','Middle Triassic','Anisian','Triassic 2','Ani',245,245.9,247.06,246.8,246.70,241.46),(55,'Tr','Triassic','Middle Triassic','Ladinian','Triassic 2','Lad',237,237,241.5,241.5,241.46,237.00),(56,'Tr','Triassic','Upper Triassic','Carnian','Triassic 3','Car',228,228.7,237,237,237.00,227.30),(57,'Tr','Triassic','Upper Triassic','Norian','Triassic 4','Nor',216.5,216.5,228.35,228.45,227.30,205.74),(58,'Tr','Triassic','Upper Triassic','Rhaetian','Triassic 4','Rha',203.6,203.6,209.46,205.81,205.74,201.36),(59,'J','Jurassic','Lower Jurassic','Hettangian','Jurassic 1','Het',199.6,199.6,201.3,201.36,201.36,199.46),(60,'J','Jurassic','Lower Jurassic','Sinemurian','Jurassic 1','Sin',196.5,196.5,199.3,199.4,199.46,192.90),(61,'J','Jurassic','Lower Jurassic','Pliensbachian','Jurassic 2','Plb',189.6,189.6,190.82,191.36,192.90,184.20),(62,'J','Jurassic','Lower Jurassic','Toarcian','Jurassic 3','Toa',183,183,182.7,183.7,184.20,174.70),(63,'J','Jurassic','Middle Jurassic','Aalenian','Jurassic 3','Aal',175.6,175.6,174.15,174.15,174.70,170.90),(64,'J','Jurassic','Middle Jurassic','Bajocian','Jurassic 4','Baj',171.6,171.6,170.3,170.3,170.90,168.17),(65,'J','Jurassic','Middle Jurassic','Bathonian','Jurassic 4','Bat',167.7,167.7,168.28,168.28,168.17,165.29),(66,'J','Jurassic','Middle Jurassic','Callovian','Jurassic 5','Cal',164.7,164.7,166.07,166.07,165.29,161.53),(67,'J','Jurassic','Upper Jurassic','Oxfordian','Jurassic 5','Oxf',161.2,161.2,163.47,163.47,161.53,154.78),(68,'J','Jurassic','Upper Jurassic','Kimmeridgian','Jurassic 5','Kim',154.6,154.6,157.3,157.3,154.78,149.24),(69,'J','Jurassic','Upper Jurassic','Tithonian','Jurassic 6','Tit',150.8,150.8,152.06,152.06,149.24,143.10),(70,'K','Cretaceous','Lower Cretaceous','Berriasian','Cretaceous 1','Ber',145.5,145.5,145.01,145.73,143.10,137.70),(71,'K','Cretaceous','Lower Cretaceous','Valanginian','Cretaceous 2','Val',136.4,136.4,140.18,139.39,137.70,132.60),(72,'K','Cretaceous','Lower Cretaceous','Hauterivian','Cretaceous 2','Hau',130,133.9,133.88,134.69,132.60,126.50),(73,'K','Cretaceous','Lower Cretaceous','Barremian','Cretaceous 3','Bar',125,125,130.77,130.77,126.50,121.40),(74,'K','Cretaceous','Lower Cretaceous','Aptian','Cretaceous 3','Apt',121,121,126.3,126.3,121.40,113.20),(75,'K','Cretaceous','Lower Cretaceous','Albian','Cretaceous 4','Alb',112,112,112.95,113.14,113.20,100.50),(76,'K','Cretaceous','Upper Cretaceous','Cenomanian','Cretaceous 5','Cen',99.6,99.6,100.5,100.5,100.50,93.90),(77,'K','Cretaceous','Upper Cretaceous','Turonian','Cretaceous 6','Tur',93.5,93.5,93.9,93.9,93.90,89.39),(78,'K','Cretaceous','Upper Cretaceous','Coniacian','Cretaceous 6','Con',89.3,88.6,89.77,89.75,89.39,85.70),(79,'K','Cretaceous','Upper Cretaceous','Santonian','Cretaceous 6','San',85.8,85.8,86.26,86.26,85.70,83.65),(80,'K','Cretaceous','Upper Cretaceous','Campanian','Cretaceous 7','Cam',83.5,83.5,83.64,84.19,83.65,72.17),(81,'K','Cretaceous','Upper Cretaceous','Maastrichtian','Cretaceous 8','Maa',70.6,70.6,72.05,72.05,72.17,66.04),(82,'Pg','Paleogene','Paleocene','Danian','Cenozoic 1','Dan',65.5,65.5,66.04,66.04,66.04,59.24),(83,'Pg','Paleogene','Paleocene','Selandian-Thanetian','Cenozoic 1','Se-Th',61.7,61.7,61.6,61.6,59.24,56.00),(84,'Pg','Paleogene','Eocene','Ypresian','Cenozoic 2','Ypr',55.8,55.8,55.96,55.96,56.00,48.07),(85,'Pg','Paleogene','Eocene','Lutetian','Cenozoic 2','Lut',48.6,48.6,47.82,47.84,48.07,41.03),(86,'Pg','Paleogene','Eocene','Bartonian','Cenozoic 3','Brt',40.4,40.4,41.2,41.03,41.03,37.71),(87,'Pg','Paleogene','Eocene','Priabonian','Cenozoic 3','Prb',37.2,37.2,37.8,37.99,37.71,33.90),(88,'Pg','Paleogene','Oligocene','Rupelian','Cenozoic 4','Rup',33.9,33.9,33.89,33.9,33.90,27.29),(89,'Pg','Paleogene','Oligocene','Chattian','Cenozoic 4','Cht',28.45,28.45,28.01,28.01,27.29,23.04),(90,'Ng','Neogene','Miocene','Lower Miocene','Cenozoic 5','Lmi',23.03,23.03,23.03,23.03,23.04,15.99),(91,'Ng','Neogene','Miocene','Middle Miocene','Cenozoic 5','Mmi',15.97,15.97,15.97,15.97,15.99,11.63),(92,'Ng','Neogene','Miocene','Upper Miocene','Cenozoic 6','Umi',11.6,11.6,11.63,11.625,11.63,5.34),(93,'Ng','Neogene','Pliocene','Pliocene','Cenozoic 6','Pli',5.33,5.33,5.333,5.333,5.34,2.58),(94,'','Quarternary','Pleistocene','Pleistocene','Cenozoic 6','Ple',2.59,2.59,2.59,2.58,2.58,0.01),(95,'','Quarternary','Holocene','Holocene','Cenozoic 6','Hol',0.115,0.115,0.0118,0.0118,0.01,0.00);


