-- MySQL dump 10.10
--
-- Host: gbellido    Database: catalogo_siia
-- ------------------------------------------------------
-- Server version	5.0.18-nt-max

/*!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 `agrupacion`
--

DROP TABLE IF EXISTS `agrupacion`;
CREATE TABLE `agrupacion` (
  `C_AGRUPACION` bigint(20) NOT NULL auto_increment,
  `D_AGRUPACION` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_AGRUPACION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agrupacion`
--


/*!40000 ALTER TABLE `agrupacion` DISABLE KEYS */;
LOCK TABLES `agrupacion` WRITE;
INSERT INTO `agrupacion` VALUES (1,'Ortoimágenes','Categoría que engloba a las distintas ortofotos'),(2,'Divisiones administrativas','Divisiones administrativas'),(3,'Elementos territoriales','Elementos territoriales'),(4,'Topográfico','Topografía'),(5,'Divisiones territoriales','Divisiones territoriales'),(6,'SigPac','SigPac'),(7,'Acuicultura','Acuicultura'),(14,'Hidrología','Hidrología'),(13,'Varios','Varios'),(12,'Infraestructura Hidráulica','Infraestructura Hidráulica'),(15,'Auxiliares','Auxiliares'),(16,'Ganaderia','Ganadería'),(11001,'Pesca','Pesca');
UNLOCK TABLES;
/*!40000 ALTER TABLE `agrupacion` ENABLE KEYS */;

--
-- Table structure for table `aplicaciones`
--

DROP TABLE IF EXISTS `aplicaciones`;
CREATE TABLE `aplicaciones` (
  `C_APLICACION` bigint(20) NOT NULL auto_increment,
  `TYPE` varchar(255) NOT NULL default '',
  `N_ORDEN` int(11) NOT NULL default '0',
  `T_NOMBRE` varchar(255) default NULL,
  `T_DESCRIPCION` varchar(255) default NULL,
  `T_AMBITO` int(11) NOT NULL default '0',
  `T_URL` varchar(255) NOT NULL default '',
  `T_URL_IMAGEN` varchar(255) NOT NULL default '',
  `T_CLASS_NAME` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`C_APLICACION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aplicaciones`
--


/*!40000 ALTER TABLE `aplicaciones` DISABLE KEYS */;
LOCK TABLES `aplicaciones` WRITE;
INSERT INTO `aplicaciones` VALUES (1,'HEAVY_CLIENT',0,'Visor SigPAC 1.0','',0,'','','org.dap.sig.applications.appVisorSigpac.AppVisorSigpacApplicationContext'),(13,'HEAVY_CLIENT',0,'Aplicación Cropac','',0,'','','org.dap.sig.applications.appCropac.AppCropacApplicationContext');
UNLOCK TABLES;
/*!40000 ALTER TABLE `aplicaciones` ENABLE KEYS */;

--
-- Table structure for table `aplicaciones_layers`
--

DROP TABLE IF EXISTS `aplicaciones_layers`;
CREATE TABLE `aplicaciones_layers` (
  `C_APLICACION_LAYER` bigint(20) NOT NULL auto_increment,
  `B_EDITABLE` tinyint(1) NOT NULL default '0',
  `B_SELECCIONABLE` tinyint(1) NOT NULL default '0',
  `C_APLICACION` bigint(20) NOT NULL default '0',
  `LAYER_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_APLICACION_LAYER`),
  KEY `LAYER_ID` (`LAYER_ID`),
  KEY `C_APLICACION` (`C_APLICACION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aplicaciones_layers`
--


/*!40000 ALTER TABLE `aplicaciones_layers` DISABLE KEYS */;
LOCK TABLES `aplicaciones_layers` WRITE;
INSERT INTO `aplicaciones_layers` VALUES (179,0,0,1,22),(21,0,0,1,1),(180,0,0,1,23),(22,0,0,1,2),(190,0,0,1,1068),(184,0,0,1,28),(25,0,0,1,6),(183,0,0,1,27),(181,0,0,1,24),(188,0,0,1,1067),(178,0,0,1,21),(24,0,0,1,4),(187,0,0,1,25),(23,0,0,1,3),(238,0,0,1,1076),(1121,0,0,1,74),(1120,0,0,1,1120),(13003,0,0,13,6),(13004,0,0,13,1067),(13005,0,0,13,1068),(13001,0,0,13,1),(13002,0,0,13,2),(13006,0,0,13,1076),(13007,0,0,13,1120),(13008,0,0,13,13001),(13009,0,0,13,13002),(13010,0,0,13,74),(13015,0,0,13,13003),(13016,0,0,13,13004),(13017,0,0,13,13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `aplicaciones_layers` ENABLE KEYS */;

--
-- Table structure for table `aplicaciones_modulos`
--

DROP TABLE IF EXISTS `aplicaciones_modulos`;
CREATE TABLE `aplicaciones_modulos` (
  `C_APLICACION_MODULO` bigint(20) NOT NULL auto_increment,
  `N_ORDEN` int(11) NOT NULL default '0',
  `B_ADD_SEPARATOR` tinyint(1) default NULL,
  `C_APLICACION` bigint(20) NOT NULL default '0',
  `C_MODULO` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_APLICACION_MODULO`),
  KEY `C_MODULO` (`C_MODULO`),
  KEY `C_APLICACION` (`C_APLICACION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aplicaciones_modulos`
--


/*!40000 ALTER TABLE `aplicaciones_modulos` DISABLE KEYS */;
LOCK TABLES `aplicaciones_modulos` WRITE;
INSERT INTO `aplicaciones_modulos` VALUES (14,50,0,1,1),(15,4,0,1,2),(16,3,0,1,3),(17,8,1,1,4),(18,5,0,1,5),(19,7,0,1,6),(20,2,0,1,7),(110,16,1,1,38),(22,6,0,1,9),(23,10,0,1,10),(24,12,1,1,11),(25,11,0,1,12),(26,1,0,1,13),(107,43,1,1,34),(108,14,0,1,35),(109,15,0,1,36),(165,41,1,1,52),(166,40,0,1,53),(199,21,0,1,59),(200,22,1,1,60),(201,42,0,1,64),(13001,3,0,13,3),(13002,4,0,13,2),(13003,5,0,13,5),(13004,7,0,13,6),(13005,8,0,13,4),(13006,6,0,13,9),(13007,11,0,13,12),(13008,12,0,13,11),(13010,14,0,13,35),(13011,5000,0,13,1),(13012,17,0,13,34),(13013,2,0,13,7),(13014,1,0,13,13),(13015,21,0,13,59),(13016,22,0,13,60),(13017,10,0,13,10),(13018,1000,0,13,13001),(13019,100,0,13,13002),(13021,102,0,13,13004);
UNLOCK TABLES;
/*!40000 ALTER TABLE `aplicaciones_modulos` ENABLE KEYS */;

--
-- Table structure for table `atributes_types`
--

DROP TABLE IF EXISTS `atributes_types`;
CREATE TABLE `atributes_types` (
  `C_ATRIBUTE_TYPE` bigint(20) NOT NULL auto_increment,
  `T_NOMBRE` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_ATRIBUTE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `atributes_types`
--


/*!40000 ALTER TABLE `atributes_types` DISABLE KEYS */;
LOCK TABLES `atributes_types` WRITE;
INSERT INTO `atributes_types` VALUES (1,'STRING','Tipo cadena'),(2,'GEOMETRY','Tipo geometria'),(3,'INTEGER','Tipo entero'),(5,'DATE','Tipo fecha'),(6,'DOUBLE','Tipo real largo'),(4,'LONG','Tipo Entero Largo'),(8,'OBJECT','Tipo objeto');
UNLOCK TABLES;
/*!40000 ALTER TABLE `atributes_types` ENABLE KEYS */;


--
-- Table structure for table `databases_types`
--

DROP TABLE IF EXISTS `databases_types`;
CREATE TABLE `databases_types` (
  `C_DATABASE_TYPE` bigint(20) NOT NULL auto_increment,
  `D_DATABASE_TYPE` varchar(255) NOT NULL default '',
  `T_CLASS_NAME` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`C_DATABASE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `databases_types`
--


/*!40000 ALTER TABLE `databases_types` DISABLE KEYS */;
LOCK TABLES `databases_types` WRITE;
INSERT INTO `databases_types` VALUES (1,'MYSQL','org.dap.sig.core.io.dataaccesor.MySQL5DataAccesor'),(3,'SPATIAL','org.dap.sig.core.io.dataaccesor.OracleLocator9iDataAccesor'),(4,'POSTGIS','org.dap.sig.core.io.dataaccesor.PostGisDataAccesor'),(5,'ORACLE','org.dap.sig.core.io.dataaccesor.OracleAlphaDataAccesor');
UNLOCK TABLES;
/*!40000 ALTER TABLE `databases_types` ENABLE KEYS */;

--
-- Table structure for table `entidades_intermedias`
--

DROP TABLE IF EXISTS `entidades_intermedias`;
CREATE TABLE `entidades_intermedias` (
  `C_ENTIDAD_IN` bigint(20) NOT NULL default '0',
  `T_FIELD_ORIGEN` varchar(255) NOT NULL default '',
  `T_FIELD_DES` varchar(255) NOT NULL default '',
  `C_GEOMETRY_COLUMN` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_ENTIDAD_IN`),
  KEY `C_ENTIDAD_IN` (`C_ENTIDAD_IN`),
  KEY `C_GEOMETRY_COLUMN` (`C_GEOMETRY_COLUMN`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `entidades_intermedias`
--


/*!40000 ALTER TABLE `entidades_intermedias` DISABLE KEYS */;
LOCK TABLES `entidades_intermedias` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `entidades_intermedias` ENABLE KEYS */;

--
-- Table structure for table `feature_type_styles`
--

DROP TABLE IF EXISTS `feature_type_styles`;
CREATE TABLE `feature_type_styles` (
  `FEATURE_TYPE_STYLE_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `TITLE` varchar(255) default NULL,
  `FEATURE_TYPE_NAME` varchar(255) NOT NULL default '',
  `LAYER_ID` bigint(20) default NULL,
  PRIMARY KEY  (`FEATURE_TYPE_STYLE_ID`),
  KEY `LAYER_ID` (`LAYER_ID`),
  KEY `LAYER_ID_2` (`LAYER_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feature_type_styles`
--


/*!40000 ALTER TABLE `feature_type_styles` DISABLE KEYS */;
LOCK TABLES `feature_type_styles` WRITE;
INSERT INTO `feature_type_styles` VALUES (1,'provinciasStyle','Estilo para las Provincias','provinciasStyle',1),(26,'instalacionesAcuiferasStyle','Estilo para etiquetar las Instalaciones Acuíferas','instalacionesAcuiferasStyle',30),(3,'municipiosStyle','Estilo para los Municipios','municipiosStyle',2),(5,'localizadorAcuiculturaStyle','Estilo para etiquetar los resultados de las búsquedas en el localizador de Acuicultura','localizadorAcuiculturaStyle',66),(4,'ortofoto_1_5000Style','Estilo de la capa Ortofoto 1:5000','ortofoto_1_5000Style',6),(8,'nucleosStyle','Estilo para los Núcleos','nucleosStyle',3),(9,'ocasStyle','Estilo para las OCAs','ocasStyle',4),(10,'mta_50000Style','Estilo para el Mapa Topográfico 1:50.000 en color','MTA_50000Style',9),(11,'mta_10000Style','Estilo para el Topográfico 1:10.000 en B/N','MTA_10000Style',10),(12,'spotStyle','Estilo para el Satélite SPOT 1998','spotStyle',11),(13,'elevacionesStyle','Estilo para el MTA 1:100000','elevacionesStyle',15),(14,'icaStyle','Estilo para el ICA (Topográfico 1:400.000)','icaStyle',13),(15,'sigOleicoStyle','Estilo para el SIG Oleícola','sigOleicoStyle',16),(16,'relieve20x20Style','Estilo para el Relieve 20x20 1995','relieve20x20Style',64),(17,'ortofoto_1_10000Style','Estilo de la capa Ortofoto 1:10000','ortofoto_1_10000Style',65),(18,'irsStyle','Estilo para el Satélite IRS 1998','irsStyle',26),(19,'hojas10000Style','Estilo para las Hojas 10000','hojas10000Style',22),(20,'hojas50000Style','estilo para las Hojas 50000','hojas50000Style',21),(21,'hojas100000Style','Estilo para las Hojas 10000','hojas100000Style',23),(22,'toponimosStyle','Estilo para los topónimos','toponimosStyles',24),(23,'hidrografiaStyle','Estilo para la Red Hidrográfica','hidrografiaStyle',25),(24,'toponimiaHidrografiaStyle','Estilo para los Topónimos Hidrográficos','toponimiaHidrografiaStyle',28),(25,'carreterasStyle','Estilo para las carreteras','carreterasStyle',27),(27,'puertosStyle','Estilo para los Puertos','puertosStyle',31),(28,'zonasEspecProtecMedioambStyle','Estilo para las Zonas de Especial Protección Medioambiental','zonasEspecProtecMedioambStyle',58),(29,'caminosStyle','Estilo para los Caminos (Acuicultura)','caminosStyle',33),(30,'embalsesStyle','Estilo para los Embalses','embalsesStyle',35),(31,'almadrabasStyle','Estilo para las Almadrabas','almadrabasStyle',36),(32,'batimetriaStyle','Estilo para Batimetría','batimetriaStyle',37),(33,'puntosInteresCulturalStyle','Estilo para los Puntos de Interés Cultural','puntosInteresCulturalStyle',38),(34,'puntosVertidosStyle','Estilo para los Punto de Vertidos','puntosVertidosStyle',39),(35,'cablesSubmarinosStyle','Estilo para los Cables Submarinos','cablesSubmarinosStyle',40),(36,'emisariosSubmarinosStyle','Estilo para los Emisarios Submarinos','emisariosSubmarinosStyle',41),(37,'potStyle','Estilo para el Plan de Ordenación Territorial','potStyle',42),(38,'areasArqueologicasStyle','Estilo para las Áreas Arqueológicas','areasArqueologicasStyle',43),(39,'arrecifesStyle','Estilo para los Arrecifes','arrecifesStyle',44),(40,'salinasStyle','Estilo para las Salinas','salinasStyle',45),(41,'habitatsInteresStyle','Estilo para los Habitats de Interes','habitatsInteresStyle',46),(42,'lugaresInteresComunitariosStyle','Estilo para los Lugares de Interés Comunitario','lugaresInteresComunitariosStyle',47),(2,'recintosSigPacStyle','Estilo para los Recintos SigPac','recintosSigPacStyle',1067),(6,'poligonosSigPacStyle','Estilo para los Polígonos SigPac','poligonosSigPacStyle',1068),(43,'extAridosStyle','Estilo para las zonas de extraccion de aridos','extAridosStyle',51),(44,'Abastecimiento','Estilo para el abastecimiento de agua','abastecimientoStyle',61),(45,'Playas de Interes','Estilo para las playas de interes','playasStyle',49),(46,'Zonas Industriales','Zonas Industriales','zonasIndustrialesStyle',50),(47,'Zonas Portuarias','Zonas Portuarias','zonasPortuariasStyle',52),(48,'Zonas Militares','Zonas Militares','zonasMilitaresStyle',53),(49,'Conductos','Conductos','conductosStyle',54),(50,'Ferrocarriles','Ferrocarriles','ferrocarrilStyle',56),(51,'Acuiferos','Acuiferos','acuiferosStyle',57),(52,'EENNPP','EENNPP','eennppStyle',63),(53,'Superficies de Aguas','Superficies de Aguas','superficiesStyle',60),(54,'Edificacion Rural','Edificacion Rural','edificacionStyle',62),(55,'Areas de Riego','Areas de Riego','areasRiegoStyle',69),(56,'Cuencas Hidrograficas','Cuencas Hidrograficas','cuencasStyle',70),(57,'Sistemas de Explotacion','Sistemas de Explotación','sistemasExpStyle',71),(58,'Areas de Riego','Areas de Riego','areasRiego0Style',72),(59,'Antigüedad Media','Antigüedad Media','areasRiego1Style',72),(60,'Consumo','Consumo','areasRiego2Style',72),(61,'COD_PTM3','COD_PTM3','areasRiego4Style',72),(62,'COD_CULT','COD_CULT','areasRiego5Style',72),(63,'PAC','PAC','areasRiego6Style',72),(66,'JORNALES','JORNALES','areasRiego9Style',72),(65,'COD_INIC','COD_INIC','areasRiego7Style',72),(64,'CAMPOAUX','CAMPOAUX','areasRiego8Style',72),(67,'M3_JORNAL','M3_JORNAL','areasRiego10Style',72),(69,'NUM_EXPL','NUM_EXPL','areasRiego12Style',72),(68,'NECHID','NECHID','areasRiego11Style',72),(70,'COD_ORIGEN','COD_ORIGEN','areasRiego13Style',72),(71,'PFA_M3','PFA_M3','areasRiego14Style',72),(72,'COD_RIEGO','COD_RIEGO','areasRiego15Style',72),(73,'SUP_ABANDO','SUP_ABANDO','areasRiego16Style',72),(74,'SUP_REGADA','SUP_REGADA','areasRiego17Style',72),(75,'SUP_REGABL','SUP_REGABL','areasRiego18Style',72),(76,'POR_TENDEN','POR_TENDEN','areasRiego19Style',72),(77,'MODA_SUP','MODA_SUP','areasRiego20Style',72),(78,'COD_DECLAR','COD_DECLAR','areasRiego21Style',72),(79,'COD_PTM3','COD_PTM3','areasRiego3Style',72),(80,'dibujarPoligonoAcuStyle','Capa auxiliar donde se dibujan los polígonos de acuicultura','dibujarPoligonoAcuStyle',73),(81,'pendienteStyle','Estilo para las pendientes','pendienteStyle',75),(82,'olivosStyle','Estilo para los olivos','olivosStyle',1076),(83,'localizadorRecintosSIGPACStyle','Localizador de Recintos SIGPAC','localizadorRecintosSIGPACStyle',77),(84,'localizadorRecintosSIGOStyle','Localizador de Recintos SIGO','localizadorRecintosSIGOStyle',78),(85,'OlivosNLocStyle','Estilo para los olivos localizados de tipo N','olivosNLocStyle',79),(86,'OlivosSLocStyle','Estilo para los olivos localizados de tipo S','olivosSLocStyle',80),(87,'OlivosALocStyle','Estilo para los olivos localizados de tipo A','olivosALocStyle',81),(88,'parcelaForestacionStyle','parcelaForestacionStyle','parcelaForestacionStyle',82),(98,'bovinoStyle','Estilo par la capa bovino de Ganadería','bovinoStyle',92),(99,'ovinoStyle','Estilo par la capa ovino de Ganadería','ovinoStyle',93),(100,'caprinoStyle','Estilo par la capa caprino de Ganadería','caprinoStyle',94),(101,'otrasStyle','Estilo par la capa otras de Ganadería','otrasStyle',95),(95,'LocParcelasSIGPACStyle','Estilo para la capa auxiliar de localización de parcelas SIGPAC','LocParcelasSIGPACStyle',89),(96,'insercionEnMapaStyle','Estilo para los elementos introducidos en el mapa','insercionEnMapaStyle',90),(97,'LocParcelasSIGPACForestacionStyle','Estilo para la capa auxiliar de localización de parcelas SIGPAC de forestación','LocParcelasSIGPACForestacionStyle',91),(102,'multipleStyle','Estilo par la capa multiple de Ganadería','multipleStyle',96),(103,'porcinoGanaderiaStyle','Estilo par la capa porcino de Ganadería','porcinoStyle',97),(104,'noSIGGANStyle','Estilo para los puntos que no pertrenecen a SIGGAN','noSIGGANStyle',98),(105,'localizadorGenericoStyle','Estilo para la capa auxiliar de cartografía General','localizadorGenericoStyle',99),(107,'bovinoStyle','Estilo par la capa bovino de Ganadería','bovinoStyle',92),(108,'ovinoStyle','Estilo para la capa ovino de Ganadería','ovinoStyle',93),(109,'caprinoStyle','Estilo para la capa caprino de Ganadería','caprinoStyle',94),(110,'otrasStyle','Estilo para la capa otras de Ganadería','otrasStyle',95),(111,'multipleStyle','Estilo para la capa multiple de Ganadería','multipleStyle',96),(112,'porcinoStyle','Estilo para la capa porcino de Ganadería','porcinoStyle',97),(113,'noSIGGANStyle','Estilo para los puntos que no pertrenecen a SIGGAN','noSIGGANStyle',98),(114,'ganProteccionStyle','Estilo para las áreas de protección de ganadería','ganProteccionStyle',101),(115,'ganVigilanciaStyle','Estilo para las áreas de vigilancia de ganadería','ganVigilanciaStyle',102),(116,'riesgoGanaderiaStyle','Estilo para las explotaciones en riesgo de Ganadería','riesgoGanaderiaStyle',103),(117,'locExpGanaderasStyle','Estilo para el localizador de explotaciones ganaderas','locExpGanaderasStyle',104),(118,'seleccionGanaderia','seleccionGanaderia','seleccionGanaderia',105),(120,'zonasRestriccionHerbicidasStyle','Estilo para las zonas de restricción de herbicidas','zonasRestriccionHerbicidasStyle',107),(1120,'frutalConCascaraStyle','Estilos de los frutales con cáscara','frutalConCascaraStyle',1120),(13001,'parcelaCroquisStyle','Estilo de croquis de parcela','parcelaCroquisStyle',13001),(13002,'olivarCropacAuxStyle','Estilos de olivar de cropac auxiliar','olivarCropacAuxStyle',13002),(13003,'OLIVAR_NStyle','Estilos de OLIVAR_N','OLIVAR_NStyle',13003),(13004,'OLIVAR_AStyle','Estilos de OLIVAR_A','OLIVAR_AStyle',13004),(13005,'OLIVAR_SStyle','Estilos de OLIVAR_S','OLIVAR_SStyle',13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `feature_type_styles` ENABLE KEYS */;

--
-- Table structure for table `features_data_accesors`
--

DROP TABLE IF EXISTS `features_data_accesors`;
CREATE TABLE `features_data_accesors` (
  `C_FEATURE_DATA_ACCESOR` bigint(20) NOT NULL auto_increment,
  `DATA_ACCESOR_TYPE` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  `T_IP` varchar(255) default NULL,
  `N_PORT` bigint(20) default NULL,
  `T_TABLE` varchar(255) default NULL,
  `C_DATA_SOURCE` int(11) default NULL,
  `T_UBICACION` varchar(255) default NULL,
  `INDEX_TABLE` varchar(255) default NULL,
  `NVC` mediumtext,
  `NHC` mediumtext,
  PRIMARY KEY  (`C_FEATURE_DATA_ACCESOR`),
  KEY `C_DATA_SOURCE` (`C_DATA_SOURCE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `features_data_accesors`
--


/*!40000 ALTER TABLE `features_data_accesors` DISABLE KEYS */;
LOCK TABLES `features_data_accesors` WRITE;
INSERT INTO `features_data_accesors` VALUES (1,'DATABASE',NULL,NULL,NULL,'provincias',1,NULL,NULL,NULL,NULL),(2,'DATABASE',NULL,NULL,NULL,'municipios',1,NULL,NULL,NULL,NULL),(3,'DATABASE',NULL,NULL,NULL,'nucleos',1,NULL,NULL,NULL,NULL),(4,'DATABASE',NULL,NULL,NULL,'ocas_correg',1,NULL,NULL,NULL,NULL),(5,'DATABASE',NULL,NULL,NULL,'hojas_100000',1,NULL,NULL,NULL,NULL),(6,'DATABASE',NULL,NULL,NULL,'hojas_10000',1,NULL,NULL,NULL,NULL),(7,'DATABASE',NULL,NULL,NULL,'hojas_50000',1,NULL,NULL,NULL,NULL),(8,'DATABASE',NULL,NULL,NULL,'hojas_100000',1,NULL,NULL,NULL,NULL),(9,'DATABASE',NULL,NULL,NULL,'hojas_50000',1,NULL,NULL,NULL,NULL),(10,'DATABASE',NULL,NULL,NULL,'hojas_10000',1,NULL,NULL,NULL,NULL),(11,'DATABASE',NULL,NULL,NULL,'hojas_100000',1,NULL,NULL,NULL,NULL),(12,'DATABASE',NULL,NULL,NULL,'toponimos_malla',1,NULL,NULL,NULL,NULL),(13,'DATABASE',NULL,NULL,NULL,'hidrografia',1,NULL,NULL,NULL,NULL),(14,'DATABASE',NULL,NULL,NULL,'carreteras',1,NULL,NULL,NULL,NULL),(15,'DATABASE',NULL,NULL,NULL,'hidrografia_nombres',1,NULL,NULL,NULL,NULL),(16,'DATABASE',NULL,NULL,NULL,'instalaciones',1,NULL,NULL,NULL,NULL),(17,'DATABASE',NULL,NULL,NULL,'instalaciones_acuiferas',1,NULL,NULL,NULL,NULL),(18,'DATABASE',NULL,NULL,NULL,'puertos',1,NULL,NULL,NULL,NULL),(19,'DATABASE',NULL,NULL,NULL,'caminos',1,NULL,NULL,NULL,NULL),(20,'DATABASE',NULL,NULL,NULL,'embalses',1,NULL,NULL,NULL,NULL),(21,'DATABASE',NULL,NULL,NULL,'embalses',1,NULL,NULL,NULL,NULL),(22,'DATABASE',NULL,NULL,NULL,'almadrabas',1,NULL,NULL,NULL,NULL),(23,'DATABASE',NULL,NULL,NULL,'batimetria',1,NULL,NULL,NULL,NULL),(24,'DATABASE',NULL,NULL,NULL,'puntos_interes_cultural',1,NULL,NULL,NULL,NULL),(25,'DATABASE',NULL,NULL,NULL,'puntos_vertidos',1,NULL,NULL,NULL,NULL),(26,'DATABASE',NULL,NULL,NULL,'cables_submarinos',1,NULL,NULL,NULL,NULL),(27,'DATABASE',NULL,NULL,NULL,'emisarios_submarinos',1,NULL,NULL,NULL,NULL),(28,'DATABASE',NULL,NULL,NULL,'plan_ordenacion_territorial',1,NULL,NULL,NULL,NULL),(29,'DATABASE',NULL,NULL,NULL,'areas_arqueologicas',1,NULL,NULL,NULL,NULL),(30,'DATABASE',NULL,NULL,NULL,'arrecifes_artificiales',1,NULL,NULL,NULL,NULL),(31,'DATABASE',NULL,NULL,NULL,'salinas',1,NULL,NULL,NULL,NULL),(32,'DATABASE',NULL,NULL,NULL,'habitats_interes',1,NULL,NULL,NULL,NULL),(33,'DATABASE',NULL,NULL,NULL,'lugares_interes_comunitario',1,NULL,NULL,NULL,NULL),(34,'DATABASE',NULL,NULL,NULL,'espacios_nat_proteg',1,NULL,NULL,NULL,NULL),(35,'DATABASE',NULL,NULL,NULL,'playas_interes',1,NULL,NULL,NULL,NULL),(36,'DATABASE',NULL,NULL,NULL,'zonas_industriales',1,NULL,NULL,NULL,NULL),(37,'DATABASE',NULL,NULL,NULL,'zonas_extraccion_aridos',1,NULL,NULL,NULL,NULL),(38,'DATABASE',NULL,NULL,NULL,'zonas_portuarias',1,NULL,NULL,NULL,NULL),(39,'DATABASE',NULL,NULL,NULL,'zonas_militares',1,NULL,NULL,NULL,NULL),(40,'DATABASE',NULL,NULL,NULL,'conductos',1,NULL,NULL,NULL,NULL),(41,'DATABASE',NULL,NULL,NULL,'espacios_nat_proteg',1,NULL,NULL,NULL,NULL),(42,'DATABASE',NULL,NULL,NULL,'ferrocarriles',1,NULL,NULL,NULL,NULL),(43,'DATABASE',NULL,NULL,NULL,'acuiferos',1,NULL,NULL,NULL,NULL),(44,'DATABASE',NULL,NULL,NULL,'espacios_nat_proteg_integral',1,NULL,NULL,NULL,NULL),(45,'DATABASE',NULL,NULL,NULL,'abastecimientos_agua',1,NULL,NULL,NULL,NULL),(46,'DATABASE',NULL,NULL,NULL,'superficies_agua',1,NULL,NULL,NULL,NULL),(47,'DATABASE',NULL,NULL,NULL,'abastecimientos_agua',1,NULL,NULL,NULL,NULL),(48,'DATABASE',NULL,NULL,NULL,'edificacion_rural',1,NULL,NULL,NULL,NULL),(49,'DATABASE',NULL,NULL,NULL,'espacios_nat_proteg',1,NULL,NULL,NULL,NULL),(50,'DATABASE',NULL,NULL,NULL,'recintos',1,NULL,NULL,NULL,NULL),(51,'DATABASE',NULL,NULL,NULL,'poligonos_sigpac',1,NULL,NULL,NULL,NULL),(52,'DATABASE',NULL,NULL,NULL,'areas_riego',1,NULL,NULL,NULL,NULL),(53,'DATABASE',NULL,NULL,NULL,'cuencas',1,NULL,NULL,NULL,NULL),(54,'DATABASE',NULL,NULL,NULL,'sistemas_exp',1,NULL,NULL,NULL,NULL),(55,'DATABASE',NULL,NULL,NULL,'zonas_reg',1,NULL,NULL,NULL,NULL),(56,'DATABASE',NULL,NULL,NULL,'fecha_orto_sigpac',1,NULL,NULL,NULL,NULL),(57,'DATABASE',NULL,NULL,NULL,'olivos',1,NULL,NULL,NULL,NULL),(1120,'DATABASE',NULL,NULL,NULL,'frutales',1,NULL,NULL,NULL,NULL),(13003,'DATABASE',NULL,NULL,NULL,'olivos_n',1,NULL,NULL,NULL,NULL),(13004,'DATABASE',NULL,NULL,NULL,'olivos_a',1,NULL,NULL,NULL,NULL),(13005,'DATABASE',NULL,NULL,NULL,'olivos_s',1,NULL,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `features_data_accesors` ENABLE KEYS */;

--
-- Table structure for table `fills`
--

DROP TABLE IF EXISTS `fills`;
CREATE TABLE `fills` (
  `FILL_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `FILL_COLOR` varchar(255) NOT NULL default '',
  `FILL_OPACITY` varchar(255) NOT NULL default '',
  `FILL_TYPE` smallint(6) NOT NULL default '0',
  `GRAPHIC_ID` bigint(20) default NULL,
  PRIMARY KEY  (`FILL_ID`),
  KEY `GRAPHIC_ID` (`GRAPHIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fills`
--


/*!40000 ALTER TABLE `fills` DISABLE KEYS */;
LOCK TABLES `fills` WRITE;
INSERT INTO `fills` VALUES (1,'Fill Etiquetas Azul','#006699','1.0',0,NULL),(12,'Fill Nucleos (Núcleo Secundario)','#009900','1.0',0,NULL),(13,'Fill Nucleos (Urbanización)','#FF6600','1.0',0,NULL),(6,'Fill Etiquetas Provincias','#000000','1.0',0,NULL),(2,'Fill Rosa Sólido','#FFCC99','1.0',0,NULL),(3,'Fill Etiquetas Localizador Instalaciones Acuíferas','#52F3FF','1.0',0,NULL),(4,'Fill Halo Etiqueta','#FFFFFF','0.5',0,NULL),(5,'Fill Instalaciones','#006699','1.0',0,NULL),(11,'Fill Nucleos (Cabecera Municipal)','#FF0000','1.0',0,NULL),(14,'Fill Nucleos (Diseminado)','#0099CC','1.0',0,NULL),(15,'Fill Etiquetas Nucleos','#000000','1.0',0,NULL),(16,'Fill Etiquetas Ocas','#006600','1.0',0,NULL),(17,'Fill Etiquetas Hojas 10000','#000000','1.0',0,NULL),(18,'Fill Etiquetas Hojas 50000','#336633','1.0',0,NULL),(19,'Fill Etiquetas Hojas 10000','#FF0000','1.0',0,NULL),(20,'Fill Etiquetas Topónimos','#000000','1.0',0,NULL),(21,'Fill Etiquetas Hidrografía','#0000FF','1.0',0,NULL),(22,'Fill Etiquetas Carreteras','#000000','1.0',0,NULL),(23,'Fill Instalaciones Acuíferas Autorizadas','#FFD4C9','1.0',0,NULL),(24,'Fill Instalaciones Acuíferas Caducadas','#E60000','1.0',0,NULL),(25,'Fill Instalaciones Acuíferas en Trámite','#FF7F7F','1.0',0,NULL),(26,'Fill Etiquetas Instalaciones','#6E6E6E','1.0',0,NULL),(27,'Fill Puertos','#00389D','1.0',0,NULL),(28,'Fill Etiquetas Puertos','#000000','1.0',0,NULL),(29,'Fill Embalses','#0000FF','1.0',0,NULL),(30,'Fill Etiquetas Embalses','#000000','1.0',0,NULL),(31,'Fill Etiquetas Almadrabas','#FCA045','1.0',0,NULL),(32,'Fill Etiquetas Batimetría','#003399','1.0',0,NULL),(33,'Fill Puntos de Vertidos','#FF0000','1.0',0,NULL),(34,'Fill Pot (Equipamientos)','#FFAA00','1.0',0,NULL),(35,'Fill Pot (Espacios Libres)','#00FCE6','1.0',0,NULL),(36,'Fill Pot (Limitaciones Específicas)','#D773FF','1.0',0,NULL),(37,'Fill Pot (Limitaciones Generales)','#E60000','1.0',0,NULL),(38,'Fill Arrecifes (En ejecución','#FF66FF','1.0',0,NULL),(39,'Fill Arrecifes (En proyecto)','#0066FF','1.0',0,NULL),(40,'Fill Arrecifes (Instalado)','#000000','1.0',0,NULL),(41,'Fill Salinas','#FFFFCC','1.0',0,NULL),(42,'Fill Etiquetas Salinas','#663300','1.0',0,NULL),(43,'Fill Hábitats de Interés','#107E31','1.0',0,NULL),(44,'Fill Propuestas de Interés Cominitario','#FFFFFF','0',1,3),(45,'Fill Graphic Propuesta Lugares de Interés Comunitario','#257405','1.0',0,NULL),(46,'Fill Etiquetas Propuesta Lugares de Interés Comunitario','#234617','1.0',0,NULL),(7,'Fill Etiquetas Municipios','#000000','1.0',0,NULL),(47,'Fill Topónimos (Geometría)','#FFFFFF','0',0,NULL),(48,'Fill Hidrografía-Nombres (Geometría)','#FFFFFF','0',0,NULL),(8,'Fill Halo Etiquetas Recintos SigPac','#FFFF00','1.0',0,NULL),(9,'Fill Etiquetas Polígonos SigPac','#FF2400','1.0',0,NULL),(49,'Fill zonas de extracción de áridos','#FFFF99','1.0',0,NULL),(50,'Fill playas 1','#FFAA00','1.0',0,NULL),(51,'Fill playas text','#804000','1.0',0,NULL),(52,'Fill Zonas','#8400A8','1.0',0,NULL),(53,'Zonas Portuarias 1','#9999FF','1.0',0,NULL),(54,'Zonas Portuarias 2','#FF0033','1.0',0,NULL),(55,'Zonas Portuarias 3','#9999FF','1.0',0,NULL),(56,'Zonas Portuarias b','#FFFFFF','1.0',1,4),(57,'Zonas Militares 1','#FFFFFF','1.0',1,2),(58,'Zonas Militares 2','#FFFFFF','1.0',1,3),(59,'FILL Acuiferos','','1.0',1,5),(60,'Fill EENNPP','#76D418','1.0',0,NULL),(61,'EENNPP Text','#009900','1.0',0,NULL),(67,'Halo EENNPP','#00FFBF','0.5',0,NULL),(68,'Fill Superficies de Aguas','#0000FF','0.8',0,NULL),(69,'Cuencas Hidrograficas','#000000','1.0',0,NULL),(70,'Fill Zonas Riego (default)','#A6FFA5','1.0',0,NULL),(71,'Areas Riego FILL 0','#FFFF00','1.0',0,NULL),(72,'Areas Riego FILL 1','#00FF00','1.0',0,NULL),(73,'Areas Riego FILL 2','#00FFFF','1.0',0,NULL),(74,'Areas Riego FILL 3','#0000FF','1.0',0,NULL),(75,'Areas Riego FILL 4','#EB5CB6','1.0',0,NULL),(76,'Areas Riego FILL 5','#FF0000','1.0',0,NULL),(78,'Areas Riego FILL 7','#FFBF00','1.0',0,NULL),(77,'Areas Riego FILL 6','#FFF9A5','1.0',0,NULL),(79,'Areas Riego FILL 8','#FFAD00','1.0',0,NULL),(80,'Areas Riego FILL 9','#A6FFA5','1.0',0,NULL),(81,'Areas Riego FILL 10','#02DC00','1.0',0,NULL),(82,'Areas Riego FILL 11','#016400','1.0',0,NULL),(83,'Areas Riego FILL 12','#FAC3FF','1.0',0,NULL),(84,'Areas Riego FILL 13','#EB33A3','1.0',0,NULL),(85,'Areas Riego','#14A4AC','1.0',0,NULL),(86,'Areas Riego 10','#FF00FF','1.0',0,NULL),(10,'Fill Etiquetas Recintos SigPac','#000000','1.0',0,NULL),(87,'Areas Riego FILL 14','#FFA5A5','1.0',0,NULL),(88,'Superficie Regada 1','#CDFE00','1.0',0,NULL),(89,'Superficie Regada 2','#3EFE00','1.0',0,NULL),(90,'Superficie Regada 3','#00DD66','1.0',0,NULL),(91,'Superficie Regada 4','#0087A5','1.0',0,NULL),(92,'Superficie Regada 5','#0D0082','1.0',0,NULL),(93,'Superficie Regada 6','#F7A5FF','1.0',0,NULL),(94,'FILL 11','#EB33A3','1.0',0,NULL),(95,'Olivos Tipo N','#00FF40','1',0,NULL),(96,'Olivos Tipo S','#FFFF99','1',0,NULL),(1377,'Fill rayado prueba','#00FFF0','0.5',0,201),(97,'Olivos Tipo A','#065F22','1',0,NULL),(98,'Ganaderia (Bovino)','#000000','1',0,NULL),(99,'Ganaderia (Ovino)','#00FF00','1',0,NULL),(100,'Ganaderia (Caprino)','#FDD017','1',0,NULL),(101,'Ganaderia (Otras)','#F87A17','1',0,NULL),(102,'Ganaderia (Multiple)','#86D4EF','1',0,NULL),(103,'Ganaderia (Porcino)','#0000FF','1',0,NULL),(104,'Ganaderia (NO SIGGAN)','#FF0000','1',0,NULL),(105,'Ganaderia (Riesgo)','#5E767E','0.6',0,NULL),(106,'Localizador Ganaderia Explt.','#31D91A','0.6',0,NULL),(108,'Fill Gan','#31D91A','0.2',0,NULL),(109,'Fill Zonas de restricción de herbicidas','#FF0000','0.3',0,NULL),(11015,'slfpActividadPuertoBaseStyle','#e0c000','1',0,NULL),(11011,'slfpEstadoReincidente','#C00000','1',0,NULL),(11010,'slfpEstadoOtrasIncidencias','#C00000','1',0,NULL),(11009,'slfpEstadoIncumplimientoDeVeda','#00ff00','1',0,NULL),(11008,'slfpEstadoActividadIlegal','#00ff00','1',0,NULL),(11007,'slfpEstadoActividadEnZonaProhibidaStyle','#ff0000','1',0,NULL),(11006,'slfpEstadoNoAsignado','#ff8000','1',0,NULL),(11005,'slfpActividadPescandoStyle','#ffff00','1',0,NULL),(11004,'slfpActividadEnTravesiaStyle','#ff00ff','1',0,NULL),(11003,'slfpActividadPuertoDistintoBaseStyle','#ff00ff','1',0,NULL),(11001,'Lonjas','#FF0000','1',0,NULL),(11002,'slfpActividadPuertoBaseStyle','#e0c000','1',0,NULL),(12003,'olivarCropac','#FFFFFF','1',0,NULL),(12004,'olivarCropacAuxEtiquetas','#000000','1',0,NULL),(5120,'ALMENDRO','#8F713E','1',0,NULL),(5121,'ALGARROBO','#8F6A08','1',0,NULL),(5122,'AVELLANO','#5F4C17','1',0,NULL),(5123,'NOGAL','#FFF15F','1',0,NULL),(5124,'PISTACHO','#D2FFCF','1',0,NULL),(5125,'OLIVO NO SIGO','#85AF83','1',0,NULL),(5126,'OTRA ESPECIE','#000000','1',0,NULL),(1120,'ALMENDRO','#BF9777','1',0,NULL),(1121,'ALGARROBO','#8F6A08','1',0,NULL),(1122,'AVELLANO','#5F4C17','1',0,NULL),(1123,'NOGAL','#FFF15F','1',0,NULL),(1124,'PISTACHO','#D2FFCF','1',0,NULL),(1125,'OLIVO NO SIGO','#85AF83','1',0,NULL),(1126,'OTRA ESPECIE','#BF9777','1',0,NULL),(13001,'parcelaCroquis','#FFFFFF','0.3',0,NULL),(13002,'olivarCropacAuxEtiquetasHalo','#68A6EF','1',0,NULL),(13003,'OLIVAR_N','#065F22','1',0,NULL),(13004,'OLIVAR_A','#BF3A0B','1',0,NULL),(13005,'OLIVAR_S','#EFAE00','1',0,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `fills` ENABLE KEYS */;

--
-- Table structure for table `fonts`
--

DROP TABLE IF EXISTS `fonts`;
CREATE TABLE `fonts` (
  `FONT_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `FAMILY` varchar(255) NOT NULL default '',
  `STYLE` varchar(255) NOT NULL default '',
  `WEIGHT` varchar(255) NOT NULL default '',
  `FONT_SIZE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`FONT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fonts`
--


/*!40000 ALTER TABLE `fonts` DISABLE KEYS */;
LOCK TABLES `fonts` WRITE;
INSERT INTO `fonts` VALUES (1,NULL,'Arial','Plain','Bold',10),(2,NULL,'Arial','Plain','Bold',8),(13001,NULL,'Verdana','Plain','Bold',14);
UNLOCK TABLES;
/*!40000 ALTER TABLE `fonts` ENABLE KEYS */;

--
-- Table structure for table `geometries_columns`
--

DROP TABLE IF EXISTS `geometries_columns`;
CREATE TABLE `geometries_columns` (
  `C_GEOMETRY_COLUMN` bigint(20) NOT NULL auto_increment,
  `T_NAME` varchar(255) default NULL,
  `COORD_DIMENSION` int(11) default NULL,
  `MAX_PPR` int(11) default NULL,
  `B_ALL_IN_MEMORY` tinyint(1) default NULL,
  `C_GEOMETRY_TYPE` bigint(20) NOT NULL default '0',
  `C_STORAGE_TYPE` bigint(20) NOT NULL default '0',
  `C_DATAACCESOR` bigint(20) default '0',
  `LAYER_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_GEOMETRY_COLUMN`),
  KEY `LAYER_ID` (`LAYER_ID`),
  KEY `C_DATAACCESOR` (`C_DATAACCESOR`),
  KEY `C_GEOMETRY_TYPE` (`C_GEOMETRY_TYPE`),
  KEY `C_STORAGE_TYPE` (`C_STORAGE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geometries_columns`
--


/*!40000 ALTER TABLE `geometries_columns` DISABLE KEYS */;
LOCK TABLES `geometries_columns` WRITE;
INSERT INTO `geometries_columns` VALUES (1,'provincias',2,0,1,3,1,1,1),(2,'municipios',2,0,1,3,1,2,2),(3,'Núcleos Urbanos',0,0,1,3,1,3,3),(4,'Ocas',0,0,1,3,1,4,4),(11,'Hojas 1:100000',0,0,1,3,1,11,23),(10,'Hojas 1:10000',0,0,1,3,1,10,22),(9,'Hojas 1:50000',0,0,1,3,1,9,21),(12,'toponimos_malla',2,0,0,3,1,12,24),(13,'hidrografia',2,0,0,5,1,13,25),(18,'Puertos',0,0,1,4,1,18,31),(14,'carreteras',2,0,0,3,1,14,27),(15,'Hidrografia Nombres',0,0,1,3,1,15,28),(17,'Instalaciones Acuiferas',0,0,0,4,1,17,30),(44,'Aguas Subterráneas',0,0,1,4,1,43,57),(20,'Caminos',0,0,1,4,1,19,33),(22,'Embalses',0,0,1,4,1,21,35),(23,'Almadrabas',0,0,1,4,1,22,36),(24,'Batimetría',0,0,1,4,1,23,37),(25,'Puntos de Interés Cultural',0,0,1,4,1,24,38),(26,'Puntos de Vertidos',0,0,1,4,1,25,39),(27,'Cables Submarinos',0,0,1,4,1,26,40),(28,'Emisarios Submarinos',0,0,1,4,1,27,41),(29,'Plan de Ordenación Territorial',0,0,0,4,1,28,42),(30,'Áreas Arqueológicas',0,0,1,4,1,29,43),(31,'Arrecifes',0,0,1,4,1,30,44),(32,'Salinas',0,0,1,4,1,31,45),(33,'Hábitats de Interés Comunitario',0,0,1,4,1,32,46),(34,'Lugares de Interés Comunitario',0,0,1,4,1,33,47),(50,'Espacios naturales Protegidos',0,0,1,4,1,49,63),(36,'Playas de Interés Turístico',0,0,1,4,1,35,49),(37,'Zonas Industriales',0,0,1,4,1,36,50),(38,'Zonas Extracción de Áridos',0,0,1,4,1,37,51),(39,'Zonas Portuarias y de Fondeo',0,0,0,4,1,38,52),(40,'Zonas Militares Terrestres y Marinas',0,0,0,4,1,39,53),(41,'Conducciones y otros elementos lineales',0,0,0,4,1,40,54),(45,'Zonas de Especial Protección Medioambiental',0,0,1,4,1,44,58),(43,'Ferrocarriles',0,0,0,5,1,42,56),(47,'Superficies de Agua',0,0,1,4,1,46,60),(48,'Abastecimientos de Agua',0,0,0,4,1,47,61),(49,'Edificación Rural',0,0,1,4,1,48,62),(51,'Localizador de Instalaciones Acuíferas',0,0,1,3,1,NULL,66),(5,'Recintos SigPac',0,0,0,3,1,50,1067),(52,'Polígonos SigPac',0,0,0,3,1,51,1068),(53,'Areas de riego',0,0,1,3,1,52,69),(54,'Cuencas hidrográficas',0,0,1,3,1,53,70),(55,'Sistemas de Explotacion',0,0,1,3,1,54,71),(56,'Zonas de Riego',0,0,0,3,1,55,72),(57,'Fecha ortofoto',2,0,0,3,1,56,74),(58,'Dibujar Poligono Acuicultura',0,0,1,3,1,NULL,73),(59,'Olivos',0,0,0,1,1,57,1076),(60,'loc_recintos_sigpac',0,0,1,3,1,NULL,77),(61,'loc_recintos_sigo',0,0,1,3,1,NULL,78),(62,'loc_olivos_N',2,0,1,1,1,NULL,79),(63,'loc_olivos_S',2,0,1,1,1,NULL,80),(64,'loc_olivos_A',2,0,1,1,1,NULL,81),(65,'Parcela de Forestación',0,0,1,3,1,NULL,82),(72,'Localizador parcelas SIGPAC',2,0,1,3,1,NULL,89),(73,'Insercion en mapa',2,0,1,3,1,NULL,90),(74,'Localizador parcelas SIGPAC Forestacion',2,0,1,3,1,NULL,91),(82,'localizadorGenerico',2,0,1,1,1,NULL,99),(83,'gan_area_proteccion',2,0,1,1,1,NULL,101),(84,'gan_area_vigilancia',2,0,1,1,1,NULL,102),(85,'Localizador Ganaderia',2,0,1,1,1,NULL,104),(87,'Riesgo Ganaderia',2,0,1,1,1,NULL,103),(12001,'PARCELA_CROQUIS_AUX',2,0,1,3,1,NULL,12001),(12004,'OLIVAR_CROPAC_AUX',2,0,0,1,1,NULL,12004),(1120,'Frutales de cascara',2,0,0,1,1,1120,1120),(13001,'PARCELA_CROQUIS_AUX',2,0,1,3,1,NULL,13001),(13002,'OLIVAR_AUX',2,0,1,1,1,NULL,13002),(13003,'OLIVAR_N',2,0,0,1,1,13003,13003),(13004,'OLIVAR_A',2,0,0,1,1,13004,13004),(13005,'OLIVAR_S',2,0,0,1,1,13005,13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `geometries_columns` ENABLE KEYS */;

--
-- Table structure for table `geometries_types`
--

DROP TABLE IF EXISTS `geometries_types`;
CREATE TABLE `geometries_types` (
  `C_GEOMETRY_TYPE` bigint(20) NOT NULL default '0',
  `D_GEOMETRY_TYPE` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_GEOMETRY_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `geometries_types`
--


/*!40000 ALTER TABLE `geometries_types` DISABLE KEYS */;
LOCK TABLES `geometries_types` WRITE;
INSERT INTO `geometries_types` VALUES (1,'POINT','Geometria de tipo puntual'),(2,'MULTIPOINT','Geometria de tipo multipuntual'),(3,'POLYGON','Geometria de tipo poligono'),(4,'MULTIPOLYGON','Geometria de tipo multipoligono'),(5,'LINESTRING','Geometria de tipo lineal'),(6,'MULTILINESTRING','Geometria de tipo multilinea');
UNLOCK TABLES;
/*!40000 ALTER TABLE `geometries_types` ENABLE KEYS */;

--
-- Table structure for table `gis_sesions`
--

DROP TABLE IF EXISTS `gis_sesions`;
CREATE TABLE `gis_sesions` (
  `C_SESSION` bigint(20) NOT NULL auto_increment,
  `D_START_ACCESS` date NOT NULL default '0000-00-00',
  `D_LAST_ACCESS` date NOT NULL default '0000-00-00',
  `N_XMIN` double NOT NULL default '0',
  `N_YMIN` double NOT NULL default '0',
  `N_XMAX` double NOT NULL default '0',
  `N_YMAX` double NOT NULL default '0',
  `T_NAME_SESSION` varchar(255) default NULL,
  `T_DESC_SESSION` varchar(255) default NULL,
  `C_USUARIO_APLICACION` bigint(20) default NULL,
  PRIMARY KEY  (`C_SESSION`),
  KEY `C_USUARIO_APLICACION` (`C_USUARIO_APLICACION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gis_sesions`
--


/*!40000 ALTER TABLE `gis_sesions` DISABLE KEYS */;
LOCK TABLES `gis_sesions` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `gis_sesions` ENABLE KEYS */;

--
-- Table structure for table `gis_themes`
--

DROP TABLE IF EXISTS `gis_themes`;
CREATE TABLE `gis_themes` (
  `C_THEME` bigint(20) NOT NULL auto_increment,
  `N_ORDEN` int(11) default NULL,
  `N_ORDEN_PICK` int(11) default NULL,
  `B_VISIBLE` tinyint(1) default NULL,
  `B_ACTIVO` tinyint(1) default NULL,
  `C_SESSION` bigint(20) default NULL,
  `ID_LAYER` bigint(20) default NULL,
  PRIMARY KEY  (`C_THEME`),
  KEY `C_SESSION` (`C_SESSION`),
  KEY `ID_LAYER` (`ID_LAYER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gis_themes`
--


/*!40000 ALTER TABLE `gis_themes` DISABLE KEYS */;
LOCK TABLES `gis_themes` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `gis_themes` ENABLE KEYS */;

--
-- Table structure for table `graphics`
--

DROP TABLE IF EXISTS `graphics`;
CREATE TABLE `graphics` (
  `GRAPHIC_ID` bigint(20) NOT NULL auto_increment,
  `GRAPHIC_TYPE` varchar(255) NOT NULL default '',
  `NAME` varchar(255) default NULL,
  `OPACITY` float NOT NULL default '0',
  `graphic_size` int(11) default NULL,
  `ROTATION` float NOT NULL default '0',
  `URL` varchar(255) default NULL,
  `FORMAT` varchar(255) default NULL,
  `TYPE` varchar(255) default NULL,
  `FILL_ID` bigint(20) default NULL,
  `STROKE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`GRAPHIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `graphics`
--


/*!40000 ALTER TABLE `graphics` DISABLE KEYS */;
LOCK TABLES `graphics` WRITE;
INSERT INTO `graphics` VALUES (1,'EXTERNAL_GRAPHIC',NULL,0.8,10,0,'C:\\developer\\web\\imagenes\\ptos_interes_cultural.gif',NULL,'circle',0,12003),(3,'MARK',NULL,1,3,0,NULL,NULL,'circle',45,12003),(2,'MARK',NULL,1,7,0,NULL,NULL,'circle',33,12003),(4,'EXTERNAL_GRAPHIC',NULL,0.8,10,0,'C:\\developer\\web\\imagenes\\ancla.gif',NULL,'circle',0,12003),(5,'EXTERNAL_GRAPHIC',NULL,0.6,1,0,'C:\\developer\\web\\imagenes\\simbolos\\acuifero.gif',NULL,NULL,0,12003),(6,'EXTERNAL_GRAPHIC',NULL,0.5,0,0,'C:\\developer\\web\\imagenes\\simbolos\\house.gif',NULL,NULL,NULL,12003),(8,'MARK',NULL,1,8,0,'C:\\developer\\web\\imagenes\\simbolos\\olivo_n.gif',NULL,'circle',95,12003),(9,'MARK',NULL,1,8,0,'C:\\developer\\web\\imagenes\\simbolos\\olivo_s.gif',NULL,'square',96,12003),(10,'MARK',NULL,1,8,0,'C:\\developer\\web\\imagenes\\simbolos\\olivo_a.gif',NULL,'circle',97,12003),(11,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules1.gif',NULL,NULL,NULL,12003),(12,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules2.gif',NULL,NULL,NULL,12003),(13,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules3.gif',NULL,NULL,NULL,12003),(14,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules4.gif',NULL,NULL,NULL,12003),(15,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules5.gif',NULL,NULL,NULL,12003),(16,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules7.gif',NULL,NULL,NULL,12003),(21,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules13.gif',NULL,NULL,NULL,12003),(17,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules9.gif',NULL,NULL,NULL,12003),(18,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules10.gif',NULL,NULL,NULL,12003),(20,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules12.gif',NULL,NULL,NULL,12003),(19,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules11.gif',NULL,NULL,NULL,12003),(22,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules24.gif',NULL,NULL,NULL,12003),(23,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules25.gif',NULL,NULL,NULL,12003),(24,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules28.gif',NULL,NULL,NULL,12003),(25,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules29.gif',NULL,NULL,NULL,12003),(26,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules30.gif',NULL,NULL,NULL,12003),(27,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules31.gif',NULL,NULL,NULL,12003),(28,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules33.gif',NULL,NULL,NULL,12003),(29,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules34.gif',NULL,NULL,NULL,12003),(30,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules35.gif',NULL,NULL,NULL,12003),(31,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules36.gif',NULL,NULL,NULL,12003),(32,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules37.gif',NULL,NULL,NULL,12003),(33,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules38.gif',NULL,NULL,NULL,12003),(34,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules39.gif',NULL,NULL,NULL,12003),(35,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules40.gif',NULL,NULL,NULL,12003),(36,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules41.gif',NULL,NULL,NULL,12003),(37,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules42.gif',NULL,NULL,NULL,12003),(38,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules43.gif',NULL,NULL,NULL,12003),(39,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules44.gif',NULL,NULL,NULL,12003),(40,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules45.gif',NULL,NULL,NULL,12003),(41,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules47.gif',NULL,NULL,NULL,12003),(42,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules48.gif',NULL,NULL,NULL,12003),(43,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules49.gif',NULL,NULL,NULL,12003),(44,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules51.gif',NULL,NULL,NULL,12003),(45,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules53.gif',NULL,NULL,NULL,12003),(46,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules54.gif',NULL,NULL,NULL,12003),(47,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules55.gif',NULL,NULL,NULL,12003),(48,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules57.gif',NULL,NULL,NULL,12003),(49,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules59.gif',NULL,NULL,NULL,12003),(50,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules63.gif',NULL,NULL,NULL,12003),(51,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules64.gif',NULL,NULL,NULL,12003),(52,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules65.gif',NULL,NULL,NULL,12003),(53,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules66.gif',NULL,NULL,NULL,12003),(54,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules67.gif',NULL,NULL,NULL,12003),(55,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules68.gif',NULL,NULL,NULL,12003),(56,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules69.gif',NULL,NULL,NULL,12003),(57,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules70.gif',NULL,NULL,NULL,12003),(58,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules71.gif',NULL,NULL,NULL,12003),(59,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules72.gif',NULL,NULL,NULL,12003),(60,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules73.gif',NULL,NULL,NULL,12003),(61,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules75.gif',NULL,NULL,NULL,12003),(62,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules76.gif',NULL,NULL,NULL,12003),(63,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules78.gif',NULL,NULL,NULL,12003),(64,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules79.gif',NULL,NULL,NULL,12003),(65,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules80.gif',NULL,NULL,NULL,12003),(66,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules81.gif',NULL,NULL,NULL,12003),(67,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules82.gif',NULL,NULL,NULL,12003),(68,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules83.gif',NULL,NULL,NULL,12003),(69,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules85.gif',NULL,NULL,NULL,12003),(70,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules86.gif',NULL,NULL,NULL,12003),(71,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules87.gif',NULL,NULL,NULL,12003),(72,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules88.gif',NULL,NULL,NULL,12003),(73,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules89.gif',NULL,NULL,NULL,12003),(74,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules90.gif',NULL,NULL,NULL,12003),(75,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules91.gif',NULL,NULL,NULL,12003),(76,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules92.gif',NULL,NULL,NULL,12003),(77,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules93.gif',NULL,NULL,NULL,12003),(78,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules94.gif',NULL,NULL,NULL,12003),(79,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules95.gif',NULL,NULL,NULL,12003),(80,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules96.gif',NULL,NULL,NULL,12003),(81,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules97.gif',NULL,NULL,NULL,12003),(82,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules98.gif',NULL,NULL,NULL,12003),(83,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules99.gif',NULL,NULL,NULL,12003),(84,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules100.gif',NULL,NULL,NULL,12003),(85,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules102.gif',NULL,NULL,NULL,12003),(86,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules104.gif',NULL,NULL,NULL,12003),(87,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules106.gif',NULL,NULL,NULL,12003),(88,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules107.gif',NULL,NULL,NULL,12003),(89,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules108.gif',NULL,NULL,NULL,12003),(90,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules109.gif',NULL,NULL,NULL,12003),(91,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imagenes\\simbolos\\rules110.gif',NULL,NULL,NULL,12003),(98,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules117.gif',NULL,NULL,NULL,12003),(99,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules118.gif',NULL,NULL,NULL,12003),(96,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules115.gif',NULL,NULL,NULL,12003),(97,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules116.gif',NULL,NULL,NULL,12003),(95,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules114.gif',NULL,NULL,NULL,12003),(94,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules113.gif',NULL,NULL,NULL,12003),(93,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules112.gif',NULL,NULL,NULL,12003),(92,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules111.gif',NULL,NULL,NULL,12003),(100,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules119.gif',NULL,NULL,NULL,12003),(101,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules120.gif',NULL,NULL,NULL,12003),(102,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules121.gif',NULL,NULL,NULL,12003),(103,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules122.gif',NULL,NULL,NULL,12003),(104,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules123.gif',NULL,NULL,NULL,12003),(105,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules124.gif',NULL,NULL,NULL,12003),(106,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules125.gif',NULL,NULL,NULL,12003),(107,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules126.gif',NULL,NULL,NULL,12003),(108,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules127.gif',NULL,NULL,NULL,12003),(109,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules128.gif',NULL,NULL,NULL,12003),(110,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules129.gif',NULL,NULL,NULL,12003),(111,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules130.gif',NULL,NULL,NULL,12003),(112,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules131.gif',NULL,NULL,NULL,12003),(113,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules132.gif',NULL,NULL,NULL,12003),(114,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules133.gif',NULL,NULL,NULL,12003),(115,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules134.gif',NULL,NULL,NULL,12003),(116,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules135.gif',NULL,NULL,NULL,12003),(117,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules136.gif',NULL,NULL,NULL,12003),(118,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules137.gif',NULL,NULL,NULL,12003),(119,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules138.gif',NULL,NULL,NULL,12003),(120,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules139.gif',NULL,NULL,NULL,12003),(121,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules140.gif',NULL,NULL,NULL,12003),(122,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules141.gif',NULL,NULL,NULL,12003),(123,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules142.gif',NULL,NULL,NULL,12003),(124,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules143.gif',NULL,NULL,NULL,12003),(125,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules144.gif',NULL,NULL,NULL,12003),(126,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules145.gif',NULL,NULL,NULL,12003),(127,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules146.gif',NULL,NULL,NULL,12003),(128,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules147.gif',NULL,NULL,NULL,12003),(129,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules148.gif',NULL,NULL,NULL,12003),(130,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules149.gif',NULL,NULL,NULL,12003),(131,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules150.gif',NULL,NULL,NULL,12003),(132,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules151.gif',NULL,NULL,NULL,12003),(133,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules152.gif',NULL,NULL,NULL,12003),(134,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules153.gif',NULL,NULL,NULL,12003),(135,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules154.gif',NULL,NULL,NULL,12003),(136,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules155.gif',NULL,NULL,NULL,12003),(137,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules156.gif',NULL,NULL,NULL,12003),(138,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules157.gif',NULL,NULL,NULL,12003),(139,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules158.gif',NULL,NULL,NULL,12003),(140,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules159.gif',NULL,NULL,NULL,12003),(141,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules160.gif',NULL,NULL,NULL,12003),(142,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules161.gif',NULL,NULL,NULL,12003),(143,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules162.gif',NULL,NULL,NULL,12003),(144,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules163.gif',NULL,NULL,NULL,12003),(145,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules164.gif',NULL,NULL,NULL,12003),(146,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules165.gif',NULL,NULL,NULL,12003),(147,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules166.gif',NULL,NULL,NULL,12003),(148,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules167.gif',NULL,NULL,NULL,12003),(149,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules168.gif',NULL,NULL,NULL,12003),(150,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules169.gif',NULL,NULL,NULL,12003),(151,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules170.gif',NULL,NULL,NULL,12003),(152,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules171.gif',NULL,NULL,NULL,12003),(153,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules172.gif',NULL,NULL,NULL,12003),(154,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules173.gif',NULL,NULL,NULL,12003),(155,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules174.gif',NULL,NULL,NULL,12003),(156,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules175.gif',NULL,NULL,NULL,12003),(157,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules176.gif',NULL,NULL,NULL,12003),(158,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules177.gif',NULL,NULL,NULL,12003),(159,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules178.gif',NULL,NULL,NULL,12003),(160,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules179.gif',NULL,NULL,NULL,12003),(161,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules180.gif',NULL,NULL,NULL,12003),(162,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules181.gif',NULL,NULL,NULL,12003),(163,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules182.gif',NULL,NULL,NULL,12003),(164,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules183.gif',NULL,NULL,NULL,12003),(165,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules184.gif',NULL,NULL,NULL,12003),(166,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules185.gif',NULL,NULL,NULL,12003),(167,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules186.gif',NULL,NULL,NULL,12003),(168,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules187.gif',NULL,NULL,NULL,12003),(169,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules188.gif',NULL,NULL,NULL,12003),(170,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules189.gif',NULL,NULL,NULL,12003),(171,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules190.gif',NULL,NULL,NULL,12003),(172,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules191.gif',NULL,NULL,NULL,12003),(173,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules192.gif',NULL,NULL,NULL,12003),(174,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules193.gif',NULL,NULL,NULL,12003),(175,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules194.gif',NULL,NULL,NULL,12003),(176,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules195.gif',NULL,NULL,NULL,12003),(177,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules196.gif',NULL,NULL,NULL,12003),(178,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules197.gif',NULL,NULL,NULL,12003),(179,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules198.gif',NULL,NULL,NULL,12003),(180,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules199.gif',NULL,NULL,NULL,12003),(181,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules200.gif',NULL,NULL,NULL,12003),(182,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules201.gif',NULL,NULL,NULL,12003),(183,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules202.gif',NULL,NULL,NULL,12003),(184,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules203.gif',NULL,NULL,NULL,12003),(185,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules204.gif',NULL,NULL,NULL,12003),(186,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules205.gif',NULL,NULL,NULL,12003),(187,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules206.gif',NULL,NULL,NULL,12003),(188,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules207.gif',NULL,NULL,NULL,12003),(189,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules208.gif',NULL,NULL,NULL,12003),(190,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules209.gif',NULL,NULL,NULL,12003),(191,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules210.gif',NULL,NULL,NULL,12003),(192,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules211.gif',NULL,NULL,NULL,12003),(193,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules212.gif',NULL,NULL,NULL,12003),(194,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules213.gif',NULL,NULL,NULL,12003),(195,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules214.gif',NULL,NULL,NULL,12003),(196,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules215.gif',NULL,NULL,NULL,12003),(197,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules216.gif',NULL,NULL,NULL,12003),(198,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules217.gif',NULL,NULL,NULL,12003),(199,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules218.gif',NULL,NULL,NULL,12003),(200,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules219.gif',NULL,NULL,NULL,12003),(201,'MARK',NULL,1,4,0,NULL,NULL,'star',NULL,12003),(202,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules221.gif',NULL,NULL,NULL,12003),(203,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules222.gif',NULL,NULL,NULL,12003),(204,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules223.gif',NULL,NULL,NULL,12003),(205,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules224.gif',NULL,NULL,NULL,12003),(206,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules225.gif',NULL,NULL,NULL,12003),(207,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules226.gif',NULL,NULL,NULL,12003),(208,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules227.gif',NULL,NULL,NULL,12003),(209,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules228.gif',NULL,NULL,NULL,12003),(210,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules229.gif',NULL,NULL,NULL,12003),(211,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules236.gif',NULL,NULL,NULL,12003),(212,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules410.gif',NULL,NULL,NULL,12003),(213,'EXTERNAL_GRAPHIC',NULL,1,1,0,'C:\\developer\\web\\imágenes\\simbolos\\rules220.gif',NULL,NULL,NULL,12003),(214,'MARK','Ganaderia Bovino',1,3,0,NULL,NULL,'cross',98,12003),(215,'MARK','Ganaderia Ovino',1,3,0,NULL,NULL,'cross',99,12003),(216,'MARK','Ganaderia Caprino',1,3,0,NULL,NULL,'cross',100,12003),(217,'MARK','Ganaderia Otras',1,3,0,NULL,NULL,'cross',101,12003),(218,'MARK','Ganaderia Multiple',1,3,0,NULL,NULL,'cross',102,12003),(219,'MARK','Ganaderia Porcino',1,3,0,NULL,NULL,'cross',103,12003),(220,'MARK','Ganaderia NO SIGGAN',0.5,3,0,NULL,NULL,'square',104,12003),(221,'MARK','Ganderia (Riesgo)',0.6,8,0,NULL,NULL,'circle',105,12003),(222,'MARK','Ganaderia Localizador',0.6,8,0,NULL,NULL,'square',106,12003),(223,'MARK','Gan_Puntos',0,1,0,NULL,NULL,'circle',108,12003),(11011,'MARK','slfpEstadoReincidente',1,5,0,NULL,NULL,'circle',11011,12003),(11010,'MARK','slfpEstadoOtrasIncidencias',1,7,0,NULL,NULL,'circle',11010,12003),(11009,'MARK','slfpEstadoIncumplimientoDeVeda',1,7,0,NULL,NULL,'circle',11009,12003),(11008,'MARK','slfpEstadoActividadIlegal',1,7,0,NULL,NULL,'circle',11008,12003),(11007,'MARK','slfpEstadoActividadEnZonaProhibidaStyle',1,7,0,NULL,NULL,'circle',11007,12003),(11006,'MARK','slfpEstadoNoAsignado',1,7,0,NULL,NULL,'circle',11006,12003),(11005,'MARK','slfpActividadPescandoStyle',1,10,0,NULL,NULL,'circle',11005,12003),(11001,'MARK','Lonjas',1,7,0,NULL,NULL,'circle',11001,12003),(11002,'MARK','slfpActividadPuertoBaseStyle',1,15,0,NULL,NULL,'circle',11002,12003),(11003,'MARK','slfpActividadPuertoBaseStyle',1,15,0,NULL,NULL,'circle',11003,12003),(11004,'MARK','slfpActividadEnTravesiaStyle',1,15,0,NULL,NULL,'circle',11004,12003),(12003,'MARK','olivarCropac',1,8,0,NULL,NULL,'circle',12003,12003),(1120,'MARK','ALMENDRO',1,8,0,NULL,NULL,'circle',1120,13002),(1121,'MARK','ALGARROBO',1,8,0,NULL,NULL,'circle',1121,13002),(1122,'MARK','AVELLANO',1,8,0,NULL,NULL,'circle',1122,13002),(1123,'MARK','NOGAL',1,8,0,NULL,NULL,'circle',1123,13002),(1124,'MARK','PISTACHO',1,8,0,NULL,NULL,'circle',1124,13002),(1125,'MARK','OLIVO NO SIGO',1,8,0,NULL,NULL,'circle',1125,13002),(1126,'MARK','OTRA ESPECIE',1,8,0,NULL,NULL,'circle',1126,13002),(13003,'MARK','OLIVAR_N',1,8,0,NULL,NULL,'circle',13003,13003),(13004,'MARK','OLIVAR_A',1,12,0,NULL,NULL,'triangle',13004,13004),(13005,'MARK','OLIVAR_S',1,10,0,NULL,NULL,'square',13005,13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `graphics` ENABLE KEYS */;

--
-- Table structure for table `halos`
--

DROP TABLE IF EXISTS `halos`;
CREATE TABLE `halos` (
  `HALO_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `RADIUS` float NOT NULL default '0',
  `FILL_ID` bigint(20) default NULL,
  PRIMARY KEY  (`HALO_ID`),
  KEY `FILL_ID` (`FILL_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `halos`
--


/*!40000 ALTER TABLE `halos` DISABLE KEYS */;
LOCK TABLES `halos` WRITE;
INSERT INTO `halos` VALUES (1,'etiqBlancoHalo',2,4),(3,NULL,2,67),(2,'etiqAmarilloHalo',2,8);
UNLOCK TABLES;
/*!40000 ALTER TABLE `halos` ENABLE KEYS */;

--
-- Table structure for table `label_fonts`
--

DROP TABLE IF EXISTS `label_fonts`;
CREATE TABLE `label_fonts` (
  `C_LABEL_FONT` bigint(20) NOT NULL auto_increment,
  `T_FONT_NAME` varchar(255) NOT NULL default '',
  `FONT_SIZE` int(11) default NULL,
  `FONT_STYLE` int(11) default NULL,
  PRIMARY KEY  (`C_LABEL_FONT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `label_fonts`
--


/*!40000 ALTER TABLE `label_fonts` DISABLE KEYS */;
LOCK TABLES `label_fonts` WRITE;
INSERT INTO `label_fonts` VALUES (1,'Arial',10,0),(4,'Arial',9,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `label_fonts` ENABLE KEYS */;

--
-- Table structure for table `labels_placements`
--

DROP TABLE IF EXISTS `labels_placements`;
CREATE TABLE `labels_placements` (
  `LABEL_PLACEMENT_ID` bigint(20) NOT NULL auto_increment,
  `LABEL_PLACEMENT_TYPE` varchar(255) NOT NULL default '',
  `NAME` varchar(255) default NULL,
  `ANCHOR_POINT_X` float default NULL,
  `ANCHOR_POINT_Y` float default NULL,
  `DISPLACEMENT_X` float default NULL,
  `DISPLACEMENT_Y` float default NULL,
  `ROTATION` float default NULL,
  `PERPENDICULAR_OFFSET` int(11) default NULL,
  PRIMARY KEY  (`LABEL_PLACEMENT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `labels_placements`
--


/*!40000 ALTER TABLE `labels_placements` DISABLE KEYS */;
LOCK TABLES `labels_placements` WRITE;
INSERT INTO `labels_placements` VALUES (1,'POINT_PLACEMENT','0',0.5,0.5,0,0,0,NULL),(2,'LINE_PLACEMENT','0',0,0,0,-100,0,-100),(3,'POINT_PLACEMENT','0',-0.1,0.5,0,0,0,NULL),(11001,'POINT_PLACEMENT','0',5,3,-0.1,-0.3,0,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `labels_placements` ENABLE KEYS */;

--
-- Table structure for table `labels_properties`
--

DROP TABLE IF EXISTS `labels_properties`;
CREATE TABLE `labels_properties` (
  `LABEL_PROPERTY_ID` bigint(20) NOT NULL default '0',
  `LABEL_PROPERTY` varchar(255) NOT NULL default '',
  `N_ORDEN` int(11) default NULL,
  `SYMBOLIZER_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`LABEL_PROPERTY_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `labels_properties`
--


/*!40000 ALTER TABLE `labels_properties` DISABLE KEYS */;
LOCK TABLES `labels_properties` WRITE;
INSERT INTO `labels_properties` VALUES (2,'C_PV',2,2),(1,'D_PV',1,2),(3,'INSTALACIO',1,4),(4,'D_TM',1,8),(5,'NOMBRE',1,16),(6,'OCA_AGRICO',1,19),(7,'NUMERO',1,21),(8,'NUMERO',1,23),(9,'HOJA',1,25),(10,'TOPONIMO',1,26),(11,'TEXTO',1,28),(12,'MATRICULA',1,43),(13,'EMPRESA',1,47),(23,'NOMBRE',1,85),(16,'NOMBRE',1,53),(17,'COTA',1,57),(18,'NOMBRE',1,75),(19,'CODIGO',2,75),(20,'C_PAR',1,6),(21,'C_REC',2,6),(22,'C_POL',1,80),(24,'NOMBRE',1,105),(25,'NOMBRE',1,111),(26,'C_EXP_COMP',1,289),(27,'C_EXP_COMP',1,287),(11002,'FK_BUQUE',1,11036),(12001,'C_TIPO',1,12004),(11001,'FK_BUQUE',1,11035),(13001,'C_TIPO',1,13002);
UNLOCK TABLES;
/*!40000 ALTER TABLE `labels_properties` ENABLE KEYS */;

--
-- Table structure for table `layers`
--

DROP TABLE IF EXISTS `layers`;
CREATE TABLE `layers` (
  `LAYER_ID` bigint(20) NOT NULL auto_increment,
  `CDATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `NOMBRE` varchar(255) NOT NULL default '',
  `T_PUBLIC_NAME` varchar(255) default NULL,
  `DESCRIPCION` varchar(255) default NULL,
  `MINX` double NOT NULL default '0',
  `MINY` double NOT NULL default '0',
  `MAXX` double NOT NULL default '0',
  `MAXY` double NOT NULL default '0',
  `N_ORDEN_PICK` int(11) NOT NULL default '0',
  `SRID` bigint(20) default NULL,
  `C_AGRUPACION` bigint(20) default NULL,
  PRIMARY KEY  (`LAYER_ID`),
  KEY `C_AGRUPACION` (`C_AGRUPACION`),
  KEY `SRID` (`SRID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `layers`
--


/*!40000 ALTER TABLE `layers` DISABLE KEYS */;
LOCK TABLES `layers` WRITE;
INSERT INTO `layers` VALUES (1,'2005-03-29 14:12:38','PROVINCIAS','Provincias','Provincias de Andalucía',98617.7,3986935.5,631717.7,4300767.5,200,NULL,2),(2,'2005-03-29 14:12:59','MUNICIPIOS','Municipios','Términos Municipales',98617.7,3986935.5,631717.7,4300767.5,210,NULL,2),(3,'2005-03-29 14:13:41','NUCLEOS','Núcleos urbanos','Núcleos urbanos',98617.7,3986935.5,631717.7,4300767.5,40,NULL,3),(4,'2005-03-29 14:15:12','OCAS','OCAs','OCAS',98617.7,3986935.5,631717.7,4300767.5,230,NULL,2),(6,'2005-04-07 14:19:35','ORTOFOTO','Ortofoto 1:5.000  B/N 2001/03','Ortofoto 1:5.000 en B/N 2001/03',98617.7,3986935.5,631717.7,4300767.5,1,NULL,1),(26,'2005-03-15 08:54:06','IRS_1998','Satélite IRS 1998','Ortofoto Satélite IRS 1998',98617.7,3986935.5,631717.7,4300767.5,4,NULL,1),(9,'2005-03-15 11:52:40','MTA_50000','MTA 1:50.000 Color','Topográfico 1:50.000 en color',98617.7,3986935.5,631717.7,4300767.5,11,NULL,4),(10,'2005-03-15 11:53:01','MTA_10000','MTA 1:10.000 B/N1995','Topográfico 1:10.000 en B/N',98617.7,3986935.5,631717.7,4300767.5,10,NULL,4),(11,'2005-03-15 08:59:47','SPOT_1995','Satélite SPOT 1995','Ortofoto Satélite SPOT 1995',98617.7,3986935.5,631717.7,4300767.5,5,NULL,1),(13,'2005-03-15 08:59:58','MTA_400000','MTA 1:400.000 (ICA)','Topográfico 1:400.000',98617.7,3986935.5,631717.7,4300767.5,13,NULL,4),(15,'2005-03-15 09:00:23','MTA_100000','MTA 1:100.000 (Elevaciones)','Topográfico 1:100.000',98617.7,3986935.5,631717.7,4300767.5,12,NULL,4),(16,'2005-03-15 09:00:34','SIG_OLEICO','SIG Oleícola','SIG Oleícola',98617.7,3986935.5,631717.7,4300767.5,3,NULL,1),(23,'2005-03-16 13:17:10','HOJAS_100000','Hojas MTA 1:100.000','Hojas MTA 1:100.000',98617.7,3986935.5,631717.7,4300767.5,32,NULL,5),(22,'2005-04-06 17:55:18','HOJAS_10000','Hojas MTA 1:10.000','Hojas MTA 1:10.000',98617.8,3986935.5,631717.7,4300767.5,30,NULL,5),(21,'2005-03-16 13:21:34','HOJAS_50000','Hojas MTA 1:50.000','Hojas MTA 1:50.000',98617.7,3986935.5,631717.7,4300767.5,31,NULL,5),(24,'2005-03-29 14:14:22','TOPONIMOS','Toponimia','Topónimos',98617.7,3986935.5,631717.7,4300767.5,41,NULL,3),(25,'2005-04-06 17:54:12','HIDROGRAFIA','Hidrografía','Etiquetas para la capa de Hidrografía',98617.8,3986935.5,631717.7,4300767.5,42,NULL,3),(27,'2005-03-15 10:37:41','CARRETERAS','Carreteras','Red de carreteras',98617.7,3986935.5,631717.7,4300767.5,44,NULL,3),(28,'2005-03-15 12:59:18','HIDROGRAFIA_NOMBRE','Hidrografía (Toponimia)','Hidrografía (Toponimia)',98617.7,3986935.5,631717.7,4300767.5,43,NULL,3),(31,'2005-04-05 17:56:38','PUERTOS','Puertos','Puertos',98617.7,3986935.5,631717.7,4300767.5,108,NULL,7),(58,'2005-04-07 12:50:18','ESPACIOS_NAT_PROTEG_INTEGRAL','Zonas de Especial Protección Medioambiental','Zonas de Especial Protección Medioambiental',98617.7,3986935.5,631717.7,4300767.5,104,NULL,7),(64,'2005-04-07 14:18:27','RELIEVE20x20_1995','Relieve 20x20 1995','Relieve 20x20 1995 (DTM)',98617.7,3986935.5,631717.7,4300767.5,14,NULL,4),(30,'2005-04-05 13:29:33','INSTALACIONES_ACUIFERAS','Instalaciones Acuíferas','Instalaciones Acuíferas',98617.7,3986935.5,631717.7,4300767.5,107,NULL,7),(33,'2005-04-06 14:08:05','CAMINOS','Caminos','Caminos',98617.7,3986935.5,631717.7,4300767.5,126,NULL,3),(35,'2005-04-06 17:47:03','EMBALSES','Embalses','Embalses',98617.7,3986935.5,631717.7,4300767.5,101,NULL,12),(36,'2005-04-06 17:46:05','ALMADRABAS','Almadrabas','Almadrabas',98617.7,3986935.5,631717.7,4300767.5,102,NULL,7),(37,'2005-04-07 09:00:59','BATIMETRIA','Batimetría','Batimetría',98617.7,3986935.5,631717.7,4300767.5,103,NULL,7),(38,'2005-04-07 09:02:55','PUNTOS_INTERES_CULTURAL','Puntos de Interés Cultural','Puntos de Interés Cultural',98617.7,3986935.5,631717.7,4300767.5,128,NULL,7),(39,'2005-04-07 09:03:55','PUNTOS_VERTIDOS','Puntos de Vertidos','Puntos de Vertidos',98617.7,3986935.5,631717.7,4300767.5,122,NULL,7),(40,'2005-04-07 09:05:04','CABLES_SUBMARINOS','Cables Submarinos','Cables Submarinos',98617.7,3986935.5,631717.7,4300767.5,121,NULL,7),(41,'2005-04-07 09:06:00','EMISARIOS_SUBMARINOS','Emisarios Submarinos','Emisarios Submarinos',98617.7,3986935.5,631717.7,4300767.5,120,NULL,7),(42,'2005-04-07 09:07:00','PLAN_ORDENACION_TERRITORIAL','Plan de Ordenación Territorial','Plan de Ordenación Territorial',98617.7,3986935.5,631717.7,4300767.5,124,NULL,7),(43,'2005-04-07 09:08:21','AREAS_ARQUEOLOGICAS','Áreas Arqueológicas','Áreas Arqueológicas',98617.7,3986935.5,631717.7,4300767.5,123,NULL,7),(44,'2005-04-07 09:09:05','ARRECIFES','Arrecifes','Arrecifes',98617.7,3986935.5,631717.7,4300767.5,130,NULL,7),(45,'2005-04-07 09:10:07','SALINAS','Salinas','SIG Oleícola',98617.7,3986935.5,631717.7,4300767.5,113,NULL,7),(46,'2005-04-07 09:11:11','HABITATS_INTERES','Hábitats de Interés Comunitario','Hábitats de Interés Comunitario',98617.7,3986935.5,631717.7,4300767.5,112,NULL,7),(47,'2005-04-07 09:12:40','LUGARES_INTERES_COMUNITARIO','Propuesta de Lugares de Interés Comunitario','Propuesta de Lugares de Interés Comunitario',98617.7,3986935.5,631717.7,4300767.5,111,NULL,7),(65,'2005-04-07 14:28:00','ORTO_10000','1:10.000 Color 1998/99','Ortofoto 1:10.000 Color 1998/99',98617.7,3986935.5,631717.7,4300767.5,2,NULL,1),(49,'2005-04-07 09:14:57','PLAYAS_INTERES','Playas de Interés Turístico','Playas de Interés Turístico',98617.7,3986935.5,631717.7,4300767.5,109,NULL,7),(50,'2005-04-07 09:17:13','ZONAS_INDUSTRIALES','Zonas Industriales','Zonas Industriales',98617.7,3986935.5,631717.7,4300767.5,129,NULL,7),(51,'2005-04-07 09:18:24','ZONAS_EXTRACCION_ARIDOS','Zonas de Extracción de Áridos','Zonas de Extracción de Áridos',98617.7,3986935.5,631717.7,4300767.5,100,NULL,7),(52,'2005-04-07 09:19:12','ZONAS_PORTUARIAS','Zonas Portuarias y de Fondeo','Zonas Portuarias y de Fondeo',98617.7,3986935.5,631717.7,4300767.5,106,NULL,7),(53,'2005-04-07 09:19:53','ZONAS_MILITARES','Zonas Militares Terrestres y Marinas','Zonas Militares Terrestres y Marinas',98617.7,3986935.5,631717.7,4300767.5,127,NULL,13),(54,'2005-04-07 12:18:35','CONDUCTOS','Conducciones y otros elementos lineales','Conducciones y otros elementos lineales',98617.7,3986935.5,631717.7,4300767.5,125,NULL,12),(56,'2005-04-07 10:22:20','FERROCARRILES','Ferrocarriles','Ferrocarriles',98617.7,3986935.5,631717.7,4300767.5,119,NULL,3),(57,'2005-04-07 12:51:13','AGUAS_SUBTERRANEAS','Aguas Subterráneas','Aguas Subterráneas',98617.7,3986935.5,631717.7,4300767.5,118,NULL,7),(63,'2005-04-07 13:24:19','ESPACIOS_NAT_PROTEG','Espacios naturales Protegidos','Espacios naturales Protegidos',98617.7,3986935.5,631717.7,4300767.5,117,NULL,13),(60,'2005-04-07 13:13:16','SUPERFICIES_AGUA','Superficies de Agua','Superficies de Agua',98617.7,3986935.5,631717.7,4300767.5,116,NULL,3),(61,'2005-04-07 13:12:45','ABASTECIMIENTO_AGUA','Abastecimientos de Agua','Abastecimientos de Agua',98617.7,3986935.5,631717.7,4300767.5,115,NULL,12),(62,'2005-04-07 13:15:17','EDIFICACION_RURAL','Edificación Rural','Edificación Rural',98617.7,3986935.5,631717.7,4300767.5,118,NULL,13),(66,'0000-00-00 00:00:00','LOC_INSTALACIONES_ACUIFERAS','Instalaciones Acuíferas (Toponimia)','Nombres de las instalaciones acuíferas utilizados para etiquetar las búsquedar en el localizador de acuicultura',98617.7,3986935.5,631717.7,4300767.5,2000,NULL,15),(1067,'0000-00-00 00:00:00','RECINTOS_SIGPAC','Recintos SigPac','Recintos SigPac',98617.7,3986935.5,631717.7,4300767.5,60,NULL,6),(1068,'0000-00-00 00:00:00','POLIGONOS_SIGPAC','Polígonos SigPac','Polígonos SigPac',98617.7,3986935.5,631717.7,4300767.5,61,NULL,6),(69,'2005-06-28 09:00:00','AREAS_RIEGO','Áreas de Riego','Áreas de',98617.7,3986935.5,631717.7,4300767.5,0,NULL,14),(70,'2005-06-28 09:00:00','CUENCAS_HIDROGRAFICAS','Cuencas Hidrográficas','Cuencas Hidrográficas',98617.7,3986935.5,631717.7,4300767.5,0,NULL,14),(71,'2005-06-28 09:00:00','SISTEMAS_EXP','Sistemas de Explotación','Sistemas de Explotación',98617.7,3986935.5,631717.7,4300767.5,0,NULL,14),(72,'2005-06-28 09:00:00','ZONAS_RIEGO','Zonas de Riego','Zonas de Riego',98617.7,3986935.5,631717.7,4300767.5,0,NULL,14),(73,'2005-07-01 09:30:00','DIBUJAR_POLIGONO_ACUICULTURA','Dibujar Polígono Acuicultura','Capa utilizada para representar los polígonos dibujados en acuicultura',98617.7,3986935.5,631717.7,4300767.5,2001,NULL,15),(74,'2005-07-01 09:30:00','FECHA_ORTO','Fecha de vuelo de la ortofoto','Fechas de vuelo de la ortofoto',98617.7,3986935.5,631717.7,4300767.5,0,NULL,1),(75,'2005-07-04 10:26:00','PENDIENTE','% Pendiente','Pendientes',98617.7,3986935.5,631717.7,4300767.5,0,NULL,4),(1076,'2005-07-05 11:49:00','OLIVAR','Olivar','Olivos Tipo N',98617.7,3986935.5,631717.7,4300767.5,62,NULL,6),(77,'2005-07-07 11:53:00','LOC_RECINTOS_SIGPAC','Recintos SIGPAC','Capa auxiliar que se utiliza para mostrar los resultados de las búsquedas de Parcelas SIGO',98617.7,3986935.5,631717.7,4300767.5,2003,NULL,15),(78,'2005-07-07 11:54:00','LOC_RECINTOS_SIGO','Parcela SIGO','Capa auxiliar que se utiliza para mostrar los resultados de las búsquedas de Parcelas SIGO',98617.7,3986935.5,631717.7,4300767.5,2002,NULL,15),(82,'2005-07-21 00:00:00','PARCELA_FORESTACION','Parcela de Forestación','Parcela de actuación de Forestación',98617.7,3986935.5,631717.7,4300767.5,2006,NULL,15),(92,'2005-09-22 00:00:00','EXP_GAN_BOVINO','Bovino','Bovino',98617.7,3986935.5,631717.7,4300767.5,181,NULL,16),(93,'2005-09-22 00:00:00','EXP_GAN_OVINO','Ovino','Ovino',98617.7,3986935.5,631717.7,4300767.5,182,NULL,16),(94,'2005-09-22 00:00:00','EXP_GAN_CAPRINO','Caprino','Caprino',98617.7,3986935.5,631717.7,4300767.5,183,NULL,16),(95,'2005-09-22 00:00:00','EXP_GAN_OTRAS','Otras','Otras',98617.7,3986935.5,631717.7,4300767.5,184,NULL,16),(96,'2005-09-22 00:00:00','EXP_GAN_MULTIPLE','Múltiple','Multiple',98617.7,3986935.5,631717.7,4300767.5,185,NULL,16),(89,'2005-08-05 00:00:00','LOCALIZADOR_PARCELAS_SIGPAC','Localizador Parcelas SIGPAC','Localizador Parcelas SIGPAC',98617.7,3986935.5,631717.7,4300767.5,2007,NULL,15),(90,'2005-08-09 00:00:00','INSERCION_EN_MAPA','Elementos insertados','Polígonos o líneas insertados en el mapa por el usuario',98617.7,3986935.5,631717.7,4300767.5,2008,NULL,15),(91,'2005-09-16 00:00:00','LOCALIZADOR_PARCELAS_SIGPAC_FORESTACION','Localizador Parcelas SIGPAC','Localizador Parcelas SIGPAC',98617.7,3986935.5,631717.7,4300767.5,2009,NULL,15),(97,'2005-09-22 00:00:00','EXP_GAN_PORCINO','Porcino','Porcino',98617.7,3986935.5,631717.7,4300767.5,186,NULL,16),(98,'2005-09-22 00:00:00','EXP_GAN_NO_SIGGAN','NO en SIGGAN','Puntos que no pertenecen a SIGGAN',98617.7,3986935.5,631717.7,4300767.5,180,NULL,16),(99,'2005-10-03 00:00:00','LOCALIZADOR_GENERICO','Localizador','Capa Auxiliar para el Localizador Genéricos',98617.7,3986935.5,631717.7,4300767.5,200,NULL,15),(102,'2005-10-20 00:00:00','GAN_AREA_VIGILANCIA','Área de Vigilancia','Área de Vigilancia para ganadería',98617.7,3986935.5,631717.7,4300767.5,179,NULL,15),(101,'2005-10-20 00:00:00','GAN_AREA_PROTECCION','Área de Protección','Área de Protección para ganadería',98617.7,3986935.5,631717.7,4300767.5,178,NULL,15),(104,'2005-10-20 00:00:00','LOC_EXPLOTACIONES_GANADERAS','Explotaciones Localizadas','Explotaciones Ganaderas',98617.7,3986935.5,631717.7,4300767.5,176,NULL,15),(103,'2005-10-20 00:00:00','EXPLOTACIONES_EN_RIESGO','Explotaciones en Riesgo','Explotaciones en Riesgo  de Epidemia',98617.7,3986935.5,631717.7,4300767.5,177,NULL,15),(105,'2005-10-20 00:00:00','GAN_PUNTOS','Puntos Ganaderia','Explotaciones Ganaderas',98617.7,3986935.5,631717.7,4300767.5,175,NULL,16),(107,'2005-10-20 00:00:00','ZONAS_RESTRICCION_HERBICIDAS','Zonas restricción herbicidas','Zonas en las que está suspendida la autorización de uso de los herbicidas terbutilazina y diurón',98617.7,3986935.5,631717.7,4300767.5,15,NULL,13),(1120,'2006-02-06 09:15:12','FRUTALES_CON_CASCARA','Frutales de Cáscara','Frutales de Cáscara',98617.7,3986935.5,631717.7,4300767.5,63,NULL,6),(13001,'2005-11-30 00:00:00','PARCELA_CROQUIS_AUX','Parcela Croquis','Parcela Croquis',98617.7,3986935.5,631717.7,4300767.5,13001,NULL,15),(13002,'0000-00-00 00:00:00','OLIVAR_CROPAC_AUX_PESADO','Olivar Parcela Agricola','Olivar Parcela Agricola',98617.7,3986935.5,631717.7,4300767.5,13001,NULL,15),(13003,'2005-11-04 09:15:12','OLIVAR_N_PESADO','Olivos Antes del 01/05/1998','Olivos Antes del 01/05/1998',98617.7,3986935.5,631717.7,4300767.5,62,NULL,6),(13004,'2005-11-04 09:15:12','OLIVAR_A_PESADO','Olivos Adicionales','Olivos Adicionales',98617.7,3986935.5,631717.7,4300767.5,62,NULL,6),(13005,'2005-11-04 09:15:12','OLIVAR_S_PESADO','Olivos Sustitutivos','Olivos Sustitutivos',98617.7,3986935.5,631717.7,4300767.5,62,NULL,6);
UNLOCK TABLES;
/*!40000 ALTER TABLE `layers` ENABLE KEYS */;

--
-- Table structure for table `layers_schemas`
--

DROP TABLE IF EXISTS `layers_schemas`;
CREATE TABLE `layers_schemas` (
  `C_LAYER_SCHEMA` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_LAYER_SCHEMA`),
  KEY `C_LAYER_SCHEMA` (`C_LAYER_SCHEMA`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `layers_schemas`
--


/*!40000 ALTER TABLE `layers_schemas` DISABLE KEYS */;
LOCK TABLES `layers_schemas` WRITE;
INSERT INTO `layers_schemas` VALUES (1),(2),(3),(4),(17),(18),(19),(21),(22),(23),(24),(25),(27),(28),(30),(31),(32),(33),(35),(36),(37),(38),(39),(40),(41),(42),(43),(44),(45),(46),(47),(49),(50),(51),(52),(53),(54),(56),(57),(58),(60),(61),(62),(63),(66),(69),(70),(71),(72),(73),(74),(77),(78),(79),(80),(81),(82),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),(101),(102),(103),(104),(105),(107),(1067),(1068),(1076),(1120),(1167),(1168),(1176),(13001),(13002),(13003),(13004),(13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `layers_schemas` ENABLE KEYS */;

--
-- Table structure for table `layers_symbols`
--

DROP TABLE IF EXISTS `layers_symbols`;
CREATE TABLE `layers_symbols` (
  `C_LAYER` bigint(20) NOT NULL default '0',
  `C_SYMBOL` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_SYMBOL`,`C_LAYER`),
  KEY `C_SYMBOL` (`C_SYMBOL`),
  KEY `C_LAYER` (`C_LAYER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `layers_symbols`
--


/*!40000 ALTER TABLE `layers_symbols` DISABLE KEYS */;
LOCK TABLES `layers_symbols` WRITE;
INSERT INTO `layers_symbols` VALUES (4,2),(1,3),(1,13),(2,14),(21,14),(22,14),(23,14),(2,15),(33,16),(56,16),(30,19),(24,20),(25,21),(28,22),(27,23),(3,25),(18,25),(27,27),(31,30),(35,30),(36,30),(37,30),(38,30),(39,30),(40,30),(41,30),(42,30),(43,30),(44,30),(45,30),(46,30),(47,30),(49,30),(50,30),(51,30),(52,30),(53,30),(54,30),(57,30),(58,30),(60,30),(61,30),(62,30),(63,30);
UNLOCK TABLES;
/*!40000 ALTER TABLE `layers_symbols` ENABLE KEYS */;

--
-- Table structure for table `lines_border_pattern`
--

DROP TABLE IF EXISTS `lines_border_pattern`;
CREATE TABLE `lines_border_pattern` (
  `C_LINE_BORDER_PATTERN` bigint(20) NOT NULL auto_increment,
  `T_PATRON` varchar(255) NOT NULL default '',
  `T_LINE_PATTERN_NAME` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`C_LINE_BORDER_PATTERN`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lines_border_pattern`
--


/*!40000 ALTER TABLE `lines_border_pattern` DISABLE KEYS */;
LOCK TABLES `lines_border_pattern` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `lines_border_pattern` ENABLE KEYS */;

--
-- Table structure for table `listeners_metadatas`
--

DROP TABLE IF EXISTS `listeners_metadatas`;
CREATE TABLE `listeners_metadatas` (
  `C_EVENT_LISTENER` bigint(20) NOT NULL auto_increment,
  `T_CLASS_NAME` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_EVENT_LISTENER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `listeners_metadatas`
--


/*!40000 ALTER TABLE `listeners_metadatas` DISABLE KEYS */;
LOCK TABLES `listeners_metadatas` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `listeners_metadatas` ENABLE KEYS */;

--
-- Table structure for table `metadatos`
--

DROP TABLE IF EXISTS `metadatos`;
CREATE TABLE `metadatos` (
  `C_METADATO` bigint(20) NOT NULL auto_increment,
  `D_CAMPO` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  `LAYER_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_METADATO`),
  KEY `LAYER_ID` (`LAYER_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `metadatos`
--


/*!40000 ALTER TABLE `metadatos` DISABLE KEYS */;
LOCK TABLES `metadatos` WRITE;
INSERT INTO `metadatos` VALUES (1,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras Públicas y Transportes. Junta de Andalucía.',1),(2,'ESCALA DE CAPTURA','1:10.000',1),(3,'ÁMBITO','Andalucía',1),(4,'CAPTURA','Digitalización en tablero.',1),(5,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía',1),(6,'CONTENIDO','Trazado de límites provinciales.',1),(7,'FECHA DE LOS DATOS','1997',1),(8,'FECHA DE LOS DATOS','2001 - 2003.',6),(9,'ÁMBITO','Andalucía',6),(10,'ORIGEN DE LOS DATOS','Vuelo aéreo 1:20.000 en blanco y negro.',6),(11,'ESCALA','1:5000.',6),(12,'FUENTE','Consejerías de Agricultura y Pesca, Medio Ambiente y Obras Públicas. Junta de Andalucía.',6),(13,'FUENTE','Consejería de Agricultura y Pesca. Junta de Andalucía.',1068),(14,'CONTENIDO','Trazado de límites de los polígonos del Sistema de Identificación de Parcelas Agrícolas',1068),(15,'ÁMBITO','Andalucía.',1068),(16,'ESCALA DE CAPTURA','Generalización de la capa de parcelas del Sistema de Identificación de Parcelas Agrícolas',1068),(18,'CAPTURA','Digitalización en pantalla sobre ortofotografía.',1067),(19,'FUENTE','Consejería de Agricultura y Pesca. Junta de Andalucía.',1067),(20,'CONTENIDO','Trazado de límites de recintos con distintos usos agrícolas.',1067),(21,'ÁMBITO','Andalucía.',1067),(22,'ESCALA DE CAPTURA','1:5.000',1067),(23,'ÁMBITO','Andalucía',2),(29,'FECHA DE LOS DATOS','1997',2),(25,'CONTENIDO','Límites de los distintos términos municipales.',2),(26,'FUENTE','Instituto Cartográfico de Andalucía. Consejería de Obras Públicas y Transportes',2),(31,'ESCALA DE CAPTURA','1:10.000',2),(30,'CAPTURA','Digitalización en tablero.',2),(32,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía',2),(33,'FUENTE','Consejería de Agricultura y Pesca. Junta de Andalucía.',4),(34,'CONTENIDO','Contorno de zonas urbanizadas.',3),(35,'ÁMBITO','Andalucía',3),(36,'ESCALA DE CAPTURA','1:10.000',3),(37,'FECHA DE LOS DATOS','1.992 - 1.996',3),(38,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras Públicas y Transportes. Junta de Andalucía.',3),(39,'CAPTURA','Digitalización en tablero.',3),(40,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',3),(41,'FUENTE','Instituto Geográfico Nacional (IGN).',23),(42,'FUENTE','Instituto Geográfico Nacional (IGN).',21),(43,'FUENTE','Instituto de Cartografía de Andalucía.',22),(44,'AMBITO','Andalucía',60),(45,'FECHA','1992-1996',60),(46,'ESCALA DE CAPTURA','1:10000',60),(47,'CAPTURA','Digitalización en tablero.',60),(48,'CONTENIDO','Trazado de la red hidrográfica.',60),(49,'FUENTE','Instituto de Cartografía de Andalucía.\nConsejería de Obras Públicas y Transportes. Junta de Andalucía.',60),(50,'ORIGEN DE LOS DATOS','Mapa Topográfico de\nAndalucía',60),(51,'ESCALA DE CAPTURA','1:10.000',25),(52,'CAPTURA','Digitalización en tablero.',25),(53,'FECHA DE LOS DATOS','1992-1996',25),(54,'CONTENIDO','Trazado de la red hidrográfica.',25),(55,'NOMBRE DE LA CAPA','HS1-1500',25),(56,'ÁMBITO','Andalucía.',25),(57,'TOPOLOGÍA','Lineal y rutas.',25),(58,'FUENTE','Instituto de Cartografía de Andalucía.\nConsejería de Obras Públicas y Transportes. Junta de Andalucía.',25),(59,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',25),(60,'CONTENIDO','Trazado de infraestructuras hidráulicas',54),(61,'FECHA','1992-1996',54),(62,'FUENTE','Instituto de Cartografía de Andalucía.\nConsejería de Obras Públicas y Transportes. Junta de Andalucía.',54),(63,'ORIGEN DE LOS DATOS','Mapa Topográfico de\nAndalucía',54),(64,'CAPTURA','Digitalización en tablero.',54),(65,'ESCALA DE CAPTURA','1:10000',54),(66,'AMBITO','Andalucía',54),(67,'CONTENIDO','Trazado de redes supramunicipales de abastecimiento de agua.',61),(68,'FUENTE','Dirección General de Obras Hidráulicas. Consejería de Obras Públicas y Transportes. Junta de Andalucía.',61),(69,'ÁMBITO','Andalucía',61),(70,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía',61),(71,'FECHA','1997',61),(72,'ESCALA DE CAPTURA','1:200.000',61),(73,'CAPTURA','Digitalización sobre base 100.000.',61),(74,'CAPTURA','Digitalización en tablero.',33),(75,'CONTENIDO','Trazado de los caminos más significativos.',33),(76,'FECHA DE LOS DATOS','1.992-1.996',33),(77,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',33),(78,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras Públicas\ny Transporte. Junta de Andalucía.',33),(79,'ÁMBITO','Andalucía.',33),(80,'ESCALA DE CAPTURA','1:10.000',33),(81,'ÁMBITO','Andalucía.',56),(82,'CONTENIDO','Trazado de los ferrocarriles.',56),(83,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras Públicas y\nTransportes. Junta de Andalucía.',56),(84,'CAPTURA','Digitalización en tablero.',56),(85,'FECHA DE LOS DATOS','1.992 - 1.996',56),(86,'ESCALA DE CAPTURA','1:10.000',56),(87,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',56),(88,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de\nObras Públicas y Transportes. Junta de Andalucía.',62),(89,'FECHA DE LOS DATOS','1.992 - 1.996',62),(90,'CAPTURA','Digitalización en tablero.',62),(91,'ESCALA DE CAPTURA','1:10.000',62),(92,'CONTENIDO','Localización de la edificación rural más\nsignificativa a esta escala.',62),(93,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',62),(94,'AMBITO','Andalucía',62),(95,'FECHA','1992-1996',35),(96,'ORIGEN DE LOS DATOS','Mapa Topográfico de\nAndalucía',35),(97,'FUENTE','Instituto de Cartografía de Andalucía.\nConsejería de Obras Públicas y Transportes. Junta de Andalucía.',35),(98,'CONTENIDO','Contorno de la lámina de agua de los embalses.',35),(99,'CAPTURA','Digitalización en tablero.',35),(100,'AMBITO','Andalucía',35),(101,'ESCALA DE CAPTURA','1:10000',35),(102,'ÁMBITO','Andalucía.',27),(103,'ORIGEN DE LOS DATOS','Mapa Topográfico de Andalucía.',27),(104,'ESCALA DE CAPTURA','1:10.000',27),(105,'CONTENIDO','Trazado de la red de carreteras.',27),(106,'CAPTURA','Digitalización en tablero.',27),(107,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras\nPúblicas y Transportes. Junta de Andalucía.',27),(108,'FECHA DE LOS DATOS','1.992 - 1.996',27),(109,'FUENTE','Consejería de Medio Ambiente. Junta de Andalucía.',11),(110,'FUENTE','Consejería de Medio Ambiente. Junta de Andalucía.',26),(111,'FUENTE','Consejería de Medio Ambiente. Junta de Andalucía.',9),(112,'FUENTE','Instituto de Cartografía de Andalucía. Consejería de Obras Públicas y Transportes. Junta de Andalucía.',10),(113,'FUENTE','Consejería de Agricultura y Pesca y \nConsejería de Empleo y Desarrollo Tecnológico.',30),(114,'FUENTE','Consejería de Medio Ambiente. Junta de Andalucía.',64),(115,'FUENTE','Órdenes Ministeriales de la Administración General del Estado. Autoridades Portuarias.',52),(116,'FUENTE','Ministerio de Defensa',53),(117,'FUENTE','Consejería de Obras Públicas y Transportes',57),(118,'FUENTE','Servicio de Protección del Patrimonio Histórico. Dirección General de Bienes Culturales. Consejería de  \nCultura.',38),(119,'FECHA DE LOS DATOS','1996',39),(120,'FUENTE','Inventario de Vertidos al Litoral Andaluz. Dirección General de Prevención y Calidad Ambiental. Consejería  \nde Medio Ambiente.',39),(121,'FUENTE','Mapa Digital de Andalucía 1:100.000. Consejería de Obras Públicas y Transportes.',37),(122,'ORIGEN DE LOS DATOS','Procedente del vuelo 1:60.000',65),(123,'FUENTE','Mapa Digital de Andalucía 1:100.000. Consejería de Obras Públicas y Transportes.',40),(124,'FUENTE','Consejería de Medio Ambiente',58),(125,'FUENTE','Inventario de Vertidos al Litoral Andaluz. Dirección General de Prevención y Calidad Ambiental. Consejería  \nde Medio Ambiente.',41),(126,'FECHA DE LOS DATOS','1996',41),(127,'FUENTE','Dirección General de Ordenación del Territorio y Urbanismo. Consejería de Obras Públicas y Transportes.',42),(128,'FUENTE','Mapa Digital de Andalucía 1:100.000. Consejería de Obras Públicas y Transportes.',31),(129,'FUENTE','Dirección General de Pesca y Agricultura. Consejería de Agricultura y Pesca.',36),(130,'FUENTE','Consejería de Agricultura y Pesca.',43),(131,'FUENTE','Consejería de Agricultura y Pesca.',44),(132,'FUENTE','Consejería de Medio Ambiente',46),(133,'FUENTE','Consejería de Medio Ambiente.',47),(134,'FUENTE','Dirección General de Planificación Turística. Consejería de Turismo y Deportes.',49),(135,'FUENTE','Consejería de Empleo y Desarrollo Tecnológico.',45),(136,'FUENTE','Dirección General de Costas en el Litoral Andaluz.',51),(137,'FUENTE','Mapa Digital de Andalucía 1:100.000. Consejería de Obras Públicas y Transportes.',50),(138,'FUENTE','Mapa Digital de Andalucía: 1:100.000. Consejería de Obras Públicas y Transportes.',53),(139,'CONTENIDO','Zonas en las que está suspendida la autorización de uso de los herbicidas terbutilazina y diurón',107);
UNLOCK TABLES;
/*!40000 ALTER TABLE `metadatos` ENABLE KEYS */;

--
-- Table structure for table `modulos`
--

DROP TABLE IF EXISTS `modulos`;
CREATE TABLE `modulos` (
  `C_MODULO` bigint(20) NOT NULL auto_increment,
  `TYPE` varchar(255) NOT NULL default '',
  `D_MODULO` varchar(255) default NULL,
  `T_CODIGO_WEB` text,
  `T_IMAGE_CODE` varchar(255) default NULL,
  `T_ALT_CODE` varchar(255) default NULL,
  `T_CLASS_NAME` varchar(255) default NULL,
  PRIMARY KEY  (`C_MODULO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modulos`
--


/*!40000 ALTER TABLE `modulos` DISABLE KEYS */;
LOCK TABLES `modulos` WRITE;
INSERT INTO `modulos` VALUES (1,'PLUGIN','salir',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.SalirPlugIn'),(2,'PLUGIN','zoomAnterior',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.ZoomAnteriorPlugIn'),(3,'PLUGIN','zoom',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.ZoomPlugIn'),(4,'PLUGIN','desplazar',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.PanPlugIn'),(5,'PLUGIN','zoomSiguiente',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.ZoomSiguientePlugIn'),(6,'PLUGIN','centrarMapa',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.CenterInMapPlugIn'),(7,'PLUGIN','removeWindowMenu',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.RemoveWindowMenuPlugIn'),(9,'PLUGIN','zoomExtensionCompleta',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.zoom.ZoomExtensionCompletaPlugIn'),(10,'PLUGIN','Establecer titulo ventana',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.SetApplicationTitlePlugIn'),(11,'PLUGIN','medirArea',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.MedirAreaPlugIn'),(12,'PLUGIN','medirDistancia',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.MedirDistanciaPlugIn'),(13,'PLUGIN','removeToolsFromToolbar',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.RemoveToolsFromToolbarPlugIn'),(34,'PLUGIN','Imprimir Genérico',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.reports.PrintPlugIn'),(35,'PLUGIN','Info Genérico',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.FeatureInfoPlugIn'),(36,'PLUGIN','Configuración de capas',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.ConfigureLayersPlugIn'),(38,'PLUGIN','cargarShape',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.shape.LoadShapeFilePlugIn'),(52,'PLUGIN','localizadorSIGPAC',NULL,NULL,NULL,'org.dap.sig.applications.appVisorSigpac.jump.plugins.localizador.LocalizadorSigpacPlugIn'),(53,'PLUGIN','infoSIGPAC',NULL,NULL,NULL,'org.dap.sig.applications.CatalogoSIIA.jump.plugins.utils.VisualizadorSigpacInfoPlugIn'),(59,'PLUGIN','dibujarEscala',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.MostrarEscalaPlugIn'),(60,'PLUGIN','threadedLoading',NULL,NULL,NULL,'org.dap.sig.core.jump.plugin.utils.ThreadedLoadingPlugin'),(64,'PLUGIN','LocalizadorSIGO',NULL,NULL,NULL,'org.dap.sig.applications.appVisorSigpac.jump.plugins.localizador.LocalizadorSigoPlugIn'),(13002,'PLUGIN','toolBoxCropac',NULL,NULL,NULL,'org.dap.sig.applications.appCropac.jump.plugins.ToolBoxCropacPlugIn'),(13004,'PLUGIN','localizadorSIGPACCropac',NULL,NULL,NULL,'org.dap.sig.applications.appCropac.jump.plugins.LocalizadorSigpacCropacPlugIn');
UNLOCK TABLES;
/*!40000 ALTER TABLE `modulos` ENABLE KEYS */;

--
-- Table structure for table `polygons_fill_patterns`
--

DROP TABLE IF EXISTS `polygons_fill_patterns`;
CREATE TABLE `polygons_fill_patterns` (
  `C_POLYGON_FILL_PATTERN` bigint(20) NOT NULL auto_increment,
  `TYPE` varchar(255) NOT NULL default '',
  `T_PATTER_NAME` varchar(50) NOT NULL default '',
  `T_IMAGE_PATH` varchar(255) default NULL,
  `N_LINE_WIDTH` tinyint(4) default NULL,
  `N_EXTENT` int(11) default NULL,
  `T_WKT_PATTERN` varchar(255) default NULL,
  `C_PATTERN_COLOR` bigint(20) default NULL,
  PRIMARY KEY  (`C_POLYGON_FILL_PATTERN`),
  KEY `C_PATTERN_COLOR` (`C_PATTERN_COLOR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `polygons_fill_patterns`
--


/*!40000 ALTER TABLE `polygons_fill_patterns` DISABLE KEYS */;
LOCK TABLES `polygons_fill_patterns` WRITE;
INSERT INTO `polygons_fill_patterns` VALUES (1,'IMAGE','','c:\\buttercup.jpg',3,1,'NO',17),(2,'WKT','ROJO NE',NULL,2,0,'NE',5);
UNLOCK TABLES;
/*!40000 ALTER TABLE `polygons_fill_patterns` ENABLE KEYS */;

--
-- Table structure for table `raster_columns_defs`
--

DROP TABLE IF EXISTS `raster_columns_defs`;
CREATE TABLE `raster_columns_defs` (
  `C_ESQUEMA` bigint(20) NOT NULL auto_increment,
  `B_MULTIPLE` tinyint(1) NOT NULL default '0',
  `C_FORMAT` bigint(20) default NULL,
  `C_RASTER_TYPE` bigint(20) default NULL,
  `C_RASTER_DATA_ACCESOR` bigint(20) default NULL,
  `LAYER_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_ESQUEMA`),
  KEY `LAYER_ID` (`LAYER_ID`),
  KEY `C_RASTER_TYPE` (`C_RASTER_TYPE`),
  KEY `C_RASTER_DATA_ACCESOR` (`C_RASTER_DATA_ACCESOR`),
  KEY `C_FORMAT` (`C_FORMAT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raster_columns_defs`
--


/*!40000 ALTER TABLE `raster_columns_defs` DISABLE KEYS */;
LOCK TABLES `raster_columns_defs` WRITE;
INSERT INTO `raster_columns_defs` VALUES (1,0,1,2,29,6);
UNLOCK TABLES;
/*!40000 ALTER TABLE `raster_columns_defs` ENABLE KEYS */;

--
-- Table structure for table `raster_formats`
--

DROP TABLE IF EXISTS `raster_formats`;
CREATE TABLE `raster_formats` (
  `C_FORMAT` bigint(20) NOT NULL auto_increment,
  `D_FORMAT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`C_FORMAT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raster_formats`
--


/*!40000 ALTER TABLE `raster_formats` DISABLE KEYS */;
LOCK TABLES `raster_formats` WRITE;
INSERT INTO `raster_formats` VALUES (1,'ECW'),(2,'TIFF');
UNLOCK TABLES;
/*!40000 ALTER TABLE `raster_formats` ENABLE KEYS */;

--
-- Table structure for table `rasters_types`
--

DROP TABLE IF EXISTS `rasters_types`;
CREATE TABLE `rasters_types` (
  `C_RASTER_TYPE` bigint(20) NOT NULL auto_increment,
  `D_RASTER_TYPE` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_RASTER_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rasters_types`
--


/*!40000 ALTER TABLE `rasters_types` DISABLE KEYS */;
LOCK TABLES `rasters_types` WRITE;
INSERT INTO `rasters_types` VALUES (1,'GRAY',NULL),(2,'RGB',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `rasters_types` ENABLE KEYS */;

--
-- Table structure for table `relationships_1n`
--

DROP TABLE IF EXISTS `relationships_1n`;
CREATE TABLE `relationships_1n` (
  `C_RELATION_1N` bigint(20) NOT NULL auto_increment,
  `TYPE` varchar(255) NOT NULL default '',
  `T_FIELD_ORIGEN` varchar(255) NOT NULL default '',
  `T_FIELD_DES` varchar(255) NOT NULL default '',
  `C_LAYER_ORIGEN` bigint(20) default NULL,
  PRIMARY KEY  (`C_RELATION_1N`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `relationships_1n`
--


/*!40000 ALTER TABLE `relationships_1n` DISABLE KEYS */;
LOCK TABLES `relationships_1n` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `relationships_1n` ENABLE KEYS */;

--
-- Table structure for table `relationships_rules`
--

DROP TABLE IF EXISTS `relationships_rules`;
CREATE TABLE `relationships_rules` (
  `C_RELATION_SHIP_RULES` bigint(20) NOT NULL auto_increment,
  `C_RELATION_1N` bigint(20) NOT NULL default '0',
  `C_RULE` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_RELATION_SHIP_RULES`),
  KEY `C_RELATION_1N` (`C_RELATION_1N`),
  KEY `C_RULE` (`C_RULE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `relationships_rules`
--


/*!40000 ALTER TABLE `relationships_rules` DISABLE KEYS */;
LOCK TABLES `relationships_rules` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `relationships_rules` ENABLE KEYS */;

--
-- Table structure for table `rhs_rules_listeners`
--

DROP TABLE IF EXISTS `rhs_rules_listeners`;
CREATE TABLE `rhs_rules_listeners` (
  `C_RELATION_SHIP_RULES` bigint(20) NOT NULL default '0',
  `C_EVENT_LISTENER` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_EVENT_LISTENER`,`C_RELATION_SHIP_RULES`),
  KEY `C_RELATION_SHIP_RULES` (`C_RELATION_SHIP_RULES`),
  KEY `C_EVENT_LISTENER` (`C_EVENT_LISTENER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rhs_rules_listeners`
--


/*!40000 ALTER TABLE `rhs_rules_listeners` DISABLE KEYS */;
LOCK TABLES `rhs_rules_listeners` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `rhs_rules_listeners` ENABLE KEYS */;

--
-- Table structure for table `rsrules`
--

DROP TABLE IF EXISTS `rsrules`;
CREATE TABLE `rsrules` (
  `C_RULE` bigint(20) NOT NULL auto_increment,
  `T_DESCRIPTION` varchar(255) default NULL,
  `T_CLASS_NAME` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`C_RULE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rsrules`
--


/*!40000 ALTER TABLE `rsrules` DISABLE KEYS */;
LOCK TABLES `rsrules` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `rsrules` ENABLE KEYS */;

--
-- Table structure for table `rules`
--

DROP TABLE IF EXISTS `rules`;
CREATE TABLE `rules` (
  `RULE_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `TITLE` varchar(255) default NULL,
  `MIN_SCALE_DENOMINATOR` double NOT NULL default '0',
  `MAX_SCALE_DENOMINATOR` double NOT NULL default '0',
  `URL_FILTER` varchar(255) default NULL,
  `GRAPHIC_ID` bigint(20) default NULL,
  `FEATURE_TYPE_STYLE_ID` bigint(20) default NULL,
  `FILTER` varchar(255) default NULL,
  PRIMARY KEY  (`RULE_ID`),
  KEY `FEATURE_TYPE_STYLE_ID` (`FEATURE_TYPE_STYLE_ID`),
  KEY `GRAPHIC_ID` (`GRAPHIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rules`
--


/*!40000 ALTER TABLE `rules` DISABLE KEYS */;
LOCK TABLES `rules` WRITE;
INSERT INTO `rules` VALUES (1,'Provincias','Provincias',15001,1000000,NULL,11,1,NULL),(9,'Núcleos (Cabecera Municipal)','Núcleos (Cabecera Municipal)',0,150000,'nucleos1.sld',17,8,NULL),(4,'Etiquetas Localizador Acuicultura','Etiquetas para la capa auxiliar utilizada en el Localizador de Instalaciones Acuíferas',0,15000,NULL,14,5,NULL),(3,'Localizador Instalaciones Acuíferas','Capa auxiliar utilizada en el Localizador de Instalaciones Acuíferas',0,1000000,NULL,13,5,NULL),(11,'Núcleos (Urbanización)','Núcleos (Urbanización)',0,150000,'nucleos3.sld',19,8,NULL),(5,'Municipios','Municipios',5001,100000,NULL,15,3,NULL),(6,'Ortofoto 1:5.000','Ortofoto 1:5.000',0,20000,NULL,NULL,4,NULL),(10,'Núcleos (Secundarios)','Núcleos (Secundarios)',0,150000,'nucleos2.sld',18,8,NULL),(12,'Núcleos (Diseminado)','Núcleos (Diseminado)',0,150000,'nucleos4.sld',20,8,NULL),(13,'Etiquetas Núcleos','Etiquetas Núcleos',0,100000,NULL,21,8,NULL),(81,'Abastecimiento 1','Abastecimiento',0,1000000,'abastecimiento1.sld',66,44,NULL),(15,'MTA 1:50.000','Mapa Topográfico 1:50.000',5000,200000,NULL,NULL,10,NULL),(16,'MTA 1:10000','Mapa Topográfico 1:10.000 en B/N',500,50000,NULL,NULL,11,NULL),(17,'Satélite SPOT 1995','Satélite SPOT 1998',5000,100000,NULL,NULL,12,NULL),(18,'Elevaciones','Elevaciones',15000,200000,NULL,NULL,13,NULL),(19,'MTA_400.000','Estilo para el ICA (Topográfico 1:400.000)',15000,1000000,NULL,NULL,14,NULL),(20,'SIG Oleícola','SIG Oleícola',500,30000,NULL,NULL,15,NULL),(21,'Relieve 20x20 1995','Relieve 20x20 1995',5000,200000,NULL,NULL,16,NULL),(22,'Ortofoto 1:10.000','Ortofoto 1:10.000',500,30000,NULL,NULL,17,NULL),(25,'Etiquetas Ocas','Etiquetas Ocas',0,200000,NULL,23,9,NULL),(24,'Ocas','Ocas',0,1000000000,NULL,22,9,NULL),(28,'Hojas 10.000','Hojas 10.000',0,200000,NULL,24,19,NULL),(27,'Satélite IRS 1998','Satélite IRS 1998',3000,100000,NULL,NULL,18,NULL),(30,'Hojas 50.000','Hojas 50.000',0,1000000,NULL,26,20,NULL),(31,'Etiquetas Hojas 50.000','Etiquetas Hojas 50000',0,100000,NULL,27,20,NULL),(29,'Etiquetas Hojas 10.000','Etiquetas Hojas 10.000',0,100000,NULL,25,19,NULL),(33,'Hojas 100.000','Hojas 100.000',0,1000000,NULL,28,21,NULL),(34,'Etiquetas Hojas 100.000','Etiquetas Hojas 100.000',0,1000000,NULL,29,21,NULL),(35,'Etiquetas Topónimos','Etiquetas Topónimos',0,100000,NULL,30,22,NULL),(36,'Hidrografía','Hidrografía',0,100000,NULL,31,23,NULL),(37,'Etiquetas Hidrografía','Etiquetas Hidrografía',0,100000,NULL,32,24,NULL),(38,'Carreteras (Autovía RIGE)','Carreteras (Autovías RIGE)',0,10000000,'carreteras1.sld',33,25,NULL),(45,'Carreteras (Carretera Secundaria)','Carreteras (Carretera Secundaria)',0,150000,'carreteras8.sld',40,25,NULL),(39,'Carreteras (Autovía Red Básica)','Carreteras (Autovía Red Básica)',0,150000,'carreteras2.sld',34,25,NULL),(44,'Carreteras (Carretera Intercomarcal)','Carreteras (Carretera Intercomarcal)',0,150000,'carreteras7.sld',39,25,NULL),(43,'Carreteras (Carretera Red Básica )','Carreteras (Carretera Red Básica )',0,150000,'carreteras6.sld',38,25,NULL),(42,'Carreteras (Carretera RIGE)','Carreteras (Carretera RIGE)',0,150000,'carreteras5.sld',37,25,NULL),(41,'Carreteras (Autovía Secundaria)','Carreteras (Autovía Secundaria)',0,150000,'carreteras4.sld',36,25,NULL),(40,'Carreteras (Autovía Intercomarcal)','Carreteras (Autovía Intercomarcal)',0,150000,'carreteras3.sld',35,25,NULL),(46,'Etiquetas Carreteras','Etiquetas Carreteras',0,150000,NULL,NULL,25,NULL),(47,'Instalaciones Acuíferas Autorizadas','Instalaciones Acuíferas',0,400000,'instalacionesAcuiferas1.sld',41,26,NULL),(48,'Instalaciones Acuíferas Caducadas','Instalaciones Acuíferas Caducadas',0,400000,'instalacionesAcuiferas2.sld',42,26,NULL),(49,'Instalaciones Acuíferas en Trámite','Instalaciones Acuíferas en Trámite',0,400000,'instalacionesAcuiferas3.sld',43,26,NULL),(50,'Etiquetas Instalaciones Acuíferas','Etiquetas Instalaciones Acuíferas',0,100000,NULL,NULL,26,NULL),(51,'Puertos','Puertos',0,400000,NULL,44,27,NULL),(52,'Etiquetas Puertos','Etiquetas Puertos',0,100000,NULL,NULL,27,NULL),(53,'Zonas de Especial Protección Medioambiental','Zonas de Especial Protección Medioambiental',0,300000,NULL,45,28,NULL),(54,'Caminos (Acuicultura)','Caminos (Acuicultura)',0,200000,NULL,46,29,NULL),(55,'Embalses','Embalses',0,450000,NULL,47,30,NULL),(56,'Etiquetas Embalses','Etiquetas Embalses',0,100000,NULL,NULL,30,NULL),(57,'Almadrabas','Almadrabas',0,500000,NULL,48,31,NULL),(58,'Etiquetas Almadrabas','Etiquetas Almadrabas',0,100000,NULL,NULL,31,NULL),(59,'Batimetría','Batimetría',0,300000,NULL,49,32,NULL),(60,'Etiquetas Batimetría','Etiquetas Batimetría',0,100000,NULL,NULL,32,NULL),(61,'Puntos de Interés Cultural','Puntos de Interés Cultural',0,300000,NULL,NULL,33,NULL),(62,'Puntos de Vertidos','Puntos de Vertidos',0,1000000,NULL,NULL,34,NULL),(63,'Cables Submarinos','Cables Submarinos',0,300000,NULL,50,35,NULL),(64,'Emisarios Submarinos','Emisarios Submarinos',0,300000,NULL,51,36,NULL),(65,'Pot (Equipamientos)','Pot (Equipamientos)',0,300000,'pot1.sld',52,37,NULL),(66,'Pot (Espacios Libres)','Pot (Espacios Libres)',0,300000,'pot2.sld',53,37,NULL),(67,'Pot (Limitaciones Específicas)','Pot (Limitaciones Específicas)',0,300000,'pot3.sld',54,37,NULL),(68,'Pot (Limitaciones Generales)','Pot (Limitaciones Generales)',0,300000,'pot4.sld',55,37,NULL),(80,'Zonas de Extracción de Áridos','Zonas de extracción de áridos',0,500000,NULL,65,43,NULL),(69,'Areas Arqueológicas','Areas Arqueológicas',0,400000,NULL,56,38,NULL),(70,'Arrecifes (En ejecución)','Arrecifes (En ejecución)',0,1000000,NULL,57,39,NULL),(71,'Arrecifes (En proyecto)','Arrecifes (En proyecto)',0,1000000,NULL,58,39,NULL),(72,'Arrecifes (Instalado)','Arrecifes (Instalado)',0,1000000,NULL,59,39,NULL),(73,'Salinas','Salinas',0,400000,NULL,60,40,NULL),(74,'Etiquetas Salinas','Etiquetas Salinas',0,400000,NULL,NULL,40,NULL),(75,'Habitats de Interes','Habitats de Interes',0,200000,NULL,61,41,NULL),(76,'Propuesta Lugares de Interés Comunitario','Propuesta Lugares de Interés Comunitario',0,1000000,NULL,62,42,NULL),(77,'Etiquetas Propuesta Lugares de Interés Comunitario','Etiquetas Propuesta Lugares de Interés Comunitario',0,200000,NULL,NULL,42,NULL),(78,'Topónimos','Topónimos',0,100000,NULL,63,22,NULL),(79,'Etiquetas Hidrografía (Geometría)','Etiquetas Hidrografía (Geometría)',0,100000,NULL,64,24,NULL),(2,'Recintos SigPac','Recintos SigPac',0,5000,NULL,12,2,NULL),(7,'Polígonos SigPac','Polígonos SigPac',0,15000,NULL,16,6,NULL),(82,'Abastecimiento 2','Abastecimiento 2',0,1000000,'abastecimiento2.sld',67,44,NULL),(83,'Playas 1','Playas 1',0,200000,NULL,68,45,NULL),(84,'Playas 2','Playas 2',0,200000,NULL,NULL,45,NULL),(85,'Zonas Industriales','Zonas Industriales',0,300000,NULL,69,46,NULL),(86,'Zonas Portuarias','Zonas Portuarias',0,500000,'zonasPortuarias1.sld',70,47,NULL),(87,'Zonas Portuarias 2','Zonas Portuarias 2',0,500000,'zonasPortuarias2.sld',71,47,NULL),(88,'Zonas Portuarias 3','Zonas Portuarias 3',0,500000,'zonasPortuarias3.sld',72,47,NULL),(89,'Zonas Militares 1','Zonas Militares 1',0,1000000,'zonasMilitares1.sld',73,48,NULL),(90,'Zonas Militares 2','Zonas Militares 2',0,1000000,'zonasMilitares2.sld',74,48,NULL),(91,'Conductos - Canales','Conductos - Canales',0,100000,'conductos1.sld',75,49,NULL),(92,'Conductos - Acequias','Conductos - Acequias',0,100000,'conductos2.sld',76,49,NULL),(93,'Conductos - Canalizacion en Salinas','Canalizacion en Salinas',0,100000,'conductos3.sld',77,49,NULL),(94,'Conductos - Presa','Conductos - Presa',0,100000,'conductos4.sld',78,49,NULL),(95,'Conductos - Flechas de canales','Conductos - Flechas de canales',0,100000,'conductos5.sld',79,49,NULL),(96,'Ferrocarriles - AVE','AVE',0,500000,'ferrocarril1.sld',80,50,NULL),(97,'Ferrocarriles - Vía doble','Vía doble',0,500000,'ferrocarril2.sld',81,50,NULL),(98,'Ferrocarriles - Vía Normal','Vía Normal',0,500000,'ferrocarril3.sld',82,50,NULL),(99,'Ferrocarriles - Vía estrecha','Vía estrecha',0,500000,'ferrocarril4.sld',83,50,NULL),(100,'Ferrocarriles - Vía desmantelada','Vía desmantelada',0,500000,'ferrocarril5.sld',84,50,NULL),(101,'Acuiferos','Acuiferos',0,300000,NULL,NULL,51,NULL),(102,'EENNPP','EENNPP',0,1000000,NULL,85,52,NULL),(103,'EENNPP Text','EENNPP text',0,300000,NULL,NULL,52,NULL),(104,'Superficies','Superficies',0,400000,NULL,86,53,NULL),(105,'Edificacion Rural','Edificacion Rural',0,100000,NULL,NULL,54,NULL),(106,'Areas de Riego','Areas de Riego',0,1000000,NULL,87,55,NULL),(107,'Cuencas Hidrograficas','Cuencas Hidrograficas',0,1000000,NULL,88,56,NULL),(108,'Sistemas de Explotación','Sistemas de Explotación',0,1000000,NULL,89,57,NULL),(109,'Areas de Riego Default','Areas de Riego Default',0,1000000,NULL,90,58,NULL),(110,'Areas de Riego 1.0','Año 1999 - 2000',0,1000000,'riegos1_1.sld',91,59,NULL),(111,'Areas de Riego 1.1','Año 1990 - 1999',0,1000000,'riegos1_2.sld',92,59,NULL),(112,'Areas de Riego 1.2','Año 1980 - 1990',0,1000000,'riegos1_3.sld',93,59,NULL),(113,'Areas de Riego 1.3','Año 1945 - 1980',0,1000000,'riegos1_4.sld',94,59,NULL),(114,'Areas de Riego 1.4','Año 1855 - 1945',0,1000000,'riegos1_5.sld',95,59,NULL),(115,'Areas de Riego 1.5','Año 1805 - 1855',0,1000000,'riegos1_6.sld',96,59,NULL),(116,'Areas de Riego 2.0','(0 - 2000) M3/Ha',0,1000000,'riegos2_1.sld',97,60,NULL),(117,'Areas de Riego 2.1','(2000 - 4000) M3/Ha',0,1000000,'riegos2_2.sld',98,60,NULL),(118,'Areas de Riego 2.2','(4000 - 5000) M3/Ha',0,1000000,'riegos2_3.sld',99,60,NULL),(119,'Areas de Riego 2.3','(5000 - 6000) M3/Ha',0,1000000,'riegos2_4.sld',100,60,NULL),(120,'Areas de Riego 2.4','(6000 - 8000) M3/Ha',0,1000000,'riegos2_5.sld',101,60,NULL),(121,'Areas de Riego 2.5','(8000 - 12000) M3/Ha',0,1000000,'riegos2_6.sld',102,60,NULL),(122,'Areas de Riego 3.0','(0 - 2)',0,1000000,'riegos3_1.sld',103,61,NULL),(123,'Areas de Riego 3.1','(2 - 5)',0,1000000,'riegos3_2.sld',104,61,NULL),(124,'Areas de Riego 3.2','(5 - 10)',0,1000000,'riegos3_3.sld',105,61,NULL),(125,'Areas de Riego 3.3','(10 - 15)',0,1000000,'riegos3_4.sld',106,61,NULL),(126,'Areas de Riego 3.4','(15 - 25)',0,1000000,'riegos3_5.sld',107,61,NULL),(127,'Areas de Riego 3.5','(25 - 35)',0,1000000,'riegos3_6.sld',108,61,NULL),(128,'Areas de Riego 4.0','Extensivos de invierno',0,1000000,'riegos4_1.sld',109,62,NULL),(129,'Areas de Riego 4.1','Extensivos de verano',0,1000000,'riegos4_2.sld',110,62,NULL),(132,'Areas de Riego 4.4','Olivar',0,10000000,'riegos4_5.sld',113,62,NULL),(130,'Areas de Riego 4.2','Arroz',0,1000000,'riegos4_3.sld',111,62,NULL),(131,'Areas de Riego 4.3','Otros',0,1000000,'riegos4_4.sld',112,62,NULL),(133,'Areas de Riego 4.6','Citricos',0,1000000,'riegos4_7.sld',114,62,NULL),(134,'Areas de Riego 4.7','Frutales subtropicales',0,1000000,'riegos4_8.sld',115,62,NULL),(135,'Areas de Riego 4.8','Horticolas aire libre',0,1000000,'riegos4_9.sld',116,62,NULL),(136,'Areas de Riego 4.9','Fresa',0,1000000,'riegos4_10.sld',117,62,NULL),(137,'Areas de Riego 4.10','Invernaderos',0,1000000,'riegos4_11.sld',118,62,NULL),(138,'Areas de Riego 4.11','Semi-intensivos',0,1000000,'riegos4_12.sld',119,62,NULL),(139,'Areas de Riego 5.0','(0 - 25) %',0,1000000,'riegos5_1.sld',120,63,NULL),(140,'Areas de Riego 5.1','(25 - 50) %',0,1000000,'riegos5_2sld',121,63,NULL),(141,'Areas de Riego 5.2','(50 - 70) %',0,1000000,'riegos5_3.sld',122,63,NULL),(142,'Areas de Riego 5.3','(70 - 85) %',0,1000000,'riegos5_4.sld',123,63,NULL),(143,'Areas de Riego 5.4','(85 - 100)%',0,1000000,'riegos5_5.sld',124,63,NULL),(144,'Areas de Riego 7.0','Iniciativa publica',0,1000000,'riegos7_0.sld',125,65,NULL),(145,'Areas de Riego 7.1','Iniciativa privada',0,1000000,'riegos7_1.sld',126,65,NULL),(151,'Areas de Riego 9.0','(2.3580 - 15) jorn./Ha.',0,1000000,'riegos9_0.sld',132,66,NULL),(152,'Areas de Riego 9.1','(15- 25) jorn./Ha.',0,1000000,'riegos9_1.sld',133,66,NULL),(153,'Areas de Riego 9.2','(25 - 40) jorn./Ha.',0,1000000,'riegos9_2.sld',134,66,NULL),(154,'Areas de Riego 9.3','(40 -100) jorn./Ha.',0,1000000,'riegos9_3.sld',135,66,NULL),(155,'Areas de Riego 9.4','(100 - 200) jorn./Ha.',0,1000000,'riegos9_4.sld',136,66,NULL),(156,'Areas de Riego 9.5','(200 - 288) jorn./Ha.',0,1000000,'riegos9_5.sld',137,66,NULL),(410,'Areas de Riego 4.5','Frutales',0,1000000,'riegos4_6.sld',212,62,NULL),(146,'Areas de Riego 8.0','(0.9 - 5) Empleo UTA / 100 Ha.',0,1000000,'riegos8_1.sld',127,64,NULL),(147,'Areas de Riego 8.1','(5 -10) Empleo UTA / 100 Ha.',0,1000000,'riegos8_2.sld',128,64,NULL),(148,'Areas de Riego 8.2','(10 - 20) Empleo UTA / 100 Ha.',0,1000000,'riegos8_3.sld',129,64,NULL),(149,'Areas de Riego 8.3','(20 - 50) Empleo UTA / 100 Ha.',0,1000000,'riegos8_4.sld',130,64,NULL),(150,'Areas de Riego 8.4','(50 - 109.92) Empleo UTA / 100 Ha.',0,1000000,'riegos8_5.sld',131,64,NULL),(157,'Areas de Riego 10.0','(18 - 60)',0,1000000,'riegos10_1.sld',138,67,NULL),(158,'Areas de Riego 10.1','(60 - 180)',0,1000000,'riegos10_2.sld',139,67,NULL),(159,'Areas de Riego 10.2','(180 - 400)',0,1000000,'riegos10_3.sld',140,67,NULL),(160,'Areas de Riego 10.3','(400 - 1000)',0,1000000,'riegos10_4.sld',141,67,NULL),(161,'Areas de Riego 10.4','(1000 - 2000)',0,1000000,'riegos10_5.sld',142,67,NULL),(168,'Areas de Riego 12.0','(1 - 200)',0,1000000,'riegos12_1.sld',149,69,NULL),(169,'Areas de Riego 12.1','(200 - 350)',0,1000000,'riegos12_2.sld',150,69,NULL),(170,'Areas de Riego 12.2','(350 - 550)',0,1000000,'riegos12_3.sld',151,69,NULL),(171,'Areas de Riego 12.3','(550 - 2500)',0,1000000,'riegos12_4.sld',152,69,NULL),(172,'Areas de Riego 12.4','(2500 - 4000)',0,1000000,'riegos12_5.sld',153,69,NULL),(173,'Areas de Riego 12.5','(4000 - 6000)',0,1000000,'riegos12_6.sld',154,69,NULL),(162,'Areas de Riego 11.0','(0 - 3000) m3/Ha.',0,1000000,'riegos11_1.sld',143,68,NULL),(163,'Areas de Riego 11.1','(3000 - 4500) m3/Ha.',0,1000000,'riegos11_2.sld',144,68,NULL),(164,'Areas de Riego 11.2','(4500 - 5000) m3/Ha.',0,1000000,'riegos11_3.sld',145,68,NULL),(165,'Areas de Riego 11.3','(5000 - 6000) m3/Ha.',0,1000000,'riegos11_4.sld',146,68,NULL),(166,'Areas de Riego 11.4','(6000 - 8000) m3/Ha.',0,1000000,'riegos11_5.sld',147,68,NULL),(167,'Areas de Riego 11.5','(8000 - 14000) m3/Ha.',0,1000000,'riegos11_6.sld',148,68,NULL),(174,'Areas de Riego 13.0','Superficial',0,1000000,'riegos13_1.sld',155,70,NULL),(175,'Areas de Riego 13.1','Sub. y sup.',0,1000000,'riegos13_2.sld',156,70,NULL),(176,'Areas de Riego 13.2','Subterranea',0,1000000,'riegos13_3.sld',157,70,NULL),(177,'Areas de Riego 13.3','Res. y sub.',0,1000000,'riegos13_4.sld',158,70,NULL),(178,'Areas de Riego 13.4','Residual',0,1000000,'riegos13_5.sld',159,70,NULL),(179,'Areas de Riego 13.5','Res. y sup.',0,1000000,'riegos13_6.sld',160,70,NULL),(185,'Areas de Riego 15.0','Aspersion',0,1000000,'riegos15_1.sld',166,72,NULL),(186,'Areas de Riego 15.1','Gravedad',0,1000000,'riegos15_2.sld',167,72,NULL),(187,'Areas de Riego 15.2','Localizado',0,1000000,'riegos15_3.sld',168,72,NULL),(188,'Areas de Riego 15.3','Loc. y asp.',0,1000000,'riegos15_4.sld',169,72,NULL),(189,'Areas de Riego 15.4','Loc. y grav.',0,1000000,'riegos15_5.sld',170,72,NULL),(190,'Areas de Riego 15.5','Asp. y grav.',0,1000000,'riegos15_6.sld',171,72,NULL),(180,'Areas de Riego 14.0','(0 - 0.5) pts/m3',0,1000000,'riegos14_1.sld',161,71,NULL),(181,'Areas de Riego 14.1','(0.5 - 1) pts/m3',0,1000000,'riegos14_2.sld',162,71,NULL),(182,'Areas de Riego 14.2','(1 - 3) pts/m3',0,1000000,'riegos14_3.sld',163,71,NULL),(183,'Areas de Riego 14.3','(3 - 8) pts/m3',0,1000000,'riegos14_4.sld',164,71,NULL),(184,'Areas de Riego 14.4','(8 - 18) pts/m3',0,1000000,'riegos14_5.sld',165,71,NULL),(191,'Areas de Riego 16.0','(0 - 8) Ha.',0,1000000,'riegos16_1.sld',172,73,NULL),(192,'Areas de Riego 16.1','(8 - 20) Ha.',0,1000000,'riegos16_2.sld',173,73,NULL),(193,'Areas de Riego 16.2','(20 - 30) Ha.',0,1000000,'riegos16_3.sld',174,73,NULL),(194,'Areas de Riego 16.3','(30 - 1000) Ha.',0,1000000,'riegos16_4.sld',175,73,NULL),(195,'Areas de Riego 16.4','(1000 - 2000) Ha.',0,1000000,'riegos16_5.sld',176,73,NULL),(196,'Areas de Riego 16.5','(2000 - 3190) Ha.',0,1000000,'riegos16_6.sld',177,73,NULL),(203,'Areas de Riego 18.0','(1.75 - 1000) Ha.',0,1000000,'riegos18_1.sld',184,75,NULL),(204,'Areas de Riego 18.1','(1000 - 2000) Ha.',0,1000000,'riegos18_2.sld',185,75,NULL),(205,'Areas de Riego 18.2','(2000 - 3000) Ha.',0,1000000,'riegos18_3.sld',186,75,NULL),(206,'Areas de Riego 18.3','(3000 - 6500) Ha.',0,1000000,'riegos18_4.sld',187,75,NULL),(207,'Areas de Riego 18.4','(6500 - 10000) Ha.',0,1000000,'riegos18_5.sld',188,75,NULL),(208,'Areas de Riego 18.5','(10000 - 14099) Ha.',0,1000000,'riegos18_6.sld',189,75,NULL),(209,'Areas de Riego 19.0','(-25 , -5)',0,1000000,'riegos19_1.sld',190,76,NULL),(197,'Areas de Riego 17.0','(1.75 - 1000) Ha.',0,1000000,'riegos17_1.sld',178,74,NULL),(198,'Areas de Riego 17.1','(1000 - 2000) Ha.',0,1000000,'riegos17_2.sld',179,74,NULL),(199,'Areas de Riego 17.2','(2000 - 3000) Ha.',0,1000000,'riegos17_3.sld',180,74,NULL),(200,'Areas de Riego 17.3','(3000 - 6500) Ha.',0,1000000,'riegos17_4.sld',181,74,NULL),(201,'Areas de Riego 17.4','(6500 - 10000) Ha.',0,1000000,'riegos17_5.sld',182,74,NULL),(202,'Areas de Riego 17.5','(10000 - 14099) Ha.',0,1000000,'riegos17_6.sld',183,74,NULL),(210,'Areas de Riego 19.1','(-5 , 0)',0,1000000,'riegos19_2.sld',191,76,NULL),(211,'Areas de Riego 19.2','(0 , 5)',0,1000000,'riegos19_3.sld',192,76,NULL),(212,'Areas de Riego 19.3','(5 , 15)',0,1000000,'riegos19_4.sld',193,76,NULL),(213,'Areas de Riego 19.4','(15 , 30)',0,1000000,'riegos19_5.sld',194,76,NULL),(214,'Areas de Riego 19.5','(30 , 400)',0,1000000,'riegos19_6.sld',195,76,NULL),(215,'Areas de Riego 20.0','(0.1 - 2)',0,1000000,'riegos20_1.sld',196,77,NULL),(216,'Areas de Riego 20.1','(2 - 4)',0,1000000,'riegos20_2.sld',197,77,NULL),(217,'Areas de Riego 20.2',' (4 - 25)',0,1000000,'riegos20_3.sld',198,77,NULL),(218,'Areas de Riego 20.3','(25 - 50)',0,1000000,'riegos20_4.sld',199,77,NULL),(219,'Areas de Riego 20.4','(50 - 100)',0,1000000,'riegos20_5.sld',200,77,NULL),(220,'Areas de Riego 20.5','(100 - 600)',0,1000000,'riegos20_6.sld',213,77,NULL),(221,'Areas de Riego 21.8','Riegos Particulares',0,1000000,'riegos21_9.sld',202,78,NULL),(222,'Areas de Riego 21.7','Otros nuevos regadios',0,1000000,'riegos21_8.sld',203,78,NULL),(223,'Areas de Riego 21.6','Nuevos regadios de Comunidades de Regantes',0,1000000,'riegos21_7.sld',204,78,NULL),(224,'Areas de Riego 21.5','Mejora de regadios (IGCA)',0,1000000,'riegos21_6.sld',205,78,NULL),(225,'Areas de Riego 21.4','Otros regadios de iniciativa publica',0,1000000,'riegos21_5.sld',206,78,NULL),(226,'Areas de Riego 21.3','Interes General de la Nacion',0,1000000,'riegos21_4.sld',207,78,NULL),(227,'Areas de Riego 21.2','Interes General de la Comunidad Autonoma',0,1000000,'riegos21_3.sld',208,78,NULL),(228,'Areas de Riego 21.1','Interes Nacional',0,1000000,'riegos21_2.sld',209,78,NULL),(229,'Areas de Riego 21.0','Ley 1911',0,1000000,'riegos21_1.sld',210,78,NULL),(230,'Areas de Riego 22.0','Areas de Riego 22.0',0,1000000,'riegos22_1.sld',NULL,79,NULL),(231,'Areas de Riego 22.1','Areas de Riego 22.1',0,1000000,'riegos22_2.sld',NULL,79,NULL),(232,'Areas de Riego 22.2','Areas de Riego 22.2',0,1000000,'riegos22_3.sld',NULL,79,NULL),(233,'Areas de Riego 22.3','Areas de Riego 22.3',0,1000000,'riegos22_4.sld',NULL,79,NULL),(234,'Areas de Riego 22.4','Areas de Riego 22.4',0,1000000,'riegos22_5.sld',NULL,79,NULL),(235,'Areas de Riego 22.5','Areas de Riego 22.5',0,1000000,'riegos22_6.sld',NULL,79,NULL),(236,'Dibujar Polígonos Acuicultura','Dibujar Polígonos Acuicultura',0,1000000,NULL,211,80,NULL),(237,'Pendiente','Pendiente',100,20000,NULL,NULL,81,NULL),(238,'Olivar tipo N','Olivar tipo N',0,500,'olivar1.sld',NULL,82,NULL),(239,'Olivat tipo S','Olivar tipo S',0,500,'olivar2.sld',NULL,82,NULL),(240,'Olivar tipo A','Olivar tipo A',0,500,'olivar3.sld',NULL,82,NULL),(241,'Localizador Recintos SIGPAC (Olivar)','Localizador Recintos SIGPAC (Olivar)',0,1000000,NULL,NULL,83,NULL),(242,'Localizador Recintos SIGPAC (Olivar)','Localizador Recintos SIGPAC (Olivar)',0,1000000,NULL,NULL,84,NULL),(244,'LOC Olivar Tipo S','Olivar Tipo S',0,1000000,NULL,NULL,86,NULL),(243,'LOC Olivar tipo N','Olivar Tipo N',0,1000000,NULL,NULL,85,NULL),(261,'Ganaderia (Multiple)','Ganaderia (Multiple)',0,1000000,'Multiple.sld',NULL,102,NULL),(260,'Ganaderia (Otras)','Ganaderia (Otras)',0,1000000,'Otras.sld',NULL,101,NULL),(262,'Ganaderia (Porcino)','Ganaderia (Porcino)',0,1000000,'Porcino.sld',NULL,103,NULL),(257,'Ganaderia (Bovino)','Ganaderia (Bovino)',0,1000000,'Bovino.sld',NULL,98,NULL),(245,'LOC Olivar Tipo A','Olivar Tipo A',0,1000000,NULL,NULL,87,NULL),(246,'ParcelaForestacion','Parcela Forestación',0,1000000,NULL,NULL,88,NULL),(263,'Ganaderia (No SIGGAN)','Ganaderia (No SIGGAN)',0,1000000,'NoSIGGAN.sld',NULL,104,NULL),(258,'Ganaderia (Ovino)','Ganaderia (Bovino)',0,1000000,'Ovino.sld',NULL,99,NULL),(259,'Ganaderia (Caprino)','Ganaderia (Caprino)',0,1000000,'Caprino.sld',NULL,100,NULL),(254,'Localizador Parcelas SIGPAC','Localizador Parcelas SIGPAC',0,1000000,NULL,NULL,95,NULL),(255,'Inserción en mapa','Inserción en mapa',0,1000000,NULL,NULL,96,NULL),(256,'Localizador Parcelas SIGPACForestacion','Localizador Parcelas SIGPACForestacion',0,1000000,NULL,NULL,97,NULL),(264,'Localizador cartografía General','Localizador cartografía General',0,1000000,NULL,NULL,105,NULL),(1120,'frutalConCascara','frutalConCascara',0,500,NULL,NULL,1120,NULL),(13001,'ParcelaCroquis','ParcelaCroquis',0,1000000,NULL,NULL,13001,NULL),(13002,'olivarCropacAux','olivarCropacAux',0,100000,NULL,NULL,13002,NULL),(13003,'OLIVAR_N','OLIVAR_N',0,500,NULL,NULL,13003,NULL),(13004,'OLIVAR_A','OLIVAR_A',0,500,NULL,NULL,13004,NULL),(13005,'OLIVAR_S','OLIVAR_S',0,500,NULL,NULL,13005,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `rules` ENABLE KEYS */;

--
-- Table structure for table `schema_attributes`
--

DROP TABLE IF EXISTS `schema_attributes`;
CREATE TABLE `schema_attributes` (
  `C_ATTRIBUTE` bigint(20) NOT NULL auto_increment,
  `T_NOMBRE` varchar(255) NOT NULL default '',
  `esPrimaryK` tinyint(1) NOT NULL default '0',
  `C_LAYER_SCHEMA` bigint(20) NOT NULL default '0',
  `T_NOMBRE_PUBLICO` varchar(255) default '',
  `esPublico` tinyint(1) NOT NULL default '0',
  `N_ORDER_SEQUENCE` tinyint(3) NOT NULL default '-1',
  `N_ORDER_BY` tinyint(4) NOT NULL default '-1',
  `C_ATTRIBUTE_TYPE` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_ATTRIBUTE`),
  KEY `C_ATTRIBUTE_TYPE` (`C_ATTRIBUTE_TYPE`),
  KEY `C_LAYER_SCHEMA` (`C_LAYER_SCHEMA`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schema_attributes`
--


/*!40000 ALTER TABLE `schema_attributes` DISABLE KEYS */;
LOCK TABLES `schema_attributes` WRITE;
INSERT INTO `schema_attributes` VALUES (371,'NOM_TM',0,24,'Nombre del municipio',1,-1,2,1),(370,'C_TM',0,24,'Código del municipio',1,-1,-1,3),(369,'NOM_PV',0,24,'Nombre de la provincia',1,-1,-1,1),(368,'C_PV',0,24,'Código de la provincia',1,-1,0,3),(340,'GEOM',0,2,'',0,-1,-1,2),(339,'GID',1,2,'',0,-1,-1,3),(333,'D_PV',0,1,'Nombre',1,-1,-1,1),(356,'GID',1,3,'GID',0,-1,-1,4),(459,'FASES',0,30,'FASES',1,-1,0,1),(336,'C_PV',0,2,'Código de la Provincia',1,-1,-1,3),(335,'D_TM',0,2,'Nombre del municipio',1,-1,0,1),(367,'GEOM',0,24,'',0,-1,-1,2),(366,'GID',1,24,'',0,-1,-1,4),(456,'GEOM',0,30,'GEOM',0,-1,-1,2),(358,'C_PV',0,3,'C_PV',1,-1,-1,3),(458,'URL',0,30,'URL',1,-1,0,1),(372,'TOPONIMO',0,24,'Topónimo',1,-1,0,1),(338,'C_TM_INE',0,2,'Código INE del municipio',1,-1,-1,3),(380,'C_TM',0,2,'Código del municipio',1,-1,-1,3),(381,'C_OCA',0,4,'C_OCA',1,-1,-1,3),(334,'GEOM',0,1,'',0,-1,-1,2),(256,'GEOM',0,23,'GEOM',0,-1,-1,2),(255,'GID',1,23,'GID',0,-1,-1,4),(510,'GEOM',0,38,'GEOM',0,-1,-1,2),(511,'ELEMENTO',0,38,'ELEMENTO',1,-1,-1,1),(448,'PROVINCIA',0,30,'PROVINCIA',1,-1,0,1),(449,'EMPRESA',0,30,'EMPRESA',1,-1,0,1),(355,'GEOM',0,3,'GEOM',0,-1,-1,2),(379,'GID',1,4,'GID',0,-1,-1,4),(378,'GEOM',0,4,'GEOM',0,-1,-1,2),(373,'OCA_AGRICO',0,4,'OCA_AGRICO',1,-1,-1,1),(457,'TIPO_ESTAB',0,30,'TIPO_ESTAB',0,-1,0,1),(497,'COPIAS',0,22,'COPIAS',1,-1,0,3),(204,'GID',1,28,'',0,-1,-1,4),(205,'GEOM',0,28,'',0,-1,-1,2),(206,'TEXTO',0,28,'Etiqueta',0,1,0,1),(207,'GID',1,27,'',0,-1,-1,4),(208,'GEOM',0,27,'',0,-1,-1,2),(209,'MATRICULA',0,27,'Código',1,1,0,1),(694,'GEOM',0,1067,'GEOM',0,-1,-1,2),(512,'NOMBRE',0,38,'NOMBRE',1,-1,-1,1),(332,'C_PV',0,1,'C_PV',1,-1,-1,3),(357,'AREA',0,3,'AREA',1,-1,-1,6),(351,'MUNICIPIO',0,3,'MUNICIPIO',1,-1,-1,1),(331,'GID',1,1,'',0,-1,-1,3),(353,'NOMBRE',0,3,'NOMBRE',1,-1,0,1),(352,'COD_ENT',0,3,'COD_ENT',0,-1,-1,1),(509,'GID',1,38,'GID',0,-1,-1,3),(508,'COTA',0,37,'COTA',1,-1,-1,3),(507,'ELEMENTO',0,37,'ELEMENTO',1,-1,-1,1),(506,'GEOM',0,37,'GEOM',0,-1,-1,2),(505,'GID',1,37,'GID',0,-1,-1,3),(257,'AREA',0,23,'AREA',1,-1,-1,6),(258,'PERIMETER',0,23,'PERIMETER',1,-1,-1,6),(259,'HOJA',0,23,'HOJA',1,-1,-1,1),(260,'NOMBRE',0,23,'NOMBRE',1,-1,-1,1),(261,'NUMERO_LC',0,23,'NUMERO_LC',1,-1,-1,3),(354,'C_TM',0,3,'C_TM',1,-1,-1,3),(350,'COD_INE',0,3,'COD_INE',1,-1,-1,3),(455,'GID',1,30,'GID',0,-1,-1,3),(454,'MUNICIPIO',0,30,'MUNICIPIO',1,-1,0,1),(453,'INSTALACIO',0,30,'INSTALACIO',0,-1,0,1),(452,'ESTADO',0,30,'ESTADO',1,-1,0,1),(272,'GID',1,21,'GID',0,-1,-1,4),(273,'GEOM',0,21,'GEOM',0,-1,-1,2),(274,'AREA',0,21,'AREA',1,-1,-1,6),(275,'PERIMETER',0,21,'PERIMETER',1,-1,-1,6),(276,'HOJAS50_',0,21,'HOJAS50_',1,-1,-1,3),(277,'HOJAS50_ID',0,21,'HOJAS50_ID',1,-1,-1,3),(278,'IGN',0,21,'IGN',1,-1,-1,1),(279,'NUMERO',0,21,'NUMERO',1,-1,-1,3),(280,'NOMBRE',0,21,'NOMBRE',1,-1,0,1),(281,'SEL',0,21,'SEL',0,-1,-1,3),(451,'FINCA',0,30,'FINCA',1,-1,0,1),(450,'ESPECIES',0,30,'ESPECIES',1,-1,0,1),(474,'URL',0,31,'Hiperlink asociado al puerto',0,-1,-1,1),(461,'GEOM',0,31,'GEOM',0,-1,-1,2),(462,'NOMBRE',0,31,'NOMBRE',1,-1,-1,1),(463,'PESQUERO',0,31,'PESQUERO',1,-1,-1,1),(464,'DEPORTIVO',0,31,'DEPORTIVO',1,-1,-1,1),(465,'COMERCIAL',0,31,'COMERCIAL',0,-1,-1,1),(466,'COMPETENCI',0,31,'COMPETENCI',0,-1,-1,1),(475,'GID',1,33,'GID',0,-1,-1,3),(447,'NUM',0,30,'NUM',1,-1,0,3),(476,'GEOM',0,33,'GEOM',0,-1,-1,2),(477,'COD_ENT',0,33,'COD_ENT',0,-1,-1,1),(460,'GID',1,31,'GID',0,-1,-1,3),(478,'TIPO_LIN',0,33,'TIPO_LIN',0,-1,-1,3),(488,'COD_ENT',0,35,'COD_ENT',0,-1,-1,1),(487,'IH3_100_ID',0,35,'IH3_100_ID',1,-1,-1,3),(486,'GEOM',0,35,'GEOM',0,-1,-1,2),(485,'GID',1,35,'GID',0,-1,-1,3),(489,'NOMBRE',0,35,'NOMBRE',1,-1,-1,1),(490,'COTA',0,35,'COTA',1,-1,-1,3),(491,'GID',1,36,'GID',0,-1,-1,3),(492,'GEOM',0,36,'GEOM',0,-1,-1,2),(493,'NOMBRE',0,36,'NOMBRE',1,-1,-1,1),(494,'TITULAR',0,36,'TITULAR',0,-1,-1,1),(495,'GID',1,25,'',0,-1,-1,4),(496,'GEOM',0,25,'',0,-1,-1,2),(498,'NUMERO',0,22,'NUMERO',1,-1,0,3),(499,'HOJAS10_ID',0,22,'HOJAS10_ID',1,-1,0,3),(500,'GID',1,22,'GID',0,-1,-1,4),(501,'GEOM',0,22,'GEOM',0,-1,-1,2),(502,'AREA',0,22,'AREA',1,-1,0,6),(503,'PERIMETER',0,22,'PERIMETER',1,-1,0,6),(504,'HOJAS10_',0,22,'HOJAS10_',1,-1,0,3),(513,'FIGURA',0,38,'FIGURA',1,-1,-1,1),(514,'TIPOLOGIA',0,38,'TIPOLOGIA',0,-1,-1,1),(515,'ESTADO',0,38,'ESTADO',1,-1,-1,1),(516,'MUNICIPIO',0,38,'MUNICIPIO',1,-1,-1,1),(517,'PROVINCIA',0,38,'PROVINCIA',1,-1,-1,1),(518,'GID',1,39,'GID',0,-1,-1,3),(519,'GEOM',0,39,'GEOM',0,-1,-1,2),(520,'ELEMENTO',0,39,'ELEMENTO',1,-1,-1,1),(521,'NOMBRE',0,39,'NOMBRE',1,-1,-1,1),(522,'CONTROL',0,39,'CONTROL',1,-1,-1,1),(523,'TITULAR',0,39,'TITULAR',0,-1,-1,1),(524,'ENTIDAD',0,39,'ENTIDAD',1,-1,-1,1),(525,'ACTIVIDAD',0,39,'ACTIVIDAD',1,-1,-1,1),(526,'ZONA_VERT',0,39,'ZONA_VERT',0,-1,-1,1),(527,'LUGAR_VERT',0,39,'LUGAR_VERT',1,-1,-1,1),(528,'USO_LITORA',0,39,'USO_LITORA',0,-1,-1,1),(529,'SIT_ADMIN',0,39,'SIT_ADMIN',0,-1,-1,1),(530,'ESTADO',0,39,'ESTADO',1,-1,-1,1),(531,'NATURALEZA',0,39,'NATURALEZA',1,-1,-1,1),(532,'DESCR_VERT',0,39,'DESCR_VERT',1,-1,-1,1),(533,'DIAMETR_MM',0,39,'DIAMETR_MM',1,-1,-1,1),(534,'CAUDAL_M3',0,39,'CAUDAL_M3',1,-1,-1,1),(535,'GID',1,40,'GID',0,-1,-1,3),(536,'GEOM',0,40,'GEOM',0,-1,-1,2),(537,'ELEMENTO',0,40,'ELEMENTO',1,-1,-1,1),(538,'GID',1,41,'GID',0,-1,-1,3),(539,'GEOM',0,41,'GEOM',0,-1,-1,2),(540,'EMISA_ID',0,41,'EMISA_ID',1,-1,-1,3),(541,'ELEMENTO',0,41,'ELEMENTO',1,-1,-1,1),(542,'GID',1,42,'GID',0,-1,-1,3),(543,'GEOM',0,42,'GEOM',0,-1,-1,2),(544,'ELEMENTO',0,42,'ELEMENTO',1,-1,-1,1),(545,'USOS',0,42,'USOS',0,-1,-1,1),(546,'GID',1,43,'GID',0,-1,-1,3),(547,'GEOM',0,43,'GEOM',0,-1,-1,2),(548,'ELEMENTO',0,43,'ELEMENTO',1,-1,-1,1),(549,'NOMBRE',0,43,'NOMBRE',1,-1,-1,1),(550,'PERIODO',0,43,'PERIODO',1,-1,-1,1),(551,'TIPOLOGIA',0,43,'TIPOLOGIA',0,-1,-1,1),(552,'ESTADO',0,43,'ESTADO',1,-1,-1,1),(553,'CLASIFICAC',0,43,'CLASIFICAC',1,-1,-1,1),(554,'MUNICIPIO',0,43,'MUNICIPIO',1,-1,-1,1),(555,'PROVINCIA',0,43,'PROVINCIA',1,-1,-1,1),(556,'GID',1,44,'GID',0,-1,-1,3),(557,'GEOM',0,44,'GEOM',0,-1,-1,2),(558,'ARRECIFE',0,44,'ARRECIFE',1,-1,-1,1),(559,'COMPETENCI',0,44,'COMPETENCI',0,-1,-1,1),(560,'MUNICIPIO',0,44,'MUNICIPIO',1,-1,-1,1),(561,'PROVINCIA',0,44,'PROVINCIA',1,-1,-1,1),(562,'ESTADO',0,44,'ESTADO',1,-1,-1,1),(563,'GID',1,45,'GID',0,-1,-1,3),(564,'GEOM',0,45,'GEOM',0,-1,-1,2),(565,'ELEMENTO',0,45,'ELEMENTO',1,-1,-1,1),(566,'NOMBRE',0,45,'NOMBRE',1,-1,-1,1),(567,'CONCESION',0,45,'CONCESION',0,-1,-1,1),(568,'EXPLOTADOR',0,45,'EXPLOTADOR',1,-1,-1,1),(569,'MUNICIPIO',0,45,'MUNICIPIO',1,-1,-1,1),(570,'ESTADO',0,45,'ESTADO',1,-1,-1,1),(571,'TAJOS_M2',0,45,'TAJOS_M2',0,-1,-1,6),(572,'GID',1,46,'GID',0,-1,-1,3),(573,'GEOM',0,46,'GEOM',0,-1,-1,2),(574,'ELEMENTO',0,46,'ELEMENTO',1,-1,-1,1),(575,'GID',1,47,'GID',0,-1,-1,3),(576,'GEOM',0,47,'GEOM',0,-1,-1,2),(577,'ELEMENTO',0,47,'ELEMENTO',1,-1,-1,1),(578,'CODIGO',0,47,'CODIGO',0,-1,-1,1),(579,'NOMBRE',0,47,'NOMBRE',1,-1,-1,1),(688,'ELEMENTO',0,63,'ELEMENTO',1,-1,-1,1),(687,'GEOM',0,63,'GEOM',0,-1,-1,2),(686,'GID',1,63,'GID',0,-1,-1,3),(584,'GID',1,49,'GID',0,-1,-1,3),(585,'GEOM',0,49,'GEOM',0,-1,-1,2),(586,'NOMBRE',0,49,'NOMBRE',1,-1,-1,1),(597,'NOMBRE',0,50,'NOMBRE',1,-1,0,1),(596,'GEOM',0,50,'GEOM',0,-1,-1,2),(595,'GID',1,50,'GID',0,-1,-1,3),(601,'ELEMENTO',0,51,'ELEMENTO',1,-1,-1,1),(600,'GEOM',0,51,'GEOM',0,-1,-1,2),(599,'GID',1,51,'GID',0,-1,-1,3),(598,'MUNICIPIO',0,50,'MUNICIPIO',1,-1,0,1),(602,'ZONA',0,51,'ZONA',0,-1,-1,1),(603,'PROVINCIA',0,51,'PROVINCIA',1,-1,-1,1),(604,'GID',1,52,'GID',0,-1,-1,3),(605,'GEOM',0,52,'GEOM',0,-1,-1,2),(606,'DOMINIO',0,52,'DOMINIO',1,-1,-1,1),(607,'AUTORIDAD',0,52,'AUTORIDAD',1,-1,-1,1),(608,'GID',1,53,'GID',0,-1,-1,3),(609,'GEOM',0,53,'GEOM',0,-1,-1,2),(610,'ELEMENTO',0,53,'ELEMENTO',1,-1,-1,1),(611,'NOMBRE',0,53,'NOMBRE',1,-1,-1,1),(612,'COMPATIBIL',0,53,'COMPATIBIL',0,-1,-1,1),(636,'ELEMENTO',0,57,'ELEMENTO',1,-1,-1,1),(635,'GEOM',0,57,'GEOM',0,-1,-1,2),(634,'GID',1,57,'GID',0,-1,-1,3),(661,'LENGTH',0,58,'LENGTH',1,-1,-1,6),(660,'ZONA',0,58,'ZONA',0,-1,-1,1),(659,'ZONA_A',0,58,'ZONA_A',0,-1,-1,1),(657,'ID',0,58,'ID',1,-1,-1,3),(658,'PARQUE',0,58,'PARQUE',1,-1,-1,1),(656,'GEOM',0,58,'GEOM',0,-1,-1,2),(655,'GID',1,58,'GID',0,-1,-1,3),(626,'GID',1,56,'GID',0,-1,-1,3),(627,'GEOM',0,56,'GEOM',0,-1,-1,2),(628,'COD_ENT',0,56,'COD_ENT',0,-1,-1,1),(629,'COUNT',0,56,'COUNT',1,-1,-1,3),(630,'GID',1,54,'GID',0,-1,-1,3),(631,'GEOM',0,54,'GEOM',0,-1,-1,2),(632,'COD_ENT',0,54,'COD_ENT',0,-1,0,1),(633,'COUNT',0,54,'COUNT',1,-1,0,3),(637,'CUENCA',0,57,'Cuenca',1,-1,-1,1),(638,'DESCRIPC',0,57,'DESCRIPC',1,-1,-1,1),(639,'NATURALEZA',0,57,'NATURALEZA',1,-1,-1,1),(640,'UTILIZAC',0,57,'UTILIZAC',0,-1,-1,1),(641,'ZONA',0,57,'ZONA',0,-1,-1,1),(642,'COTA',0,57,'COTA',1,-1,-1,6),(643,'PROFUND',0,57,'PROFUND',1,-1,-1,6),(644,'FECHA',0,57,'FECHA',1,-1,-1,1),(645,'MUNICIPIO',0,57,'MUNICIPIO',1,-1,-1,1),(646,'PROVINCIA',0,57,'PROVINCIA',1,-1,-1,1),(668,'COD_ENT',0,60,'COD_ENT',0,-1,-1,1),(667,'GEOM',0,60,'GEOM',0,-1,-1,2),(666,'GID',1,60,'GID',0,-1,-1,3),(669,'COUNT',0,60,'COUNT',1,-1,-1,3),(670,'GID',1,61,'GID',0,-1,-1,3),(671,'GEOM',0,61,'GEOM',0,-1,-1,2),(672,'FNODE_',0,61,'FNODE_',1,-1,-1,3),(673,'TNODE_',0,61,'TNODE_',0,-1,-1,3),(674,'LPOLY_',0,61,'LPOLY_',1,-1,-1,3),(675,'RPOLY_',0,61,'RPOLY_',0,-1,-1,3),(676,'LENGTH',0,61,'LENGTH',1,-1,-1,6),(677,'IH2_100_',0,61,'IH2_100_',1,-1,-1,3),(678,'IH2_100_ID',0,61,'IH2_100_ID',1,-1,-1,3),(679,'COD_ENT',0,61,'COD_ENT',0,-1,-1,1),(680,'GID',1,62,'GID',0,-1,-1,3),(681,'GEOM',0,62,'GEOM',0,-1,-1,2),(682,'COD_ENT',0,62,'COD_ENT',0,-1,-1,1),(683,'NOMBRE',0,62,'NOMBRE',1,-1,-1,1),(684,'COD_MUN',0,62,'COD_MUN',1,-1,-1,3),(685,'MUNICIPIO',0,62,'MUNICIPIO',1,-1,-1,1),(689,'NOMBRE',0,63,'NOMBRE',1,-1,-1,1),(690,'INSTALACIO',1,66,'Instalaciones Acuíferas',1,-1,-1,1),(691,'GEOM',0,66,'GEOM',0,-1,-1,2),(692,'GID',1,66,'GID',0,-1,-1,3),(695,'GID',1,1067,'GID',0,-1,-1,4),(696,'C_PV',0,1067,'Provincia',1,1,-1,3),(697,'C_TM',0,1067,'Municipio',1,2,-1,3),(698,'C_POL',0,1067,'Poligono',1,3,-1,3),(699,'C_PAR',0,1067,'Parcela',1,4,0,3),(700,'C_REC',0,1067,'Recinto',1,5,-1,3),(701,'C_USO',0,1067,'Uso',1,6,-1,1),(702,'AREA',0,1067,'Area(m2)',1,7,-1,6),(703,'C_INCIDENCIAS',0,1067,'Incidencias',1,11,-1,1),(704,'COEF_PAS',0,1067,'Coeficiente de Pastoreo',1,9,-1,6),(705,'COEF_REG',0,1067,'Coeficiente de Regadío',1,8,-1,6),(715,'C_POL',0,1068,'Polígono',1,3,0,3),(716,'C_TM',0,1068,'Municipio',1,2,-1,3),(717,'C_PV',0,1068,'Provincia',1,1,-1,3),(718,'GID',1,1068,'GID',0,-1,-1,3),(719,'EMPRESA',0,30,'NOMBRE',1,-1,-1,1),(714,'GEOM',0,1068,'GEOM',0,-1,-1,2),(713,'PERIMETRO',0,1067,'Perímetro',0,-1,-1,6),(785,'COD_INIC',0,70,'Iniciativa de Riego',1,-1,-1,1),(784,'COD_DECLAR',0,70,'Tipo Decl. Mayoritario',1,-1,-1,1),(783,'ANTIG_EDAD',0,70,'Antigüedad Media',1,-1,-1,6),(782,'SUP_REGADA',0,70,'Sup. Regada (Ha.)',1,-1,-1,6),(781,'SUP_REGABL',0,70,'Sup. Regable (Ha.)',1,-1,-1,6),(780,'SUP_ABANDO',0,70,'Sup. Abandonada (Ha.)',1,-1,-1,6),(779,'POR_TENDEN',0,70,'',0,-1,-1,6),(778,'NUM_EXPL',0,70,'N. Explotaciones',1,-1,-1,6),(777,'JORNALES',0,70,'Empleo (JOR./Ha.)',1,-1,-1,6),(776,'PFA',0,70,'',0,-1,-1,6),(774,'COD_CULT',0,69,'Cultivo Mayoritario',1,-1,-1,1),(773,'PFA',0,69,NULL,0,-1,-1,6),(772,'JORNALES',0,69,'Empleo (JOR./Ha.)',1,-1,-1,6),(775,'COD_CULT',0,70,'Cultivo Mayoritario',1,-1,-1,1),(770,'NUM_EXPL',0,69,'N. Explotaciones',1,-1,-1,6),(769,'POR_TENDEN',0,69,'Tendencia de Crecimiento',0,-1,-1,6),(768,'SUP_ABANDO',0,69,'Sup. Abandonada (Ha.)',1,-1,-1,6),(767,'SUP_REGABL',0,69,'Sup. Regable (Ha.)',1,-1,-1,6),(766,'SUP_REGADA',0,69,'Sup. Regada (Ha.)',1,-1,-1,6),(765,'ANTIG_EDAD',0,69,'Antigüedad Media',1,-1,-1,6),(764,'COD_DECLAR',0,69,'Tipo Decl. Mayoritario',1,-1,-1,1),(763,'COD_INIC',0,69,'Iniciativa de Riego',1,-1,-1,1),(762,'COD_AREA',0,69,'Área',1,-1,-1,3),(761,'NOMBRE',0,69,'Nombre',1,-1,-1,1),(760,'CODIGO',0,69,'Código',0,-1,-1,3),(759,'GEOM',0,69,NULL,0,-1,-1,2),(758,'GID',1,69,NULL,0,-1,-1,4),(796,'COD_INIC',0,71,'Iniciativa de Riego',1,-1,-1,1),(787,'NOMBRE',0,70,'Nombre',1,-1,-1,1),(788,'CODIGO',0,70,'',0,-1,-1,3),(789,'GEOM',0,70,'',0,-1,-1,2),(790,'GID',1,70,'',0,-1,-1,4),(791,'CONSUMO',0,70,'Consumo de Agua (M3/Ha.)',1,-1,-1,6),(792,'NECHID',0,70,'Necesidad Híd. (M3/Ha.)',1,-1,-1,6),(793,'COD_ORIGEN',0,70,'Origen del Agua',1,-1,-1,1),(794,'COD_PTM3',0,70,'Coste Agua (EUROS/M3)',1,-1,-1,6),(795,'COD_RIEGO',0,70,'Sistema de Riego',1,-1,-1,1),(797,'COD_DECLAR',0,71,'Tipo Decl. Mayoritario',1,-1,-1,1),(798,'ANTIG_EDAD',0,71,'Antigüedad Media',1,-1,-1,6),(799,'SUP_REGADA',0,71,'Sup. Regada (Ha.)',1,-1,-1,6),(800,'SUP_REGABL',0,71,'Sup. Regable (Ha.)',1,-1,-1,6),(801,'SUP_ABANDO',0,71,'Sup. Abandonada (Ha.)',1,-1,-1,6),(802,'POR_TENDEN',0,71,'Tendencia de Crecimiento',0,-1,-1,6),(803,'NUM_EXPL',0,71,'N. Explotaciones',1,-1,-1,6),(804,'JORNALES',0,71,'Empleo (JOR./Ha.)',1,-1,-1,6),(805,'PFA',0,71,NULL,0,-1,-1,6),(806,'COD_CULT',0,71,'Cultivo Mayoritario',1,-1,-1,1),(807,'NOMBRE',0,71,'Nombre',1,-1,-1,1),(808,'CODIGO',0,71,'Código',0,-1,-1,3),(809,'GEOM',0,71,NULL,0,-1,-1,2),(810,'GID',1,71,NULL,0,-1,-1,4),(811,'CONSUMO',0,71,'Consumo de Agua (M3/Ha.)',1,-1,-1,6),(812,'NECHID',0,71,'Necesidad Híd. (M3/Ha.)',1,-1,-1,6),(813,'COD_ORIGEN',0,71,'Origen del Agua',1,-1,-1,1),(814,'COD_PTM3',0,71,'Coste Agua (EUROS/M3)',1,-1,-1,6),(815,'COD_RIEGO',0,71,'Sistema de Riego',1,-1,-1,1),(816,'COD_SER',0,71,NULL,0,-1,-1,1),(817,'COD_INIC',0,72,'Iniciativa de Riego',1,-1,-1,1),(818,'COD_DECLAR',0,72,'Tipo Decl. Mayoritario',1,-1,-1,1),(819,'ANTIG_EDAD',0,72,'Antigüedad Media',1,-1,-1,6),(820,'SUP_REGADA',0,72,'Sup. Regada (Ha.)',1,-1,-1,6),(821,'SUP_REGABL',0,72,'Sup. Regable (Ha.)',1,-1,-1,6),(822,'SUP_ABANDO',0,72,'Sup. Abandonada (Ha.)',1,-1,-1,6),(823,'POR_TENDEN',0,72,'Tendencia de Crecimiento',1,-1,-1,6),(824,'NUM_EXPL',0,72,'N. Explotaciones',1,-1,-1,6),(825,'JORNALES',0,72,'Empleo (JOR./Ha.)',1,-1,-1,6),(845,'GID',1,74,'',0,-1,-1,3),(827,'COD_CULT',0,72,'Cultivo Mayoritario',1,-1,-1,1),(829,'CODIGO',0,72,'Código',0,-1,-1,3),(830,'GEOM',0,72,NULL,0,-1,-1,2),(831,'GID',1,72,NULL,0,-1,-1,4),(832,'CONSUMO',0,72,'Consumo de Agua (M3/Ha.)',1,-1,-1,6),(833,'NECHID',0,72,'Necesidad Híd. (M3/Ha.)',1,-1,-1,6),(834,'COD_ORIGEN',0,72,'Origen del Agua',1,-1,-1,1),(835,'COD_PTM3',0,72,'Coste Agua (EUROS/M3)',1,-1,-1,6),(836,'COD_RIEGO',0,72,'Sistema de Riego',1,-1,-1,1),(844,'MODA_SUP',0,72,'Tamaño Exp. más Frec.',1,-1,-1,6),(846,'GEOM',0,74,'',0,-1,-1,2),(840,'CAMPOAUX',0,72,'Empleo UTA por 100 Ha.',0,-1,-1,6),(841,'PFA_M3',0,72,'Productividad (EUROS/M3)',0,-1,-1,6),(842,'M3_JORNAL',0,72,'Consumo/Empleo',0,-1,-1,6),(843,'PAC',0,72,'% Cultivos PAC',0,-1,-1,6),(847,'FECHA',0,74,'Fecha de vuelo',1,-1,-1,3),(848,'EMPRESA',0,66,'Nombre de la Empresa (Instalaciones Acuíferas)',1,-1,-1,1),(1038,'L_OTRAS',0,92,'Es otra',1,-1,-1,3),(1039,'MULTIPLE',0,92,'Es multiple',1,-1,-1,4),(852,'HUSO',0,2,NULL,0,-1,-1,3),(1067,'GID',1,96,NULL,0,-1,-1,3),(1033,'GEOM',0,92,NULL,0,-1,-1,2),(1041,'GID',1,93,NULL,0,-1,-1,3),(1068,'GEOM',0,96,NULL,0,-1,-1,2),(907,'GEOM',0,78,NULL,0,-1,-1,2),(908,'GID',1,78,NULL,0,-1,-1,3),(859,'GID',1,73,NULL,0,-1,-1,3),(860,'GEOM',0,73,NULL,0,-1,-1,2),(1073,'L_OTRAS',0,96,'Es otra',1,-1,-1,3),(862,'ID_OLI',1,1076,NULL,0,-1,-1,4),(863,'PROV',0,1076,'Código Provincia SIGO',1,1,-1,3),(864,'MUN',0,1076,'Código Municipio SIGO',1,2,-1,3),(865,'POL',0,1076,'Código Polígono SIGO',1,3,-1,3),(866,'PARC',0,1076,'Código Parcela SIGO',1,4,-1,4),(867,'X',0,1076,'Coordenada X',1,11,-1,6),(868,'Y',0,1076,'Coordenada Y',1,12,-1,6),(869,'TEXTO',0,1076,'Tipo de olivo',1,-1,-1,1),(870,'DAP',0,1076,NULL,0,-1,-1,3),(871,'INCIDENCIA',0,1076,'Incidencia',0,10,-1,1),(872,'FALTA',0,1076,NULL,0,-1,-1,5),(873,'FBAJA',0,1076,NULL,0,-1,-1,5),(874,'FPLANTACION',0,1076,'Fecha de Plantación',1,8,-1,5),(875,'CVALIDEZ',0,1076,'Campaña de Validez',0,9,-1,1),(876,'ID_CAUSA_BAJA',0,1076,NULL,0,-1,-1,3),(877,'PROV_SP',0,1076,'Código de Provincia SIGPAC',1,5,-1,3),(878,'MUN_SP',0,1076,'Código de Municipio SIGPAC',1,6,-1,3),(879,'POL_SP',0,1076,'Código de Polígono SIGPAC',1,7,-1,3),(880,'PARC_SP',0,1076,'Código de Parcela SIGPAC',1,8,-1,4),(881,'R_SP',0,1076,'Código de Recinto SIGPAC',1,9,-1,3),(882,'GEOM',0,1076,NULL,0,-1,-1,2),(886,'ID_OLI',1,79,NULL,0,-1,-1,4),(975,'GEOM',0,82,NULL,0,-1,-1,2),(884,'ANYO_REN_CATASTRO',0,2,NULL,0,-1,-1,3),(887,'PROV',0,79,'Código Provincia SIGO',1,1,-1,3),(888,'MUN',0,79,'Código Municipio SIGO',1,2,-1,3),(889,'POL',0,79,'Código Polígono SIGO',1,3,-1,3),(890,'PARC',0,79,'Código Parcela SIGO',1,4,-1,4),(891,'X',0,79,'Coordenada X',1,11,-1,6),(892,'Y',0,79,'Coordenada Y',1,12,-1,6),(893,'TEXTO',0,79,'Tipo de olivo',1,-1,-1,1),(894,'DAP',0,79,NULL,0,-1,-1,3),(895,'INCIDENCIA',0,79,'Incidencia',0,10,-1,1),(896,'FALTA',0,79,NULL,0,-1,-1,5),(897,'FBAJA',0,79,NULL,0,-1,-1,5),(898,'FPLANTACION',0,79,'Fecha de Plantación',1,8,-1,5),(899,'CVALIDEZ',0,79,'Campaña de Validez',0,9,-1,1),(900,'ID_CAUSA_BAJA',0,79,NULL,0,-1,-1,3),(901,'PROV_SP',0,79,'Código de Provincia SIGPAC',1,5,-1,3),(902,'MUN_SP',0,79,'Código de Municipio SIGPAC',1,6,-1,3),(903,'POL_SP',0,79,'Código de Polígono SIGPAC',1,7,-1,3),(904,'PARC_SP',0,79,'Código de Parcela SIGPAC',1,8,-1,4),(905,'R_SP',0,79,'Código de Recinto SIGPAC',1,9,-1,3),(906,'GEOM',0,79,NULL,0,-1,-1,2),(914,'PARC',0,80,'Código Parcela SIGO',1,4,-1,4),(1049,'L_OTRAS',0,93,'Es otra',1,-1,-1,3),(1050,'MULTIPLE',0,93,'Es multiple',1,-1,-1,4),(1085,'NO_SIGGAN',0,92,'NO pertenece al SIGGAN',1,-1,-1,4),(1042,'GEOM',0,93,NULL,0,-1,-1,2),(920,'FBAJA',0,80,NULL,0,-1,-1,5),(1032,'GID',1,92,NULL,0,-1,-1,3),(922,'CVALIDEZ',0,80,'Campaña de Validez',0,9,-1,1),(923,'ID_CAUSA_BAJA',0,80,NULL,0,-1,-1,3),(1074,'MULTIPLE',0,96,'Es multiple',1,-1,-1,4),(1069,'L_BOVINO',0,96,'Es bovino',1,-1,-1,3),(1070,'L_OVINO',0,96,'Es ovino',1,-1,-1,3),(927,'PARC_SP',0,80,'Código de Parcela SIGPAC',1,8,-1,4),(1075,'GID',1,97,NULL,0,-1,-1,3),(1037,'L_CAPRINO',0,92,'Es caprino',1,-1,-1,3),(931,'ID_OLI',1,80,NULL,0,-1,-1,4),(932,'PROV',0,80,'Código Provincia SIGO',1,1,-1,3),(933,'MUN',0,80,'Código Municipio SIGO',1,2,-1,3),(934,'POL',0,80,'Código Polígono SIGO',1,3,-1,3),(1076,'GEOM',0,97,NULL,0,-1,-1,2),(936,'X',0,80,'Coordenada X',1,11,-1,6),(937,'Y',0,80,'Coordenada Y',1,12,-1,6),(938,'TEXTO',0,80,'Tipo de olivo',1,-1,-1,1),(939,'DAP',0,80,NULL,0,-1,-1,3),(940,'FALTA',0,80,NULL,0,-1,-1,5),(942,'FPLANTACION',0,80,'Fecha de Plantación',1,8,-1,5),(1036,'L_PORCINO',0,92,'Es porcino',1,-1,-1,3),(1035,'L_OVINO',0,92,'Es ovino',1,-1,-1,3),(945,'PROV_SP',0,80,'Código de Provincia SIGPAC',1,5,-1,3),(946,'MUN_SP',0,80,'Código de Municipio SIGPAC',1,6,-1,3),(947,'POL_SP',0,80,'Código de Polígono SIGPAC',1,7,-1,3),(949,'R_SP',0,80,'Código de Recinto SIGPAC',1,9,-1,3),(950,'GEOM',0,80,NULL,0,-1,-1,2),(976,'GID',1,82,NULL,0,-1,-1,3),(953,'ID_OLI',1,81,NULL,0,-1,-1,4),(954,'PROV',0,81,'Código Provincia SIGO',1,1,-1,3),(955,'MUN',0,81,'Código Municipio SIGO',1,2,-1,3),(956,'POL',0,81,'Código Polígono SIGO',1,3,-1,3),(957,'PARC',0,81,'Código Parcela SIGO',1,4,-1,4),(958,'X',0,81,'Coordenada X',1,11,-1,6),(959,'Y',0,81,'Coordenada Y',1,12,-1,6),(960,'TEXTO',0,81,'Tipo de olivo',1,-1,-1,1),(961,'DAP',0,81,NULL,0,-1,-1,3),(962,'FALTA',0,81,NULL,0,-1,-1,5),(963,'FBAJA',0,81,NULL,0,-1,-1,5),(964,'FPLANTACION',0,81,'Fecha de Plantación',1,8,-1,5),(965,'CVALIDEZ',0,81,'Campaña de Validez',0,9,-1,1),(966,'ID_CAUSA_BAJA',0,81,NULL,0,-1,-1,3),(967,'PROV_SP',0,81,'Código de Provincia SIGPAC',1,5,-1,3),(968,'MUN_SP',0,81,'Código de Municipio SIGPAC',1,6,-1,3),(969,'POL_SP',0,81,'Código de Polígono SIGPAC',1,7,-1,3),(970,'PARC_SP',0,81,'Código de Parcela SIGPAC',1,8,-1,4),(971,'R_SP',0,81,'Código de Recinto SIGPAC',1,9,-1,3),(972,'GEOM',0,81,NULL,0,-1,-1,2),(973,'GID',1,77,NULL,0,-1,-1,3),(974,'GEOM',0,77,NULL,0,-1,-1,2),(1071,'L_PORCINO',0,96,'Es porcino',1,-1,-1,3),(1072,'L_CAPRINO',0,96,'Es caprino',1,-1,-1,3),(1063,'L_PORCINO',0,95,'Es porcino',1,-1,-1,3),(1064,'L_CAPRINO',0,95,'Es caprino',1,-1,-1,3),(1065,'L_OTRAS',0,95,'Es otra',1,-1,-1,3),(1066,'MULTIPLE',0,95,'Es multiple',1,-1,-1,4),(1059,'GID',1,95,NULL,0,-1,-1,3),(1060,'GEOM',0,95,NULL,0,-1,-1,2),(1061,'L_BOVINO',0,95,'Es bovino',1,-1,-1,3),(1062,'L_OVINO',0,95,'Es ovino',1,-1,-1,3),(1055,'L_PORCINO',0,94,'Es porcino',1,-1,-1,3),(1056,'L_CAPRINO',0,94,'Es caprino',1,-1,-1,3),(1057,'L_OTRAS',0,94,'Es otra',1,-1,-1,3),(1058,'MULTIPLE',0,94,'Es multiple',1,-1,-1,4),(1051,'GID',1,94,NULL,0,-1,-1,3),(1052,'GEOM',0,94,NULL,0,-1,-1,2),(1053,'L_BOVINO',0,94,'Es bovino',1,-1,-1,3),(1054,'L_OVINO',0,94,'Es ovino',1,-1,-1,3),(1086,'NO_SIGGAN',0,93,'NO pertenece al SIGGAN',1,-1,-1,4),(1034,'L_BOVINO',0,92,'Es bovino',1,-1,-1,3),(1045,'L_BOVINO',0,93,'Es bovino',1,-1,-1,3),(1046,'L_OVINO',0,93,'Es ovino',1,-1,-1,3),(1047,'L_PORCINO',0,93,'Es porcino',1,-1,-1,3),(1048,'L_CAPRINO',0,93,'Es caprino',1,-1,-1,3),(1026,'GEOM',0,89,NULL,0,-1,-1,2),(1027,'GID',1,89,NULL,0,-1,-1,3),(1028,'GEOM',0,90,NULL,0,-1,-1,2),(1029,'GID',1,90,NULL,0,-1,-1,3),(1030,'GEOM',0,91,NULL,0,-1,-1,2),(1031,'GID',1,91,NULL,0,-1,-1,3),(1077,'L_BOVINO',0,97,'Es bovino',1,-1,-1,3),(1078,'L_OVINO',0,97,'Es ovino',1,-1,-1,3),(1079,'L_PORCINO',0,97,'Es porcino',1,-1,-1,3),(1080,'L_CAPRINO',0,97,'Es caprino',1,-1,-1,3),(1081,'L_OTRAS',0,97,'Es otra',1,-1,-1,3),(1082,'MULTIPLE',0,97,'Es multiple',1,-1,-1,4),(1087,'NO_SIGGAN',0,94,'NO pertenece al SIGGAN',1,-1,-1,4),(1088,'NO_SIGGAN',0,95,'NO pertenece al SIGGAN',1,-1,-1,4),(1089,'NO_SIGGAN',0,96,'NO pertenece al SIGGAN',1,-1,-1,4),(1090,'NO_SIGGAN',0,97,'NO pertenece al SIGGAN',1,-1,-1,4),(1091,'GID',1,98,NULL,0,-1,-1,3),(1092,'GEOM',0,98,NULL,0,-1,-1,2),(1093,'L_BOVINO',0,98,'Es bovino',1,-1,-1,3),(1094,'L_OVINO',0,98,'Es ovino',1,-1,-1,3),(1095,'L_PORCINO',0,98,'Es porcino',1,-1,-1,3),(1096,'L_CAPRINO',0,98,'Es caprino',1,-1,-1,3),(1097,'L_OTRAS',0,98,'Es otra',1,-1,-1,3),(1098,'MULTIPLE',0,98,'Es multiple',1,-1,-1,4),(1099,'NO_SIGGAN',0,98,'NO pertenece al SIGGAN',1,-1,-1,4),(1100,'GID',0,99,NULL,0,-1,-1,0),(1101,'GEOM',0,99,NULL,0,-1,-1,0),(1102,'GID',1,101,NULL,0,-1,-1,3),(1103,'GEOM',0,101,NULL,0,-1,-1,2),(1104,'GID',1,102,NULL,0,-1,-1,3),(1105,'GEOM',0,102,NULL,0,-1,-1,2),(1106,'GID',1,103,NULL,0,-1,-1,3),(1107,'GEOM',0,103,NULL,0,-1,-1,2),(1108,'GID',1,104,NULL,0,-1,-1,3),(1109,'GEOM',0,104,NULL,0,-1,-1,2),(1110,'C_EXP_COMP',0,104,NULL,1,-1,-1,1),(1111,'C_EXP_COMP',0,92,NULL,1,-1,-1,1),(1112,'C_EXP_COMP',1,93,NULL,1,-1,-1,1),(1113,'C_EXP_COMP',1,94,NULL,1,-1,-1,1),(1114,'C_EXP_COMP',1,95,NULL,1,-1,-1,1),(1115,'C_EXP_COMP',1,96,NULL,1,-1,-1,1),(1116,'C_EXP_COMP',1,97,NULL,1,-1,-1,1),(1117,'C_EXP_COMP',1,98,NULL,1,-1,-1,1),(1118,'MUN_NOMBRE',0,92,NULL,0,-1,-1,1),(1119,'MUN_NOMBRE',0,93,NULL,0,-1,-1,1),(1120,'MUN_NOMBRE',0,94,NULL,0,-1,-1,1),(1121,'MUN_NOMBRE',0,95,NULL,0,-1,-1,1),(1122,'MUN_NOMBRE',0,96,NULL,0,-1,-1,1),(1123,'MUN_NOMBRE',0,97,NULL,0,-1,-1,1),(1124,'MUN_NOMBRE',0,98,NULL,0,-1,-1,1),(1125,'C_PV',0,92,NULL,0,-1,-1,3),(1126,'C_PV',0,93,NULL,0,-1,-1,3),(1127,'C_PV',0,94,NULL,0,-1,-1,3),(1128,'C_PV',0,95,NULL,0,-1,-1,3),(1129,'C_PV',0,96,NULL,0,-1,-1,3),(1130,'C_PV',0,97,NULL,0,-1,-1,3),(1131,'C_PV',0,98,NULL,0,-1,-1,3),(1135,'NO_SIGGAN',0,105,NULL,1,-1,-1,4),(1136,'L_CAPRINO',0,105,'Es Caprino',1,-1,-1,3),(1137,'L_OVINO',0,105,'Es Ovino',1,-1,-1,3),(1139,'L_BOVINO',0,105,'Es Bovino',1,-1,-1,3),(1140,'GID',1,105,NULL,0,-1,-1,3),(1141,'L_PORCINO',0,105,'Es Porcino',1,-1,-1,3),(1142,'C_EXP_COMP',0,105,NULL,1,-1,-1,1),(1143,'L_OTRAS',0,105,'Es Otra',1,-1,-1,3),(1144,'GEOM',0,105,NULL,0,-1,-1,2),(1145,'MULTIPLE',0,105,'Es Multiple',1,-1,-1,4),(1146,'MUN_NOMBRE',0,105,NULL,0,-1,-1,1),(1147,'C_PV',0,105,NULL,0,-1,-1,3),(1148,'GID',1,107,'Zonas de restricción de herbicidas',0,-1,-1,3),(1149,'GEOM',0,107,'Zonas de restricción de herbicidas',0,-1,-1,2),(1150,'NOMBRE',0,107,'Embalse',1,-1,-1,1),(1151,'CAT1',0,1067,'Categoría 1',1,13,-1,6),(1152,'CAT2',0,1067,'Categoría 2',1,14,-1,6),(1153,'CAT3',0,1067,'Categoría 3',1,15,-1,6),(1154,'CAT4',0,1067,'Categoría 4',1,16,-1,6),(1155,'CAT5',0,1067,'Categoría 5',1,17,-1,6),(1156,'CAT6',0,1067,'Categoría 6',1,18,-1,6),(1157,'PDTE_MEDIA',0,1067,'Pendiente Media',1,12,-1,6),(1230,'ESPECIE',0,1120,'Especie',1,-1,0,3),(1228,'X',0,1120,'Coordenada X',1,-1,0,4),(1229,'Y',0,1120,' Coordenada Y',1,-1,0,4),(1227,'C_REC',0,1120,'Recinto SIGPAC',1,-1,0,3),(1226,'C_PAR',0,1120,'Parcela',1,-1,0,3),(1225,'C_POL',0,1120,' Polígono',1,-1,0,3),(1224,'C_TM',0,1120,'Municipio',1,-1,0,3),(1222,'C_PV',0,1120,'Provincia',1,-1,0,3),(1221,'GEOM',0,1120,NULL,1,-1,0,2),(1220,'ID_ARBOL',1,1120,NULL,0,-1,0,4),(13001,'GID',1,13001,NULL,0,-1,0,3),(13002,'GEOM',0,13001,NULL,0,-1,0,2),(13003,'C_USUARIO',0,13001,NULL,0,-1,0,3),(13004,'C_PARCELA',0,13001,NULL,0,-1,0,3),(13005,'C_IMPRESO',0,13001,NULL,0,-1,0,3),(13006,'C_CULTIVO',0,13001,NULL,0,-1,0,1),(13007,'C_VARIEDAD',0,13001,NULL,0,-1,0,1),(13008,'T_NOMBRE',0,13001,NULL,0,-1,0,1),(13009,'C_REGIMEN_AYUDA',0,13001,NULL,0,-1,0,1),(13010,'GID',1,13002,NULL,0,-1,0,4),(13011,'GEOM',0,13002,NULL,0,-1,0,2),(13012,'C_TIPO',0,13002,'Tipo de Olivo',1,-1,0,1),(13034,'TEXTO',0,13003,'Tipo Olivo',1,-1,0,1),(13033,'Y',0,13003,' Coordenada Y',1,-1,0,6),(13032,'X',0,13003,'Coordenada X',1,-1,0,6),(13028,'PROV',0,13003,'Provincia',1,-1,0,3),(13029,'MUN',0,13003,'Municipio',1,-1,0,3),(13030,'POL',0,13003,' Poligono',1,-1,0,3),(13031,'PARC',0,13003,'Parcela',1,-1,0,4),(13027,'FPLANTACION',0,13003,'Fecha de plantación',1,-1,0,5),(13026,'R_SP',0,13003,'Recinto SIGPAC',1,-1,0,3),(13025,'PARC_SP',0,13003,'Parcela SIGPAC',1,-1,0,4),(13049,'TEXTO',0,13004,'Tipo Olivo',1,-1,0,1),(13048,'Y',0,13004,' Coordenada Y',1,-1,0,6),(13047,'X',0,13004,'Coordenada X',1,-1,0,6),(13043,'PROV',0,13004,'Provincia',1,-1,0,3),(13044,'MUN',0,13004,'Municipio',1,-1,0,3),(13045,'POL',0,13004,' Poligono',1,-1,0,3),(13046,'PARC',0,13004,'Parcela',1,-1,0,4),(13042,'FPLANTACION',0,13004,'Fecha de plantación',1,-1,0,5),(13041,'R_SP',0,13004,'Recinto SIGPAC',1,-1,0,3),(13040,'PARC_SP',0,13004,'Parcela SIGPAC',1,-1,0,4),(13064,'TEXTO',0,13005,'Tipo Olivo',1,-1,0,1),(13063,'Y',0,13005,' Coordenada Y',1,-1,0,6),(13062,'X',0,13005,'Coordenada X',1,-1,0,6),(13058,'PROV',0,13005,'Provincia',1,-1,0,3),(13059,'MUN',0,13005,'Municipio',1,-1,0,3),(13060,'POL',0,13005,' Poligono',1,-1,0,3),(13061,'PARC',0,13005,'Parcela',1,-1,0,4),(13057,'FPLANTACION',0,13005,'Fecha de plantación',1,-1,0,5),(13056,'R_SP',0,13005,'Recinto SIGPAC',1,-1,0,3),(13055,'PARC_SP',0,13005,'Parcela SIGPAC',1,-1,0,4),(13024,'POL_SP',0,13003,' Poligono SIGPAC',1,-1,0,3),(13023,'MUN_SP',0,13003,'Municipio SIGPAC',1,-1,0,3),(13022,'PROV_SP',0,13003,'Provincia SIGPAC',1,-1,0,3),(13021,'GEOM',0,13003,NULL,0,-1,0,2),(13039,'POL_SP',0,13004,' Poligono SIGPAC',1,-1,0,3),(13038,'MUN_SP',0,13004,'Municipio SIGPAC',1,-1,0,3),(13037,'PROV_SP',0,13004,'Provincia SIGPAC',1,-1,0,3),(13036,'GEOM',0,13004,NULL,0,-1,0,2),(13054,'POL_SP',0,13005,' Poligono SIGPAC',1,-1,0,3),(13053,'MUN_SP',0,13005,'Municipio SIGPAC',1,-1,0,3),(13052,'PROV_SP',0,13005,'Provincia SIGPAC',1,-1,0,3),(13051,'GEOM',0,13005,NULL,0,-1,0,2),(13020,'ID_OLI',1,13003,NULL,0,-1,0,4),(13035,'ID_OLI',1,13004,NULL,0,-1,0,4),(13050,'ID_OLI',1,13005,NULL,0,-1,0,4);
UNLOCK TABLES;
/*!40000 ALTER TABLE `schema_attributes` ENABLE KEYS */;

--
-- Table structure for table `spatial_references`
--

DROP TABLE IF EXISTS `spatial_references`;
CREATE TABLE `spatial_references` (
  `SRID` bigint(20) NOT NULL auto_increment,
  `FALSEX` int(11) NOT NULL default '0',
  `FALSEY` int(11) NOT NULL default '0',
  `FALSEZ` int(11) NOT NULL default '0',
  `FALSEM` int(11) NOT NULL default '0',
  `XYUNITS` int(11) NOT NULL default '0',
  `ZUNITS` int(11) NOT NULL default '0',
  `MUNITS` int(11) NOT NULL default '0',
  `DESCRIPTION` varchar(255) default NULL,
  `AUTH_NAME` varchar(255) default NULL,
  `AUTH_SRID` int(11) default NULL,
  `SRTEXT` varchar(255) default NULL,
  PRIMARY KEY  (`SRID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `spatial_references`
--


/*!40000 ALTER TABLE `spatial_references` DISABLE KEYS */;
LOCK TABLES `spatial_references` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `spatial_references` ENABLE KEYS */;

--
-- Table structure for table `storages_types`
--

DROP TABLE IF EXISTS `storages_types`;
CREATE TABLE `storages_types` (
  `C_STORAGE_TYPE` bigint(20) NOT NULL auto_increment,
  `D_STORAGE_TYPE` varchar(255) NOT NULL default '',
  `T_DESCRIPCION` varchar(255) default NULL,
  PRIMARY KEY  (`C_STORAGE_TYPE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `storages_types`
--


/*!40000 ALTER TABLE `storages_types` DISABLE KEYS */;
LOCK TABLES `storages_types` WRITE;
INSERT INTO `storages_types` VALUES (1,'WKB','Almacenimiento en formato WKB'),(2,'WKT','Almacenamiento en formato WKT'),(3,'SHAPE','Almacenamiento en formato SHAPE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `storages_types` ENABLE KEYS */;

--
-- Table structure for table `strokes`
--

DROP TABLE IF EXISTS `strokes`;
CREATE TABLE `strokes` (
  `STROKE_ID` bigint(20) NOT NULL auto_increment,
  `NAME` varchar(255) default NULL,
  `STROKE_COLOR` varchar(255) NOT NULL default '',
  `STROKE_OPACITY` varchar(255) NOT NULL default '',
  `STROKE_WIDTH` varchar(255) NOT NULL default '',
  `STROKE_LINEJOIN` varchar(255) default NULL,
  `STROKE_LINECAP` varchar(255) default NULL,
  `STROKE_DASHARRAY` varchar(255) default NULL,
  `STROKE_TYPE` smallint(6) NOT NULL default '0',
  `GRAPHIC_ID` bigint(20) default NULL,
  PRIMARY KEY  (`STROKE_ID`),
  KEY `GRAPHIC_ID` (`GRAPHIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `strokes`
--


/*!40000 ALTER TABLE `strokes` DISABLE KEYS */;
LOCK TABLES `strokes` WRITE;
INSERT INTO `strokes` VALUES (1,'Provincias','#238E23','1.0','1','1','1',NULL,0,NULL),(2,'Acuicultura','#003366','1.0','1','1','1',NULL,0,NULL),(4,'Localizador Instalaciones Acuiferas','#52F3FF','1.0','2','1','1',NULL,0,NULL),(3,'Municipios','#0000FF','1.0','1','1','1',NULL,0,NULL),(9,'Ocas 2','#006600','1.0','2','1','1',NULL,0,NULL),(8,'Ocas 1','#006600','1.0','1','1','1',NULL,0,NULL),(10,'Hojas 10000','#0000FF','1.0','1','1','1',NULL,0,NULL),(11,'Hojas 50000','#336633','1.0','2','1','1',NULL,0,NULL),(12,'Hojas 100000','#C80000','1.0','2','1','1',NULL,0,NULL),(13,'Hidrografía','#0000FF','1.0','1','1','1',NULL,0,NULL),(14,'Carreteras (Autovía RIGE) 1','#000000','1.0','5','1','1',NULL,0,NULL),(15,'Carreteras (Autovía RIGE) 2','#FF6464','1.0','3','1','1',NULL,0,NULL),(16,'Carreteras (Autovía RIGE) 3','#000000','1.0','1','1','1',NULL,0,NULL),(17,'Carreteras (Autovía Básica) 1','#000000','1.0','5','1','1',NULL,0,NULL),(18,'Carreteras (Autovía Básica) 2','#FFFF00','1.0','3','1','1',NULL,0,NULL),(19,'Carreteras (Autovía Básica) 3','#000000','1.0','1','1','1',NULL,0,NULL),(20,'Carreteras (Autovía Intercomarcal) 1','#1BE31B','1.0','3','1','1',NULL,0,NULL),(21,'Carreteras (Autovía Intercomarcal) 2','#000000','1.0','1','1','1',NULL,0,NULL),(22,'Carreteras (Autovía Secundaria) 1','#E37F1B','1.0','3','1','1',NULL,0,NULL),(23,'Carreteras (Autovía Secundaria) 2','#000000','1.0','1','1','1',NULL,0,NULL),(24,'Carreteras (Carretera RIGE)','#FF0000','1.0','1','1','1',NULL,0,NULL),(25,'Carreteras (Carretera Red Básica)','#7D3200','1.0','1','1','1',NULL,0,NULL),(26,'Carreteras (Carretera Intercomarcal)','#00FF00','1.0','1','1','1',NULL,0,NULL),(27,'Carreteras (Carretera Secundaria)','#646400','1.0','1','1','1',NULL,0,NULL),(28,'Instalaciones Acuíferas','#6E6E6E','1.0','1','1','1',NULL,0,NULL),(29,'Zonas Especial Protección Mediomabiental','#0DEE3A','1.0','2','1','1','5,2,3,2',0,NULL),(30,'Caminos (Acuicultura)','#646400','1.0','1','1','1',NULL,0,NULL),(31,'Almadrabas','#FCA045','1.0','2','1','1',NULL,0,NULL),(32,'Batimetría','#003399','1.0','1','1','1',NULL,0,NULL),(33,'Puntos de Vertidos','#000000','1.0','0.1','1','1',NULL,0,NULL),(45,'Propuesta Lugares de Interés Comunitario','#257405','1.0','1','1','1',NULL,0,NULL),(34,'Cables Submarinos','#00FF00','1.0','1','1','1','5,2,3,2',0,NULL),(35,'Pot (Equipamientos)','#FFAA00','1.0','2','1','1',NULL,0,NULL),(36,'Pot (Espacios Libres)','#00FFE6','1.0','2','1','1',NULL,0,NULL),(37,'Pot (Limitaciones Específicas)','#A900E6','1.0','2','1','1',NULL,0,NULL),(38,'Pot (Limitaciones Generales)','#E60000','1.0','2','1','1',NULL,0,NULL),(39,'Áreas Arqueológicas','#0000FF','1.0','1','1','1',NULL,0,NULL),(40,'Arrecifes (En ejecución)','#FF66FF','1.0','1','1','1',NULL,0,NULL),(41,'Arrecifes (En proyecto)','#0066FF','1.0','1','1','1',NULL,0,NULL),(42,'Arrecifes (Instalado)','#000000','1.0','1','1','1',NULL,0,NULL),(43,'Salinas','#6E6E6E','1.0','1','1','1',NULL,0,NULL),(44,'Hábitats de Interés','#107E31','1.0','1','1','1',NULL,0,NULL),(5,'Recintos SigPac','#FFFF00','1.0','1','1','1',NULL,1,NULL),(6,'Polígonos SigPac','#FF2400','1.0','1','1','1',NULL,1,NULL),(46,'Aridos','#FEE100','1.0','1','1','1',NULL,0,NULL),(47,'Abastecimiento 1','#990099','1.0','1','1','1',NULL,0,NULL),(48,'Abastecimiento 2','#CC6600','1.0','1','1','1',NULL,0,NULL),(49,'Playas 1','#FFAA00','1.0','1','1','1',NULL,0,NULL),(50,'Zonas Industriales','#6E6E6E','1.0','1','1','1',NULL,0,NULL),(51,'Zonas Portuarias 1','#9999FF','1.0','1','1','1',NULL,0,NULL),(52,'Zonas Portuarias 2','#FF0033','1.0','1','1','1',NULL,0,NULL),(53,'Zonas Portuarias 3','#9999FF','1.0','1','1','1',NULL,0,NULL),(54,'Zonas Militares 1','#9C9C9C','1.0','2','1','1',NULL,0,NULL),(55,'Conductos 1','#009600','1.0','1','1','1',NULL,0,NULL),(56,'Conductos 2','#007896','1.0','1','1','1',NULL,0,NULL),(57,'Conductos 3','#00FF99','1.0','1','1','1',NULL,0,NULL),(58,'Conductos 4','#640000','1.0','1','1','1',NULL,0,NULL),(59,'Conductos 5','#009600','1.0','1','1','1',NULL,0,NULL),(60,'Ferrocarril 1','#C80000','1.0','1','1','1',NULL,0,NULL),(61,'Ferrocarril 2','#000096','1.0','1','1','1',NULL,0,NULL),(62,'Ferrocarril 3','#000000','1.0','1','1','1',NULL,0,NULL),(63,'Ferrocarril 4','#78460A','1.0','1','1','1',NULL,0,NULL),(64,'Ferrocarril 5','#969696','1.0','1','1','1',NULL,0,NULL),(65,'Acuiferos','#000096','1.0','1','1','1',NULL,0,NULL),(66,'eennpp','#66CC00','1.0','1','1','1',NULL,0,NULL),(67,'Superficies de aguas','#0000FF','1.0','1','1','1',NULL,0,NULL),(68,'Zonas Militares 2','#9C9C9C','1.0','1','1','1','5,3,2,3',0,NULL),(69,'Areas de Riego','#FF8000','1.0','1','1','1',NULL,0,NULL),(70,'Cuencas Hidrográficas','#60BCD7','1.0','5','1','1',NULL,0,NULL),(71,'Sistemas de Explotación','#FF0000','1.0','3','1','1',NULL,0,NULL),(72,'Dibujar Polígonos Acuicultura','#FA0000','1.0','3','1','1',NULL,0,NULL),(73,'Olivos Tipo N','#339933','1.0','0.2','0','1',NULL,0,NULL),(75,'Localizador Recintos SIGO','#F87A17','1.0','4','1','1',NULL,0,NULL),(74,'Localizador Recintos SIGPAC','#B5E917','1.0','2','1','1',NULL,0,NULL),(76,'Olivos Tipo S','#990000','1.0','0.2','0','1',NULL,0,NULL),(77,'Olivos Tipo A','#065F22','1.0','0.2','0','1',NULL,0,NULL),(78,'Parcela de Forestacion','#33CFCC','1.0','2','1','1',NULL,0,NULL),(79,'Stroke blanco','#FFFFFF','1.0','0.5','1','1',NULL,0,NULL),(80,'Localizador Parcelas SIGPAC','#1DEF26','1.0','2.5','1','1',NULL,0,NULL),(81,'Insercion en mapa','#68A6EF','1.0','2','1','1',NULL,0,NULL),(82,'Localizador Genérico','#FA0000','1.0','2','1','1',NULL,0,NULL),(83,'Ganaderia (Proteccion)','#FF0000','0.6','4','1','1',NULL,0,NULL),(84,'Ganaderia (Vigilancia)','#FFFF00','0.6','4','1','1',NULL,0,NULL),(85,'Ganaderia (Riesgo)','#5E767E','0.6','2','1','1',NULL,0,NULL),(86,'Zonas de restricción de herbicidas','#FF0000','1','2','1','1',NULL,0,NULL),(12003,'Olivar Cropac','#065F22','1','4','1','1',NULL,0,NULL),(13001,'ParcelaCroquis','#EFEFEF','1','5','1','1',NULL,0,NULL),(13002,'Frutales de Cáscara','#BF9777','1','1','1','1',NULL,0,NULL),(13003,'OLIVAR_N','#065F22','1','4','1','1',NULL,0,NULL),(13004,'OLIVAR_A','#BF3A0B','1','4','1','1',NULL,0,NULL),(13005,'OLIVAR_S','#EFAE00','1','4','1','1',NULL,0,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `strokes` ENABLE KEYS */;

--
-- Table structure for table `symbolizers`
--

DROP TABLE IF EXISTS `symbolizers`;
CREATE TABLE `symbolizers` (
  `SYMBOLIZER_ID` bigint(20) NOT NULL auto_increment,
  `SYMBOLIZER_TYPE` varchar(255) NOT NULL default '',
  `NAME` varchar(255) default NULL,
  `GEOM_PROPERTY` varchar(255) NOT NULL default '',
  `STROKE_ID` bigint(20) default NULL,
  `FILL_ID` bigint(20) default NULL,
  `GRAPHIC_ID` bigint(20) default NULL,
  `HALO_ID` bigint(20) default NULL,
  `FONT_ID` bigint(20) default NULL,
  `LABEL_PLACEMENT_ID` bigint(20) default NULL,
  `RULE_ID` bigint(20) default NULL,
  `LABEL_SEPARATOR` varchar(4) default NULL,
  `classifier` varchar(255) default NULL,
  PRIMARY KEY  (`SYMBOLIZER_ID`),
  KEY `HALO_ID` (`HALO_ID`),
  KEY `STROKE_ID` (`STROKE_ID`),
  KEY `RULE_ID` (`RULE_ID`),
  KEY `LABEL_PLACEMENT_ID` (`LABEL_PLACEMENT_ID`),
  KEY `FILL_ID` (`FILL_ID`),
  KEY `FONT_ID` (`FONT_ID`),
  KEY `GRAPHIC_ID` (`GRAPHIC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `symbolizers`
--


/*!40000 ALTER TABLE `symbolizers` DISABLE KEYS */;
LOCK TABLES `symbolizers` WRITE;
INSERT INTO `symbolizers` VALUES (1,'POLYGON','Provincias','GEOM',1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL),(2,'TEXT','Etiquetas Provincias','GEOM',NULL,6,NULL,1,1,1,1,'-',NULL),(241,'POLYGON','Dibujar Polígono Acuicultura','GEOM',72,NULL,NULL,NULL,NULL,NULL,236,NULL,NULL),(242,'POINT','Olivos tipo N','GEOM',NULL,NULL,8,NULL,NULL,NULL,238,NULL,NULL),(10,'TEXT','Etiquetas Localizador Instalaciones Acuicultura','GEOM',NULL,3,NULL,1,1,1,4,NULL,NULL),(7,'POLYGON','Municipios','GEOM',3,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL),(8,'TEXT','Etiquetas Municipios','GEOM',NULL,7,NULL,1,1,1,5,'-',NULL),(9,'LINE','Localizador Instalaciones Acuicultura','GEOM',4,NULL,NULL,NULL,NULL,NULL,3,NULL,NULL),(13,'POLYGON','Núcleos (Cabecera Municipal)','GEOM',NULL,12,NULL,NULL,NULL,NULL,10,NULL,NULL),(12,'POLYGON','Núcleos (Secundario)','GEOM',NULL,11,NULL,NULL,NULL,NULL,9,NULL,NULL),(14,'POLYGON','Núcleos (Urbanización)','GEOM',NULL,13,NULL,NULL,NULL,NULL,11,NULL,NULL),(15,'POLYGON','Núcleos (Diseminado)','GEOM',NULL,14,NULL,NULL,NULL,NULL,12,NULL,NULL),(16,'TEXT','Etiquetas Núcleos','GEOM',NULL,15,NULL,1,1,1,13,'-',NULL),(17,'POLYGON','Ocas 1','GEOM',8,NULL,NULL,NULL,NULL,NULL,23,NULL,NULL),(18,'POLYGON','Ocas 2','GEOM',9,NULL,NULL,NULL,NULL,NULL,24,NULL,NULL),(19,'TEXT','Etiquetas Ocas','GEOM',NULL,16,NULL,1,1,1,25,NULL,NULL),(20,'POLYGON','Hojas 10000','GEOM',10,NULL,NULL,NULL,NULL,NULL,28,NULL,NULL),(21,'TEXT','Etiquetas Hojas 10000','GEOM',NULL,17,NULL,1,2,1,29,NULL,NULL),(22,'POLYGON','Hojas 50000','GEOM',11,NULL,NULL,NULL,NULL,NULL,30,NULL,NULL),(23,'TEXT','Etiquetas Hojas 50000','GEOM',NULL,18,NULL,1,2,1,31,NULL,NULL),(24,'POLYGON','Hojas 100000','GEOM',12,NULL,NULL,NULL,NULL,NULL,33,NULL,NULL),(25,'TEXT','Etiquetas Hojas 100000','GEOM',NULL,19,NULL,1,2,1,34,NULL,NULL),(26,'TEXT','Etiquetas Topónimos','GEOM',NULL,20,NULL,1,2,1,35,NULL,NULL),(27,'LINE','Hidrografía','GEOM',13,NULL,NULL,NULL,0,0,36,NULL,NULL),(28,'TEXT','Etiquetas Hidrografía','GEOM',NULL,21,NULL,1,2,1,37,NULL,NULL),(29,'LINE','Carreteras (Autovía RIGE) 1','GEOM',14,NULL,NULL,NULL,NULL,NULL,38,NULL,NULL),(30,'LINE','Carreteras (Autovía RIGE) 2','GEOM',15,NULL,NULL,NULL,NULL,NULL,38,NULL,NULL),(31,'LINE','Carreteras (Autovía RIGE) 3','GEOM',16,NULL,NULL,NULL,NULL,NULL,38,NULL,NULL),(32,'LINE','Carreteras (Autovía Básica) 1','GEOM',17,NULL,NULL,NULL,NULL,NULL,39,NULL,NULL),(33,'LINE','Carreteras (Autovía Básica) 2','GEOM',18,NULL,NULL,NULL,NULL,NULL,39,NULL,NULL),(34,'LINE','Carreteras (Autovía Básica) 3','GEOM',19,NULL,NULL,NULL,NULL,NULL,39,NULL,NULL),(35,'LINE','Carreteras (Autovía Intercomarcal) 1','GEOM',20,NULL,NULL,NULL,NULL,NULL,40,NULL,NULL),(36,'LINE','Carreteras (Autovía Intercomarcal) 2','GEOM',21,NULL,NULL,NULL,NULL,NULL,40,NULL,NULL),(37,'LINE','Carreteras (Autovía Secundaria) 1','GEOM',22,NULL,NULL,NULL,NULL,NULL,41,NULL,NULL),(38,'LINE','Carreteras (Autovía Secundaria) 2','GEOM',23,NULL,NULL,NULL,NULL,NULL,41,NULL,NULL),(39,'LINE','Carreteras (Carretera RIGE)','GEOM',24,NULL,NULL,NULL,NULL,NULL,42,NULL,NULL),(40,'LINE','Carreteras (Carretera Red Básica)','GEOM',25,NULL,NULL,NULL,NULL,NULL,43,NULL,NULL),(41,'LINE','Carreteras (Carretera Secundaria)','GEOM',27,NULL,NULL,NULL,NULL,NULL,45,NULL,NULL),(42,'LINE','Carreteras (Carretera Intercomarcal)','GEOM',26,NULL,NULL,NULL,NULL,NULL,44,NULL,NULL),(43,'TEXT','Etiquetas Carreteras','GEOM',NULL,22,NULL,1,2,1,46,NULL,NULL),(44,'POLYGON','Instalaciones Acuíferas Autorizadas','GEOM',28,23,NULL,NULL,NULL,NULL,47,NULL,NULL),(45,'POLYGON','Instalaciones Acuíferas Caducadas','GEOM',28,24,NULL,NULL,NULL,NULL,48,NULL,NULL),(46,'POLYGON','Instalaciones Acuíferas en Trámite','GEOM',28,25,NULL,NULL,NULL,NULL,49,NULL,NULL),(47,'TEXT','Etiquetas Instalaciones Acuíferas','GEOM',NULL,26,NULL,1,1,1,50,'-',NULL),(48,'POLYGON','Puertos','GEOM',NULL,27,NULL,NULL,NULL,NULL,51,NULL,NULL),(49,'TEXT','Etiquetas Puertos','GEOM',NULL,28,NULL,1,1,1,52,NULL,NULL),(50,'POLYGON','Zonas de Especial Protección Medioambiental','GEOM',29,NULL,NULL,NULL,NULL,NULL,53,NULL,NULL),(52,'POLYGON','Embalses','GEOM',NULL,29,NULL,NULL,NULL,NULL,55,NULL,NULL),(51,'LINE','Caminos (Acuicultura)','GEOM',30,NULL,NULL,NULL,NULL,NULL,54,NULL,NULL),(53,'TEXT','Etiquetas Embalses','GEOM',NULL,30,NULL,1,2,1,56,NULL,NULL),(54,'POLYGON','Almadrabas','GEOM',31,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(55,'TEXT','Etiquetas Almadrabas','GEOM',NULL,31,NULL,1,1,1,58,NULL,NULL),(56,'LINE','Batimetría','GEOM',32,NULL,NULL,NULL,NULL,NULL,59,NULL,NULL),(57,'TEXT','Etiquetas Batimetría','GEOM',NULL,32,NULL,1,1,1,60,NULL,NULL),(58,'POINT','Puntos de Interés Cultural','GEOM',NULL,NULL,1,NULL,NULL,NULL,61,NULL,NULL),(59,'POINT','Puntos de Vertidos','GEOM',NULL,NULL,2,NULL,NULL,NULL,62,NULL,NULL),(60,'LINE','Cables Submarinos','GEOM',34,NULL,NULL,NULL,NULL,NULL,63,NULL,NULL),(61,'LINE','Emisarios Submarinos','GEOM',35,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL),(63,'POLYGON','Pot (Equipamientos)','GEOM',35,34,NULL,NULL,NULL,NULL,65,NULL,NULL),(64,'POLYGON','Pot (Espacios Libres)','GEOM',36,35,NULL,NULL,NULL,NULL,66,NULL,NULL),(65,'POLYGON','Pot (Limitaciones Específicas)','GEOM',37,36,NULL,NULL,NULL,NULL,67,NULL,NULL),(66,'POLYGON','Pot (Limitaciones Generales)','GEOM',38,37,NULL,NULL,NULL,NULL,68,NULL,NULL),(77,'POLYGON','Topónimos (Geometría)','GEOM',NULL,47,NULL,NULL,NULL,NULL,78,NULL,NULL),(67,'POLYGON','Areas Arqueológicas','GEOM',39,39,NULL,NULL,NULL,NULL,69,NULL,NULL),(68,'POLYGON','Arrecifes (En ejecución)','GEOM',40,38,NULL,NULL,NULL,NULL,70,NULL,NULL),(69,'POLYGON','Arrecifes (En proyecto)','GEOM',41,39,NULL,NULL,NULL,NULL,71,NULL,NULL),(70,'POLYGON','Arrecifes (Instalado)','GEOM',42,40,NULL,NULL,NULL,NULL,72,NULL,NULL),(71,'POLYGON','Salinas','GEOM',43,41,NULL,NULL,NULL,NULL,73,NULL,NULL),(72,'TEXT','Etiquetas Salinas','GEOM',NULL,42,NULL,1,1,1,74,NULL,NULL),(73,'POLYGON','Hábitats de Interés','GEOM',44,43,NULL,NULL,NULL,NULL,75,NULL,NULL),(74,'POLYGON','Propuesta Lugares de Interés Comunitario','GEOM',45,44,NULL,NULL,NULL,NULL,76,NULL,NULL),(75,'TEXT','Etiquetas Propuesta Lugares de Interés Comunitario','GEOM',NULL,46,NULL,1,1,1,77,'-',NULL),(78,'POLYGON','Etiqueta Hidrografía  (Geometría)','GEOM',NULL,48,NULL,NULL,NULL,NULL,79,NULL,NULL),(3,'POLYGON','Recintos SigPac','GEOM',5,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL),(6,'TEXT','Etiquetas Recintos SigPac','GEOM',NULL,10,NULL,2,1,1,2,'-',NULL),(79,'POLYGON','Polígonos SigPac','GEOM',6,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL),(80,'TEXT','Etiquetas Polígonos SigPac','GEOM',NULL,11,NULL,1,1,1,7,NULL,NULL),(81,'POLYGON','Extracción de Áridos','GEOM',46,49,NULL,NULL,NULL,NULL,80,NULL,NULL),(82,'LINE','Abastecimiento 1','GEOM',47,NULL,NULL,NULL,NULL,NULL,81,NULL,NULL),(83,'LINE','Abastecimiento 2','GEOM',48,NULL,NULL,NULL,NULL,NULL,82,NULL,NULL),(84,'POLYGON','Playas 1','GEOM',49,50,NULL,NULL,NULL,NULL,83,NULL,NULL),(85,'TEXT','Playas 1 text','GEOM',NULL,51,NULL,1,1,1,84,'-',NULL),(86,'POLYGON','Z. Industriales','GEOM',50,52,NULL,NULL,NULL,NULL,85,NULL,NULL),(87,'POLYGON','Zonas Portuarias 1','GEOM',51,53,NULL,NULL,NULL,NULL,86,NULL,NULL),(88,'POLYGON','Zonas Portuarias 2','GEOM',52,54,NULL,NULL,NULL,NULL,87,NULL,NULL),(89,'POLYGON','Zonas Portuarias 3','GEOM',53,55,NULL,NULL,NULL,NULL,88,NULL,NULL),(90,'POLYGON','Zonas Portuarias 1b','GEOM',51,56,NULL,NULL,NULL,NULL,0,NULL,NULL),(91,'POLYGON','Zonas Militares 1','GEOM',54,57,NULL,NULL,NULL,NULL,89,NULL,NULL),(92,'POLYGON','Zonas Militares 2','GEOM',68,58,NULL,NULL,NULL,NULL,90,NULL,NULL),(93,'LINE','Conductos 1','GEOM',55,NULL,NULL,NULL,NULL,NULL,91,NULL,NULL),(94,'LINE','Conductos 2','GEOM',56,NULL,NULL,NULL,NULL,NULL,92,NULL,NULL),(95,'LINE','Conductos 3','GEOM',57,NULL,NULL,NULL,NULL,NULL,93,NULL,NULL),(96,'LINE','Conductos 4','GEOM',58,NULL,NULL,NULL,NULL,NULL,94,NULL,NULL),(97,'LINE','Conductos 5','GEOM',59,NULL,NULL,NULL,NULL,NULL,95,NULL,NULL),(98,'LINE','Ferrocarril 1','GEOM',60,NULL,NULL,NULL,NULL,NULL,96,NULL,NULL),(99,'LINE','Ferrocarril 2','GEOM',61,NULL,NULL,NULL,NULL,NULL,97,NULL,NULL),(100,'LINE','Ferrocarril 3','GEOM',62,NULL,NULL,NULL,NULL,NULL,98,NULL,NULL),(101,'LINE','Ferrocarril 4','GEOM',63,NULL,NULL,NULL,NULL,NULL,99,NULL,NULL),(102,'LINE','Ferrocarril 5','GEOM',64,NULL,NULL,NULL,NULL,NULL,100,NULL,NULL),(103,'POINT','Acuiferos','GEOM',NULL,NULL,5,NULL,NULL,NULL,101,NULL,NULL),(104,'POLYGON','eennpp','GEOM',66,60,NULL,NULL,NULL,NULL,102,NULL,NULL),(105,'TEXT','eennpp text','GEOM',NULL,61,NULL,3,1,1,103,NULL,NULL),(106,'POLYGON','Superficies de Aguas','GEOM',67,68,NULL,NULL,NULL,NULL,104,NULL,NULL),(107,'POINT','Edificacion Rural','GEOM',NULL,NULL,6,NULL,NULL,NULL,105,NULL,NULL),(108,'POLYGON','Areas de Riego','GEOM',69,NULL,NULL,NULL,NULL,NULL,106,NULL,NULL),(110,'POLYGON','Cuencas Hidrograficas','GEOM',70,NULL,NULL,NULL,NULL,NULL,107,NULL,NULL),(111,'TEXT','Cuencas Hidrografica Text','GEOM',NULL,69,NULL,1,1,1,107,NULL,NULL),(112,'POLYGON','Sistemas de Explotación','GEOM',71,NULL,NULL,NULL,NULL,NULL,108,NULL,NULL),(113,'POLYGON','Zonas de Riego Default','GEOM',21,70,NULL,NULL,NULL,NULL,109,NULL,NULL),(114,'POLYGON','Areas de Riego 1.0','GEOM',21,71,NULL,NULL,NULL,NULL,110,NULL,NULL),(115,'POLYGON','Areas de Riego 1.1','GEOM',21,72,NULL,NULL,NULL,NULL,111,NULL,NULL),(116,'POLYGON','Areas de Riego 1.2','GEOM',21,73,NULL,NULL,NULL,NULL,112,NULL,NULL),(117,'POLYGON','Areas de Riego 1.3','GEOM',21,74,NULL,NULL,NULL,NULL,113,NULL,NULL),(118,'POLYGON','Areas de Riego 1.4','GEOM',21,75,NULL,NULL,NULL,NULL,114,NULL,NULL),(119,'POLYGON','Areas de Riego 1.5','GEOM',21,76,NULL,NULL,NULL,NULL,115,NULL,NULL),(120,'POLYGON','Areas de Riego 2.0','GEOM',21,71,NULL,NULL,NULL,NULL,116,NULL,NULL),(121,'POLYGON','Areas de Riego 2.1','GEOM',21,72,NULL,NULL,NULL,NULL,117,NULL,NULL),(122,'POLYGON','Areas de Riego 2.2','GEOM',21,73,NULL,NULL,NULL,NULL,118,NULL,NULL),(123,'POLYGON','Areas de Riego 2.3','GEOM',21,74,NULL,NULL,NULL,NULL,119,NULL,NULL),(124,'POLYGON','Areas de Riego 2.4','GEOM',21,75,NULL,NULL,NULL,NULL,120,NULL,NULL),(125,'POLYGON','Areas de Riego 2.5','GEOM',21,76,NULL,NULL,NULL,NULL,121,NULL,NULL),(126,'POLYGON','Areas de Riego 3.0','GEOM',21,72,NULL,NULL,NULL,NULL,122,NULL,NULL),(127,'POLYGON','Areas de Riego 3.1','GEOM',21,73,NULL,NULL,NULL,NULL,123,NULL,NULL),(128,'POLYGON','Areas de Riego 3.2','GEOM',21,74,NULL,NULL,NULL,NULL,124,NULL,NULL),(129,'POLYGON','Areas de Riego 3.3','GEOM',21,75,NULL,NULL,NULL,NULL,125,NULL,NULL),(130,'POLYGON','Areas de Riego 3.4','GEOM',21,76,NULL,NULL,NULL,NULL,126,NULL,NULL),(131,'POLYGON','Areas de Riego 3.5','GEOM',21,76,NULL,NULL,NULL,NULL,127,NULL,NULL),(132,'POLYGON','Areas de Riego 4.1','GEOM',21,77,NULL,NULL,NULL,NULL,128,NULL,NULL),(133,'POLYGON','Areas de Riego 4.2','GEOM',21,71,NULL,NULL,NULL,NULL,129,NULL,NULL),(134,'POLYGON','Areas de Riego 4.3','GEOM',21,78,NULL,NULL,NULL,NULL,130,NULL,NULL),(135,'POLYGON','Areas de Riego 4.4','GEOM',21,79,NULL,NULL,NULL,NULL,131,NULL,NULL),(136,'POLYGON','Areas de Riego 4.5','GEOM',21,73,NULL,NULL,NULL,NULL,132,NULL,NULL),(137,'POLYGON','Areas de Riego 4.6','GEOM',21,80,NULL,NULL,NULL,NULL,410,NULL,NULL),(138,'POLYGON','Areas de Riego 4.7','GEOM',21,81,NULL,NULL,NULL,NULL,133,NULL,NULL),(139,'POLYGON','Areas de Riego 4.8','GEOM',21,82,NULL,NULL,NULL,NULL,134,NULL,NULL),(140,'POLYGON','Areas de Riego 4.9','GEOM',21,83,NULL,NULL,NULL,NULL,135,NULL,NULL),(141,'POLYGON','Areas de Riego 4.10','GEOM',21,84,NULL,NULL,NULL,NULL,136,NULL,NULL),(142,'POLYGON','Areas de Riego 4.11','GEOM',21,76,NULL,NULL,NULL,NULL,137,NULL,NULL),(143,'POLYGON','Areas de Riego 4.12','GEOM',21,72,NULL,NULL,NULL,NULL,138,NULL,NULL),(144,'POLYGON','Areas de Riego 5.1','GEOM',21,71,NULL,NULL,NULL,NULL,139,NULL,NULL),(145,'POLYGON','Areas de Riego 5.2','GEOM',21,72,NULL,NULL,NULL,NULL,140,NULL,NULL),(146,'POLYGON','Areas de Riego 5.3','GEOM',21,73,NULL,NULL,NULL,NULL,141,NULL,NULL),(147,'POLYGON','Areas de Riego 5.4','GEOM',21,74,NULL,NULL,NULL,NULL,142,NULL,NULL),(148,'POLYGON','Areas de Riego 5.5','GEOM',21,76,NULL,NULL,NULL,NULL,143,NULL,NULL),(149,'POLYGON','Areas de Riego 7.1','GEOM',21,86,NULL,NULL,NULL,NULL,144,NULL,NULL),(150,'POLYGON','Areas de Riego 7.2','GEOM',21,85,NULL,NULL,NULL,NULL,145,NULL,NULL),(151,'POLYGON','Areas de Riego 9.0','GEOM',21,71,NULL,NULL,NULL,NULL,151,NULL,NULL),(152,'POLYGON','Areas de Riego 9.1','GEOM',21,72,NULL,NULL,NULL,NULL,152,NULL,NULL),(153,'POLYGON','Areas de Riego 9.2','GEOM',21,73,NULL,NULL,NULL,NULL,153,NULL,NULL),(154,'POLYGON','Areas de Riego 9.3','GEOM',21,74,NULL,NULL,NULL,NULL,154,NULL,NULL),(155,'POLYGON','Areas de Riego 9.4','GEOM',21,84,NULL,NULL,NULL,NULL,155,NULL,NULL),(156,'POLYGON','Areas de Riego 9.5','GEOM',21,76,NULL,NULL,NULL,NULL,156,NULL,NULL),(157,'POLYGON','Areas de Riego 8.1','GEOM',21,71,NULL,NULL,NULL,NULL,146,NULL,NULL),(158,'POLYGON','Areas de Riego 8.2','GEOM',21,72,NULL,NULL,NULL,NULL,147,NULL,NULL),(159,'POLYGON','Areas de Riego 8.3','GEOM',21,73,NULL,NULL,NULL,NULL,148,NULL,NULL),(160,'POLYGON','Areas de Riego 8.4','GEOM',21,74,NULL,NULL,NULL,NULL,149,NULL,NULL),(161,'POLYGON','Areas de Riego 8.5','GEOM',21,76,NULL,NULL,NULL,NULL,150,NULL,NULL),(162,'POLYGON','Areas de Riego 10.1','GEOM',21,71,NULL,NULL,NULL,NULL,157,NULL,NULL),(163,'POLYGON','Areas de Riego 10.2','GEOM',21,72,NULL,NULL,NULL,NULL,158,NULL,NULL),(164,'POLYGON','Areas de Riego 10.3','GEOM',21,73,NULL,NULL,NULL,NULL,159,NULL,NULL),(165,'POLYGON','Areas de Riego 10.4','GEOM',21,74,NULL,NULL,NULL,NULL,160,NULL,NULL),(166,'POLYGON','Areas de Riego 10.5','GEOM',21,76,NULL,NULL,NULL,NULL,161,NULL,NULL),(167,'POLYGON','Areas de Riego 11.1','GEOM',21,71,NULL,NULL,NULL,NULL,162,NULL,NULL),(168,'POLYGON','Areas de Riego 11.2','GEOM',21,72,NULL,NULL,NULL,NULL,163,NULL,NULL),(169,'POLYGON','Areas de Riego 11.3','GEOM',21,73,NULL,NULL,NULL,NULL,164,NULL,NULL),(170,'POLYGON','Areas de Riego 11.4','GEOM',21,74,NULL,NULL,NULL,NULL,165,NULL,NULL),(171,'POLYGON','Areas de Riego 11.5','GEOM',21,84,NULL,NULL,NULL,NULL,166,NULL,NULL),(172,'POLYGON','Areas de Riego 11.6','GEOM',21,76,NULL,NULL,NULL,NULL,167,NULL,NULL),(173,'POLYGON','Areas de Riego 12.1','GEOM',21,71,NULL,NULL,NULL,NULL,168,NULL,NULL),(174,'POLYGON','Areas de Riego 12.2','GEOM',21,72,NULL,NULL,NULL,NULL,169,NULL,NULL),(175,'POLYGON','Areas de Riego 12.3','GEOM',21,73,NULL,NULL,NULL,NULL,170,NULL,NULL),(176,'POLYGON','Areas de Riego 12.4','GEOM',21,74,NULL,NULL,NULL,NULL,171,NULL,NULL),(177,'POLYGON','Areas de Riego 12.5','GEOM',21,84,NULL,NULL,NULL,NULL,172,NULL,NULL),(178,'POLYGON','Areas de Riego 12.6','GEOM',21,76,NULL,NULL,NULL,NULL,173,NULL,NULL),(179,'POLYGON','Areas de Riego 13.1','GEOM',21,72,NULL,NULL,NULL,NULL,174,NULL,NULL),(180,'POLYGON','Areas de Riego 13.2','GEOM',21,73,NULL,NULL,NULL,NULL,175,NULL,NULL),(181,'POLYGON','Areas de Riego 13.3','GEOM',21,74,NULL,NULL,NULL,NULL,176,NULL,NULL),(182,'POLYGON','Areas de Riego 13.4','GEOM',21,75,NULL,NULL,NULL,NULL,177,NULL,NULL),(183,'POLYGON','Areas de Riego 13.5','GEOM',21,76,NULL,NULL,NULL,NULL,178,NULL,NULL),(184,'POLYGON','Areas de Riego 13.6','GEOM',21,77,NULL,NULL,NULL,NULL,179,NULL,NULL),(185,'POLYGON','Areas de Riego 15.1','GEOM',21,71,NULL,NULL,NULL,NULL,185,NULL,NULL),(186,'POLYGON','Areas de Riego 15.2','GEOM',21,73,NULL,NULL,NULL,NULL,186,NULL,NULL),(187,'POLYGON','Areas de Riego 15.3','GEOM',21,76,NULL,NULL,NULL,NULL,187,NULL,NULL),(188,'POLYGON','Areas de Riego 15.4','GEOM',21,87,NULL,NULL,NULL,NULL,188,NULL,NULL),(189,'POLYGON','Areas de Riego 15.5','GEOM',21,79,NULL,NULL,NULL,NULL,189,NULL,NULL),(190,'POLYGON','Areas de Riego 15.6','GEOM',21,80,NULL,NULL,NULL,NULL,190,NULL,NULL),(191,'POLYGON','Areas de Riego 14.1','GEOM',21,71,NULL,NULL,NULL,NULL,180,NULL,NULL),(192,'POLYGON','Areas de Riego 14.2','GEOM',21,72,NULL,NULL,NULL,NULL,181,NULL,NULL),(193,'POLYGON','Areas de Riego 14.3','GEOM',21,73,NULL,NULL,NULL,NULL,182,NULL,NULL),(194,'POLYGON','Areas de Riego 14.4','GEOM',21,74,NULL,NULL,NULL,NULL,183,NULL,NULL),(195,'POLYGON','Areas de Riego 14.5','GEOM',21,76,NULL,NULL,NULL,NULL,184,NULL,NULL),(196,'POLYGON','Areas de Riego 16.1','GEOM',21,72,NULL,NULL,NULL,NULL,191,NULL,NULL),(197,'POLYGON','Areas de Riego 16.2','GEOM',21,73,NULL,NULL,NULL,NULL,192,NULL,NULL),(198,'POLYGON','Areas de Riego 16.3','GEOM',21,74,NULL,NULL,NULL,NULL,193,NULL,NULL),(199,'POLYGON','Areas de Riego 16.4','GEOM',21,75,NULL,NULL,NULL,NULL,194,NULL,NULL),(200,'POLYGON','Areas de Riego 16.5','GEOM',21,76,NULL,NULL,NULL,NULL,195,NULL,NULL),(201,'POLYGON','Areas de Riego 16.6','GEOM',21,77,NULL,NULL,NULL,NULL,196,NULL,NULL),(202,'POLYGON','Areas de Riego 17.1','GEOM',21,71,NULL,NULL,NULL,NULL,197,NULL,NULL),(203,'POLYGON','Areas de Riego 17.2','GEOM',21,88,NULL,NULL,NULL,NULL,198,NULL,NULL),(204,'POLYGON','Areas de Riego 17.3','GEOM',21,89,NULL,NULL,NULL,NULL,199,NULL,NULL),(205,'POLYGON','Areas de Riego 17.4','GEOM',21,90,NULL,NULL,NULL,NULL,200,NULL,NULL),(206,'POLYGON','Areas de Riego 17.5','GEOM',21,91,NULL,NULL,NULL,NULL,201,NULL,NULL),(207,'POLYGON','Areas de Riego 17.6','GEOM',21,92,NULL,NULL,NULL,NULL,202,NULL,NULL),(208,'POLYGON','Areas de Riego 19.1','GEOM',21,72,NULL,NULL,NULL,NULL,209,NULL,NULL),(209,'POLYGON','Areas de Riego 19.2','GEOM',21,73,NULL,NULL,NULL,NULL,210,NULL,NULL),(210,'POLYGON','Areas de Riego 19.3','GEOM',21,74,NULL,NULL,NULL,NULL,211,NULL,NULL),(211,'POLYGON','Areas de Riego 19.4','GEOM',21,75,NULL,NULL,NULL,NULL,212,NULL,NULL),(212,'POLYGON','Areas de Riego 19.5','GEOM',21,76,NULL,NULL,NULL,NULL,213,NULL,NULL),(213,'POLYGON','Areas de Riego 19.6','GEOM',21,77,NULL,NULL,NULL,NULL,214,NULL,NULL),(214,'POLYGON','Areas de Riego 18.1','GEOM',21,71,NULL,NULL,NULL,NULL,203,NULL,NULL),(215,'POLYGON','Areas de Riego 18.2','GEOM',21,88,NULL,NULL,NULL,NULL,204,NULL,NULL),(216,'POLYGON','Areas de Riego 18.3','GEOM',21,89,NULL,NULL,NULL,NULL,205,NULL,NULL),(217,'POLYGON','Areas de Riego 18.4','GEOM',21,90,NULL,NULL,NULL,NULL,206,NULL,NULL),(218,'POLYGON','Areas de Riego 18.5','GEOM',21,91,NULL,NULL,NULL,NULL,207,NULL,NULL),(219,'POLYGON','Areas de Riego 18.6','GEOM',21,92,NULL,NULL,NULL,NULL,208,NULL,NULL),(220,'POLYGON','Areas de Riego 20.1','GEOM',21,71,NULL,NULL,NULL,NULL,215,NULL,NULL),(221,'POLYGON','Areas de Riego 20.2','GEOM',21,72,NULL,NULL,NULL,NULL,216,NULL,NULL),(222,'POLYGON','Areas de Riego 20.3','GEOM',21,73,NULL,NULL,NULL,NULL,217,NULL,NULL),(223,'POLYGON','Areas de Riego 20.4','GEOM',21,74,NULL,NULL,NULL,NULL,218,NULL,NULL),(224,'POLYGON','Areas de Riego 20.5','GEOM',21,84,NULL,NULL,NULL,NULL,219,NULL,NULL),(225,'POLYGON','Areas de Riego 20.6','GEOM',21,76,NULL,NULL,NULL,NULL,220,NULL,NULL),(226,'POLYGON','Areas de Riego 21.1','GEOM',21,71,NULL,NULL,NULL,NULL,221,NULL,NULL),(227,'POLYGON','Areas de Riego 21.2','GEOM',21,80,NULL,NULL,NULL,NULL,222,NULL,NULL),(228,'POLYGON','Areas de Riego 21.3','GEOM',21,72,NULL,NULL,NULL,NULL,223,NULL,NULL),(229,'POLYGON','Areas de Riego 21.4','GEOM',21,81,NULL,NULL,NULL,NULL,224,NULL,NULL),(230,'POLYGON','Areas de Riego 21.5','GEOM',21,82,NULL,NULL,NULL,NULL,225,NULL,NULL),(231,'POLYGON','Areas de Riego 21.6','GEOM',21,73,NULL,NULL,NULL,NULL,226,NULL,NULL),(232,'POLYGON','Areas de Riego 21.7','GEOM',21,93,NULL,NULL,NULL,NULL,227,NULL,NULL),(233,'POLYGON','Areas de Riego 21.8','GEOM',21,86,NULL,NULL,NULL,NULL,228,NULL,NULL),(234,'POLYGON','Areas de Riego 21.9','GEOM',21,11,NULL,NULL,NULL,NULL,229,NULL,NULL),(235,'POLYGON','Areas de Riego 22.1','GEOM',21,71,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(236,'POLYGON','Areas de Riego 22.2','GEOM',21,72,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(237,'POLYGON','Areas de Riego 22.3','GEOM',21,73,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,'POLYGON','Areas de Riego 22.4','GEOM',21,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,'POLYGON','Areas de Riego 22.5','GEOM',21,94,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,'POLYGON','Areas de Riego 22.6','GEOM',21,76,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(243,'POINT','Olivos tipo S','GEOM',NULL,NULL,9,NULL,NULL,NULL,239,NULL,NULL),(244,'POINT','Olivos tipo A','GEOM',NULL,NULL,10,NULL,NULL,NULL,240,NULL,NULL),(245,'LINE','Localizador Recintos SIGPAC','GEOM',74,NULL,NULL,NULL,NULL,NULL,241,NULL,NULL),(246,'LINE','Localizador Recintos SIGO','GEOM',75,NULL,NULL,NULL,NULL,NULL,242,NULL,NULL),(247,'POINT','Loc Olivos Tipo N','GEOM',NULL,NULL,8,NULL,NULL,NULL,243,NULL,NULL),(248,'POINT','Loc Olivar Tipo S','GEOM',NULL,NULL,9,NULL,NULL,NULL,244,NULL,NULL),(249,'POINT','Loc Olivar Tipo A','GEOM',NULL,NULL,10,NULL,NULL,NULL,245,NULL,NULL),(250,'POLYGON','Parcela de Forestación','GEOM',78,NULL,NULL,NULL,NULL,NULL,246,NULL,NULL),(263,'POINT','Ganaderia (Ovino)','GEOM',NULL,NULL,215,NULL,NULL,NULL,258,NULL,NULL),(262,'POINT','Ganaderia (Porcino)','GEOM',NULL,NULL,219,NULL,NULL,NULL,262,NULL,NULL),(264,'POINT','Ganaderia (Caprino)','GEOM',NULL,NULL,216,NULL,NULL,NULL,259,NULL,NULL),(266,'POINT','Ganaderia (Multiple)','GEOM',NULL,NULL,218,NULL,NULL,NULL,261,NULL,NULL),(267,'POINT','Ganaderia (NoSIGGAN)','GEOM',NULL,NULL,220,NULL,NULL,NULL,263,NULL,NULL),(265,'POINT','Ganaderia (Bovino)','GEOM',NULL,NULL,214,NULL,NULL,NULL,257,NULL,NULL),(261,'POINT','Ganaderia (Otras)','GEOM',NULL,NULL,217,NULL,NULL,NULL,260,NULL,NULL),(258,'POLYGON','Localizador Parcelas SIGPAC','GEOM',80,NULL,NULL,NULL,NULL,NULL,254,NULL,NULL),(259,'POLYGON','Inserción en mapa','GEOM',81,NULL,NULL,NULL,NULL,NULL,255,NULL,NULL),(260,'POLYGON','Localizador Parcelas SIGPAC Forestacion','GEOM',80,NULL,NULL,NULL,NULL,NULL,256,NULL,NULL),(268,'POLYGON','Localizador Genérico','GEOM',82,NULL,NULL,NULL,NULL,NULL,264,NULL,NULL),(270,'POINT','Ganaderia (Otras)','GEOM',NULL,NULL,217,NULL,NULL,NULL,268,NULL,NULL),(271,'POINT','Ganaderia (Porcino)','GEOM',NULL,NULL,219,NULL,NULL,NULL,266,NULL,NULL),(273,'POINT','Ganaderia (Ovino)','GEOM',NULL,NULL,215,NULL,NULL,NULL,270,NULL,NULL),(272,'POINT','Ganaderia (Caprino)','GEOM',NULL,NULL,216,NULL,NULL,NULL,269,NULL,NULL),(274,'POINT','Ganaderia (Bovino)','GEOM',NULL,NULL,214,NULL,NULL,NULL,271,NULL,NULL),(275,'POINT','Ganaderia (Multiple)','GEOM',NULL,NULL,218,NULL,NULL,NULL,267,NULL,'L_CAPRINO==1'),(269,'POINT','Ganaderia (NoSIGGAN)','GEOM',NULL,NULL,220,NULL,NULL,NULL,265,NULL,NULL),(284,'POLYGON','Ganaderia (Proteccion)','GEOM',83,NULL,NULL,NULL,NULL,NULL,272,NULL,NULL),(285,'POLYGON','Ganaderia (Vigilancia)','GEOM',84,NULL,NULL,NULL,NULL,NULL,273,NULL,NULL),(290,'POINT','Ganaderia (Seleccion)','GEOM',NULL,108,223,NULL,NULL,NULL,276,NULL,NULL),(287,'TEXT','Ganaderia (Localizador)','GEOM',21,106,222,1,2,3,275,NULL,NULL),(289,'TEXT','Ganaderia (Riesgo)','GEOM',NULL,105,NULL,1,2,3,274,NULL,NULL),(291,'POLYGON','Zonas de restricción de herbicidas','GEOM',86,109,NULL,NULL,NULL,NULL,277,NULL,NULL),(1126,'POINT','OTRA ESPECIE','GEOM',NULL,NULL,1126,NULL,NULL,NULL,1120,NULL,'ESPECIE==7'),(1125,'POINT','OLIVO NO SIGO','GEOM',NULL,NULL,1125,NULL,NULL,NULL,1120,NULL,'ESPECIE==6'),(1124,'POINT','PISTACHO','GEOM',NULL,NULL,1124,NULL,NULL,NULL,1120,NULL,'ESPECIE==5'),(1123,'POINT','NOGAL','GEOM',NULL,NULL,1123,NULL,NULL,NULL,1120,NULL,'ESPECIE==4'),(1122,'POINT','AVELLANO','GEOM',NULL,NULL,1122,NULL,NULL,NULL,1120,NULL,'ESPECIE==3'),(1121,'POINT','ALGARROBO','GEOM',NULL,NULL,1121,NULL,NULL,NULL,1120,NULL,'ESPECIE==2'),(1120,'POINT','ALMENDRO','GEOM',NULL,NULL,1120,NULL,NULL,NULL,1120,NULL,'ESPECIE==1'),(13001,'POLYGON','ParcelaCroquis','GEOM',13001,13001,NULL,NULL,NULL,NULL,13001,NULL,NULL),(13002,'TEXT','olivarCropacAux','GEOM',NULL,13001,NULL,1,13001,1,13002,NULL,NULL),(13003,'POINT','OLIVAR_N','GEOM',NULL,NULL,13003,NULL,NULL,NULL,13003,NULL,NULL),(13004,'POINT','Olivos tipo A','GEOM',NULL,NULL,13004,NULL,NULL,NULL,13004,NULL,NULL),(13005,'POINT','Olivos tipo S','GEOM',NULL,NULL,13005,NULL,NULL,NULL,13005,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `symbolizers` ENABLE KEYS */;

--
-- Table structure for table `usuario_gis_aplicacion`
--

DROP TABLE IF EXISTS `usuario_gis_aplicacion`;
CREATE TABLE `usuario_gis_aplicacion` (
  `C_USUARIO_APLICACION` bigint(20) NOT NULL auto_increment,
  `L_USUARIO_POR_DEFECTO` tinyint(1) NOT NULL default '0',
  `C_USUARIO` bigint(20) NOT NULL default '0',
  `C_APLICACION` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_USUARIO_APLICACION`),
  KEY `C_APLICACION` (`C_APLICACION`),
  KEY `C_USUARIO` (`C_USUARIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuario_gis_aplicacion`
--


/*!40000 ALTER TABLE `usuario_gis_aplicacion` DISABLE KEYS */;
LOCK TABLES `usuario_gis_aplicacion` WRITE;
INSERT INTO `usuario_gis_aplicacion` VALUES (2,0,5,1),(5,1,1,1),(13001,1,13001,13);
UNLOCK TABLES;
/*!40000 ALTER TABLE `usuario_gis_aplicacion` ENABLE KEYS */;

--
-- Table structure for table `usuarios_gis`
--

DROP TABLE IF EXISTS `usuarios_gis`;
CREATE TABLE `usuarios_gis` (
  `C_USUARIO` bigint(20) NOT NULL auto_increment,
  `T_LOGIN` varchar(255) NOT NULL default '',
  `T_PASSWORD` varchar(255) default NULL,
  `T_EMAIL` varchar(255) default NULL,
  `T_NOMBRE` varchar(255) default NULL,
  `T_APELLIDO_1` varchar(255) default NULL,
  `T_APELLIDO_2` varchar(255) default NULL,
  `L_ADMISTRADOR` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`C_USUARIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios_gis`
--


/*!40000 ALTER TABLE `usuarios_gis` DISABLE KEYS */;
LOCK TABLES `usuarios_gis` WRITE;
INSERT INTO `usuarios_gis` VALUES (1,'generico','generico','','user_generico','','',0),(5,'userVisorSIGPAC','userVisorSIGPAC','','userVisorSIGPAC','','',0),(13001,'userCropac','userCropac',NULL,'userCropac',NULL,NULL,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `usuarios_gis` ENABLE KEYS */;

--
-- Table structure for table `usuarios_layers`
--

DROP TABLE IF EXISTS `usuarios_layers`;
CREATE TABLE `usuarios_layers` (
  `C_USUARIO_LAYER` bigint(20) NOT NULL auto_increment,
  `L_ES_ACTIVA` tinyint(1) NOT NULL default '0',
  `L_ES_VISIBLE` tinyint(1) NOT NULL default '0',
  `C_USUARIO` bigint(20) NOT NULL default '0',
  `C_LAYER` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`C_USUARIO_LAYER`),
  KEY `C_LAYER` (`C_LAYER`),
  KEY `C_USUARIO` (`C_USUARIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios_layers`
--


/*!40000 ALTER TABLE `usuarios_layers` DISABLE KEYS */;
LOCK TABLES `usuarios_layers` WRITE;
INSERT INTO `usuarios_layers` VALUES (678,0,0,1,66),(625,0,1,1,11),(689,0,0,1,73),(626,0,1,1,13),(627,0,1,1,15),(628,0,1,1,16),(629,0,1,1,23),(630,0,1,1,22),(631,0,1,1,21),(632,0,1,1,24),(633,0,0,1,25),(634,0,1,1,27),(635,0,0,1,28),(636,0,1,1,31),(637,0,0,1,58),(638,0,1,1,64),(639,0,1,1,30),(640,0,0,1,33),(641,0,0,1,35),(624,0,1,1,10),(623,0,1,1,9),(622,0,1,1,26),(621,1,1,1,6),(620,0,1,1,4),(619,0,1,1,3),(618,0,1,1,2),(672,0,1,1,72),(671,0,1,1,71),(670,0,0,1,70),(669,0,0,1,1069),(665,0,0,1,61),(666,0,0,1,62),(617,1,1,1,1),(642,0,0,1,36),(643,0,0,1,37),(644,0,0,1,38),(645,0,0,1,39),(646,0,0,1,40),(647,0,0,1,41),(648,0,0,1,42),(649,0,0,1,43),(650,0,0,1,44),(651,0,0,1,45),(652,0,0,1,46),(653,0,0,1,47),(654,0,1,1,65),(655,0,0,1,49),(668,1,1,1,1068),(656,0,0,1,50),(657,0,0,1,51),(658,0,0,1,52),(659,0,0,1,53),(660,0,0,1,54),(661,0,0,1,56),(662,0,0,1,57),(667,1,1,1,1067),(663,0,0,1,63),(664,0,0,1,60),(716,1,1,5,1),(717,0,0,5,2),(718,0,0,5,3),(719,1,1,5,4),(720,1,1,5,6),(721,0,0,5,9),(722,0,0,5,10),(723,0,0,5,11),(724,0,0,5,13),(725,0,0,5,15),(726,0,0,5,16),(727,0,0,5,21),(728,0,0,5,22),(729,0,0,5,23),(730,0,0,5,24),(731,0,0,5,25),(732,0,0,5,26),(733,0,0,5,27),(734,0,0,5,28),(735,0,0,5,64),(736,0,0,5,65),(737,1,1,5,1067),(738,1,1,5,1068),(739,1,1,5,1076),(765,0,0,1,90),(785,0,0,1,99),(1121,0,0,5,74),(1120,1,1,5,1120),(13001,1,1,13001,1),(13002,1,1,13001,2),(13003,1,1,13001,6),(13004,1,1,13001,1067),(13005,1,1,13001,1068),(13006,0,0,13001,1076),(13007,1,1,13001,1120),(13008,1,1,13001,13001),(13009,1,1,13001,13002),(13010,0,0,13001,74),(13015,1,1,13001,13003),(13016,1,1,13001,13004),(13017,1,1,13001,13005);
UNLOCK TABLES;
/*!40000 ALTER TABLE `usuarios_layers` ENABLE KEYS */;

--
-- Table structure for table `usuarios_modulos`
--

DROP TABLE IF EXISTS `usuarios_modulos`;
CREATE TABLE `usuarios_modulos` (
  `MODULO_ID` bigint(20) NOT NULL default '0',
  `USUARIO_ID` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`USUARIO_ID`,`MODULO_ID`),
  KEY `USUARIO_ID` (`USUARIO_ID`),
  KEY `MODULO_ID` (`MODULO_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usuarios_modulos`
--


/*!40000 ALTER TABLE `usuarios_modulos` DISABLE KEYS */;
LOCK TABLES `usuarios_modulos` WRITE;
INSERT INTO `usuarios_modulos` VALUES (1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(7,5),(9,5),(10,5),(11,5),(12,5),(13,5),(34,5),(35,5),(36,5),(38,5),(52,5),(53,5),(59,5),(60,5),(64,5),(1,13001),(2,13001),(3,13001),(4,13001),(5,13001),(6,13001),(7,13001),(9,13001),(10,13001),(11,13001),(12,13001),(13,13001),(34,13001),(35,13001),(59,13001),(60,13001),(13002,13001),(13004,13001);
UNLOCK TABLES;
/*!40000 ALTER TABLE `usuarios_modulos` 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 */;

