-- http://www.phpmyadmin.net
--




--
-- Database: `db_bci_current`
--

-- --------------------------------------------------------

--
-- Table structure for table `tempMultStems_P17`
--

CREATE TABLE IF NOT EXISTS `tempMultStems_P17` (
  `QuadratName` char(12) default NULL,
  `subquad` int(10) unsigned default NULL,
  `Tag` char(10) default NULL,
  `StemTag` varchar(32) default NULL,
  `DBH` float default NULL,
  `codes` varchar(50) default NULL,
  `HOM` float default NULL,
  `comments` varchar(256) default NULL,
  `ExactDate` date default NULL,
  `TreeID` int(10) unsigned default NULL,
  `x` float default NULL,
  `y` float default NULL,
  `StemID` int(10) unsigned default NULL,
  `MeasureID` int(10) unsigned default NULL,
  `PlotCensusNumber` int(10) unsigned default NULL,
  `CensusID` int(10) unsigned default NULL,
  `PrimaryStem` varchar(20) default NULL,
  `Mnemonic` char(10) default NULL,
  `PlotID` int(10) unsigned default NULL,
  `Errors` varchar(256) default NULL,
  `tempID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`tempID`),
  KEY `indMult1` (`Tag`,`StemTag`),
  KEY `indMult2` (`TreeID`,`StemID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;

--
-- Dumping data for table `tempMultStems_P17`
--

INSERT INTO `tempMultStems_P17` (`QuadratName`, `subquad`, `Tag`, `StemTag`, `DBH`, `codes`, `HOM`, `comments`, `ExactDate`, `TreeID`, `x`, `y`, `StemID`, `MeasureID`, `PlotCensusNumber`, `CensusID`, `PrimaryStem`, `Mnemonic`, `PlotID`, `Errors`, `tempID`) VALUES
('0002', 44, '522563', '1', 181, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 1),
('0002', 44, '522563', '2', 31, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 2),
('0002', 44, '522563', '3', 31, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 3),
('0003', 44, '522582', '1', 121, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 4),
('0003', 44, '522582', '2', 21, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 5),
('0100', 22, '522608', '1', 304, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 6),
('0100', 22, '522608', '2', 23, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 7),
('0101', 12, '522694', '1', 24, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 8),
('0101', 12, '522694', '2', 10, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 9),
('0101', 13, '522706', '1', 15, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 10),
('0101', 13, '522706', '2', 11, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 11),
('0101', 14, '522726', '3', 15, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 12),
('0101', 14, '522726', '4', 14, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 13),
('0101', 14, '522726', '5', 11, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 14),
('0101', 14, '522726', '6', 11, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 15),
('0101', 21, '522749', '1', 26, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 16),
('0101', 21, '522749', '2', 22, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 17),
('0101', 33, '522779', '1', 20, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 18),
('0101', 33, '522779', '2', 13, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 19),
('0101', 43, '522797', '1', 34, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 20),
('0101', 43, '522797', '2', 12, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 21),
('0101', 41, '522805', '1', 40, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 22),
('0101', 41, '522805', '2', 21, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 23),
('0101', 41, '522805', '3', 16, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 24),
('0102', 21, '522944', '1', 49, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 25),
('0102', 21, '522944', '2', 24, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 26),
('0102', 21, '522944', '3', 15, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 27),
('0102', 21, '522944', '4', 14, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 28),
('0102', 21, '522944', '5', 14, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 29),
('0102', 31, '523630', '1', 69, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 30),
('0102', 31, '523630', '2', 19, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 31),
('0102', 31, '523630', '3', 14, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 32),
('0102', 34, '523656', '1', 154, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 33),
('0102', 34, '523656', '2', 14, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 34),
('0102', 41, '523699', '1', 17, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 35),
('0102', 41, '523699', '2', 16, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 36),
('0104', 33, '523734', '3', 11, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 37),
('0201', 12, '524493', '1', 100, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 38),
('0201', 12, '524493', '2', 13, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 39),
('0201', 12, '524493', '3', 11, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 40),
('0201', 23, '524518', '1', 28, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 41),
('0201', 23, '524518', '2', 15, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 42),
('0201', 21, '524529', '1', 22, 'R', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 43),
('0201', 21, '524529', '2', 21, 'R', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 44),
('0201', 21, '524530', '1', 52, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 45),
('0201', 21, '524530', '2', 36, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 46),
('0201', 21, '524530', '3', 18, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 47),
('0201', 33, '524555', '1', 29, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 48),
('0201', 33, '524555', '2', 16, 'L', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 49),
('0201', 33, '524556', '1', 50, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 50),
('0201', 33, '524556', '2', 25, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 51),
('0201', 33, '524556', '3', 13, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 52),
('0201', 44, '524566', '1', 70, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 53),
('0201', 44, '524566', '2', 27, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 54),
('0201', 41, '524578', '1', 29, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 55),
('0201', 41, '524578', '2', 10, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 56),
('0201', 11, '524582', '1', 44, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 57),
('0201', 11, '524582', '2', 10, '', 1.3, '', '2012-01-25', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 58),
('0202', 23, '524696', '1', 122, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 59),
('0202', 23, '524696', '2', 24, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 60),
('0202', 32, '524723', '1', 39, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 61),
('0202', 32, '524723', '2', 12, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 62),
('0202', 33, '524734', '1', 40, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 63),
('0202', 33, '524734', '2', 12, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 64),
('0202', 34, '524737', '1', 30, 'L', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 65),
('0202', 34, '524737', '2', 14, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 66),
('0301', 43, '524879', '1', 320, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 67),
('0301', 43, '524879', '2', 45, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 68),
('0301', 43, '524879', '3', 34, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 69),
('0301', 43, '524879', '4', 19, '', 1.3, '', '2012-01-26', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 70),
('0400', 44, '525486', '1', 190, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 71),
('0400', 44, '525486', '2', 14, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 72),
('0400', 44, '525486', '3', 11, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 73),
('0400', 31, '525490', '1', 145, 'Q', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 74),
('0400', 31, '525490', '2', 43, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 75),
('0400', 41, '525491', '3', 32, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 76),
('0400', 41, '525491', '4', 32, 'L', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 77),
('0401', 14, '525505', '1', 70, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 78),
('0401', 14, '525505', '2', 66, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 79),
('0401', 14, '525505', '3', 32, '', 1.3, '', '2012-01-27', 0, 0, 0, 0, 0, 2, 251, '', '', 115, '', 80);
