CREATE SEQUENCE metadata.conexions_sources_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.conexions_sources_id_seq
    OWNER TO postgres;

CREATE SEQUENCE metadata.conexions_types_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.conexions_types_id_seq
    OWNER TO postgres;

CREATE SEQUENCE metadata.file_types_id_library_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.file_types_id_library_seq
    OWNER TO postgres;

CREATE SEQUENCE metadata."layerServer_library_libraryId_seq"
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata."layerServer_library_libraryId_seq"
    OWNER TO postgres;

CREATE SEQUENCE metadata."layerServer_types_ogc_fid_seq"
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata."layerServer_types_ogc_fid_seq"
    OWNER TO postgres;

CREATE SEQUENCE metadata.sources_library_id_library_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.sources_library_id_library_seq
    OWNER TO postgres;

CREATE SEQUENCE metadata.svg_library_id_library_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.svg_library_id_library_seq
    OWNER TO postgres;

CREATE SEQUENCE metadata.svg_types_id_seq
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 2147483647
    CACHE 1;

ALTER SEQUENCE metadata.svg_types_id_seq
    OWNER TO postgres;

CREATE TABLE metadata.conexions_sources
(
    id integer NOT NULL DEFAULT nextval('metadata.conexions_sources_id_seq'::regclass),
    id_conexion integer,
    id_sources integer,
    CONSTRAINT conexions_sources_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.conexions_sources
    OWNER to postgres;


CREATE TABLE metadata.conexions_types
(
    id integer NOT NULL DEFAULT nextval('metadata.conexions_types_id_seq'::regclass),
    name character varying COLLATE pg_catalog."default",
    CONSTRAINT conexions_types_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.conexions_types
    OWNER to postgres;

CREATE TABLE metadata.file_types
(
    id_library integer NOT NULL DEFAULT nextval('metadata.file_types_id_library_seq'::regclass),
    file_name character varying COLLATE pg_catalog."default",
    internal_name character varying COLLATE pg_catalog."default",
    publish_date date,
    id_sources integer,
    CONSTRAINT file_types_pkey PRIMARY KEY (id_library)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.file_types
    OWNER to postgres;

CREATE TABLE metadata."layerServer_library"
(
    "libraryId" integer NOT NULL DEFAULT nextval('metadata."layerServer_library_libraryId_seq"'::regclass),
    "typeId" integer,
    name character varying COLLATE pg_catalog."default",
    url character varying COLLATE pg_catalog."default",
    published_date date,
    "spatialRange" character varying COLLATE pg_catalog."default",
    description character varying COLLATE pg_catalog."default",
    "spanishName" character varying COLLATE pg_catalog."default",
    category character varying COLLATE pg_catalog."default",
    bbox character varying COLLATE pg_catalog."default",
    validated boolean,
    "reviewedAt" character varying COLLATE pg_catalog."default",
    "insecureURL" character varying COLLATE pg_catalog."default",
    "imageURL" character varying COLLATE pg_catalog."default",
    downloadable boolean,
    "downloadURL_geojson" character varying COLLATE pg_catalog."default",
    "downloadURL_csv" character varying COLLATE pg_catalog."default",
    reference_date character varying COLLATE pg_catalog."default",
    lenguage character varying COLLATE pg_catalog."default",
    cuality character varying COLLATE pg_catalog."default",
    source character varying COLLATE pg_catalog."default",
    CONSTRAINT "layerServer_library_pkey" PRIMARY KEY ("libraryId")
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata."layerServer_library"
    OWNER to postgres;   


CREATE TABLE metadata."layerServer_types"
(
    ogc_fid integer NOT NULL DEFAULT nextval('metadata."layerServer_types_ogc_fid_seq"'::regclass),
    id integer,
    name character varying COLLATE pg_catalog."default",
    human_name character varying COLLATE pg_catalog."default",
    CONSTRAINT "layerServer_types_pkey" PRIMARY KEY (ogc_fid)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata."layerServer_types"
    OWNER to postgres;


CREATE TABLE metadata.sources_library
(
    id_library integer NOT NULL DEFAULT nextval('metadata.sources_library_id_library_seq'::regclass),
    sourcetype_name character varying COLLATE pg_catalog."default",
    internal_name character varying COLLATE pg_catalog."default",
    published_date date,
    CONSTRAINT sources_library_pkey PRIMARY KEY (id_library)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.sources_library
    OWNER to postgres;


CREATE TABLE metadata.svg_library
(
    id_library integer NOT NULL DEFAULT nextval('metadata.svg_library_id_library_seq'::regclass),
    id_types integer NOT NULL,
    svg_name character varying COLLATE pg_catalog."default",
    svg_url character varying COLLATE pg_catalog."default",
    published_date date DEFAULT CURRENT_DATE,
    CONSTRAINT svg_library_pkey PRIMARY KEY (id_library)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.svg_library
    OWNER to postgres;


CREATE TABLE metadata.svg_types
(
    id integer NOT NULL DEFAULT nextval('metadata.svg_types_id_seq'::regclass),
    name character varying COLLATE pg_catalog."default",
    CONSTRAINT svg_types_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE metadata.svg_types
    OWNER to postgres;


INSERT INTO metadata.conexions_sources(id,id_conexion,id_sources) VALUES
(1,1,1),
(2,1,2),
(3,2,1),
(4,2,2),
(5,2,3),
(6,2,4),
(7,2,5),
(8,3,1),
(9,3,2),
(10,3,3),
(11,3,4),
(12,3,5);

INSERT INTO metadata.conexions_types(id,name) VALUES
(1,'PostgreSQL'),
(2,'FTP'),
(3,'HTTP');

INSERT INTO metadata.file_types(id_library,file_name,internal_name,publish_date,id_sources) VALUES
(1,'Shapefile','SHAPE','2020-05-07',1),
(2,'KML','KML','2020-05-07',1),
(3,'GeoJSON','GeoJSON','2020-05-07',1),
(4,'las','LAS','2021-02-04',4),
(5,'GeoTIFF','GEOTIFF','2021-02-04',3),
(6,'ECW','ECW','2021-02-04',3),
(7,'csv','CSV','2021-02-04',2),
(8,'Excel','EXCEL','2021-02-04',2),
(9,'zip','ZIP','2021-02-04',5),
(10,'7zip','7ZIP','2021-02-04',5),
(11,'rar','RAR','2021-02-04',5);

INSERT INTO metadata."layerServer_library"("libraryId","typeId",name,url,published_date,"spatialRange",description,"spanishName",category,bbox,validated,"reviewedAt","insecureURL","imageURL",downloadable,"downloadURL_geojson","downloadURL_csv",reference_date,lenguage,cuality,"source") VALUES
(1,4,'Water Basemap','https://maratlas.discomap.eea.Europe.eu/arcgis/services/Maratlas/BaseMap/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-05','https://maratlas.discomap.eea.Europe.eu/arcgis/services/Maratlas/BaseMap/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,4,'Administrative Units USA','https://land.discomap.eea.Europe.eu/arcgis/services/Land/GISCO_Nomenclature_of_Territorial_Units_for_Statistics_2010_NUTS_Aug2012/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Europe',NULL,NULL,NULL,NULL,False,'2020-11-05','https://land.discomap.eea.Europe.eu/arcgis/services/Land/GISCO_Nomenclature_of_Territorial_Units_for_Statistics_2010_NUTS_Aug2012/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3,4,'Transport Density','https://land.discomap.eea.Europe.eu/arcgis/services/Land/Fragmentation/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Europe',NULL,NULL,NULL,NULL,False,'2020-11-05','https://land.discomap.eea.Europe.eu/arcgis/services/Land/Fragmentation/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(4,4,'Urban Atlas','https://land.discomap.eea.Europe.eu/arcgis/services/Land/UrbanAtlas_Dyna_WGS84/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Europe',NULL,NULL,NULL,NULL,False,'2020-11-05','https://land.discomap.eea.Europe.eu/arcgis/services/Land/UrbanAtlas_Dyna_WGS84/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(5,4,'Rivers','https://maratlas.discomap.eea.Europe.eu/arcgis/services/Maratlas/Hydrography/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Europe',NULL,NULL,NULL,NULL,False,'2020-11-05','https://maratlas.discomap.eea.Europe.eu/arcgis/services/Maratlas/Hydrography/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(6,4,'Flood Hazard','https://servicios.idee.es/wms-inspire/riesgos-naturales/inundaciones?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con las capas de periodos de retorno de inundación marina y fluvial','Riesgo de inundación',' #Terrain #Urbanplanning #Risk ','-19.6,25.4 : 5.6,45.6',True,'2020-11-05','http://servicios.idee.es/wms-inspire/riesgos-naturales/inundaciones?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(7,4,'Copernicus project','https://servicios.idee.es/wms/copernicus-landservice-spain?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con diferentes capas del proyecto Copérnico','Proyecto Copérnico',' #nature #Enviroment #Land #Coverage #Urbanplanning ','-19.6,25.4 : 5.6,45.6',True,'2020-11-05','http://servicios.idee.es/wms/copernicus-landservice-spain?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(9,4,'IGN Base maps','https://www.ign.es/wms-inspire/ign-base?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con diferentes mapas base del IGN predominando transportes','IGN Mapas base',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Urbanplanning ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://www.ign.es/wms-inspire/ign-base?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(10,4,'IGN DTM','https://servicios.idee.es/wms-inspire/mdt?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con Mallado, curvas de nivel, orientaciones, pendientes, puntos acotados, Relieve y Sombreado del Modelo Digital del Terreno del IGN','IGN MDT',' #Terrain #Urbanplanning #Risk ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://servicios.idee.es/wms-inspire/mdt?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(11,4,'IGN Land use','https://servicios.idee.es/wms-inspire/ocupacion-suelo?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con datos de SIOSE de España procedentes del IGN','IGN Siose',' #Transport #Infraestructures #nature #Enviroment #Coverage #Urbanplanning','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://servicios.idee.es/wms-inspire/ocupacion-suelo?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(12,4,'IGN spanish historic orthoimages','https://www.ign.es/wms/pnoa-historico?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con un mosaico con las ortoimagenes históricas de España. Años 1956-57, 1973-86, 1981-86, 1997-98, 1997-2003 y PNOA 2004-18','Imágenes históricas España del IGN',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://www.ign.es/wms/pnoa-historico?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,4,'Orthomige maximum actuality of IGN PNOA','https://www.ign.es/wms-inspire/pnoa-ma','2020-04-01','Spain','WMS con un mosaico con las ortoimagenes de PNOA más actuales','WMS ortoimagen mas actalidad de PNOA',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://www.ign.es/wms-inspire/pnoa-ma',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(14,4,'Air and ground transportation','https://servicios.idee.es/wms-inspire/transportes?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capas del IGN con informacion de referencia de transporte aéreo y terrestre de España','Transporte aéreo y terrestre',' #Transport #Infraestructures #Estructures #Urbanplanning','-18.5, 26.4, 4.8, 45.1',True,'2020-11-05','http://servicios.idee.es/wms-inspire/transportes?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(15,4,'Nautocal Chart','http://ideihm.covam.es/wms/cartaENCp2?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capas con informacion de referencia de elementos de orientacion en el mar','Cartas nauticas de España',' #Transport #Enviroment #Risk ','-18.5, 26.4, 4.8, 45.1',False,'2021-02-12','http://ideihm.covam.es/wms/cartaENCp2?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(16,4,'Info Marina Reference','http://barreto.md.ieo.es/arcgis/services/wms/wmsBase/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capas con información marina de referencia','Información marina de referencia',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Security ','-18.5, 26.4, 4.8, 45.1',False,'2021-02-12','http://barreto.md.ieo.es/arcgis/services/wms/wmsBase/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(17,4,'Active Faults','http://Maps.igme.es/gis/services/Cartografia_Tematica/IGME_QAFI/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Spain',NULL,NULL,NULL,NULL,False,'2021-02-12','http://Maps.igme.es/gis/services/Cartografia_Tematica/IGME_QAFI/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(18,4,'Carto Geological','http://Maps.igme.es/gis/services/Cartografia_Geologica/IGME_Geode_50/MapServer/WMSServer?request=GetCapabilities&service=WMS','2020-04-01','Spain',NULL,NULL,NULL,NULL,False,'2021-02-12','http://Maps.igme.es/gis/services/Cartografia_Geologica/IGME_Geode_50/MapServer/WMSServer?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(19,4,'IGN Raster','http://www.ign.es/wms-inspire/Map-raster?request=GetCapabilities&service=WMS','2020-04-01','Spain',NULL,NULL,NULL,NULL,False,'2021-02-12','http://www.ign.es/wms-inspire/Map-raster?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(20,4,'IGN Grid MTN25 and MTN50','https://www.ign.es/wms-inspire/cuadriculas?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capa con las cuadriculas de MTN25 y MTN50 del IGN','Cuadrícula de MTN25 y MTN50 del IGN',' #Administrativelimits ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms-inspire/cuadriculas?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(21,4,'IGN Photo library','https://fototeca.cnig.es/wms/fototeca.dll?request=GetCapabilities&service=WMS','2020-04-01','Spain','Fotocentros de las imágenes de los diferentes vuelos del IGN','IGN Fototeca',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://fototeca.cnig.es/wms/fototeca.dll?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(22,4,'IGN sismic information','https://www.ign.es/wms-inspire/geofisica?request=GetCapabilities&service=WMS','2020-04-01','Spain','Información sísmica y volcánica','Capa con información sísmica del IGN',' #Urbanplanning #Risk ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms-inspire/geofisica?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(23,4,'IGN Topónimos','https://www.ign.es/wms-inspire/ngbe?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capa con los nombres geográficos','IGN Topónimos',' #Administrativelimits','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms-inspire/ngbe?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(24,4,'IGN Minutas','https://www.ign.es/wms/minutas-cartograficas?request=GetCapabilities&service=WMS','2020-04-01','Spain','WMS con las minutas cartográficas históricas entre 1870 y 1950','IGN minutas',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms/minutas-cartograficas?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(25,4,'IGN MTN Primera Edicion','https://www.ign.es/wms/minutas-cartograficas?request=GetCapabilities&service=WMS','2020-04-01','Spain','Primera edición del MTN25 y MTN50 del IGN','MTN25 y MTN50 del IGN',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk ','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms/primera-edicion-mtn?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(26,4,'IGN ELF','http://elf.ign.es/wms/basemap?request=GetCapabilities&service=WMS','2020-04-01','Spain',NULL,NULL,NULL,NULL,False,'2021-02-12','http://elf.ign.es/wms/basemap?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(27,4,'IGN Geodesic networks','https://www.ign.es/wms-inspire/redes-geodesicas?request=GetCapabilities&service=WMS','2020-04-01','Spain','Redes geodésicass  de España ERGNESS, REDNAP, ROI y REGENTE','Redes geodésicas del IGN',' #Terrain','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms-inspire/redes-geodesicas?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(28,4,'IGN Limite Administrativo','https://www.ign.es/wms-inspire/unidades-administrativas?request=GetCapabilities&service=WMS','2020-04-01','Spain','Límites administrativos de España del IGN','Límites administrativos de España',' #Administrativelimits','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wms-inspire/unidades-administrativas?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(29,4,'Cadastre','http://ovc.Cadastre.meh.es/Cartografia/WMS/ServidorWMS.aspx?request=GetCapabilities&service=WMS','2020-04-01','Spain','Catastro España según parámetros INSPIRE','Catastro de España',' #Administrativelimits #Infraestructures #Coverage #Urbanplanning','-18.5, 26.4, 4.8, 45.1',False,'2021-02-12','http://ovc.Cadastre.meh.es/Cartografia/WMS/ServidorWMS.aspx?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(30,4,'Cadastre INSPIRE','https://ovc.catastro.meh.es/cartografia/INSPIRE/spadgcwms.aspx?','2020-04-01','Spain','Catastro España según parámetros INSPIRE. Va a dar error al cargar en maps hay que cambiar la versión a 1.0.0  y darle a la layer el nombre de la capa dentro de sus metadatos.','Catastro de España',' #Administrativelimits #Infraestructures #Coverage #Urbanplanning','-18.5, 26.4, 4.8, 45.1',True,'2021-02-12','http://ovc.catastro.meh.es/cartografia/INSPIRE/spadgcwms.aspx?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(31,4,'Cadastre','https://ovc.Cadastre.meh.es/Cartografia/WMS/PonenciasWMS.aspx?request=GetCapabilities&service=WMS','2020-04-01','Spain','Capa WMS con las geometrías y valores de Catastro de España. Va a dar error al cargar en maps hay que cambiar la versión a 1.0.0  y darle a la layer el nombre de la capa dentro de sus metadatos.','Catastro de España',' #Administrativelimits #Infraestructures #Coverage #Urbanplanning','-18.5, 26.4, 4.8, 45.1',True,'2021-02-12','http://ovc.Cadastre.meh.es/Cartografia/WMS/PonenciasWMS.aspx?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(32,4,'Thematics Maps','http://www.madrid.org/cartografia/ide/wms/WMS_CARTOGRAFIA_TEMATICA.xml?request=GetCapabilities&service=WMS','2020-04-01','Community_of_Madrid','Mapas temáticos dre la comunidad de Madrid','Mapas Temáticos Madrid',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk ','-5.1, 39.8, -2.6, 41.2',False,'2021-02-12','http://www.madrid.org/cartografia/ide/wms/WMS_CARTOGRAFIA_TEMATICA.xml?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(34,4,'Historicals Plans','https://www.ign.es/wms/planos?request=GetCapabilities&service=WMS','2020-04-01','Madrid','Mapas históricos del ayuntamiento de Madrid de 1622 hasta 1960 proveedor IGN','Planos Históricos de Madrid',' #Urbanplanning','-4.0, 40.2, -3.4, 40.6',True,'2020-11-04','http://www.ign.es/wms/planos?request=GetCapabilities&service=WMS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(38,41,'Esri Imagery/Satellite','https://server.arcgisonline.com/ArcGIS/rest/services/World_Imagery/MapServer/tile/{z}/{y}/{x}','2020-04-01','World','Mapa Base con imagen satelital a nivel mundial','Mapa base con  imágen satélite de ESRI',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk ','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04),
','https://server.arcgisonline.com/ArcGIS/rest/services/World_Imagery/MapServer/tile/{z}/{y}/{x}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(42,4,'Stamen Toner','https://stamen-tiles-{s}.a.ssl.fastly.net/toner/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa minimalista en blanco y negro donde se representan las principales entidades.','Mapa base con estilo Stamen Toner',' #Administrativelimits #Transport ','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/toner/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(44,41,'Stamen TonerLite','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-lite/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa base en blanco, con un estilo antiguo, donde se representan las carreteras.','Mapa base con estilo Stamen TonerLite',' #Administrativelimits #Transport ','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-lite/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(45,41,'Stamen Watercolor','https://stamen-tiles-{s}.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.png','2020-04-01','World','Mapa base en blanco, con un estilo antiguo, donde se representan las carreteras y zonas verdes.','Mapa base con estilo Watercolor',' #Transport ','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/watercolor/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(46,4,'Stamen TerrainBackground','https://stamen-tiles-{s}.a.ssl.fastly.net/terrain-background/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa base  físico sin etiquetas con estilo TerrainBackground','Mapa Base  físico Stamenr',' #nature #Enviromen','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/terrain-background/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(47,41,'Esri WorldTerrain','https://server.arcgisonline.com/ArcGIS/rest/services/World_Terrain_Base/MapServer/tile/{z}/{y}/{x}','2020-04-01','World','Mapa base físico mundial sin etiquetas y escala pequeña','Mapa base de terreno mundial',' #nature #Enviroment #Terrain','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://server.arcgisonline.com/ArcGIS/rest/services/World_Terrain_Base/MapServer/tile/{z}/{y}/{x}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(48,41,'Esri WorldPhysical','https://server.arcgisonline.com/ArcGIS/rest/services/World_Physical_Map/MapServer/tile/{z}/{y}/{x}','2020-04-01','World','Mapa Base físico de  ESRI, escalas pequeñas, sin etiquetas','Mapa base físico mundial',' #nature #Enviroment #Terrain','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://server.arcgisonline.com/ArcGIS/rest/services/World_Physical_Map/MapServer/tile/{z}/{y}/{x}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(49,41,'Esri OceanBasemap','https://server.arcgisonline.com/ArcGIS/rest/services/Ocean_Basemap/MapServer/tile/{z}/{y}/{x}','2020-04-01','World','Mapa Base Estilo Ocean de  ESRI, escalas pequeñas','Mapa base Ocean de ESRI',' #Administrativelimits #Enviroment','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://server.arcgisonline.com/ArcGIS/rest/services/Ocean_Basemap/MapServer/tile/{z}/{y}/{x}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(50,41,'CartoDB PositronNoLabels','https://{s}.basemaps.cartocdn.com/light_nolabels/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa Base sin etiquetas con diseño Positron de CartoDB','Mapa sin etiquetas con estilo Positron de CartoDB',' #Transport #Infraestructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/light_nolabels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(51,41,'CartoDB PositronOnlyLabels','https://{s}.basemaps.cartocdn.com/light_only_labels/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de etiquetas con diseño Positron de CartoDB','Etiquetas estilo Positron de CartoDB',' #Administrativelimits','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/light_only_labels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(52,41,'CartoDB DarkMatter','https://{s}.basemaps.cartocdn.com/dark_all/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa Base con diseño DarkMatter de CartoDB','Mapa con estilo DarkMatter de CartoDB',' #Administrativelimits #Transport #Infraestructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/dark_all/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(53,41,'CartoDB DarkMatterNoLabels','https://{s}.basemaps.cartocdn.com/dark_nolabels/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa Base sin etiquetas con diseño DarkMatter de CartoDB','Mapa sin etiquetas con estilo DarkMatter de CartoDB',' #Transport #Infraestructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/dark_nolabels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(54,41,'CartoDB DarkMatterOnlyLabels','https://{s}.basemaps.cartocdn.com/dark_only_labels/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de etiquetas con diseño DarkMatter de CartoDB','Etiquetas estilo DarkMatter de CartoDB',' #Administrativelimits','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/dark_only_labels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(55,41,'CartoDB Voyager','https://{s}.basemaps.cartocdn.com/rastertiles/voyager/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa base estilo Voyager CartoDB','Mapa con estilo Voyager CartoDB',' #Administrativelimits #Transport #Infraestructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/rastertiles/voyager/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(56,41,'CartoDB VoyagerNoLabels','https://{s}.basemaps.cartocdn.com/rastertiles/voyager_nolabels/{z}/{x}/{y}{r}.png','2020-04-01','World','Mapa base sin etiquetas con diseño Voyager de CartoDB','Mapa sin etiquetas con estilo Voyager CartoDB',' #Transport #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/rastertiles/voyager_nolabels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(57,41,'CartoDB VoyagerOnlyLabels','https://{s}.basemaps.cartocdn.com/rastertiles/voyager_only_labels/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de etiquetas con diseño Voyager de CartoDB','Etiquetas Voyager CartoDB',' #Administrativelimits','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.basemaps.cartocdn.com/rastertiles/voyager_only_labels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(58,41,'HikeBike HillShading','https://tiles.wmflabs.org/hillshading/{z}/{x}/{y}.png','2020-04-01','World','mapa de  pendientes',NULL,NULL,NULL,False,'2020-11-04','https://tiles.wmflabs.org/hillshading/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(59,41,'NASAGIBS ViirsEarthAtNight2012','https://map1.vis.earthdata.nasa.gov/wmts-webmerc/VIIRS_CityLights_2012/default/{time}/{tilematrixset}{maxZoom}/{z}/{y}/{x}.jpg','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-04','https://map1.vis.earthdata.nasa.gov/wmts-webmerc/VIIRS_CityLights_2012/default/{time}/{tilematrixset}{maxZoom}/{z}/{y}/{x}.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(60,41,'Wikimedia','https://maps.wikimedia.org/osm-intl/{z}/{x}/{y}{r}.png','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-04),
','https://maps.wikimedia.org/osm-intl/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(61,41,'OpenSeaMap','https://tiles.openseamap.org/seamark/{z}/{x}/{y}.png','2020-04-01','World','Capa con elementos de orientación marina, así como las vias de paso de embarcaciones','Señales marinas',' #Transport #Infraestructures #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://tiles.openseamap.org/seamark/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(62,41,'OpenPtMap','http://openptmap.org/tiles/{z}/{x}/{y}.png','2020-04-01','World','Capa con las líneas de transporte público improtantes del mundo.','Líneas de transporte público del mundo',' #Transport','-189.0, -152.0, 189.0, 150.5',False,'2021-02-12','http://openptmap.org/tiles/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(63,41,'OpenRailwayMap','https://{s}.tiles.openrailwaymap.org/standard/{z}/{x}/{y}.png','2020-04-01','World','Capa con las líneas de tren más improtantes del mundo de forma categorizada.','lineas de tren del mundo',' #Transport','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://{s}.tiles.openrailwaymap.org/standard/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(64,41,'OpenFireMap','http://openfiremap.org/hytiles/{z}/{x}/{y}.png','2020-04-01','World','Capa donde figuran los parques de bombero del mundo','Parques de bomberos mundiales',' #Infraestructures #Urbanplanning #Security #Risk','-189.0, -152.0, 189.0, 150.5',False,'2021-02-12','http://openfiremap.org/hytiles/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(65,41,'SafeCast','https://s3.amazonaws.com/te512.safecast.org/{z}/{x}/{y}.png','2020-04-01','World',NULL,NULL,' #Transport','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://s3.amazonaws.com/te512.safecast.org/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(66,41,'OpenMapSurfer AdminBounds','https://maps.heigit.org/openmapsurfer/tiles/adminb/webmercator/{z}/{x}/{y}.png','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-05','https://maps.heigit.org/openmapsurfer/tiles/adminb/webmercator/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(67,41,'OpenMapSurfer Hillshade','https://maps.heigit.org/openmapsurfer/tiles/asterh/webmercator/{z}/{x}/{y}.png','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-05','https://maps.heigit.org/openmapsurfer/tiles/asterh/webmercator/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(68,41,'Hydda RoadsAndLabels','https://{s}.tile.openstreetmap.se/hydda/roads_and_labels/{z}/{x}/{y}.png','2020-04-01','World',NULL,NULL,NULL,NULL,False,'2020-11-05','https://{s}.tile.openstreetmap.se/hydda/roads_and_labels/{z}/{x}/{y}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(69,41,'Stamen TonerHybrid','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-hybrid/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de etiquetas y líneas de OSM con el  diseño Stamen Toner','líneas y etiquetas del diseño  Stamen Toner',' #Administrativelimits #Transport #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-hybrid/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(70,41,'Stamen TonerLines','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-lines/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de  líneas de OSM con el  diseño Stamen Toner','líneas del diseño  Stamen Toner',' #Transport #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-lines/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(71,41,'Stamen TonerLabels','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-labels/{z}/{x}/{y}{r}.png','2020-04-01','World','Capa de  etiquetas de OSM con el  diseño Stamen Toner','Etiquetas del diseño  Stamen Toner',' #Administrativelimits','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-labels/{z}/{x}/{y}{r}.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(72,75,'Basemap','https://www.ign.es/wmts/ign-base','2020-04-01','Spain','Mapa base de estilo minimalista donde se representan las principales entidades.','diferentes mapas base de estilo donde se representan las principales entidades.',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-11-04','http://www.ign.es/wmts/ign-base',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(73,75,'Map LiDAR','http://wmts-Map-lidar.idee.es/lidar','2020-04-01','Spain','Capa obtenida a partir de datos LiDAR, donde se representa el relieve y los núcleos urbanos de España.',NULL,NULL,NULL,False,'2021-02-12','http://wmts-Map-lidar.idee.es/lidar',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(74,75,'Digital Model of Elevation in Spain','https://servicios.idee.es/wmts/mdt','2020-04-01','Spain','Capa donde se muestra en escala de grises el Modelo Digital del Terreno de España. ','mapa base con el Modelo Digital del Terreno de España',' #Terrain','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://servicios.idee.es/wmts/mdt',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(75,75,'Land Occupation','https://servicios.idee.es/wmts/ocupacion-suelo','2020-04-01','Spain','Mapa Base de usos del suelo de España.','Mapa base de SIOSE de España',' #Coverage','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://servicios.idee.es/wmts/ocupacion-suelo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(76,75,'Carto raster','http://www.ign.es/wmts/Map-raster','2020-04-01','Spain',NULL,NULL,NULL,NULL,False,'2021-02-12','http://www.ign.es/wmts/Map-raster',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(77,75,'Plans of Madrid(1662-1960),','https://www.ign.es/wmts/planos','2020-04-01','Spain','Planos de la ciudad Madrid georeferenciado entre los años 1662-1960.','Planos históricos de Madrid',' #Urbanplanning','-4.0, 40.2, -3.4, 40.6',True,'2020-11-04','http://www.ign.es/wmts/planos',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(78,75,'First edition of the National Topographic Maps','https://www.ign.es/wmts/primera-edicion-mtn','2020-04-01','Spain','Composición que unifica todas las hojas del mapa topográfico nacional realizado por Instituto Geográfico Nacional','Primera edicion de MTN25',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://www.ign.es/wmts/primera-edicion-mtn',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(79,82,'Spain communities','https://apps.ipsilum.com:30022/geoserver/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:esp_ccaa_vw&outputFormat=application/json','2020-04-01','Spain','Capa dodne se representan las comunidades de España.','Comunidades Autónomas de  España',' #Administrativelimits','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://83.48.27.22:8080/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:esp_ccaa_vw&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(80,82,'Spain provinces','https://apps.ipsilum.com:30022/geoserver/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:esp_provincias_suav_vw&outputFormat=application/json','2020-04-01','Spain','Capa donde se representan las provincias de España','Provincias de España',' #Administrativelimits','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://83.48.27.22:8080/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:esp_provincias_suav_vw&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(81,82,'madrid district','https://apps.ipsilum.com:30022/geoserver/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_mad_distritos&outputFormat=application/json','2020-04-01','Madrid','Capa donde se  representan los distritos de Madrid','Distritos de Madrid',' #Administrativelimits','-4.0, 40.2, -3.4, 40.6',True,'2020-11-04','http://83.48.27.22:30013/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_mad_distritos&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(82,82,'madrid neighborhoods','https://apps.ipsilum.com:30022/geoserver/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_mad_barrios&outputFormat=application/json','2020-04-01','Madrid','Capa donde se representan los barrios de la ciudad de Madrid.','Barrios de Madrid',' #Administrativelimits','-4.0, 40.2, -3.4, 40.6',True,'2020-11-04','http://83.48.27.22:30013/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_mad_barrios&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(83,82,'european union nut1','https://apps.ipsilum.com:30022/geoserver/geoserver/comercial/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=comercial:eu_paises&outputFormat=application/json','2020-04-01','Europa Union','Capa donde se representan las regiones categoría nut1 de la UE. nut1 en España es CCAA','Nut1 de la Union Europea',' #Administrativelimits','-32.1,26.8 : 47.0,70.6',True,'2020-11-04','http://83.48.27.22:30013/geoserver/mundo/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=mundo:mv_europe1_suav&outputFormat=application/json ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(84,82,'mexico states','https://apps.ipsilum.com:30022/geoserver/geoserver/Proyecto_mexico/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Proyecto_mexico:mex_states&outputFormat=application/json','2020-04-01','Mexico','Capa donde se representan los estados de México.','Estados de México',' #Administrativelimits','-120.6, 13.2, -82.5, 34.3',True,'2020-11-04','http://83.48.27.22:30013/geoserver/mundo/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=mundo:mv_mexico1_suav&outputFormat=application/json ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(85,82,'mexico municipilities','https://apps.ipsilum.com:30022/geoserver/geoserver/Proyecto_mexico/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Proyecto_mexico:mex_municipilities&outputFormat=application/json','2020-04-01','Mexico','Capa donde se representan los municipios de México','Municipios de México',' #Administrativelimits','-120.6, 13.2, -82.5, 34.3',True,'2020-11-04','http://83.48.27.22:30013/geoserver/mundo/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=mundo:mv_mexico2_suav&outputFormat=application/json ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(86,82,'natural Protected Areas','https://apps.ipsilum.com:30022/geoserver/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_espacios_naturales_protegidos&outputFormat=application/json','2020-04-01','Spain','Capa donde se visualizan areas protegidas de España','Áreas naturales protegidas',' #nature #Enviroment #Terrain #Urbanplanning','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://83.48.27.22:30013/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_espacios_naturales_protegidos&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(87,82,'hydrographic confederations','https://apps.ipsilum.com:30022/geoserver/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_confederaciones_hidrograficas&outputFormat=application/json','2020-04-01','Spain','Capa donde se representan las cuencas fluviales de España.','Cuencas hidrográficas de España',' #nature #Enviroment','-18.5, 26.4, 4.8, 45.1',True,'2020-11-04','http://83.48.27.22:30013/geoserver/Mapas_tematicos/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=Mapas_tematicos:mv_confederaciones_hidrograficas&outputFormat=application/json ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(88,82,'USA states','https://apps.ipsilum.com:30022/geoserver/geoserver/comercial/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=comercial:eeuu_states&outputFormat=application/json','2020-04-01','USA','Capa donde se representan los estados de E.E.U.U.','Estados de Estados Unidos',' #Administrativelimits','-175.5, 22.9, -59.9, 71.856229',True,'2020-11-03','http://83.48.27.22:30013/geoserver/mundo/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=mundo%3Amv_eeuu1_suav&outputFormat=application%2Fjson',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(91,41,'Esri Streets ','https://server.arcgisonline.com/ArcGIS/rest/services/World_Street_Map/MapServer/tile/{z}/{y}/{x} ','2020-04-02','World','Mapa base donde se da un mayor peso al relieve y a las vías de comunicación. #mapabase #mapacarreteras','ESRI Calles',' #Transport #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://server.arcgisonline.com/ArcGIS/rest/services/World_Street_Map/MapServer/tile/{z}/{y}/{x} ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(92,41,'Esri Topo ','https://server.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer/tile/{z}/{y}/{x} ','2020-04-02','World','Mapa base donde se representan las entidades más importantes. Predomina el color blanco, y el verde para la representación de relieve y vegetación.','ESRI Topográfico',' #Administrativelimits #Transport #Infraestructures #Land #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://server.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer/tile/{z}/{y}/{x} ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(93,41,'Carto Positron ','https://cartodb-basemaps-a.global.ssl.fastly.net/light_all/{z}/{x}/{y}.png ','2020-04-02','World','Mapa base, con un tono blanco, donde se representan las entidades más importantes a excepción del relieve y las fronteras.','CartoDB Positron',' #Administrativelimits #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://cartodb-basemaps-a.global.ssl.fastly.net/light_all/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(94,41,'Stamen Terrain','http://a.tile.stamen.com/terrain/{z}/{x}/{y}.png ','2020-04-02','World','Mapa base donde prevalece la estética, con una representación en estilo acuarela, a la funcionalidad. Uso escala urbano','Stamen terrain',' #Administrativelimits #Transport #Infraestructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',False,'2021-02-12','http://a.tile.stamen.com/terrain/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(95,41,'OpenMapSurfer Roads ','https://maps.heigit.org/openmapsurfer/tiles/roads/webmercator/{z}/{x}/{y}.png ','2020-04-02','World','Mapa base donde a gran escala se destacan las vías de comunicación por encima del resto de entidades.',NULL,NULL,NULL,False,'2020-11-03','https://maps.heigit.org/openmapsurfer/tiles/roads/webmercator/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(96,41,'Esri NatGeoWorldMap ','https://server.arcgisonline.com/ArcGIS/rest/services/NatGeo_World_Map/MapServer/tile/{z}/{y}/{x} ','2020-04-02','World','Mapa base, a pequeña escala, donde se representan las entidades más importantes. Se fusiona el diseño estándar de un mapa político , con cada país en un color diferente, con elementos propios del mapas físico como la representación del relieve y vegetación.','Esri NatGeoWorldMap ',' #Administrativelimits #Transport #Infraestructures #Land #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://server.arcgisonline.com/ArcGIS/rest/services/NatGeo_World_Map/MapServer/tile/{z}/{y}/{x} ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(97,41,'OpenTopoMap ','https://{s}.tile.opentopomap.org/{z}/{x}/{y}.png ','2020-04-02','World','Mapa base, donde se representan las entidades más importantes dando mayor importancia al relieve, coberturas y transporte. muy parecedo a los de MTN25','OpenTopoMap ',' #Transport #Infraestructures #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://{s}.tile.opentopomap.org/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(98,41,'Hydda Full ','https://{s}.tile.openstreetmap.se/hydda/full/{z}/{x}/{y}.png ','2020-04-02','World',NULL,NULL,NULL,NULL,False,'2020-11-03','https://{s}.tile.openstreetmap.se/hydda/full/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(99,41,'Hydda Base ','https://{s}.tile.openstreetmap.se/hydda/base/{z}/{x}/{y}.png ','2020-04-02','World',NULL,NULL,NULL,NULL,False,'2020-11-03','https://{s}.tile.openstreetmap.se/hydda/base/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(100,41,'Stamen Toner ','https://stamen-tiles-{s}.a.ssl.fastly.net/toner/{z}/{x}/{y}{r}.png ','2020-04-02','World','Mapa base con estilo minimalista donde se representan las fronteras y las vías de comunicación.','Stamen TonerBackground',' #nature #Enviroment #Estructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://stamen-tiles-{s}.a.ssl.fastly.net/toner/{z}/{x}/{y}{r}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(101,41,'Stamen TonerBackground ','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-background/{z}/{x}/{y}{r}.png ','2020-04-02','World','Mapa base en blanco y negro sin etiquetas','Stamen TonerBackground',' #nature #Enviroment #Estructures #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://stamen-tiles-{s}.a.ssl.fastly.net/toner-background/{z}/{x}/{y}{r}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(102,41,'OpenStreetMap Mapnick ','https://tile.openstreetmap.org/{z}/{x}/{y}.png ','2020-04-02','World','Mapa de OSM Mapnick ','OpenStreetMap Mapnick ',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','http://tile.openstreetmap.org/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(103,75,'orthophoto maximum news PNOA ','https://www.ign.es/wmts/pnoa-ma ','2020-04-02','Spain','Ortofoto de España del PNOA.','Ortofoto de máxima resolución de España del PNOA.',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-18.5, 26.4, 4.8, 45.1',True,'2020-11-03','http://www.ign.es/wmts/pnoa-ma ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(104,41,'OSM Black and White ','https://tiles.wmflabs.org/bw-mapnik/{z}/{x}/{y}.png ','2020-04-02','World','Mapamundi de carreteras en blanco y negro. ','xyz Tiles de OSM en Blanco y negro',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','http://tiles.wmflabs.org/bw-mapnik/{z}/{x}/{y}.png ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(105,108,'Thematic CSV of the provinces of Spain','https://www.dropbox.com/s/rmts5zeaml17g0i/esp_provincias.csv?dl=0 ','2020-04-02','Provincias ','Capa temática de datos donde se incluyen los datos natcode, nameunit, codnut1 y codnut2 de las provincias españolas.','CSV temático de las provincias de España',' #Administrativelimits','null',False,'2020-11-03','https://www.dropbox.com/s/rmts5zeaml17g0i/esp_provincias.csv?dl=0 ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(106,109,'OGR Antarctic Ice Shelves','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_antarctic_ice_shelves_polys.zip','2020-04-16','Antartic','Capa vectorial de la superficie helada de la Antártida.','OGR Plataformas de hielo antárticas',' #nature #Enviroment #Land #Coverage','-189.0, -226.1, 189.0, 76.4',True,'2020-11-03','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_antarctic_ice_shelves_polys.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(107,109,'OGR Antarctica','https://download.geofabrik.de/antarctica-latest-free.shp.zip','2020-04-16','Antartic','Capa vectorial de la superficie de la Antártida.','OGR Antártida',' #Transport #Infraestructures #nature #Enviroment #Estructures #Land #Urbanplanning','-189.0, -226.1, 189.0, 76.4',True,'2020-11-03','http://download.geofabrik.de/antarctica-latest-free.shp.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(108,109,'OGR Bathymetry','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_bathymetry_all.zip','2020-04-16','World','Capa vectorial de batimetría.','OGR Batimetria',' #Terrain','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_bathymetry_all.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(109,109,'OGR Inland beach','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_playas.zip','2020-04-16','World','Capa vectorial de oasis del mundo.','OGR Lago Salino Interno',' #nature #Enviroment #Land #Coverage #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-11-03','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_playas.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(110,109,'OGR Coastline','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_coastline.zip','2020-04-16','World','Capa vectorial donde se representa el perímetro costero a nivel mundial.','OGR Línea de costa ',' #nature #Enviroment #Land #Coverage #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_coastline.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(111,109,'OGR Geographic lines','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_geographic_lines.zip','2020-04-16','World','Capa vectorial donde se representan los 5 paralelos principales de la Tierra.','OGR Líneas geográficas',' #Land','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_geographic_lines.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(114,109,'OGR Glaciated Areas','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_glaciated_areas.zip','2020-04-16','World','Capa vectorial de los glaciares más importantes a nivel mundial.','OGR Zonas glaciares',' #nature #Enviroment #Land #Coverage #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_glaciated_areas.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(115,109,'OGR Spain rivers','https://biogeo.ucdavis.edu/data/diva/wat/ESP_wat.zip','2020-04-16','Spain','Capa vectorial de las masas de agua de España.','OGR Rios España',' #nature #Enviroment #Urbanplanning #Risk','-18.5, 26.4, 4.8, 45.1',True,'2020-10-30','http://biogeo.ucdavis.edu/data/diva/wat/ESP_wat.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(116,109,'OGR Land','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_land.zip','2020-04-16','World','Capa vectorial de la superficie terrestre mundial','OGR Tierra',' #nature #Enviroment #Land #Coverage #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_land.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(117,109,'OGR Minor Island','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_minor_islands.zip','2020-04-16','World','Capa vectorial de pequeñas islas del mundo. Menores a 2 Km2','OGR Islas de pequeño tamaño',' #Administrativelimits #nature #Enviroment #Land #Coverage','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_minor_islands.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(118,109,'OGR Oceans','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_ocean.zip','2020-04-16','World','Capa vectorial de los océanos del mundo.','OGR Oceanos',' #nature #Enviroment #Land #Coverage','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_ocean.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(119,109,'OGR Reefs','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_reefs.zip','2020-04-16','World','Capa vectorial con los arrecifes más importantes.','OGR Arrecifes',' #nature #Enviroment #Urbanplanning','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_reefs.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(120,109,'OGR Rivers and lakes','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_rivers_europe.zip','2020-04-16','Europe','Capa vectorial con los principales ríos y lagos de Europa.','OGR rios y lagos',' #nature #Enviroment #Urbanplanning','-23.7, 12.0, 68.0, 85.4',True,'2020-10-30','https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/physical/ne_10m_rivers_europe.zip',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(124,82,'Demo_4','https://apps.ipsilum.com:30022/geoserver/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:demo_provincias_mv&outputFormat=application/json','2020-06-17','World','WMS con 157 capas diversas con atributos cuantitativos y cualitativos','Demo_4',' #Administrativelimits #Transport #Infraestructures #nature #Enviroment #Terrain #Estructures #Land #Coverage #Urbanplanning #Security #Healthandsafety #Risk','-189.0, -152.0, 189.0, 150.5',True,'2020-10-30','http://83.48.27.22:8080/geoserver/T2hjjeTigxNQ965ai/wfs?request=GetFeature&service=WFS&version=1.0.0&typeName=T2hjjeTigxNQ965ai:demo_provincias_mv&outputFormat=application/json',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

INSERT INTO metadata."layerServer_types"(ogc_fid,id,name,human_name) VALUES
(1,4,'WMS','Web Map Service'),
(2,75,'WMTS','Web Map Tile Service'),
(3,82,'GeoJSON','Geojson'),
(4,124,'TMS','Tile Map Service'),
(5,125,'mapBox','Mapbox'),
(6,126,'mapBox-gl','Mapbox-GL'),
(7,41,'xyzTiles','XYZ Tiles service'),
(8,108,'CSV','CSV'),
(9,109,'OGR','OGR file');

INSERT INTO metadata.sources_library(id_library,sourcetype_name,internal_name,published_date) VALUES
(1,'Vector','VECTOR','2020-05-07'),
(2,'Thematic','THEMATIC','2020-05-07'),
(3,'Raster','RASTER','2020-05-07'),
(4,'PointCloud','POINTCLOUD','2020-05-07'),
(5,'Generic','GENERIC','2020-05-07');

INSERT INTO metadata.svg_library(id_library,id_types,svg_name,svg_url,published_date) VALUES
(396,1,'Chincheta','https://upload.wikimedia.org/wikipedia/commons/4/49/Pin_in_Lila_L.svg','2019-10-08'),
(397,1,'Marcador','https://upload.wikimedia.org/wikipedia/commons/1/18/Kb_Map-pin-marked.svg','2019-10-08'),
(398,3,'Árbol','https://svgsilh.com/svg/303884.svg','2019-10-08'),
(399,1,'Bandera','https://svgsilh.com/svg/1295315.svg','2019-10-08'),
(400,1,'Rotulador','https://svgsilh.com/svg/156032.svg','2019-10-08'),
(402,8,'Airport','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/airport.svg','2019-10-15'),
(403,1,'Estrella','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/attraction.svg','2019-10-16'),
(404,8,'Puntos de recarga','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/car_charge_point.svg','2019-10-16'),
(405,8,'Parking','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/car_park1.svg','2019-10-16'),
(406,8,'Parking black','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/car_park2.svg','2019-10-16'),
(407,14,'Castillo','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/castle.svg','2019-10-16'),
(408,14,'Catedral','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/cathedral.svg','2019-10-16'),
(409,3,'Coniferas','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/coniferous_tree.svg','2019-10-16'),
(410,14,'Country park Reino Unido','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/country_park.svg','2019-10-16'),
(411,8,'Bicicleta','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/cycle.svg','2019-10-16'),
(412,8,'Restaurante','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/eating_drinking_venue.svg','2019-10-16'),
(413,8,'Metro Londres','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/london_underground.svg','2019-10-16'),
(414,3,'Árbol no conífera','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/non_coniferous_tree.svg','2019-10-21'),
(415,3,'Frutal','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/orchard_tree.svg','2019-10-21'),
(416,3,'Árbol de huerta','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/orchard_tree.svg','2019-10-21'),
(417,1,'pin 1','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/pin1.svg','2019-10-21'),
(418,1,'pin 2','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/pin2.svg','2019-10-21'),
(419,1,'pin 3','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/pin3.svg','2019-10-21'),
(420,31,'Cruz','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/place_of_worship.svg','2019-10-21'),
(426,3,'Frutal','http://83.48.27.22:30016/ipsilum/symbology/point/icon/frutal.svg','2019-10-22'),
(435,31,'Lugar de culto aguja','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/place_of_worship_spire.svg','2019-10-21'),
(436,31,'Lugar de culto cruz','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/place_of_worship_tower.svg','2019-10-21'),
(437,14,'Alojamiento','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/places_to_stay.svg','2019-10-21'),
(438,14,'Aseos','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/public_convenience.svg','2019-10-21'),
(439,8,'Bici','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/riding.svg','2019-10-21'),
(440,14,'Yacimiento arqueológico','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/site_of_antiquity.svg','2019-10-21'),
(441,38,'Planta solar','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/solar_farm.svg','2019-10-21'),
(442,14,'Centro deportivo','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/sports_leisure.svg','2019-10-21'),
(443,14,'Parque temático','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/theme_park.svg','2019-10-21'),
(444,1,'Punto de información','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/tourist_information.svg','2019-10-21'),
(445,8,'Estación de tren','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/train_station.svg','2019-10-21'),
(446,43,'Huella pie','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/walk.svg','2019-10-21'),
(447,38,'Aerogenerador','https://raw.githubusercontent.com/OrdnanceSurvey/GeoDataViz-Toolkit/master/Symbols/wind_turbine.svg','2019-10-21'),
(518,115,'Círculo en movimiento','https://upload.wikimedia.org/wikipedia/commons/c/c9/SVG_animated_loading_icon.svg','2019-10-22');

INSERT INTO metadata.svg_types(id,name) VALUES
(1,'Marcadores'),
(3,'Naturaleza'),
(8,'Transporte'),
(14,'Lugares'),
(31,'Religioso'),
(38,'Industrial'),
(43,'Varios'),
(45,'Señales'),
(115,'Animados'),
(116,'Autoridades');