-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.27-community-nt
/*!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 */;
/*!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' */;
--
-- Create schema dfo_0385
--
CREATE DATABASE IF NOT EXISTS dfo_0385;
USE dfo_0385;
--
-- Definition of table `content`
--
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `page_inp` varchar(45) default NULL,
  `title_inp_fr` varchar(45) default NULL,
  `title_inp_en` varchar(45) default NULL,
  `content_htm_fr` text,
  `content_htm_en` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `content`
--
/*!40000 ALTER TABLE `content` DISABLE KEYS */;
INSERT INTO `content` (`id`,`page_inp`,`title_inp_fr`,`title_inp_en`,`content_htm_fr`,`content_htm_en`) VALUES 
 (1,'00','introduction','','','<p><strong>Risk Profiler : Ecosystem Risk Characterization and Decision-Making Support Tool</strong> </p><p>The Risk Profiler application is designed as a simple tool to assist in characterizing risks in a given ecological unit and to help support decision-making through priority setting.&nbsp; The tool is used to characterize Drivers and Stressors in the Ecological Unit in order to produce an Ecosystem Risk Profile.&nbsp; </p><p>The tool allows professionals to test &quot;what-if&quot; scenarios based on their expertise and assist in the evaluation of risks in the ecological unit while ranking the potential Impact of stressors.&nbsp; This can be useful for identifying management priorities based on the vulnerabilities of the ecological unit.&nbsp; </p><p>The tool applies a simple semi-qualitative method for characterizing hazard levels (e.g. high, medium, low) and attributing values.&nbsp; This approach provides a representation of cumulative risk rankings based on the characterization of the Severity and Likelihood of impacts to ecological functions within the ecological unit. </p>'),
 (2,'20','definition','','','<p><strong>Drivers:<br /></strong>Socio-economic and cultural Drivers are underlying factors influencing a variety of relevant variables.&nbsp; In this case, they refer human activities present in an ecological unit, which by their nature and normal operations may potentially impact aquatic ecosystems.</p><p><strong>Stressors:</strong><br />Stressors or Pressure indicators describe the variables which directly cause (or may cause) environmental problems.&nbsp; They are the mechanisms through which Drivers affect the aquatic environment.&nbsp; They are also measurable indicators of the state of health in the ecosystem (i.e. pathologies).</p><p><strong>Ecological Unit:<br /></strong>An ecological unit is a defined area with is representative of the ecological functions within an area.&nbsp; For example, a watershed could be considered an ecological unit given that all drainage within the area meets in the estuary.&nbsp; Although aquatic systems form continuous areas extending from streams out to the open ocean, a representative sub-area can usually be defined for the purposes of an assessment.&nbsp; This contrasts with socio-political boundaries which do not typically reflect the ecological functions.</p><p><strong>Impacts:</strong><br />Impact indicators describe the ultimate effects of changes of state. Example: the percentage of children suffering from lead-induced health problems; the mortality due to noise-induced heart attacks; the number of people starving due to climate-change induced crop losses. </p><p><br /><strong>References:<br /></strong>Sumner, J.; Ross, T.; Ababouch, L.&nbsp; Application of risk assessment in the fish industry.<br />FAO Fisheries Technical Paper. No. 442. Rome, FAO. 2004. 78p.&nbsp; <br /><a href=/>ftp://ftp.fao.org/docrep/fao/007/y4722e/y4722e00.pdf</a></p><p>DPSIR Information. <a href=/>http://esl.jrc.it/envind/theory/handb_03.htm</a></p>'),
 (3,'21','contact us','contact us','','<p>We can response some of your answer with this <a href=/ target=\"_blank\">email</a></p>');
/*!40000 ALTER TABLE `content` ENABLE KEYS */;
--
-- Definition of table `groups`
--
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fktbl_inp` varchar(255) default NULL,
  `val_inp` varchar(50) default NULL,
  `cat_inp` varchar(45) default NULL,
  `txt_inp_fr` varchar(255) default NULL,
  `txt_inp_en` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `groups`
--
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` (`id`,`fktbl_inp`,`val_inp`,`cat_inp`,`txt_inp_fr`,`txt_inp_en`) VALUES 
 (1,NULL,'3','strenght_int','haut','high'),
 (2,NULL,'2','strenght_int','moyenne','medium'),
 (3,NULL,'1','strenght_int','bas','low'),
 (4,NULL,'1','level_int','drivers a stresseur','driver to stressor'),
 (5,NULL,'2','level_int',NULL,'stressor to service'),
 (6,NULL,'3','level_int',NULL,'service to dependencie');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
--
-- Definition of table `item_lnk`
--
DROP TABLE IF EXISTS `item_lnk`;
CREATE TABLE `item_lnk` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `project_fk` varchar(45) default NULL,
  `level_sel` varchar(45) default NULL,
  `parent_sel` varchar(45) default NULL,
  `strenght_sel` varchar(45) default NULL,
  `child_sel` varchar(45) default NULL,
  `desc_txt_fr` text,
  `desc_txt_en` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `item_lnk`
--
/*!40000 ALTER TABLE `item_lnk` DISABLE KEYS */;
INSERT INTO `item_lnk` (`id`,`project_fk`,`level_sel`,`parent_sel`,`strenght_sel`,`child_sel`,`desc_txt_fr`,`desc_txt_en`) VALUES 
 (1,'1','1','1','3','13',NULL,NULL),
 (2,'1','1','1','1','14',NULL,NULL),
 (3,'1','1','2','2','13',NULL,NULL),
 (4,'1','3','22','3','1',NULL,NULL),
 (5,'1','1','1','2','15',NULL,NULL);
/*!40000 ALTER TABLE `item_lnk` ENABLE KEYS */;
--
-- Definition of table `items`
--
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `id` int(11) default NULL,
  `types_sel` double default NULL,
  `title_inp_en` varchar(255) default NULL,
  `ordre_int` double default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `items`
--
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` (`id`,`types_sel`,`title_inp_en`,`ordre_int`) VALUES 
 (1,1,'Municipalities',1),
 (2,1,'Residential and commercial',2),
 (3,1,'Fish Processing',3),
 (4,1,'Aquaculture',4),
 (5,1,'Fisheries',5),
 (6,1,'Industries',6),
 (7,1,'Mining',7),
 (8,1,'Forestry',8),
 (9,1,'Agriculture',9),
 (10,1,'Land Transport',10),
 (11,1,'Marine Transport',11),
 (12,1,'Tourism and Recreation',12),
 (13,2,'Contaminants',1),
 (14,2,'Sediment',2),
 (15,2,'Pathogens',3),
 (16,2,'Habitat Fragmentation',4),
 (17,2,'Biomass Alt.',5),
 (18,2,'Hydrologic Alt.',6),
 (19,2,'Nutrient Alt.',7),
 (20,2,'Invasive Species',8),
 (21,2,'Riparian Alt.',9),
 (22,3,'Water quality',1),
 (23,3,'Water source',2),
 (24,3,'Fish resources',3),
 (25,3,'Navigation ',4),
 (26,3,'Aesthetics',5),
 (27,3,'Coastal Zone',6);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
--
-- Definition of table `link_lst`
--
DROP TABLE IF EXISTS `link_lst`;
CREATE TABLE `link_lst` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `projectsystem_fk` varchar(45) default NULL,
  `level_sel` varchar(45) default NULL,
  `parent_sel` int(10) unsigned default NULL,
  `strenght_sel` varchar(45) default NULL,
  `child_sel` int(10) unsigned default NULL,
  `value_int` varchar(45) default NULL,
  `desc_txt_fr` text,
  `desc_txt_en` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `link_lst`
--
/*!40000 ALTER TABLE `link_lst` DISABLE KEYS */;
INSERT INTO `link_lst` (`id`,`projectsystem_fk`,`level_sel`,`parent_sel`,`strenght_sel`,`child_sel`,`value_int`,`desc_txt_fr`,`desc_txt_en`) VALUES 
 (1,'1','1',1,'3',13,'100',NULL,NULL),
 (2,'1','1',1,'1',14,'1',NULL,NULL),
 (3,'1','1',1,'2',15,'10',NULL,NULL),
 (4,'1','1',1,'3',16,'10',NULL,NULL),
 (5,'1','1',1,'2',18,'10',NULL,NULL),
 (6,'1','1',1,NULL,19,'100',NULL,NULL),
 (7,'1','1',2,NULL,13,'10',NULL,NULL),
 (8,'1','1',2,NULL,14,'1',NULL,NULL),
 (9,'1','1',2,NULL,15,'1',NULL,NULL),
 (10,'1','1',2,NULL,16,'1',NULL,NULL),
 (11,'1','1',2,NULL,18,'10',NULL,NULL),
 (12,'1','1',2,NULL,19,'100',NULL,NULL),
 (13,'1','1',2,NULL,21,'1',NULL,NULL),
 (14,'1','1',3,NULL,13,'10',NULL,NULL),
 (15,'1','1',3,NULL,15,'1',NULL,NULL),
 (16,'1','1',3,NULL,18,'1',NULL,NULL),
 (17,'1','1',3,NULL,19,'100',NULL,NULL),
 (18,'1','1',3,NULL,20,'10',NULL,NULL),
 (19,'1','1',4,NULL,13,'10',NULL,NULL),
 (20,'1','1',4,NULL,14,'10',NULL,NULL),
 (21,'1','1',4,NULL,15,'1',NULL,NULL),
 (22,'1','1',4,NULL,18,'1',NULL,NULL),
 (23,'1','1',4,NULL,19,'10',NULL,NULL),
 (24,'1','1',4,NULL,20,'10',NULL,NULL),
 (25,'1','1',5,NULL,13,'1',NULL,NULL),
 (26,'1','1',5,NULL,17,'100',NULL,NULL),
 (27,'1','1',5,NULL,18,'1',NULL,NULL),
 (28,'1','1',5,NULL,19,'1',NULL,NULL),
 (29,'1','1',6,NULL,13,'100',NULL,NULL),
 (30,'1','1',6,NULL,14,'100',NULL,NULL),
 (31,'1','1',6,NULL,16,'10',NULL,NULL),
 (32,'1','1',6,NULL,18,'10',NULL,NULL),
 (33,'1','1',6,NULL,19,'1',NULL,NULL),
 (34,'1','1',6,NULL,21,'100',NULL,NULL),
 (35,'1','1',7,NULL,13,'100',NULL,NULL),
 (36,'1','1',7,NULL,14,'100',NULL,NULL),
 (37,'1','1',7,NULL,16,'10',NULL,NULL),
 (38,'1','1',7,NULL,18,'10',NULL,NULL),
 (39,'1','1',7,NULL,21,'100',NULL,NULL),
 (40,'1','1',8,NULL,13,'1',NULL,NULL),
 (41,'1','1',8,NULL,14,'1',NULL,NULL),
 (42,'1','1',8,NULL,16,'100',NULL,NULL),
 (43,'1','1',8,NULL,18,'10',NULL,NULL),
 (44,'1','1',8,NULL,19,'1',NULL,NULL),
 (45,'1','1',8,NULL,21,'100',NULL,NULL),
 (46,'1','1',9,NULL,13,'100',NULL,NULL),
 (47,'1','1',9,NULL,14,'100',NULL,NULL),
 (48,'1','1',9,NULL,15,'10',NULL,NULL),
 (49,'1','1',9,NULL,16,'1',NULL,NULL),
 (50,'1','1',9,NULL,18,'10',NULL,NULL),
 (51,'1','1',9,NULL,19,'100',NULL,NULL),
 (52,'1','1',9,NULL,21,'100',NULL,NULL),
 (53,'1','1',10,NULL,13,'10',NULL,NULL),
 (54,'1','1',10,NULL,14,'10',NULL,NULL),
 (55,'1','1',10,NULL,16,'100',NULL,NULL),
 (56,'1','1',10,NULL,18,'100',NULL,NULL),
 (57,'1','1',10,NULL,21,'10',NULL,NULL),
 (58,'1','1',11,NULL,13,'10',NULL,NULL),
 (59,'1','1',11,NULL,15,'1',NULL,NULL),
 (60,'1','1',11,NULL,19,'1',NULL,NULL),
 (61,'1','1',11,NULL,20,'100',NULL,NULL),
 (62,'1','1',12,NULL,13,'10',NULL,NULL),
 (63,'1','1',12,NULL,14,'10',NULL,NULL),
 (64,'1','1',12,NULL,18,'1',NULL,NULL),
 (65,'1','1',12,NULL,16,'10',NULL,NULL),
 (66,'1','1',12,NULL,21,'10',NULL,NULL),
 (67,'1','2',13,NULL,22,'100',NULL,NULL),
 (68,'1','2',13,NULL,24,'100',NULL,NULL),
 (69,'1','2',14,NULL,22,'10',NULL,NULL),
 (70,'1','2',14,NULL,24,'10',NULL,NULL),
 (71,'1','2',14,NULL,26,'10',NULL,NULL),
 (72,'1','2',14,NULL,27,'10',NULL,NULL),
 (73,'1','2',15,NULL,22,'10',NULL,NULL),
 (74,'1','2',15,NULL,24,'100',NULL,NULL),
 (75,'1','2',16,NULL,23,'10',NULL,NULL),
 (76,'1','2',0,NULL,0,'0',NULL,NULL),
 (77,'1','2',16,NULL,25,'100',NULL,NULL),
 (78,'1','2',17,NULL,24,'100',NULL,NULL),
 (79,'1','2',17,NULL,26,'1',NULL,NULL),
 (80,'1','2',18,NULL,22,'10',NULL,NULL),
 (81,'1','2',18,NULL,23,'10',NULL,NULL),
 (82,'1','2',18,NULL,24,'10',NULL,NULL),
 (83,'1','2',18,NULL,25,'100',NULL,NULL),
 (84,'1','2',18,NULL,26,'10',NULL,NULL),
 (85,'1','2',18,NULL,27,'1',NULL,NULL),
 (86,'1','2',19,NULL,22,'10',NULL,NULL),
 (87,'1','2',19,NULL,24,'100',NULL,NULL),
 (88,'1','2',19,NULL,26,'10',NULL,NULL),
 (89,'1','2',20,NULL,24,'100',NULL,NULL),
 (90,'1','2',20,NULL,26,'10',NULL,NULL),
 (91,'1','2',21,NULL,22,'10',NULL,NULL),
 (92,'1','2',21,NULL,24,'10',NULL,NULL),
 (93,'1','2',21,NULL,26,'100',NULL,NULL),
 (94,'1','2',21,NULL,27,'100',NULL,NULL),
 (95,'1','3',22,NULL,1,'100',NULL,NULL),
 (96,'1','3',22,NULL,3,'10',NULL,NULL),
 (97,'1','3',22,NULL,4,'10',NULL,NULL),
 (98,'1','3',22,NULL,5,'10',NULL,NULL),
 (99,'1','3',22,NULL,9,'10',NULL,NULL),
 (100,'1','3',25,NULL,11,'100',NULL,NULL),
 (101,'1','3',23,NULL,1,'100',NULL,NULL),
 (102,'1','3',23,NULL,2,'100',NULL,NULL),
 (103,'1','3',23,NULL,3,'100',NULL,NULL),
 (104,'1','3',23,NULL,4,'1',NULL,NULL),
 (105,'1','3',23,NULL,6,'100',NULL,NULL),
 (106,'1','3',23,NULL,7,'100',NULL,NULL),
 (107,'1','3',23,NULL,8,'100',NULL,NULL),
 (108,'1','3',23,NULL,9,'10',NULL,NULL),
 (109,'1','3',24,NULL,3,'100',NULL,NULL),
 (110,'1','3',24,NULL,4,'1',NULL,NULL),
 (111,'1','3',24,NULL,5,'100',NULL,NULL),
 (112,'1','3',26,NULL,11,'10',NULL,NULL),
 (113,'1','3',25,NULL,1,'100',NULL,NULL),
 (114,'1','3',25,NULL,3,'100',NULL,NULL),
 (115,'1','3',25,NULL,4,'100',NULL,NULL),
 (116,'1','3',25,NULL,5,'100',NULL,NULL),
 (117,'1','3',25,NULL,7,'10',NULL,NULL),
 (118,'1','3',25,NULL,8,'10',NULL,NULL),
 (119,'1','3',27,NULL,11,'10',NULL,NULL),
 (120,'1','3',22,NULL,11,'100',NULL,NULL),
 (121,'1','3',26,NULL,1,'10',NULL,NULL),
 (122,'1','3',26,NULL,2,'100',NULL,NULL),
 (123,'1','3',25,NULL,12,'100',NULL,NULL),
 (124,'1','3',27,NULL,1,'100',NULL,NULL),
 (125,'1','3',27,NULL,2,'10',NULL,NULL),
 (126,'1','3',27,NULL,3,'1',NULL,NULL),
 (127,'1','3',27,NULL,4,'10',NULL,NULL),
 (128,'1','3',27,NULL,5,'1',NULL,NULL),
 (129,'1','3',27,NULL,6,'10',NULL,NULL),
 (130,'1','3',27,NULL,12,'10',NULL,NULL),
 (131,'1','3',24,NULL,11,'10',NULL,NULL),
 (132,'1','3',25,NULL,6,'100',NULL,NULL);
/*!40000 ALTER TABLE `link_lst` ENABLE KEYS */;
--
-- Definition of table `poll`
--
DROP TABLE IF EXISTS `poll`;
CREATE TABLE `poll` (
  `id` int(11) NOT NULL auto_increment,
  `types_sel` int(11) default NULL,
  `parent_fk` int(11) default NULL,
  `title_inp_fr` varchar(150) default NULL,
  `title_inp_en` varchar(150) default NULL,
  `titledesc_inp_fr` varchar(255) default NULL,
  `titledesc_inp_en` varchar(255) default NULL,
  `titleexplicit_txt_fr` text,
  `titleexplicit_txt_en` text,
  `pos_inp` varchar(50) default NULL,
  `values_int` varchar(50) default NULL,
  `ord_int` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `poll`
--
/*!40000 ALTER TABLE `poll` DISABLE KEYS */;
INSERT INTO `poll` (`id`,`types_sel`,`parent_fk`,`title_inp_fr`,`title_inp_en`,`titledesc_inp_fr`,`titledesc_inp_en`,`titleexplicit_txt_fr`,`titleexplicit_txt_en`,`pos_inp`,`values_int`,`ord_int`) VALUES 
 (1,NULL,NULL,'','drivers',NULL,NULL,NULL,NULL,NULL,NULL,'1'),
 (2,NULL,NULL,'','stressor',NULL,NULL,NULL,NULL,NULL,NULL,'2'),
 (3,NULL,NULL,'','severity',NULL,NULL,NULL,NULL,NULL,NULL,'1'),
 (4,NULL,NULL,'','likelihood',NULL,NULL,NULL,NULL,NULL,NULL,'2'),
 (5,1,3,'','intensity',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (6,1,3,'','duration',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (7,1,3,'','geographic extent',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (8,1,3,'','Driver Tendency',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (9,2,3,'','magnitude',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (10,2,3,'','Ecosystem Sensitivity',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (11,2,3,'','Reversibility',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 (12,2,4,'','OBSERVED',NULL,NULL,NULL,'Have the impacts associated to the stressor occurred in this ecological unit in the past',NULL,NULL,NULL),
 (13,2,4,'','EXPECTED',NULL,NULL,NULL,'Are the impacts associated to the stressor expected to occur in this ecological unit in the future',NULL,NULL,NULL),
 (14,1,5,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (15,1,5,'','High',NULL,NULL,NULL,'The driver is characterized as intense within the area it occurs; where the degree of the activity is considered high in regards to: the number of people involved, the volume, the density, the concentration, etc.',NULL,'1428.571429','2'),
 (16,1,5,'','Medium',NULL,NULL,NULL,'The driver is characterized as moderately intense within the area it occurs; where the degree of the activity is considered moderate in regards to: the number of people involved, the volume, the density, the concentration, etc.',NULL,'14.28571429','3'),
 (17,1,5,'','Low',NULL,NULL,NULL,'The driver is characterized at a low intensity within the area it occurs; where the degree of the activity is considered low in regards to: the number of people involved, the volume, the density, the concentration, etc.',NULL,'0.142857143','4'),
 (18,1,6,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (19,1,6,'','High',NULL,NULL,NULL,'The activities associated to the driver operate continuously within the ecological unit.   Impacts are considered chronic as they extend beyond a year.',NULL,'1428.571429','2'),
 (20,1,6,'','Medium',NULL,NULL,NULL,'The activities associated to the driver operate over a specified period only within the ecological unit.  Impacts are considered to occur over one year or less.',NULL,'14.28571429','3'),
 (21,1,6,'','Low',NULL,NULL,NULL,'The activities associated to the driver operate only on a punctual basis within the ecological unit.  Impacts are considered to occur within one season or less.',NULL,'0.142857143','4'),
 (22,1,7,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (23,1,7,'','High',NULL,NULL,NULL,'The driver occurs over an extensive area within the ecological unit.  The driver is considered to have an area of influence extending over a large geographic scale of the ecological unit or perhaps beyond the ecological unit.',NULL,'1428.571429','2'),
 (24,1,7,'','Medium',NULL,NULL,NULL,'The driver occurs over a portion of the area within the ecological unit.  The driver is considered to have an area of influence which is limited to only a portion of the geographic scale of the ecological unit.',NULL,'14.28571429','3'),
 (25,1,7,'','Low',NULL,NULL,NULL,'The driver occurs over in a localized area within the ecological unit.  The driver is considered to have an area of influence which is limited to only the footprint of the driver or its immediate vicinity.',NULL,'0.142857143','4'),
 (26,1,8,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (27,1,8,'','Increasing',NULL,NULL,NULL,'The driver is expected to increase over the next decade (i.e. change of the driver in terms of development, immigration, industry expansion, new emphasis, etc.).',NULL,'1428.571429','2'),
 (28,1,8,'','Stable',NULL,NULL,NULL,'The driver is expected to be relatively stable over the next decade (i.e. no significant change of the driver in terms of development, immigration, expansion, new emphasis, etc.).',NULL,'14.28571429','3'),
 (29,1,8,'','Decreasing','','','','The driver is expected to be decline over the next decade (i.e. negative changes of the driver in terms of development, out-migration, industry closures, etc.).','','0.142857143','4'),
 (30,2,9,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (31,2,9,'','High',NULL,NULL,NULL,'Impacts have the potential to impact a whole stock(s), population(s), habitat(s) or ecosystem(s) which represents a major change in ecosystem structure and function or a total collapse of processes. Outside the range of natural variability.',NULL,'1428.571429','2'),
 (32,2,9,'','Medium',NULL,NULL,NULL,'Impacts have the potential to impact a portion of a population or habitat, or ecosystem which represents a detectable change to structure and ecological function. Temporarily outside the range of natural variability',NULL,'14.28571429','3'),
 (33,2,9,'','Low',NULL,NULL,NULL,'Impacts have the potential to cause localised impacts on specific sub-population, habitat, or ecosystem which represents minor alterations to some ecosystem components.  Within natural variation.',NULL,'0.142857143','4'),
 (34,2,10,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (35,2,10,'','High',NULL,NULL,NULL,'The ecosystem is highly sensitive to change and perturbations (e.g. rare or unique species and habitat assemblages that require stable constant conditions)',NULL,'1428.571429','2'),
 (36,2,10,'','Medium',NULL,NULL,NULL,'The ecosystem is moderately sensitive to change and perturbations (e.g. species and habitat assemblages are common and typical within the ecological unit and they tolerate most changes to a degree)',NULL,'14.28571429','3'),
 (37,2,10,'','Low',NULL,NULL,NULL,'The ecosystem is resilient to changes and perturbations (e.g. species and habitat assemblages are acclimated to frequent disruptions such as tides, storm events, mobile sediments, etc.)',NULL,'0.142857143','4'),
 (38,2,11,'','Hazard Level',NULL,NULL,NULL,'Criteria',NULL,'0','1'),
 (39,2,11,'','High',NULL,NULL,NULL,'Impacts are irreversible or only reversible over an extended period with active management efforts (i.e. ecological restoration).',NULL,'1428.571429','2'),
 (40,2,11,'','Medium',NULL,NULL,NULL,'Impacts are reversible over short term with active management or over a longer term without active management.',NULL,'14.28571429','3'),
 (41,2,11,'','Low',NULL,NULL,NULL,'Impacts are reversible over short term without active management.  The ecosystem will return to its previous state without any interventions.',NULL,'0.142857143','4'),
 (42,2,12,'','Likelihood',NULL,NULL,NULL,'Prior Knowledge of Ecosystem	Probability',NULL,'0','1'),
 (43,2,12,'','Almost Certain',NULL,NULL,NULL,'Occurred regularly in this ecological unit and is considered a chronic concern.',NULL,'5000','2'),
 (44,2,12,'','Likely',NULL,NULL,NULL,'Has occurred here more than once and is considered a concern.',NULL,'500','3'),
 (45,2,12,'','Moderate',NULL,NULL,NULL,'Has occurred before in this ecological unit, but infrequently.',NULL,'50','4'),
 (46,2,12,'','Unlikely',NULL,NULL,NULL,'Has occurred only in exceptional circumstances.',NULL,'5','5'),
 (47,2,12,'','Rare',NULL,NULL,NULL,'Never observed. ',NULL,'0.5','6'),
 (48,2,13,'','Likelihood',NULL,NULL,NULL,'Expected results in the ecosystem	Probability',NULL,'0','1'),
 (49,2,13,'','Almost Certain',NULL,NULL,NULL,'The impacts are expected to occur regularly in this ecological unit.',NULL,'5000','2'),
 (50,2,13,'','Likely',NULL,NULL,NULL,'The impacts are expected to occur here more than once.',NULL,'500','3'),
 (51,2,13,'','Moderate',NULL,NULL,NULL,'Uncommon, but some evidence to suggest that impacts will occur infrequently in this ecological unit.',NULL,'50','4'),
 (52,2,13,'','Unlikely',NULL,NULL,NULL,'The impact could potentially occur in this ecological unit under exceptional circumstances.',NULL,'5','5'),
 (53,2,13,'','Rare',NULL,NULL,NULL,'Not expected, but not impossible.',NULL,'0.5','6');
/*!40000 ALTER TABLE `poll` ENABLE KEYS */;
--
-- Definition of table `poll_bak`
--
DROP TABLE IF EXISTS `poll_bak`;
CREATE TABLE `poll_bak` (
  `id` int(11) NOT NULL auto_increment,
  `title_inp_fr` varchar(150) default NULL,
  `title_inp_en` varchar(150) default NULL,
  `titledesc_inp_fr` varchar(255) default NULL,
  `titledesc_inp_en` varchar(255) default NULL,
  `titleexplicit_txt_fr` text,
  `titleexplicit_txt_en` text,
  `pos_inp` varchar(50) default NULL,
  `values_int` varchar(50) default NULL,
  `ord_int` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `poll_bak`
--
/*!40000 ALTER TABLE `poll_bak` DISABLE KEYS */;
INSERT INTO `poll_bak` (`id`,`title_inp_fr`,`title_inp_en`,`titledesc_inp_fr`,`titledesc_inp_en`,`titleexplicit_txt_fr`,`titleexplicit_txt_en`,`pos_inp`,`values_int`,`ord_int`) VALUES 
 (1,'','severity','','','','','000_000','','1'),
 (2,'','likelihood','','','','','000_000','','2'),
 (3,'','magnitude','','','','','001_001','','1'),
 (4,'','duration of effect','','','','','001_001','','2'),
 (5,'','geographic extent of event','','','','','001_001','','3'),
 (6,'','reversibility','','','','','001_001','','4'),
 (7,'','ecosystem Sensitivity ','','','','','001_001','','5'),
 (8,'','prior','','','','','001_002','','1'),
 (9,'','expected','','','','','001_002','','2'),
 (10,'','hazard Level','','','','critera','002_003','0','1'),
 (11,'','high','','','','affecting a whole stock(s), population(s), habitat(s) or ecosystem(s) which represents a major change in ecosystem structure and function or a total collapse of processes. Outside the range of natural variability.','002_003','2000','2'),
 (12,'','medium','','','','effect on portion of a population or habitat, or ecosystem which represents a detectable changes to structure and ecological funtion. Temporarily outside the range of natural variability','002_003','20','2'),
 (13,'','low','','','','localised effect on specific sub-population, habitat, or ecosystem which represents minor alterations to some ecosystem components.  Within natural variation.','002_003','0.2','3'),
 (14,'','hazard level','','','','critera','002_004','0','1'),
 (15,'','high','','','','effect is chronic. Extending beyond a year.','002_004','2000','2'),
 (16,'','medium','','','','effect lasts moderately.  Occuring over one year or less.','002_004','20','3'),
 (17,'','low','','','','effect is punctual.  Occuring in less than one season.','002_004','0.2','4'),
 (18,NULL,'hazard level',NULL,NULL,NULL,'critera','002_005','0','1'),
 (19,NULL,'high',NULL,NULL,NULL,'effect extends beyond the ecological unit','002_005','2000','2'),
 (20,NULL,'medium',NULL,NULL,NULL,'effect is limited within the ecological unit','002_005','20','3'),
 (21,NULL,'low',NULL,NULL,NULL,'effect is limited to the footprint of the event and its vicinity','002_005','0.2','4'),
 (22,NULL,'hazard level',NULL,NULL,NULL,'critera','002_006','0','1'),
 (23,NULL,'high',NULL,NULL,NULL,'effects are irreversible or only reversible over an extended period with active management efforts.','002_006','2000','2'),
 (24,NULL,'medium',NULL,NULL,NULL,'effects are reversible over short term with active management or over a longer term without active management.','002_006','20','3'),
 (25,NULL,'low',NULL,NULL,NULL,'effects are reversible over short term without active management','002_006','0.2','4'),
 (26,NULL,'hazard level',NULL,NULL,NULL,'critera','002_007','0','1'),
 (27,NULL,'high',NULL,NULL,NULL,'the ecosystem is highly sensitive to change and perturbations (e.g. rare or unique species and habitat assemblages that require stable constant conditions)','002_007','2000','2'),
 (28,NULL,'medium',NULL,NULL,NULL,'the ecosystem is moderately sensitive to change and perturbations (e.g. species and habitat assemblages are common and typical within the ecological unit and they tolerate most changes to a degree)','002_007','20','3'),
 (29,NULL,'low',NULL,NULL,NULL,'the ecosystem is resilient to changes and perturbations (e.g. species and habitat assemblages are acclimated to frequent disruptions such as tides, storm events, mobile sediments, etc.)','002_007','0.2','4'),
 (30,NULL,'probability',NULL,'probability',NULL,'prior knowledge of ecosystem','002_008','0','1'),
 (31,NULL,'regularly',NULL,'more than 95%',NULL,'occurs regularly in this ecoligical unit and is considered a chronic concern.','002_008','5000','2'),
 (32,NULL,'periodically',NULL,'76%-95%',NULL,'has occured here more than once is considered a concern.','002_008','500','3'),
 (33,NULL,'sometimes',NULL,'25%-75%',NULL,'has occured before in this ecological unit, but infrequently.','002_008','50','4'),
 (34,NULL,'unlikely',NULL,'5%-24%',NULL,'may occur only in execptional circumstances.','002_008','5','5'),
 (35,NULL,'rarely',NULL,'<5%',NULL,'never observed. ','002_008','0.5','6'),
 (36,NULL,'probability',NULL,'probability',NULL,'expected','002_009','0','1'),
 (37,NULL,'almost certain',NULL,'more than 95%',NULL,'the pressure is expected to occur regularly in this ecological unit.','002_009','5000','2'),
 (38,NULL,'likely',NULL,'76%-95%',NULL,'the pressures are expected to occur here more than once.','002_009','500','3'),
 (39,NULL,'moderate',NULL,'25%-75%',NULL,'uncommon, but some evidence to suggest that it is possible to occur in this ecological unit.','002_009','50','4'),
 (40,NULL,'unlikely',NULL,'5%-24%',NULL,'the impact could potentially occur infrequently in this ecological unit.','002_009','5','5'),
 (41,NULL,'rare',NULL,'<5%',NULL,'not expected, but not impossible. ','002_009','0.5','6');
/*!40000 ALTER TABLE `poll_bak` ENABLE KEYS */;
--
-- Definition of table `projects`
--
DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title_inp_fr` varchar(255) default NULL,
  `title_inp_en` varchar(255) default NULL,
  `desc_txt_fr` varchar(255) default NULL,
  `desc_txt_en` varchar(255) default NULL,
  `parordre_int` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `projects`
--
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
--
-- Definition of table `projets_lst`
--
DROP TABLE IF EXISTS `projets_lst`;
CREATE TABLE `projets_lst` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_sel` varchar(45) default NULL,
  `projet_sel` varchar(45) default NULL,
  `driver_sel` varchar(45) default NULL,
  `choice_req` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `projets_lst`
--
/*!40000 ALTER TABLE `projets_lst` DISABLE KEYS */;
INSERT INTO `projets_lst` (`id`,`user_sel`,`projet_sel`,`driver_sel`,`choice_req`) VALUES 
 (16,'6','6','1','a:1:{i:1;a:2:{i:13;a:1:{s:7:\"choices\";a:7:{s:8:\"choice_3\";s:2:\"13\";s:8:\"choice_4\";s:2:\"17\";s:8:\"choice_5\";s:2:\"20\";s:8:\"choice_6\";s:2:\"25\";s:8:\"choice_7\";s:2:\"29\";s:8:\"choice_8\";s:2:\"34\";s:8:\"choice_9\";s:2:\"40\";}}i:14;a:1:{s:7:\"choices\";a:6:{s:8:\"choice_3\";s:2:\"12\";s:8:\"choice_4\";s:2:\"17\";s:8:\"choice_5\";s:2:\"20\";s:8:\"choice_7\";s:2:\"27\";s:8:\"choice_8\";s:2:\"34\";s:8:\"choice_9\";s:2:\"40\";}}}}'),
 (17,'6','10','1','a:2:{i:1;a:1:{i:13;a:1:{s:7:\"choices\";a:7:{s:8:\"choice_3\";s:2:\"11\";s:8:\"choice_4\";s:2:\"16\";s:8:\"choice_5\";s:2:\"21\";s:8:\"choice_6\";s:2:\"25\";s:8:\"choice_7\";s:2:\"28\";s:8:\"choice_8\";s:2:\"31\";s:8:\"choice_9\";s:2:\"38\";}}}i:9;a:1:{i:14;a:1:{s:7:\"choices\";a:3:{s:8:\"choice_3\";s:2:\"12\";s:8:\"choice_8\";s:2:\"33\";s:8:\"choice_9\";s:2:\"37\";}}}}');
/*!40000 ALTER TABLE `projets_lst` ENABLE KEYS */;
--
-- Definition of table `units`
--
DROP TABLE IF EXISTS `units`;
CREATE TABLE `units` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_fk` int(11) default NULL,
  `title_inp_fr` varchar(255) default NULL,
  `title_inp_en` varchar(255) default NULL,
  `desc_txt_fr` text,
  `desc_txt_en` text,
  `choice_req` text,
  `parordre_int` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `units`
--
/*!40000 ALTER TABLE `units` DISABLE KEYS */;
INSERT INTO `units` (`id`,`user_fk`,`title_inp_fr`,`title_inp_en`,`desc_txt_fr`,`desc_txt_en`,`choice_req`,`parordre_int`) VALUES 
 (63,6,NULL,'baie de caraquet',NULL,'baie de caraquet','a:1:{i:63;a:3:{s:6:\"titles\";s:16:\"baie de caraquet\";s:11:\"drivers_chk\";a:3:{i:3;a:5:{s:2:\"id\";i:3;s:5:\"title\";s:15:\"Fish Processing\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:28.857142866000000225312760449014604091644287109375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:5;a:5:{s:2:\"id\";i:5;s:5:\"title\";s:9:\"Fisheries\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"23\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:1457.285714722999955483828671276569366455078125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:11;a:5:{s:2:\"id\";i:11;s:5:\"title\";s:16:\"Marine Transport\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"19\";i:7;s:2:\"23\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:4300.0000012900009096483699977397918701171875;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:6:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:3:{i:3;s:2:\"13\";i:5;s:2:\"13\";i:11;s:2:\"13\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"39\";i:12;s:2:\"46\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1457.142857580000054440461099147796630859375;s:1:\"X\";d:5.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:3;s:2:\"15\";i:11;s:2:\"15\";}}i:17;a:6:{s:2:\"id\";s:2:\"17\";s:5:\"title\";s:19:\"Biomass alterations\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"36\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:5500;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:5;s:2:\"17\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"37\";i:11;s:2:\"40\";i:12;s:2:\"46\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";i:10;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:3;s:2:\"18\";i:5;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"36\";i:11;s:2:\"41\";i:12;s:2:\"44\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:14.5714285760000006320069587673060595989227294921875;s:1:\"X\";i:1000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:3:{i:3;s:2:\"19\";i:5;s:2:\"19\";i:11;s:2:\"19\";}}i:20;a:6:{s:2:\"id\";s:2:\"20\";s:5:\"title\";s:32:\"Introduction of invasive species\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"46\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";i:10;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:3;s:2:\"20\";i:11;s:2:\"20\";}}}}}',NULL),
 (64,6,NULL,'test001',NULL,'test001','a:1:{i:64;a:3:{s:6:\"titles\";s:7:\"test001\";s:11:\"drivers_chk\";a:2:{i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:0.571428571999999945774106890894472599029541015625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:3;a:5:{s:2:\"id\";i:3;s:5:\"title\";s:15:\"Fish Processing\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"21\";i:7;s:2:\"24\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:43.00000001299999752291114418767392635345458984375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:8:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1457.142857580000054440461099147796630859375;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"13\";i:3;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:11;s:2:\"40\";i:12;s:2:\"47\";i:13;s:2:\"51\";i:10;s:2:\"35\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";d:50.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:13;s:2:\"49\";i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"43\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"15\";i:3;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:11;s:2:\"40\";i:10;s:2:\"35\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1457.142857580000054440461099147796630859375;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"16\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"46\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";d:5.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"18\";i:3;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";d:50.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"19\";i:3;s:2:\"19\";}}i:20;a:6:{s:2:\"id\";s:2:\"20\";s:5:\"title\";s:32:\"Introduction of invasive species\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"44\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";d:500.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:3;s:2:\"20\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";d:5000.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"21\";}}}}}',NULL),
 (67,6,NULL,'tous selectionner',NULL,'test003hhh','a:1:{i:67;a:3:{s:6:\"titles\";s:8:\"test 003\";s:11:\"drivers_chk\";a:12:{i:1;a:5:{s:2:\"id\";i:1;s:5:\"title\";s:14:\"Municipalities\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"20\";i:7;s:2:\"24\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:1457.285714722999955483828671276569366455078125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"24\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:57.14285715999999837322320672683417797088623046875;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:3;a:5:{s:2:\"id\";i:3;s:5:\"title\";s:15:\"Fish Processing\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:0.57142857199999996797856738339760340750217437744140625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:4;a:5:{s:2:\"id\";i:4;s:5:\"title\";s:11:\"Aquaculture\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"24\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:57.14285715999999837322320672683417797088623046875;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:5;a:5:{s:2:\"id\";i:5;s:5:\"title\";s:9:\"Fisheries\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"19\";i:7;s:2:\"23\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:5714.285716000000320491380989551544189453125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:6;a:5:{s:2:\"id\";i:6;s:5:\"title\";s:10:\"Industries\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:8;s:2:\"29\";i:7;s:2:\"24\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:14.714285718999999375000697909854352474212646484375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:7;a:5:{s:2:\"id\";i:7;s:5:\"title\";s:6:\"Mining\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"24\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:43.00000001299999752291114418767392635345458984375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:8;a:5:{s:2:\"id\";i:8;s:5:\"title\";s:8:\"Forestry\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:7;s:2:\"23\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:2857.4285722860004170797765254974365234375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:9;a:5:{s:2:\"id\";i:9;s:5:\"title\";s:11:\"Agriculture\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"20\";i:7;s:2:\"23\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:1443.142857575999869368388317525386810302734375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:10;a:5:{s:2:\"id\";i:10;s:5:\"title\";s:14:\"Land Transport\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"19\";i:7;s:2:\"25\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:2871.57142943300050319521687924861907958984375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:11;a:5:{s:2:\"id\";i:11;s:5:\"title\";s:16:\"Marine Transport\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"19\";i:7;s:2:\"23\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:5714.285716000000320491380989551544189453125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:12;a:5:{s:2:\"id\";i:12;s:5:\"title\";s:22:\"Tourism and Recreation\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"21\";i:7;s:2:\"24\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:28.857142866000000225312760449014604091644287109375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:9:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:12:{i:1;s:2:\"13\";i:2;s:2:\"13\";i:3;s:2:\"13\";i:4;s:2:\"13\";i:5;s:2:\"13\";i:6;s:2:\"13\";i:7;s:2:\"13\";i:8;s:2:\"13\";i:9;s:2:\"13\";i:10;s:2:\"13\";i:11;s:2:\"13\";i:12;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:9:{i:1;s:2:\"14\";i:2;s:2:\"14\";i:4;s:2:\"14\";i:6;s:2:\"14\";i:7;s:2:\"14\";i:8;s:2:\"14\";i:9;s:2:\"14\";i:10;s:2:\"14\";i:12;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.4285714290000000037395011531771160662174224853515625;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:6:{i:1;s:2:\"15\";i:2;s:2:\"15\";i:3;s:2:\"15\";i:4;s:2:\"15\";i:9;s:2:\"15\";i:11;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"40\";i:12;s:2:\"46\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:10;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:8:{i:1;s:2:\"16\";i:2;s:2:\"16\";i:6;s:2:\"16\";i:7;s:2:\"16\";i:8;s:2:\"16\";i:9;s:2:\"16\";i:10;s:2:\"16\";i:12;s:2:\"16\";}}i:17;a:6:{s:2:\"id\";s:2:\"17\";s:5:\"title\";s:19:\"Biomass alterations\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"37\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1443.00000043299996832502074539661407470703125;s:1:\"X\";i:5005;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:5;s:2:\"17\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"40\";i:12;s:2:\"46\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:14.571428575999998855650119367055594921112060546875;s:1:\"X\";i:55;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:11:{i:1;s:2:\"18\";i:2;s:2:\"18\";i:3;s:2:\"18\";i:4;s:2:\"18\";i:5;s:2:\"18\";i:6;s:2:\"18\";i:7;s:2:\"18\";i:8;s:2:\"18\";i:9;s:2:\"18\";i:10;s:2:\"18\";i:12;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:9:{i:1;s:2:\"19\";i:2;s:2:\"19\";i:3;s:2:\"19\";i:4;s:2:\"19\";i:5;s:2:\"19\";i:6;s:2:\"19\";i:8;s:2:\"19\";i:9;s:2:\"19\";i:11;s:2:\"19\";}}i:20;a:6:{s:2:\"id\";s:2:\"20\";s:5:\"title\";s:32:\"Introduction of invasive species\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:3:{i:3;s:2:\"20\";i:4;s:2:\"20\";i:11;s:2:\"20\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"36\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1443.00000043299996832502074539661407470703125;s:1:\"X\";d:5000.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:7:{i:2;s:2:\"21\";i:6;s:2:\"21\";i:7;s:2:\"21\";i:8;s:2:\"21\";i:9;s:2:\"21\";i:10;s:2:\"21\";i:12;s:2:\"21\";}}}}}',NULL),
 (68,6,NULL,'test 004',NULL,'test 004','a:1:{i:68;a:3:{s:6:\"titles\";s:8:\"test 004\";s:11:\"drivers_chk\";a:1:{i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:1:{i:5;s:2:\"15\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:1428.57142900000008012284524738788604736328125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:7:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"16\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"19\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"21\";}}}}}',NULL),
 (69,1,NULL,'denis 0001',NULL,'denis 0001','a:1:{i:69;a:3:{s:6:\"titles\";s:10:\"denis 0001\";s:11:\"drivers_chk\";a:12:{i:1;a:5:{s:2:\"id\";i:1;s:5:\"title\";s:14:\"Municipalities\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:3;a:5:{s:2:\"id\";i:3;s:5:\"title\";s:15:\"Fish Processing\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:4;a:5:{s:2:\"id\";i:4;s:5:\"title\";s:11:\"Aquaculture\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"21\";i:7;s:2:\"24\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:1443.142857575999869368388317525386810302734375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:5;a:5:{s:2:\"id\";i:5;s:5:\"title\";s:9:\"Fisheries\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:6;a:5:{s:2:\"id\";i:6;s:5:\"title\";s:10:\"Industries\";s:7:\"choices\";a:4:{i:6;s:2:\"21\";i:5;s:2:\"16\";i:7;s:2:\"24\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:28.857142866000000225312760449014604091644287109375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:7;a:5:{s:2:\"id\";i:7;s:5:\"title\";s:6:\"Mining\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:8;a:5:{s:2:\"id\";i:8;s:5:\"title\";s:8:\"Forestry\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:9;a:5:{s:2:\"id\";i:9;s:5:\"title\";s:11:\"Agriculture\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:10;a:5:{s:2:\"id\";i:10;s:5:\"title\";s:14:\"Land Transport\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:11;a:5:{s:2:\"id\";i:11;s:5:\"title\";s:16:\"Marine Transport\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:12;a:5:{s:2:\"id\";i:12;s:5:\"title\";s:22:\"Tourism and Recreation\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:1:{s:1:\"Y\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:9:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:12:{i:1;s:2:\"13\";i:2;s:2:\"13\";i:3;s:2:\"13\";i:4;s:2:\"13\";i:5;s:2:\"13\";i:6;s:2:\"13\";i:7;s:2:\"13\";i:8;s:2:\"13\";i:9;s:2:\"13\";i:10;s:2:\"13\";i:11;s:2:\"13\";i:12;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:9:{i:1;s:2:\"14\";i:2;s:2:\"14\";i:4;s:2:\"14\";i:6;s:2:\"14\";i:7;s:2:\"14\";i:8;s:2:\"14\";i:9;s:2:\"14\";i:10;s:2:\"14\";i:12;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:6:{i:1;s:2:\"15\";i:2;s:2:\"15\";i:3;s:2:\"15\";i:4;s:2:\"15\";i:9;s:2:\"15\";i:11;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:8:{i:1;s:2:\"16\";i:2;s:2:\"16\";i:6;s:2:\"16\";i:7;s:2:\"16\";i:8;s:2:\"16\";i:9;s:2:\"16\";i:10;s:2:\"16\";i:12;s:2:\"16\";}}i:17;a:6:{s:2:\"id\";s:2:\"17\";s:5:\"title\";s:19:\"Biomass alterations\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:5;s:2:\"17\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:11:{i:1;s:2:\"18\";i:2;s:2:\"18\";i:3;s:2:\"18\";i:4;s:2:\"18\";i:5;s:2:\"18\";i:6;s:2:\"18\";i:7;s:2:\"18\";i:8;s:2:\"18\";i:9;s:2:\"18\";i:10;s:2:\"18\";i:12;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:9:{i:1;s:2:\"19\";i:2;s:2:\"19\";i:3;s:2:\"19\";i:4;s:2:\"19\";i:5;s:2:\"19\";i:6;s:2:\"19\";i:8;s:2:\"19\";i:9;s:2:\"19\";i:11;s:2:\"19\";}}i:20;a:6:{s:2:\"id\";s:2:\"20\";s:5:\"title\";s:32:\"Introduction of invasive species\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:3:{i:3;s:2:\"20\";i:4;s:2:\"20\";i:11;s:2:\"20\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:7:{i:2;s:2:\"21\";i:6;s:2:\"21\";i:7;s:2:\"21\";i:8;s:2:\"21\";i:9;s:2:\"21\";i:10;s:2:\"21\";i:12;s:2:\"21\";}}}}}',NULL),
 (70,1,NULL,'denis 002',NULL,'denis 002','a:1:{i:70;a:3:{s:6:\"titles\";s:9:\"denis 002\";s:11:\"drivers_chk\";a:1:{i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"24\";i:8;s:2:\"28\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:57.14285715999999837322320672683417797088623046875;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:7:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"46\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:14.5714285760000006320069587673060595989227294921875;s:1:\"X\";i:10;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"44\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:1000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"16\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1428.8571432859998822095803916454315185546875;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"19\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"44\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";i:1000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:2;s:2:\"21\";}}}}}',NULL),
 (71,1,NULL,'denistest',NULL,'<p>FJFJGFHGFFHFHGFHGFHFHFG</p>','a:1:{i:71;a:3:{s:6:\"titles\";s:9:\"denistest\";s:11:\"drivers_chk\";a:4:{i:1;a:5:{s:2:\"id\";i:1;s:5:\"title\";s:14:\"Municipalities\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"19\";i:7;s:2:\"24\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:4300.000001290000000153668224811553955078125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:3;a:5:{s:2:\"id\";i:3;s:5:\"title\";s:15:\"Fish Processing\";s:7:\"choices\";a:4:{i:5;s:2:\"15\";i:6;s:2:\"20\";i:7;s:2:\"23\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:4300.000001290000000153668224811553955078125;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:5;a:5:{s:2:\"id\";i:5;s:5:\"title\";s:9:\"Fisheries\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"23\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:2885.71428658000013456330634653568267822265625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:7;a:5:{s:2:\"id\";i:7;s:5:\"title\";s:6:\"Mining\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"19\";i:7;s:2:\"24\";i:8;s:2:\"27\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:2885.71428658000013456330634653568267822265625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:9:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"40\";i:12;s:2:\"44\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:5500;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:4:{i:1;s:2:\"13\";i:3;s:2:\"13\";i:5;s:2:\"13\";i:7;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"40\";i:12;s:2:\"43\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:1;s:2:\"14\";i:7;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";i:5500;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:1;s:2:\"15\";i:3;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"36\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2871.428572290000374778173863887786865234375;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:1;s:2:\"16\";i:7;s:2:\"16\";}}i:17;a:6:{s:2:\"id\";s:2:\"17\";s:5:\"title\";s:19:\"Biomass alterations\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"37\";i:11;s:2:\"40\";i:12;s:2:\"44\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:1443.00000043299996832502074539661407470703125;s:1:\"X\";i:1000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:5;s:2:\"17\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"44\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:5500;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:4:{i:1;s:2:\"18\";i:3;s:2:\"18\";i:5;s:2:\"18\";i:7;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"45\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2857.2857151429998339153826236724853515625;s:1:\"X\";i:550;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:3:{i:1;s:2:\"19\";i:3;s:2:\"19\";i:5;s:2:\"19\";}}i:20;a:6:{s:2:\"id\";s:2:\"20\";s:5:\"title\";s:32:\"Introduction of invasive species\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"41\";i:12;s:2:\"43\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";i:5500;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:3;s:2:\"20\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"46\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";d:5.5;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:7;s:2:\"21\";}}}}}',NULL),
 (72,6,NULL,'testeur 001',NULL,'tt001','a:1:{i:72;a:3:{s:6:\"titles\";s:5:\"tt001\";s:11:\"drivers_chk\";a:2:{i:2;a:5:{s:2:\"id\";i:2;s:5:\"title\";s:26:\"Residential and commercial\";s:7:\"choices\";a:4:{i:5;s:2:\"16\";i:6;s:2:\"20\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:28.857142866000000225312760449014604091644287109375;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}i:9;a:5:{s:2:\"id\";i:9;s:5:\"title\";s:11:\"Agriculture\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:0.571428571999999945774106890894472599029541015625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:7:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"41\";i:12;s:2:\"46\";i:13;s:2:\"52\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:28.714285722999999705962181906215846538543701171875;s:1:\"X\";i:10;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"13\";i:9;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"14\";i:9;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"39\";i:12;s:2:\"43\";i:13;s:2:\"49\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:4285.714287000000695115886628627777099609375;s:1:\"X\";i:10000;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"15\";i:9;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"16\";i:9;s:2:\"16\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"33\";i:10;s:2:\"37\";i:11;s:2:\"41\";i:12;s:2:\"46\";i:13;s:2:\"50\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:0.42857142899999995933058016817085444927215576171875;s:1:\"X\";i:505;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"18\";i:9;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"31\";i:10;s:2:\"35\";i:11;s:2:\"41\";i:12;s:2:\"47\";i:13;s:2:\"53\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:2857.28571514300028866273351013660430908203125;s:1:\"X\";d:1;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"19\";i:9;s:2:\"19\";}}i:21;a:6:{s:2:\"id\";s:2:\"21\";s:5:\"title\";s:24:\"Riparian zone alteration\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:2:{i:2;s:2:\"21\";i:9;s:2:\"21\";}}}}}',NULL),
 (73,1,NULL,'new test eco',NULL,'new test eco','a:1:{i:73;a:3:{s:6:\"titles\";s:12:\"new test eco\";s:11:\"drivers_chk\";a:1:{i:1;a:5:{s:2:\"id\";i:1;s:5:\"title\";s:14:\"Municipalities\";s:7:\"choices\";a:4:{i:5;s:2:\"17\";i:6;s:2:\"21\";i:7;s:2:\"25\";i:8;s:2:\"29\";}s:5:\"coord\";a:1:{s:1:\"Y\";d:0.571428571999999945774106890894472599029541015625;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}}}s:13:\"stressors_chk\";a:6:{i:13;a:6:{s:2:\"id\";s:2:\"13\";s:5:\"title\";s:28:\"Introduction of contaminants\";s:7:\"choices\";a:5:{i:9;s:2:\"32\";i:10;s:2:\"36\";i:11;s:2:\"40\";i:12;s:2:\"45\";i:13;s:2:\"51\";}s:5:\"coord\";a:2:{s:1:\"Y\";d:42.85714286999999700356056564487516880035400390625;s:1:\"X\";i:100;}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"13\";}}i:14;a:6:{s:2:\"id\";s:2:\"14\";s:5:\"title\";s:24:\"Sediment load alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"14\";}}i:15;a:6:{s:2:\"id\";s:2:\"15\";s:5:\"title\";s:25:\"Introduction of pathogens\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"15\";}}i:16;a:6:{s:2:\"id\";s:2:\"16\";s:5:\"title\";s:26:\"Fish habitat fragmentation\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"16\";}}i:18;a:6:{s:2:\"id\";s:2:\"18\";s:5:\"title\";s:28:\"Hydrologic regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"18\";}}i:19;a:6:{s:2:\"id\";s:2:\"19\";s:5:\"title\";s:26:\"Nutrient regime alteration\";s:7:\"choices\";a:0:{}s:5:\"coord\";a:2:{s:1:\"Y\";s:0:\"\";s:1:\"X\";s:0:\"\";}s:7:\"process\";a:1:{s:7:\"percent\";s:0:\"\";}s:6:\"parent\";a:1:{i:1;s:2:\"19\";}}}}}',NULL);
/*!40000 ALTER TABLE `units` ENABLE KEYS */;
--
-- Definition of table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `firstname_inp` varchar(255) default NULL,
  `lastname_inp` varchar(255) default NULL,
  `username_inp` varchar(100) default NULL,
  `password_psw` varchar(45) default NULL,
  `email_ema` varchar(100) default NULL,
  `level_inp` varchar(45) default NULL,
  `active_chk` varchar(45) default NULL,
  `region_inp` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`,`firstname_inp`,`lastname_inp`,`username_inp`,`password_psw`,`email_ema`,`level_inp`,`active_chk`,`region_inp`) VALUES 
 (1,'denis','demers','denis','2password',NULL,'1','on',NULL),
 (6,NULL,NULL,'admin','1password',NULL,'3','on',NULL),
 (11,'matthew','hardy','matthew','password1',NULL,'1','on',NULL),
 (12,'roland',NULL,'roland','password2',NULL,'1','on',NULL),
 (13,'denis','derosiers','derosiers','password3',NULL,'1','on',NULL),
 (14,NULL,NULL,'','',NULL,'1','',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;