-- MySQL dump 10.10 -- -- Host: mysql.maporegon.net Database: maporegon -- ------------------------------------------------------ -- Server version 5.0.24a-standard-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `tutor` -- DROP TABLE IF EXISTS `tutor`; CREATE TABLE `tutor` ( `tutor_index` int(11) NOT NULL auto_increment, `name` varchar(80) default NULL, `class` varchar(30) default NULL, `county` varchar(30) default NULL, `lat` varchar(12) default NULL, `lng` varchar(12) default NULL, `elevation` int(11) default NULL, `pop` int(11) default NULL, PRIMARY KEY (`tutor_index`), KEY `name_ind` (`name`(20)) ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tutor` -- /*!40000 ALTER TABLE `tutor` DISABLE KEYS */; LOCK TABLES `tutor` WRITE; INSERT INTO `tutor` VALUES (1,'11th Street Park','park','Yamhill','45.2147','-123.0889',3384,9864); INSERT INTO `tutor` VALUES (2,'13th Avenue City Park','park','Clackamas','45.2536','-122.68',3535,9454); INSERT INTO `tutor` VALUES (3,'19th Avenue City Park','park','Clackamas','45.2792','-122.6747',7519,7676); INSERT INTO `tutor` VALUES (4,'32nd Street Community Sports Park','park','Lane','44.03722','-122.98306',6984,14); INSERT INTO `tutor` VALUES (5,'4H Camp','locale','Coos','43.23194','-123.99583',2360,7034); INSERT INTO `tutor` VALUES (7,'5th Street Park','park','Coos','43.1786','-124.1847',844,5125); INSERT INTO `tutor` VALUES (8,'9th Street Park','park','Tillamook','45.4533','-123.8478',7126,4510); INSERT INTO `tutor` VALUES (9,'A B Crossing (historical)','locale','Coos','43.15278','-124.17778',3088,7167); INSERT INTO `tutor` VALUES (10,'A Canal','canal','Klamath','42.64722','-122.00833',4051,2293); INSERT INTO `tutor` VALUES (11,'A Canal','canal','Klamath','42.17528','-121.69917',981,9952); INSERT INTO `tutor` VALUES (12,'A Coombs Ranch','locale','Grant','44.42972','-118.62639',2737,2870); INSERT INTO `tutor` VALUES (13,'A Drain','canal','Malheur','44.03472','-117.00972',730,4478); INSERT INTO `tutor` VALUES (14,'A E Brown Dam','dam','Harney','43.17','-118.27333',5424,3766); INSERT INTO `tutor` VALUES (15,'A G Spence (historical)','locale','Lane','44.05139','-123.73556',4914,5382); INSERT INTO `tutor` VALUES (16,'A K Gulch','valley','Jackson','42.6125','-123.1625',8282,5597); INSERT INTO `tutor` VALUES (17,'A K Prairie','area','Jackson','42.67083','-123.15694',6649,1819); INSERT INTO `tutor` VALUES (18,'A Line Canal','canal','Umatilla','45.82639','-119.2775',8380,2288); INSERT INTO `tutor` VALUES (19,'A M Kennedy Park','park','Washington','45.4889','-122.7808',1937,5962); INSERT INTO `tutor` VALUES (20,'A P Spring','spring','Union','45.13917','-118.49972',4521,2927); INSERT INTO `tutor` VALUES (21,'A Reservoir','reservoir','Baker','44.67528','-117.57194',6773,6728); INSERT INTO `tutor` VALUES (22,'A and M Ridge','ridge','Wheeler','44.39306','-119.66',278,4834); INSERT INTO `tutor` VALUES (23,'A and M Spring','spring','Grant','44.37389','-119.64917',1049,3962); INSERT INTO `tutor` VALUES (24,'A-Y Spring','spring','Crook','44.47556','-120.67083',4386,5286); INSERT INTO `tutor` VALUES (25,'AJ Dwyer Roadside Reservation Memorial Area','area','Clackamas','45.35611','-121.99222',8757,4518); INSERT INTO `tutor` VALUES (26,'AP Well','well','Harney','42.44694','-119.03778',600,6706); INSERT INTO `tutor` VALUES (27,'Aamodt Dairy Reservoir','reservoir','Clackamas','45.15833','-122.73',6701,9950); INSERT INTO `tutor` VALUES (28,'Aamodt Flashboard Dam','dam','Clackamas','45.15833','-122.73',1677,9600); INSERT INTO `tutor` VALUES (29,'Aarhus Reservoir','reservoir','Marion','45.03611','-122.81667',8255,8122); INSERT INTO `tutor` VALUES (30,'Aaron Mercer Reservoir','reservoir','Polk','44.90389','-123.46889',6211,1781); INSERT INTO `tutor` VALUES (31,'Aarons Lake','lake','Columbia','45.76389','-122.79722',6259,4505); INSERT INTO `tutor` VALUES (32,'Abberdeen Post Office (historical)','po','Linn','44.56806','-122.78417',2630,7152); INSERT INTO `tutor` VALUES (33,'Abbey Creek','stream','Lincoln','44.61333','-123.8825',4338,2212); INSERT INTO `tutor` VALUES (34,'Abbey Creek','stream','Washington','45.57806','-122.85778',3766,9569); INSERT INTO `tutor` VALUES (35,'Abbot Butte','summit','Jefferson','44.55778','-121.70778',5782,1171); INSERT INTO `tutor` VALUES (36,'Abbot Butte Spring','spring','Jefferson','44.555','-121.72722',7575,7114); INSERT INTO `tutor` VALUES (37,'Abbot Creek','stream','Jefferson','44.57028','-121.62028',491,2021); INSERT INTO `tutor` VALUES (38,'Abbot Creek Recreation Site','locale','Jefferson','44.54583','-121.67194',9693,8721); INSERT INTO `tutor` VALUES (39,'Abbot Lake','lake','Clatsop','46.17778','-123.95472',6951,7505); INSERT INTO `tutor` VALUES (40,'Abbot Pass','gap','Clackamas','45.13083','-121.70389',5638,1321); INSERT INTO `tutor` VALUES (41,'Abbott Burn','area','Clackamas','45.18056','-121.81667',7293,4050); INSERT INTO `tutor` VALUES (42,'Abbott Butte','summit','Douglas','42.94361','-122.54861',9511,6242); INSERT INTO `tutor` VALUES (43,'Abbott Butte Lookout','locale','Douglas','42.94389','-122.54806',5631,9015); INSERT INTO `tutor` VALUES (44,'Abbott Creek','stream','Douglas','42.99167','-122.54306',9577,6308); INSERT INTO `tutor` VALUES (45,'Abbott Creek','stream','Grant','44.09417','-119.5',947,4449); INSERT INTO `tutor` VALUES (46,'Abbott Creek','stream','Jackson','42.85972','-122.5075',5957,3272); INSERT INTO `tutor` VALUES (47,'Abbott Creek Recreation Site','locale','Jackson','42.88139','-122.50583',6895,2968); INSERT INTO `tutor` VALUES (48,'Abbott Creek Research Natural Area','park','Jackson','42.935','-122.52278',6558,4975); INSERT INTO `tutor` VALUES (49,'Abbott Prairie','flat','Jackson','42.82361','-122.65722',2053,5921); INSERT INTO `tutor` VALUES (50,'Abe Creek','stream','Curry','42.49444','-124.30944',541,4629); UNLOCK TABLES; /*!40000 ALTER TABLE `tutor` ENABLE KEYS */; /*!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 */;