INSERT INTO `sample` VALUES (354,242169,0.8,NULL,'calcite','not applicable'),(354,242170,0.8,NULL,'calcite','not applicable'),(354,242171,0.8,NULL,'calcite','not applicable'),(354,242172,0.8,NULL,'calcite','not applicable'),(354,242173,0.8,NULL,'calcite','not applicable'),(354,242174,0.8,NULL,'calcite','not applicable'),(354,242175,0.8,NULL,'calcite','not applicable'),(354,242176,0.8,NULL,'calcite','not applicable'),(354,242177,0.8,NULL,'calcite','not applicable'),(354,242178,0.8,NULL,'calcite','not applicable'),(354,242179,0.8,NULL,'calcite','not applicable'),(354,242180,0.8,NULL,'calcite','not applicable'),(354,242181,0.8,NULL,'calcite','not applicable'),(354,242182,0.8,NULL,'calcite','not applicable'),(354,242183,0.8,NULL,'calcite','not applicable'),(354,242184,0.8,NULL,'calcite','not applicable'),(354,242185,0.8,NULL,'calcite','not applicable'),(354,242186,0.8,NULL,'calcite','not applicable'),(354,242187,0.8,NULL,'calcite','not applicable'),(354,242188,0.8,NULL,'calcite','not applicable'),(354,242189,0.8,NULL,'calcite','not applicable'),(354,242190,0.8,NULL,'calcite','not applicable'),(354,242191,0.8,NULL,'calcite','not applicable'),(354,242192,0.8,NULL,'calcite','not applicable'),(354,242193,0.8,NULL,'calcite','not applicable'),(354,242194,0.8,NULL,'calcite','not applicable'),(354,242195,0.8,NULL,'calcite','not applicable'),(354,242196,0.8,NULL,'calcite','not applicable'),(354,242197,0.8,NULL,'calcite','not applicable'),(354,242198,0.8,NULL,'calcite','not applicable'),(354,242199,0.8,NULL,'calcite','not applicable'),(354,242200,0.8,NULL,'calcite','not applicable'),(354,242201,0.8,NULL,'calcite','not applicable'),(354,242202,0.8,NULL,'calcite','not applicable'),(354,242203,0.8,NULL,'calcite','not applicable'),(354,242204,0.8,NULL,'calcite','not applicable'),(354,242205,0.8,NULL,'calcite','not applicable'),(354,242206,0.8,NULL,'calcite','not applicable'),(354,242207,0.8,NULL,'calcite','not applicable'),(354,242208,0.8,NULL,'calcite','not applicable'),(354,242209,0.8,NULL,'calcite','not applicable'),(354,242210,0.8,NULL,'calcite','not applicable'),(354,242211,0.8,NULL,'calcite','not applicable'),(354,242212,0.8,NULL,'calcite','not applicable'),(354,242213,0.8,NULL,'calcite','not applicable'),(354,242214,0.8,NULL,'calcite','not applicable'),(354,242215,0.8,NULL,'calcite','not applicable'),(354,242216,0.8,NULL,'calcite','not applicable'),(354,242217,0.8,NULL,'calcite','not applicable'),(354,242218,0.8,NULL,'calcite','not applicable'),(354,242219,0.8,NULL,'calcite','not applicable'),(354,242220,0.8,NULL,'calcite','not applicable'),(354,242221,0.8,NULL,'calcite','not applicable'),(354,242222,0.8,NULL,'calcite','not applicable'),(354,242223,0.8,NULL,'calcite','not applicable'),(354,242224,0.8,NULL,'calcite','not applicable'),(354,242225,0.8,NULL,'calcite','not applicable'),(354,242226,0.8,NULL,'calcite','not applicable'),(354,242227,0.8,NULL,'calcite','not applicable'),(354,242228,0.8,NULL,'calcite','not applicable'),(354,242229,0.8,NULL,'calcite','not applicable'),(354,242230,0.8,NULL,'calcite','not applicable'),(354,242231,0.8,NULL,'calcite','not applicable'),(354,242232,0.8,NULL,'calcite','not applicable'),(354,242233,0.8,NULL,'calcite','not applicable'),(354,242234,0.8,NULL,'calcite','not applicable'),(354,242235,0.8,NULL,'calcite','not applicable'),(354,242236,0.8,NULL,'calcite','not applicable'),(354,242237,0.8,NULL,'calcite','not applicable'),(354,242238,0.8,NULL,'calcite','not applicable'),(354,242239,0.8,NULL,'calcite','not applicable'),(354,242240,0.8,NULL,'calcite','not applicable'),(354,242241,0.8,NULL,'calcite','not applicable'),(354,242242,0.8,NULL,'calcite','not applicable'),(354,242243,0.8,NULL,'calcite','not applicable'),(354,242244,0.8,NULL,'calcite','not applicable'),(354,242245,0.8,NULL,'calcite','not applicable'),(354,242246,0.8,NULL,'calcite','not applicable'),(354,242247,0.8,NULL,'calcite','not applicable'),(354,242248,0.8,NULL,'calcite','not applicable'),(354,242249,0.8,NULL,'calcite','not applicable'),(354,242250,0.8,NULL,'calcite','not applicable'),(354,242251,0.8,NULL,'calcite','not applicable'),(354,242252,0.8,NULL,'calcite','not applicable'),(354,242253,0.8,NULL,'calcite','not applicable'),(354,242254,0.8,NULL,'calcite','not applicable'),(354,242255,0.8,NULL,'calcite','not applicable'),(354,242256,0.8,NULL,'calcite','not applicable'),(354,242257,0.8,NULL,'calcite','not applicable'),(354,242258,0.8,NULL,'calcite','not applicable'),(354,242259,0.8,NULL,'calcite','not applicable'),(354,242260,0.8,NULL,'calcite','not applicable'),(354,242261,0.8,NULL,'calcite','not applicable'),(354,242262,0.8,NULL,'calcite','not applicable'),(354,242263,0.8,NULL,'calcite','not applicable'),(354,242264,0.8,NULL,'calcite','not applicable'),(354,242265,0.8,NULL,'calcite','not applicable'),(354,242266,0.8,NULL,'calcite','not applicable'),(354,242267,0.8,NULL,'calcite','not applicable'),(354,242268,0.8,NULL,'calcite','not applicable'),(354,242269,0.8,NULL,'calcite','not applicable'),(354,242270,0.8,NULL,'calcite','not applicable'),(354,242271,0.8,NULL,'calcite','not applicable'),(354,242272,0.8,NULL,'calcite','not applicable'),(354,242273,0.8,NULL,'calcite','not applicable'),(354,242274,0.8,NULL,'calcite','not applicable'),(354,242275,0.8,NULL,'calcite','not applicable'),(354,242276,0.8,NULL,'calcite','not applicable'),(354,242277,0.8,NULL,'calcite','not applicable'),(354,242278,0.8,NULL,'calcite','not applicable'),(354,242279,0.8,NULL,'calcite','not applicable'),(354,242280,0.8,NULL,'calcite','not applicable'),(354,242281,0.8,NULL,'calcite','not applicable'),(354,242282,0.8,NULL,'calcite','not applicable'),(354,242283,0.8,NULL,'calcite','not applicable'),(354,242284,0.8,NULL,'calcite','not applicable'),(354,242285,0.8,NULL,'calcite','not applicable'),(354,242286,0.8,NULL,'calcite','not applicable'),(354,242287,0.8,NULL,'calcite','not applicable'),(354,242288,0.8,NULL,'calcite','not applicable'),(354,242289,0.8,NULL,'calcite','not applicable'),(354,242290,0.8,NULL,'calcite','not applicable'),(354,242291,0.8,NULL,'calcite','not applicable'),(354,242292,0.8,NULL,'calcite','not applicable'),(354,242293,0.8,NULL,'calcite','not applicable'),(354,242294,0.8,NULL,'calcite','not applicable'),(354,242295,0.8,NULL,'calcite','not applicable'),(354,242296,0.8,NULL,'calcite','not applicable'),(354,242297,0.8,NULL,'calcite','not applicable'),(354,242298,0.8,NULL,'calcite','not applicable'),(354,242299,0.8,NULL,'calcite','not applicable'),(354,242300,0.8,NULL,'calcite','not applicable'),(354,242301,0.8,NULL,'calcite','not applicable'),(354,242302,0.8,NULL,'calcite','not applicable'),(354,242303,0.8,NULL,'calcite','not applicable'),(354,242304,0.8,NULL,'calcite','not applicable'),(354,242305,0.8,NULL,'calcite','not applicable'),(354,242306,0.8,NULL,'calcite','not applicable'),(354,242307,0.8,NULL,'calcite','not applicable'),(354,242308,0.8,NULL,'calcite','not applicable'),(354,242309,0.8,NULL,'calcite','not applicable'),(354,242310,0.8,NULL,'calcite','not applicable'),(354,242311,0.8,NULL,'calcite','not applicable'),(354,242312,0.8,NULL,'calcite','not applicable'),(354,242313,0.8,NULL,'calcite','not applicable'),(354,242314,0.8,NULL,'calcite','not applicable'),(354,242315,0.8,NULL,'calcite','not applicable'),(354,242316,0.8,NULL,'calcite','not applicable'),(354,242317,0.8,NULL,'calcite','not applicable'),(354,242318,0.8,NULL,'calcite','not applicable'),(354,242319,0.8,NULL,'calcite','not applicable'),(354,242320,0.8,NULL,'calcite','not applicable'),(354,242321,0.8,NULL,'calcite','not applicable'),(354,242322,0.8,NULL,'calcite','not applicable'),(354,242323,0.8,NULL,'calcite','not applicable'),(354,242324,0.8,NULL,'calcite','not applicable'),(354,242325,0.8,NULL,'calcite','not applicable'),(354,242326,0.8,NULL,'calcite','not applicable'),(354,242327,0.8,NULL,'calcite','not applicable'),(354,242328,0.8,NULL,'calcite','not applicable'),(354,242329,0.8,NULL,'calcite','not applicable'),(354,242330,0.8,NULL,'calcite','not applicable'),(354,242331,0.8,NULL,'calcite','not applicable'),(354,242332,0.8,NULL,'calcite','not applicable'),(354,242333,0.8,NULL,'calcite','not applicable'),(354,242334,0.8,NULL,'calcite','not applicable'),(354,242335,0.8,NULL,'calcite','not applicable'),(354,242336,0.8,NULL,'calcite','not applicable'),(354,242337,0.8,NULL,'calcite','not applicable'),(354,242338,0.8,NULL,'calcite','not applicable'),(354,242339,0.8,NULL,'calcite','not applicable'),(354,242340,0.8,NULL,'calcite','not applicable'),(354,242341,0.8,NULL,'calcite','not applicable'),(354,242342,0.8,NULL,'calcite','not applicable'),(354,242343,0.8,NULL,'calcite','not applicable'),(354,242344,0.8,NULL,'calcite','not applicable'),(354,242345,0.8,NULL,'calcite','not applicable'),(354,242346,0.8,NULL,'calcite','not applicable'),(354,242347,0.8,NULL,'calcite','not applicable'),(354,242348,0.8,NULL,'calcite','not applicable'),(354,242349,0.8,NULL,'calcite','not applicable'),(354,242350,0.8,NULL,'calcite','not applicable'),(354,242351,0.8,NULL,'calcite','not applicable'),(354,242352,0.8,NULL,'calcite','not applicable'),(354,242353,0.8,NULL,'calcite','not applicable'),(354,242354,0.8,NULL,'calcite','not applicable'),(354,242355,0.8,NULL,'calcite','not applicable'),(354,242356,0.8,NULL,'calcite','not applicable'),(354,242357,0.8,NULL,'calcite','not applicable'),(354,242358,0.8,NULL,'calcite','not applicable'),(354,242359,0.8,NULL,'calcite','not applicable'),(354,242360,0.8,NULL,'calcite','not applicable'),(354,242361,0.8,NULL,'calcite','not applicable'),(354,242362,0.8,NULL,'calcite','not applicable'),(354,242363,0.8,NULL,'calcite','not applicable'),(354,242364,0.8,NULL,'calcite','not applicable'),(354,242365,0.8,NULL,'calcite','not applicable'),(354,242366,0.8,NULL,'calcite','not applicable'),(354,242367,0.8,NULL,'calcite','not applicable'),(354,242368,0.8,NULL,'calcite','not applicable'),(354,242369,0.8,NULL,'calcite','not applicable'),(354,242370,0.8,NULL,'calcite','not applicable'),(354,242371,0.8,NULL,'calcite','not applicable'),(354,242372,0.8,NULL,'calcite','not applicable'),(354,242373,0.8,NULL,'calcite','not applicable'),(354,242374,0.8,NULL,'calcite','not applicable'),(354,242375,0.8,NULL,'calcite','not applicable'),(354,242376,0.8,NULL,'calcite','not applicable'),(354,242377,0.8,NULL,'calcite','not applicable'),(354,242378,0.8,NULL,'calcite','not applicable'),(354,242379,0.8,NULL,'calcite','not applicable'),(354,242380,0.8,NULL,'calcite','not applicable'),(354,242381,0.8,NULL,'calcite','not applicable'),(354,242382,0.8,NULL,'calcite','not applicable'),(354,242383,0.8,NULL,'calcite','not applicable'),(354,242384,0.8,NULL,'calcite','not applicable'),(354,242385,0.8,NULL,'calcite','not applicable'),(354,242386,0.8,NULL,'calcite','not applicable'),(354,242387,0.8,NULL,'calcite','not applicable'),(354,242388,0.8,NULL,'calcite','not applicable'),(354,242389,0.8,NULL,'calcite','not applicable'),(354,242390,0.8,NULL,'calcite','not applicable'),(354,242391,0.8,NULL,'calcite','not applicable'),(354,242392,0.8,NULL,'calcite','not applicable'),(354,242393,0.8,NULL,'calcite','not applicable'),(354,242394,0.8,NULL,'calcite','not applicable'),(354,242395,0.8,NULL,'calcite','not applicable'),(354,242396,0.8,NULL,'calcite','not applicable'),(354,242397,0.8,NULL,'calcite','not applicable'),(354,242398,0.8,NULL,'calcite','not applicable'),(354,242399,0.8,NULL,'calcite','not applicable'),(354,242400,0.8,NULL,'calcite','not applicable'),(354,242401,0.8,NULL,'calcite','not applicable'),(354,242402,0.8,NULL,'calcite','not applicable'),(354,242403,0.8,NULL,'calcite','not applicable'),(354,242404,0.8,NULL,'calcite','not applicable'),(354,242405,0.8,NULL,'calcite','not applicable'),(354,242406,0.8,NULL,'calcite','not applicable'),(354,242407,0.8,NULL,'calcite','not applicable'),(354,242408,0.8,NULL,'calcite','not applicable'),(354,242409,0.8,NULL,'calcite','not applicable'),(354,242410,0.8,NULL,'calcite','not applicable'),(354,242411,0.8,NULL,'calcite','not applicable'),(354,242412,0.8,NULL,'calcite','not applicable'),(354,242413,0.8,NULL,'calcite','not applicable'),(354,242414,0.8,NULL,'calcite','not applicable'),(354,242415,0.8,NULL,'calcite','not applicable'),(354,242416,0.8,NULL,'calcite','not applicable'),(354,242417,0.8,NULL,'calcite','not applicable'),(354,242418,0.8,NULL,'calcite','not applicable'),(354,242419,0.8,NULL,'calcite','not applicable'),(354,242420,0.8,NULL,'calcite','not applicable'),(354,242421,0.8,NULL,'calcite','not applicable'),(354,242422,0.8,NULL,'calcite','not applicable'),(354,242423,0.8,NULL,'calcite','not applicable'),(354,242424,0.8,NULL,'calcite','not applicable'),(354,242425,0.8,NULL,'calcite','not applicable'),(354,242426,0.8,NULL,'calcite','not applicable'),(354,242427,0.8,NULL,'calcite','not applicable'),(354,242428,0.8,NULL,'calcite','not applicable'),(354,242429,0.8,NULL,'calcite','not applicable'),(354,242430,0.8,NULL,'calcite','not applicable'),(354,242431,0.8,NULL,'calcite','not applicable'),(354,242432,0.8,NULL,'calcite','not applicable'),(354,242433,0.8,NULL,'calcite','not applicable'),(354,242434,0.8,NULL,'calcite','not applicable'),(354,242435,0.8,NULL,'calcite','not applicable'),(354,242436,0.8,NULL,'calcite','not applicable'),(354,242437,0.8,NULL,'calcite','not applicable'),(354,242438,0.8,NULL,'calcite','not applicable'),(354,242439,0.8,NULL,'calcite','not applicable'),(354,242440,0.8,NULL,'calcite','not applicable'),(354,242441,0.8,NULL,'calcite','not applicable'),(354,242442,0.8,NULL,'calcite','not applicable'),(354,242443,0.8,NULL,'calcite','not applicable'),(354,242444,0.8,NULL,'calcite','not applicable'),(354,242445,0.8,NULL,'calcite','not applicable'),(354,242446,0.8,NULL,'calcite','not applicable'),(354,242447,0.8,NULL,'calcite','not applicable'),(354,242448,0.8,NULL,'calcite','not applicable'),(354,242449,0.8,NULL,'calcite','not applicable'),(354,242450,0.8,NULL,'calcite','not applicable'),(354,242451,0.8,NULL,'calcite','not applicable'),(354,242452,0.8,NULL,'calcite','not applicable'),(354,242453,0.8,NULL,'calcite','not applicable'),(354,242454,0.8,NULL,'calcite','not applicable'),(354,242455,0.8,NULL,'calcite','not applicable'),(354,242456,0.8,NULL,'calcite','not applicable'),(354,242457,0.8,NULL,'calcite','not applicable'),(354,242458,0.8,NULL,'calcite','not applicable'),(354,242459,0.8,NULL,'calcite','not applicable'),(354,242460,0.8,NULL,'calcite','not applicable'),(354,242461,0.8,NULL,'calcite','not applicable'),(354,242462,0.8,NULL,'calcite','not applicable'),(354,242463,0.8,NULL,'calcite','not applicable'),(354,242464,0.8,NULL,'calcite','not applicable'),(354,242465,0.8,NULL,'calcite','not applicable'),(354,242466,0.8,NULL,'calcite','not applicable'),(354,242467,0.8,NULL,'calcite','not applicable'),(354,242468,0.8,NULL,'calcite','not applicable'),(354,242469,0.8,NULL,'calcite','not applicable'),(354,242470,0.8,NULL,'calcite','not applicable'),(354,242471,0.8,NULL,'calcite','not applicable'),(354,242472,0.8,NULL,'calcite','not applicable'),(354,242473,0.8,NULL,'calcite','not applicable'),(354,242474,0.8,NULL,'calcite','not applicable'),(354,242475,0.8,NULL,'calcite','not applicable'),(354,242476,0.8,NULL,'calcite','not applicable'),(354,242477,0.8,NULL,'calcite','not applicable'),(354,242478,0.8,NULL,'calcite','not applicable'),(354,242479,0.8,NULL,'calcite','not applicable'),(354,242480,0.8,NULL,'calcite','not applicable'),(354,242481,0.8,NULL,'calcite','not applicable'),(354,242482,0.8,NULL,'calcite','not applicable'),(354,242483,0.8,NULL,'calcite','not applicable'),(354,242484,0.8,NULL,'calcite','not applicable'),(354,242485,0.8,NULL,'calcite','not applicable'),(354,242486,0.8,NULL,'calcite','not applicable'),(354,242487,0.8,NULL,'calcite','not applicable'),(354,242488,0.8,NULL,'calcite','not applicable'),(107,242489,NULL,61.845,NULL,NULL),(319,242490,NULL,333.1,NULL,NULL),(320,242491,NULL,197.5,NULL,NULL);
/*!40000 ALTER TABLE `sample` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site`
--

DROP TABLE IF EXISTS `site`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site` (
  `site_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(200) DEFAULT NULL,
  `latitude` decimal(6,4) DEFAULT NULL,
  `longitude` decimal(7,4) DEFAULT NULL,
  `elevation` decimal(10,1) DEFAULT NULL,
  `geology` enum('limestone','dolomite','gypsum','magmatic','marble','granite','mixed','other','unknown') DEFAULT NULL,
  `rock_age` enum('Holocene','Pleistocene','Pliocene','Miocene','Oligocene','Eocene','Palaeocene','Cretaceous','Jurassic','Triassic','Permian','Carboniferous','Devonian','Silurian','Ordovician','Cambrian','Precambrian','unknown') DEFAULT NULL,
  `monitoring` enum('yes','no','unknown') DEFAULT NULL,
  PRIMARY KEY (`site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site`
--

LOCK TABLES `site` WRITE;
/*!40000 ALTER TABLE `site` DISABLE KEYS */;
INSERT INTO `site` VALUES (1,'Bittoo cave',30.7903,77.7764,3000.0,'limestone','Pleistocene','yes'),(2,'Kesang cave',42.8700,81.7500,2000.0,'unknown','Pleistocene','no'),(3,'Paraiso cave',-4.0667,-55.4500,60.0,'limestone','Carboniferous','yes'),(4,'Villars cave',45.4300,0.7800,175.0,'limestone','Jurassic','yes'),(5,'Yangkou cave',29.0333,107.1833,2140.0,'limestone','Permian','yes'),(6,'Hulu cave',32.5000,119.1700,90.0,'unknown','unknown','unknown'),(7,'Cold Air cave',-24.0000,29.1833,1420.0,'dolomite','Precambrian','yes'),(8,'Lancaster Hole',54.2209,-2.5168,294.0,'limestone','Carboniferous','yes'),(9,'Tonnel’naya cave',38.4000,67.2300,3226.0,'unknown','Pleistocene','no'),(10,'Jaraguá cave',-21.0830,-56.5830,570.0,'limestone','unknown','yes'),(11,'Jeita cave',33.9500,35.6500,100.0,'limestone','Pleistocene','no'),(12,'Mawmluh cave',25.2622,91.8817,1160.0,'limestone','Eocene','yes'),(13,'Ball Gown cave',-17.3000,124.1000,100.0,'limestone','Devonian','no'),(14,'Lehman caves',39.0100,-114.2199,2080.0,'limestone','Cambrian','yes'),(15,'Baschg cave',47.2501,9.6667,780.0,'limestone','Cretaceous','no'),(16,'Han-sur-Lesse cave',50.1164,5.1884,180.0,'limestone','Devonian','no'),(17,'Huangye cave',33.5833,105.1167,1650.0,'unknown','unknown','no'),(18,'Abissal cave',-5.6000,-37.7330,100.0,'limestone','unknown','no'),(19,'Kanaan cave',33.9069,35.6069,98.0,'limestone','Jurassic','yes'),(20,'Secret cave',4.0848,114.8503,250.0,'limestone','unknown','unknown'),(21,'Uamh an Tartair',58.1400,4.9300,220.0,'dolomite','Ordovician','yes'),(22,'RukieSSa cave',8.6036,40.3772,1618.0,'limestone','Jurassic','yes'),(23,'Lapa grande cave',-14.4200,-44.3660,590.0,'limestone','Precambrian','no'),(24,'Lapa sem fim cave',-16.1503,-44.6281,341.0,'limestone','Precambrian','yes'),(25,'Palestina cave',-5.9200,-77.3500,870.0,'limestone','Triassic','yes'),(26,'Okshola cave',67.0000,15.0000,165.0,'marble','unknown','no'),(27,'Tamboril cave',-16.0000,-47.0000,200.0,'dolomite','Precambrian','yes'),(28,'Valmiki cave ',15.1500,77.8167,420.0,'dolomite','Precambrian','no'),(29,'Mairs cave',-32.1600,138.8300,475.0,'limestone','Cambrian','no'),(30,'Lobatse cave',-25.2100,25.6800,1200.0,'dolomite','unknown','no'),(31,'Abaliget cave',46.1300,18.1200,209.0,'limestone','Triassic','yes'),(32,'Anjokipoty cave',-15.5784,46.7344,NULL,'limestone','unknown','no'),(33,'Bero cave',8.4241,40.3073,1363.0,'limestone','Jurassic','yes'),(34,'Cueva del Diablo',18.1920,-99.9210,1030.0,'unknown','Cretaceous','no'),(35,'Curupira cave',-15.2002,-56.7839,420.0,'limestone','unknown','no'),(36,'Dayu cave',33.1330,106.3000,870.0,'dolomite','Precambrian','no'),(37,'DeSoto caverns',33.3722,-86.3667,150.0,'dolomite','Ordovician','unknown'),(38,'Diva cave',-12.3667,-41.5667,680.0,'limestone','unknown','no'),(39,'Dongge cave',25.2800,108.0800,680.0,'unknown','Pleistocene','no'),(40,'Excentrica cave',37.1000,-7.7700,100.0,'limestone','Cretaceous','yes'),(41,'Fukugaguchi cave',36.9917,137.8000,170.0,'limestone','Permian','yes'),(42,'Ifoulki cave',30.7080,-9.3275,1250.0,'limestone','unknown','no'),(43,'Kalakot cave',33.2219,74.4258,826.0,'limestone','Precambrian','no'),(44,'Kapsia cave',37.6233,22.3539,700.0,'limestone','Triassic','yes'),(45,'Kulishu cave',39.6800,115.6500,610.0,'dolomite','Precambrian','no'),(46,'Labyrintgrottan cave',66.0600,14.6800,730.0,'limestone','Ordovician','no'),(47,'Larshullet cave',66.0000,14.0000,400.0,'marble','unknown','no'),(48,'Leviathan cave',37.8900,-115.5800,2400.0,'limestone','Devonian','yes'),(49,'McLean\'s cave',38.0700,-120.4200,300.0,'limestone','Triassic','no'),(50,'Moaning cave',38.0717,-120.4655,520.0,'limestone','Triassic','no'),(51,'Natural Bridge caverns',29.6900,-98.3400,306.0,'limestone','Cretaceous','yes'),(52,'Pau d\'Alho cave',-15.2055,-56.8000,340.0,'limestone','unknown','no'),(53,'Pippikin Pot cave',54.2143,-2.5123,320.0,'limestone','Carboniferous','yes'),(54,'Sahiya cave',30.6000,77.8667,1190.0,'unknown','unknown','no'),(55,'Sieben Hengste cave',46.7500,7.8100,1955.0,'limestone','Cretaceous','unknown'),(56,'Skala Marion cave',40.6387,24.5144,41.0,'limestone','Miocene','unknown'),(57,'Soylegrotta cave',66.0000,14.0000,280.0,'marble','unknown','yes'),(58,'Spannagel cave',47.0800,11.6700,2310.0,'marble','Jurassic','no'),(59,'Suozi cave',32.4300,107.1700,700.0,'limestone','Permian','no'),(60,'Taurius cave',-15.5333,167.0167,230.0,'unknown','unknown','no'),(61,'Timta cave',29.8381,82.0336,1900.0,'unknown','unknown','no'),(62,'Torrinha cave',-12.3667,-41.5667,680.0,'limestone','unknown','unknown'),(63,'Tzabnah cave',20.7300,-89.7160,20.0,'unknown','unknown','unknown'),(64,'Wah Shikhar cave',25.2500,91.8667,1290.0,'unknown','unknown','no'),(65,'Whiterock cave',4.1500,114.8600,NULL,'limestone','unknown','unknown'),(66,'White Scar cave',54.1656,-2.4419,255.0,'limestone','Carboniferous','yes'),(67,'Clearwater/Wind caves connection',4.1000,114.8300,NULL,'limestone','unknown','unknown'),(68,'Jerusalem west cave',31.7833,35.1500,700.0,'dolomite','Cretaceous','unknown'),(69,'Xinglong cave',40.5000,117.5000,710.0,'dolomite','Precambrian','yes'),(70,'Abaco Island cave',26.2300,-77.1600,-45.0,'limestone','Pleistocene','no'),(71,'Baradla cave',48.4667,20.5000,375.0,'limestone','Triassic','yes'),(72,'Ascunsa cave',45.0000,22.6000,1050.0,'limestone','Cretaceous','yes'),(73,'Bourgeois–Delaunay cave',45.6678,0.5133,100.0,'limestone','Jurassic','no'),(74,'Cango cave',-33.3925,22.2147,NULL,'limestone','Precambrian','no'),(75,'Cave Without a Name',29.8852,-98.6208,377.0,'limestone','Cretaceous','yes'),(76,'Ceremosnja cave',44.4000,21.6500,530.0,'limestone','Cretaceous','yes'),(77,'Chauvet cave',44.2300,4.2600,240.0,'limestone','Cretaceous','yes'),(78,'Chilibrillo cave',9.1741,-79.6164,60.0,'unknown','unknown','no'),(79,'Dim cave',36.5340,32.1056,232.0,'limestone','Permian','no'),(80,'Furong cave',29.2289,107.9036,480.0,'dolomite','Cambrian','yes'),(81,'Gueldaman cave',36.4333,4.5667,507.0,'limestone','Jurassic','no'),(82,'Hollywood cave',-41.9500,171.4667,130.0,'unknown','unknown','no'),(83,'La Mine cave',36.0300,9.6800,975.0,'limestone','Cretaceous','no'),(84,'Leany cave',47.7000,18.8400,420.0,'limestone','Triassic','no'),(85,'Macal Chasm',16.8830,-89.1080,530.0,'limestone','Cretaceous','unknown'),(86,'Modric cave',44.2568,15.5372,32.0,'limestone','Cretaceous','yes'),(87,'Pindal cave',43.4000,-4.5300,24.0,'limestone','Carboniferous','yes'),(88,'Postojna cave',45.7700,14.2000,529.0,'limestone','Cretaceous','yes'),(89,'New St Michael\'s cave',36.1261,-5.3455,325.0,'limestone','Jurassic','yes'),(90,'Trio cave',46.1100,18.1500,275.0,'limestone','Triassic','no'),(91,'Ursilor cave',46.5537,22.5695,482.0,'limestone','Jurassic','unknown'),(92,'Bir-Uja cave',40.4833,72.5833,1435.0,'limestone','Devonian','yes'),(93,'Green Cathedral cave',4.2333,114.9250,NULL,'limestone','unknown','unknown'),(94,'Anjohibe cave',-15.5300,46.8800,131.0,'mixed','Eocene','no'),(95,'Brown\'s cave',22.8894,-82.5186,25.0,'limestone','Eocene','no'),(96,'Brown\'s Folly mine',51.3800,-2.3700,150.0,'limestone','Jurassic','yes'),(97,'Bue Marino cave',40.2467,9.6228,0.0,'limestone','Jurassic','unknown'),(98,'Crag cave',52.2500,-9.4300,60.0,'limestone','Carboniferous','yes'),(99,'Dante cave',-19.4000,17.8833,NULL,'dolomite','unknown','unknown'),(100,'Katerloch cave',47.0833,15.5500,900.0,'limestone','Devonian','yes'),(101,'Klapferloch cave',46.9500,10.5500,1140.0,'mixed','Cretaceous','yes'),(102,'Korallgrottan cave',64.8800,14.0000,540.0,'limestone','Precambrian','yes'),(103,'Lapa Doce cave',-12.3667,-41.5667,680.0,'limestone','unknown','no'),(104,'Liang Luar cave',-8.5300,120.4300,550.0,'limestone','Miocene','no'),(105,'Schneckenloch cave',47.4333,9.8667,1285.0,'limestone','Cretaceous','unknown'),(106,'Seso cave',42.4600,0.0400,794.0,'limestone','Eocene','yes'),(107,'Yok Balum cave',16.2086,-89.0735,336.0,'limestone','Cretaceous','yes'),(108,'Clamouse cave',43.7100,3.5500,110.0,'mixed','Jurassic','yes'),(109,'Molinos cave',40.7925,-0.4492,1050.0,'limestone','Cretaceous','yes'),(110,'Ma\'ale Efrayim cave',32.0660,35.3952,250.0,'dolomite','Cretaceous','unknown'),(111,'Rainha cave',-5.6000,-37.7330,100.0,'limestone','unknown','unknown'),(112,'Xinya cave',30.7500,109.4700,1250.0,'limestone','Triassic','no'),(113,'Paixão cave',-12.6182,-41.0184,NULL,'limestone','Precambrian','yes'),(114,'Achere cave',8.6036,40.3729,1534.0,'limestone','Jurassic','yes'),(115,'Hölloch im Mahdtal',47.3781,10.1506,1240.0,'limestone','Cretaceous','yes'),(116,'Bukit Assam cave',4.0300,114.8000,150.0,'unknown','unknown','unknown'),(117,'Bunker cave',51.3675,7.6647,184.0,'limestone','Devonian','yes'),(118,'Clearwater cave',4.1000,114.8333,120.0,'limestone','unknown','yes'),(119,'Cueva de Asiul',43.3200,-3.5900,285.0,'unknown','unknown','unknown'),(120,'Ejulve cave',40.4500,-0.3500,1240.0,'mixed','Cretaceous','yes'),(121,'Entrische Kirche cave',47.1600,13.1500,2119.0,'mixed','Jurassic','no'),(122,'Heshang cave',30.4500,110.4167,294.0,'dolomite','Cambrian','no'),(123,'Milchbach cave',46.6167,8.0830,1840.0,'limestone','Jurassic','yes'),(124,'Pinnacle cave',35.9700,-115.5000,1792.0,'limestone','Devonian','no'),(125,'Schafsloch cave ',47.2333,9.3833,1890.0,'limestone','Cretaceous','unknown'),(126,'Tityana cave',30.6419,77.6521,1470.0,'limestone','Precambrian','no'),(127,'Xiaobailong cave',24.2000,103.3500,1500.0,'unknown','unknown','no'),(128,'Buckeye creek',37.9825,-79.5894,600.0,'limestone','unknown','unknown'),(129,'Grotta di Carburangeli',38.1671,13.1615,22.0,'limestone','Pleistocene','yes'),(130,'Dandak cave',19.0000,82.0000,400.0,'unknown','unknown','no'),(131,'Grotta di Ernesto',45.9667,11.6500,1167.0,'limestone','Jurassic','yes'),(132,'Kleegruben cave',47.0800,11.6700,2165.0,'marble','Jurassic','yes'),(133,'Buca della Renella',44.0800,10.2100,300.0,'dolomite','Triassic','yes'),(134,'Cave of the Bells',31.7500,-110.7500,NULL,'unknown','unknown','yes'),(135,'Grotte de Piste',33.8400,-4.0900,1260.0,'unknown','Holocene','unknown'),(136,'Juxtlahuaca cave',17.4000,-99.2000,934.0,'limestone','Cretaceous','yes'),(137,'Kinderlinskaya cave',54.1500,56.8500,240.0,'limestone','Devonian','yes'),(138,'Moomi cave',12.5000,54.0000,400.0,'limestone','unknown','no'),(139,'Oregon caves national monument',42.0981,-123.4072,1300.0,'marble','Triassic','yes'),(140,'Sanbao cave',31.6670,110.4330,1900.0,'limestone','Pleistocene','no'),(141,'Sofular cave',41.4200,31.9300,700.0,'unknown','unknown','unknown'),(142,'Tianmen',30.9167,90.0667,4800.0,'unknown','unknown','no'),(143,'Cova da Arcoia',42.6100,-7.0900,1240.0,'unknown','unknown','no'),(144,'Botuverá',-27.2247,-49.1569,180.0,'limestone','Precambrian','yes'),(145,'Antro del Corchia',43.9800,10.2200,840.0,'mixed','unknown','unknown'),(146,'Gunung-buda cave (snail shell cave)',4.0330,114.8000,150.0,'limestone','Miocene','yes'),(147,'Fort Stanton cave',33.5067,-105.4433,1864.0,'unknown','unknown','unknown'),(148,'Buffalo cave',-24.1428,29.1770,1140.0,'dolomite','Precambrian','no'),(149,'Dongge cave',25.2800,108.0800,680.0,'unknown','Pleistocene','no'),(150,'Exhaleair cave',-41.2833,172.6330,685.0,'marble','unknown','no'),(151,'Guillotine cave',-42.3108,172.2178,740.0,'unknown','unknown','unknown'),(152,'Hoti cave',23.0833,57.3500,800.0,'unknown','unknown','no'),(153,'Jhumar cave',18.8667,81.8667,600.0,'unknown','unknown','yes'),(154,'Jiuxian cave',33.5667,109.1000,1495.0,'limestone','unknown','no'),(155,'KNI-51 cave',-15.1800,128.3700,100.0,'limestone','Devonian','no'),(156,'Mavri Trypa cave',36.7360,21.7596,70.0,'limestone','Palaeocene','no'),(157,'Munagamanu cave',15.1500,77.9200,475.0,'unknown','unknown','no'),(158,'Nettlebed cave',-41.2500,172.6330,390.0,'marble','unknown','no'),(159,'Qunf cave',17.1667,54.3000,650.0,'unknown','unknown','no'),(160,'Soreq cave',31.7558,35.0224,400.0,'dolomite','Cretaceous','yes'),(161,'Te Anau Fiordland',-45.2800,167.7000,320.0,'unknown','unknown','unknown'),(162,'Calcite cave',-46.0172,167.7431,NULL,'limestone','Miocene','unknown'),(163,'Gardener\'s Gut',-37.7394,175.1033,120.0,'unknown','unknown','unknown'),(164,'Max\'s cave',-37.7394,175.1033,325.0,'unknown','unknown','unknown'),(165,'Ruakuri cave',-38.2667,175.0667,80.0,'unknown','unknown','unknown'),(166,'Te Reinga cave',-38.8200,177.5200,NULL,'unknown','unknown','unknown'),(167,'Waiau cave',-46.0000,167.7300,100.0,'unknown','unknown','unknown'),(168,'Wazpretti cave',-42.3108,171.4000,100.0,'unknown','unknown','unknown'),(169,'Doubtful Xanadu',-45.3735,167.0476,960.0,'marble','unknown','unknown'),(170,'Defore cave',17.1667,54.0833,150.0,'limestone','unknown','no'),(171,'Devils Hole',36.4254,-116.2915,719.0,'unknown','unknown','unknown'),(172,'Wolkberg cave',-24.1000,29.8800,1450.0,'dolomite','unknown','no'),(173,'Perdida cave',18.0000,-67.0000,350.0,'limestone','Oligocene','yes'),(174,'Zhuliuping cave',26.0167,104.0950,1217.0,'limestone','Triassic','unknown');
/*!40000 ALTER TABLE `site` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-06-01 13:43:49
